FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Foreign_Principal_Termination_Date" is on date 1988-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 19
- Ajinomoto Company, Inc. 1
- Asociacion Nacional del Fabricantes de Tableros de Madera, A.C. (ANAFATA) 1
- British Columbia Hydro & Power Authority 1
- Canacero 1
- Consul General of Canada/Southwest Region 1
- Consulate General of Japan, San Francisco 1
- De Acero America (Wiresteel Corporation) 1
- Eldorado Resources, Ltd. 1
- Hylsa 1
- Japan Automobile Manufacturers' Association, Inc. 1
- Japan Fisheries Association 1
- Japan Whaling Association 1
- Korean Traders' Association 1
- Neal & Massy Holdings, Ltd. 1
- Private Pants Industry of Costa Rica 1
- Private Shirt Industry of Costa Rica 1
- Sidermex International 1
- Societe Generale de Surveillance, S.A. 1
- Tubos de Acero de Mexico, S.A. (TAMSA) 1
Registrant_Name 8
Country/Location_Represented 7
- MEXICO 6
- JAPAN 5
- CANADA 3
- COSTA RICA 2
- KOREA, SOUTH 1
- SWITZERLAND 1
- TRINIDAD AND TOBAGO 1
City 1
- - 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4437 | 4437 | 1988-03-31 | Japan Automobile Manufacturers' Association, Inc. | 1986-12-22 | JAPAN | Fowlkes, Frank Vaughan 3917 | 1986-12-22 | Fowlkes, Frank Vaughan | Tokyo | ||||
4438 | 4438 | 1988-03-31 | Korean Traders' Association | 1985-09-17 | KOREA, SOUTH | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | Seoul | ||||
4439 | 4439 | 1988-03-31 | Ajinomoto Company, Inc. | 1987-08-11 | JAPAN | Miner, Fraser & Gabriel Public Affairs, Inc. 4022 | 1987-08-11 | Miner, Fraser & Gabriel Public Affairs, Inc. | Tokyo | ||||
4440 | 4440 | 1988-03-31 | Asociacion Nacional del Fabricantes de Tableros de Madera, A.C. (ANAFATA) | 1986-05-10 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4441 | 4441 | 1988-03-31 | British Columbia Hydro & Power Authority | 1987-09-29 | CANADA | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | Vancouver | ||||
4442 | 4442 | 1988-03-31 | Canacero | 1986-03-10 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4443 | 4443 | 1988-03-31 | Consul General of Canada/Southwest Region | 1987-12-22 | CANADA | E. Bruce Harrison Company/Southwest, Inc. 4078 | 1987-12-22 | E. Bruce Harrison Company/Southwest, Inc. | Dallas | TX | |||
4444 | 4444 | 1988-03-31 | Consulate General of Japan, San Francisco | 1986-12-15 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
4445 | 4445 | 1988-03-31 | De Acero America (Wiresteel Corporation) | 1986-03-10 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | TX | ||||
4446 | 4446 | 1988-03-31 | Eldorado Resources, Ltd. | 1986-06-03 | CANADA | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4447 | 4447 | 1988-03-31 | Hylsa | 1986-03-10 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4448 | 4448 | 1988-03-31 | Japan Fisheries Association | 1987-03-10 | JAPAN | Steven R. Perles, P.C. 3248 | 1981-06-15 | Steven R. Perles, P.C. | Tokyo | ||||
4449 | 4449 | 1988-03-31 | Japan Whaling Association | 1981-06-15 | JAPAN | Steven R. Perles, P.C. 3248 | 1981-06-15 | Steven R. Perles, P.C. | Tokyo | ||||
4450 | 4450 | 1988-03-31 | Neal & Massy Holdings, Ltd. | 1986-05-28 | TRINIDAD AND TOBAGO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4451 | 4451 | 1988-03-31 | Private Pants Industry of Costa Rica | 1987-09-30 | COSTA RICA | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4452 | 4452 | 1988-03-31 | Private Shirt Industry of Costa Rica | 1987-05-13 | COSTA RICA | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | |||||
4453 | 4453 | 1988-03-31 | Sidermex International | 1985-06-04 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | San Antonio | TX | |||
4454 | 4454 | 1988-03-31 | Societe Generale de Surveillance, S.A. | 1986-10-08 | SWITZERLAND | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
4455 | 4455 | 1988-03-31 | Tubos de Acero de Mexico, S.A. (TAMSA) | 1985-06-04 | MEXICO | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. |
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]) );