FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Registrant_Name = "Hill and Knowlton Strategies, LLC" and State = "VA" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Registrant_Date (date)
Foreign_Principal_Termination_Date (date) 9 ✖
- 1981-11-30 1
- 1983-02-09 1
- 1986-06-11 1
- 1987-09-01 1
- 1988-10-31 1
- 1994-06-10 1
- 1995-12-31 1
- 1998-06-30 1
- 1999-11-01 1
Foreign_Principal_Registration_Date (date) 9 ✖
- 1981-11-24 1
- 1982-12-30 1
- 1985-04-10 1
- 1989-02-16 1
- 1989-05-31 1
- 1989-06-09 1
- 1995-05-08 1
- 1995-06-02 1
- 1997-11-24 1
Foreign_Principal 9
- ADIG-Investment GmbH 1
- Babak Farzaneh 1
- International Reporting Information Systems (IRIS) 1
- Italian Aerospace Industries, Inc., a Subsidiary of Aeritalia, S.A.I.P.A. 1
- Konimklijke Luchtvaart Maatschappij, N.V. (KLM) 1
- Matra Aerospace, Inc. 1
- Republic of Liberia, Embassy 1
- Royal Ordnance, U.S.A. 1
- Short Brothers 1
Country/Location_Represented 8
- LIBERIA 2
- FRANCE 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- IRAN 1
- ITALY 1
- NETHERLANDS 1
- NORTHERN IRELAND 1
State 1
- VA · 9 ✖
Registrant_Name 1
- Hill and Knowlton Strategies, LLC · 9 ✖
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14358 | 14358 | 1981-11-30 | Italian Aerospace Industries, Inc., a Subsidiary of Aeritalia, S.A.I.P.A. | 1981-11-24 | ITALY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Arlington | VA | |||
2318 | 2318 | 1983-02-09 | International Reporting Information Systems (IRIS) | 1982-12-30 | INTERNATIONAL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Arlington | VA | |||
7746 | 7746 | 1986-06-11 | Babak Farzaneh | 1985-04-10 | IRAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | McLean | VA | |||
11264 | 11264 | 1987-09-01 | Royal Ordnance, U.S.A. | 1989-02-16 | GREAT BRITAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Alexandria | VA | |||
13246 | 13246 | 1988-10-31 | ADIG-Investment GmbH | 1989-05-31 | LIBERIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Reston | VA | |||
7735 | 7735 | 1994-06-10 | Matra Aerospace, Inc. | 1989-06-09 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Arlington | VA | |||
8572 | 8572 | 1998-06-30 | Konimklijke Luchtvaart Maatschappij, N.V. (KLM) | 1995-05-08 | NETHERLANDS | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Reston | VA | |||
16368 | 16368 | 1995-12-31 | Short Brothers | 1995-06-02 | NORTHERN IRELAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Arlington | VA | |||
13618 | 13618 | 1999-11-01 | Republic of Liberia, Embassy | 1997-11-24 | LIBERIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Reston | VA |
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]) );