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 Registrant_Name = "Shearman & Sterling"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

Registrant_Name 1

  • Shearman & Sterling · 23 ✖

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
1479 1479 1997-01-23 MAN Roland Druckmaschinen AG (Man Roland) 1996-08-29 GERMANY Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Augsburg        
1480 1480 1997-01-23 Suramerica de Aleaciones Laminadas, C.A. 1996-03-01 VENEZUELA Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Caracas        
1481 1481 2000-01-23 Credit Lyonnais 1998-05-07 FRANCE Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 5 rue Gretry 75002 Paris        
2166 2166 1992-02-03 Quebec Government House 1991-11-25 CANADA Shearman & Sterling 4208 1989-01-23 Shearman & Sterling New York     NY  
2730 2730 1993-02-23 Petroleos de Venezuela, S.A. (PdVSA) 1991-09-24 VENEZUELA Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Caracas        
2957 2957 1989-02-28 Siemens, A.G. 1989-02-21 GERMANY, FEDERAL REPUBLIC OF Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Munich        
3846 3846 1992-03-17 Claro Y Cia 1989-05-12 CHILE Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Santiago        
4468 4468 1989-03-31 Minorco Societe Anonyme 1989-01-23 LUXEMBOURG Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Luxembourg, Ville RC        
5157 5157 1977-04-11 Bureau Algerian de Recherches et d'Exploitations Minieres (BAREM) 1966-11-15 ALGERIA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Algiers        
5158 5158 1977-04-11 Societe Nationale de Recherches et d'Etploitations Minieres (SONAREM) 1973-05-18 ALGERIA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Algiers        
5159 5159 1977-04-11 ASA, Ltd. (formerly American-South African Investment Company, Ltd.) 1974-04-17 SOUTH AFRICA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Johannesburg        
5160 5160 1977-04-11 Minister of Industry & Energy of Algeria 1973-05-18 ALGERIA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Algiers        
5161 5161 1977-04-11 Schlumberger, Ltd. 1973-02-08 NETHERLANDS ANTILLES Shearman & Sterling 1877 1965-04-05 Shearman & Sterling New York     NY  
5162 5162 1977-04-11 Societe Nationale de Transport et de Commercialisation des Hydrocarbons (Agency of Government of Algeria) (SONATRACH) 1965-04-05 ALGERIA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Algiers        
5344 5344 1974-04-17 American-South African Investment Company, Ltd. 1969-10-29 SOUTH AFRICA Shearman & Sterling 1877 1965-04-05 Shearman & Sterling Johannesburg        
8043 8043 1997-06-23 Industrija Nafte d.d. Zagreb (INA) - Naftaplin Unit 1996-01-03 CROATIA Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Zagreb        
10146 10146 1996-08-05 Confedercion de Asociaciones Agricolas del Estado Sinaloa (CAADES) 1995-05-19 MEXICO Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Sinaloa        
10709 10709 1993-08-24 Airbus Industrie, G.I.E. 1990-04-06 FRANCE Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Blagnac        
10710 10710 1993-08-24 Grupo Industrial Camesa, S.A. de C.V. 1990-06-27 MEXICO Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Mexico City        
10711 10711 1993-08-24 Mexican Coffee Institute (INMECAFE) 1992-06-19 MEXICO Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Universidad        
10712 10712 1993-08-24 Office of the Leader of the Opposition Quebec National Assembly 1992-02-03 CANADA Shearman & Sterling 4208 1989-01-23 Shearman & Sterling Quebec        
15098 15098 1982-12-14 British Virgin Islands 1982-05-14 BRITISH VIRGIN ISLANDS Shearman & Sterling 3370 1982-05-14 Shearman & Sterling          
16444 16444 1998-12-31 Secretariat of Commerce & Industrial Development of Mexico (SECOFI) 1991-02-26 MEXICO Shearman & Sterling 4208 1989-01-23 Shearman & Sterling -----        

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