FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Foreign_Principal_Termination_Date = "1989-11-30"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 16
- Gesamtverband der Deutschen Versicherungswirtschaft e. V. 2
- Asia Satellite Telecommunications, Hong Kong, Ltd. 1
- Bongrain, S.A. 1
- Cartier International Cie 1
- Casino 1
- Centre National Pour la Promotion des Produits Agricole et Alimentaires (CnPA) 1
- Chanel Parfums 1
- Embassy of Canada 1
- Friends' Provident Life Office 1
- Groupe BSN 1
- Hitachi America, Ltd. 1
- Louis Dreyfus Company 1
- Phillips & Drew 1
- Siciliana Appalti Costruzioni 1
- Sidamer Corporation 1
- Stelco, Inc. 1
Registrant_Name 7
Country/Location_Represented 7
- FRANCE 8
- CANADA 2
- GERMANY, FEDERAL REPUBLIC OF 2
- GREAT BRITAIN 2
- HONG KONG 1
- ITALY 1
- JAPAN 1
City 1
- - 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14382 | 14382 | 1989-11-30 | Friends' Provident Life Office | 1989-05-31 | GREAT BRITAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | London | ||||
14383 | 14383 | 1989-11-30 | Asia Satellite Telecommunications, Hong Kong, Ltd. | 1988-07-27 | HONG KONG | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Wanchai | ||||
14384 | 14384 | 1989-11-30 | Bongrain, S.A. | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Guyancourt | ||||
14385 | 14385 | 1989-11-30 | Cartier International Cie | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Paris | ||||
14386 | 14386 | 1989-11-30 | Casino | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Paris | ||||
14387 | 14387 | 1989-11-30 | Centre National Pour la Promotion des Produits Agricole et Alimentaires (CnPA) | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Paris | ||||
14388 | 14388 | 1989-11-30 | Chanel Parfums | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Victor Noir | ||||
14389 | 14389 | 1989-11-30 | Embassy of Canada | 1981-11-20 | CANADA | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | Washington | DC | |||
14390 | 14390 | 1989-11-30 | Gesamtverband der Deutschen Versicherungswirtschaft e. V. | 1990-07-31 | GERMANY, FEDERAL REPUBLIC OF | Levine & Company 3971 | 1987-04-29 | Levine & Company | |||||
14391 | 14391 | 1989-11-30 | Gesamtverband der Deutschen Versicherungswirtschaft e. V. | 1991-11-18 | GERMANY, FEDERAL REPUBLIC OF | Levine & Company 3971 | 1987-04-29 | Levine & Company | |||||
14392 | 14392 | 1989-11-30 | Groupe BSN | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Paris | ||||
14393 | 14393 | 1989-11-30 | Hitachi America, Ltd. | 1987-09-25 | JAPAN | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Tarrytown | NY | |||
14394 | 14394 | 1989-11-30 | Louis Dreyfus Company | 1989-05-31 | FRANCE | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Paris | ||||
14395 | 14395 | 1989-11-30 | Phillips & Drew | 1989-05-31 | GREAT BRITAIN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | London | ||||
14396 | 14396 | 1989-11-30 | Siciliana Appalti Costruzioni | 1989-10-30 | ITALY | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Catania | ||||
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 | |||
14398 | 14398 | 1989-11-30 | Stelco, Inc. | 1984-05-09 | CANADA | Allan, John D. 3585 | 1984-05-09 | Allan, John D. | Toronto, Ontario |
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]) );