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

15 rows where "Foreign_Principal_Termination_Date" is on date 2001-03-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 4

City 1

  • - 15
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
4589 4589 2001-03-31 Japan Cotton Textile Exporters' Association 1956-01-25 JAPAN Japan Economic Institute of America 929 1956-01-25 Japan Economic Institute of America Osaka        
4590 4590 2001-03-31 British Trade Development Office 1985-03-19 GREAT BRITAIN Spring O'Brien & Company, Inc. 3661 1985-03-19 Spring O'Brien & Company, Inc. New York     NY  
4591 4591 2001-03-31 Cayman Islands Department of Tourism 1986-02-20 CAYMAN ISLANDS O'Leary Clarke & Partners, Inc. 3780 1986-02-20 O'Leary Clarke & Partners, Inc.          
4592 4592 2001-03-31 Croatian National Tourist Office, Inc. 2000-11-03 CROATIA Global Communicators/ Harff Communications, Inc. 5241 1998-03-05 Global Communicators/ Harff Communications, Inc. New York     NY  
4593 4593 2001-03-31 Democratic Republic of the Congo 1999-02-11 CONGO, REPUBLIC OF THE Cohen & Woods International, Inc. 5003 1995-03-10 Cohen & Woods International, Inc. Kinshasa        
4594 4594 2001-03-31 Government of Georgia, Embassy 1998-03-25 GEORGIA Capitol Advisors, Inc. 5245 1998-03-25 Capitol Advisors, Inc. 1511 K Street, N.W., Suite 400     DC  
4595 4595 2001-03-31 Government of Japan 1956-01-25 JAPAN Japan Economic Institute of America 929 1956-01-25 Japan Economic Institute of America Washington     DC  
4596 4596 2001-03-31 Hamburg Business Development Corporation 1999-03-31 GERMANY Global Communicators/ Harff Communications, Inc. 5241 1998-03-05 Global Communicators/ Harff Communications, Inc. Hamburger Strasse 11 D 22083        
4597 4597 2001-03-31 His Excellency Ibrahim Saminu Turaki, Governor Jigawa State 2000-12-14 NIGERIA BKSH & Associates 5402 2000-12-14 BKSH & Associates Government House Dutse, Jigawa State        
4598 4598 2001-03-31 Italian Trade Commission 2001-02-05 ITALY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Fashion Center 499 Park Avenue New York 10022     NY  
4599 4599 2001-03-31 Italian Trade Commission 2000-07-05 ITALY Oliver A. Dulle, Jr. & Company, Inc. 4739 1992-12-17 Oliver A. Dulle, Jr. & Company, Inc. Via Liszt 21 00144 ROMA        
4600 4600 2001-03-31 Japan External Trade Organization (JETRO) 1997-11-24 JAPAN Business Network Corporation 4513 1991-05-20 Business Network Corporation Tokyo        
4601 4601 2001-03-31 Republic of Georgia 2001-04-17 GEORGIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Ministry of Finance of the Republic of Georgia 70, IR. Abashidze Street, 380062 Tbilishi        
4602 4602 2001-03-31 Singapore Technologies Engineering (USA), Inc. 2000-04-18 SINGAPORE Caribou Technologies, Inc. 5367 2000-04-18 Caribou Technologies, Inc. 7701 Lemmon Avenue Dallas 75209     TX  
4603 4603 2001-03-31 VEVE Group 2001-05-11 ALBANIA Global Communicators/ Harff Communications, Inc. 5241 1998-03-05 Global Communicators/ Harff Communications, Inc. Bulevardi Deshmovet e Kombit Tirana        

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