FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

9 rows where Foreign_Principal_Country = "PHILIPPINES", Foreign_Principal_Name = "PHILIPPINE SUGAR ADMINISTRATION" and Registrant_Name = "L.A. MOTLEY & COMPANY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Registrant_Name 1

  • L.A. MOTLEY & COMPANY · 9 ✖

Foreign_Principal_Name 1

  • PHILIPPINE SUGAR ADMINISTRATION · 9 ✖

Foreign_Principal_Country 1

  • PHILIPPINES · 9 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
9658 9658 1997-01-31 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19970131-E5YXCS06.pdf
12693 12693 1992-02-01 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19920201-D12OSY01.pdf
13038 13038 1993-02-01 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19930201-D14AV001.pdf
13235 13235 1994-02-01 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19940201-D14ACM01.pdf
16938 16938 1999-02-17 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19990217-F7EPQA02.pdf
25862 25862 1995-03-07 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19950307-DNTCSG02.pdf
27978 27978 1989-03-15 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19890315-D14L4601.pdf
28357 28357 1990-03-16 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19900316-D14KL901.pdf
49958 49958 1998-05-07 L.A. MOTLEY & COMPANY L.A. Motley & Company 3723 Exhibit AB   PHILIPPINE SUGAR ADMINISTRATION PHILIPPINES https://efile.fara.gov/docs/3723-Exhibit-AB-19980507-EUEAPV04.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_RegistrantDocs] (
   [Date_Stamped] TEXT,
   [Registrant_Name] TEXT,
   [Registration_Number] INTEGER,
   [Document_Type] TEXT,
   [Short_Form_Name] TEXT,
   [Foreign_Principal_Name] TEXT,
   [Foreign_Principal_Country] TEXT,
   [URL] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);