FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
184 rows where Registration_Number = 1833 sorted by Short_Form_Date
This data as json, CSV (advanced)
Short_Form_Termination_Date (date) >30 ✖
- 2003-03-31 2
- 2022-08-12 2
- 1995-06-01 1
- 1995-06-21 1
- 1995-07-12 1
- 1995-10-19 1
- 1996-03-10 1
- 1996-03-21 1
- 1996-12-23 1
- 1997-03-21 1
- 1997-07-13 1
- 1997-08-23 1
- 1997-09-27 1
- 1997-10-11 1
- 1998-03-22 1
- 1998-06-13 1
- 1998-06-14 1
- 1998-06-26 1
- 1998-09-29 1
- 1998-11-04 1
- 1999-03-17 1
- 2000-04-14 1
- 2000-06-25 1
- 2001-03-12 1
- 2001-03-28 1
- 2001-06-02 1
- 2001-06-25 1
- 2001-06-26 1
- 2002-02-26 1
- 2002-03-11 1
- …
State 1
- CA 84
Registration_Number 1
- JETRO, Los Angeles · 84 ✖
Registrant_Name 1
City 1
- Los Angeles 84
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19979 | 19979 | 1995-06-21 | 1992-07-27 | Watanabe | Takeo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10467 | 10467 | 1997-03-21 | 1993-07-19 | Nishizawa | Kiyoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23014 | 23014 | 1995-07-12 | 1993-07-19 | Yumoto | Noboru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33213 | 33213 | 1995-10-19 | 1993-07-19 | Ishiwata | Kenjiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9576 | 9576 | 1996-03-10 | 1993-08-09 | Moriya | Masanobu | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
18505 | 18505 | 1995-06-01 | 1994-01-18 | Yokoiyama | Noboru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
39021 | 39021 | 1996-12-23 | 1994-01-18 | Yamaguchi | Kentaro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30612 | 30612 | 1997-09-27 | 1994-07-19 | Miura | Hideto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
35232 | 35232 | 1998-11-04 | 1994-07-19 | Sone | Ichiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10466 | 10466 | 1996-03-21 | 1995-01-17 | Kanno | Takahiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
27270 | 27270 | 1997-08-23 | 1995-01-17 | Oki | Hiromi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
32632 | 32632 | 1997-10-11 | 1995-05-04 | Kitamura | Naohiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10524 | 10524 | 1998-03-22 | 1995-07-24 | Mitsui | Makoto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19355 | 19355 | 1998-06-13 | 1995-07-24 | Tonosaki | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19447 | 19447 | 1998-06-14 | 1995-07-24 | Murayama | Masazumi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20316 | 20316 | 1998-06-26 | 1995-07-24 | Miyazawa | Toshinari | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23067 | 23067 | 1997-07-13 | 1996-01-17 | Hasegawa | Ken | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30755 | 30755 | 1998-09-29 | 1996-01-17 | Ishikawa | Ichiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10163 | 10163 | 1999-03-17 | 1996-07-17 | Masui | Hiroshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
13331 | 13331 | 2000-04-14 | 1997-01-30 | Hirano | Masao | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
11885 | 11885 | 2002-03-31 | 1997-07-22 | Inoue | Satoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9738 | 9738 | 2001-03-12 | 1998-02-06 | Moromi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20248 | 20248 | 2000-06-25 | 1998-02-06 | Iwasaki | Toshihide | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
9651 | 9651 | 2002-03-11 | 1998-06-15 | Taki | Osamu | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10974 | 10974 | 2001-03-28 | 1998-06-15 | Yamaoka | Nobukuni | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
18675 | 18675 | 2001-06-02 | 1998-07-24 | Fukushima | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20320 | 20320 | 2001-06-26 | 1998-07-24 | Yamagishi | Akira | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20249 | 20249 | 2001-06-25 | 1998-07-27 | Takahashi | Hiroki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
34982 | 34982 | 2003-11-01 | 1999-01-21 | Kobayashi | Tosaku | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
7728 | 7728 | 2002-02-26 | 1999-07-26 | Wakaume | Masaki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
11909 | 11909 | 2003-03-31 | 2000-07-21 | Oki | Kenichi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
10893 | 10893 | 2004-03-27 | 2001-08-07 | Kato | Hiroshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
3820 | 3820 | 2005-01-15 | 2001-09-18 | Takashi | Muneo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
16675 | 16675 | 2006-05-18 | 2001-09-18 | Nishiura | Masaru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19876 | 19876 | 2004-06-19 | 2001-09-18 | Yokota | Makoto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20046 | 20046 | 2004-06-22 | 2001-09-18 | Tamura | Yoshihiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
11910 | 11910 | 2003-03-31 | 2002-07-29 | Matsushita | Ikuzo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38749 | 38749 | 2003-12-19 | 2002-07-29 | Komatsuzaki | Satoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
12802 | 12802 | 2008-04-05 | 2004-02-06 | Tsuchiya | Keizo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20118 | 20118 | 2007-06-23 | 2004-07-30 | Mashita | Toshiharu | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20581 | 20581 | 2007-06-29 | 2004-07-30 | Fukushima | Hiroshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30322 | 30322 | 2007-09-23 | 2004-07-30 | Hara | Minoru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30765 | 30765 | 2008-09-29 | 2005-08-16 | Watanabe | Masayoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
22609 | 22609 | 2010-07-05 | 2006-08-15 | Asai | Yasutaka | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20256 | 20256 | 2010-06-25 | 2007-08-13 | Mizutani | Tsuyoshi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
12071 | 12071 | 2010-03-31 | 2008-07-03 | Takahashi | Mitsuo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23075 | 23075 | 2010-07-13 | 2008-07-03 | Funaki | Kentaro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
11090 | 11090 | 2011-03-29 | 2008-09-05 | Kimura | Shigeru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
14214 | 14214 | 2012-04-27 | 2009-02-25 | Kobayashi | Hiroto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20056 | 20056 | 2013-06-22 | 2011-02-17 | Nakagawa | Kentaro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20475 | 20475 | 2013-06-28 | 2011-02-17 | Miyazaki | Takaya | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
23028 | 23028 | 2014-07-12 | 2011-02-17 | Hirota | Shin | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
27231 | 27231 | 2014-08-22 | 2011-08-15 | Takahashi | Yoshitoku | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
27724 | 27724 | 2016-08-29 | 2012-07-30 | Hamajima | Sachiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
22490 | 22490 | 2016-07-02 | 2013-08-27 | Kawabuchi | Hideo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20407 | 20407 | 2016-06-27 | 2014-02-28 | Kuwada | Yuzuru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
19779 | 19779 | 2017-06-17 | 2015-02-05 | Okumoto | Kazuo | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
32096 | 32096 | 2017-10-01 | 2015-02-05 | Yasuda | Ayako | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
22553 | 22553 | 2019-07-03 | 2016-07-28 | Kanazashi | Hisashi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
21944 | 21944 | 2020-06-30 | 2017-02-10 | Hojo | Takashi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33275 | 33275 | 2019-10-20 | 2017-02-10 | Nishimoto | Keiichi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
26520 | 26520 | 2022-08-12 | 2017-07-28 | Asai | Yasutaka | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
188 | 188 | 2018-01-25 | Baker | Christopher | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
189 | 189 | 2018-01-25 | Torres | Kumiko Tanaka | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
190 | 190 | 2018-01-25 | Vermeiren | Sachie | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
25822 | 25822 | 2019-08-02 | 2018-01-25 | Murata | Soma | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
27727 | 27727 | 2019-08-29 | 2018-01-25 | Yoneyama | Lena | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
30707 | 30707 | 2018-09-28 | 2018-01-25 | Griffith | Kaori Ozawa | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33221 | 33221 | 2020-10-19 | 2018-01-25 | Kuriyama | Ai | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31674 | 31674 | 2019-09-30 | 2018-07-27 | Yamaguchi | Makoto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
26131 | 26131 | 2019-08-06 | 2019-01-29 | Aisen | Mayuka | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
31699 | 31699 | 2020-09-30 | 2019-07-30 | Pike | Chika Yamaga | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
26518 | 26518 | 2022-08-12 | 2020-01-31 | Saeki | Norihiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
222 | 222 | 2021-01-29 | Nakano | Chiaki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
1546 | 1546 | 2021-07-30 | Nagata | Hikara | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
31730 | 31730 | 2022-09-30 | 2021-07-30 | Maurata | Keiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
33443 | 33443 | 2021-10-22 | 2021-07-30 | Servin | Alberto | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
216 | 216 | 2022-01-28 | John | Maai | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
217 | 217 | 2022-01-28 | Shibahara | Tomonori | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
28710 | 28710 | 2022-08-31 | 2022-01-28 | Mochizuki | Jasmine | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
325 | 325 | 2023-02-06 | Hirano | Junko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
326 | 326 | 2023-02-06 | Kimura | Kota | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
328 | 328 | 2023-02-06 | Tsuwaki | Yoshiko | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 | |
329 | 329 | 2023-02-06 | Wanami | Takuro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
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]) );