FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where City = "Tokyo"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5543 | 5543 | 2019-01-31 | 2019-03-05 | Akimoto | Satohiro | 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 | ||
5544 | 5544 | 2019-01-31 | 2019-03-05 | Ito | Shinnosuke | 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 | ||
5545 | 5545 | 2019-01-31 | 2019-03-05 | Kurokawa | Ken | 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 | ||
5546 | 5546 | 2019-01-31 | 2019-03-05 | Nemoto | Katsunori | 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 | ||
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 | ||
8119 | 8119 | 2001-02-28 | 2001-02-07 | Kurokawa | Keiichi | Hakuhodo Incorporated 5409 | 2001-02-07 | Hakuhodo Incorporated | Grandpark Tower | 3-4-1 Shibaura Minato-ku | Tokyo | ||
8120 | 8120 | 2001-02-28 | 2001-02-07 | Mihara | Tamaki | Hakuhodo Incorporated 5409 | 2001-02-07 | Hakuhodo Incorporated | Grandpark Tower | 3-4-1 Shibaura Minato-ku | Tokyo | ||
8121 | 8121 | 2001-02-28 | 2001-02-07 | Takahashi | Masayoshi | Hakuhodo Incorporated 5409 | 2001-02-07 | Hakuhodo Incorporated | Grandpark Tower | 3-4-1 Shibaura Minato-ku | Tokyo | ||
8480 | 8480 | 2000-02-29 | 2000-02-18 | Ando | Motoatsu | Hakuhodo Incorporated 5359 | 2000-02-18 | Hakuhodo Incorporated | Granpark Tower | 3-4-1 Shibaura | Tokyo | ||
8481 | 8481 | 2000-02-29 | 2000-02-18 | Kitaoka | Shoji | Hakuhodo Incorporated 5359 | 2000-02-18 | Hakuhodo Incorporated | Granpark Tower | 3-4-1 Shibaura | Tokyo | ||
8482 | 8482 | 2000-02-29 | 2000-02-18 | Kurokawa | Keiichi | Hakuhodo Incorporated 5359 | 2000-02-18 | Hakuhodo Incorporated | Granpark Tower | 3-4-1 Shibaura | Tokyo | ||
10469 | 10469 | 1999-03-21 | 1999-02-18 | Ando | Motoatsu | Hakuhodo, Inc. 5301 | 1999-02-18 | Hakuhodo, Inc. | Granpark Tower | 3-4-1 Shibaura, Minato-ku | Tokyo | ||
10470 | 10470 | 1999-03-21 | 1999-02-18 | Chidori | Kimitatsu | Hakuhodo, Inc. 5301 | 1999-02-18 | Hakuhodo, Inc. | Granpark Tower | 3-4-1 Shibaura, Minato-ku | Tokyo | ||
10471 | 10471 | 1999-03-21 | 1999-02-18 | Takahashi | Masayoshi | Hakuhodo, Inc. 5301 | 1999-02-18 | Hakuhodo, Inc. | Granpark Tower | 3-4-1 Shibaura, Minato-ku | Tokyo | ||
14334 | 14334 | 1987-04-29 | 1987-05-15 | Yamazaki | Toshiko | Japan Center for Information & Cultural Affairs (JCIC) 3535 | 1983-10-28 | Japan Center for Information & Cultural Affairs (JCIC) | 2-7-7 Hirakawa-Cho | Chiyoda-Ku | Tokyo | ||
14336 | 14336 | 1987-04-29 | 1983-10-29 | Asabuki | Makoto | Japan Center for Information & Cultural Affairs (JCIC) 3535 | 1983-10-28 | Japan Center for Information & Cultural Affairs (JCIC) | 2-7-7 Hirakawa-Cho | Chiyoda-Ku | Tokyo | ||
14714 | 14714 | 1996-04-30 | 1995-10-24 | Murakami | Katsunari | Hakuhodo, Inc. 5064 | 1995-10-24 | Hakuhodo, Inc. | Kandabashi Park Building 19-1 | Chiyoda-ku | Tokyo | ||
14715 | 14715 | 1996-04-30 | 1995-10-24 | Nakayama | Toshiaki | Hakuhodo, Inc. 5064 | 1995-10-24 | Hakuhodo, Inc. | Kandabashi Park Building 19-1 | Chiyoda-ku | Tokyo | ||
14716 | 14716 | 1996-04-30 | 1995-10-24 | Otsuka | Atsuo | Hakuhodo, Inc. 5064 | 1995-10-24 | Hakuhodo, Inc. | Kandabashi Park Building 19-1 | Chiyoda-ku | Tokyo | ||
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 | ||
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 | ||
31161 | 31161 | 1997-09-30 | 1997-03-12 | Umeda | Kazuhiko | Hakuhodo, Inc. 5163 | 1997-03-12 | Hakuhodo, Inc. | 3-4-1 Shibaura | Minato-ku | Tokyo | ||
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 | ||
42194 | 42194 | 2018-12-31 | 2018-07-20 | Uozumi | Yasuhiro | 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 |
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]) );