FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where 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 for the UAE), The Executive Office (Dubai)" and Registration_Number = 5787 sorted by rowid descending
This data as json, CSV (advanced)
Registrant_Name 1
Foreign_Principal_Name 1
- Sheikh Mohammed Bin Rashid Al Maktoum (Prime Minister VP of the UAE), Sheikh Hamdan Bin Rashid Al Maktoum (Minister of Finance and Industry for the UAE), The Executive Office (Dubai) · 1 ✖
Foreign_Principal_Country 1
Document_Type 1
Link | rowid ▲ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
7434 | 7434 | 2007-01-25 | Rock Creek Strategic Marketing | Rock Creek Strategic Marketing 5787 | 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 for the UAE), The Executive Office (Dubai) | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/5787-Exhibit-AB-20070125-1.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]) );