FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Foreign_Principal_Termination_Date" is on date 1991-06-30 sorted by Foreign_Principal
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Foreign_Principal_Registration_Date (date)
Foreign_Principal 24
- Arancia, S.A. de C.V. 1
- Bank of Credit & Commerce International 1
- Bank of Montreal, Public Affairs Office 1
- Board of Foreign Trade of the Republic of China 1
- Connaught Laboratories, Inc. 1
- DAF 1
- Department of Tourism, Government of the Turks & Caicos Islands 1
- Ethiopian Airlines 1
- Ethiopian People's Revolutionary Party (EPRP) 1
- Federation of Swiss Watch Industry 1
- Fiat U.S.A., Inc. 1
- Government of British Columbia 1
- Government of the People's Democratic Republic of Ethiopia 1
- Indian Investment Centre 1
- Japan Steel Works, Ltd. 1
- Nagase Kenko Corporation 1
- Panavia GmbH 1
- Puerto Vallarta Tourism Trust 1
- Royal Trustco, Ltd. (Royal Trustco")" 1
- SmithKline-Beecham Corporation 1
- South Europe-U.S.A. Freight Conference 1
- Sugar Sales (Pvt.), Ltd. 1
- Tourist Assn. of Yugoslavia (Turisticki Savez Jugoslavije) 1
- Toyota 1
Registrant_Name 20
- Hand, Arendall, Bedsole, Greaves & Johnson 3
- O'Connor & Hannan, L.L.P. 2
- Squire Patton Boggs, LLP 2
- Anderson, Hibey & Blair 1
- British Columbia House 1
- CHACMA, Inc. 1
- Ethiopian People's Revolutionary Party 1
- GCI Group, Inc. 1
- Grey Advertising, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Indian Investment Centre 1
- Kreuger, Ralph W. 1
- Medhurst & Associates, Inc. 1
- Pagonis & Donnelly Group, Inc. 1
- Popham, Haik, Schnobrich & Kaufman, Ltd. 1
- Richard V. Allen Company 1
- Rose, Schmidt, Hasley, & DiSalle 1
- Sheldon Ritter International Public Relations 1
- Waters, David J. 1
- Yugoslav National Tourist Office 1
Registrant_Date (date) 19 ✖
- 1990-06-29 4
- 1969-10-09 2
- 1978-10-25 2
- 1955-10-10 1
- 1964-09-01 1
- 1971-08-24 1
- 1973-06-12 1
- 1981-03-09 1
- 1981-11-10 1
- 1985-06-20 1
- 1986-07-11 1
- 1987-06-19 1
- 1987-08-03 1
- 1987-12-27 1
- 1988-02-23 1
- 1989-04-28 1
- 1989-08-16 1
- 1990-08-17 1
- 1990-10-09 1
Country/Location_Represented 16
- CANADA 4
- ETHIOPIA 3
- JAPAN 3
- MEXICO 2
- BELGIUM 1
- GERMANY 1
- GREAT BRITAIN 1
- INDIA 1
- INTERNATIONAL 1
- ITALY 1
- SWITZERLAND 1
- TAIWAN 1
- TURKS AND CAICOS ISLANDS 1
- UNITED ARAB EMIRATES 1
- YUGOSLAVIA 1
- ZIMBABWE 1
City 1
- - 24
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8472 | 8472 | 1991-06-30 | Arancia, S.A. de C.V. | 1991-12-04 | MEXICO | CHACMA, Inc. 4020 | 1987-08-03 | CHACMA, Inc. | Guadalajara, Jal. | ||||
8473 | 8473 | 1991-06-30 | Bank of Credit & Commerce International | 1991-05-03 | UNITED ARAB EMIRATES | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Abu Dhabi | ||||
8474 | 8474 | 1991-06-30 | Bank of Montreal, Public Affairs Office | 1988-03-23 | CANADA | Waters, David J. 4103 | 1988-02-23 | Waters, David J. | Toronto | ||||
8475 | 8475 | 1991-06-30 | Board of Foreign Trade of the Republic of China | 1990-08-17 | TAIWAN | Richard V. Allen Company 4408 | 1990-08-17 | Richard V. Allen Company | Taipei | ||||
8476 | 8476 | 1991-06-30 | Connaught Laboratories, Inc. | 1987-12-09 | CANADA | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | |||||
8477 | 8477 | 1991-06-30 | DAF | 1990-06-29 | BELGIUM | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | Brussels | ||||
8478 | 8478 | 1991-06-30 | Department of Tourism, Government of the Turks & Caicos Islands | 1988-07-15 | TURKS AND CAICOS ISLANDS | Medhurst & Associates, Inc. 3996 | 1987-06-19 | Medhurst & Associates, Inc. | |||||
8479 | 8479 | 1991-06-30 | Ethiopian Airlines | 1988-01-06 | ETHIOPIA | Sheldon Ritter International Public Relations 4077 | 1987-12-27 | Sheldon Ritter International Public Relations | Addis Ababa | ||||
8470 | 8470 | 1991-06-30 | Ethiopian People's Revolutionary Party (EPRP) | 1989-08-16 | ETHIOPIA | Ethiopian People's Revolutionary Party 4281 | 1989-08-16 | Ethiopian People's Revolutionary Party | Paris | ||||
8480 | 8480 | 1991-06-30 | Federation of Swiss Watch Industry | 1986-02-18 | SWITZERLAND | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | Bienne | ||||
8481 | 8481 | 1991-06-30 | Fiat U.S.A., Inc. | 1990-06-29 | ITALY | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | Washington | DC | |||
8482 | 8482 | 1991-06-30 | Government of British Columbia | 1964-09-01 | CANADA | British Columbia House 1782 | 1964-09-01 | British Columbia House | Victoria | ||||
8471 | 8471 | 1991-06-30 | Government of the People's Democratic Republic of Ethiopia | 1990-08-01 | ETHIOPIA | Pagonis & Donnelly Group, Inc. 3692 | 1985-06-20 | Pagonis & Donnelly Group, Inc. | Addis Abbaba | ||||
8483 | 8483 | 1991-06-30 | Indian Investment Centre | 1973-06-12 | INDIA | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | New Delhi | ||||
8484 | 8484 | 1991-06-30 | Japan Steel Works, Ltd. | 1989-04-28 | JAPAN | Popham, Haik, Schnobrich & Kaufman, Ltd. 4247 | 1989-04-28 | Popham, Haik, Schnobrich & Kaufman, Ltd. | Tokyo | ||||
8485 | 8485 | 1991-06-30 | Nagase Kenko Corporation | 1991-01-31 | JAPAN | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Tokyo | ||||
8486 | 8486 | 1991-06-30 | Panavia GmbH | 1990-06-29 | GERMANY | Hand, Arendall, Bedsole, Greaves & Johnson 4396 | 1990-06-29 | Hand, Arendall, Bedsole, Greaves & Johnson | Munich | ||||
8487 | 8487 | 1991-06-30 | Puerto Vallarta Tourism Trust | 1990-10-09 | MEXICO | Grey Advertising, Inc. 4420 | 1990-10-09 | Grey Advertising, Inc. | Jalisco | ||||
8488 | 8488 | 1991-06-30 | Royal Trustco, Ltd. (Royal Trustco")" | 1989-05-31 | CANADA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Ontario | ||||
8489 | 8489 | 1991-06-30 | SmithKline-Beecham Corporation | 1989-11-22 | GREAT BRITAIN | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | Middlesax | ||||
8490 | 8490 | 1991-06-30 | South Europe-U.S.A. Freight Conference | 1990-07-13 | INTERNATIONAL | Kreuger, Ralph W. 4391 | 1990-06-29 | Kreuger, Ralph W. | New Orleans | LA | |||
8491 | 8491 | 1991-06-30 | Sugar Sales (Pvt.), Ltd. | 1982-04-30 | ZIMBABWE | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | Salisbury | ||||
8492 | 8492 | 1991-06-30 | Tourist Assn. of Yugoslavia (Turisticki Savez Jugoslavije) | 1955-10-10 | YUGOSLAVIA | Yugoslav National Tourist Office 915 | 1955-10-10 | Yugoslav National Tourist Office | New York | NY | |||
8493 | 8493 | 1991-06-30 | Toyota | 1989-05-31 | JAPAN | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Tokyo |
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]) );