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

21 rows where Registrant_Name = "Wilmer, Cutler & Pickering"

✎ 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)

State 3

Registrant_Name 1

  • Wilmer, Cutler & Pickering · 21 ✖

City 1

  • - 21
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
1387 1387 1995-01-17 Commission of the European Union 1994-03-11 INTERNATIONAL Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Washington     DC  
1389 1389 1996-01-17 Shoreline Mutual (Bermuda), Ltd. 1994-05-04 BERMUDA Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Hamilton        
2483 2483 1984-02-14 Hapag-Lloyd Aktiengesellschaft 1982-04-08 GERMANY, FEDERAL REPUBLIC OF Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Hamburg        
2501 2501 1996-02-14 Swiss Bankers' Association 1992-10-13 SWITZERLAND Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Basle        
3280 3280 1986-03-01 Government of the Federal Republic of Germany 1986-03-07 GERMANY, FEDERAL REPUBLIC OF Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Bonn        
4516 4516 1992-03-31 European Communities 1987-11-23 GREAT BRITAIN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Washington     DC  
4881 4881 1983-04-01 AEG-Kanis Turbinenfabrik GmbH 1982-09-27 GERMANY, FEDERAL REPUBLIC OF Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Essen        
5619 5619 1984-04-27 Kingdom of the Netherlands 1982-04-08 NETHERLANDS Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Washington     DC  
6568 6568 1991-05-15 Rafael Group 1990-11-07 BRITISH VIRGIN ISLANDS Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering New York     NY  
7137 7137 1994-05-31 Deutsche Lufthansa, A.G. 1994-02-15 GERMANY Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Cologne        
8111 8111 1989-06-26 Enewetak/Ujelang Local Government Council 1988-11-04 MARSHALL ISLANDS Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Nitijela Majuro        
9327 9327 1984-07-17 British Gas Corporation 1983-11-01 GREAT BRITAIN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering London        
11838 11838 1989-09-26 Air New Zealand, Ltd. 1988-05-25 NEW ZEALAND Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Auckland        
12569 12569 1995-10-09 Banking Federation of the European Union 1995-05-25 INTERNATIONAL Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Bruxelles        
12716 12716 1990-10-15 Deutsche Lufthansa Aktiengesellschaft 1983-04-01 GERMANY Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Koelin        
13826 13826 1989-11-08 Amadeus Global Travel Distribution, S.A. 1989-05-08 SPAIN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Madrid        
13862 13862 1986-11-10 Commission of the European Communities 1984-05-09 INTERNATIONAL Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Brussels        
13863 13863 1986-11-10 Sumitomo Metal Industries, Ltd. 1984-11-08 JAPAN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Tokyo        
13984 13984 1989-11-15 Government of Tibet In Exile 1985-07-10 TIBET Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering          
14868 14868 1988-12-07 Grand Metropolitan, PLC 1988-10-25 GREAT BRITAIN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering          
14869 14869 1988-12-07 Wendell Investments, Ltd. 1988-10-25 GREAT BRITAIN Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 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])
);