FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Foreign_Principal = "Japan External Trade Organization"
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)
Registrant_Name
- Bozell & Jacobs, Inc. 2
- Afridi, Angell & Pelletreau LLP 1
- Business Network Corporation 1
- Charles von Loewenfeldt, Inc. 1
- Coudert Brothers 1
- Daniel J. Edelman, Inc. 1
- Dickens & Webster 1
- Fraser Associates, Inc. 1
- JETRO, Dallas (Japan External Trade Organization) 1
- JETRO, New York 1
- JETRO, Puerto Rico 1
- Japan Marketing 1
- Japan Trade Center, New Orleans 1
- Klein Partnership 1
- Kojima & International Associates, Inc. 1
- MS Research, Inc. 1
- McCann-Marschalk Company, Inc. 1
- Modern Education Services, Inc. 1
- Ornberg & Associates 1
- Ruder & Finn of California, Inc. 1
- Ruder Finn, Inc. 1
- Whitehouse Associates, Inc. 1
Foreign_Principal
- Japan External Trade Organization · 23 ✖
Country/Location_Represented
- JAPAN 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343 | 343 | Japan External Trade Organization | 1963-06-25 | JAPAN | 1643 1643 | 1963-06-25 | JETRO, New York | Tokyo | |||||
2583 | 2583 | 1976-02-24 | Japan External Trade Organization | 1974-03-22 | JAPAN | 2190 2190 | 1970-02-24 | Whitehouse Associates, Inc. | Los Angeles | CA | |||
3815 | 3815 | 2003-03-24 | Japan External Trade Organization | 1977-08-08 | JAPAN | 2820 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | Tokyo | ||||
3945 | 3945 | 1962-03-30 | Japan External Trade Organization | 1961-03-19 | JAPAN | 1477 1477 | 1961-09-19 | McCann-Marschalk Company, Inc. | Tokyo | ||||
4296 | 4296 | 1991-03-31 | Japan External Trade Organization | 1973-10-23 | JAPAN | 2468 2468 | 1973-10-23 | JETRO, Puerto Rico | |||||
4408 | 4408 | 2003-03-31 | Japan External Trade Organization | 1992-08-10 | JAPAN | 4697 4697 | 1992-08-10 | MS Research, Inc. | Los Angeles | CA | |||
4425 | 4425 | 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 | |||
4813 | 4813 | 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 | |||
4862 | 4862 | 1980-04-09 | Japan External Trade Organization | 1968-05-20 | JAPAN | 1803 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
7798 | 7798 | 2002-06-28 | Japan External Trade Organization | 1998-02-04 | JAPAN | 5231 5231 | 1998-02-04 | Afridi, Angell & Pelletreau LLP | New York | NY | |||
8881 | 8881 | 1981-07-15 | Japan External Trade Organization | 1981-07-15 | JAPAN | 3259 3259 | 1981-07-15 | Bozell & Jacobs, Inc. | Houston | TX | |||
9343 | 9343 | 1982-07-31 | Japan External Trade Organization | 1981-08-13 | JAPAN | 810 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
11370 | 11370 | 1993-09-24 | Japan External Trade Organization | 1992-07-20 | JAPAN | 4691 4691 | 1992-07-20 | Ornberg & Associates | Chicago | IL | |||
11486 | 11486 | 1973-09-30 | Japan External Trade Organization | 1971-10-07 | JAPAN | 2284 2284 | 1971-10-07 | Ruder & Finn of California, Inc. | Los Angeles | CA | |||
11531 | 11531 | 1986-09-30 | Japan External Trade Organization | 1961-09-27 | JAPAN | 1481 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
11636 | 11636 | 1996-09-30 | Japan External Trade Organization | 1995-06-22 | JAPAN | 3657 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Tokyo | ||||
11905 | 11905 | 1995-10-01 | Japan External Trade Organization | 1993-08-03 | JAPAN | 4837 4837 | 1993-08-03 | Dickens & Webster | Chicago | ||||
12588 | 12588 | 1994-10-27 | Japan External Trade Organization | 1994-04-25 | JAPAN | 3743 3743 | 1985-10-02 | Coudert Brothers | New York | NY | |||
13839 | 13839 | 1982-11-30 | Japan External Trade Organization | 1971-11-04 | JAPAN | 2287 2287 | 1971-11-04 | Bozell & Jacobs, Inc. | Houston | TX | |||
13991 | 13991 | 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 | |||
14130 | 14130 | 1980-12-01 | Japan External Trade Organization | 1980-02-15 | JAPAN | 2844 2844 | 1977-11-08 | Fraser Associates, Inc. | Tokyo | ||||
14283 | 14283 | 1977-12-05 | Japan External Trade Organization | 1972-01-25 | JAPAN | 2309 2309 | 1972-01-25 | Japan Trade Center, New Orleans | Tokyo | ||||
15566 | 15566 | 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
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) );