FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Registrant_Name = "Garrett & Company" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date)
Foreign_Principal_Registration_Date (date) 9 ✖
- 1990-07-12 2
- 1983-02-03 1
- 1984-08-06 1
- 1989-08-11 1
- 1990-07-25 1
- 1991-05-07 1
- 1992-04-23 1
- 1992-12-07 1
- 1993-11-01 1
Foreign_Principal 8
- Taiwan Power Company 3
- COMOIL, S.A. 1
- Denis Sassou Nguesso, President of the Republic of the Congo 1
- Denis Sassou-Nguesso, President of The Republic of the Congo 1
- Eurafrica Communications, Inc. 1
- Italian Government (through I.S.I. Enterprises, Inc.) 1
- Jose Eduardo Dos Santos, President of the Republic of Angola 1
- Republic of Haiti 1
Country/Location_Represented 6
Registrant_Name 1
- Garrett & Company · 10 ✖
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1332 | 1332 | 1989-01-15 | Taiwan Power Company | 1983-02-03 | TAIWAN | Garrett & Company 3439 | 1983-02-03 | Garrett & Company | Taipei | ||||
1284 | 1284 | 1986-01-14 | Republic of Haiti | 1984-08-06 | HAITI | Garrett & Company 3439 | 1983-02-03 | Garrett & Company | Port au Prince | ||||
2959 | 2959 | 1990-02-28 | Denis Sassou Nguesso, President of the Republic of the Congo | 1989-08-11 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4279 | 1989-08-11 | Garrett & Company | |||||
1099 | 1099 | 1993-01-06 | Taiwan Power Company | 1990-07-12 | TAIWAN | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Taipei | ||||
5862 | 5862 | 1991-04-30 | COMOIL, S.A. | 1990-07-12 | FRANCE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Paris | ||||
4498 | 4498 | 1991-03-31 | Denis Sassou-Nguesso, President of The Republic of the Congo | 1990-07-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Brazzaville | ||||
4515 | 4515 | 1992-03-31 | Eurafrica Communications, Inc. | 1991-05-07 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Washington | DC | |||
1097 | 1097 | 1993-01-06 | Jose Eduardo Dos Santos, President of the Republic of Angola | 1992-04-23 | ANGOLA | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Luanda | ||||
1096 | 1096 | 1993-01-06 | Italian Government (through I.S.I. Enterprises, Inc.) | 1992-12-07 | ITALY | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Washington | DC | |||
8179 | 8179 | 1995-06-29 | Taiwan Power Company | 1993-11-01 | TAIWAN | Garrett & Company 4865 | 1993-11-01 | Garrett & Company | Taipei |
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]) );