FARA_All_ForeignPrincipals

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

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
362   Japan External Trade Organization 1963-06-25 JAPAN 1643 1643 1963-06-25 JETRO, New York Tokyo        
2581 1976-02-24 Japan External Trade Organization 1974-03-22 JAPAN 2190 2190 1970-02-24 Whitehouse Associates, Inc. Los Angeles     CA  
3798 2003-03-24 Japan External Trade Organization 1977-08-08 JAPAN 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) Tokyo        
3927 1962-03-30 Japan External Trade Organization 1961-03-19 JAPAN 1477 1477 1961-09-19 McCann-Marschalk Company, Inc. Tokyo        
4275 1991-03-31 Japan External Trade Organization 1973-10-23 JAPAN 2468 2468 1973-10-23 JETRO, Puerto Rico          
4387 2003-03-31 Japan External Trade Organization 1992-08-10 JAPAN 4697 4697 1992-08-10 MS Research, Inc. Los Angeles     CA  
4404 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  
4775 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  
4820 1980-04-09 Japan External Trade Organization 1968-05-20 JAPAN 1803 1803 1964-10-19 Modern Education Services, Inc.          
7719 2002-06-28 Japan External Trade Organization 1998-02-04 JAPAN 5231 5231 1998-02-04 Afridi, Angell & Pelletreau LLP New York     NY  
8792 1981-07-15 Japan External Trade Organization 1981-07-15 JAPAN 3259 3259 1981-07-15 Bozell & Jacobs, Inc. Houston     TX  
9250 1982-07-31 Japan External Trade Organization 1981-08-13 JAPAN 810 810 1954-01-05 Charles von Loewenfeldt, Inc. San Francisco     CA  
11241 1993-09-24 Japan External Trade Organization 1992-07-20 JAPAN 4691 4691 1992-07-20 Ornberg & Associates Chicago     IL  
11355 1973-09-30 Japan External Trade Organization 1971-10-07 JAPAN 2284 2284 1971-10-07 Ruder & Finn of California, Inc. Los Angeles     CA  
11400 1986-09-30 Japan External Trade Organization 1961-09-27 JAPAN 1481 1481 1961-09-27 Ruder Finn, Inc.          
11505 1996-09-30 Japan External Trade Organization 1995-06-22 JAPAN 3657 3657 1985-03-12 Daniel J. Edelman, Inc. Tokyo        
11767 1995-10-01 Japan External Trade Organization 1993-08-03 JAPAN 4837 4837 1993-08-03 Dickens & Webster Chicago        
12431 1994-10-27 Japan External Trade Organization 1994-04-25 JAPAN 3743 3743 1985-10-02 Coudert Brothers New York     NY  
13661 1982-11-30 Japan External Trade Organization 1971-11-04 JAPAN 2287 2287 1971-11-04 Bozell & Jacobs, Inc. Houston     TX  
13813 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      
13942 1980-12-01 Japan External Trade Organization 1980-02-15 JAPAN 2844 2844 1977-11-08 Fraser Associates, Inc. Tokyo        
14091 1977-12-05 Japan External Trade Organization 1972-01-25 JAPAN 2309 2309 1972-01-25 Japan Trade Center, New Orleans Tokyo        
15363 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)
);
Powered by Datasette · Query took 148.93ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history