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 Foreign_Principal = "Japan External Trade Organization" and State = "" sorted by Country/Location_Represented

View and edit SQL

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

State

Foreign_Principal

  • Japan External Trade Organization · 11

Country/Location_Represented

City

  • - 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
355   Japan External Trade Organization 1963-06-25 JAPAN 1643 1643 1963-06-25 JETRO, New York Tokyo        
3838 2003-03-24 Japan External Trade Organization 1977-08-08 JAPAN 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) Tokyo        
3969 1962-03-30 Japan External Trade Organization 1961-03-19 JAPAN 1477 1477 1961-09-19 McCann-Marschalk Company, Inc. Tokyo        
4320 1991-03-31 Japan External Trade Organization 1973-10-23 JAPAN 2468 2468 1973-10-23 JETRO, Puerto Rico          
4904 1980-04-09 Japan External Trade Organization 1968-05-20 JAPAN 1803 1803 1964-10-19 Modern Education Services, Inc.          
11604 1986-09-30 Japan External Trade Organization 1961-09-27 JAPAN 1481 1481 1961-09-27 Ruder Finn, Inc.          
11709 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN 3657 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        
11979 1995-10-01 Japan External Trade Organization 1993-08-03 JAPAN 4837 4837 1993-08-03 Dickens & Webster Chicago        
14073 2004-11-30 Japan External Trade Organization 2003-05-31 JAPAN 4513 4513 1991-05-20 Business Network Corporation 2-5 Toranomon 2-chome Minato-ku, Tokyo 105      
14213 1980-12-01 Japan External Trade Organization 1980-02-15 JAPAN 2844 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
14368 1977-12-05 Japan External Trade Organization 1972-01-25 JAPAN 2309 2309 1972-01-25 Japan Trade Center, New Orleans 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])
);