FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
124 rows where City = "San Francisco" and Registration_Number = 1813
This data as json, CSV (advanced)
State 1
- CA 24
Registration_Number 1
- JETRO, San Francisco · 24 ✖
Registrant_Name 1
City 1
- San Francisco · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29291 | 29291 | 2017-09-06 | 2016-04-28 | Takeuchi | Daisuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
30167 | 30167 | 2019-09-20 | 2017-04-24 | Wood | Miki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
31807 | 31807 | 1969-10-01 | 1966-04-28 | Eguchi | Hiromichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
32490 | 32490 | 1965-10-09 | 1964-11-05 | Moriyama | Shingo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
32524 | 32524 | 2009-10-09 | 2009-06-09 | Shelton | Douglas | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
32707 | 32707 | 2004-10-12 | 2002-12-31 | Hinojosa | Rene | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
33009 | 33009 | 1984-10-16 | 1981-12-02 | Yamazaki | Kunimitsu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
33336 | 33336 | 1976-10-22 | 1973-08-08 | Yoshitsugu | Koji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
34625 | 34625 | 2011-10-31 | 2009-06-09 | Chung | Jane | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
34639 | 34639 | 2011-10-31 | 2009-12-09 | Nagoya | Mamoru | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35030 | 35030 | 2014-11-01 | 2011-05-12 | Kimura | Yoichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35093 | 35093 | 1983-11-02 | 1981-01-02 | Ota | Yasutomi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35568 | 35568 | 2018-11-09 | 2018-10-23 | Wang | Yenting | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35638 | 35638 | 2021-11-11 | 2017-10-30 | Tarutani | Noriya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
35797 | 35797 | 1972-11-15 | 1972-03-21 | Tsuchiya | Naotoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36013 | 36013 | 2019-11-17 | 2017-10-30 | Nakazawa | Norio | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36026 | 36026 | 1994-11-18 | 1991-12-03 | Fushimi | Toshiyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36027 | 36027 | 1994-11-18 | 1991-12-03 | Noguchi | Nobuya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36028 | 36028 | 1994-11-18 | 1991-12-03 | Sakai | Takuji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36328 | 36328 | 2013-11-24 | 2008-11-12 | Hamidi | Saori | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
36494 | 36494 | 2014-11-27 | 2012-04-20 | Ogawa | Hiroko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
38451 | 38451 | 2017-12-15 | 2002-12-31 | Stephens | Matthew D. | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
38969 | 38969 | 2014-12-22 | 2013-04-30 | Takahashi | Yukina | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
41863 | 41863 | 2013-12-31 | 2010-05-06 | Lampe | Sean | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );