FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 4

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
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        
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        
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        
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        
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

CSV options: 

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])
);