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

20 rows where "Foreign_Principal_Termination_Date" is on date 1990-06-30

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 11

State 3

City 1

  • - 20
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
8450 8450 1990-06-30 Agusta Aviation Corporation 1988-05-02 ITALY Ginn, Edington, Wade & Sanders, Inc. 4134 1988-05-02 Ginn, Edington, Wade & Sanders, Inc. Milano        
8451 8451 1990-06-30 Algoma Steel Corporation, Ltd. 1984-01-17 CANADA Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Ontario        
8452 8452 1990-06-30 Algoma Steel Corporation, Ltd. 1984-03-14 CANADA Melville, James T. 3570 1984-03-14 Melville, James T. Ontario        
8453 8453 1990-06-30 Algoma Steel Corporation, Ltd. 1984-06-21 CANADA Nixon, Peter 3598 1984-06-21 Nixon, Peter Ontario        
8454 8454 1990-06-30 Beckett Packaging, Ltd. 1988-03-16 CANADA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Ontario        
8455 8455 1990-06-30 Embassy of the Republic of Senegal 1990-05-18 SENEGAL van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
8456 8456 1990-06-30 Embassy of the Socialist Republic of Romania 1986-03-03 ROMANIA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
8457 8457 1990-06-30 Fiat, S.p.A. 1986-05-22 ITALY Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP Torino        
8458 8458 1990-06-30 Fundacion Pro-Imagen de Colombia en el Exterior 1988-11-02 COLOMBIA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bogota        
8459 8459 1990-06-30 Gilbert Chagoury 1989-12-21 FRANCE Marc, Inc. 4325 1989-12-21 Marc, Inc. Paris        
8460 8460 1990-06-30 Government of Panama 1990-06-20 PANAMA Capitol Resources Group 4386 1990-06-20 Capitol Resources Group Washington     DC  
8461 8461 1990-06-30 Harris Steel Group, Inc. 1985-06-06 CANADA Harris, Milton E. 3687 1985-06-06 Harris, Milton E. Toronto, Ontario        
8462 8462 1990-06-30 Harris Steel Group, Inc. 1985-06-21 CANADA Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Ontario        
8463 8463 1990-06-30 Hotel Suites Alvear 1990-01-17 PANAMA Holland & Knight 3718 1985-08-07 Holland & Knight Panama City        
8464 8464 1990-06-30 Minerals Marketing Corporation of Zimbabwe (MMCZ) 1987-12-23 ZIMBABWE Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Harare        
8465 8465 1990-06-30 Scandinavian Tourist Board 1988-11-23 INTERNATIONAL West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
8466 8466 1990-06-30 Stelco, Inc. 1989-12-13 CANADA Clayton, Reginald Hugh 4324 1989-12-13 Clayton, Reginald Hugh Ontario        
8467 8467 1990-06-30 Stratas Corporation, Ltd. 1989-02-17 CANADA Dickstein Shapiro, LLP 3028 1979-06-07 Dickstein Shapiro, LLP Halifax, Nova Scotia        
8468 8468 1990-06-30 UNITA (Uniao Nacional de Independencia Total de Angola National Union for the Total Independence of Angola) 1990-04-10 ANGOLA Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. Washington     DC  
8469 8469 1990-06-30 Union Nationals Democracy Party 1989-12-04 MYANMAR (BURMA) Sein, Malcolm K. 4319 1989-12-04 Sein, Malcolm K. Rangoon        

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