FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Date_Stamped" is on date 2019-11-12 and Document_Type = "Informational Materials"
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 |
---|---|---|---|---|---|---|---|---|---|
119021 | 119021 | 2019-11-12 | Akin, Gump, Strauss, Hauer & Feld, LLP | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Informational Materials | Embassy of the United Arab Emirates | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/3492-Informational-Materials-20191112-48.pdf | |
119022 | 119022 | 2019-11-12 | Akin, Gump, Strauss, Hauer & Feld, LLP | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Informational Materials | Government of the Republic of the Marshall Islands | MARSHALL ISLANDS | https://efile.fara.gov/docs/3492-Informational-Materials-20191112-38.pdf | |
119024 | 119024 | 2019-11-12 | Brownstein Hyatt Farber Schreck, LLP | Brownstein Hyatt Farber Schreck, LLP 5870 | Informational Materials | Royal Government of the Kingdom of Cambodia | CAMBODIA | https://efile.fara.gov/docs/5870-Informational-Materials-20191112-31.pdf | |
119025 | 119025 | 2019-11-12 | Friends of Sinn Fein, Inc. | Friends of Sinn Fein, Inc. 5006 | Informational Materials | Sinn Fein | IRELAND | https://efile.fara.gov/docs/5006-Informational-Materials-20191112-16.pdf | |
119036 | 119036 | 2019-11-12 | MSLGROUP Americas, LLC | QORVIS LLC 5483 | Informational Materials | Kingdom of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/5483-Informational-Materials-20191112-77.pdf | |
119037 | 119037 | 2019-11-12 | MSLGROUP Americas, LLC | QORVIS LLC 5483 | Informational Materials | Muslim World League | SAUDI ARABIA | https://efile.fara.gov/docs/5483-Informational-Materials-20191112-76.pdf | |
119038 | 119038 | 2019-11-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Accord Libya, Office of the Prime Minister | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20191112-220.pdf | |
119039 | 119039 | 2019-11-12 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Accord Libya, Office of the Prime Minister | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20191112-221.pdf | |
119040 | 119040 | 2019-11-12 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20191112-72.pdf | |
119041 | 119041 | 2019-11-12 | 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. Mustafa Akinci | CYPRUS | https://efile.fara.gov/docs/2619-Informational-Materials-20191112-55.pdf | |
119043 | 119043 | 2019-11-12 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | PJSC AGRARIAN FUND | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20191112-49.pdf | |
119044 | 119044 | 2019-11-12 | Yorktown Solutions, LLC | Yorktown Solutions, LLC 6491 | Informational Materials | Public Joint-Stock Company National Joint-Stock Company (Naftogaz of Ukraine) | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20191112-50.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]) );