FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

459 rows where Registration_Number = 1643

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

Registration_Number

  • 1643 · 459 ✖

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
42 42   2017-01-05 Gonda Tadashi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
67 67   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
219 219   2017-01-31 Nagao Yusuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
220 220   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
241 241   2006-02-01 Tanaka Yumiko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
407 407   2011-03-02 Nakajima Daiki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
417 417   2016-03-03 Wakamatsu Isamu 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
635 635   2018-04-12 Suzuki Hiroyuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1040 1040   2019-06-11 Isobe Shinichi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1112 1112   2017-06-27 Yanagisawa Tomoya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1147 1147   2018-07-05 Wakabayashi Kengo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1208 1208   2016-07-19 Sugimoto Keiji 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1229 1229   2018-07-23 Hatakeyama Issei 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1341 1341   2017-08-08 Kasahara Ryo 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1353 1353   2017-08-10 Nakazawa Kiyoshi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1382 1382   2014-08-19 Ohara Noriko 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1438 1438   2019-08-27 Takeda Shinjiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1463 1463   2019-08-30 Ito Sadanori 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1472 1472   2017-08-31 Sakado Shunsuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1480 1480   2019-09-03 Machii Hiroaki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1487 1487   2019-09-05 Yoshida Natsue 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1508 1508   2015-09-08 Kashiba Sakura 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1537 1537   2018-09-13 Niikura Yukari 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1725 1725   2019-10-03 Inaba Kotohumi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
1880 1880   2015-10-27 Tasaki O 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2040 2040   2019-11-19 Ara Takahiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2041 2041   2019-11-19 Suga Mikiro 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2323 2323   2019-12-23 Watanabe Takayuki 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2329 2329   2019-12-26 Tani Hayato 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
2975 2975 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
3053 3053 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
3060 3060 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
3200 3200 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
3270 3270 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
3617 3617 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
3625 3625 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
3772 3772 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
3991 3991 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
4585 4585 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
5359 5359 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
5525 5525 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
5627 5627 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
5708 5708 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
5709 5709 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
5829 5829 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
5830 5830 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
5833 5833 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
5850 5850 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
5861 5861 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
5862 5862 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
5863 5863 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
5864 5864 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
5865 5865 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
5868 5868 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
6070 6070 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
6411 6411 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
6413 6413 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
6511 6511 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
6563 6563 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
6707 6707 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
6795 6795 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
7003 7003 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
7201 7201 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
8046 8046 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
8746 8746 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
8772 8772 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
8794 8794 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
8964 8964 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
9160 9160 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
9377 9377 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
9379 9379 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
9430 9430 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
9438 9438 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
9440 9440 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
9573 9573 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
9637 9637 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
9638 9638 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
9677 9677 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
9680 9680 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
9683 9683 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
9714 9714 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
9715 9715 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
9719 9719 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
9732 9732 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
9740 9740 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
9778 9778 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
9844 9844 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
9846 9846 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
9847 9847 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
9931 9931 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
9936 9936 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
10000 10000 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
10002 10002 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
10012 10012 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
10017 10017 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
10019 10019 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
10084 10084 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
10123 10123 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
10124 10124 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
10125 10125 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)
);
Powered by Datasette · Query took 277.852ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history