FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Date_Stamped" is on date 2021-06-01 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 12
- SAUDI ARABIA 3
- KOREA SOUTH 2
- - 1
- AFGHANISTAN 1
- BANGLADESH 1
- CHINA 1
- CYPRUS 1
- IRAQ 1
- ISRAEL 1
- LIBYA 1
- PHILIPPINES 1
- TURKEY 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
61964 | 61964 | 2021-06-01 | 5430 | BGR Government Affairs, LLC 5430 | Informational Materials | Government of the People's Republic of Bangladesh, Embassy | BANGLADESH | https://efile.fara.gov/docs/5430-Informational-Materials-20210601-138.pdf | |
61965 | 61965 | 2021-06-01 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of National Unity of Libya (through Mercury International UK Ltd.) | LIBYA | https://efile.fara.gov/docs/6170-Informational-Materials-20210601-945.pdf | |
61966 | 61966 | 2021-06-01 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Q Cyber Technologies Ltd | ISRAEL | https://efile.fara.gov/docs/6170-Informational-Materials-20210601-946.pdf | |
61967 | 61967 | 2021-06-01 | 6170 | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20210601-944.pdf | |
61968 | 61968 | 2021-06-01 | Arena Strategy Group, LLC | Arena Strategy Group, LLC 6899 | Informational Materials | Royal Embassy of Saudi Arabia through Larson Shannah | https://efile.fara.gov/docs/6899-Informational-Materials-20210601-12.pdf | ||
61969 | 61969 | 2021-06-01 | BCW LLC | BCW LLC 6227 | Informational Materials | The Government of the Republic of the Philippines | PHILIPPINES | https://efile.fara.gov/docs/6227-Informational-Materials-20210601-39.pdf | |
61971 | 61971 | 2021-06-01 | 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-20210601-35.pdf | |
61972 | 61972 | 2021-06-01 | 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-20210601-274.pdf | |
61973 | 61973 | 2021-06-01 | 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-20210601-275.pdf | |
61974 | 61974 | 2021-06-01 | Kurdistan Regional Government - Liaison Office - USA | Kurdistan Regional Government - Liaison Office - USA 5783 | Informational Materials | Kurdistan Regional Government | IRAQ | https://efile.fara.gov/docs/5783-Informational-Materials-20210601-29.pdf | |
61978 | 61978 | 2021-06-01 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20210601-554.pdf | |
61979 | 61979 | 2021-06-01 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20210601-555.pdf | |
61980 | 61980 | 2021-06-01 | Larson Shannahan Slifka Group, LLC | Larson Shannahan Slifka Group, LLC 6749 | Informational Materials | Royal Embassy of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/6749-Informational-Materials-20210601-556.pdf | |
61985 | 61985 | 2021-06-01 | 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-20210601-115.pdf | |
61986 | 61986 | 2021-06-01 | Wise Capital Strategy, LLC | Wise Capital Strategy, LLC 6803 | Informational Materials | The Afghanistan - U.S. Democratic Peace and Prosperity Council | AFGHANISTAN | https://efile.fara.gov/docs/6803-Informational-Materials-20210601-26.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]) );