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

47 rows where "Foreign_Principal_Termination_Date" is on date 1990-12-31

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 5

City 1

  • - 47
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
16139 16139 1990-12-31 Korea Soybean Processors' Association 1990-01-18 KOREA, SOUTH Gene Moos & Associates 4331 1990-01-18 Gene Moos & Associates Seoul        
16140 16140 1990-12-31 Amalgamated Metal Corporation, PLC 1989-02-16 GREAT BRITAIN Chadbourne & Parke 3490 1983-06-24 Chadbourne & Parke London        
16141 16141 1990-12-31 American Honda Motor Company, Inc. 1990-06-05 JAPAN Davis Wright Tremaine 4382 1990-06-05 Davis Wright Tremaine Gardena     CA  
16142 16142 1990-12-31 Antigua & Barbuda Department of Tourism 1986-06-02 ANTIGUA & BARBUDA Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
16143 16143 1990-12-31 Australian Barley Board 1988-01-21 AUSTRALIA Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. Adelaide        
16144 16144 1990-12-31 Bonaire Government 1989-04-24 BONAIRE Sontheimer Hazlett, Ltd. 1648 1963-07-19 Sontheimer Hazlett, Ltd. Kralendijk, Bonaire        
16145 16145 1990-12-31 British Consulate General 1989-05-24 GREAT BRITAIN DeCamp Legal Services, P.C. 4258 1989-05-24 DeCamp Legal Services, P.C. Chicago     IL  
16146 16146 1990-12-31 British Government 1990-01-03 GREAT BRITAIN Murphy & Desmond, S.C. 4327 1990-01-03 Murphy & Desmond, S.C. Chicago     IL  
16147 16147 1990-12-31 Canadian Institute of Steel Construction 1986-08-29 CANADA Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Ontario        
16148 16148 1990-12-31 Canadian Institute of Steel Construction 1986-10-09 CANADA Krentz, Hugh A. 3895 1986-10-09 Krentz, Hugh A. Ontario        
16149 16149 1990-12-31 City of Hannover, West Germany 1986-04-04 GERMANY P.W. Anderson & Partners, Inc. 3806 1986-04-04 P.W. Anderson & Partners, Inc.          
16150 16150 1990-12-31 City of Managua, Nicaragua 1990-07-24 NICARAGUA Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Managua        
16151 16151 1990-12-31 Clearwater Fine Foods 1988-06-28 CANADA Bogle & Gates 3474 1983-05-24 Bogle & Gates Nova Scotia        
16152 16152 1990-12-31 Corporacion Nacional de Turismo de Colombia 1978-02-01 COLOMBIA Colombian Government Tourist Office 1285 1959-10-12 Colombian Government Tourist Office          
16153 16153 1990-12-31 Crystal Globe, Ltd. 1987-06-01 NORWAY Bogle & Gates 3474 1983-05-24 Bogle & Gates          
16154 16154 1990-12-31 Curacao Tourism Development Bureau 1990-09-10 CURACAO Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
16155 16155 1990-12-31 Danish Agricultural Council 1974-05-01 DENMARK Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
16156 16156 1990-12-31 Empresa Colombiana de Turismo 1959-10-12 COLOMBIA Colombian Government Tourist Office 1285 1959-10-12 Colombian Government Tourist Office Bogota        
16157 16157 1990-12-31 German Convention Bureau 1990-09-10 GERMANY Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. East Meadow     NY  
16158 16158 1990-12-31 German National Tourist Board 1979-10-10 GERMANY Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
16159 16159 1990-12-31 Golden Tulip Aruba Caribbean Hotel & Casino 1986-05-21 ARUBA Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
16160 16160 1990-12-31 Government of El Salvador 1990-04-18 EL SALVADOR FMR Group, Inc. 4381 1990-04-18 FMR Group, Inc. San Salvador        
16161 16161 1990-12-31 Government of the Argentine Republic 1989-11-17 ARGENTINA Williams & Connolly 4225 1989-03-14 Williams & Connolly Washington     DC  
16162 16162 1990-12-31 Government of the Republic of Poland 1990-03-16 POLAND Paul, Weiss, Rifkind, Wharton & Garrison 3647 1985-02-04 Paul, Weiss, Rifkind, Wharton & Garrison Washington     DC  
16163 16163 1990-12-31 Jalawi Corporation 1979-01-16 SAUDI ARABIA Franklin & Sims Trading Corporation 3063 1979-10-02 Franklin & Sims Trading Corporation          
16164 16164 1990-12-31 John Kendall & Associates 1989-03-29 GREAT BRITAIN Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. London        
16165 16165 1990-12-31 Lufthansa German Airlines 1990-02-28 GERMANY Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. New York     NY  
16166 16166 1990-12-31 Michels Warren Public Relations 1988-01-21 AUSTRALIA Keene, Shirley & Associates, Inc. 3997 1987-06-19 Keene, Shirley & Associates, Inc. Adelaide        
16167 16167 1990-12-31 Montserrat Department of Tourism 1986-02-25 MONTSERRAT Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc.          
16168 16168 1990-12-31 Nippon Steel Corporation 1990-06-04 JAPAN O'Melveny & Myers 3346 1982-03-12 O'Melveny & Myers Tokyo        
16169 16169 1990-12-31 Ontario Ministry of Industry & Tourism 1973-10-03 CANADA Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
16170 16170 1990-12-31 People SARL & World Magazine Communication, Inc. 1989-05-16 FRANCE Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. Paris        
16171 16171 1990-12-31 People of the Republic of South Moluccas 1975-04-09 SOUTH MOLUCCAS, REPUBLIC OF Office of the Republic of South Moluccas 2575 1975-04-09 Office of the Republic of South Moluccas          
16172 16172 1990-12-31 Portuguese Trade Commission 1990-08-07 PORTUGAL Harron & Associates 4431 1990-08-07 Harron & Associates New York     NY  
16173 16173 1990-12-31 Presidency of the Republic of Guatemala 1987-09-28 GUATEMALA Cameron, Bruce P. 4043 1987-09-28 Cameron, Bruce P. Guatemala City        
16174 16174 1990-12-31 Republic of the Philippines 1990-02-09 PHILIPPINES Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe San Francisco     CA  
16175 16175 1990-12-31 Rolls Royce, Inc., Wholly-Owned Subsidiary of Rolls Royce, PLC of England 1989-03-27 GREAT BRITAIN Hyman Fine & Associates, Ltd. 3273 1981-09-02 Hyman Fine & Associates, Ltd. Washington     DC  
16176 16176 1990-12-31 Rossing Uranium, Ltd. 1990-05-09 NAMIBIA Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Windhoek        
16177 16177 1990-12-31 Royal Jordanian Airlines, Jordan Ministry of Tourism 1987-06-25 JORDAN Lou Hammond & Associates, Inc. 3682 1985-05-23 Lou Hammond & Associates, Inc.       NY  
16178 16178 1990-12-31 Secretaria de Relaciones Exteriores Directora de Informacion Internacional 1990-09-20 MEXICO CHACMA, Inc. 4020 1987-08-03 CHACMA, Inc. Mexico D.F.        
16179 16179 1990-12-31 Sodick, Inc. 1990-04-09 JAPAN Williams & Jensen, P.C. 3112 1980-06-13 Williams & Jensen, P.C. Rolling Meadows     IL  
16180 16180 1990-12-31 Statoil North America, Inc. 1989-09-22 NORWAY Washington Policy & Analysis 4211 1989-01-27 Washington Policy & Analysis New York     NY  
16181 16181 1990-12-31 Tokyo Electric Power Company 1990-05-25 JAPAN Miller & Chevalier, Chartered 3626 1984-10-31 Miller & Chevalier, Chartered Tokyo        
16182 16182 1990-12-31 Tokyo Electric Power Company 1990-05-25 JAPAN Washington Policy & Analysis 4211 1989-01-27 Washington Policy & Analysis Tokyo        
16183 16183 1990-12-31 Total Compagnie Francaise des Petroles 1986-07-03 FRANCE Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
16184 16184 1990-12-31 Turkish Tourism Information Office 1991-01-08 TURKEY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
16185 16185 1990-12-31 Universal Frutrading Co-operative, Ltd. 1988-03-15 SOUTH AFRICA Freedman, Levy, Kroll & Simonds 4117 1988-03-15 Freedman, Levy, Kroll & Simonds Bellville        

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