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 1996-09-30 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date)
Foreign_Principal 13
- Bombardier 1
- Canadian Steel Producers' Association 1
- Chinese Science News Overseas Edition 1
- Consortium of German States' Economic Development Organizations 1
- Embassy of the Republic of Singapore 1
- Government of Iceland 1
- Government of Nigeria 1
- Government of Rwanda 1
- Government of the Republic of Togo 1
- Japan External Trade Organization 1
- Outlook Weekly 1
- People's Daily Overseas Edition 1
- Scitex Corporation 1
Registrant_Name 10
Country/Location_Represented 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12071 | 12071 | 1996-09-30 | Canadian Steel Producers' Association | 1995-09-11 | CANADA | Van Loon, Jean 5063 | 1995-09-11 | Van Loon, Jean | Ottawa, Ontario | ||||
12072 | 12072 | 1996-09-30 | Consortium of German States' Economic Development Organizations | 1995-10-18 | GERMANY | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Erfurt | ||||
12073 | 12073 | 1996-09-30 | People's Daily Overseas Edition | 1992-03-20 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12074 | 12074 | 1996-09-30 | Bombardier | 1996-09-05 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Montreal, Quebec | ||||
12075 | 12075 | 1996-09-30 | Chinese Science News Overseas Edition | 1993-08-24 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12076 | 12076 | 1996-09-30 | Embassy of the Republic of Singapore | 1995-11-09 | SINGAPORE | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | 1981-09-10 | Powell, Goldstein, Frazer & Murphy, L.L.P. | Washington | DC | |||
12077 | 12077 | 1996-09-30 | Government of Iceland | 1995-10-10 | ICELAND | Boynton, Stephen S. 5056 | 1995-10-10 | Boynton, Stephen S. | Washington | DC | |||
12078 | 12078 | 1996-09-30 | Government of Nigeria | 1995-06-28 | NIGERIA | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | New York | NY | |||
12079 | 12079 | 1996-09-30 | Government of Rwanda | 1996-04-26 | RWANDA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Kigali | ||||
12080 | 12080 | 1996-09-30 | Government of the Republic of Togo | 1996-05-22 | TOGO | Tamen & Tamen 5108 | 1996-05-22 | Tamen & Tamen | Lome | ||||
12081 | 12081 | 1996-09-30 | Japan External Trade Organization | 1995-06-22 | JAPAN | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Tokyo | ||||
12082 | 12082 | 1996-09-30 | Outlook Weekly | 1994-10-17 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12083 | 12083 | 1996-09-30 | Scitex Corporation | 1997-03-10 | ISRAEL | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Herzlia |
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]) );