FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Date_Stamped" is on date 2021-06-11 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country 11
- SAUDI ARABIA 4
- BOSNIA & HERZEGOVINA 3
- KOREA SOUTH 3
- ANGOLA 1
- CANADA 1
- CHINA 1
- CYPRUS 1
- IRAQ 1
- KAZAKHSTAN 1
- QATAR 1
- RUSSIA 1
Document_Type 1
- Informational Materials · 18 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
64454 | 64454 | 2021-06-11 | 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-20210611-100.pdf | |
64455 | 64455 | 2021-06-11 | 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-20210611-101.pdf | |
64456 | 64456 | 2021-06-11 | 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-20210611-102.pdf | |
64459 | 64459 | 2021-06-11 | 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-20210611-16.pdf | |
64464 | 64464 | 2021-06-11 | 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-20210611-244.pdf | |
64465 | 64465 | 2021-06-11 | Hogan Lovells US LLP | Hogan Lovells US LLP 2244 | Informational Materials | Royal Embassy of Saudi Arabia, Washington, D.C. | SAUDI ARABIA | https://efile.fara.gov/docs/2244-Informational-Materials-20210611-43.pdf | |
64466 | 64466 | 2021-06-11 | 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-20210611-30.pdf | |
64467 | 64467 | 2021-06-11 | 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-20210611-560.pdf | |
64468 | 64468 | 2021-06-11 | 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-20210611-561.pdf | |
64469 | 64469 | 2021-06-11 | 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-20210611-562.pdf | |
64470 | 64470 | 2021-06-11 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210611-744.pdf | |
64471 | 64471 | 2021-06-11 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210611-745.pdf | |
64472 | 64472 | 2021-06-11 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20210611-746.pdf | |
64473 | 64473 | 2021-06-11 | 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-20210611-949.pdf | |
64475 | 64475 | 2021-06-11 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20210611-281.pdf | |
64476 | 64476 | 2021-06-11 | 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-20210611-120.pdf | |
64477 | 64477 | 2021-06-11 | Rubin Turnbull & Associates, Inc. | Rubin Turnbull & Associates, Inc. 6944 | Informational Materials | Embassy of the State of Qatar | QATAR | https://efile.fara.gov/docs/6944-Informational-Materials-20210611-1.pdf | |
64478 | 64478 | 2021-06-11 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Republic of Angola | ANGOLA | https://efile.fara.gov/docs/2165-Informational-Materials-20210611-109.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]) );