FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where 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 of the UAE), The Executive Office (Dubai)", Registrant_Date = "2004-10-08" and Registrant_Name = "Levick Strategic Communications"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date)
State 1
- - 1
Registrant_Name 1
- Levick Strategic Communications · 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 of the UAE), The Executive Office (Dubai) · 1 ✖
Country/Location_Represented 1
City 1
- - 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10542 | 10542 | 2008-08-15 | 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) | 2007-02-28 | UNITED ARAB EMIRATES | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications |
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]) );