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

45 rows where Registration_Number = 2350

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Japan National Tourism Organization, Los Angeles · 45 ✖

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
531 531   2021-03-08 Shoji Kaoru Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
736 736   2022-04-06 Kitazawa Izumi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1826 1826   2022-09-22 Ando Katsuhiro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1827 1827   2022-09-22 Furihata Moe Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1831 1831   2022-09-22 Watanabe Kodai Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
2481 2481   2014-12-30 Scott Yohko Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
6179 6179 1993-02-05 1991-08-27 Sato Hiroyasu Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
6590 6590 2005-02-10 2002-03-28 Tonai Daisuke Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
6956 6956 1997-02-15 1993-02-05 Tomioka Hideki Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
9406 9406 1995-03-07 1991-03-08 Inaba Akira Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
9588 9588 2009-03-10 2007-10-19 Marutani Naoko Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
10057 10057 1985-03-16 1981-12-28 Kimura Yoshio Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
10878 10878 1991-03-27 1986-08-22 Tsukamuto Yasutake Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
10985 10985 2007-03-28 2004-09-27 Kida Susumu Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
11092 11092 2016-03-29 2014-12-30 Okada Ryoko Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
11126 11126 1981-03-30 1979-03-20 Hamano Hideo Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
12219 12219 2018-03-31 2017-02-06 Hasegawa Ryoko Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
12309 12309 2022-03-31 2020-03-02 Yamagishi Yu Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
12320 12320 2022-03-31 2019-08-22 Kishinaka Ayami Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
12803 12803 2012-04-05 2010-03-10 Aoshima Minako Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
13053 13053 2004-04-09 2002-03-28 Kubota Hiroshi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
14216 14216 2013-04-27 2010-02-24 Ota Yoshinobu Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
14497 14497 1974-04-30 1972-07-03 Ninomiya Albert Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
15938 15938 1998-05-08 1995-12-12 Katori Koichi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
19518 19518 1977-06-15 1975-03-23 Takano Tomio Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
19986 19986 2007-06-21 2004-09-27 Kakee Koichiro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
20250 20250 2004-06-25 2003-01-30 Amaya Naoaki Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
20480 20480 2016-06-28 2015-03-03 Kubota Takuro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
21345 21345 1999-06-30 1995-12-12 Nagami Masatoshi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
21865 21865 2016-06-30 2014-12-30 Harada Yasuyuki Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
21907 21907 2018-06-30 2015-09-01 Ota Yoshinobu Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
21919 21919 2019-06-30 2017-02-06 Osaki Shoichi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
22531 22531 1990-07-03 1986-11-24 Izumi Yuji Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
22562 22562 2002-07-04 2002-03-28 Kato Yukio Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
22608 22608 2009-07-05 2007-10-19 Watanabe Takeshi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
22752 22752 1974-07-08 1972-07-03 Terashima Hiroshi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
25283 25283 2015-07-31 2014-12-30 Tonai Daisuke Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
25769 25769 2022-08-01 2018-09-13 ASO Ryoji Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
26464 26464 2011-08-11 2010-03-10 Takizawa Hidenao Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
29305 29305 1978-09-07 1977-08-08 Kumaki Tokichi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
29772 29772 2008-09-14 2007-10-19 Tsukamoto Yasutake Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
30766 30766 2009-09-29 2007-10-19 Suzuki Zensuke Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
32566 32566 1976-10-10 1975-03-23 Kaneko Yoshihiro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
33279 33279 2020-10-20 2018-09-13 Kadowaki Keita Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
35984 35984 1981-11-17 1977-12-02 Tanaka Ichiro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017

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