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

23 rows where Registration_Number = 3700

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 11

State 7

Registrant_Name 1

City 1

  • - 23
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
2294 2294 1993-02-08 BAA, PLC 1989-02-09 GREAT BRITAIN Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. London        
2296 2296 1993-02-08 Korea Iron & Steel Association 1992-08-07 KOREA, SOUTH Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Seoul        
2494 2494 1994-02-14 SECOFI (Secretaria de Comercio y Fomento Industrial) C/O Mexican Embassy Free Trade Office 1991-03-12 MEXICO Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Washington     DC  
2603 2603 1996-02-16 Beretta, U.S.A. Corporation 1987-08-13 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Accokeek     MD  
2604 2604 1996-02-16 Camara Nacional de la Industria Pesquera 1994-02-25 MEXICO Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Mexico City        
2605 2605 1996-02-16 Camara Nacional de las Industrias (Azucarera y Alcoholera) 1994-02-25 MEXICO Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Mexico City        
2606 2606 1996-02-16 Cementos Mexicanos 1994-02-25 MEXICO Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Monterrey        
2608 2608 1996-02-16 Thomson-CSF, Inc. 1995-06-08 FRANCE Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Alexandria     VA  
2999 2999 1995-02-28 Degussa, A.G. (Through Burson-Marsteller, Washington) 1994-05-03 GERMANY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Frankfurt        
3001 3001 1995-02-28 Medela, A.G., Medical Equipment 1994-01-19 SWITZERLAND Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Baar        
3004 3004 1995-02-28 Nestle U.S.A., Inc. 1992-07-24 SWITZERLAND Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Washington     DC  
3006 3006 1995-02-28 Thomson-CSF, Inc. 1989-02-27 FRANCE Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Arlington     VA  
5323 5323 1986-04-16 International Gold Corporation, Ltd. 1985-07-09 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. New York     NY  
6217 6217 1995-05-01 Pirelli Armstrong Tire Corporation 1994-11-30 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. New Haven     CT  
7067 7067 1988-05-31 Thomson-CSF, Inc. 1987-04-03 FRANCE Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. New York     NY  
10213 10213 1994-08-08 AFIN CASA DE BOLSA, S.A. de C.V. 1993-10-14 MEXICO Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Mexico City        
10214 10214 1994-08-08 Hitachi America, Ltd. 1994-03-24 JAPAN Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Tarrytown     NY  
12002 12002 1988-09-30 Ricoh Corporation 1987-02-27 INTERNATIONAL Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. West Caldwell     NJ  
12067 12067 1995-09-30 James Capel & Company 1993-10-18 GREAT BRITAIN Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. London        
14455 14455 1995-11-30 Government of Pakistan, Embassy 1995-10-30 PAKISTAN Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Washington     DC  
16318 16318 1995-12-31 Fiat Washington, Inc./combined with Fiat, S.p.A 1989-11-09 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Washington     DC  
16319 16319 1995-12-31 Fiat, S.p.A. (combined with Fiat Washington, Inc.) 1986-05-16 ITALY Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Turin        
16358 16358 1995-12-31 National Council of Resistance of Iran 1995-09-28 IRAN Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. Washington     DC  

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