FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
2 rows where Foreign_Principal_Country = "UNITED ARAB EMIRATES" and Foreign_Principal_Name = "Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai)"
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name 2
Document_Type 1
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
19980 | 19980 | 2007-02-28 | Levick Strategic Communications I WO M Street NW, SuiteQO Washington, DC MOM | Levick Strategic Communications 5649 | Exhibit AB | Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai) | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/5649-Exhibit-AB-20070228-9.pdf | |
19981 | 19981 | 2007-02-28 | Levick Strategic Communications | Levick Strategic Communications 5649 | Exhibit AB | Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister, VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry of the UAE), The Executive Office (Dubai) | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/5649-Exhibit-AB-20070228-10.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]) );