FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Nakamura"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 9
Registrant_Name 9
City 8
- New York 3
- Chicago 2
- New York 2
- San Francisco 2
- Atlanta 1
- Houston 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4919 | 4919 | 1967-01-31 | 1967-05-02 | Nakamura | Kohji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8841 | 8841 | 2004-03-01 | 2002-12-31 | Nakamura | Satoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
11219 | 11219 | 2011-03-30 | 2008-04-15 | Nakamura | Kyoichi | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
12914 | 12914 | 2012-04-07 | 2009-09-02 | Nakamura | Toshihiko | Kobe Trade Information Office 2438 | 1973-07-02 | Kobe Trade Information Office | 1001 Fourth Avenue | Suite 4310 | Seattle | WA | 98154 |
13877 | 13877 | 2000-04-21 | 1999-08-03 | Nakamura | Takako | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
16252 | 16252 | 1987-05-13 | 1984-09-06 | Nakamura | Toshio | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
20756 | 20756 | 1965-06-30 | 1963-03-07 | Nakamura | Mesao | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
25465 | 25465 | 1967-08-01 | 1965-02-26 | Nakamura | Toru | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
32147 | 32147 | 1981-10-02 | 1979-03-13 | Nakamura | Toru | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
34808 | 34808 | 1960-11-01 | 1959-04-02 | Nakamura | Shigenao | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
36121 | 36121 | 1995-11-20 | 1993-02-03 | Nakamura | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36325 | 36325 | 2002-11-24 | 1999-10-13 | Nakamura | Yukio | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
39251 | 39251 | 1983-12-28 | 1981-08-03 | Nakamura | Yoshio | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 |
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]) );