List of all foreign principals (active and terminated)

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

19 rows where Registration_Number = 5801

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

Registrant_Name

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
147   Embassy of Japan in the United States of America 2021-01-30 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 2520 Massachusetts Avenue NW   Washington DC 20008
482   OCP S.A. (OCP Group) 2020-10-09 MOROCCO 5801 5801 2007-04-16 Fleishman-Hillard, Inc.          
668   UAE Ministry of Cabinet Affairs and Future Public Diplomacy Office 2020-06-26 UNITED ARAB EMIRATES 5801 5801 2007-04-16 Fleishman-Hillard, Inc. P.O. Box: 212000 Dubai UAE      
1282 2019-01-16 Social Communication Secretariat of the Office of the President of the Republic of Brazil 2009-03-16 BRAZIL 5801 5801 2007-04-16 Fleishman-Hillard, Inc. Esplanada dos Ministerios Bloco A-6 Andar, Gabinete Brasilia    
2990 2018-02-28 Embassy of Singapore 2013-03-12 SINGAPORE 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 3501 International Place, NW   Washington DC 20008
3562 2018-03-14 King Abdullah University of Science & Technology (KAUST) 2018-03-14 SAUDI ARABIA 5801 5801 2007-04-16 Fleishman-Hillard, Inc.          
4561 2014-03-31 Government of Japan (through Dentsu, Inc.) 2014-01-10 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 1-6-1 Nagatacho Chiyoda-ku Tokyo 100-8914      
5100 2011-04-15 Levant Suez Consulting Corporation for Sheikh Fahad Al Ali Al Sabah thru GrayLoeffler, LLC 2011-03-25 KUWAIT 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 4002 Townsville Circle #105 Missouri City TX 77459
5151 2008-04-17 King Abdullah University of Science and Technology (KAUST) 2007-04-16 SAUDI ARABIA 5801 5801 2007-04-16 Fleishman-Hillard, Inc. c/o Aramco Overseas Company, B.V. P.O. Box 222; 2300 AE Leiden      
5856 2014-04-30 Government of the Republic of Turkey, Embassy 2007-09-24 TURKEY 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 2525 Massachusetts Avenue, NW   Washington DC 20008
6001 2009-05-01 Office of the Cabinet Secretariat of the Prime Minister of Japan, Cabinet Counselor 2009-04-28 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 6-1 Nagatacho 1-chome, Chiyoda-ku   Tokyo    
9727 2020-08-01 Office of the Prime Minister of Japan 2020-03-30 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 2-3-1 Nagata-Chiypda-ku-   Tokyo    
11849 2016-09-30 Embassy of Denmark 2016-07-25 DENMARK 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 3200 Whitehaven Street, NW   Washington DC 20008
12144 2020-10-08 South Korean Ministry of Trade, Industry and Energy 2020-08-14 KOREA, SOUTH 5801 5801 2007-04-16 Fleishman-Hillard, Inc. Government Complex- Sejong 401 Hannuri-daero Sejong SI    
13014 2010-10-31 Office of the President of the Federal Republic of Nigeria 2010-10-08 NIGERIA 5801 5801 2007-04-16 Fleishman-Hillard, Inc. State House   Abuja    
13066 2019-10-31 Office of the Prime Minister of Japan 2017-09-19 JAPAN 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 2-3-1, Nagata-cho Chiyoda-ku, Tokyo        
13191 2009-11-01 Abu Dhabi Department of Planning & Economy 2009-06-19 UNITED ARAB EMIRATES 5801 5801 2007-04-16 Fleishman-Hillard, Inc. P.O. Box 12 Al Salam Street      
13192 2009-11-01 General Authority for Investment and Free Zones, the Arab Republic of Egypt (GAFI) 2009-06-19 EGYPT 5801 5801 2007-04-16 Fleishman-Hillard, Inc.          
16163 2009-12-31 Cayman Islands Government, Portfolio of Finance and Economics 2007-09-07 CAYMAN ISLANDS 5801 5801 2007-04-16 Fleishman-Hillard, Inc. Government Administration Building Grand Cayman      

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