FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Date_Stamped" is on date 2021-06-18 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Country
Registrant_Name 7
Foreign_Principal_Name 7
- Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP 3
- Embassy of the Kingdom of Saudi Arabia 1
- En+ Group International Public Joint-Stock Company 1
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 1
- Huawei Technologies USA 1
- Korea Institute for International Economic Policy (KIEP) 1
- Republika Srpska 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
65973 | 65973 | 2021-06-18 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210618-103.pdf | |
65974 | 65974 | 2021-06-18 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210618-104.pdf | |
65975 | 65975 | 2021-06-18 | Bluetext, LLC | Bluetext, LLC 6693 | Informational Materials | Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP | KOREA SOUTH | https://efile.fara.gov/docs/6693-Informational-Materials-20210618-105.pdf | |
65976 | 65976 | 2021-06-18 | 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-20210618-252.pdf | |
65977 | 65977 | 2021-06-18 | 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-20210618-282.pdf | |
65978 | 65978 | 2021-06-18 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210618-750.pdf | |
65979 | 65979 | 2021-06-18 | 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-20210618-957.pdf | |
65980 | 65980 | 2021-06-18 | Off Hill Strategies LLC | Off Hill Strategies LLC 6889 | Informational Materials | Embassy of the Kingdom of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6889-Informational-Materials-20210618-13.pdf | |
65981 | 65981 | 2021-06-18 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210618-284.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]) );