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 1970-12-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 7
Country/Location_Represented 7
- ARGENTINA 1
- BRAZIL 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- JAPAN 1
- MEXICO 1
- SWITZERLAND 1
Registrant_Name 6
City 1
- - 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15673 | 15673 | 1970-12-31 | La Comite de Liaison Europeenne de l'Inudstries de la Chaussure | 1970-04-19 | INTERNATIONAL | DGA International, Inc. 2206 | 1970-08-19 | DGA International, Inc. | Brussels | ||||
15674 | 15674 | 1970-12-31 | Asahi Chemical Industry Company, Ltd. | 1970-06-05 | JAPAN | Donald G. Lerch, Jr. & Company, Inc. 2089 | 1968-04-22 | Donald G. Lerch, Jr. & Company, Inc. | |||||
15675 | 15675 | 1970-12-31 | British Travel Association | 1970-05-18 | GREAT BRITAIN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | Los Angeles | CA | |||
15676 | 15676 | 1970-12-31 | Embassy of Argentina | 1969-02-10 | ARGENTINA | Lever, Michael 1592 | 1963-01-25 | Lever, Michael | Washington | DC | |||
15677 | 15677 | 1970-12-31 | Embassy of Mexico, Economic Office | 1964-02-04 | MEXICO | Lever, Michael 1592 | 1963-01-25 | Lever, Michael | Washington | DC | |||
15678 | 15678 | 1970-12-31 | Sao Paulo Textile Association | 1970-11-24 | BRAZIL | Coudert Brothers 2222 | 1970-11-24 | Coudert Brothers | Sao Paulo | ||||
15679 | 15679 | 1970-12-31 | Vorort des Schweizerischen Handels-und Industrie-Vereins | 1968-02-15 | SWITZERLAND | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Zurich |
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]) );