FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where "Foreign_Principal_Registration_Date" is on date 1988-08-18
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal >30
- ADIG-Investment GmbH 1
- Air China International Corporation, Ltd. 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
- Kenya Tourist Board 1
- Louis Dreyfus Company 1
- Nedlloyd Lijnen, B.V. 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
- …
Country/Location_Represented 10
- FRANCE 15
- GREAT BRITAIN 4
- CANADA 3
- JAPAN 3
- GERMANY, FEDERAL REPUBLIC OF 2
- CHINA 1
- KENYA 1
- LUXEMBOURG 1
- NETHERLANDS 1
- SCOTLAND 1
Registrant_Name 4
City 1
- - 32
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2405 | 2405 | 1988-02-12 | Kenya Tourist Board | 1988-08-18 | KENYA | Klinger Group 4004 | 1987-07-07 | Klinger Group | |||||
| 5099 | 5099 | 1992-04-08 | Air China International Corporation, Ltd. | 1988-08-18 | CHINA | Washington, Perito & Dubuc 4107 | 1988-03-21 | Washington, Perito & Dubuc | Beijing | ||||
| 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 | ||||
| 9043 | 9043 | 1989-07-06 | Nedlloyd Lijnen, B.V. | 1988-08-18 | NETHERLANDS | Benner, Burnett & Coleman 3654 | 1985-03-07 | Benner, Burnett & Coleman | Rotterdam |
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]) );