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

11 rows where Country/Location_Represented = "JAPAN" and Registrant_Name = "Akin, Gump, Strauss, Hauer & Feld, LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 4

City 2

Registrant_Name 1

  • Akin, Gump, Strauss, Hauer & Feld, LLP · 11 ✖

Country/Location_Represented 1

  • JAPAN · 11 ✖
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
161 161   Embassy of Japan 2011-03-02 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
1511 1511 1993-01-25 Fujitsu Microelectronics, Inc. - Fujitsu, Ltd. 1986-04-17 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Tokyo        
1512 1512 1993-01-25 Matsushita Electronics Corporation 1990-11-27 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Osaka        
4749 4749 2015-03-31 Ministry of Foreign Affairs, Embassy 2014-05-16 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
5173 5173 1995-04-11 Mazda Motor Corporation 1991-09-24 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Hiroshima        
7279 7279 2018-05-31 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) on behalf of Members of the National Diet of Japan 2018-07-20 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 1-3-2, Otemachi, Chiyoda-ku Tokyo 100-8188      
8071 8071 1995-06-24 Ajinomoto U.S.A., Inc. 1993-03-19 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Teaneck     NJ  
8073 8073 1995-06-24 Matsushita Electric Industrial Company, Ltd. 1990-11-26 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Osaka        
8076 8076 1996-06-24 Fujitsu America, Inc. 1987-08-07 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP San Jose     CA  
8077 8077 1996-06-24 Fujitsu, Ltd. 1986-12-11 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Tokoyo        
8078 8078 1996-06-24 Mazda (North America), Inc. 1991-09-24 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Washington     DC  

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