FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Short_Form_Last_Name = "Suzuki"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Date (date)
Registration_Number 15
- JETRO, New York 8
- JETRO, Chicago 5
- Japan National Tourism Organization 3
- JETRO, Los Angeles 3
- Japan Broadcasting Corporation 1
- JETRO, San Francisco 1
- Japan National Tourist Organization, Dallas 1
- Japan National Tourist Organization, San Francisco 1
- Japan National Tourism Organization, Los Angeles 1
- Heron, Burchette, Ruckert & Rothwell 1
- Daniel J. Edelman, Inc. 1
- Hakuhodo, Inc. 1
- Hakuhodo, Inc. 1
- Hakuhodo, Inc. 1
- Ogilvy Group LLC 1
Registrant_Name 13
- JETRO, New York 8
- JETRO, Chicago 5
- Hakuhodo, Inc. 3
- JETRO, Los Angeles 3
- Japan National Tourism Organization 3
- Daniel J. Edelman, Inc. 1
- Heron, Burchette, Ruckert & Rothwell 1
- JETRO, San Francisco 1
- Japan Broadcasting Corporation 1
- Japan National Tourism Organization, Los Angeles 1
- Japan National Tourist Organization, Dallas 1
- Japan National Tourist Organization, San Francisco 1
- Ogilvy Group LLC 1
City 9
- New York 10
- Chicago 6
- Los Angeles 4
- New York 3
- San Francisco 2
- Tokyo 2
- Chiyoda-ku, Tokyo 1
- Dallas 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3621 | 3621 | 1989-01-12 | 1986-10-17 | Suzuki | Akio | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
3971 | 3971 | 1995-01-17 | 1991-01-17 | Suzuki | Masahiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9146 | 9146 | 1971-03-05 | 1968-03-12 | Suzuki | Ken | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9514 | 9514 | 1984-03-09 | 1981-07-20 | Suzuki | Masachika | 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 |
10929 | 10929 | 1969-03-28 | 1966-08-09 | Suzuki | Tatsutaro | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
10998 | 10998 | 2019-03-28 | 2016-04-28 | Suzuki | Tomoya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
11096 | 11096 | 2019-03-29 | 2014-09-18 | Suzuki | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11709 | 11709 | 1995-03-31 | 1990-02-02 | Suzuki | Seiichi | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
11716 | 11716 | 1995-03-31 | 1992-03-10 | Suzuki | Minoru | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14717 | 14717 | 1996-04-30 | 1995-10-24 | Suzuki | Asao | Hakuhodo, Inc. 5064 | 1995-10-24 | Hakuhodo, Inc. | Kandabashi Park Building 19-1 | Chiyoda-ku | Tokyo | ||
16817 | 16817 | 1980-05-21 | 1977-12-05 | Suzuki | Ryohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
18395 | 18395 | 1968-06-01 | 1966-03-04 | Suzuki | Ryohei | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18746 | 18746 | 1980-06-03 | 1978-01-16 | Suzuki | Kazumi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19299 | 19299 | 1991-06-12 | 1989-03-09 | Suzuki | Minoru | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
19657 | 19657 | 1989-06-16 | 1988-07-29 | Suzuki | Yasuhiko | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | 1025 Thomas Jeff. Street, N.W. | Suite 700 | Washington | DC | 20007 |
19807 | 19807 | 1989-06-18 | 1986-08-19 | Suzuki | Shitaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20230 | 20230 | 1995-06-25 | 1992-08-06 | Suzuki | Yoshinori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20390 | 20390 | 2001-06-27 | 1999-05-12 | Suzuki | Yasutomo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22583 | 22583 | 1968-07-05 | 1965-08-03 | Suzuki | Hisashi | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
25089 | 25089 | 2006-07-31 | 2003-09-23 | Suzuki | Akira | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
25610 | 25610 | 1995-08-01 | 1995-02-28 | Suzuki | Asao | Hakuhodo, Inc. 4997 | 1995-02-28 | Hakuhodo, Inc. | Kandabashi Park Building 1-19 | Kanda-nishikicho 1-chome | Chiyoda-ku, Tokyo | ||
25707 | 25707 | 2015-08-01 | 2010-06-10 | Suzuki | Eiko | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28705 | 28705 | 2021-08-31 | 2021-08-10 | Suzuki | Nanaka | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
29299 | 29299 | 1968-09-07 | 1967-07-20 | Suzuki | Toshio | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
29665 | 29665 | 1978-09-13 | 1976-05-04 | Suzuki | Hisashi | 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 |
30766 | 30766 | 2009-09-29 | 2007-10-19 | Suzuki | Zensuke | 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 |
31160 | 31160 | 1997-09-30 | 1997-03-12 | Suzuki | Asao | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
33643 | 33643 | 2005-10-25 | 2002-12-11 | Suzuki | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38978 | 38978 | 1968-12-23 | 1965-07-30 | Suzuki | Akio | 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]) );