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 96
Registration_Number 1
- JETRO, San Francisco · 96 ✖
Registrant_Name 1
City 1
- San Francisco · 96 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10276 | 10276 | 1966-03-19 | 1964-11-05 | Takeda | Ippei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10405 | 10405 | 2016-03-20 | 2015-10-30 | Yamada | Masayoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10539 | 10539 | 2019-03-22 | 2018-10-23 | Koga | Yasufumi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10613 | 10613 | 1992-03-23 | 1988-11-16 | Iino | Shigefumi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10630 | 10630 | 2003-03-23 | 2002-12-31 | Hashitomi | Mizuho | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10898 | 10898 | 2008-03-27 | 2006-01-03 | Oyaizu | Akihiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10927 | 10927 | 1967-03-28 | 1964-11-05 | Tanabe | Ryuichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10975 | 10975 | 2001-03-28 | 1998-06-17 | Goto | Takashi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10998 | 10998 | 2019-03-28 | 2016-04-28 | Suzuki | Tomoya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
12202 | 12202 | 2017-03-31 | 2012-06-21 | Hamano | Yusuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
12210 | 12210 | 2017-03-31 | 2016-10-28 | Kawaminami | Maki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
13336 | 13336 | 2010-04-14 | 2006-12-20 | Watanabe | Takayuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
13881 | 13881 | 2005-04-21 | 2002-12-31 | Nagaoka | Tani Gelbwachs | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
14043 | 14043 | 1991-04-24 | 1988-02-24 | Ishii | Shigeru | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
14215 | 14215 | 2012-04-27 | 2009-06-09 | Saito | Manabu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
14303 | 14303 | 2011-04-28 | 2006-12-20 | Nakajima | Takeo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
15040 | 15040 | 2011-04-30 | 2009-12-09 | Hasegawa | Naoyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
15468 | 15468 | 2005-05-01 | 2002-12-31 | Kurita | Nobufumi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
15603 | 15603 | 2005-05-02 | 2002-12-31 | Matsuura | Kentaro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
16156 | 16156 | 2020-05-12 | 2018-04-27 | Hirokazu | Shimoda | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
16178 | 16178 | 1966-05-13 | 1964-11-13 | Kawasaki | Sumio | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
17604 | 17604 | 1969-05-31 | 1966-04-28 | Miyata | Kyoshiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
17608 | 17608 | 1970-05-31 | 1966-04-28 | Kuraishi | Fumiaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
17978 | 17978 | 2004-05-31 | 2002-12-31 | Livesey | Samantha | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18221 | 18221 | 2019-05-31 | 2018-10-23 | Kurose | Yuri | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18629 | 18629 | 1979-06-02 | 1977-05-23 | Tomita | Shunsuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18772 | 18772 | 1998-06-03 | 1996-06-06 | Yoshihara | Junji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18913 | 18913 | 1991-06-05 | 1989-11-14 | Ochida | Makoto | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
18976 | 18976 | 1987-06-06 | 1985-02-21 | Tokura | Osamu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19104 | 19104 | 1982-06-09 | 1979-02-01 | Uchida | Yoshio | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19426 | 19426 | 1987-06-14 | 1986-08-19 | Okubo | Tetsuo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19513 | 19513 | 1973-06-15 | 1972-03-21 | Matsuoka | Yooichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19554 | 19554 | 1989-06-15 | 1988-02-24 | Hirano | Tatsuro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19573 | 19573 | 1993-06-15 | 1989-11-14 | Kamigane | Kohei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19773 | 19773 | 2006-06-17 | 2006-01-03 | Muramatsu | Yosuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19777 | 19777 | 2016-06-17 | 2014-04-23 | Morota | Akihiko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19851 | 19851 | 1988-06-19 | 1986-10-02 | Hiroki | Junichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
19877 | 19877 | 2004-06-19 | 2002-12-31 | Nakayama | Toru | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20004 | 20004 | 1978-06-22 | 1975-06-13 | Kiyotaki | Osamu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20038 | 20038 | 1998-06-22 | 1996-06-06 | Tsuchiya | Keizo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20094 | 20094 | 1989-06-23 | 1986-10-02 | Ogino | Shinjuro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20134 | 20134 | 1973-06-24 | 1972-03-21 | Nakano | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20258 | 20258 | 2013-06-25 | 2010-11-09 | Nakazono | Masashi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20286 | 20286 | 1976-06-26 | 1972-12-15 | Matsubara | Haruyo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20397 | 20397 | 2003-06-27 | 2000-12-29 | Osawa | Yuichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
20408 | 20408 | 2016-06-27 | 2016-10-28 | Shimoda | Hirokazu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
21368 | 21368 | 2000-06-30 | 1991-12-03 | Bray | Patrick | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
21419 | 21419 | 2001-06-30 | 1998-12-14 | Fukuda | Hidetaka | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
21490 | 21490 | 2003-06-30 | 2000-12-29 | Tanaka | Shinsuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
21897 | 21897 | 2018-06-30 | 2015-04-24 | Nagamatsu | Yasuhiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22486 | 22486 | 2009-07-02 | 2006-12-20 | Muranaga | Yuji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22561 | 22561 | 1991-07-04 | 1988-11-16 | Komamiya | Fumihiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22653 | 22653 | 2006-07-06 | 2006-01-03 | Haraoka | Naoyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22675 | 22675 | 1971-07-07 | 1968-05-06 | Tsubaki | Hiroyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22712 | 22712 | 1995-07-07 | 1993-06-25 | Miyazawa | Kazuo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22786 | 22786 | 2001-07-08 | 1998-12-14 | Nukui | Kunihiko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22861 | 22861 | 2010-07-09 | 2008-04-07 | Hayami | Yutaka | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22939 | 22939 | 1968-07-11 | 1967-05-02 | Nagaoka | Sadao | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
23980 | 23980 | 2017-07-24 | 2014-10-17 | Tojo | Yoshiaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25156 | 25156 | 2009-07-31 | 2009-06-09 | Schlabach | Kevin | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25181 | 25181 | 2012-07-31 | 2009-06-09 | Owada | Takako | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25231 | 25231 | 2014-07-31 | 2009-06-09 | Nguyen | Anh | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25268 | 25268 | 2015-07-31 | 2012-06-21 | Greene | Jason | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25674 | 25674 | 2014-08-01 | 2011-11-23 | Okada | Toshiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
26080 | 26080 | 1976-08-06 | 1973-08-08 | Miyauchi | Takeshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
26840 | 26840 | 1994-08-16 | 1991-12-03 | Oh | John | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
26843 | 26843 | 2006-08-16 | 2002-12-31 | Doi | Miyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27140 | 27140 | 1995-08-21 | 1992-08-18 | Miyahara | Yutaka | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27502 | 27502 | 2019-08-26 | 2016-04-28 | Tachibana | Hideki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27584 | 27584 | 1988-08-28 | 1986-08-19 | Yoshimoto | Seiji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27598 | 27598 | 2006-08-28 | 2002-12-31 | Boyle | Brandon A. | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
28558 | 28558 | 2010-08-31 | 2009-06-09 | Lackey | Michiru | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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]) );