FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Registration_Date" is on date 1986-09-26 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Address_1
Foreign_Principal 9
Registrant_Name 7
Country/Location_Represented 7
- MEXICO 2
- PHILIPPINES 2
- CAYMAN ISLANDS 1
- INTERNATIONAL 1
- JAPAN 1
- KOREA, SOUTH 1
- MALAWI 1
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15957 | 15957 | 1986-12-31 | EXEL, Ltd. | 1986-09-26 | CAYMAN ISLANDS | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Cayman Islands | ||||
5493 | 5493 | 1992-04-23 | Nakajima All Company, Ltd. | 1986-09-26 | JAPAN | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Tokyo | ||||
8868 | 8868 | 1987-07-01 | Republic of the Philippines | 1986-09-26 | PHILIPPINES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Manila | ||||
10708 | 10708 | 1988-08-24 | Government of Malawi | 1986-09-26 | MALAWI | Duncan, Allen & Talmage 3503 | 1983-07-25 | Duncan, Allen & Talmage | |||||
9075 | 9075 | 1989-07-07 | Philippine Sugar Regulatory Administration | 1986-09-26 | PHILIPPINES | Paul, Hastings, Janofsky & Walker 3763 | 1985-12-16 | Paul, Hastings, Janofsky & Walker | Quezon | ||||
11674 | 11674 | 1988-09-16 | Government of the Republic of Korea | 1986-09-26 | KOREA, SOUTH | Bergner Bockorny, Inc. 3801 | 1986-03-20 | Bergner Bockorny, Inc. | Washington | DC | |||
8438 | 8438 | 1989-06-30 | European Community | 1986-09-26 | INTERNATIONAL | Palumbo & Cerrell, Inc. 3888 | 1986-09-26 | Palumbo & Cerrell, Inc. | Washington | DC | |||
8991 | 8991 | 1989-07-03 | Miguel Fernandez | 1986-09-26 | MEXICO | Clews Communications, Inc. 3889 | 1986-09-26 | Clews Communications, Inc. | Chihuahua | ||||
8992 | 8992 | 1989-07-03 | Rodolfo Elizondo | 1986-09-26 | MEXICO | Clews Communications, Inc. 3889 | 1986-09-26 | Clews Communications, Inc. | Durango |
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]) );