FARA_All_ForeignPrincipals

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"

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
909 1996-01-01 Major British Banks Group 1996-03-21 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        
1865 1976-02-01 De Havilland Aircraft of Canada, Ltd. 1975-02-21 CANADA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
1934 1995-02-01 Taiwan Power Company 1986-09-23 TAIWAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
2543 1993-02-21 Japan Atomic Energy Research Institute (JERI) 1992-10-19 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
2581 1996-02-23 MATEK 1994-06-23 RUSSIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Moscow        
2627 1996-02-25 Air Foyle, Ltd. 1992-04-21 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Luton        
2628 1996-02-25 Embraer Aircraft Corporation 1995-05-24 BRAZIL 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Fort Lauderdale     FL  
2787 1988-02-28 Manurhin, S.A. 1982-09-28 FRANCE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
3106 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  
3714 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  
3715 1994-03-21 AECL 1993-09-21 CANADA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Ottawa, Ontario,        
3716 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        
3717 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        
3718 1994-03-21 Delft University of Tech 1993-05-03 NETHERLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Delft        
3719 1994-03-21 Forschungszentrum Geesthacht GmbH (GKSS) 1992-10-19 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Geesthacht        
3720 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        
3721 1994-03-21 Japan Atomic Energy Research Institute (JAERI")" 1993-09-21 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
3722 1994-03-21 Joint Research Centre 1992-10-19 NETHERLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Petten        
3723 1994-03-21 Osterreichisches Forschungszentrum Seibersdorf GmbH (ASTRA) 1992-10-19 AUSTRIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Seibersdorf        
3724 1994-03-21 Paul Scherrer Institute Research Reactor Saphir 1993-09-21 SWITZERLAND 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Villigen        
3725 1994-03-21 Riso National Laboratory (RISO) 1992-10-19 DENMARK 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Roskilde        
3726 1994-03-21 Studsvik Nuclear, A.B. (SKB) 1992-10-19 SWEDEN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Nykoping        
3727 1994-03-21 Technical University of Munich 1993-05-03 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reaktorstation        
4726 1992-04-03 Federation of Bankers' Association of Japan 1987-09-11 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
5001 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  
5002 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          
5004 1994-04-15 Nukem GmbH (NUKEM) 1992-10-19 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Alzenau        
5051 1975-04-17 Embassy of Saudi Arabia 1970-12-09 SAUDI ARABIA 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
5052 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        
7237 1991-06-06 Ceres Enterprises, Inc. 1991-03-08 GREECE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reston     VA  
7238 1991-06-06 Michelin Tire Company 1988-09-02 FRANCE 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Greenville     SC  
7622 1994-06-23 Republic of Latvia 1993-03-22 LATVIA 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
7921 1982-06-30 Cayman Turtle Farm, Ltd. 1979-06-15 CAYMAN ISLANDS 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
7922 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          
11194 1994-09-21 Colebrand, Ltd. 1990-01-31 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        
11361 1974-09-30 Committee of Foreign-Owned Banks 1969-09-15 INTERNATIONAL 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge New York     NY  
11954 1978-10-10 American Children's Citizenship Rights League (ACCRL) 1978-06-01 SWITZERLAND 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
11955 1978-10-10 Samuel Cummings 1978-06-01 GREAT BRITAIN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
13232 1970-11-13 Embassy of Saudi Arabia 1962-08-30 SAUDI ARABIA 1226 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
13233 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  
13281 1979-11-15 Hong Kong & Shanghai Banking Corporation 1979-11-27 HONG KONG 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
13663 1979-11-30 Taiwan Power Company 1979-02-09 TAIWAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
15522 1995-12-31 Federation of Bankers' Associations of Japan 1994-08-17 JAPAN 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
15583 1995-12-31 Institute of International Bankers 1975-02-21 INTERNATIONAL 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
15614 1995-12-31 Schnell-Bruter-Kernkraftwerksgesellschaft, MbH (SBK) 1993-08-03 GERMANY 2580 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Essen        

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)
);
Powered by Datasette · Query took 158.957ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history