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" is on date 1994-02-28 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Registrant_Date (date)
Foreign_Principal 8
- Cemex, S.A. 1
- Government of Haiti 1
- Industrial Studies & Development Center of Saudi Arabia 1
- National Federation of Coffee Growers of Colombia 1
- Office of the President of Kazakhstan 1
- Office of the President of Ukraine (Through P/C Advisors, Inc.) 1
- Republic of Kirgizhstan 1
- Republic of Mexico, Ministry of Commerce & Industrial Development 1
Country/Location_Represented 7
- MEXICO 2
- COLOMBIA 1
- HAITI 1
- KAZAKHSTAN 1
- KYRGYZSTAN 1
- SAUDI ARABIA 1
- UKRAINE 1
Registrant_Name 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2990 | 2990 | 1994-02-28 | Cemex, S.A. | 1993-03-02 | MEXICO | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | Monterry | ||||
2991 | 2991 | 1994-02-28 | Government of Haiti | 1993-09-29 | HAITI | Washington Strategic Consulting Group, Inc. 4694 | 1992-07-17 | Washington Strategic Consulting Group, Inc. | Washington | DC | |||
2992 | 2992 | 1994-02-28 | Industrial Studies & Development Center of Saudi Arabia | 1977-01-17 | SAUDI ARABIA | Dutton & Dutton, P.C. 2591 | 1975-06-12 | Dutton & Dutton, P.C. | Riyadh | ||||
2993 | 2993 | 1994-02-28 | National Federation of Coffee Growers of Colombia | 1986-06-24 | COLOMBIA | Murray, Scheer, Montgomery, Tapia & O'Donnell 3557 | 1984-02-02 | Murray, Scheer, Montgomery, Tapia & O'Donnell | NY | ||||
2994 | 2994 | 1994-02-28 | Office of the President of Kazakhstan | 1993-08-12 | KAZAKHSTAN | Raftis Associates 4816 | 1993-06-11 | Raftis Associates | Alma Ata | ||||
2995 | 2995 | 1994-02-28 | Office of the President of Ukraine (Through P/C Advisors, Inc.) | 1993-06-11 | UKRAINE | Raftis Associates 4816 | 1993-06-11 | Raftis Associates | Kiev | ||||
2996 | 2996 | 1994-02-28 | Republic of Kirgizhstan | 1992-08-31 | KYRGYZSTAN | Skadden, Arps, Slate, Meagher & Flom, L.L.P. 4550 | 1991-07-29 | Skadden, Arps, Slate, Meagher & Flom, L.L.P. | Bishkek, Kirgizhstan | ||||
2997 | 2997 | 1994-02-28 | Republic of Mexico, Ministry of Commerce & Industrial Development | 1992-03-11 | MEXICO | Solar & Ellis, L.L.P. 4630 | 1992-03-11 | Solar & Ellis, L.L.P. | Mexico City |
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]) );