FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Date_Stamped" is on date 2021-09-29 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 8
- Department of Culture and Tourism - Abu Dhabi 2
- Malaysian Rubber Export Promotion Council 2
- Bahaa Hariri thru CT Solutions & Private Advisory Ltd. 1
- China-United States Exchange Foundation 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Government of National Unity of Libya (through Mercury International UK Ltd.) 1
- Government of the Republic of Honduras 1
- Palestinian Authority 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
101541 | 101541 | 2021-09-29 | Broydrick and Associates, Inc. | Broydrick and Associates, Inc. 6796 | Informational Materials | Malaysian Rubber Export Promotion Council | MALAYSIA | https://efile.fara.gov/docs/6796-Informational-Materials-20210929-10.pdf | |
101542 | 101542 | 2021-09-29 | Broydrick and Associates, Inc. | Broydrick and Associates, Inc. 6796 | Informational Materials | Malaysian Rubber Export Promotion Council | MALAYSIA | https://efile.fara.gov/docs/6796-Informational-Materials-20210929-9.pdf | |
101546 | 101546 | 2021-09-29 | Brunswick Group LLC | Brunswick Group LLC 6826 | Informational Materials | Department of Culture and Tourism - Abu Dhabi | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6826-Informational-Materials-20210929-32.pdf | |
101547 | 101547 | 2021-09-29 | Brunswick Group LLC | Brunswick Group LLC 6826 | Informational Materials | Department of Culture and Tourism - Abu Dhabi | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6826-Informational-Materials-20210929-33.pdf | |
101548 | 101548 | 2021-09-29 | CTF Global LLC | CTF Global LLC 7008 | Informational Materials | Bahaa Hariri thru CT Solutions & Private Advisory Ltd. | LEBANON | https://efile.fara.gov/docs/7008-Informational-Materials-20210929-1.pdf | |
101551 | 101551 | 2021-09-29 | Ghebi LLC | Ghebi LLC 6869 | Informational Materials | Federal State Unitary Enterprise Rossiya Segodnya International Information Agency | RUSSIA | https://efile.fara.gov/docs/6869-Informational-Materials-20210929-342.pdf | |
101552 | 101552 | 2021-09-29 | Gus West Government Affairs, Inc. | Gus West Government Affairs, Inc. 6364 | Informational Materials | Government of the Republic of Honduras | HONDURAS | https://efile.fara.gov/docs/6364-Informational-Materials-20210929-37.pdf | |
101556 | 101556 | 2021-09-29 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Unity of Libya (through Mercury International UK Ltd.) | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20210929-1026.pdf | |
101569 | 101569 | 2021-09-29 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Palestinian Authority | PALESTINE | https://efile.fara.gov/docs/2165-Informational-Materials-20210929-142.pdf | |
101570 | 101570 | 2021-09-29 | Wilson Global Communications, LLC | Wilson Global Communications, LLC 6584 | Informational Materials | China-United States Exchange Foundation | CHINA | https://efile.fara.gov/docs/6584-Informational-Materials-20210929-43.pdf |
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]) );