FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Foreign_Principal_Termination_Date = "1994-12-20" and Registrant_Name = "IPG DXTRA, Inc" sorted by State
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 8
- APKINDO (Asosiasi Panel Kayu Indonesia) 1
- Board of Foreign Trade, Ministry of Economic Affairs 1
- Ecopetrol 1
- France Telecom & Deutsche Telekom 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 1
- IPG DXTRA, Inc · 8 ✖
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
15263 | 15263 | 1994-12-20 | Ecopetrol | 1994-10-13 | COLOMBIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Bogota | ||||
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 | ||||
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 | |||
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 |
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]) );