FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
490 rows where Registration_Number = 1643 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- NY 490
Registration_Number 1
- JETRO, New York · 490 ✖
Registrant_Name 1
- JETRO, New York 490
City 1
- New York 490
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40080 | 40080 | 1978-12-31 | 1973-10-12 | Uehara | Yosuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39288 | 39288 | 2000-12-29 | 1997-09-25 | Hasegawa | Hidekazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39107 | 39107 | 1990-12-25 | 1987-12-24 | Kojima | Katsuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39100 | 39100 | 1965-12-25 | 1963-06-25 | Tokuyama | Jiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39099 | 39099 | 1965-12-25 | 1963-06-25 | Koyama | Iwao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39033 | 39033 | 2010-12-23 | 2008-03-20 | Matsumoto | Takako | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38978 | 38978 | 1968-12-23 | 1965-07-30 | Suzuki | Akio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38955 | 38955 | 2001-12-22 | 1999-04-27 | Maeda | Shigeki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38411 | 38411 | 2003-12-15 | 2001-03-16 | Arata | Ryohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38255 | 38255 | 2019-12-13 | 2015-07-09 | Sugiyama | Reiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37724 | 37724 | 1981-12-04 | 1978-10-11 | Kaizo | Hashimoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37643 | 37643 | 2013-12-02 | 2011-04-07 | Hoshino | Kaori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37640 | 37640 | 2005-12-02 | 2002-12-23 | Kato | Ikuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
37480 | 37480 | 2004-12-01 | 2002-03-04 | Masuda | Toyokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36614 | 36614 | 1970-11-30 | 1967-01-02 | Yukawa | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36602 | 36602 | 1966-11-30 | 1963-06-25 | Sogo | Shinsaku | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36561 | 36561 | 1999-11-29 | 1997-02-18 | Kuromatsu | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36531 | 36531 | 1969-11-29 | 1966-07-27 | Ino | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36523 | 36523 | 2022-11-28 | 2019-12-26 | Tani | Hayato | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36501 | 36501 | 1967-11-28 | 1965-03-01 | Oda | Sueaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36465 | 36465 | 1967-11-27 | 1965-03-01 | Kurusu | Yoshiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36403 | 36403 | 2013-11-25 | 2007-10-15 | Austin | Doreen | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36391 | 36391 | 1999-11-25 | 1999-04-28 | Takei | Shinji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36294 | 36294 | 1976-11-24 | 1974-08-27 | Kashiwagi | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36280 | 36280 | 2008-11-23 | 2006-01-30 | Iino | Kazumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36237 | 36237 | 2020-11-22 | 2016-07-19 | Sugimoto | Keiji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36231 | 36231 | 2000-11-22 | 1999-04-27 | Matsumoto | Tetsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36206 | 36206 | 1977-11-22 | 1975-03-31 | Tanigawa | Kiyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36121 | 36121 | 1995-11-20 | 1993-02-03 | Nakamura | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36070 | 36070 | 2010-11-19 | 2009-07-29 | Seal | Jacob Scott | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36032 | 36032 | 2008-11-18 | 2006-01-30 | Inoue | Noriyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35993 | 35993 | 1990-11-17 | 1987-02-03 | Takatsu | Kazuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35985 | 35985 | 1983-11-17 | 1980-12-09 | Hirato | Hisao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35952 | 35952 | 2000-11-16 | 1996-08-02 | Hashimoto | Koji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35888 | 35888 | 1996-11-15 | 1993-08-09 | Hayashi | Michiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35732 | 35732 | 2013-11-13 | 2011-01-20 | Belanich | Susan | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35723 | 35723 | 2003-11-13 | 2001-02-02 | Imai | Tomomitsu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35474 | 35474 | 1984-11-09 | 1981-09-29 | Washio | Tomoharu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35313 | 35313 | 2021-11-05 | 2017-01-31 | Shartzer | Andrew | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35285 | 35285 | 1981-11-05 | 1978-10-11 | Yutaka | Nakata | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35120 | 35120 | 2005-11-02 | 2004-08-11 | Shimada | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35036 | 35036 | 2016-11-01 | 2013-08-27 | Applebury | Timothy A | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
34398 | 34398 | 1997-10-31 | 1996-08-02 | Nozu | Tadao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
34103 | 34103 | 2015-10-30 | 2013-06-06 | Fujii | Rumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33981 | 33981 | 2002-10-29 | 2001-02-02 | Hirano | Nagatoki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33688 | 33688 | 2022-10-26 | 2019-11-19 | Ara | Takahiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33684 | 33684 | 2012-10-26 | 2009-09-25 | Mori | Kotaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33643 | 33643 | 2005-10-25 | 2002-12-11 | Suzuki | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33444 | 33444 | 2021-10-22 | 2019-12-23 | Watanabe | Takayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33415 | 33415 | 1988-10-22 | 1985-01-07 | Wakabayashi | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33145 | 33145 | 2000-10-18 | 1997-09-25 | Yoshimi | Hideo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33112 | 33112 | 1975-10-18 | 1972-03-06 | Yamato | Yasuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32710 | 32710 | 2007-10-12 | 2006-08-11 | Keller | Simon B. | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32641 | 32641 | 2016-10-11 | 2013-12-05 | Maenaka | Koji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32639 | 32639 | 2016-10-11 | 2016-10-04 | Cabral | Ramon R. | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32594 | 32594 | 2004-10-10 | 2000-12-29 | Kato | Makoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32523 | 32523 | 2004-10-09 | 2002-03-04 | Tomisawa | Takeshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32461 | 32461 | 1991-10-08 | 1989-02-07 | Hozaki | Yasuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32382 | 32382 | 2003-10-06 | 2000-10-12 | Sakai | Yuichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32295 | 32295 | 2019-10-04 | 2016-09-27 | Fukushima | Yoshitaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32287 | 32287 | 2019-10-04 | 2016-01-07 | Cook | Gerald | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32230 | 32230 | 2020-10-03 | 2016-03-03 | Wakamatsu | Isamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32213 | 32213 | 2000-10-03 | 1997-09-25 | Maeda | Masayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
32175 | 32175 | 2007-10-02 | 2004-04-20 | Nakayama | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31525 | 31525 | 2011-09-30 | 2006-08-25 | Kajita | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31426 | 31426 | 2009-09-30 | 2008-02-15 | Ihara | Mizuho | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31326 | 31326 | 2004-09-30 | 2000-09-18 | Nakajima | Takeo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31323 | 31323 | 2004-09-30 | 2001-07-10 | Yokozeki | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30770 | 30770 | 2016-09-29 | 2013-04-11 | Goto | Katsuyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30769 | 30769 | 2014-09-29 | 2011-08-18 | Kishimoto | Kentaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30762 | 30762 | 2004-09-29 | 2001-08-27 | Okumura | Jun | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30761 | 30761 | 2004-09-29 | 2002-08-23 | Ishihara | Kenichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30700 | 30700 | 2007-09-28 | 2006-04-05 | Yamaguchi | Kazuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30696 | 30696 | 2005-09-28 | 2004-04-20 | Aoki | Hiroe | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30695 | 30695 | 2005-09-28 | 2004-02-24 | Yumoto | Hidemitsu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30645 | 30645 | 1971-09-28 | 1968-01-29 | Cho | Kyohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30622 | 30622 | 2003-09-27 | 2002-06-17 | Kudo | Naoki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30621 | 30621 | 2003-09-27 | 2000-02-09 | Nishioka | Kazuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30549 | 30549 | 2014-09-26 | 2010-02-05 | Mizuno | Ryo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30478 | 30478 | 1967-09-26 | 1964-06-09 | Maruo | Takeshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30460 | 30460 | 2018-09-25 | 2017-04-04 | Fuchigami | Shigenobu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30458 | 30458 | 2014-09-25 | 2013-04-11 | Yamada | Shona | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30353 | 30353 | 1975-09-24 | 1972-07-20 | Kawabata | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30348 | 30348 | 1971-09-24 | 1969-09-11 | Otsuka | Shigeru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30311 | 30311 | 1991-09-23 | 1989-02-07 | Usumoto | Tomiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30302 | 30302 | 1976-09-23 | 1973-10-12 | Tsuruoka | Yoshiaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30087 | 30087 | 1998-09-19 | 1995-07-28 | Hirai | Toshinaga | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29984 | 29984 | 1989-09-17 | 1987-02-03 | Uetani | Toshihiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29955 | 29955 | 1995-09-16 | 1993-02-03 | Kajishima | Tatsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29829 | 29829 | 1987-09-15 | 1985-01-07 | Tsuchiya | Tadashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29780 | 29780 | 2018-09-14 | 2016-02-04 | Arce | Asuka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29777 | 29777 | 2015-09-14 | 2012-11-20 | Akiyama | Shiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29646 | 29646 | 2006-09-12 | 2003-08-08 | Miura | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29594 | 29594 | 2012-09-11 | 2011-10-20 | Higashino | Dai | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29471 | 29471 | 1975-09-09 | 1975-03-31 | Kato | Nobukazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29468 | 29468 | 1969-09-09 | 1968-01-29 | Toya | Osamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29451 | 29451 | 2010-09-08 | 2007-07-25 | Yamauchi | Makoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29369 | 29369 | 2017-09-07 | 2014-07-22 | Watanabe | Kenjiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29255 | 29255 | 1974-09-06 | 1972-03-06 | Sawada | Jin | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29232 | 29232 | 2000-09-05 | 1997-09-25 | Ishii | Junzo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
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]) );