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 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 · 464 ✖

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
67 67   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
237 237   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
254 254   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
303 303   2021-02-09 Hiramoto Ryota 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
430 430   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
658 658   2018-04-12 Suzuki Hiroyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
997 997   2019-06-11 Isobe Shinichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1073 1073   2017-06-27 Yanagisawa Tomoya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1114 1114   2018-07-05 Wakabayashi Kengo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1185 1185   2020-07-21 Ishihara Tetsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1299 1299   2017-08-08 Kasahara Ryo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1306 1306   2017-08-10 Nakazawa Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1350 1350   2014-08-19 Ohara Noriko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1396 1396   2019-08-27 Takeda Shinjiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1417 1417   2019-08-30 Ito Sadanori 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1426 1426   2017-08-31 Sakado Shunsuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1434 1434   2019-09-03 Machii Hiroaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1447 1447   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
1483 1483   2018-09-13 Niikura Yukari 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1543 1543   2020-09-24 Yoneyama Hiroshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1609 1609   2019-10-03 Inaba Kotohumi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1761 1761   2015-10-27 Tasaki O 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1848 1848   2020-11-05 Miyano Keita 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1877 1877   2020-11-11 Nota Masayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1944 1944   2019-11-19 Ara Takahiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1945 1945   2019-11-19 Suga Mikiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2203 2203   2019-12-23 Watanabe Takayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2210 2210   2019-12-26 Tani Hayato 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2863 2863 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
2942 2942 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
2949 2949 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
3092 3092 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
3162 3162 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
3521 3521 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
3529 3529 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
3680 3680 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
3903 3903 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
4506 4506 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
5317 5317 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
5483 5483 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
5586 5586 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
5667 5667 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
5668 5668 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
5791 5791 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
5792 5792 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
5795 5795 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
5812 5812 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
5823 5823 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
5824 5824 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
5825 5825 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
5826 5826 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
5827 5827 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
5830 5830 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
6042 6042 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
6388 6388 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
6390 6390 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
6489 6489 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
6541 6541 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
6709 6709 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
6798 6798 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
7017 7017 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
7215 7215 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
8134 8134 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
8838 8838 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
8864 8864 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
8886 8886 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
9056 9056 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
9253 9253 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
9471 9471 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
9473 9473 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
9524 9524 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
9532 9532 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
9534 9534 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
9667 9667 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
9731 9731 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
9732 9732 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
9771 9771 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
9774 9774 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
9777 9777 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
9808 9808 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
9809 9809 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
9813 9813 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
9827 9827 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
9835 9835 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
9873 9873 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
9939 9939 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
9941 9941 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
9942 9942 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
10028 10028 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
10033 10033 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
10097 10097 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
10099 10099 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
10109 10109 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
10114 10114 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
10116 10116 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
10182 10182 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
10221 10221 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
10222 10222 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
10223 10223 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)
);