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

465 rows where Registration_Number = 1643

✎ 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

  • 1643 · 465 ✖

Registrant_Name

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
72 72   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
238 238   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
255 255   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
302 302   2021-02-09 Hiramoto Ryota 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
421 421   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
439 439   2021-03-04 Ohde Mariko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
692 692   2018-04-12 Suzuki Hiroyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1063 1063   2019-06-11 Isobe Shinichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1133 1133   2017-06-27 Yanagisawa Tomoya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1172 1172   2018-07-05 Wakabayashi Kengo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1235 1235   2020-07-21 Ishihara Tetsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1327 1327   2017-08-08 Kasahara Ryo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1334 1334   2017-08-10 Nakazawa Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1376 1376   2014-08-19 Ohara Noriko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1405 1405   2019-08-27 Takeda Shinjiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1420 1420   2019-08-30 Ito Sadanori 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1428 1428   2017-08-31 Sakado Shunsuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1436 1436   2019-09-03 Machii Hiroaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1448 1448   2019-09-05 Yoshida Natsue 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1462 1462   2015-09-08 Kashiba Sakura 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1479 1479   2018-09-13 Niikura Yukari 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1537 1537   2020-09-24 Yoneyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1600 1600   2019-10-03 Inaba Kotohumi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1741 1741   2015-10-27 Tasaki O 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1819 1819   2020-11-05 Miyano Keita 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1847 1847   2020-11-11 Nota Masayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1912 1912   2019-11-19 Ara Takahiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1913 1913   2019-11-19 Suga Mikiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2164 2164   2019-12-23 Watanabe Takayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2170 2170   2019-12-26 Tani Hayato 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2825 2825 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
2904 2904 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
2911 2911 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
3054 3054 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
3124 3124 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
3485 3485 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
3493 3493 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
3666 3666 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
3889 3889 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
4494 4494 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
5309 5309 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
5475 5475 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
5578 5578 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
5661 5661 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
5662 5662 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
5785 5785 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
5786 5786 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
5789 5789 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
5806 5806 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
5817 5817 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
5818 5818 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
5819 5819 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
5820 5820 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
5821 5821 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
5824 5824 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
6036 6036 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
6383 6383 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
6385 6385 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
6484 6484 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
6536 6536 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
6714 6714 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
6806 6806 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
7025 7025 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
7223 7223 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
8153 8153 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
8860 8860 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
8886 8886 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
8908 8908 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
9078 9078 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
9275 9275 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
9495 9495 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
9497 9497 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
9548 9548 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
9556 9556 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
9558 9558 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
9691 9691 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
9755 9755 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
9756 9756 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
9795 9795 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
9798 9798 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
9801 9801 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
9832 9832 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
9833 9833 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
9837 9837 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
9851 9851 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
9859 9859 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
9897 9897 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
9964 9964 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
9966 9966 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
9967 9967 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
10053 10053 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
10058 10058 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
10123 10123 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
10125 10125 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
10135 10135 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
10141 10141 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
10143 10143 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
10210 10210 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
10249 10249 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
10250 10250 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

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