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

67 rows where "Registrant_Date" is on date 1986-02-05

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 5

Registrant_Name 1

City 1

  • - 67
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
1783 1783 1995-01-31 C.W. Agencies, Inc. 1995-09-06 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Vancouver, B.C.        
1811 1811 1997-01-31 World Cup Japan 2002 Bidding Committee Secretariat 1995-09-06 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
1834 1834 2001-01-31 Government of Iceland 1999-09-07 ICELAND Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Prime Minister's Office IS-150 Reykjavik Iceland Contact: Skarphendinn Berg Steinarsson        
2054 2054 1996-02-01 ILVA Ceramica, S.A. 1995-09-06 ARGENTINA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Buenos Aires        
2223 2223 1996-02-05 Industrial Development Board of Northern Ireland 1993-09-07 NORTHERN IRELAND Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Belfast        
2987 2987 1992-02-28 Korea Foreign Trade Association 1991-05-30 KOREA, SOUTH Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Seoul        
3053 3053 2002-02-28 Tyumen Oil Company 2000-03-10 RUSSIA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 18/2 Schipok Street Moscow 113093 Russian Federation        
3060 3060 2003-02-28 Ilim Pulp Enterprises 2002-09-12 RUSSIA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 17 Marata Street, St. Petersburg        
3302 3302 1991-03-01 Syndicat Mixte de Protecion et de Conservation du Littoral du Nord-Ouest de la Bretagne 1991-03-07 FRANCE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Ploudalmezeau        
3304 3304 1992-03-01 International Business Communications, Inc. 1990-10-30 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
3306 3306 1992-03-01 Secretaria de Turismo de Mexico 1991-03-07 MEXICO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Mexico City        
3329 3329 2002-03-01 Pakistan Textile & Apparel Group 2002-03-28 PAKISTAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. c/o Aleema Khan Cotton Connection (PVT) Ltd. 29-C Main Gulberg Lahore        
3440 3440 1994-03-04 Bombardier Corporation 1993-09-07 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Montreal, Quebec        
3441 3441 1994-03-04 China International Travel Service (CITS) 1993-09-07 CHINA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Beijing        
3442 3442 1994-03-04 Fletcher Challenge Finance Canada, Ltd. 1991-03-07 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Ontario        
3443 3443 1994-03-04 Grupo Financiero Bancomer 1992-09-04 MEXICO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
3444 3444 1994-03-04 MTC Electronic Technologies Company, Ltd. 1993-09-07 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Richmond, BC        
3445 3445 1994-03-04 Pacific Millenium Company, Ltd. 1994-03-04 HONG KONG Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Kowloon        
3446 3446 1994-03-04 Star T.V. 1993-03-05 HONG KONG Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
3458 3458 1992-03-05 Singapore Airlines 1991-03-07 SINGAPORE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
4558 4558 1997-03-31 Royal Norwegian Government, Embassy 1997-03-06 NORWAY Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Washington     DC  
4575 4575 1999-03-31 Canadair: Division of Bombardier, Inc. 1995-03-06 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Quebec        
5235 5235 2000-04-12 Superintendencia de Bancos del Ecuador 2000-03-10 ECUADOR Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. c/o Opinion & Imagen Urb. Sta. Leonor Mz.11 Edif. Veritas, via terminal terrestre Guayaquil,        
5308 5308 2003-04-15 El Consejo de Promocion Turistica de Mexico 2001-03-14 MEXICO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Mariano Escobedo, numero 550 5th Floor, Colonia Anzures Delegacion Miguel Hidalgo Mexico City 11590        
5858 5858 1990-04-30 Newscan Company, Ltd. 1988-03-03 HONG KONG Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
6207 6207 1991-05-01 Diasyn Technologies, Ltd. 1991-09-05 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Ontario        
6981 6981 1991-05-30 Meitec Corporation 1991-05-17 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Nagoya        
7153 7153 1996-05-31 Embassy of South Africa 1996-04-24 SOUTH AFRICA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Washington     DC  
7154 7154 1996-05-31 Government of Angola 1995-01-25 ANGOLA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Luanda        
7156 7156 1996-05-31 Government of Qatar, Embassy 1996-03-29 QATAR Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Washington     DC  
7188 7188 2002-05-31 European Aeronautic Space and Defense Company (EADS) 2001-03-14 INTERNATIONAL Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. EADS NV Drentastraat 24 1083 HK Amsterdam        
8425 8425 1988-06-30 Government of Spain, Embassy 1988-01-19 SPAIN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Washington     DC  
8914 8914 2000-07-01 Suez Lyonnaise des Eaux 1999-03-05 FRANCE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Paris        
9795 9795 1992-07-31 Acapulco Tourist Promotion Mixed Fund 1991-09-05 MEXICO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Septimo Piso        
9841 9841 2002-07-31 Republic of Chile 2001-09-07 CHILE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Minsterio de Relaciones Exteriores Catedral 1158, Piso 3 Chile        
10152 10152 2004-08-05 Embassy of Rwanda 2003-09-22 RWANDA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 1714 New Hampshire Avenue, N.W. 20009     DC  
10153 10153 2004-08-05 Hong Kong Trade Development Council c/o Hong Kong Economic and Trade Office 2002-09-12 HONG KONG Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 38/F Office Tower, Convention Plaza, 1 Harbour Road, Wan Chai        
10154 10154 2004-08-05 Singapore Economic Development Board 2003-09-22 SINGAPORE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 250 North Bridge Road #24-00 Raffles City Tower Singapore 179101        
10535 10535 1997-08-15 Bureau Etudes Vision Stockplus 1997-09-04 MOROCCO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tangiers        
10713 10713 1994-08-24 Osman Dogangun, Deputy Undersecretary for Foreign Trade 1993-10-20 TURKEY Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Ankara        
11084 11084 2003-08-31 National Investment Promotion Commission (PRO.ESA) 2001-09-07 EL SALVADOR Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Calle Circunvalacion No. 248 Colonia San Benito San Salvador        
11405 11405 1993-09-07 China National Tourism Administration 1991-11-19 CHINA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Beijing        
11406 11406 1993-09-07 Grand Metropolitan, PLC 1993-09-07 GREAT BRITAIN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. London        
11407 11407 1993-09-07 Grindsted Products 1993-03-05 DENMARK Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Braband        
11408 11408 1993-09-07 Honda Motor Company, Ltd. 1990-12-10 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
11409 11409 1993-09-07 Horsham Corporation/Clark Oil & Refinery Corporation 1993-03-05 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Toronto, Ontario        
11412 11412 1993-09-07 Lehman Brothers/Government of Sweden 1993-03-05 SWEDEN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. New York City     NY  
11413 11413 1993-09-07 Li & Fung Trading, Ltd. 1993-03-05 HONG KONG Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Kowloon        
11415 11415 1993-09-07 MTC Animal Health (Maple Leaf Foods, Inc.) 1992-03-05 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Ontario        
11416 11416 1993-09-07 Novo Nordisk, A.S. 1992-03-18 DENMARK Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Novo Alle        
11417 11417 1993-09-07 Tokyu Agency, Inc. 1987-04-05 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
11715 11715 1990-09-19 Shintaro Ishihara 1990-01-12 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tokyo        
12014 12014 1989-09-30 United Advertising Company 1988-03-03 TAIWAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Taiwan        
12016 12016 1990-09-30 Chilean Exporters' Association 1989-11-24 CHILE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Santiago        
12022 12022 1990-09-30 Korea Foreign Trade Association 1990-05-10 KOREA, SOUTH Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Seoul        
12024 12024 1990-09-30 Nara Advertising, Inc. 1988-03-03 KOREA, SOUTH Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Seoul        
12027 12027 1990-09-30 Ricoh Electronics, Inc. 1988-09-01 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Tustin     CA  
12387 12387 2000-10-01 Bermuda International Business Association 2000-03-10 BERMUDA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Century House 16 Par-la-ville Road Hamilton HMO8        
13162 13162 1987-10-30 Camp Associates Advertising, Ltd. 1986-02-05 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
13164 13164 1987-10-30 JETRO, Los Angeles 1986-09-05 JAPAN Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Los Angeles     CA  
13375 13375 1998-10-31 Business Location Germany 1997-05-05 GERMANY Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Chicago     IL  
13376 13376 1998-10-31 Electricite de France 1992-03-05 FRANCE Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Paris        
14413 14413 1990-11-30 Government of Mexico, Ministry of Commerce 1989-09-05 MEXICO Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc.          
14462 14462 1996-11-30 APEC Foundation of the Philippines, Inc. (Asia-Pacific Economic Cooperation) 1996-07-15 PHILIPPINES Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Makati        
14469 14469 1997-11-30 Canadian National Railway 1995-09-06 CANADA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Montreal, Quebec        
14471 14471 1997-11-30 Government of Turkey, Embassy 1994-06-09 TURKEY Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Washington     DC  
15150 15150 1999-12-15 Panama ARI/Autoridad de la Region Interoceanica 1999-03-05 PANAMA Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Apartado No. 2097 Balboa, Ancon, Republic de Panama        

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