FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
199 rows where Document_Type = "Short-Form" and Registration_Number = 1850
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
424 | 424 | 1978-01-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SUGURU MURAKAMI | Available-FARA-Public-Office | ||
4485 | 4485 | 2001-01-10 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Sano,Shun | Available-FARA-Public-Office | ||
4486 | 4486 | 2001-01-10 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Tomita,Tetsutaro | Available-FARA-Public-Office | ||
4487 | 4487 | 2001-01-10 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Yoshida,Shigeo | Available-FARA-Public-Office | ||
6901 | 6901 | 1981-01-23 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | EIICHI NAGATA | Available-FARA-Public-Office | ||
6902 | 6902 | 1981-01-23 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | MASAAKI TAKIGAWA | Available-FARA-Public-Office | ||
6903 | 6903 | 1981-01-23 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SUMIO TANAKA | Available-FARA-Public-Office | ||
13512 | 13512 | 1965-02-02 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | EIICHI IIMURA | Available-FARA-Public-Office | ||
13513 | 13513 | 1965-02-02 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | FUMIO INUI | Available-FARA-Public-Office | ||
13514 | 13514 | 1965-02-02 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HARUMI YOKOTA | Available-FARA-Public-Office | ||
13515 | 13515 | 1965-02-02 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HIROFUMI SHIMIZU | Available-FARA-Public-Office | ||
13516 | 13516 | 1965-02-02 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | JOSEPH S. HIKIDA | Available-FARA-Public-Office | ||
14522 | 14522 | 1971-02-06 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TSUYOSHI OCHI | Available-FARA-Public-Office | ||
14974 | 14974 | 1971-02-08 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HITOSHI TAKANO | Available-FARA-Public-Office | ||
18368 | 18368 | 1982-02-24 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HIDEO SETOYA | Available-FARA-Public-Office | ||
18369 | 18369 | 1982-02-24 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TOMIYUKI KUDO | Available-FARA-Public-Office | ||
18370 | 18370 | 1982-02-24 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TOSAKU KOBAYASHI | Available-FARA-Public-Office | ||
19193 | 19193 | 2002-02-27 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Washio,Tomoharu | Available-FARA-Public-Office | ||
19838 | 19838 | 2001-02-28 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Tokoro,Terue | Available-FARA-Public-Office | ||
20566 | 20566 | 1967-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KEI MATSUMOTO | Available-FARA-Public-Office | ||
20628 | 20628 | 1970-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | IZUMI NII | Available-FARA-Public-Office | ||
20731 | 20731 | 1973-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | MASAHIRO SOEJIMA | Available-FARA-Public-Office | ||
20787 | 20787 | 1974-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | EIICHI KAJIKAWA | Available-FARA-Public-Office | ||
20991 | 20991 | 1978-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | NOBUYUKI OTERA | Available-FARA-Public-Office | ||
21307 | 21307 | 1982-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HIDEO YANAGISAWA | Available-FARA-Public-Office | ||
21629 | 21629 | 1985-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YOSHICHIKA TERASAWA | Available-FARA-Public-Office | ||
22473 | 22473 | 1990-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YOSHIYA ISHIZAKI | Available-FARA-Public-Office | ||
23747 | 23747 | 1993-03-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YOSHITAKA TOYONAGA | Available-FARA-Public-Office | ||
24856 | 24856 | 2003-03-03 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Ando,Koichi | Available-FARA-Public-Office | ||
24857 | 24857 | 2003-03-03 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Horiguchi,Hikaru | Available-FARA-Public-Office | ||
24858 | 24858 | 2003-03-03 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Morita,Aiichiro | Available-FARA-Public-Office | ||
24859 | 24859 | 2003-03-03 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Saito,Hidemi | Available-FARA-Public-Office | ||
24860 | 24860 | 2003-03-03 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Sho,Hideki | Available-FARA-Public-Office | ||
25037 | 25037 | 1966-03-04 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | RYOHEI SUZUKI | Available-FARA-Public-Office | ||
25038 | 25038 | 1966-03-04 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YOSHIHIRO OKAWARA | Available-FARA-Public-Office | ||
25039 | 25039 | 1966-03-04 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | ZENZABURO ISHIKAWA | Available-FARA-Public-Office | ||
25041 | 25041 | 1969-03-04 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | AKIRA OSHIKAWA | Available-FARA-Public-Office | ||
25042 | 25042 | 1969-03-04 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | CHIHIRO IZAWA | Available-FARA-Public-Office | ||
25137 | 25137 | 2004-03-04 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Nagi,Hidetakara | Available-FARA-Public-Office | ||
25138 | 25138 | 2004-03-04 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Watanabe,Tetsuji | Available-FARA-Public-Office | ||
25784 | 25784 | 1972-03-07 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HAJIME TOKUMASU | Available-FARA-Public-Office | ||
25785 | 25785 | 1972-03-07 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | NARUMI MATSUO | Available-FARA-Public-Office | ||
25786 | 25786 | 1972-03-07 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TSUGIO KUSAJIMA | Available-FARA-Public-Office | ||
26635 | 26635 | 1992-03-10 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | MINORU SUZUKI | Available-FARA-Public-Office | ||
26636 | 26636 | 1992-03-10 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TOSHIMICHI YANASHIMA | Available-FARA-Public-Office | ||
26950 | 26950 | 1977-03-11 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | GUNZO ISHIKAWA | Available-FARA-Public-Office | ||
26951 | 26951 | 1977-03-11 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHINICHI SAITO | Available-FARA-Public-Office | ||
27220 | 27220 | 1968-03-12 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KAZUO YAMAHATA | Available-FARA-Public-Office | ||
27221 | 27221 | 1968-03-12 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KEN SUZUKI | Available-FARA-Public-Office | ||
27222 | 27222 | 1968-03-12 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | MICHIO YAKABE | Available-FARA-Public-Office | ||
27482 | 27482 | 1996-03-13 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | IKUHIRO MORITA | Available-FARA-Public-Office | ||
27483 | 27483 | 1996-03-13 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TAKAO MONDEN | Available-FARA-Public-Office | ||
27484 | 27484 | 1996-03-13 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YUKIO KOBAYASHI | Available-FARA-Public-Office | ||
29628 | 29628 | 1975-03-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HIROFUMI KIMBA | Available-FARA-Public-Office | ||
29629 | 29629 | 1975-03-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | NOBORU HATAKEYAMA | Available-FARA-Public-Office | ||
29630 | 29630 | 1975-03-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHINKICHI KIUCHI | Available-FARA-Public-Office | ||
29631 | 29631 | 1975-03-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHOSAKU OKAMOTO | Available-FARA-Public-Office | ||
29969 | 29969 | 2010-03-22 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Hata, Masayuki | https://efile.fara.gov/docs/1850-Short-Form-20100322-38.pdf | ||
30349 | 30349 | 1975-03-24 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TADASHI HIRONO | Available-FARA-Public-Office | ||
30487 | 30487 | 2015-03-24 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Nagao, Masaki | https://efile.fara.gov/docs/1850-Short-Form-20150324-60.pdf | ||
30626 | 30626 | 1994-03-25 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HIROSHI SAWANO | Available-FARA-Public-Office | ||
30627 | 30627 | 1994-03-25 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YASUO AOKI | Available-FARA-Public-Office | ||
30997 | 30997 | 2013-03-26 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Okui, Kohei | https://efile.fara.gov/docs/1850-Short-Form-20130326-54.pdf | ||
30998 | 30998 | 2013-03-26 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Stevenson, Naoko | https://efile.fara.gov/docs/1850-Short-Form-20130326-52.pdf | ||
31130 | 31130 | 1989-03-27 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | HISASHI SEKINE | Available-FARA-Public-Office | ||
31131 | 31131 | 1989-03-27 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | MASATO INUYAMA | Available-FARA-Public-Office | ||
31132 | 31132 | 1989-03-27 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TSUGIO KUSAJIMA | Available-FARA-Public-Office | ||
31292 | 31292 | 2018-03-27 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Hashimoto, Tsubasa | https://efile.fara.gov/docs/1850-Short-Form-20180327-72.pdf | ||
32259 | 32259 | 2012-03-30 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Florida, Tomoko | https://efile.fara.gov/docs/1850-Short-Form-20120330-44.pdf | ||
32260 | 32260 | 2012-03-30 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Fukuda, Tatsuya | https://efile.fara.gov/docs/1850-Short-Form-20120330-46.pdf | ||
32356 | 32356 | 2020-03-30 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Nishizawa, Tomofumi | https://efile.fara.gov/docs/1850-Short-Form-20200330-80.pdf | ||
34763 | 34763 | 1987-04-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KAZUMICHI MACHINO | Available-FARA-Public-Office | ||
37882 | 37882 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Inforzato,Ralph | Available-FARA-Public-Office | ||
37883 | 37883 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Kose,Toshihiro | Available-FARA-Public-Office | ||
37884 | 37884 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Makiura,Hiroyuki | Available-FARA-Public-Office | ||
37885 | 37885 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Matsuo,Kohei | Available-FARA-Public-Office | ||
37886 | 37886 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Moriyama,Mitsuo | Available-FARA-Public-Office | ||
37887 | 37887 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Noda,Shinichiro | Available-FARA-Public-Office | ||
37888 | 37888 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Saito,Masahiko | Available-FARA-Public-Office | ||
37889 | 37889 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Usui,Akio | Available-FARA-Public-Office | ||
37890 | 37890 | 2000-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Yamano,Minoru | Available-FARA-Public-Office | ||
37928 | 37928 | 2007-04-05 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Komiyama, Tomonari | Available-FARA-Public-Office | ||
38100 | 38100 | 1987-04-06 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHINICHI SAITO | Available-FARA-Public-Office | ||
40416 | 40416 | 2008-04-15 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Nakamura, Kyoichi | https://efile.fara.gov/docs/1850-Short-Form-20080415-24.pdf | ||
40417 | 40417 | 2008-04-15 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Shibahara, Tomonori | https://efile.fara.gov/docs/1850-Short-Form-20080415-22.pdf | ||
41652 | 41652 | 1986-04-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHIRO FUJIHARA | Available-FARA-Public-Office | ||
41653 | 41653 | 1986-04-21 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TOSHIO HATA | Available-FARA-Public-Office | ||
41725 | 41725 | 1999-04-21 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Take, Nobumasa | Available-FARA-Public-Office | ||
45553 | 45553 | 1971-05-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | ZENZABURO ISHIKAWA | Available-FARA-Public-Office | ||
54937 | 54937 | 2000-05-26 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Ishihara,Kenichi | Available-FARA-Public-Office | ||
64772 | 64772 | 1997-06-13 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KYUHEI KOMATSU | Available-FARA-Public-Office | ||
81707 | 81707 | 1970-08-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TSUNEO NAKAJIMA | Available-FARA-Public-Office | ||
82033 | 82033 | 1978-08-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SHUJI OGAWA | Available-FARA-Public-Office | ||
90505 | 90505 | 1989-08-29 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | JIRO HORITA | Available-FARA-Public-Office | ||
90506 | 90506 | 1989-08-29 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | KAZUAKI HAMADA | Available-FARA-Public-Office | ||
90507 | 90507 | 1989-08-29 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | YOSHIO YAMANE | Available-FARA-Public-Office | ||
91316 | 91316 | 2004-08-31 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Nakajo,Kazuya | Available-FARA-Public-Office | ||
91317 | 91317 | 2004-08-31 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Sasaki,Teruo | Available-FARA-Public-Office | ||
91318 | 91318 | 2004-08-31 | JETRO, Chicago | JETRO, Chicago 1850 | Short-Form | Yamakuchi,Junichiro | Available-FARA-Public-Office | ||
91705 | 91705 | 1967-09-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | TAKESHI YAMAZAKI | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );