FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

21 rows where City = "Dubai"

✎ View and edit SQL

This data as json, 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)

Country/Location_Represented

State

  • - 21

City

  • Dubai · 21 ✖
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
128 128   Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES 6212 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
296 296   HH Sheikh Marwan Bin Muhd. Bin Rashid Al Maktoum 2021-01-08 UNITED ARAB EMIRATES 6905 6905 2021-01-08 Vega Jr., Luis Angel P.O. Box 91791 United Arab Emirates Dubai    
1535 1535 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    
2997 2997 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    
3594 3594 2020-03-15 Expo 2020 Dubai 2019-04-26 UNITED ARAB EMIRATES 6530 6530 2018-03-07 Sanitas International, Inc. Expo Road Dubai South, Jebel Ali   Dubai    
4491 4491 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    
4712 4712 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    
5341 5341 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    
6912 6912 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    
6930 6930 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    
7119 7119 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    
8573 8573 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    
9483 9483 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    
10717 10717 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    
12316 12316 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    
13368 13368 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    
13497 13497 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    
13529 13529 2016-11-17 Adalid Business Consulting DMCC 2015-09-13 IRAQ 5666 5666 2005-01-31 FGH Holdings Unit 305, Indigo Tower, Cluster D Emirates Hill First, Jumeriah Lake Towers Dubai    
14663 14663 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    
16118 16118 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    
16121 16121 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    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);