FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Wada"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 7
Registrant_Name 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5547 | 5547 | 2019-01-31 | 2019-03-05 | Wada | Teruko | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 | 2018-07-20 | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) | Keidanren Kaikan, 1-3-2 | Otemachi, Chiyoda-ku TOKYO | Tokyo | ||
10888 | 10888 | 2001-03-27 | 1998-10-15 | Wada | Aya | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11892 | 11892 | 2002-03-31 | 2000-09-15 | Wada | Yasuhiro | U.S. Representative Offices of the Development Bank of Japan 5344 | 1999-11-18 | U.S. Representative Offices of the Development Bank of Japan | 1251 Avenue of the Americas | Suite 830 | New York | NY | 10020 |
19459 | 19459 | 2016-06-14 | 2013-07-18 | Wada | Junichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20405 | 20405 | 2013-06-27 | 2010-06-30 | Wada | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25445 | 25445 | 1960-08-01 | 1958-01-09 | Wada | Yoshio | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
29172 | 29172 | 1999-09-04 | 1996-10-18 | Wada | Susumu | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
32570 | 32570 | 1986-10-10 | 1982-07-28 | Wada | Masatake | New Energy Development Organization 3393 | 1982-07-28 | New Energy Development Organization | 1800 K Street, N.W. | Suite 924 | Washington | DC | 20006 |
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]) );