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

45 rows where Registrant_Name = "Shaw, Pittman, Potts & Trowbridge"

✎ View and edit SQL

This data as json, CSV (advanced)

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 6

Registrant_Name 1

  • Shaw, Pittman, Potts & Trowbridge · 45 ✖

City 1

  • - 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
961 961 1996-01-01 Major British Banks Group 1996-03-21 GREAT BRITAIN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        
1974 1974 1976-02-01 De Havilland Aircraft of Canada, Ltd. 1975-02-21 CANADA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
2043 2043 1995-02-01 Taiwan Power Company 1986-09-23 TAIWAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
2683 2683 1993-02-21 Japan Atomic Energy Research Institute (JERI) 1992-10-19 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
2725 2725 1996-02-23 MATEK 1994-06-23 RUSSIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Moscow        
2774 2774 1996-02-25 Air Foyle, Ltd. 1992-04-21 GREAT BRITAIN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Luton        
2775 2775 1996-02-25 Embraer Aircraft Corporation 1995-05-24 BRAZIL Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Fort Lauderdale     FL  
2939 2939 1988-02-28 Manurhin, S.A. 1982-09-28 FRANCE Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
3281 3281 1989-03-01 Government of the Republic of Cape Verde 1988-11-10 CABO VERDE Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
3921 3921 1991-03-21 National Bank of Kuwait, S.A.K. 1990-09-28 KUWAIT Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New York     NY  
3922 3922 1994-03-21 AECL 1993-09-21 CANADA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Ottawa, Ontario,        
3923 3923 1994-03-21 Australian Nuclear Science & Technology Organization (ANSTO) 1992-10-19 AUSTRALIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New South Wales        
3924 3924 1994-03-21 Belgian Nuclear Research Centre (C.E.N./S.C.K.) 1993-01-13 BELGIUM Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Boeretang        
3925 3925 1994-03-21 Delft University of Tech 1993-05-03 NETHERLANDS Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Delft        
3926 3926 1994-03-21 Forschungszentrum Geesthacht GmbH (GKSS) 1992-10-19 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Geesthacht        
3927 3927 1994-03-21 Hahn - Meitner - Institut Berlin GmbH (HMI) Hahn - Meitner - Institut 1992-10-19 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Berlin        
3928 3928 1994-03-21 Japan Atomic Energy Research Institute (JAERI")" 1993-09-21 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
3929 3929 1994-03-21 Joint Research Centre 1992-10-19 NETHERLANDS Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Petten        
3930 3930 1994-03-21 Osterreichisches Forschungszentrum Seibersdorf GmbH (ASTRA) 1992-10-19 AUSTRIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Seibersdorf        
3931 3931 1994-03-21 Paul Scherrer Institute Research Reactor Saphir 1993-09-21 SWITZERLAND Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Villigen        
3932 3932 1994-03-21 Riso National Laboratory (RISO) 1992-10-19 DENMARK Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Roskilde        
3933 3933 1994-03-21 Studsvik Nuclear, A.B. (SKB) 1992-10-19 SWEDEN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Nykoping        
3934 3934 1994-03-21 Technical University of Munich 1993-05-03 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reaktorstation        
4993 4993 1992-04-03 Federation of Bankers' Association of Japan 1987-09-11 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
5279 5279 1994-04-15 Bank Leumi le-Israel, B.M. 1992-02-11 ISRAEL Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge New York     NY  
5280 5280 1994-04-15 French-American Chamber of Commerce in the U.S., Inc. 1983-09-21 FRANCE Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
5282 5282 1994-04-15 Nukem GmbH (NUKEM) 1992-10-19 GERMANY Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Alzenau        
5330 5330 1975-04-17 Embassy of Saudi Arabia 1970-12-09 SAUDI ARABIA Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
5331 5331 1975-04-17 Government of Brazil (Brazilian Aeronautical Commission) 1970-12-09 BRAZIL Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Rio de Janeiro        
7620 7620 1991-06-06 Ceres Enterprises, Inc. 1991-03-08 GREECE Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Reston     VA  
7621 7621 1991-06-06 Michelin Tire Company 1988-09-02 FRANCE Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Greenville     SC  
8019 8019 1994-06-23 Republic of Latvia 1993-03-22 LATVIA Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Washington     DC  
8322 8322 1982-06-30 Cayman Turtle Farm, Ltd. 1979-06-15 CAYMAN ISLANDS Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
8323 8323 1982-06-30 General Department of International Air Services (Aeroflot Soviet Airlines) 1980-03-10 USSR Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
11726 11726 1994-09-21 Colebrand, Ltd. 1990-01-31 GREAT BRITAIN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge London        
11906 11906 1974-09-30 Committee of Foreign-Owned Banks 1969-09-15 INTERNATIONAL Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge New York     NY  
12550 12550 1978-10-10 American Children's Citizenship Rights League (ACCRL) 1978-06-01 SWITZERLAND Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
12551 12551 1978-10-10 Samuel Cummings 1978-06-01 GREAT BRITAIN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
13889 13889 1970-11-13 Embassy of Saudi Arabia 1962-08-30 SAUDI ARABIA Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
13890 13890 1970-11-13 Government of Brazil (Brazilian Aeronautical Commission - Agency of the Ministry of Aeronautics) 1959-05-12 BRAZIL Shaw, Pittman, Potts & Trowbridge 1226 1959-05-12 Shaw, Pittman, Potts & Trowbridge Washington     DC  
13939 13939 1979-11-15 Hong Kong & Shanghai Banking Corporation 1979-11-27 HONG KONG Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
14328 14328 1979-11-30 Taiwan Power Company 1979-02-09 TAIWAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
16245 16245 1995-12-31 Federation of Bankers' Associations of Japan 1994-08-17 JAPAN Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Tokyo        
16306 16306 1995-12-31 Institute of International Bankers 1975-02-21 INTERNATIONAL Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge          
16337 16337 1995-12-31 Schnell-Bruter-Kernkraftwerksgesellschaft, MbH (SBK) 1993-08-03 GERMANY Shaw, Pittman, Potts & Trowbridge 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])
);