FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where "Date_Stamped" is on date 2021-06-16
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 11
- - 20
- Department of Culture and Tourism - Abu Dhabi 2
- En+ Group International Public Joint-Stock Company 2
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 2
- Qatar Foundation through Memac Ogilvy & Mather LLC 2
- Abu Dhabi National Oil Company 1
- Huawei Technologies USA 1
- OOO NPP Kherson Machine-Building Plant 1
- Presidency of the Republic of Haiti (through Mercury International UK Ltd) 1
- The Gem and Jewellery Export Promotion Council("GJEPC") 1
- Turkish Republic of Northern Cyprus, H.E. Mr. Ersin Tatar 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
65501 | 65501 | 2021-06-16 | O'Brien Gentry & Scott, LLC | O'Brien Gentry & Scott, LLC 5971 | Short-Form | Paul, Shannon | https://efile.fara.gov/docs/5971-Short-Form-20210616-12.pdf | ||
65502 | 65502 | 2021-06-16 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Amendment | https://efile.fara.gov/docs/6582-Amendment-20210616-24.pdf | |||
65503 | 65503 | 2021-06-16 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Exhibit AB | Abu Dhabi National Oil Company | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6582-Exhibit-AB-20210616-13.pdf | |
65504 | 65504 | 2021-06-16 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Short-Form | O'Leary, Lauren | https://efile.fara.gov/docs/6582-Short-Form-20210616-144.pdf | ||
65505 | 65505 | 2021-06-16 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Short-Form | Adler, Jacob Brice | https://efile.fara.gov/docs/6582-Short-Form-20210616-142.pdf | ||
65506 | 65506 | 2021-06-16 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Short-Form | Labuschagne, Nicholas Bruce | https://efile.fara.gov/docs/6582-Short-Form-20210616-140.pdf | ||
65507 | 65507 | 2021-06-16 | Brunswick Group LLC | Brunswick Group LLC 6826 | Informational Materials | Department of Culture and Tourism - Abu Dhabi | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6826-Informational-Materials-20210616-26.pdf | |
65508 | 65508 | 2021-06-16 | Brunswick Group LLC | Brunswick Group LLC 6826 | Informational Materials | Department of Culture and Tourism - Abu Dhabi | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/6826-Informational-Materials-20210616-27.pdf | |
65509 | 65509 | 2021-06-16 | Delahunt Group International LLC | Delahunt Group International LLC 6975 | Exhibit AB | OOO NPP Kherson Machine-Building Plant | UKRAINE | https://efile.fara.gov/docs/6975-Exhibit-AB-20210616-1.pdf | |
65510 | 65510 | 2021-06-16 | Delahunt Group International LLC | Delahunt Group International LLC 6975 | Exhibit C | https://efile.fara.gov/docs/6975-Exhibit-C-20210616-1.pdf | |||
65511 | 65511 | 2021-06-16 | Delahunt Group International LLC | Delahunt Group International LLC 6975 | Registration Statement | https://efile.fara.gov/docs/6975-Registration-Statement-20210616-1.pdf | |||
65512 | 65512 | 2021-06-16 | Delahunt Group International LLC | Delahunt Group International LLC 6975 | Short-Form | Bobrov, Nickolai | https://efile.fara.gov/docs/6975-Short-Form-20210616-2.pdf | ||
65513 | 65513 | 2021-06-16 | Delahunt Group International LLC | Delahunt Group International LLC 6975 | Short-Form | Delahunt, William D. | https://efile.fara.gov/docs/6975-Short-Form-20210616-4.pdf | ||
65514 | 65514 | 2021-06-16 | Fozzie Miller Group, LLC | Fozzie Miller Group, LLC 6936 | Supplemental Statement | https://efile.fara.gov/docs/6936-Supplemental-Statement-20210616-2.pdf | |||
65515 | 65515 | 2021-06-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-20210616-250.pdf | |
65516 | 65516 | 2021-06-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-20210616-302.pdf | |
65517 | 65517 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | The Gem and Jewellery Export Promotion Council("GJEPC") | INDIA | https://efile.fara.gov/docs/3301-Exhibit-AB-20210616-41.pdf | |
65518 | 65518 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Serralheiro-O'Neill, Nathalie Ann | https://efile.fara.gov/docs/3301-Short-Form-20210616-854.pdf | ||
65519 | 65519 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Barchardt, Sarah | https://efile.fara.gov/docs/3301-Short-Form-20210616-856.pdf | ||
65520 | 65520 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Bushell, Jack | https://efile.fara.gov/docs/3301-Short-Form-20210616-858.pdf | ||
65521 | 65521 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Kenny, Tyler | https://efile.fara.gov/docs/3301-Short-Form-20210616-850.pdf | ||
65522 | 65522 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Morgan, Laura | https://efile.fara.gov/docs/3301-Short-Form-20210616-862.pdf | ||
65523 | 65523 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Puebla, Ricardo | https://efile.fara.gov/docs/3301-Short-Form-20210616-852.pdf | ||
65524 | 65524 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Quick, Hannah | https://efile.fara.gov/docs/3301-Short-Form-20210616-848.pdf | ||
65525 | 65525 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Smillie, Colin | https://efile.fara.gov/docs/3301-Short-Form-20210616-860.pdf | ||
65526 | 65526 | 2021-06-16 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Webster, Whitney | https://efile.fara.gov/docs/3301-Short-Form-20210616-864.pdf | ||
65527 | 65527 | 2021-06-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | En+ Group International Public Joint-Stock Company | RUSSIA | https://efile.fara.gov/docs/6170-Informational-Materials-20210616-955.pdf | |
65528 | 65528 | 2021-06-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | En+ Group International Public Joint-Stock Company | RUSSIA | https://efile.fara.gov/docs/6170-Informational-Materials-20210616-956.pdf | |
65529 | 65529 | 2021-06-16 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Presidency of the Republic of Haiti (through Mercury International UK Ltd) | HAITI | https://efile.fara.gov/docs/6170-Informational-Materials-20210616-952.pdf | |
65530 | 65530 | 2021-06-16 | QORVIS LLC | QORVIS LLC 5483 | Amendment | https://efile.fara.gov/docs/5483-Amendment-20210616-89.pdf | |||
65531 | 65531 | 2021-06-16 | RF Binder Partners Inc. | RF Binder Partners Inc. 6814 | Informational Materials | Qatar Foundation through Memac Ogilvy & Mather LLC | QATAR | https://efile.fara.gov/docs/6814-Informational-Materials-20210616-44.pdf | |
65532 | 65532 | 2021-06-16 | RF Binder Partners Inc. | RF Binder Partners Inc. 6814 | Informational Materials | Qatar Foundation through Memac Ogilvy & Mather LLC | QATAR | https://efile.fara.gov/docs/6814-Informational-Materials-20210616-45.pdf | |
65533 | 65533 | 2021-06-16 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210616-283.pdf | |
65534 | 65534 | 2021-06-16 | Representative of the Turkish Republic of Northern Cyprus | Representative of the Turkish Republic of Northern Cyprus 2619 | Informational Materials | Turkish Republic of Northern Cyprus, H.E. Mr. Ersin Tatar | CYPRUS | https://efile.fara.gov/docs/2619-Informational-Materials-20210616-122.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]) );