FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Date_Stamped" is on date 2019-03-13 and Document_Type = "Exhibit AB"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country 5
- SPAIN 2
- AFGHANISTAN 1
- GERMANY 1
- MALAYSIA 1
- NIGER 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
27590 | 27590 | 2019-03-13 | Abernathy MacGregor Group, Inc. | Abernathy MacGregor Group, Inc. 6647 | Exhibit AB | Embassy of Spain | SPAIN | https://efile.fara.gov/docs/6647-Exhibit-AB-20190313-2.pdf | |
27591 | 27591 | 2019-03-13 | Abernathy MacGregor Group, Inc. | Abernathy MacGregor Group, Inc. 6647 | Exhibit AB | Oversea Solution, Ltd. on behalf of the Embassy of Spain | SPAIN | https://efile.fara.gov/docs/6647-Exhibit-AB-20190313-1.pdf | |
27604 | 27604 | 2019-03-13 | Hogan Lovells US LLP | Hogan Lovells US LLP 2244 | Exhibit AB | Embassy of Afghanistan | AFGHANISTAN | https://efile.fara.gov/docs/2244-Exhibit-AB-20190313-84.pdf | |
27608 | 27608 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | NRW.INVEST (NORTH AMERICA) LLC 6645 | Exhibit AB | Ministry of Economic Affairs, Innovation, Digitalization and Energy of the State of the North Rhone-Westphalia; Germany | GERMANY | https://efile.fara.gov/docs/6645-Exhibit-AB-20190313-1.pdf | |
27614 | 27614 | 2019-03-13 | Reevemark LLC | Reevemark LLC 6646 | Exhibit AB | Low Taek Jho | MALAYSIA | https://efile.fara.gov/docs/6646-Exhibit-AB-20190313-1.pdf | |
27626 | 27626 | 2019-03-13 | Vanguard Africa | Vanguard Africa 6411 | Exhibit AB | Ibrahim Yacouba | NIGER | https://efile.fara.gov/docs/6411-Exhibit-AB-20190313-11.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]) );