FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where "Foreign_Principal_Termination_Date" is on date 1987-03-01 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registrant_Date (date)
Registrant_Name 4
Foreign_Principal 4
Country/Location_Represented 4
- CYPRUS 1
- GREECE 1
- HAITI 1
- KOREA, SOUTH 1
State 1
- - 4
City 1
- - 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3281 | 3281 | 1987-03-01 | Freedom & Justice for Cyprus Trust | 1986-10-31 | CYPRUS | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Nicosia | ||||
3282 | 3282 | 1987-03-01 | Government of the Republic of Korea | 1987-02-20 | KOREA, SOUTH | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Seoul | ||||
3283 | 3283 | 1987-03-01 | Mr. Marc Bazin | 1986-08-15 | HAITI | Alyse Lynn Booth & Associates 3870 | 1986-08-15 | Alyse Lynn Booth & Associates | Port-au-Prince | ||||
3284 | 3284 | 1987-03-01 | Union of Greek Shipowners | 1986-06-26 | GREECE | Manatos & Manatos 3522 | 1983-09-28 | Manatos & Manatos | Piraeus |
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]) );