FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where "Foreign_Principal_Termination_Date" is on date 1989-05-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7068 | 7068 | 1989-05-31 | Government of Alberta, Canada | 1984-05-22 | CANADA | Government of Alberta, Canada 3589 | 1984-05-22 | Government of Alberta, Canada | Edmonton, Alberta | ||||
7069 | 7069 | 1989-05-31 | Government of Bolivia | 1986-10-16 | BOLIVIA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Washington | DC | |||
7070 | 7070 | 1989-05-31 | Jamaica Tourist Board | 1986-07-11 | JAMAICA | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Kingston | ||||
7071 | 7071 | 1989-05-31 | Lebanese Information & Research Center/Lebanese Forces | 1988-05-11 | LEBANON | Jefferson Group, Inc. 4139 | 1988-05-11 | Jefferson Group, Inc. | Washington | DC | |||
7072 | 7072 | 1989-05-31 | Nicaraguan Democratic Resistance | 1989-03-29 | NICARAGUA | Keene, Shirley & Associates, Inc. 3997 | 1987-06-19 | Keene, Shirley & Associates, Inc. | |||||
7073 | 7073 | 1989-05-31 | Nippon Yusen Kaisha (NYK) | 1986-04-17 | JAPAN | Pettit & Martin 3815 | 1986-04-17 | Pettit & Martin | Tokyo | ||||
7074 | 7074 | 1989-05-31 | Scand-Video-Group | 1989-03-20 | SWEDEN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | Boras |
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]) );