home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

32 rows where Registrant_Name = "Hill & Knowlton, Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Japan Trade Center 2
  • Aeromexico 1
  • Asbestos Institute 1
  • Australian Information Service, Australian Embassy 1
  • Austrian Trade Commission 1
  • Batam Industrial Development Authority 1
  • Batam Island Development Authority 1
  • Canadian Forest Industries Council 1
  • Canadian Softwood Lumber Committee 1
  • Comite de Exportadores Textiles de la Sociedad de Industrias 1
  • Daewoo International Corporation 1
  • Euromissile 1
  • Fondo Nacional de Fomento al Turismo 1
  • Government of Gabon 1
  • Government of Morocco 1
  • Government of the Netherlands 1
  • Guatemala Tourist Commission 1
  • His Excellency Jose Llado Ambassador of Spain 1
  • Hong Kong Tourist Association 1
  • Hoteles El Presidente 1
  • JETRO (Japan External Trade Organization) 1
  • Japan Trade Center, Houston (Japan External Trade Organization, Dallas) 1
  • Korean Traders' Association 1
  • Messerschmitt-Bolkow-Blohm GmbH 1
  • Mexican Government Tourism Office (Consejo Nacional de Turismo) 1
  • National Development Information Office of the Republic of Indonesia 1
  • Republic of Indonesia 1
  • Republic of Turkey 1
  • Royal Ordnance, U.S.A. 1
  • Saskatchewan Economic Development & Trade 1
  • …

Country/Location_Represented 18

  • JAPAN 5
  • CANADA 4
  • INDONESIA 4
  • MEXICO 4
  • KOREA, SOUTH 2
  • AUSTRALIA 1
  • AUSTRIA 1
  • FRANCE 1
  • GABON 1
  • GERMANY, FEDERAL REPUBLIC OF 1
  • GUATEMALA 1
  • HONG KONG 1
  • MOROCCO 1
  • NETHERLANDS 1
  • PERU 1
  • SPAIN 1
  • TURKEY 1
  • UNITED KINGDOM 1

State 6

  • - 20
  • DC 4
  • NY 4
  • TX 2
  • FL 1
  • VA 1

Registrant_Name 1

  • Hill & Knowlton, Inc. · 32 ✖

City 1

  • - 32
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
2549 2549 1979-02-15 Government of Morocco 1977-11-18 MOROCCO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Washington     DC  
3765 3765 1984-03-15 Republic of Turkey 1982-07-23 TURKEY Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Ankara        
4354 4354 1976-03-31 Korean Traders' Association 1975-04-07 KOREA, SOUTH Hill & Knowlton, Inc. 2574 1975-04-07 Hill & Knowlton, Inc. New York     NY  
5816 5816 1982-04-30 Japan Trade Center 1982-01-28 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. New York     NY  
5820 5820 1984-04-30 Government of Gabon 1984-03-21 GABON Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Libreville        
6178 6178 1982-05-01 Australian Information Service, Australian Embassy 1981-03-05 AUSTRALIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Washington     DC  
6623 6623 1981-05-17 His Excellency Jose Llado Ambassador of Spain 1981-01-30 SPAIN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Washington     DC  
6765 6765 1983-05-24 Canadian Softwood Lumber Committee 1983-02-24 CANADA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Vancouver        
9991 9991 1984-08-01 Batam Island Development Authority 1984-05-02 INDONESIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Jakarta        
9993 9993 1984-08-01 Hoteles El Presidente 1984-04-13 MEXICO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
10968 10968 1983-08-31 Government of the Netherlands 1978-07-25 NETHERLANDS Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. The Hague        
11813 11813 1978-09-25 Japan Trade Center, Houston (Japan External Trade Organization, Dallas) 1978-08-03 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Dallas     TX  
11942 11942 1977-09-30 Republic of Indonesia 1976-12-17 INDONESIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Jakarta        
11947 11947 1979-09-30 JETRO (Japan External Trade Organization) 1979-08-08 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Dallas     TX  
12923 12923 1986-10-22 Asbestos Institute 1986-07-09 CANADA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Montreal, Quebec        
12924 12924 1986-10-22 Batam Industrial Development Authority 1986-09-19 INDONESIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Jakarta        
12925 12925 1986-10-22 Canadian Forest Industries Council 1985-04-25 CANADA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Vancouver        
12926 12926 1986-10-22 Daewoo International Corporation 1984-01-06 KOREA, SOUTH Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Washington     DC  
12927 12927 1986-10-22 Euromissile 1983-05-05 FRANCE Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
12928 12928 1986-10-22 Fondo Nacional de Fomento al Turismo 1983-12-02 MEXICO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
12929 12929 1986-10-22 Hong Kong Tourist Association 1980-08-20 HONG KONG Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
12930 12930 1986-10-22 Japan Trade Center 1984-08-31 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. New York     NY  
12931 12931 1986-10-22 Messerschmitt-Bolkow-Blohm GmbH 1984-01-12 GERMANY, FEDERAL REPUBLIC OF Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
12932 12932 1986-10-22 Mexican Government Tourism Office (Consejo Nacional de Turismo) 1983-12-02 MEXICO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc.          
12933 12933 1986-10-22 National Development Information Office of the Republic of Indonesia 1977-07-08 INDONESIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Jakarta        
12934 12934 1986-10-22 Royal Ordnance, U.S.A. 1986-05-30 UNITED KINGDOM Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Alexandria     VA  
12935 12935 1986-10-22 Toyo Kogyo, Ltd. 1984-01-03 JAPAN Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Hiroshima        
13226 13226 1982-10-31 Austrian Trade Commission 1981-04-22 AUSTRIA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. New York     NY  
13238 13238 1984-10-31 Saskatchewan Economic Development & Trade 1984-10-12 CANADA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Regina        
15127 15127 1982-12-15 Comite de Exportadores Textiles de la Sociedad de Industrias 1982-12-30 PERU Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Lima        
15130 15130 1984-12-15 Aeromexico 1984-05-25 MEXICO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Miami     FL  
15898 15898 1983-12-31 Guatemala Tourist Commission 1982-11-29 GUATEMALA Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, 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])
);
Powered by Datasette · Queries took 171.897ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history