FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Short_Form_First_Name = "Hiroyuki"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- JETRO, New York 6
- JETRO, Los Angeles 2
- JETRO, Chicago 2
- JETRO, Houston 2
- Japan National Tourist Organization, San Francisco 2
- Japan Economic Institute of America 1
- Arnold & Porter Kaye Scholer LLP 1
- JETRO, San Francisco 1
- JETRO, Atlanta 1
- NHK Cosmomedia America, Inc. 1
- Japan Center for Intercultural Communications (JCIC) 1
Registrant_Name 11
- JETRO, New York 6
- JETRO, Chicago 2
- JETRO, Houston 2
- JETRO, Los Angeles 2
- Japan National Tourist Organization, San Francisco 2
- Arnold & Porter Kaye Scholer LLP 1
- JETRO, Atlanta 1
- JETRO, San Francisco 1
- Japan Center for Intercultural Communications (JCIC) 1
- Japan Economic Institute of America 1
- NHK Cosmomedia America, Inc. 1
City 8
- New York 7
- San Francisco 3
- Chicago 2
- Houston 2
- Los Angeles 2
- Washington 2
- Atlanta 1
- Tokyo, 102-0093 1
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1818 | 1818 | 2022-09-21 | Nemoto | Hiroyuki | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1957 | 1957 | 2022-10-14 | Akiyama | Hiroyuki | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 | |
4209 | 4209 | 1986-01-21 | 1984-09-26 | Kamano | Hiroyuki | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
10063 | 10063 | 1996-03-16 | 1992-10-29 | Nemoto | Hiroyuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
10375 | 10375 | 1983-03-20 | 1980-07-16 | Miyao | Hiroyuki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10636 | 10636 | 2021-03-23 | 2018-04-12 | Suzuki | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12091 | 12091 | 2011-03-31 | 1997-08-27 | Fukuyama | Hiroyuki | Japan Center for Intercultural Communications (JCIC) 4998 | 1995-03-01 | Japan Center for Intercultural Communications (JCIC) | 2-7-7 Hirakawa-cho | Chiyoda-ku | Tokyo, 102-0093 | ||
16981 | 16981 | 2009-05-23 | 2004-10-19 | Akiyama | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20891 | 20891 | 1974-06-30 | 1972-08-08 | Kono | Hiroyuki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
21414 | 21414 | 2001-06-30 | 1998-10-15 | Yamamoto | Hiroyuki | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | 100 Broadway | 15th Floor | New York | NY | 10005-1983 |
22643 | 22643 | 1997-07-06 | 1994-07-14 | Hashimoto | Hiroyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
22675 | 22675 | 1971-07-07 | 1968-05-06 | Tsubaki | Hiroyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
24025 | 24025 | 2000-07-25 | 1998-02-19 | Yano | Hiroyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
24571 | 24571 | 2002-07-30 | 2000-04-05 | Makiura | Hiroyuki | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
25088 | 25088 | 2006-07-31 | 2003-08-08 | Mitsuishi | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25302 | 25302 | 2017-07-31 | 2014-09-23 | Kawabata | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26398 | 26398 | 2010-08-10 | 2006-07-14 | Tanaka | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
28925 | 28925 | 2002-09-01 | 1999-11-03 | Hosokawa | Hiroyuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
31253 | 31253 | 2000-09-30 | 1997-08-08 | Takahashi | Hiroyuki | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
33415 | 33415 | 1988-10-22 | 1985-01-07 | Wakabayashi | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_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]) );