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

16 rows where Registration_Number = 6064

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 7

City 3

State 2

Registrant_Name 1

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
34 34   Agence Francaise de Developpement 2021-02-22 FRANCE Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 5 Rue Roland Barthes, 75 598 Paris Cedex 12      
653 653   State of Qatar - Government Communications Office 2018-10-31 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. P.O. Box 636, Doha,        
1408 1408 2021-01-18 Investment Corporation, LLC 2020-10-28 AZERBAIJAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Xalqlar Dostlugu Xiyabani, 17C, AX1029, Baku,        
2251 2251 2019-02-06 Education Above All Foundation (through Portland PR Limited (QFC Branch) 2018-03-01 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. P.O. Box 34173 Education City, Doha        
2363 2363 2018-02-10 Embassy of the Republic of Kazakhstan 2018-01-11 KAZAKHSTAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 1401 16th Street, NW   Washington DC 20036
8743 8743 2017-06-30 Embassy of the State of Qatar 2015-01-15 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 2555 M Street, NW   Washington DC 20037
9192 9192 2019-07-11 Singapore Info-Communications Media Development Authority 2019-02-20 SINGAPORE Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Infocomm Media Development Authority 10 Pasir Panjang Road #03-01, Mapletree Business City 117438      
9914 9914 2017-07-31 Presidency of the Republic of Benin (through Portland PR Limited) 2017-09-29 BENIN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Palais de la Marina Littoral, Cotonou 01BP 2028        
11756 11756 2017-09-21 Qatar Foundation (through Portland PR Limited) 2017-12-06 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. PO Box 5825 Doha        
12211 12211 2012-09-30 Republic of Kazakhstan through Windrush Ventures No. 3 LP through Windrush Ventures Limited through Portland PR Limited 2011-09-19 KAZAKHSTAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 1 Red Lion Court   London    
12279 12279 2022-09-30 Education Above All Foundation (through Portland PR Limited (QFC Branch)) 2020-09-03 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. P.O. Box 34173 Education City Doha      
12281 12281 2022-09-30 Government of Qatar 2014-09-16 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Doha        
12462 12462 2018-10-03 Alwaleed Philanthropies 2018-09-25 SAUDI ARABIA Portland PR Inc. 6064 2011-09-19 Portland PR Inc.          
15163 15163 2019-12-15 Embassy of the Republic of Kazakhstan in Washington 2019-06-03 KAZAKHSTAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 1401 16th Street, NW        
16787 16787 2016-12-31 King Abdullah Foundation 2018-01-23 SAUDI ARABIA Portland PR Inc. 6064 2011-09-19 Portland PR Inc. Ar Rahmaniyah Riyadh 12342      
16822 16822 2018-12-31 Embassy of the Republic of Kazakhstan in Washington 2018-06-06 KAZAKHSTAN Portland PR Inc. 6064 2011-09-19 Portland PR Inc. 1401 16th Street, NW   Washington DC 20036

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