FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Foreign_Principal_Termination_Date = "1994-12-20"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- APKINDO (Asosiasi Panel Kayu Indonesia) 1
- Board of Foreign Trade, Ministry of Economic Affairs 1
- ELTAC, European Largest Textile & Apparel Companies 1
- Ecopetrol 1
- France Telecom & Deutsche Telekom 1
- L'Union des Industries Textiles 1
- Ministry of Foreign Trade 1
- Nationwide Action Committee for United Nations, Republic of China on Taiwan 1
- Presidencia de la Republica of Colombia 1
- ProChile 1
Registrant_Name 2
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15259 | 15259 | 1994-12-20 | L'Union des Industries Textiles | 1993-04-07 | FRANCE | Eurostrategy Associates, Inc. 4790 | 1993-04-07 | Eurostrategy Associates, Inc. | Clichy | ||||
15260 | 15260 | 1994-12-20 | APKINDO (Asosiasi Panel Kayu Indonesia) | 1994-10-06 | INDONESIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Jakarta | ||||
15261 | 15261 | 1994-12-20 | Board of Foreign Trade, Ministry of Economic Affairs | 1994-02-28 | TAIWAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Washington | DC | |||
15262 | 15262 | 1994-12-20 | ELTAC, European Largest Textile & Apparel Companies | 1993-04-07 | INTERNATIONAL | Eurostrategy Associates, Inc. 4790 | 1993-04-07 | Eurostrategy Associates, Inc. | Brussels | ||||
15263 | 15263 | 1994-12-20 | Ecopetrol | 1994-10-13 | COLOMBIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Bogota | ||||
15264 | 15264 | 1994-12-20 | France Telecom & Deutsche Telekom | 1994-07-25 | FRANCE | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | New York | NY | |||
15265 | 15265 | 1994-12-20 | Ministry of Foreign Trade | 1994-03-23 | COLOMBIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Bogota | ||||
15266 | 15266 | 1994-12-20 | Nationwide Action Committee for United Nations, Republic of China on Taiwan | 1994-09-20 | TAIWAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Taipei | ||||
15267 | 15267 | 1994-12-20 | Presidencia de la Republica of Colombia | 1994-03-23 | COLOMBIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Bogota | ||||
15268 | 15268 | 1994-12-20 | ProChile | 1993-07-07 | CHILE | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Santiago |
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]) );