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-12-13 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country, Date_Stamped
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
130728 | 130728 | 2019-12-13 | 6168 | 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-20191213-32.pdf | |
130729 | 130729 | 2019-12-13 | 6168 | 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-20191213-34.pdf | |
130730 | 130730 | 2019-12-13 | 6170 | 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-20191213-592.pdf | |
130731 | 130731 | 2019-12-13 | 6170 | 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-20191213-593.pdf | |
130732 | 130732 | 2019-12-13 | 6170 | 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-20191213-594.pdf | |
130733 | 130733 | 2019-12-13 | 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-20191213-591.pdf | |
130734 | 130734 | 2019-12-13 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20191213-588.pdf | |
130735 | 130735 | 2019-12-13 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20191213-589.pdf | |
130736 | 130736 | 2019-12-13 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20191213-590.pdf | |
130737 | 130737 | 2019-12-13 | 6650 | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20191213-111.pdf | |
130738 | 130738 | 2019-12-13 | 6650 | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20191213-125.pdf | |
130739 | 130739 | 2019-12-13 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191213-329.pdf | |
130740 | 130740 | 2019-12-13 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191213-330.pdf | |
130741 | 130741 | 2019-12-13 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191213-331.pdf | |
130742 | 130742 | 2019-12-13 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191213-332.pdf | |
130743 | 130743 | 2019-12-13 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20191213-333.pdf | |
130747 | 130747 | 2019-12-13 | CMGRP, Inc., d/b/a Rogers & Cowan | CMGRP, Inc., d/b/a Rogers & Cowan 6769 | Informational Materials | Consulum FZ LLC | SAUDI ARABIA | https://efile.fara.gov/docs/6769-Informational-Materials-20191213-1.pdf | |
130748 | 130748 | 2019-12-13 | CMGRP, Inc., d/b/a Rogers & Cowan | CMGRP, Inc., d/b/a Rogers & Cowan 6769 | Informational Materials | Consulum FZ LLC | SAUDI ARABIA | https://efile.fara.gov/docs/6769-Informational-Materials-20191213-6.pdf | |
130749 | 130749 | 2019-12-13 | CMGRP, Inc., d/b/a Rogers & Cowan | CMGRP, Inc., d/b/a Rogers & Cowan 6769 | Informational Materials | Polska Fundacja Narodowa | POLAND | https://efile.fara.gov/docs/6769-Informational-Materials-20191213-2.pdf | |
130750 | 130750 | 2019-12-13 | CMGRP, Inc., d/b/a Rogers & Cowan | CMGRP, Inc., d/b/a Rogers & Cowan 6769 | Informational Materials | Polska Fundacja Narodowa | POLAND | https://efile.fara.gov/docs/6769-Informational-Materials-20191213-5.pdf | |
130763 | 130763 | 2019-12-13 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | BIAFRA | https://efile.fara.gov/docs/6170-Informational-Materials-20191213-232.pdf | |
130765 | 130765 | 2019-12-13 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20191213-88.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]) );