FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Date_Stamped" is on date 2007-10-15
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 2
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
108931 | 108931 | 2007-10-15 | APCO Worldwide, Inc. | APCO Worldwide, Inc. 4561 | Amendment | https://efile.fara.gov/docs/4561-Amendment-20071015-7.pdf | |||
108932 | 108932 | 2007-10-15 | APCO Worldwide, Inc. | APCO Worldwide, Inc. 4561 | Exhibit AB | Embassy of the Republic of Kazakhstan | KAZAKHSTAN | https://efile.fara.gov/docs/4561-Exhibit-AB-20071015-3.pdf | |
108933 | 108933 | 2007-10-15 | Greenberg Traurig, LLP | Greenberg Traurig, LLP 5712 | Short-Form | Siebert, Thomas L. | Available-FARA-Public-Office | ||
108934 | 108934 | 2007-10-15 | IDA Ireland | IDA Ireland 1770 | Short-Form | Buckley, Mary | Available-FARA-Public-Office | ||
108935 | 108935 | 2007-10-15 | IDA Ireland | IDA Ireland 1770 | Short-Form | McEvoy, Thomas P. | Available-FARA-Public-Office | ||
108936 | 108936 | 2007-10-15 | IDA Ireland | IDA Ireland 1770 | Short-Form | Nugent, John | Available-FARA-Public-Office | ||
108937 | 108937 | 2007-10-15 | IDA Ireland | IDA Ireland 1770 | Short-Form | Thurston, Katherine M. | Available-FARA-Public-Office | ||
108938 | 108938 | 2007-10-15 | IDA Ireland | IDA Ireland 1770 | Supplemental Statement | https://efile.fara.gov/docs/1770-Supplemental-Statement-20071015-6.pdf | |||
108939 | 108939 | 2007-10-15 | JETRO, New York | JETRO, New York 1643 | Short-Form | Austin, Doreen | Available-FARA-Public-Office | ||
108940 | 108940 | 2007-10-15 | JETRO, New York | JETRO, New York 1643 | Short-Form | Watanabe, Tomoko | Available-FARA-Public-Office | ||
108941 | 108941 | 2007-10-15 | JETRO, New York | JETRO, New York 1643 | Short-Form | Yamade, Koji | Available-FARA-Public-Office | ||
108942 | 108942 | 2007-10-15 | Korea National Tourism Organization, New Jersey | Korea National Tourism Organization, New Jersey 2614 | Supplemental Statement | https://efile.fara.gov/docs/2614-Supplemental-Statement-20071015-6.pdf | |||
108943 | 108943 | 2007-10-15 | Qorvis Communications, LLC | QORVIS LLC 5483 | Short-Form | Battaglia, Basil | Available-FARA-Public-Office | ||
108944 | 108944 | 2007-10-15 | Quebec Government House | Quebec Government Office 1787 | Short-Form | Boucher, Marc | Available-FARA-Public-Office | ||
108945 | 108945 | 2007-10-15 | Quebec Government House | Quebec Government Office 1787 | Short-Form | Fallecker, Stephane | Available-FARA-Public-Office | ||
108946 | 108946 | 2007-10-15 | Quebec Government House | Quebec Government Office 1787 | Short-Form | Laflamme, Jean-Pierre | Available-FARA-Public-Office | ||
108947 | 108947 | 2007-10-15 | Sidley Austin, LLP | Sidley Austin LLP 3731 | Short-Form | Clark, Alice Slayton | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
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]) );