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 = "1989-09-30" sorted by State
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Carmen Group, Inc. 1
- Charles L. Fishman, P.C. 1
- Declusin, James E. 1
- Dorsey & Whitney 1
- Durocher & Company, Inc. 1
- Fleishman-Hillard, Inc. 1
- Graydon Associates, Inc. 1
- Hallett, Carol B. 1
- IPG DXTRA, Inc 1
- Jack H. McDonald Company 1
- Murphy & Demory, Ltd. 1
- Wagner, Hines & Avary, Inc. 1
- Wolf Shevack, Inc. 1
Foreign_Principal 12
- Mohammed Harajchi 2
- Aeroflot 1
- California Steel Industries, Inc. 1
- Canadian General Electric 1
- Consul General, Federal Republic of Germany 1
- Government of Thailand (Royal Thai Embassy) 1
- Minorco Societe Anonyme 1
- Nissan Aerospace Division, Nissan Motor Company, Ltd. 1
- Samsung 1
- Suzuki of America Automotive Corporation 1
- United Advertising Company 1
- Warrington & Runcorn New Town Development Corporation 1
Country/Location_Represented 11
- IRAN 2
- JAPAN 2
- BRAZIL 1
- CANADA 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GREAT BRITAIN 1
- KOREA, SOUTH 1
- LUXEMBOURG 1
- TAIWAN 1
- THAILAND 1
- USSR 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12005 | 12005 | 1989-09-30 | Canadian General Electric | 1986-06-18 | CANADA | Wagner, Hines & Avary, Inc. 3845 | 1986-06-18 | Wagner, Hines & Avary, Inc. | |||||
12008 | 12008 | 1989-09-30 | Minorco Societe Anonyme | 1989-03-23 | LUXEMBOURG | Jack H. McDonald Company 3956 | 1987-04-01 | Jack H. McDonald Company | Luxembourg-Ville | ||||
12009 | 12009 | 1989-09-30 | Mohammed Harajchi | 1989-03-20 | IRAN | Carmen Group, Inc. 4233 | 1989-03-20 | Carmen Group, Inc. | Nassau | ||||
12010 | 12010 | 1989-09-30 | Mohammed Harajchi | 1989-05-18 | IRAN | Hallett, Carol B. 4256 | 1989-05-18 | Hallett, Carol B. | Hamburg | ||||
12011 | 12011 | 1989-09-30 | Nissan Aerospace Division, Nissan Motor Company, Ltd. | 1987-11-06 | JAPAN | Charles L. Fishman, P.C. 4054 | 1987-11-06 | Charles L. Fishman, P.C. | Tokyo | ||||
12014 | 12014 | 1989-09-30 | United Advertising Company | 1988-03-03 | TAIWAN | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Taiwan | ||||
12015 | 12015 | 1989-09-30 | Warrington & Runcorn New Town Development Corporation | 1975-12-10 | GREAT BRITAIN | Graydon Associates, Inc. 2639 | 1975-12-10 | Graydon Associates, Inc. | Cheshire | ||||
12004 | 12004 | 1989-09-30 | California Steel Industries, Inc. | 1989-06-06 | BRAZIL | Declusin, James E. 4263 | 1989-06-06 | Declusin, James E. | Fontana | CA | |||
12013 | 12013 | 1989-09-30 | Suzuki of America Automotive Corporation | 1988-03-15 | JAPAN | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Brea | CA | |||
12007 | 12007 | 1989-09-30 | Government of Thailand (Royal Thai Embassy) | 1989-02-03 | THAILAND | Dorsey & Whitney 4214 | 1989-02-03 | Dorsey & Whitney | Washington | DC | |||
12006 | 12006 | 1989-09-30 | Consul General, Federal Republic of Germany | 1987-10-15 | GERMANY, FEDERAL REPUBLIC OF | Durocher & Company, Inc. 4051 | 1987-10-15 | Durocher & Company, Inc. | Detroit | MI | |||
12012 | 12012 | 1989-09-30 | Samsung | 1989-09-05 | KOREA, SOUTH | Murphy & Demory, Ltd. 4095 | 1988-03-03 | Murphy & Demory, Ltd. | Fort Lee | NJ | |||
12003 | 12003 | 1989-09-30 | Aeroflot | 1978-10-22 | USSR | Wolf Shevack, Inc. 1436 | 1961-03-28 | Wolf Shevack, Inc. | 545 Fifth Avenue | 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]) );