FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Date_Stamped" is on date 2019-11-05
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
117726 | 117726 | 2019-11-05 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-60.pdf | |
117727 | 117727 | 2019-11-05 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) | ZIMBABWE | https://efile.fara.gov/docs/6170-Informational-Materials-20191105-532.pdf | |
117728 | 117728 | 2019-11-05 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) | ZIMBABWE | https://efile.fara.gov/docs/6170-Informational-Materials-20191105-643.pdf | |
117729 | 117729 | 2019-11-05 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20191105-897.pdf | |
117730 | 117730 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Kingdom of Bahrain to the United States of America | BAHRAIN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-18.pdf | |
117731 | 117731 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Kingdom of Bahrain to the United States of America | BAHRAIN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-26.pdf | |
117732 | 117732 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-17.pdf | |
117733 | 117733 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-19.pdf | |
117734 | 117734 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-20.pdf | |
117735 | 117735 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-21.pdf | |
117736 | 117736 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20191105-28.pdf | |
117737 | 117737 | 2019-11-05 | BGR Government Affairs, LLC | BGR Government Affairs, LLC 5430 | Short-Form | Simeone, Chris | https://efile.fara.gov/docs/5430-Short-Form-20191105-304.pdf | ||
117738 | 117738 | 2019-11-05 | CHP Representation to the United States, LLC | CHP Representation to the United States, LLC 6168 | Informational Materials | Republican People's Party of Turkey (CHP) | TURKEY | https://efile.fara.gov/docs/6168-Informational-Materials-20191105-11.pdf | |
117739 | 117739 | 2019-11-05 | Gallagher Group, LLC | Gallagher Group, LLC 6277 | Supplemental Statement | https://efile.fara.gov/docs/6277-Supplemental-Statement-20191105-10.pdf | |||
117740 | 117740 | 2019-11-05 | Livingston Group, LLC | Livingston Group, LLC 6344 | Amendment | https://efile.fara.gov/docs/6344-Amendment-20191105-28.pdf | |||
117741 | 117741 | 2019-11-05 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Accord Libya, Office of the Prime Minister | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20191105-208.pdf | |
117742 | 117742 | 2019-11-05 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Ministry of Foreign Affairs and International Trade of Zimbabwe (through Mercury International UK Ltd.) (MFA) | ZIMBABWE | https://efile.fara.gov/docs/6170-Informational-Materials-20191105-216.pdf | |
117743 | 117743 | 2019-11-05 | Rokk Solutions, LLC | Rokk Solutions, LLC 6320 | Amendment | https://efile.fara.gov/docs/6320-Amendment-20191105-6.pdf | |||
117744 | 117744 | 2019-11-05 | Rokk Solutions, LLC | Rokk Solutions, LLC 6320 | Amendment | https://efile.fara.gov/docs/6320-Amendment-20201105-7.pdf | |||
117745 | 117745 | 2019-11-05 | Rokk Solutions, LLC | Rokk Solutions, LLC 6320 | Supplemental Statement | https://efile.fara.gov/docs/6320-Supplemental-Statement-20191105-15.pdf | |||
117746 | 117746 | 2019-11-05 | Rokk Solutions, LLC | Rokk Solutions, LLC 6320 | Supplemental Statement | https://efile.fara.gov/docs/6320-Supplemental-Statement-20191105-16.pdf | |||
117747 | 117747 | 2019-11-05 | Waxman Consulting, Inc. DBA Waxman Strategies | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20191105-36.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]) );