FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Date_Stamped" is on date 2021-10-12
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 |
---|---|---|---|---|---|---|---|---|---|
108380 | 108380 | 2021-10-12 | BCW LLC | BCW LLC 6227 | Amendment | https://efile.fara.gov/docs/6227-Amendment-20211012-13.pdf | |||
108381 | 108381 | 2021-10-12 | BCW LLC | BCW LLC 6227 | Exhibit AB | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Exhibit-AB-20211012-29.pdf | |
108382 | 108382 | 2021-10-12 | CTF Global LLC | CTF Global LLC 7008 | Informational Materials | Bahaa Hariri thru CT Solutions & Private Advisory Ltd. | LEBANON | https://efile.fara.gov/docs/7008-Informational-Materials-20211012-4.pdf | |
108383 | 108383 | 2021-10-12 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | Sullivan Jr., Jere J. | https://efile.fara.gov/docs/3634-Short-Form-20211012-1029.pdf | ||
108384 | 108384 | 2021-10-12 | Forbes Tate Partners LLC | Forbes Tate Partners LLC 6522 | Informational Materials | H.Q. Energy Services (U.S.) Inc. | CANADA | https://efile.fara.gov/docs/6522-Informational-Materials-20211012-36.pdf | |
108385 | 108385 | 2021-10-12 | Forbes Tate Partners LLC | Forbes Tate Partners LLC 6522 | Informational Materials | H.Q. Energy Services (U.S.) Inc. | CANADA | https://efile.fara.gov/docs/6522-Informational-Materials-20211012-37.pdf | |
108386 | 108386 | 2021-10-12 | 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-20211012-352.pdf | |
108387 | 108387 | 2021-10-12 | Hai Tian Development U.S.A., Inc. | Hai Tian Development U.S.A., Inc. 5143 | Informational Materials | People's Daily Overseas Edition | CHINA | https://efile.fara.gov/docs/5143-Informational-Materials-20211012-48.pdf | |
108388 | 108388 | 2021-10-12 | Hausfeld, LLP | Hausfeld LLP 6724 | Informational Materials | Environmental Youth Activists | INTERNATIONAL | https://efile.fara.gov/docs/6724-Informational-Materials-20211012-9.pdf | |
108389 | 108389 | 2021-10-12 | India Tourism, New York | India Tourism, New York 2329 | Supplemental Statement | https://efile.fara.gov/docs/2329-Supplemental-Statement-20211012-38.pdf | |||
108390 | 108390 | 2021-10-12 | JETRO, New York | JETRO, New York 1643 | Short-Form | Tsukamoto, Kazunari | https://efile.fara.gov/docs/1643-Short-Form-20211012-388.pdf | ||
108391 | 108391 | 2021-10-12 | Jake Perry + Partners LLC | Jake Perry + Partners LLC 6886 | Supplemental Statement | https://efile.fara.gov/docs/6886-Supplemental-Statement-20211012-2.pdf | |||
108392 | 108392 | 2021-10-12 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20211012-100.pdf | |
108393 | 108393 | 2021-10-12 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20211012-99.pdf | |
108394 | 108394 | 2021-10-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of Ethiopia (through Mercury International UK Ltd.) | ETHIOPIA | https://efile.fara.gov/docs/6170-Informational-Materials-20211012-1054.pdf | |
108395 | 108395 | 2021-10-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Ministry of Justice, Republic of Kazakhstan through Latham & Watkins LLP | KAZAKHSTAN | https://efile.fara.gov/docs/6170-Informational-Materials-20211012-1055.pdf | |
108396 | 108396 | 2021-10-12 | Sing Tao US | Sing Tao US 6999 | Informational Materials | Sing Tao News Corporation Ltd. | HONG KONG | https://efile.fara.gov/docs/6999-Informational-Materials-20211012-7.pdf | |
108397 | 108397 | 2021-10-12 | 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-20211012-452.pdf | |
108398 | 108398 | 2021-10-12 | 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-20211012-453.pdf | |
108399 | 108399 | 2021-10-12 | 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-20211012-454.pdf | |
108400 | 108400 | 2021-10-12 | 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-20211012-455.pdf | |
108401 | 108401 | 2021-10-12 | 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-20211012-456.pdf | |
108402 | 108402 | 2021-10-12 | 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-20211012-457.pdf | |
108403 | 108403 | 2021-10-12 | 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-20211012-458.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]) );