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

52 rows where "Foreign_Principal_Termination_Date" is on date 1989-12-31

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 6

City 1

  • - 52
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
16087 16087 1989-12-31 Embassy of the People's Republic of Mongolia 1990-04-03 MONGOLIA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
16088 16088 1989-12-31 Japan Iron & Steel Exporters' Association 1989-04-19 JAPAN Steptoe & Johnson, L.L.P. 3975 1987-05-08 Steptoe & Johnson, L.L.P. Tokyo        
16089 16089 1989-12-31 People's Committee for Libyan Students 1989-12-07 LIBYA Beveridge & Diamond, P.C. 4323 1989-12-07 Beveridge & Diamond, P.C. Falls Church     VA  
16090 16090 1989-12-31 People's Republic of Bangladesh 1984-08-01 BANGLADESH Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Dhaka        
16091 16091 1989-12-31 Aeroport de Paris 1982-06-08 FRANCE Russom & Leeper 3377 1982-06-08 Russom & Leeper          
16092 16092 1989-12-31 Aruba Tourist Bureau 1980-05-15 ARUBA Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. 3043 1979-07-23 Martin, Marshall, Jaccoma & Mitchell Advertising, Inc. Aruba        
16093 16093 1989-12-31 Asociacion de Productores de te de Misiones 1988-12-31 ARGENTINA Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Misiones        
16094 16094 1989-12-31 Aspitarte y Cia 1984-02-01 ARGENTINA Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Buenos Aires        
16095 16095 1989-12-31 Banco Latinoamericano de Exportaciones 1988-04-20 PANAMA Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP          
16096 16096 1989-12-31 Batam Industrial Development Authority 1986-06-01 INDONESIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC          
16097 16097 1989-12-31 Bazar San Jorge, S.A. (Rodolfo Zelaya)(Nicolas Cruz Torres) 1989-06-09 HONDURAS Reichler & Soble 3582 1984-05-09 Reichler & Soble Danli        
16098 16098 1989-12-31 Belgian National Tourist Office 1980-12-19 BELGIUM Jordan, McGrath, Case & Taylor, Inc. 3182 1980-12-19 Jordan, McGrath, Case & Taylor, Inc. New York     NY  
16099 16099 1989-12-31 Caisse des Depots et Consignations 1989-05-31 FRANCE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Paris        
16100 16100 1989-12-31 California Steel Industries, Inc. 1989-09-07 INTERNATIONAL Squire, Sanders & Dempsey, L.L.P. 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Fontana     CA  
16101 16101 1989-12-31 Casa Fuentes, S.A.C.I.F.I. 1984-02-01 ARGENTINA Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Buenos Aires        
16102 16102 1989-12-31 Central Bureau of Fruit & Vegetable Auctions in Holland 1987-03-24 NETHERLANDS Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC          
16103 16103 1989-12-31 Companhia de Navegacao Maritima NETUMAR 1988-11-18 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Rio de Janeiro        
16104 16104 1989-12-31 Convivencia Foundation 1989-03-09 ARGENTINA KRV International Group, Inc. 4177 1988-09-21 KRV International Group, Inc. Buenos Aires        
16105 16105 1989-12-31 Curacao Tourist Board 1987-09-04 CURACAO Lobsenz-Stevens, Inc. 3576 1984-04-27 Lobsenz-Stevens, Inc.       NY  
16106 16106 1989-12-31 Direccao Geral do Turismo 1968-06-12 PORTUGAL Heyward Associates, Inc. 1639 1963-06-12 Heyward Associates, Inc. Lisbon        
16107 16107 1989-12-31 Eitaro Itoyama 1989-08-23 JAPAN Black, Kelly, Scruggs & Healey 3600 1984-06-14 Black, Kelly, Scruggs & Healey Kawangoe City        
16108 16108 1989-12-31 Embassy of Bolivia 1989-10-12 BOLIVIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
16109 16109 1989-12-31 Embassy of Lebanon 1989-05-12 LEBANON Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP Washington     DC  
16110 16110 1989-12-31 Embassy of Lebanon 1989-07-17 LEBANON RCF Group 4273 1989-07-17 RCF Group Washington     DC  
16111 16111 1989-12-31 Establecimiento Las Marias, S.A. 1984-08-01 ARGENTINA Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Corrientes        
16112 16112 1989-12-31 F&C Management, Ltd. 1989-05-31 GREAT BRITAIN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC London        
16113 16113 1989-12-31 Federation Nationale des Travaux Publics 1989-05-31 FRANCE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Paris        
16114 16114 1989-12-31 Free Angola Information Service 1987-01-09 ANGOLA Government Relations International, Inc. 3929 1987-01-09 Government Relations International, Inc. Washington     DC  
16115 16115 1989-12-31 French Government, Ministry of Equipment, Port of Le Harve Authority 1976-07-22 FRANCE Port of Le Havre Authority 2710 1976-07-22 Port of Le Havre Authority Cedex        
16116 16116 1989-12-31 Frente Nacional de Libertacao de Angola 1984-04-05 ANGOLA Frente Nacional de Libertacao de Angola 3591 1984-04-05 Frente Nacional de Libertacao de Angola          
16117 16117 1989-12-31 German National Tourist Office 1987-09-22 GERMANY, FEDERAL REPUBLIC OF Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
16118 16118 1989-12-31 Government of Bermuda, Department of Tourism 1973-03-28 BERMUDA FCB New York 2415 1973-03-28 FCB New York Hamilton        
16119 16119 1989-12-31 Government of New South Wales 1959-09-25 AUSTRALIA New South Wales Government Office 1276 1959-09-25 New South Wales Government Office          
16120 16120 1989-12-31 Government of Saskatchewan 1989-05-31 CANADA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Saskatchewan        
16121 16121 1989-12-31 Green Forest Lumber, Ltd. 1989-05-04 CANADA Van Ness, Feldman & Curtis, P.C. 4085 1988-01-22 Van Ness, Feldman & Curtis, P.C. Ontario        
16122 16122 1989-12-31 Hong Kong Trade Development Council 1989-09-07 HONG KONG GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. New York     NY  
16123 16123 1989-12-31 Hong Kong Trade Development Council 1985-09-26 HONG KONG Hecht, Spencer & Associates, Inc. 3740 1985-09-26 Hecht, Spencer & Associates, Inc.          
16124 16124 1989-12-31 Japan External Trade Organization 1986-08-27 JAPAN Klein Partnership 3878 1986-08-27 Klein Partnership Houston     TX  
16125 16125 1989-12-31 Japan Tuna Fisheries Co-operative 1986-06-13 JAPAN Anderson & Pendleton, C.A. 2696 1976-06-09 Anderson & Pendleton, C.A. Tokyo        
16126 16126 1989-12-31 Korea Development Institute 1982-02-01 KOREA, SOUTH Korea Economic Institute 3327 1982-02-01 Korea Economic Institute Seoul        
16127 16127 1989-12-31 Messerschmitt-Bolkow-Blohm (American), Inc. 1970-11-05 GERMANY, FEDERAL REPUBLIC OF Taussig-Tomb & Associates 2217 1970-11-05 Taussig-Tomb & Associates Munich        
16128 16128 1989-12-31 Military Authorities of the Army of Suriname 1989-04-10 SURINAME van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd.          
16129 16129 1989-12-31 Ministry for Foreign Affairs, Finland 1988-02-19 FINLAND Haworth, James David Stewart 4090 1988-02-19 Haworth, James David Stewart Helsinki        
16130 16130 1989-12-31 Ministry of Trade and Industry Republic of the Philippines 1989-03-02 PHILIPPINES CHACMA, Inc. 4020 1987-08-03 CHACMA, Inc. Makati, Metro Manila        
16131 16131 1989-12-31 Netherlands Industrial Commission 1982-06-15 NETHERLANDS Gavin Anderson Doremus & Company 3378 1982-06-15 Gavin Anderson Doremus & Company New York     NY  
16132 16132 1989-12-31 Office of Economic Development of the Canton of Fribourg 1988-08-05 SWITZERLAND Access Management Corporation 4167 1988-08-05 Access Management Corporation Fribourg        
16133 16133 1989-12-31 Olympia & York Developments, Ltd. 1980-06-13 CANADA Williams & Jensen, P.C. 3112 1980-06-13 Williams & Jensen, P.C. Ontario        
16134 16134 1989-12-31 Tomen Electronics Corporation 1990-06-29 JAPAN Sedam & Emerson, a Professional Corporation 4049 1987-10-14 Sedam & Emerson, a Professional Corporation Tokyo        
16135 16135 1989-12-31 UNPH (Confederation of Mexican Fruit & Vegetable Growers Association) 1989-03-27 MEXICO Donald G. Lerch, Jr. & Company, Inc. 2089 1968-04-22 Donald G. Lerch, Jr. & Company, Inc. Leandro Valle Centro        
16136 16136 1989-12-31 Venezuela - Ministry of the Presidency 1989-10-02 VENEZUELA Kaplan, Russin & Vecchi 4092 1988-02-11 Kaplan, Russin & Vecchi Caracas        
16137 16137 1989-12-31 Vitrocrisa Cristaleria, S.A. 1989-05-12 MEXICO BZS/Capitol Strategies, L.P. 4252 1989-05-12 BZS/Capitol Strategies, L.P. Monterrey        
16138 16138 1989-12-31 WINvest 1984-01-23 GREAT BRITAIN Mathews & Clark Communications, Inc. 3554 1984-01-23 Mathews & Clark Communications, Inc.          

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