FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Foreign_Principal_Termination_Date = "1996-04-30"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 8
Foreign_Principal 8
Country/Location_Represented 8
- AZERBAIJAN 1
- BERMUDA 1
- HAITI 1
- JAPAN 1
- MEXICO 1
- NORWAY 1
- SAINT LUCIA 1
- ST. KITTS AND NEVIS 1
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5950 | 5950 | 1996-04-30 | Centre Reinsurance (Bermuda), Ltd. | 1994-08-04 | BERMUDA | Baker & Hostetler 4371 | 1990-04-30 | Baker & Hostetler | Hamilton | ||||
5951 | 5951 | 1996-04-30 | Government of Haiti, Embassy | 1993-02-22 | HAITI | International Liaison Office, Inc. 4767 | 1993-02-22 | International Liaison Office, Inc. | Washington | DC | |||
5952 | 5952 | 1996-04-30 | Government of St. Kitts & Nevis | 1996-08-26 | ST. KITTS AND NEVIS | Prince, Leslie F. 4238 | 1989-04-17 | Prince, Leslie F. | |||||
5953 | 5953 | 1996-04-30 | Japan Federation of Economic Organizations (Keidanren) | 1991-03-19 | JAPAN | Japan Federation of Economic Organizations (Keidanren) 4487 | 1991-03-19 | Japan Federation of Economic Organizations (Keidanren) | Tokyo | ||||
5954 | 5954 | 1996-04-30 | Mexican Investment Board | 1996-05-08 | MEXICO | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Mexico City | ||||
5955 | 5955 | 1996-04-30 | Norcom Networks Corporation | 1995-12-22 | NORWAY | Rockey Company, Inc. 4594 | 1991-11-14 | Rockey Company, Inc. | Bellevue | WA | |||
5956 | 5956 | 1996-04-30 | Republic of Azerbaijan | 1994-10-14 | AZERBAIJAN | Azerbaijan Study Foundation 4964 | 1994-10-14 | Azerbaijan Study Foundation | Baku | ||||
5957 | 5957 | 1996-04-30 | St. Lucia Tourist Board | 1993-08-17 | SAINT LUCIA | Marcella Martinez Associates, Inc. 4349 | 1990-03-09 | Marcella Martinez Associates, Inc. | Castries |
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]) );