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

22 rows where "Foreign_Principal_Termination_Date" is on date 1987-01-01

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

City 1

  • - 22
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
881 881 1987-01-01 Aeroport de Paris 1980-03-25 FRANCE Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc.          
882 882 1987-01-01 Agence Comturist Bucharest Romania 1973-08-20 ROMANIA Supuran, Victor 2451 1973-08-20 Supuran, Victor Bucharest        
883 883 1987-01-01 Alfa Romeo, S.p.A. 1985-05-03 ITALY Alenia of U.S.A., Inc. 3399 1982-08-11 Alenia of U.S.A., Inc.          
884 884 1987-01-01 Burnett & Hallamshire Holdings, PLC 1986-07-17 GREAT BRITAIN Chadbourne & Parke 3490 1983-06-24 Chadbourne & Parke Notts        
885 885 1987-01-01 Cayman Airways, Ltd. 1978-05-12 CAYMAN ISLANDS Cayman Islands News Bureau 2823 1977-08-12 Cayman Islands News Bureau Grand Cayman        
886 886 1987-01-01 Cayman Islands Government, Department of Tourism 1977-08-12 CAYMAN ISLANDS Cayman Islands News Bureau 2823 1977-08-12 Cayman Islands News Bureau Grand Cayman        
887 887 1987-01-01 Consejo Empresarial Mexicano para Asuntos Internacionales (CEMAI) 1985-07-18 MEXICO GFE, Ltd. 3705 1985-07-18 GFE, Ltd.          
888 888 1987-01-01 Embassy of Canada 1984-02-10 CANADA Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt Washington     DC  
889 889 1987-01-01 Government of the Republic of Seychelles 1985-06-11 SEYCHELLES Teeley-MacDonald Partnership 3689 1985-06-11 Teeley-MacDonald Partnership          
890 890 1987-01-01 Hoya Corporation 1985-12-23 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Tokyo        
891 891 1987-01-01 Japan Trade Center 1987-02-16 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
892 892 1987-01-01 Jordan Information Bureau 1976-05-19 JORDAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
893 893 1987-01-01 LEG State Development Corporation of Baden - Wuerttemberg 1986-06-11 GERMANY, FEDERAL REPUBLIC OF Richard V. Allen Company 3709 1985-07-26 Richard V. Allen Company          
894 894 1987-01-01 M.E.L. 1982-12-01 GREAT BRITAIN Botsford, Charles G. 3268 1981-08-12 Botsford, Charles G. West Sussex        
895 895 1987-01-01 Middle East Institute 1981-07-30 INTERNATIONAL Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. New York     NY  
896 896 1987-01-01 Ministry of Transport, Tourism & Communications (Spain) 1985-05-23 SPAIN Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc. New York     NY  
897 897 1987-01-01 National Travel Office Carpati Bucharest"" 1988-07-11 ROMANIA Supuran, Victor 2451 1973-08-20 Supuran, Victor Bucharest        
898 898 1987-01-01 Nobel Foundation 1983-02-18 SWEDEN Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Stockholm        
899 899 1987-01-01 Pietro Beretta, S.p.A. 1980-12-03 ITALY Bonaventure, Robert L. 3177 1980-12-03 Bonaventure, Robert L.          
900 900 1987-01-01 Scandinavian Railways Companies 1966-05-11 INTERNATIONAL Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
901 901 1987-01-01 Small & Medium Industry Bank of Korea 1983-06-16 KOREA, SOUTH Oppenheimer, Wolff & Donnelly 3485 1983-06-16 Oppenheimer, Wolff & Donnelly Seoul        
902 902 1987-01-01 TransCanada Pipelines, Ltd. 1981-11-24 CANADA Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt Toronto, Ontario        

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