FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Date_Stamped" is on date 2019-09-19 and Document_Type = "Informational Materials"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 8
- Republika Srpska 5
- Turkish Republic of Northern Cyprus, H.E. Mustafa Akinci 2
- Embassy of the Republic of Korea 1
- Government of National Accord Libya, Office of the Prime Minister 1
- Huawei Technologies USA 1
- Innovative Technology & Business Consulting LLC 1
- Prince Albert II of Monaco Foundation 1
- Zaklad Metalurgiczny, through SEKCO Operating Company 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
98997 | 98997 | 2019-09-19 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190919-424.pdf | |
98998 | 98998 | 2019-09-19 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190919-425.pdf | |
98999 | 98999 | 2019-09-19 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190919-426.pdf | |
99000 | 99000 | 2019-09-19 | 6672 | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200919-423.pdf | |
99002 | 99002 | 2019-09-19 | Livingston Group, LLC | Livingston Group, LLC 6344 | Informational Materials | Innovative Technology & Business Consulting LLC | UKRAINE | https://efile.fara.gov/docs/6344-Informational-Materials-20190919-53.pdf | |
99003 | 99003 | 2019-09-19 | Livingston Group, LLC | Livingston Group, LLC 6344 | Informational Materials | Zaklad Metalurgiczny, through SEKCO Operating Company | POLAND | https://efile.fara.gov/docs/6344-Informational-Materials-20190919-52.pdf | |
99008 | 99008 | 2019-09-19 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20190919-87.pdf | |
99009 | 99009 | 2019-09-19 | 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-20190919-176.pdf | |
99013 | 99013 | 2019-09-19 | Racepoint Global, Inc. | Racepoint Global, Inc. 6650 | Informational Materials | Huawei Technologies USA | CHINA | https://efile.fara.gov/docs/6650-Informational-Materials-20190919-47.pdf | |
99016 | 99016 | 2019-09-19 | 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-20190919-21.pdf | |
99017 | 99017 | 2019-09-19 | 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-20190919-51.pdf | |
99018 | 99018 | 2019-09-19 | SKDKnickerbocker LLC | SKDKnickerbocker LLC 6690 | Informational Materials | Prince Albert II of Monaco Foundation | MONACO | https://efile.fara.gov/docs/6690-Informational-Materials-20190919-5.pdf | |
99019 | 99019 | 2019-09-19 | Squire Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Informational Materials | Embassy of the Republic of Korea | KOREA SOUTH | https://efile.fara.gov/docs/2165-Informational-Materials-20190919-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]) );