FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Date_Stamped" is on date 2020-04-08
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 13
- - 8
- Turkey-U.S. Business Council (TAIK) 3
- Government of Japan, Embassy 2
- Government of National Accord Libya, Office of the Prime Minister 2
- Embassy of Japan 1
- European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) 1
- Government of Colombia, Embassy 1
- Kingdom of Saudi Arabia 1
- Korea Trade-Investment Promotion Agency 1
- Mr. Andrii Derkach 1
- PJSC United Aircraft Corporation 1
- Republika Srpska 1
- Saudi Basic Industries Corporation (SABIC) 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
38798 | 38798 | 2020-04-08 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Informational Materials | Saudi Basic Industries Corporation (SABIC) | SAUDI ARABIA | https://efile.fara.gov/docs/3634-Informational-Materials-20200408-9.pdf | |
38799 | 38799 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Amendment | https://efile.fara.gov/docs/5867-Amendment-20200408-45.pdf | |||
38800 | 38800 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Amendment | https://efile.fara.gov/docs/5867-Amendment-20200408-46.pdf | |||
38801 | 38801 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Amendment | https://efile.fara.gov/docs/5867-Amendment-20200408-47.pdf | |||
38802 | 38802 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Exhibit AB | Government of Colombia, Embassy | COLOMBIA | https://efile.fara.gov/docs/5867-Exhibit-AB-20200408-51.pdf | |
38803 | 38803 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Exhibit AB | Government of Japan, Embassy | JAPAN | https://efile.fara.gov/docs/5867-Exhibit-AB-20200408-49.pdf | |
38804 | 38804 | 2020-04-08 | Fratelli Group | Fratelli Group 5867 | Exhibit AB | Government of Japan, Embassy | JAPAN | https://efile.fara.gov/docs/5867-Exhibit-AB-20200408-50.pdf | |
38805 | 38805 | 2020-04-08 | Global Management Association, Corp | Global Management Association, Corp 6812 | Exhibit AB | Mr. Andrii Derkach | UKRAINE | https://efile.fara.gov/docs/6812-Exhibit-AB-20200408-1.pdf | |
38806 | 38806 | 2020-04-08 | Global Management Association, Corp | Global Management Association, Corp 6812 | Exhibit C | https://efile.fara.gov/docs/6812-Exhibit-C-20200408-1.pdf | |||
38807 | 38807 | 2020-04-08 | Global Management Association, Corp | Global Management Association, Corp 6812 | Registration Statement | https://efile.fara.gov/docs/6812-Registration-Statement-20200408-1.pdf | |||
38808 | 38808 | 2020-04-08 | Global Management Association, Corp | Global Management Association, Corp 6812 | Short-Form | Bader, Nabil Ahmad | https://efile.fara.gov/docs/6812-Short-Form-20200408-2.pdf | ||
38809 | 38809 | 2020-04-08 | Greenfield Law, LLC | Greenfield Law, LLC 6294 | Exhibit AB | Embassy of Japan | JAPAN | https://efile.fara.gov/docs/6294-Exhibit-AB-20200408-5.pdf | |
38810 | 38810 | 2020-04-08 | KOTRA | KOTRA 1619 | Informational Materials | Korea Trade-Investment Promotion Agency | KOREA SOUTH | https://efile.fara.gov/docs/1619-Informational-Materials-20200408-30.pdf | |
38811 | 38811 | 2020-04-08 | MSLGROUP Americas, LLC | QORVIS LLC 5483 | Informational Materials | Kingdom of Saudi Arabia | SAUDI ARABIA | https://efile.fara.gov/docs/5483-Informational-Materials-20200408-102.pdf | |
38812 | 38812 | 2020-04-08 | Mark Thomas Stopa | Stopa, Mark Thomas 6813 | Exhibit AB | PJSC United Aircraft Corporation | RUSSIA | https://efile.fara.gov/docs/6813-Exhibit-AB-20200408-1.pdf | |
38813 | 38813 | 2020-04-08 | Mark Thomas Stopa | Stopa, Mark Thomas 6813 | Registration Statement | https://efile.fara.gov/docs/6813-Registration-Statement-20200408-1.pdf | |||
38814 | 38814 | 2020-04-08 | McGinnis Lochridge | McGinnis Lochridge 6672 | Informational Materials | Republika Srpska | BOSNIA & HERZEGOVINA | https://efile.fara.gov/docs/6672-Informational-Materials-20200408-195.pdf | |
38815 | 38815 | 2020-04-08 | 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-20200408-351.pdf | |
38816 | 38816 | 2020-04-08 | 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-20200408-353.pdf | |
38817 | 38817 | 2020-04-08 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200408-352.pdf | |
38818 | 38818 | 2020-04-08 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200408-369.pdf | |
38819 | 38819 | 2020-04-08 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Turkey-U.S. Business Council (TAIK) | TURKEY | https://efile.fara.gov/docs/6170-Informational-Materials-20200408-370.pdf | |
38820 | 38820 | 2020-04-08 | Neale Creek, LLC | Neale Creek, LLC 6723 | Supplemental Statement | https://efile.fara.gov/docs/6723-Supplemental-Statement-20200408-1.pdf | |||
38821 | 38821 | 2020-04-08 | Waxman Consulting, Inc. DBA Waxman Strategies | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | Informational Materials | European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) | NORWAY | https://efile.fara.gov/docs/6710-Informational-Materials-20200408-194.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]) );