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

10 rows where Registrant_Name = "McDermott, Will & Emery"

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

Country/Location_Represented 3

State 2

Registrant_Name 1

  • McDermott, Will & Emery · 10 ✖

City 1

  • - 10
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
957 957 1995-01-01 Comite de Soporte al Comercio (COSOSCO) 1993-06-22 GUATEMALA McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Guatemala City        
1720 1720 1987-01-31 Federation of Japan Salmon Fisheries Cooperative Association 1983-10-28 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1722 1722 1987-01-31 Japan Fisheries Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1724 1724 1987-01-31 National Common Squid Fishery Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1725 1725 1987-01-31 National Driftnet Fishery Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1726 1726 1987-01-31 National Salmon Drift-Net Fisheries Association 1985-10-09 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
1727 1727 1987-01-31 Northern Seas Salmon Mothership Council 1983-10-28 JAPAN McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery Tokyo        
2498 2498 1996-02-14 Electronics Industries Association of Japan, IC/User's Committees 1995-05-17 JAPAN McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Tokyo        
2521 2521 1996-02-14 North West Water Process, Inc. 1995-07-14 GREAT BRITAIN McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Waukesha     WI  
5036 5036 1993-04-05 Electronic Industries Association of Japan 1992-04-06 JAPAN McDermott, Will & Emery 4643 1992-04-06 McDermott, Will & Emery Tokyo        

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