FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 1990-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 13
- Algoma Steel Corporation, Ltd. 1
- Chilean Exporters' Association 1
- Democratic Renaissance Movement of Angola 1
- FFV Ordinance 1
- Government of the Republic of Liberia 1
- INTELSAT (International Telecommunications Satellite Organization) 1
- Korea Foreign Trade Association 1
- Laurel Steel Products, Ltd. 1
- Nara Advertising, Inc. 1
- Plessey Company, PLC 1
- Rafael Hotels, Ltd. 1
- Ricoh Electronics, Inc. 1
- Tourism Canada 1
Registrant_Name 10
Country/Location_Represented 10
- CANADA 3
- KOREA, SOUTH 2
- ANGOLA 1
- CHILE 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- JAPAN 1
- LIBERIA 1
- MONACO 1
- SWEDEN 1
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12016 | 12016 | 1990-09-30 | Chilean Exporters' Association | 1989-11-24 | CHILE | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Santiago | ||||
12017 | 12017 | 1990-09-30 | Algoma Steel Corporation, Ltd. | 1985-09-27 | CANADA | Pack, Allen Scott 3741 | 1985-09-27 | Pack, Allen Scott | Ontario | ||||
12018 | 12018 | 1990-09-30 | Democratic Renaissance Movement of Angola | 1990-03-27 | ANGOLA | Democratic Renaissance Movement of Angola (D.R.M.A.) 4359 | 1990-03-27 | Democratic Renaissance Movement of Angola (D.R.M.A.) | Washington | DC | |||
12019 | 12019 | 1990-09-30 | FFV Ordinance | 1990-07-19 | SWEDEN | Lindstrom, Talbot Shaw 4403 | 1990-07-19 | Lindstrom, Talbot Shaw | Eskilstuna | ||||
12020 | 12020 | 1990-09-30 | Government of the Republic of Liberia | 1990-06-05 | LIBERIA | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | Monrovia | ||||
12021 | 12021 | 1990-09-30 | INTELSAT (International Telecommunications Satellite Organization) | 1989-03-17 | INTERNATIONAL | Reed, Smith, Shaw & McClay 4227 | 1989-03-17 | Reed, Smith, Shaw & McClay | Washington | DC | |||
12022 | 12022 | 1990-09-30 | Korea Foreign Trade Association | 1990-05-10 | KOREA, SOUTH | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Seoul | ||||
12023 | 12023 | 1990-09-30 | Laurel Steel Products, Ltd. | 1984-05-09 | CANADA | Herring, Barry Alexander 3581 | 1984-05-09 | Herring, Barry Alexander | Burlington Ontario | ||||
12024 | 12024 | 1990-09-30 | Nara Advertising, Inc. | 1988-03-03 | KOREA, SOUTH | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Seoul | ||||
12025 | 12025 | 1990-09-30 | Plessey Company, PLC | 1988-12-13 | GREAT BRITAIN | Goodwin Procter, LLP 3901 | 1986-10-30 | Goodwin Procter, LLP | London | ||||
12026 | 12026 | 1990-09-30 | Rafael Hotels, Ltd. | 1990-12-03 | MONACO | Farella, Braun & Martel 4443 | 1990-12-03 | Farella, Braun & Martel | Monte Carlo | ||||
12027 | 12027 | 1990-09-30 | Ricoh Electronics, Inc. | 1988-09-01 | JAPAN | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Tustin | CA | |||
12028 | 12028 | 1990-09-30 | Tourism Canada | 1986-12-02 | CANADA | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Ottawa |
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]) );