FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

464 rows where Registrant_Name = "JETRO, New York"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

Registrant_Name

  • JETRO, New York · 464 ✖

City

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
65 65   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
235 235   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
252 252   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
301 301   2021-02-09 Hiramoto Ryota 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
418 418   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
646 646   2018-04-12 Suzuki Hiroyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
985 985   2019-06-11 Isobe Shinichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1061 1061   2017-06-27 Yanagisawa Tomoya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1102 1102   2018-07-05 Wakabayashi Kengo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1173 1173   2020-07-21 Ishihara Tetsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1287 1287   2017-08-08 Kasahara Ryo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1294 1294   2017-08-10 Nakazawa Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1338 1338   2014-08-19 Ohara Noriko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1384 1384   2019-08-27 Takeda Shinjiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1405 1405   2019-08-30 Ito Sadanori 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1414 1414   2017-08-31 Sakado Shunsuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1422 1422   2019-09-03 Machii Hiroaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1435 1435   2019-09-05 Yoshida Natsue 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1450 1450   2015-09-08 Kashiba Sakura 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1471 1471   2018-09-13 Niikura Yukari 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1531 1531   2020-09-24 Yoneyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1597 1597   2019-10-03 Inaba Kotohumi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1750 1750   2015-10-27 Tasaki O 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1837 1837   2020-11-05 Miyano Keita 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1866 1866   2020-11-11 Nota Masayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1933 1933   2019-11-19 Ara Takahiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1934 1934   2019-11-19 Suga Mikiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2193 2193   2019-12-23 Watanabe Takayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2200 2200   2019-12-26 Tani Hayato 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2853 2853 1974-01-03 1970-03-05 Tsuyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2932 2932 2008-01-04 2004-03-10 Silverbush Mark 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2939 2939 2019-01-04 2010-08-11 Watt Ian 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3082 3082 1965-01-08 1969-03-14 Hara Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3152 3152 2016-01-08 2014-05-27 Ota Naoko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3511 3511 2007-01-15 2006-05-26 Shih Dorothy 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3519 3519 2016-01-15 2010-08-04 Kobayashi Nagisa 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3670 3670 1972-01-18 1968-01-29 Ochi Norio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3893 3893 1972-01-22 1969-09-11 Nakaima Hirokazu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4496 4496 2017-01-30 2013-05-28 Horita Noriyasu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5307 5307 1977-02-01 1973-10-12 Miyata Kyoshiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5473 5473 2013-02-01 2010-04-09 Nagai Shingo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5576 5576 2002-02-02 1999-05-26 Shibata Sumio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5657 5657 1993-02-03 1990-02-02 Goto Hitoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5658 5658 1993-02-03 1990-02-02 Kojima Ainosuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5781 5781 2005-02-05 2002-07-31 Kaji Katsuhiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5782 5782 2008-02-05 2006-11-02 Takahashi Kei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5785 5785 2010-02-05 2004-10-19 Yamada Ryohei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5802 5802 1984-02-06 1983-04-29 Kawamoto Shigeo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5813 5813 1995-02-06 1992-02-04 Kameya Toshiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5814 5814 1995-02-06 1992-02-04 Kubota Hideo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5815 5815 1995-02-06 1992-02-04 Tanaka Hidetoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5816 5816 1995-02-06 1991-02-08 Hirai Sumihito 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5817 5817 1995-02-06 1991-02-08 Sasamoto Wataru 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5820 5820 1995-02-06 1992-08-06 Nishio Akemi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6032 6032 1988-02-09 1988-02-09 Furuta Hajime 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6378 6378 1994-02-14 1990-08-03 Ohashi Koshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6380 6380 1994-02-14 1989-08-14 Ito Kunio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6479 6479 1983-02-15 1980-04-30 Sugiura Shogo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6531 6531 2012-02-15 2009-09-25 Makino Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6699 6699 1975-02-17 1972-07-20 Kitamura Toshio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6788 6788 2016-02-19 2006-07-28 Yajima Haruko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7007 7007 2010-02-23 2009-05-07 Eiki-Law Maya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7205 7205 1973-02-26 1963-06-25 Hara Tsutomu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8123 8123 1964-03-01 1963-06-25 Someya Keiji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8827 8827 1980-03-07 1977-12-05 Kuraishi Fumiaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8853 8853 2001-03-07 1999-04-27 Goto Hideyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8875 8875 1975-03-08 1971-02-14 Mizuguchi Yasuhiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9045 9045 1991-03-11 1988-02-09 Ichikawa Nobuharu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9242 9242 1992-03-14 1988-08-16 Takahashi Toshiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9460 9460 1998-03-16 1995-02-06 Ando Masami 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9462 9462 1998-03-16 1995-07-28 Sagane Masakazu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9513 9513 1966-03-17 1963-06-25 Moriguchi Ryouichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9521 9521 1983-03-17 1980-12-09 Yamakawa Sigeru 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9523 9523 1986-03-17 1983-11-14 Okamoto Junichiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9656 9656 1997-03-18 1994-08-19 Hemmi Yoichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9720 9720 2003-03-19 2001-05-11 Mori Shigeki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9721 9721 2003-03-19 2000-09-18 Kometani Yuichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9760 9760 1966-03-20 1963-06-25 Aoyama Haruo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9763 9763 1973-03-20 1969-09-11 Yamazaki Tadao 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9766 9766 1977-03-20 1974-06-27 Kimura Nobuo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9797 9797 2015-03-20 2013-04-11 Eno Koichiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9798 9798 2015-03-20 2013-08-27 Koshiba Jane 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9802 9802 2019-03-20 2018-04-12 Okimoto Kyoko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9816 9816 1969-03-21 1966-01-27 Kuroda Akio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9824 9824 1983-03-21 1980-04-30 Shioya Takafusa 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9862 9862 1999-03-21 1996-02-05 Hattori Osamu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9928 9928 2010-03-22 2006-09-20 Nishimoto Keiichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9930 9930 2013-03-22 2010-03-31 Kimura Tadaaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9931 9931 2013-03-22 2010-09-15 Takeuchi Mikio 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10017 10017 2000-03-23 1999-04-27 Morii Motonao 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10022 10022 2002-03-23 1999-05-12 Deguchi Koji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10086 10086 1996-03-24 1992-08-06 Moriai Mineo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10088 10088 2000-03-24 1999-04-27 Usuzawa Tsutomu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10098 10098 2005-03-24 2004-04-07 Hirose Miki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10103 10103 2016-03-24 2014-10-30 Ogawa Yuta 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10105 10105 2017-03-24 2016-05-26 Hiagakiuchi Miyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10171 10171 1975-03-26 1966-04-25 Ishikawa Samuel 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10210 10210 2010-03-26 2009-04-02 Hikino Teruki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10211 10211 2010-03-26 2006-07-13 Kohama Teruhiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10212 10212 2010-03-26 2007-10-15 Yamade Koji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);