Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, atom, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name
Foreign_Principal
Country/Location_Represented
City
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 226 | 226 | Expo 2020 Dubai | 2019-04-26 | UNITED ARAB EMIRATES | 6530 6530 | 2018-03-07 | Sanitas International, Inc. | Expo Road Dubai South, Jebel Ali | Dubai | ||||
| 1554 | 1554 | 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 | 5787 5787 | 2007-01-25 | Rock Creek Strategic Marketing | c/o The Executive Office | Dubai Holdings P.O. Box 73311 | Dubai | ||
| 2992 | 2992 | 2008-02-29 | Borse Dubai Limited | 2007-10-19 | UNITED ARAB EMIRATES | 2244 2244 | 1971-02-18 | Hogan Lovells US LLP | P.O. Box 74777, Level 14, The Gate | Dubai International Financial Centre, | Dubai | ||
| 4471 | 4471 | 2010-03-31 | Executive Office of Dubai | 2008-08-07 | UNITED ARAB EMIRATES | 5827 5827 | 2007-09-07 | Mark Saylor Company, LLC | Emirates Towers, Level 38 | P.O. Box 73311 | Dubai | ||
| 4683 | 4683 | 2009-04-01 | Executive Office of His Highness Sheikh Mohammed Bin Rashid Al Maktoum | 2007-01-19 | UNITED ARAB EMIRATES | 5776 5776 | 2006-11-17 | Peck, Madigan, Jones & Stewart, Inc. | Dr. Habib Al Mulla | Emirate Towers, Level 38, Sheikh Zayed Road P.O. Box 73311 | Dubai | ||
| 5297 | 5297 | 2013-04-26 | Fundo Soberano de Angola through Grayling | 2013-04-17 | ANGOLA | 6166 6166 | 2013-04-17 | Dutko Worldwide, LLC d/b/a Dutko Grayling | Office 337, BUidling 10, Dubai Media City, P.O. Box 24554 | Dubai | |||
| 6850 | 6850 | 2009-05-31 | Emirates | 2008-11-18 | UNITED ARAB EMIRATES | 5891 5891 | 2008-11-18 | Everson, David E. | Emirates Group Legal Department Emirates New Group Headquarters Building | Marrakesh Street P.O. Box 686 | Dubai | ||
| 6868 | 6868 | 2011-05-31 | Turkish Ministry of Foreign Affairs through Hill & Knowlton Dubai | 2011-05-12 | TURKEY | 5913 5913 | 2009-03-05 | Public Strategies, Inc. | c/o Gulf Hill & Knowlton | P.O Box 50653 | Dubai | ||
| 7056 | 7056 | 2008-06-01 | Borse Dubai Limited | 2007-11-02 | UNITED ARAB EMIRATES | 3712 3712 | 1985-08-05 | DLA Piper US LLP | P.O. Box 74777, Level 14 - The Gate | Dubai International Financial Centre | Dubai | ||
| 8489 | 8489 | 2018-07-01 | Lapis Middle East and Africa | 2018-04-04 | UNITED ARAB EMIRATES | 6371 6371 | 2016-08-17 | Andreae & Associates | Office 401, Level 4, Building 4 | Studio City | Dubai | ||
| 9392 | 9392 | 2007-07-31 | Dubai Aerospace Enterprise (DAE) Ltd. | 2007-05-01 | UNITED ARAB EMIRATES | 5753 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | Level 8 Convention Tower | P.O. Box 9522 | Dubai | ||
| 10603 | 10603 | 2009-08-31 | Office of the UAE Pavilion for the Venice Biennale | 2009-05-05 | UNITED ARAB EMIRATES | 1481 1481 | 1961-09-27 | Ruder Finn, Inc. | P.O. Box 60478 | Dubai | |||
| 12164 | 12164 | 2007-10-17 | Dubai Aerospace Enterprise (DAE) Ltd., (through Skadden, Arps, Slate, Meagher & Flom, LLP) | 2007-07-02 | UNITED ARAB EMIRATES | 5818 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | Level 8 Convention Tower | P.O. Box 9522 | Dubai | ||
| 13199 | 13199 | 2008-11-11 | Executive Office of Dubai | 2008-06-26 | UNITED ARAB EMIRATES | 3712 3712 | 1985-08-05 | DLA Piper US LLP | Emirates Towers, Level 38 | P.O. Box 73311 | Dubai | ||
| 13324 | 13324 | 2007-11-16 | Dubai Aerospace Enterprise (DAE) Ltd. | 2007-05-16 | UNITED ARAB EMIRATES | 5812 5812 | 2007-05-16 | Skadden, Arps, Slate, Meagher & Flom, LLP | Level 8 - Convention Tower | P.O. Box 9522 | Dubai | ||
| 13356 | 13356 | 2016-11-17 | Adalid Business Consulting DMCC | 2015-09-13 | IRAQ | 5666 5666 | 2005-01-31 | Glover Park Group, LLC | Unit 305, Indigo Tower, Cluster D | Emirates Hill First, Jumeriah Lake Towers | Dubai | ||
| 14467 | 14467 | 2008-12-18 | Sheikh Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates, et al | 2006-11-20 | UNITED ARAB EMIRATES | 3712 3712 | 1985-08-05 | DLA Piper US LLP | c/o Dr. Habib Al Mulla | Emirates Towers, Level 38 - P.O. Box 73311 | Dubai | ||
| 15920 | 15920 | 2010-12-31 | Dubai Civil Aviation Authority | 2010-01-05 | UNITED ARAB EMIRATES | 3492 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | The Government of Dubai Legal Affairs Department Board | P.O. Box 446 | Dubai | ||
| 15923 | 15923 | 2010-12-31 | Government of Dubai | 2010-01-05 | UNITED ARAB EMIRATES | 3492 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | The Government of Dubai Legal Affairs Department Board | P.O. Box 446 | Dubai |
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) );