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

23 rows where Foreign_Principal = "Japan External Trade Organization" sorted by Country/Location_Represented descending

✎ View and edit SQL

This data as json, CSV (advanced)

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 · 23 ✖

Country/Location_Represented

City

  • - 23
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 355   Japan External Trade Organization 1963-06-25 JAPAN 1643 1643 1963-06-25 JETRO, New York Tokyo        
2598 2598 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN 2190 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
3838 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 3969 1962-03-30 Japan External Trade Organization 1961-03-19 JAPAN 1477 1477 1961-09-19 McCann-Marschalk Company, Inc. Tokyo        
4320 4320 1991-03-31 Japan External Trade Organization 1973-10-23 JAPAN 2468 2468 1973-10-23 JETRO, Puerto Rico          
4432 4432 2003-03-31 Japan External Trade Organization 1992-08-10 JAPAN 4697 4697 1992-08-10 MS Research, Inc. Los Angeles     CA  
4449 4449 2004-03-31 Japan External Trade Organization 1999-09-02 JAPAN 5327 5327 1999-09-02 Japan Marketing 245 Peachtree Center Avenue, Suite 2208, Atlanta     GA  
4855 4855 2006-04-06 Japan External Trade Organization 2000-11-09 JAPAN 5395 5395 2000-11-09 Kojima & International Associates, Inc. 245 Peachtree Center Avenue Marquis One Tower, Suite 2208 Atlanta, GA 30303     GA  
4904 4904 1980-04-09 Japan External Trade Organization 1968-05-20 JAPAN 1803 1803 1964-10-19 Modern Education Services, Inc.          
7860 7860 2002-06-28 Japan External Trade Organization 1998-02-04 JAPAN 5231 5231 1998-02-04 Afridi, Angell & Pelletreau LLP New York     NY  
8949 8949 1981-07-15 Japan External Trade Organization 1981-07-15 JAPAN 3259 3259 1981-07-15 Bozell & Jacobs, Inc. Houston     TX  
9412 9412 1982-07-31 Japan External Trade Organization 1981-08-13 JAPAN 810 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
11443 11443 1993-09-24 Japan External Trade Organization 1992-07-20 JAPAN 4691 4691 1992-07-20 Ornberg & Associates Chicago     IL  
11559 11559 1973-09-30 Japan External Trade Organization 1971-10-07 JAPAN 2284 2284 1971-10-07 Ruder & Finn of California, Inc. Los Angeles     CA  
11604 11604 1986-09-30 Japan External Trade Organization 1961-09-27 JAPAN 1481 1481 1961-09-27 Ruder Finn, Inc.          
11709 11709 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN 3657 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        
11979 11979 1995-10-01 Japan External Trade Organization 1993-08-03 JAPAN 4837 4837 1993-08-03 Dickens & Webster Chicago        
12665 12665 1994-10-27 Japan External Trade Organization 1994-04-25 JAPAN 3743 3743 1985-10-02 Coudert Brothers New York     NY  
13921 13921 1982-11-30 Japan External Trade Organization 1971-11-04 JAPAN 2287 2287 1971-11-04 Bozell & Jacobs, Inc. Houston     TX  
14073 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 14213 1980-12-01 Japan External Trade Organization 1980-02-15 JAPAN 2844 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
14368 14368 1977-12-05 Japan External Trade Organization 1972-01-25 JAPAN 2309 2309 1972-01-25 Japan Trade Center, New Orleans Tokyo        
15652 15652 1989-12-31 Japan External Trade Organization 1986-08-27 JAPAN 3878 3878 1986-08-27 Klein Partnership Houston     TX  

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