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

473 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 1

Registration_Number 1

Registrant_Name 1

  • JETRO, New York · 473 ✖

City 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
57 57   2020-01-09 Furujo Tatsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
241 241   2006-02-01 Tanaka Yumiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
301 301   2021-02-09 Hiramoto Ryota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
434 434   2011-03-02 Nakajima Daiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
453 453   2021-03-04 Ohde Mariko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
697 697   2022-04-01 Fujioka Yota JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1190 1190   2019-06-11 Isobe Shinichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1233 1233   2021-06-24 Fujita Yuri JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1253 1253   2017-06-27 Yanagisawa Tomoya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1357 1357   2020-07-21 Ishihara Tetsuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1453 1453   2017-08-08 Kasahara Ryo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1460 1460   2017-08-10 Nakazawa Kiyoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1502 1502   2014-08-19 Ohara Noriko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1533 1533   2019-08-27 Takeda Shinjiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1549 1549   2019-08-30 Ito Sadanori JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1586 1586   2019-09-03 Machii Hiroaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1598 1598   2019-09-05 Yoshida Natsue JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1621 1621   2015-09-08 Kashiba Sakura JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1625 1625   2021-09-09 Nakayama Takaaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1626 1626   2021-09-09 Okada Takuya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1638 1638   2018-09-13 Niikura Yukari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1684 1684   2020-09-24 Yoneyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1777 1777   2021-10-12 Tsukamoto Kazunari JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1979 1979   2020-11-05 Miyano Keita JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2006 2006   2020-11-11 Nota Masayuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2063 2063   2019-11-19 Ara Takahiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2064 2064   2019-11-19 Suga Mikiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2129 2129   2021-11-29 Hotta Motoi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2216 2216   2021-12-03 Rowland Amy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2231 2231   2021-12-06 Nambu Tomoshige JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2331 2331   2019-12-26 Tani Hayato JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2976 2976 1974-01-03 1970-03-05 Tsuyama Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3057 3057 2008-01-04 2004-03-10 Silverbush Mark JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3064 3064 2019-01-04 2010-08-11 Watt Ian JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3210 3210 1965-01-08 1969-03-14 Hara Kiyoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3280 3280 2016-01-08 2014-05-27 Ota Naoko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3646 3646 2007-01-15 2006-05-26 Shih Dorothy JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3654 3654 2016-01-15 2010-08-04 Kobayashi Nagisa JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
3836 3836 1972-01-18 1968-01-29 Ochi Norio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4061 4061 1972-01-22 1969-09-11 Nakaima Hirokazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
4669 4669 2017-01-30 2013-05-28 Horita Noriyasu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5501 5501 1977-02-01 1973-10-12 Miyata Kyoshiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5667 5667 2013-02-01 2010-04-09 Nagai Shingo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5770 5770 2002-02-02 1999-05-26 Shibata Sumio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5853 5853 1993-02-03 1990-02-02 Goto Hitoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5854 5854 1993-02-03 1990-02-02 Kojima Ainosuke JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5982 5982 2005-02-05 2002-07-31 Kaji Katsuhiko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5983 5983 2008-02-05 2006-11-02 Takahashi Kei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
5986 5986 2010-02-05 2004-10-19 Yamada Ryohei JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6006 6006 1984-02-06 1983-04-29 Kawamoto Shigeo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6017 6017 1995-02-06 1992-02-04 Kameya Toshiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6018 6018 1995-02-06 1992-02-04 Kubota Hideo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6019 6019 1995-02-06 1992-02-04 Tanaka Hidetoshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6020 6020 1995-02-06 1991-02-08 Hirai Sumihito JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6021 6021 1995-02-06 1991-02-08 Sasamoto Wataru JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6024 6024 1995-02-06 1992-08-06 Nishio Akemi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6241 6241 1988-02-09 1988-02-09 Furuta Hajime JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6488 6488 2021-02-12 2015-10-27 Tasaki O JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6592 6592 1994-02-14 1990-08-03 Ohashi Koshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6594 6594 1994-02-14 1989-08-14 Ito Kunio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6693 6693 1983-02-15 1980-04-30 Sugiura Shogo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6745 6745 2012-02-15 2009-09-25 Makino Hiroshi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
6925 6925 1975-02-17 1972-07-20 Kitamura Toshio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7021 7021 2016-02-19 2006-07-28 Yajima Haruko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7242 7242 2010-02-23 2009-05-07 Eiki-Law Maya JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
7445 7445 1973-02-26 1963-06-25 Hara Tsutomu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
8392 8392 1964-03-01 1963-06-25 Someya Keiji JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9116 9116 1980-03-07 1977-12-05 Kuraishi Fumiaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9142 9142 2001-03-07 1999-04-27 Goto Hideyuki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9166 9166 1975-03-08 1971-02-14 Mizuguchi Yasuhiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9343 9343 1991-03-11 1988-02-09 Ichikawa Nobuharu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9542 9542 1992-03-14 1988-08-16 Takahashi Toshiki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9766 9766 1998-03-16 1995-02-06 Ando Masami JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9768 9768 1998-03-16 1995-07-28 Sagane Masakazu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9819 9819 1966-03-17 1963-06-25 Moriguchi Ryouichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9827 9827 1983-03-17 1980-12-09 Yamakawa Sigeru JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9829 9829 1986-03-17 1983-11-14 Okamoto Junichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
9962 9962 1997-03-18 1994-08-19 Hemmi Yoichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10027 10027 2003-03-19 2001-05-11 Mori Shigeki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10028 10028 2003-03-19 2000-09-18 Kometani Yuichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10067 10067 1966-03-20 1963-06-25 Aoyama Haruo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10070 10070 1973-03-20 1969-09-11 Yamazaki Tadao JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10073 10073 1977-03-20 1974-06-27 Kimura Nobuo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10104 10104 2015-03-20 2013-04-11 Eno Koichiro JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10105 10105 2015-03-20 2013-08-27 Koshiba Jane JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10109 10109 2019-03-20 2018-04-12 Okimoto Kyoko JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10123 10123 1969-03-21 1966-01-27 Kuroda Akio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10131 10131 1983-03-21 1980-04-30 Shioya Takafusa JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10169 10169 1999-03-21 1996-02-05 Hattori Osamu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10235 10235 2010-03-22 2006-09-20 Nishimoto Keiichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10237 10237 2013-03-22 2010-03-31 Kimura Tadaaki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10238 10238 2013-03-22 2010-09-15 Takeuchi Mikio JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10325 10325 2000-03-23 1999-04-27 Morii Motonao JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10330 10330 2002-03-23 1999-05-12 Deguchi Koji JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10336 10336 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
10396 10396 1996-03-24 1992-08-06 Moriai Mineo JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10398 10398 2000-03-24 1999-04-27 Usuzawa Tsutomu JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10408 10408 2005-03-24 2004-04-07 Hirose Miki JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10414 10414 2016-03-24 2014-10-30 Ogawa Yuta JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
10416 10416 2017-03-24 2016-05-26 Hiagakiuchi Miyuki JETRO, New York 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])
);