FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where Foreign_Principal_Country = "UNITED ARAB EMIRATES", 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)" and Registrant_Name = "Levick Strategic Communications" sorted by Foreign_Principal_Name
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
Registrant_Name 1
- Levick Strategic Communications · 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 of the UAE), The Executive Office (Dubai) · 1 ✖
Foreign_Principal_Country 1
- UNITED ARAB EMIRATES · 1 ✖
Document_Type 1
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name ▼ | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
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]) );