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

19 rows where Registration_Number = 5198

✎ View and edit SQL

This data as json, CSV (advanced)

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

City

State

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
85 85   Cayman Islands Ministry of Financial Services, Commerce & Environment 2016-09-02 CAYMAN ISLANDS 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Government Administration Building, Box 126 133 Elgin Avenue, Grand Cayman KY1-9000      
164 164   Embassy of Qatar 2018-03-23 QATAR 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2555 M Street, NW   Washington DC 20037
285 285   Government of the Republic of Korea, Embassy 2011-11-10 KOREA, SOUTH 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
417 417   Ministry of Energy, Industry, and Mineral Resources (MEIM) King Abdullah City for Atomic and Renewable Energy (K.A.CARE) 2018-02-20 SAUDI ARABIA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Postal Code 11191 Riyadh MEIM      
580 580   Secretaria de Economia 1998-04-09 MEXICO 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 50 Fremont Street San Francisco     CA  
675 675   iFLYTEK Co., Ltd. 2019-06-26 CHINA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Hefei City, No. 666 Wangjiang Road West Anhui Province      
1070 1070 2016-01-09 International Counsel Bureau, Kuwaiti Counsel for the Families of Kuwaiti Citizens at Guantanamo Bay 2006-08-07 KUWAIT 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Dasman Commercial Complex Block No. 3, 8th Floor P.O. Box 20941, Safat 13070 Sharq    
1366 1366 2015-01-23 King Abdullah City for Atomic and Renewable Energy (KACARE) 2011-10-17 SAUDI ARABIA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP P.O. Box 2022 Al Akaria Plaza Square, Entrance 2   Riyadh    
1687 1687 1998-01-31 Barseback Kraft AB 1997-11-12 SWEDEN 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP LODDEKOPINGE        
1689 1689 1998-01-31 Empresa Nacional del Uranio, S.A. (ENUSA) 1997-11-12 SPAIN 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Madrid        
1930 1930 2008-02-01 Bangladesh Nationalist Party 2007-06-13 BANGLADESH 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Naya Paltan   Dhaka    
4539 4539 2016-03-31 Royal Embassy of Saudi Arabia 2015-03-26 SAUDI ARABIA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 601 New Hampshire Avenue, NW   Washington DC 20037
8986 8986 1998-07-20 Empresa Estatal de Telecomunicaciones (Emetel) 1997-07-31 ECUADOR 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Quito        
9433 9433 2001-07-31 Government of Liechtenstein 2000-05-25 LIECHTENSTEIN 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Regierrungsgebaude, FL - 4940 Vaduz        
9532 9532 2020-07-31 Association of Cyprus Banks 2019-08-28 CYPRUS 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 15, Demetriou Karatasou Str., 4th Floor, Flat 401 Nicosia 2024      
9534 9534 2020-07-31 Ministry of Foreign Affairs of Kosovo 2018-09-10 KOSOVA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Ministry of Foreign Affairs Building Str. Luan Haradinaj" No. 32 10000 Pristina "      
10129 10129 2017-08-15 Government of Georgia 2015-04-24 GEORGIA 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Tbilisi, Georgia 0175 P. Ingorovka Str. N7      
12939 12939 2011-10-31 Government of Taiwan (Taipei Economic and Cultural Representative Office) 2010-12-15 TAIWAN 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 4201 Wisconsin Avenue, NW   Washington DC 20016
14289 14289 2019-12-06 Khamis Khanjar and Sarmad Khanjar 2019-06-10 IRAQ 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Al Radwan Company Mishmisheh Building 14 Ramadan Street, Mansur District Baghdad    

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