FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
153 rows where State = "CA" and Zip = 94105
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
899 | 899 | 2021-04-28 | La | Kellie | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
900 | 900 | 2021-04-28 | Nakanishi | Tomoaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
994 | 994 | 2023-05-09 | Hayashi | Yotetsu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1869 | 1869 | 2020-09-29 | Fast | Andrew | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1871 | 1871 | 2020-09-29 | Shiozaki | Misako | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1873 | 1873 | 2020-09-29 | Yamashita | Takanari | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2022 | 2022 | 2018-10-23 | Ferguson | William | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2023 | 2023 | 2018-10-23 | Ishibashi | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2057 | 2057 | 2020-10-29 | Ramsey | Edward | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2066 | 2066 | 2015-10-30 | Hunter | Naoco | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2067 | 2067 | 2015-10-30 | Tanaka | Mihoko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2068 | 2068 | 2017-10-30 | Tomita | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2169 | 2169 | 2022-11-14 | Ishiguro | Seiya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
3772 | 3772 | 1979-01-15 | 1976-07-15 | Matsuo | Yasuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4196 | 4196 | 1966-01-21 | 1964-11-05 | Nakano | Hideo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4919 | 4919 | 1967-01-31 | 1967-05-02 | Nakamura | Kohji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5472 | 5472 | 2013-01-31 | 2008-06-09 | Ebara | Masashi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5705 | 5705 | 1975-02-01 | 1972-03-21 | Sasaki | Jun | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
5864 | 5864 | 2011-02-01 | 2009-07-31 | Stillings | Susan | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
5986 | 5986 | 2005-02-02 | 2004-12-28 | Truong | Autumn Tru | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
6642 | 6642 | 2021-02-11 | 2019-04-25 | Braver | Adam | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
7649 | 7649 | 2005-02-25 | 2004-12-28 | Lande | Rachel | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
7811 | 7811 | 2014-02-27 | 2011-05-12 | Sato | Kenji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8659 | 8659 | 1968-03-01 | 1964-11-05 | Tashiro | Nobuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
8841 | 8841 | 2004-03-01 | 2002-12-31 | Nakamura | Satoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9652 | 9652 | 2002-03-11 | 2021-11-02 | Maehiro | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
9791 | 9791 | 2008-03-13 | 2006-01-03 | Sone | Ichiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10004 | 10004 | 2018-03-15 | 2016-04-28 | Chiba | Taisei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10005 | 10005 | 2018-03-15 | 2017-04-28 | Adams | Michelle | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10009 | 10009 | 2018-03-15 | 2017-10-30 | Higashihara | Keisuke | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10086 | 10086 | 2011-03-16 | 2008-06-09 | Sugimoto | Yasunobu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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 |
11589 | 11589 | 1988-03-31 | 1987-09-29 | Bagley | William T. | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | 100 The Embarcadero | 3rd Floor | San Francisco | CA | 94105 |
11590 | 11590 | 1988-03-31 | 1987-09-29 | Zweben | Murray | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | 100 The Embarcadero | 3rd Floor | 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 |
12523 | 12523 | 2005-04-01 | 2005-03-15 | Chung | Lucy Kyung Eun | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | 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 |
15864 | 15864 | 2018-05-07 | 2012-03-01 | Kyle III | George | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15865 | 15865 | 2018-05-07 | 2011-03-10 | Lubman | Sarah | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15866 | 15866 | 2018-05-07 | 2018-05-07 | Childress | John | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15867 | 15867 | 2018-05-07 | 2018-05-07 | Moran | Robert | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15868 | 15868 | 2018-05-07 | 2018-05-07 | Normandeau | Kaylan | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15869 | 15869 | 2018-05-07 | 2018-05-07 | Ortolani | Antonio | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15870 | 15870 | 2018-05-07 | 2018-05-07 | Pompelia | Emily | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 |
15871 | 15871 | 2018-05-07 | 2018-05-07 | Ruch | Jeremy | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | 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 |
16867 | 16867 | 1973-05-22 | 1957-05-13 | Lee | Chien-san | Central News Agency of China, San Francisco Bureau 1025 | 1957-05-13 | Central News Agency of China, San Francisco Bureau | 681 Market Street | Room 772 | 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 |
18553 | 18553 | 2012-06-01 | 2009-07-31 | Wilkinson | James R. | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | 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 |
19774 | 19774 | 2011-06-17 | 2009-07-31 | Lipin | Steve | Brunswick Group, LLC 5947 | 2009-07-31 | Brunswick Group, LLC | One Market Street | 35th Floor | 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 |
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]) );