home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_RegistrantDocs

Table actions
  • GraphQL API for FARA_All_RegistrantDocs
List of URLs to all registrant docs (available in PDF format)

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

98 rows where Registrant_Name = "JETRO, Houston" and Registration_Number = 2277

✎ View and edit SQL

This data as json, CSV (advanced)

Document_Type 3

  • Supplemental Statement 48
  • Short-Form 47
  • Informational Materials 3

Foreign_Principal_Name 2

  • - 95
  • Japan External Trade Organization (JETRO) 3

Foreign_Principal_Country 2

  • - 95
  • JAPAN 3

Registrant_Name 1

  • JETRO, Houston · 98 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
6730 6730 2002-01-22 JETRO, Houston JETRO, Houston 2277 Short-Form Onishi,Hideo     Available-FARA-Public-Office
8876 8876 2002-01-30 JETRO, Houston JETRO, Houston 2277 Short-Form Toyomoto,Shinichi     Available-FARA-Public-Office
16236 16236 2001-02-14 JETRO, Houston JETRO, Houston 2277 Short-Form Iwano,Hiroshi     Available-FARA-Public-Office
27585 27585 2018-03-13 JETRO, Houston JETRO, Houston 2277 Short-Form Hirai, Toshinaga     https://efile.fara.gov/docs/2277-Short-Form-20180313-38.pdf
29447 29447 2000-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20000320-GCEVWV02.pdf
29450 29450 2001-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20010320-GNFAK301.pdf
29451 29451 2002-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20020320-GV4UA201.pdf
29455 29455 2003-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20030320-HDPB7G03.pdf
29457 29457 2004-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20040320-HWFLR704.pdf
29458 29458 2005-03-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20050320-IFKKAM04.pdf
39759 39759 2019-04-12 JETRO, Houston JETRO, Houston 2277 Short-Form Koyama, Isao     https://efile.fara.gov/docs/2277-Short-Form-20190412-42.pdf
39760 39760 2019-04-12 JETRO, Houston JETRO, Houston 2277 Short-Form McKisick, Sheridan     https://efile.fara.gov/docs/2277-Short-Form-20190412-40.pdf
39761 39761 2019-04-12 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20190412-28.pdf
41259 41259 2023-04-18 JETRO, Houston JETRO, Houston 2277 Short-Form Mayu, Hobo     https://efile.fara.gov/docs/2277-Short-Form-20230418-66.pdf
41428 41428 2021-04-19 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20210419-32.pdf
42045 42045 2015-04-22 JETRO, Houston JETRO, Houston 2277 Short-Form Kurokawa, Junji     https://efile.fara.gov/docs/2277-Short-Form-20150422-30.pdf
42046 42046 2015-04-22 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20150422-20.pdf
42098 42098 2020-04-22 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20200422-1.pdf
42099 42099 2020-04-22 JETRO, Houston JETRO, Houston 2277 Short-Form Sakurauchi, Masahiro     https://efile.fara.gov/docs/2277-Short-Form-20200422-50.pdf
42100 42100 2020-04-22 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20200422-30.pdf
42246 42246 2013-04-23 JETRO, Houston JETRO, Houston 2277 Short-Form Sanders, Keith     https://efile.fara.gov/docs/2277-Short-Form-20130423-16.pdf
42247 42247 2013-04-23 JETRO, Houston JETRO, Houston 2277 Short-Form Shimada, Aki     https://efile.fara.gov/docs/2277-Short-Form-20130423-18.pdf
42248 42248 2013-04-23 JETRO, Houston JETRO, Houston 2277 Short-Form Wong, Yuko     https://efile.fara.gov/docs/2277-Short-Form-20130423-22.pdf
42249 42249 2013-04-23 JETRO, Houston JETRO, Houston 2277 Short-Form Zhao, Yiou     https://efile.fara.gov/docs/2277-Short-Form-20130423-20.pdf
42250 42250 2013-04-23 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20130423-16.pdf
42478 42478 2018-04-24 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20180424-26.pdf
42543 42543 2023-04-24 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20230424-37.pdf
42745 42745 2014-04-25 JETRO, Houston JETRO, Houston 2277 Short-Form Maeda, Shinobu     https://efile.fara.gov/docs/2277-Short-Form-20140425-28.pdf
42746 42746 2014-04-25 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20140425-18.pdf
43029 43029 2017-04-26 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20170426-24.pdf
43653 43653 2011-04-28 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20110428-12.pdf
44042 44042 2016-04-29 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20160429-22.pdf
44890 44890 2012-04-30 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20120430-14.pdf
48510 48510 2008-05-01 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20080501-6.pdf
48761 48761 2007-05-02 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20070502-4.pdf
49038 49038 2006-05-03 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20060503-2.pdf
49282 49282 2010-05-04 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20100504-10.pdf
49532 49532 2009-05-05 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20090505-8.pdf
50493 50493 2006-05-09 JETRO, Houston JETRO, Houston 2277 Short-Form Kurita, Kaoru     Available-FARA-Public-Office
54695 54695 2000-05-25 JETRO, Houston JETRO, Houston 2277 Short-Form Nei ,Hisanori     Available-FARA-Public-Office
62599 62599 2002-06-04 JETRO, Houston JETRO, Houston 2277 Short-Form Ozawa,Jingo     Available-FARA-Public-Office
74170 74170 2006-07-06 JETRO, Houston JETRO, Houston 2277 Short-Form Okabe, Tadahisa     Available-FARA-Public-Office
76668 76668 2003-07-17 JETRO, Houston JETRO, Houston 2277 Short-Form Yajima,Yoshinori     Available-FARA-Public-Office
78374 78374 2009-07-24 JETRO, Houston JETRO, Houston 2277 Short-Form Koyari, Takashi     https://efile.fara.gov/docs/2277-Short-Form-20090724-14.pdf
80307 80307 2008-07-30 JETRO, Houston JETRO, Houston 2277 Short-Form Hirai, Mika     https://efile.fara.gov/docs/2277-Short-Form-20080730-10.pdf
84476 84476 2003-08-01 JETRO, Houston JETRO, Houston 2277 Short-Form Nakamizo,Takashi     Available-FARA-Public-Office
84799 84799 2005-08-02 JETRO, Houston JETRO, Houston 2277 Short-Form Kimura, Masayuki     Available-FARA-Public-Office
85070 85070 1999-08-03 JETRO, Houston JETRO, Houston 2277 Short-Form Kanazawa,Takashi     Available-FARA-Public-Office
85657 85657 2013-08-05 JETRO, Houston JETRO, Houston 2277 Short-Form Nakamizo, Takashi     https://efile.fara.gov/docs/2277-Short-Form-20130805-26.pdf
86556 86556 2004-08-09 JETRO, Houston JETRO, Houston 2277 Short-Form Yajima,Yoshinori     Available-FARA-Public-Office
87429 87429 2001-08-13 JETRO, Houston JETRO, Houston 2277 Short-Form Kobara,Makoto     Available-FARA-Public-Office
88197 88197 2020-08-17 JETRO, Houston JETRO, Houston 2277 Short-Form Okimoto, Kenji     https://efile.fara.gov/docs/2277-Short-Form-20200817-52.pdf
96765 96765 2004-09-10 JETRO, Houston JETRO, Houston 2277 Short-Form Hasegawa,Hitoshi     Available-FARA-Public-Office
99115 99115 1999-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-19990920-GE61XG01.pdf
99117 99117 2000-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20000920-GIHBQF01.pdf
99122 99122 2001-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20010920-GT6HJH01.pdf
99126 99126 2002-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20020920-H59JE304.pdf
99128 99128 2003-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20030920-HPMUYO03.pdf
99136 99136 2004-09-20 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20040920-I6AT3E04.pdf
99363 99363 1999-09-21 JETRO, Houston JETRO, Houston 2277 Short-Form Maekawa,Naoyuki     Available-FARA-Public-Office
100038 100038 2002-09-24 JETRO, Houston JETRO, Houston 2277 Short-Form Chiba,Toshinori     Available-FARA-Public-Office
106064 106064 2019-10-01 JETRO, Houston JETRO, Houston 2277 Short-Form Shioiri, Emi     https://efile.fara.gov/docs/2277-Short-Form-20191001-44.pdf
106065 106065 2019-10-01 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20191001-29.pdf
108253 108253 1993-10-12 JETRO, Houston JETRO, Houston 2277 Short-Form Sakamoto, Hirokazu     Available-FARA-Public-Office
108522 108522 1999-10-13 JETRO, Houston JETRO, Houston 2277 Short-Form Nakamura,Yukio     Available-FARA-Public-Office
108638 108638 2022-10-13 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20221013-35.pdf
109196 109196 2019-10-16 JETRO, Houston JETRO, Houston 2277 Short-Form Sakurauchi, Masahiro     https://efile.fara.gov/docs/2277-Short-Form-20191016-46.pdf
109898 109898 2020-10-19 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20201019-2.pdf
109899 109899 2020-10-19 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20201019-31.pdf
109934 109934 2022-10-19 JETRO, Houston JETRO, Houston 2277 Short-Form Hirasawa, Yuka     https://efile.fara.gov/docs/2277-Short-Form-20221019-64.pdf
109935 109935 2022-10-19 JETRO, Houston JETRO, Houston 2277 Short-Form killian, Chika     https://efile.fara.gov/docs/2277-Short-Form-20221019-62.pdf
109936 109936 2022-10-19 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20221019-36.pdf
110253 110253 2016-10-21 JETRO, Houston JETRO, Houston 2277 Short-Form Oikawa, Kiyohito     https://efile.fara.gov/docs/2277-Short-Form-20161021-32.pdf
110254 110254 2016-10-21 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20161021-23.pdf
110690 110690 2014-10-23 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20141023-19.pdf
110693 110693 2015-10-23 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20151023-21.pdf
110938 110938 2018-10-24 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20181024-27.pdf
111221 111221 2021-10-25 JETRO, Houston JETRO, Houston 2277 Informational Materials   Japan External Trade Organization (JETRO) JAPAN https://efile.fara.gov/docs/2277-Informational-Materials-20211025-3.pdf
111222 111222 2021-10-25 JETRO, Houston JETRO, Houston 2277 Short-Form Fukasawa, Ryuta     https://efile.fara.gov/docs/2277-Short-Form-20211025-54.pdf
111223 111223 2021-10-25 JETRO, Houston JETRO, Houston 2277 Short-Form Holdstock, Erika     https://efile.fara.gov/docs/2277-Short-Form-20211025-56.pdf
111224 111224 2021-10-25 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20211026-33.pdf
111825 111825 2011-10-28 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20111028-13.pdf
112165 112165 2012-10-29 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20121029-15.pdf
112170 112170 2013-10-29 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20131029-17.pdf
112704 112704 2017-10-30 JETRO, Houston JETRO, Houston 2277 Short-Form Nakagawa, Naoto     https://efile.fara.gov/docs/2277-Short-Form-20171030-34.pdf
112705 112705 2017-10-30 JETRO, Houston JETRO, Houston 2277 Short-Form Uchida, Kaori     https://efile.fara.gov/docs/2277-Short-Form-20171030-36.pdf
112706 112706 2017-10-30 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20171030-25.pdf
116707 116707 2006-11-01 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20061101-3.pdf
116951 116951 2005-11-02 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20051102-1.pdf
117005 117005 2007-11-02 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20071102-5.pdf
117016 117016 2010-11-02 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20101102-11.pdf
117195 117195 1999-11-03 JETRO, Houston JETRO, Houston 2277 Short-Form Hosokawa,Hiroyuki     Available-FARA-Public-Office
117196 117196 1999-11-03 JETRO, Houston JETRO, Houston 2277 Short-Form Hosokawa,Hiroyuki     Available-FARA-Public-Office
117241 117241 2008-11-03 JETRO, Houston JETRO, Houston 2277 Short-Form Kimura, Makoto     https://efile.fara.gov/docs/2277-Short-Form-20081103-12.pdf
117455 117455 2008-11-04 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20081104-7.pdf
117650 117650 2002-11-05 JETRO, Houston JETRO, Houston 2277 Short-Form Iwano,Hiroshi     Available-FARA-Public-Office
118405 118405 2009-11-09 JETRO, Houston JETRO, Houston 2277 Supplemental Statement       https://efile.fara.gov/docs/2277-Supplemental-Statement-20091109-9.pdf
130147 130147 2002-12-10 JETRO, Houston JETRO, Houston 2277 Short-Form Tokita,Setsuko     Available-FARA-Public-Office

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 613.529ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history