FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where City = "Dubai", Country/Location_Represented = "UNITED ARAB EMIRATES", Foreign_Principal = "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)", "Registrant_Date" is on date 2007-01-25 and Registrant_Name = "Rock Creek Strategic Marketing"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
State 1
- - 1
Registrant_Name 1
- Rock Creek Strategic Marketing · 1 ✖
Foreign_Principal 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 ✖
Country/Location_Represented 1
- UNITED ARAB EMIRATES · 1 ✖
City 1
- Dubai · 1 ✖
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1656 | 1656 | 2008-01-30 | 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) | 2007-01-25 | UNITED ARAB EMIRATES | Rock Creek Strategic Marketing 5787 | 2007-01-25 | Rock Creek Strategic Marketing | c/o The Executive Office | Dubai Holdings P.O. Box 73311 | Dubai |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );