FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Date_Stamped" is on date 2021-04-16
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 |
---|---|---|---|---|---|---|---|---|---|
40802 | 40802 | 2021-04-16 | 3634 | Daniel J. Edelman, Inc. 3634 | Informational Materials | United Nations Development Programme on behalf of the Government of Panama | PANAMA | https://efile.fara.gov/docs/3634-Informational-Materials-20210416-34.pdf | |
40803 | 40803 | 2021-04-16 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20210416-121.pdf | |
40804 | 40804 | 2021-04-16 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20210416-122.pdf | |
40805 | 40805 | 2021-04-16 | 6650 | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210416-258.pdf | |
40806 | 40806 | 2021-04-16 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210416-679.pdf | |
40807 | 40807 | 2021-04-16 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210416-680.pdf | |
40808 | 40808 | 2021-04-16 | 6798 | Somaliland Mission USA, LLC 6798 | Informational Materials | Ministry of Foreign Affairs, Republic of Somaliland | SOMALI DEMOCRATIC REPUBLIC | https://efile.fara.gov/docs/6798-Informational-Materials-20210416-4.pdf | |
40809 | 40809 | 2021-04-16 | BCW LLC | BCW LLC 6227 | Informational Materials | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Informational-Materials-20210416-33.pdf | |
40810 | 40810 | 2021-04-16 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Short-Form | McGuire, Brian | https://efile.fara.gov/docs/5870-Short-Form-20210416-174.pdf | ||
40811 | 40811 | 2021-04-16 | 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-20210416-187.pdf | |
40812 | 40812 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Ardis, Joseph | https://efile.fara.gov/docs/6797-Short-Form-20210416-78.pdf | ||
40813 | 40813 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Castillo, Cassandra | https://efile.fara.gov/docs/6797-Short-Form-20210416-74.pdf | ||
40814 | 40814 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Hanley, Katelyn | https://efile.fara.gov/docs/6797-Short-Form-20210416-90.pdf | ||
40815 | 40815 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Hardy, Laura | https://efile.fara.gov/docs/6797-Short-Form-20210416-80.pdf | ||
40816 | 40816 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Kim, Hannah | https://efile.fara.gov/docs/6797-Short-Form-20210416-88.pdf | ||
40817 | 40817 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | McGarry, Kelly | https://efile.fara.gov/docs/6797-Short-Form-20210416-96.pdf | ||
40818 | 40818 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Ngo, Angie | https://efile.fara.gov/docs/6797-Short-Form-20210416-94.pdf | ||
40819 | 40819 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Parada Valencia, Monica A. | https://efile.fara.gov/docs/6797-Short-Form-20210416-84.pdf | ||
40820 | 40820 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Price, Jessica | https://efile.fara.gov/docs/6797-Short-Form-20210416-76.pdf | ||
40821 | 40821 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Ting, Laura | https://efile.fara.gov/docs/6797-Short-Form-20210416-82.pdf | ||
40822 | 40822 | 2021-04-16 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Short-Form | Wang, Andrea | https://efile.fara.gov/docs/6797-Short-Form-20210416-72.pdf | ||
40823 | 40823 | 2021-04-16 | Seven Letter | Seven Letter 6847 | Amendment | https://efile.fara.gov/docs/6847-Amendment-20210416-1.pdf | |||
40824 | 40824 | 2021-04-16 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210416-227.pdf | |
40825 | 40825 | 2021-04-16 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210416-228.pdf | |
40826 | 40826 | 2021-04-16 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210416-229.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]) );