FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Date_Stamped" is on date 2021-11-03 sorted by Short_Form_Name
This data as json, CSV (advanced)
These facets timed out: Document_Type, Date_Stamped
Foreign_Principal_Name 17
- - 16
- All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" 6
- Bahrain Economic Development Board 2
- Kateryna Odarchenko 2
- Neom Company 2
- ALOR 1
- Chamber of Commerce and Industry of Serbia 1
- DIHK DEinternational GmbH 1
- Department of Culture and Tourism - Abu Dhabi 1
- Embassy of the Republic of Korea 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- JinkoSolar (U.S.) Inc. 1
- Korea Institute for International Economic Policy (KIEP) 1
- Liberia Maritime Authority 1
- Okinawa Prefecture 1
- Saudi Arabian Oil Company (Saudi Aramco) 1
- United Nations Development Programme on behalf of the Government of Panama 1
Registrant_Name 16
- Zeppelin Communications 8
- Yorktown Solutions, LLC 7
- Daniel J. Edelman, Inc. 6
- Mercury Public Affairs, LLC 4
- Hill and Knowlton Strategies, LLC 3
- Brownstein Hyatt Farber Schreck, LLP 2
- APCO Worldwide LLC 1
- Aramco Affiliated Services Company (AASC) 1
- Brunswick Group LLC 1
- Delegation of German Industry and Commerce in Washington DC, LLC 1
- Foley Hoag, LLP 1
- Ghebi LLC 1
- Korea Economic Institute 1
- Ogilvy Group LLC 1
- Olafson, Curtis 1
- Squire Patton Boggs, LLP 1
Foreign_Principal_Country 15
- - 16
- UKRAINE 8
- BAHRAIN 2
- INTERNATIONAL 2
- KOREA SOUTH 2
- CHINA 1
- GERMANY 1
- ICELAND 1
- JAPAN 1
- LIBERIA 1
- PANAMA 1
- RUSSIA 1
- SAUDI ARABIA 1
- SERBIA 1
- UNITED ARAB EMIRATES 1
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name ▼ | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
117332 | 117332 | 2021-11-03 | APCO Worldwide LLC | APCO Worldwide LLC 6582 | Amendment | https://efile.fara.gov/docs/6582-Amendment-20211103-35.pdf | |||
117333 | 117333 | 2021-11-03 | Aramco Affiliated Services Company (AASC) | Aramco Affiliated Services Company (AASC) 6390 | Informational Materials | Saudi Arabian Oil Company (Saudi Aramco) | SAUDI ARABIA | https://efile.fara.gov/docs/6390-Informational-Materials-20211103-9.pdf | |
117334 | 117334 | 2021-11-03 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Amendment | https://efile.fara.gov/docs/5870-Amendment-20211103-27.pdf | |||
117335 | 117335 | 2021-11-03 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Exhibit AB | Liberia Maritime Authority | LIBERIA | https://efile.fara.gov/docs/5870-Exhibit-AB-20211103-26.pdf | |
117336 | 117336 | 2021-11-03 | 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-20211103-35.pdf | |
117337 | 117337 | 2021-11-03 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Exhibit AB | Bahrain Economic Development Board | BAHRAIN | https://efile.fara.gov/docs/3634-Exhibit-AB-20211103-94.pdf | |
117338 | 117338 | 2021-11-03 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Informational Materials | Bahrain Economic Development Board | BAHRAIN | https://efile.fara.gov/docs/3634-Informational-Materials-20211103-56.pdf | |
117339 | 117339 | 2021-11-03 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Informational Materials | Neom Company | INTERNATIONAL | https://efile.fara.gov/docs/3634-Informational-Materials-20211103-51.pdf | |
117340 | 117340 | 2021-11-03 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Informational Materials | Neom Company | INTERNATIONAL | https://efile.fara.gov/docs/3634-Informational-Materials-20211103-52.pdf | |
117341 | 117341 | 2021-11-03 | Daniel J. Edelman, Inc. | 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-20211103-50.pdf | |
117343 | 117343 | 2021-11-03 | Delegation of German Industry and Commerce in Washington DC, LLC | Delegation of German Industry and Commerce in Washington DC, LLC 7002 | Informational Materials | DIHK DEinternational GmbH | GERMANY | https://efile.fara.gov/docs/7002-Informational-Materials-20211103-24.pdf | |
117344 | 117344 | 2021-11-03 | Foley Hoag, LLP | Foley Hoag, LLP 4776 | Supplemental Statement | https://efile.fara.gov/docs/4776-Supplemental-Statement-20211103-34.pdf | |||
117345 | 117345 | 2021-11-03 | 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-20211103-371.pdf | |
117349 | 117349 | 2021-11-03 | Korea Economic Institute | Korea Economic Institute 3327 | Informational Materials | Korea Institute for International Economic Policy (KIEP) | KOREA SOUTH | https://efile.fara.gov/docs/3327-Informational-Materials-20211103-317.pdf | |
117350 | 117350 | 2021-11-03 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20211103-121.pdf | |||
117351 | 117351 | 2021-11-03 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Amendment | https://efile.fara.gov/docs/6170-Amendment-20211103-122.pdf | |||
117352 | 117352 | 2021-11-03 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Exhibit AB | JinkoSolar (U.S.) Inc. | CHINA | https://efile.fara.gov/docs/6170-Exhibit-AB-20211103-103.pdf | |
117353 | 117353 | 2021-11-03 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Exhibit AB | Okinawa Prefecture | JAPAN | https://efile.fara.gov/docs/6170-Exhibit-AB-20211103-104.pdf | |
117354 | 117354 | 2021-11-03 | Ogilvy Group LLC | Ogilvy Group LLC 6797 | Supplemental Statement | https://efile.fara.gov/docs/6797-Supplemental-Statement-20211103-3.pdf | |||
117355 | 117355 | 2021-11-03 | Olafson, Curtis | Olafson, Curtis 7014 | Informational Materials | ALOR | ICELAND | https://efile.fara.gov/docs/7014-Informational-Materials-20211103-9.pdf | |
117356 | 117356 | 2021-11-03 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Embassy of the Republic of Korea | KOREA SOUTH | https://efile.fara.gov/docs/2165-Informational-Materials-20211103-151.pdf | |
117357 | 117357 | 2021-11-03 | 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-20211103-495.pdf | |
117358 | 117358 | 2021-11-03 | 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-20211103-496.pdf | |
117359 | 117359 | 2021-11-03 | 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-20211103-497.pdf | |
117360 | 117360 | 2021-11-03 | 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-20211103-498.pdf | |
117361 | 117361 | 2021-11-03 | 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-20211103-499.pdf | |
117362 | 117362 | 2021-11-03 | 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-20211103-500.pdf | |
117363 | 117363 | 2021-11-03 | 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-20211103-494.pdf | |
117364 | 117364 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Amendment | https://efile.fara.gov/docs/6709-Amendment-20211103-4.pdf | |||
117365 | 117365 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Amendment | https://efile.fara.gov/docs/6709-Amendment-20211103-5.pdf | |||
117366 | 117366 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Amendment | https://efile.fara.gov/docs/6709-Amendment-20211103-6.pdf | |||
117367 | 117367 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Informational Materials | Kateryna Odarchenko | UKRAINE | https://efile.fara.gov/docs/6709-Informational-Materials-20211103-1.pdf | |
117368 | 117368 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Informational Materials | Kateryna Odarchenko | UKRAINE | https://efile.fara.gov/docs/6709-Informational-Materials-20211103-2.pdf | |
117369 | 117369 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Supplemental Statement | https://efile.fara.gov/docs/6709-Supplemental-Statement-20211103-2.pdf | |||
117370 | 117370 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Supplemental Statement | https://efile.fara.gov/docs/6709-Supplemental-Statement-20211103-3.pdf | |||
117371 | 117371 | 2021-11-03 | Zeppelin Communications | Zeppelin Communications 6709 | Supplemental Statement | https://efile.fara.gov/docs/6709-Supplemental-Statement-20211103-4.pdf | |||
117346 | 117346 | 2021-11-03 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Cox, Carolyn | https://efile.fara.gov/docs/3301-Short-Form-20211103-902.pdf | ||
117347 | 117347 | 2021-11-03 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Grady, Michael George | https://efile.fara.gov/docs/3301-Short-Form-20211103-896.pdf | ||
117342 | 117342 | 2021-11-03 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | Hailes, Simon | https://efile.fara.gov/docs/3634-Short-Form-20211103-1039.pdf | ||
117348 | 117348 | 2021-11-03 | Hill and Knowlton Strategies, LLC | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Smillie, Colin | https://efile.fara.gov/docs/3301-Short-Form-20211103-904.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]) );