FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Registrant_Name = "Hill and Knowlton Strategies, LLC" and State = "NY"
This data as json, CSV (advanced)
Foreign_Principal 15
- Adnan Khashoggi 1
- Egyptian Tourist Authority 1
- German National Tourist Office 1
- Hitachi America, Ltd. 1
- Japan External Trade Relations Organization 1
- National Media Production Center (Philippines) 1
- National Tourist Office of Spain 1
- Netherlands Board of Tourism 1
- Permanent Mission of Kuwait to the United Nations 1
- Republic of Uzbekistan 1
- Salen Dry Cargo, Inc. 1
- Sanwa Bank, Ltd. 1
- Sidamer Corporation 1
- Turkish Tourism Information Office 1
- UK Trade and Investment USA 1
Country/Location_Represented 13
- JAPAN 3
- EGYPT 1
- FRANCE 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GREAT BRITAIN 1
- KUWAIT 1
- NETHERLANDS 1
- PHILIPPINES 1
- SAUDI ARABIA 1
- SPAIN 1
- SWEDEN 1
- TURKEY 1
- UZBEKISTAN 1
State 1
- NY · 15 ✖
Registrant_Name 1
- Hill and Knowlton Strategies, LLC · 15 ✖
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7652 | 7652 | 1991-06-07 | Japan External Trade Relations Organization | 1989-05-31 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
9426 | 9426 | 1988-07-22 | Hitachi America, Ltd. | 1985-06-21 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Tarrytown | NY | |||
9749 | 9749 | 1988-07-31 | National Tourist Office of Spain | 1987-06-18 | SPAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
12373 | 12373 | 1991-10-01 | Permanent Mission of Kuwait to the United Nations | 1991-09-20 | KUWAIT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
13235 | 13235 | 1983-10-31 | National Media Production Center (Philippines) | 1983-09-28 | PHILIPPINES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
13972 | 13972 | 1984-11-15 | Salen Dry Cargo, Inc. | 1984-04-17 | SWEDEN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
14397 | 14397 | 1989-11-30 | Sidamer Corporation | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
14949 | 14949 | 1992-12-10 | Netherlands Board of Tourism | 1992-02-26 | NETHERLANDS | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
14951 | 14951 | 1992-12-10 | Sanwa Bank, Ltd. | 1988-03-31 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | NY | ||||
14960 | 14960 | 1993-12-10 | Egyptian Tourist Authority | 1991-04-08 | EGYPT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
14984 | 14984 | 1993-12-10 | Republic of Uzbekistan | 1993-09-28 | UZBEKISTAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
15045 | 15045 | 1986-12-12 | Adnan Khashoggi | 1984-05-04 | SAUDI ARABIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
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 | |||
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 | |||
16626 | 16626 | 2007-12-31 | UK Trade and Investment USA | 2005-01-07 | GREAT BRITAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 845 Third Avenue | NY |
Advanced export
JSON shape: default, array, newline-delimited
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]) );