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

12 rows where Registration_Number = 4529

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 10

State 2

Registrant_Name 1

City 1

  • - 12
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
960 960 1995-01-01 Republic of Algeria 1993-06-18 ALGERIA Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Washington     DC  
1335 1335 1992-01-15 Committee to Establish City of America (Through Perkins Coie) 1991-06-20 JAPAN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Tokyo        
1777 1777 1994-01-31 Foreign Ministry of Iceland 1991-08-29 ICELAND Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Reykjavik        
1779 1779 1994-01-31 Ministry of Trade & Industry 1992-07-10 KOREA, SOUTH Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L          
7138 7138 1995-05-31 Agusta Group 1993-09-02 ITALY Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Milano        
7655 7655 1994-06-07 Council of Saudi Chambers of Commerce & Industry 1993-09-30 SAUDI ARABIA Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Riyadh        
9271 9271 1997-07-15 Besim Tibuk 1997-07-29 TURKEY Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Istanbul        
9808 9808 1995-07-31 E.H. Industries, Ltd. 1993-09-02 GREAT BRITAIN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L London        
10032 10032 1997-08-01 Takata Corporation 1996-09-30 JAPAN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Tokyo        
11287 11287 1997-09-01 Better Hong Kong Foundation 1996-02-13 HONG KONG Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Wanchai        
13370 13370 1997-10-31 Republic of Turkey 1992-01-31 TURKEY Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Washington     DC  
14840 14840 1993-12-06 Republic of Azerbaijan 1993-02-05 AZERBAIJAN Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L Baku        

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