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"

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

Foreign_Principal 1

  • Japan External Trade Organization · 23 ✖

Country/Location_Represented 1

City 1

  • - 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
380 380   Japan External Trade Organization 1963-06-25 JAPAN JETRO, New York 1643 1963-06-25 JETRO, New York Tokyo        
2685 2685 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN Whitehouse Associates, Inc. 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
3945 3945 2003-03-24 Japan External Trade Organization 1977-08-08 JAPAN JETRO, Dallas (Japan External Trade Organization) 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) Tokyo        
4077 4077 1962-03-30 Japan External Trade Organization 1961-03-19 JAPAN McCann-Marschalk Company, Inc. 1477 1961-09-19 McCann-Marschalk Company, Inc. Tokyo        
4428 4428 1991-03-31 Japan External Trade Organization 1973-10-23 JAPAN JETRO, Puerto Rico 2468 1973-10-23 JETRO, Puerto Rico          
4540 4540 2003-03-31 Japan External Trade Organization 1992-08-10 JAPAN MS Research, Inc. 4697 1992-08-10 MS Research, Inc. Los Angeles     CA  
4557 4557 2004-03-31 Japan External Trade Organization 1999-09-02 JAPAN Japan Marketing 5327 1999-09-02 Japan Marketing 245 Peachtree Center Avenue, Suite 2208, Atlanta     GA  
4966 4966 2006-04-06 Japan External Trade Organization 2000-11-09 JAPAN Kojima & International Associates, Inc. 5395 2000-11-09 Kojima & International Associates, Inc. 245 Peachtree Center Avenue Marquis One Tower, Suite 2208 Atlanta, GA 30303     GA  
5016 5016 1980-04-09 Japan External Trade Organization 1968-05-20 JAPAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
7999 7999 2002-06-28 Japan External Trade Organization 1998-02-04 JAPAN Afridi, Angell & Pelletreau LLP 5231 1998-02-04 Afridi, Angell & Pelletreau LLP New York     NY  
9095 9095 1981-07-15 Japan External Trade Organization 1981-07-15 JAPAN Bozell & Jacobs, Inc. 3259 1981-07-15 Bozell & Jacobs, Inc. Houston     TX  
9558 9558 1982-07-31 Japan External Trade Organization 1981-08-13 JAPAN Charles von Loewenfeldt, Inc. 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
11608 11608 1993-09-24 Japan External Trade Organization 1992-07-20 JAPAN Ornberg & Associates 4691 1992-07-20 Ornberg & Associates Chicago     IL  
11729 11729 1973-09-30 Japan External Trade Organization 1971-10-07 JAPAN Ruder & Finn of California, Inc. 2284 1971-10-07 Ruder & Finn of California, Inc. Los Angeles     CA  
11774 11774 1986-09-30 Japan External Trade Organization 1961-09-27 JAPAN Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc.          
11879 11879 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        
12161 12161 1995-10-01 Japan External Trade Organization 1993-08-03 JAPAN Dickens & Webster 4837 1993-08-03 Dickens & Webster Chicago        
12853 12853 1994-10-27 Japan External Trade Organization 1994-04-25 JAPAN Coudert Brothers 3743 1985-10-02 Coudert Brothers New York     NY  
14122 14122 1982-11-30 Japan External Trade Organization 1971-11-04 JAPAN Bozell & Jacobs, Inc. 2287 1971-11-04 Bozell & Jacobs, Inc. Houston     TX  
14274 14274 2004-11-30 Japan External Trade Organization 2003-05-31 JAPAN Business Network Corporation 4513 1991-05-20 Business Network Corporation 2-5 Toranomon 2-chome Minato-ku, Tokyo 105      
14420 14420 1980-12-01 Japan External Trade Organization 1980-02-15 JAPAN Fraser Associates, Inc. 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
14576 14576 1977-12-05 Japan External Trade Organization 1972-01-25 JAPAN Japan Trade Center, New Orleans 2309 1972-01-25 Japan Trade Center, New Orleans Tokyo        
15865 15865 1989-12-31 Japan External Trade Organization 1986-08-27 JAPAN Klein Partnership 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])
);