FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Short_Form_Last_Name = "Watanabe"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 9
Registrant_Name 8
City 8
- New York 13
- Los Angeles 7
- Chicago 3
- Atlanta 1
- Chiyoda-ku, Tokyo 1
- New York 1
- San Francisco 1
- Tokyo 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1806 | 1806 | 2022-09-19 | Watanabe | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
1831 | 1831 | 2022-09-22 | Watanabe | Kodai | Japan National Tourism Organization, Los Angeles 2350 | 1972-07-03 | Japan National Tourism Organization, Los Angeles | 707 Wilshire Blvd. | Suite 4325 | Los Angeles | CA | 90017 | |
8724 | 8724 | 1978-03-01 | 1974-01-28 | Watanabe | Yasuo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9731 | 9731 | 1998-03-12 | 1995-09-18 | Watanabe | Hisanori | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10428 | 10428 | 1980-03-21 | 1977-07-19 | Watanabe | Masafumi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10891 | 10891 | 2004-03-27 | 2003-03-26 | Watanabe | Masanori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11087 | 11087 | 2009-03-29 | 2007-10-15 | Watanabe | Tomoko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13103 | 13103 | 2001-04-10 | 1998-08-06 | Watanabe | Hiroshi | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
13336 | 13336 | 2010-04-14 | 2006-12-20 | Watanabe | Takayuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
13340 | 13340 | 2016-04-14 | 2015-04-23 | Watanabe | Mai | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19979 | 19979 | 1995-06-21 | 1992-07-27 | Watanabe | Takeo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20001 | 20001 | 1971-06-22 | 1969-01-21 | Watanabe | Yusuke | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20048 | 20048 | 2007-06-22 | 2004-07-30 | Watanabe | Hiroyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20398 | 20398 | 2006-06-27 | 2003-08-08 | Watanabe | Mototaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20457 | 20457 | 2002-06-28 | 1999-08-10 | Watanabe | Takayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22520 | 22520 | 1981-07-03 | 1979-03-07 | Watanabe | Osamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22608 | 22608 | 2009-07-05 | 2007-10-19 | Watanabe | Takeshi | Japan National Tourism Organization, Los Angeles 2350 | 1972-07-03 | Japan National Tourism Organization, Los Angeles | 707 Wilshire Blvd. | Suite 4325 | Los Angeles | CA | 90017 |
23623 | 23623 | 2001-07-19 | 1999-04-27 | Watanabe | Hidenao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25446 | 25446 | 1960-08-01 | 1958-01-09 | Watanabe | Keitaro | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
25611 | 25611 | 1995-08-01 | 1995-02-28 | Watanabe | Kei | Hakuhodo, Inc. 4997 | 1995-02-28 | Hakuhodo, Inc. | Kandabashi Park Building 1-19 | Kanda-nishikicho 1-chome | Chiyoda-ku, Tokyo | ||
25985 | 25985 | 1989-08-05 | 1987-02-03 | Watanabe | Noboru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29122 | 29122 | 2009-09-03 | 2006-07-20 | Watanabe | Yumiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29369 | 29369 | 2017-09-07 | 2014-07-22 | Watanabe | Kenjiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30698 | 30698 | 2006-09-28 | 2004-03-04 | Watanabe | Tetsuji | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
30765 | 30765 | 2008-09-29 | 2005-08-16 | Watanabe | Masayoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31162 | 31162 | 1997-09-30 | 1997-03-12 | Watanabe | Kei | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
33444 | 33444 | 2021-10-22 | 2019-12-23 | Watanabe | Takayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38456 | 38456 | 2019-12-15 | 2015-09-29 | Watanabe | Takayuki | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
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]) );