FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where Address_1 = "" and "Registrant_Date" is on date 1981-11-10
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal >30
- AgustaWestland S.P.A. 1
- Airbus Industrie of North America, Inc. 1
- Ascoloflores 1
- AsiaSat Satellite Telecommunications Company, Ltd. 1
- Batam Industrial Development Authority 1
- Bermuda Department of Tourism 1
- Brother Industries, Ltd. 1
- Bureau National Interprofessional de Cognac 1
- Central Bureau of Fruit & Vegetable Auctions in Holland 1
- China Media Services, Inc. 1
- Egyptian Government Ministry of Tourism 1
- Electronics Industries Association of Korea 1
- FONATUR 1
- Fisheries Council of Canada 1
- Fougerolle 1
- Government of Antigua & Barbuda 1
- Government of Canada 1
- Government of Iceland, Ministry of Foreign Affairs 1
- Government of the Cayman Islands 1
- Hitachi, Ltd. 1
- Hong Kong Economic & Trade Office 1
- Hong Kong Tourist Association 1
- Hyundai 1
- Liberal Democratic Federation of Hong Kong, Ltd. 1
- Malaysian Airline System 1
- Marubeni America Corporation 1
- Mexican Government Tourism Office (Consejo Nacional de Turismo) 1
- Minpeco, S.A. 1
- National Sea Products, Ltd. 1
- Princess Haya Bint AI Hussein 1
- …
Country/Location_Represented 24
- HONG KONG 5
- FRANCE 4
- JAPAN 4
- CANADA 3
- KOREA, SOUTH 3
- GERMANY, FEDERAL REPUBLIC OF 2
- MEXICO 2
- ANTIGUA & BARBUDA 1
- BERMUDA 1
- CAYMAN ISLANDS 1
- CHINA 1
- COLOMBIA 1
- EGYPT 1
- ICELAND 1
- INDONESIA 1
- ITALY 1
- MALAYSIA 1
- NETHERLANDS 1
- PERU 1
- POLAND 1
- SWEDEN 1
- UKRAINE 1
- UNITED ARAB EMIRATES 1
- YUGOSLAVIA 1
Registrant_Name 1
City 1
- - 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
691 | 691 | The Government of Ukraine, The Ministry of Culture and Information Policy through GroupM Sp z.o.o. | 2022-08-19 | UKRAINE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | ||||||
1719 | 1719 | 1986-01-31 | Government of the Cayman Islands | 1985-04-04 | CAYMAN ISLANDS | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
2021 | 2021 | 1987-02-01 | Ascoloflores | 1986-09-01 | COLOMBIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
2027 | 2027 | 1987-02-01 | State of Baden-Wuerttemberg | 1986-05-16 | GERMANY, FEDERAL REPUBLIC OF | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
2975 | 2975 | 1991-02-28 | Yugoslav National Tourist Office | 1988-02-22 | YUGOSLAVIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
3059 | 3059 | 2003-02-28 | Hong Kong Economic & Trade Office | 2001-04-17 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
3544 | 3544 | 1987-03-09 | Hyundai | 1985-11-01 | KOREA, SOUTH | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
3602 | 3602 | 1987-03-11 | Soule' | 1986-06-19 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
3995 | 3995 | 1988-03-23 | National Sea Products, Ltd. | 1987-05-01 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
4118 | 4118 | 1988-03-28 | Government of Canada | 1988-02-18 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
4475 | 4475 | 1990-03-31 | Bureau National Interprofessional de Cognac | 1987-01-01 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
4481 | 4481 | 1990-03-31 | Electronics Industries Association of Korea | 1987-01-12 | KOREA, SOUTH | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
5845 | 5845 | 1989-04-30 | FONATUR | 1983-11-23 | MEXICO | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
6072 | 6072 | 2013-04-30 | AgustaWestland S.P.A. | 2013-04-05 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
6565 | 6565 | 1990-05-15 | Bermuda Department of Tourism | 1984-11-01 | BERMUDA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
6903 | 6903 | 1986-05-29 | Government of Antigua & Barbuda | 1986-01-13 | ANTIGUA & BARBUDA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
6977 | 6977 | 1990-05-30 | Brother Industries, Ltd. | 1987-05-15 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
7061 | 7061 | 1987-05-31 | Malaysian Airline System | 1987-06-03 | MALAYSIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
7412 | 7412 | 1990-06-01 | Yuen Chow International Finance Company, Ltd. | 1989-10-25 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
7705 | 7705 | 1994-06-09 | Government of Iceland, Ministry of Foreign Affairs | 1986-10-02 | ICELAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
7727 | 7727 | 1992-06-10 | Liberal Democratic Federation of Hong Kong, Ltd. | 1991-05-29 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
8444 | 8444 | 1989-06-30 | Mexican Government Tourism Office (Consejo Nacional de Turismo) | 1987-07-13 | MEXICO | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
9748 | 9748 | 1988-07-31 | Hong Kong Tourist Association | 1980-08-14 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
9754 | 9754 | 1989-07-31 | AsiaSat Satellite Telecommunications Company, Ltd. | 1989-07-21 | HONG KONG | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
11271 | 11271 | 1989-09-01 | Airbus Industrie of North America, Inc. | 1984-09-19 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
11510 | 11510 | 1987-09-11 | Fisheries Council of Canada | 1987-05-06 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
11655 | 11655 | 1999-09-15 | Marubeni America Corporation | 1988-02-24 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
13864 | 13864 | 1987-11-10 | China Media Services, Inc. | 1986-01-31 | CHINA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14078 | 14078 | 1987-11-19 | Minpeco, S.A. | 1987-11-20 | PERU | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14364 | 14364 | 1984-11-30 | Fougerolle | 1983-12-02 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14563 | 14563 | 2016-11-30 | Princess Haya Bint AI Hussein | 2012-01-25 | UNITED ARAB EMIRATES | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14727 | 14727 | 2015-12-01 | Egyptian Government Ministry of Tourism | 2015-01-11 | EGYPT | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14743 | 14743 | 2022-12-01 | V.S. VisitSweden AE (VisitSweden) through Hill+Knowlton Strategies Stockholm | 2022-08-31 | SWEDEN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
14923 | 14923 | 1994-12-09 | Republic of Poland's Ministry of Finance | 1994-03-04 | POLAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
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 | ||||
15889 | 15889 | 1982-12-31 | Thyssen Nordseewerke GmbH | 1982-02-05 | GERMANY, FEDERAL REPUBLIC OF | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
16020 | 16020 | 1987-12-31 | Republic of Korea | 1984-01-31 | KOREA, SOUTH | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | |||||
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 | |||||
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 | |||||
16522 | 16522 | 2002-12-31 | Hitachi, Ltd. | 1987-03-30 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC |
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]) );