List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

45 rows where Registrant_Name = "Shaw, Pittman, Potts & Trowbridge" sorted by rowid descending

View and edit SQL

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

State

Registrant_Name

  • Shaw, Pittman, Potts & Trowbridge · 45

City

  • - 45
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
15945 1995-12-31 Schnell-Bruter-Kernkraftwerksgesellschaft, MbH (SBK) 1993-08-03 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Essen        
15914 1995-12-31 Institute of International Bankers 1975-02-21 INTERNATIONAL 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
15853 1995-12-31 Federation of Bankers' Associations of Japan 1994-08-17 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
13967 1979-11-30 Taiwan Power Company 1979-02-09 TAIWAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
13581 1979-11-15 Hong Kong & Shanghai Banking Corporation 1979-11-27 HONG KONG 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
13532 1970-11-13 Government of Brazil (Brazilian Aeronautical Commission - Agency of the Ministry of Aeronautics) 1959-05-12 BRAZIL 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
13531 1970-11-13 Embassy of Saudi Arabia 1962-08-30 SAUDI ARABIA 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
12220 1978-10-10 Samuel Cummings 1978-06-01 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
12219 1978-10-10 American Children's Citizenship Rights League (ACCRL) 1978-06-01 SWITZERLAND 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
11608 1974-09-30 Committee of Foreign-Owned Banks 1969-09-15 INTERNATIONAL 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge New York     NY  
11439 1994-09-21 Colebrand, Ltd. 1990-01-31 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        
8105 1982-06-30 General Department of International Air Services (Aeroflot Soviet Airlines) 1980-03-10 USSR 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
8104 1982-06-30 Cayman Turtle Farm, Ltd. 1979-06-15 CAYMAN ISLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
7803 1994-06-23 Republic of Latvia 1993-03-22 LATVIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
7410 1991-06-06 Michelin Tire Company 1988-09-02 FRANCE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Greenville     SC  
7409 1991-06-06 Ceres Enterprises, Inc. 1991-03-08 GREECE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reston     VA  
5177 1975-04-17 Government of Brazil (Brazilian Aeronautical Commission) 1970-12-09 BRAZIL 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Rio de Janeiro        
5176 1975-04-17 Embassy of Saudi Arabia 1970-12-09 SAUDI ARABIA 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
5128 1994-04-15 Nukem GmbH (NUKEM) 1992-10-19 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Alzenau        
5126 1994-04-15 French-American Chamber of Commerce in the U.S., Inc. 1983-09-21 FRANCE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
5125 1994-04-15 Bank Leumi le-Israel, B.M. 1992-02-11 ISRAEL 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New York     NY  
4844 1992-04-03 Federation of Bankers' Association of Japan 1987-09-11 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
3806 1994-03-21 Technical University of Munich 1993-05-03 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reaktorstation        
3805 1994-03-21 Studsvik Nuclear, A.B. (SKB) 1992-10-19 SWEDEN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Nykoping        
3804 1994-03-21 Riso National Laboratory (RISO) 1992-10-19 DENMARK 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Roskilde        
3803 1994-03-21 Paul Scherrer Institute Research Reactor Saphir 1993-09-21 SWITZERLAND 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Villigen        
3802 1994-03-21 Osterreichisches Forschungszentrum Seibersdorf GmbH (ASTRA) 1992-10-19 AUSTRIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Seibersdorf        
3801 1994-03-21 Joint Research Centre 1992-10-19 NETHERLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Petten        
3800 1994-03-21 Japan Atomic Energy Research Institute (JAERI")" 1993-09-21 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
3799 1994-03-21 Hahn - Meitner - Institut Berlin GmbH (HMI) Hahn - Meitner - Institut 1992-10-19 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Berlin        
3798 1994-03-21 Forschungszentrum Geesthacht GmbH (GKSS) 1992-10-19 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Geesthacht        
3797 1994-03-21 Delft University of Tech 1993-05-03 NETHERLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Delft        
3796 1994-03-21 Belgian Nuclear Research Centre (C.E.N./S.C.K.) 1993-01-13 BELGIUM 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Boeretang        
3795 1994-03-21 Australian Nuclear Science & Technology Organization (ANSTO) 1992-10-19 AUSTRALIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New South Wales        
3794 1994-03-21 AECL 1993-09-21 CANADA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Ottawa, Ontario,        
3793 1991-03-21 National Bank of Kuwait, S.A.K. 1990-09-28 KUWAIT 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New York     NY  
3176 1989-03-01 Government of the Republic of Cape Verde 1988-11-10 CABO VERDE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
2847 1988-02-28 Manurhin, S.A. 1982-09-28 FRANCE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
2684 1996-02-25 Embraer Aircraft Corporation 1995-05-24 BRAZIL 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Fort Lauderdale     FL  
2683 1996-02-25 Air Foyle, Ltd. 1992-04-21 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Luton        
2637 1996-02-23 MATEK 1994-06-23 RUSSIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Moscow        
2599 1993-02-21 Japan Atomic Energy Research Institute (JERI) 1992-10-19 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
1976 1995-02-01 Taiwan Power Company 1986-09-23 TAIWAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
1907 1976-02-01 De Havilland Aircraft of Canada, Ltd. 1975-02-21 CANADA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
918 1996-01-01 Major British Banks Group 1996-03-21 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        

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