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 2020-03-24
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 |
---|---|---|---|---|---|---|---|---|---|
30511 | 30511 | 2020-03-24 | 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-20200324-17.pdf | |
30512 | 30512 | 2020-03-24 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20200324-28.pdf | |
30513 | 30513 | 2020-03-24 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200324-166.pdf | |
30514 | 30514 | 2020-03-24 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200324-167.pdf | |
30515 | 30515 | 2020-03-24 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200324-168.pdf | |
30516 | 30516 | 2020-03-24 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200324-169.pdf | |
30517 | 30517 | 2020-03-24 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | People's Progressive Party (Guyana) | GUYANA | https://efile.fara.gov/docs/6170-Informational-Materials-20200324-342.pdf | |
30518 | 30518 | 2020-03-24 | 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-20200324-341.pdf | |
30519 | 30519 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Exhibit AB | Embassy of the United Arab Emirates | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6806-Exhibit-AB-20200324-1.pdf | |
30520 | 30520 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Exhibit C | https://efile.fara.gov/docs/6806-Exhibit-C-20200324-1.pdf | |||
30521 | 30521 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Registration Statement | https://efile.fara.gov/docs/6806-Registration-Statement-20200324-1.pdf | |||
30522 | 30522 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Alise, Gabriela | https://efile.fara.gov/docs/6806-Short-Form-20200324-20.pdf | ||
30523 | 30523 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Cummings, MacLaren | https://efile.fara.gov/docs/6806-Short-Form-20200324-2.pdf | ||
30524 | 30524 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Danial, Patrick | https://efile.fara.gov/docs/6806-Short-Form-20200324-12.pdf | ||
30525 | 30525 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Harrison, Anneliese | https://efile.fara.gov/docs/6806-Short-Form-20200324-14.pdf | ||
30526 | 30526 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Hurlburt, Ryan | https://efile.fara.gov/docs/6806-Short-Form-20200324-10.pdf | ||
30527 | 30527 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Kimball, Antoinette | https://efile.fara.gov/docs/6806-Short-Form-20200324-4.pdf | ||
30528 | 30528 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | MacBlane, Brianna | https://efile.fara.gov/docs/6806-Short-Form-20200324-16.pdf | ||
30529 | 30529 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Reedy, Shannon | https://efile.fara.gov/docs/6806-Short-Form-20200324-6.pdf | ||
30530 | 30530 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Schiefer, Kenneth | https://efile.fara.gov/docs/6806-Short-Form-20200324-18.pdf | ||
30531 | 30531 | 2020-03-24 | Terakeet LLC | Terakeet LLC 6806 | Short-Form | Weyant, Curtis | https://efile.fara.gov/docs/6806-Short-Form-20200324-8.pdf | ||
30532 | 30532 | 2020-03-24 | 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-20200324-189.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]) );