FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
38 rows where "Date_Stamped" is on date 2021-04-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name 10
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
37052 | 37052 | 2021-04-01 | 2244 | Hogan Lovells US LLP 2244 | Informational Materials | Royal Embassy of Saudi Arabia, Washington, D.C. | SAUDI ARABIA | https://efile.fara.gov/docs/2244-Informational-Materials-20210401-41.pdf | |
37053 | 37053 | 2021-04-01 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20210401-118.pdf | |
37054 | 37054 | 2021-04-01 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Embassy of the Republic of Azerbaijan | AZERBAIJAN | https://efile.fara.gov/docs/5430-Informational-Materials-20210401-119.pdf | |
37055 | 37055 | 2021-04-01 | 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-20210401-907.pdf | |
37056 | 37056 | 2021-04-01 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20210401-908.pdf | |
37057 | 37057 | 2021-04-01 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210401-669.pdf | |
37058 | 37058 | 2021-04-01 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210401-670.pdf | |
37059 | 37059 | 2021-04-01 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210401-671.pdf | |
37060 | 37060 | 2021-04-01 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210401-672.pdf | |
37061 | 37061 | 2021-04-01 | 6943 | Republica Havas, LLC 6943 | Informational Materials | Jamaica Tourist Board | JAMAICA | https://efile.fara.gov/docs/6943-Informational-Materials-20210401-1.pdf | |
37062 | 37062 | 2021-04-01 | Castillo, Edward O. | Castillo, Edward O. 6643 | Supplemental Statement | https://efile.fara.gov/docs/6643-Supplemental-Statement-20210401-1.pdf | |||
37063 | 37063 | 2021-04-01 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20210401-479.pdf | |
37064 | 37064 | 2021-04-01 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20210401-480.pdf | |
37065 | 37065 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Exhibit AB | Jamaica Tourist Board | JAMAICA | https://efile.fara.gov/docs/6943-Exhibit-AB-20210401-1.pdf | |
37066 | 37066 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Exhibit C | https://efile.fara.gov/docs/6943-Exhibit-C-20210401-1.pdf | |||
37067 | 37067 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Registration Statement | https://efile.fara.gov/docs/6943-Registration-Statement-20210401-1.pdf | |||
37068 | 37068 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Short-Form | Beazel, Marisa | https://efile.fara.gov/docs/6943-Short-Form-20210401-4.pdf | ||
37069 | 37069 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Short-Form | Blanco, Desiree | https://efile.fara.gov/docs/6943-Short-Form-20210401-6.pdf | ||
37070 | 37070 | 2021-04-01 | Republica Havas, LLC | Republica Havas, LLC 6943 | Short-Form | Sanchez, Giovanna | https://efile.fara.gov/docs/6943-Short-Form-20210401-2.pdf | ||
37071 | 37071 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Exhibit AB | Embassy of the State of Qatar | QATAR | https://efile.fara.gov/docs/6944-Exhibit-AB-20210401-1.pdf | |
37072 | 37072 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Exhibit C | https://efile.fara.gov/docs/6944-Exhibit-C-20210401-1.pdf | |||
37073 | 37073 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Registration Statement | https://efile.fara.gov/docs/6944-Registration-Statement-20210401-1.pdf | |||
37074 | 37074 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Carmona, Jacqueline | https://efile.fara.gov/docs/6944-Short-Form-20210401-10.pdf | ||
37075 | 37075 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Chanti, Erica | https://efile.fara.gov/docs/6944-Short-Form-20210401-6.pdf | ||
37076 | 37076 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Davidson, Jodi Bock | https://efile.fara.gov/docs/6944-Short-Form-20210401-8.pdf | ||
37077 | 37077 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Rubin, William | https://efile.fara.gov/docs/6944-Short-Form-20210401-2.pdf | ||
37078 | 37078 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Turnbull, Heather | https://efile.fara.gov/docs/6944-Short-Form-20210401-4.pdf | ||
37079 | 37079 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Short-Form | Ulvert, Christian | https://efile.fara.gov/docs/6944-Short-Form-20210401-12.pdf | ||
37080 | 37080 | 2021-04-01 | 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-20210401-212.pdf | |
37081 | 37081 | 2021-04-01 | 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-20210401-213.pdf | |
37082 | 37082 | 2021-04-01 | 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-20210401-214.pdf | |
37083 | 37083 | 2021-04-01 | 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-20210401-216.pdf | |
37084 | 37084 | 2021-04-01 | 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-20210401-217.pdf | |
37085 | 37085 | 2021-04-01 | 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-20210401-218.pdf | |
37086 | 37086 | 2021-04-01 | 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-20210401-219.pdf | |
37087 | 37087 | 2021-04-01 | 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-20210401-220.pdf | |
37088 | 37088 | 2021-04-01 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | Chamber of Commerce and Industry of Serbia | SERBIA | https://efile.fara.gov/docs/6491-Informational-Materials-20210401-221.pdf | |
37089 | 37089 | 2021-04-01 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | Chamber of Commerce and Industry of Serbia | SERBIA | https://efile.fara.gov/docs/6491-Informational-Materials-20210401-222.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]) );