FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
49 rows where Document_Type = "Short-Form" and Registrant_Name = "JETRO, SAN FRANCISCO"
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Name
Registrant_Name 1
- JETRO, SAN FRANCISCO · 49 ✖
Foreign_Principal_Country 1
- - 49
Document_Type 1
- Short-Form · 49 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
604 | 604 | 1981-01-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YASUTOMI OTA | Available-FARA-Public-Office | ||
10940 | 10940 | 1979-02-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YOSHIO UCHIDA | Available-FARA-Public-Office | ||
11387 | 11387 | 1985-02-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | OSAMU TOKURA | Available-FARA-Public-Office | ||
18384 | 18384 | 1988-02-24 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SHIGERU ISHII | Available-FARA-Public-Office | ||
18385 | 18385 | 1988-02-24 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TATSURO HIRANO | Available-FARA-Public-Office | ||
20683 | 20683 | 1972-03-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | JUN SASAKI | Available-FARA-Public-Office | ||
29623 | 29623 | 1972-03-21 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HIROSHI NAKANO | Available-FARA-Public-Office | ||
29624 | 29624 | 1972-03-21 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | NAOTOSHI TSUCHIYA | Available-FARA-Public-Office | ||
29625 | 29625 | 1972-03-21 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YOOICHI MATSUOKA | Available-FARA-Public-Office | ||
43504 | 43504 | 1966-04-28 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | FUMIAKI KURAISHI | Available-FARA-Public-Office | ||
43505 | 43505 | 1966-04-28 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HIROMICHI EGUCHI | Available-FARA-Public-Office | ||
43506 | 43506 | 1966-04-28 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KYOSHIRO MIYATA | Available-FARA-Public-Office | ||
45502 | 45502 | 1968-05-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HIROYUKI TSUBAKI | Available-FARA-Public-Office | ||
45735 | 45735 | 1977-05-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SHUNSUKE TOMITA | Available-FARA-Public-Office | ||
48662 | 48662 | 1967-05-02 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KOHJI NAKAMURA | Available-FARA-Public-Office | ||
48663 | 48663 | 1967-05-02 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SADAO NAGAOKA | Available-FARA-Public-Office | ||
58014 | 58014 | 1975-06-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | OSAMU KIYOTAKI | Available-FARA-Public-Office | ||
61450 | 61450 | 1993-06-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KAZUO MIYAZAWA | Available-FARA-Public-Office | ||
63046 | 63046 | 1996-06-06 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | JUNJI YOSHIHARA | Available-FARA-Public-Office | ||
63047 | 63047 | 1996-06-06 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KEIZO TSUCHIYA | Available-FARA-Public-Office | ||
65642 | 65642 | 1998-06-17 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TAKASHI GOTO | Available-FARA-Public-Office | ||
70790 | 70790 | 1976-07-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YASUYUKI MATSUO | Available-FARA-Public-Office | ||
81809 | 81809 | 1973-08-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TAKESHI MIYAUCHI | Available-FARA-Public-Office | ||
83794 | 83794 | 1992-08-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YUTAKA MIYAHARA | Available-FARA-Public-Office | ||
86214 | 86214 | 1973-08-08 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KOJI YOSHITSUGU | Available-FARA-Public-Office | ||
88424 | 88424 | 1986-08-19 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SEIJI YOSHIMOTO | Available-FARA-Public-Office | ||
88425 | 88425 | 1986-08-19 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TETSUO OKUBO | Available-FARA-Public-Office | ||
106126 | 106126 | 1986-10-02 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | JUNICHI HIROKI | Available-FARA-Public-Office | ||
106127 | 106127 | 1986-10-02 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SHINJURO OGINO | Available-FARA-Public-Office | ||
113932 | 113932 | 1964-11-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SHINGO MORIYAMA | Available-FARA-Public-Office | ||
117568 | 117568 | 1964-11-05 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HIDEO NAKANO | Available-FARA-Public-Office | ||
117569 | 117569 | 1964-11-05 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | IPPEI TAKEDA | Available-FARA-Public-Office | ||
117570 | 117570 | 1964-11-05 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | NOBUYUKI TASHIRO | Available-FARA-Public-Office | ||
117571 | 117571 | 1964-11-05 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | RYUICHI TANABE | Available-FARA-Public-Office | ||
119115 | 119115 | 1964-11-13 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SUMIO KAWASAKI | Available-FARA-Public-Office | ||
119363 | 119363 | 1989-11-14 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KOHEI KAMIGANE | Available-FARA-Public-Office | ||
119364 | 119364 | 1989-11-14 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | MAKOTO OCHIDA | Available-FARA-Public-Office | ||
119813 | 119813 | 1988-11-16 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | FUMIHIRO KOMAMIYA | Available-FARA-Public-Office | ||
119814 | 119814 | 1988-11-16 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | SHIGEFUMI IINO | Available-FARA-Public-Office | ||
124272 | 124272 | 1972-12-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HARUYO MATSUBARA | Available-FARA-Public-Office | ||
125019 | 125019 | 1981-12-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KUNIMITSU YAMAZAKI | Available-FARA-Public-Office | ||
128704 | 128704 | 1991-12-03 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | JOHN OH | Available-FARA-Public-Office | ||
128705 | 128705 | 1991-12-03 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | NOBUYA NOGUCHI | Available-FARA-Public-Office | ||
128706 | 128706 | 1991-12-03 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | PATRICK BRAY | Available-FARA-Public-Office | ||
128707 | 128707 | 1991-12-03 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TAKUJI SAKAI | Available-FARA-Public-Office | ||
128708 | 128708 | 1991-12-03 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | TOSHIYUKI FUSHIMI | Available-FARA-Public-Office | ||
130855 | 130855 | 1998-12-14 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | HIDETAKA FUKUDA | Available-FARA-Public-Office | ||
130856 | 130856 | 1998-12-14 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | KUNIHIKO NUKUI | Available-FARA-Public-Office | ||
130857 | 130857 | 1998-12-14 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | PATRICK BRAY | 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]) );