FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where "Foreign_Principal_Registration_Date" is on date 1988-08-18 and Registration_Number = 4170
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 29
- ADIG-Investment GmbH 1
- Alexanders Laing & Cruickshank 1
- Bograin, S.A. 1
- Caisse des Depots et Consignations 1
- Cartier International Cie 1
- Casino 1
- Centre National Pour la Promotion des Produits Agricole et Alimentaires (CNPA) 1
- Chanel Parfums 1
- Dresdnerbank Investment Management Kapitalanlagegesellschaft mbH 1
- European Investment Bank 1
- F&C Management, Ltd. 1
- Federation Nationale des Travaux Publics 1
- Friends' Provident Life Office 1
- General Biscuit Brands, Inc. 1
- Government of Alberta 1
- Groupe BSN 1
- Hachette, S.A. 1
- Havas 1
- Hitachi Research Institute 1
- Japan Trade Center 1
- Louis Dreyfus Company 1
- Office de Vulgarisation Pharmaceutique 1
- Phillips & Drew 1
- Promodes 1
- Public Affairs International 1
- SNA Canada, Inc. 1
- Scottish Equitable Life Assurance Society 1
- Sidamer Corporation 1
- Toyota 1
Country/Location_Represented 7
- FRANCE 15
- GREAT BRITAIN 4
- CANADA 3
- JAPAN 3
- GERMANY, FEDERAL REPUBLIC OF 2
- LUXEMBOURG 1
- SCOTLAND 1
Registrant_Name 1
City 1
- - 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6945 | 6945 | 1989-05-30 | Friends' Provident Life Office | 1988-08-18 | GREAT BRITAIN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | London | ||||
6946 | 6946 | 1989-05-30 | ADIG-Investment GmbH | 1988-08-18 | GERMANY, FEDERAL REPUBLIC OF | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Frankfurt | ||||
6947 | 6947 | 1989-05-30 | Alexanders Laing & Cruickshank | 1988-08-18 | GREAT BRITAIN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | London | ||||
6948 | 6948 | 1989-05-30 | Bograin, S.A. | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Guyancourt | ||||
6949 | 6949 | 1989-05-30 | Caisse des Depots et Consignations | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6950 | 6950 | 1989-05-30 | Cartier International Cie | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6951 | 6951 | 1989-05-30 | Casino | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6952 | 6952 | 1989-05-30 | Centre National Pour la Promotion des Produits Agricole et Alimentaires (CNPA) | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6953 | 6953 | 1989-05-30 | Chanel Parfums | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Victor Noir | ||||
6954 | 6954 | 1989-05-30 | Dresdnerbank Investment Management Kapitalanlagegesellschaft mbH | 1988-08-18 | GERMANY, FEDERAL REPUBLIC OF | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Frankfurt | ||||
6955 | 6955 | 1989-05-30 | European Investment Bank | 1988-08-18 | LUXEMBOURG | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Luxembourg-Kirchberg | ||||
6956 | 6956 | 1989-05-30 | F&C Management, Ltd. | 1988-08-18 | GREAT BRITAIN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | London | ||||
6957 | 6957 | 1989-05-30 | Federation Nationale des Travaux Publics | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6959 | 6959 | 1989-05-30 | General Biscuit Brands, Inc. | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Elizabeth | NJ | |||
6960 | 6960 | 1989-05-30 | Government of Alberta | 1988-08-18 | CANADA | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Edmonton, Alberta | ||||
6962 | 6962 | 1989-05-30 | Groupe BSN | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6963 | 6963 | 1989-05-30 | Hachette, S.A. | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6964 | 6964 | 1989-05-30 | Havas | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Neuilly Sur Seine | ||||
6965 | 6965 | 1989-05-30 | Hitachi Research Institute | 1988-08-18 | JAPAN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Tokyo | ||||
6966 | 6966 | 1989-05-30 | Japan Trade Center | 1988-08-18 | JAPAN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | New York | NY | |||
6967 | 6967 | 1989-05-30 | Louis Dreyfus Company | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6968 | 6968 | 1989-05-30 | Office de Vulgarisation Pharmaceutique | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Paris | ||||
6969 | 6969 | 1989-05-30 | Phillips & Drew | 1988-08-18 | GREAT BRITAIN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | London | ||||
6970 | 6970 | 1989-05-30 | Promodes | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Mondeville | ||||
6971 | 6971 | 1989-05-30 | Public Affairs International | 1988-08-18 | CANADA | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Ottawa, Ontario | ||||
6973 | 6973 | 1989-05-30 | SNA Canada, Inc. | 1988-08-18 | CANADA | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Ottawa | ||||
6974 | 6974 | 1989-05-30 | Scottish Equitable Life Assurance Society | 1988-08-18 | SCOTLAND | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Edinburgh | ||||
6975 | 6975 | 1989-05-30 | Sidamer Corporation | 1988-08-18 | FRANCE | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | New York | NY | |||
6976 | 6976 | 1989-05-30 | Toyota | 1988-08-18 | JAPAN | Government Research Corporation 4170 | 1988-08-18 | Government Research Corporation | Tokyo |
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]) );