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 Short_Form_Last_Name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
20571 | 20571 | 2001-06-29 | 1999-04-27 | Yoshikawa | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1723 | 1723 | 2019-09-05 | Yoshida | Natsue | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
17365 | 17365 | 2004-05-29 | 2001-07-10 | Yoshida | Masahiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1836 | 1836 | 2020-09-24 | Yoneyama | Hiroshi | 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 |
11089 | 11089 | 2011-03-29 | 2008-03-31 | Yokota | Kunitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13638 | 13638 | 1991-04-17 | 1988-08-16 | Yokota | Mitsuru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23629 | 23629 | 2016-07-19 | 2014-08-14 | Yokota | Toshiyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22648 | 22648 | 2001-07-06 | 1999-04-27 | Yatani | Kohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24106 | 24106 | 2002-07-26 | 1999-08-10 | Yanase | Tadao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22004 | 22004 | 2022-06-30 | 2017-06-27 | Yanagisawa | Tomoya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13052 | 13052 | 2003-04-09 | 2002-06-17 | Yanagida | Yoshihiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10369 | 10369 | 1973-03-20 | 1969-09-11 | Yamazaki | Tadao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10899 | 10899 | 2008-03-27 | 2007-04-04 | Yamazaki | Kunihiro | 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 |
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 |
20187 | 20187 | 2000-06-24 | 1997-09-25 | Yamashita | Tatsuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11093 | 11093 | 2018-03-29 | 2017-04-13 | Yamamoto | Reiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21271 | 21271 | 1997-06-30 | 1990-08-03 | Yamamoto | Shunsaku | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10125 | 10125 | 1983-03-17 | 1980-12-09 | Yamakawa | Sigeru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1491 | 1491 | 2022-07-26 | Yamaguchi | Jia | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
21434 | 21434 | 2002-06-30 | 1999-05-19 | Yamaguchi | Takatsugu | 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 |
15926 | 15926 | 1987-05-08 | 1985-01-07 | Yamagishi | Kiichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10826 | 10826 | 2010-03-26 | 2007-10-15 | Yamade | Koji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6202 | 6202 | 2010-02-05 | 2004-10-19 | Yamada | Ryohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19983 | 19983 | 2000-06-21 | 1999-04-27 | Yamada | Noriyasu | 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 |
7259 | 7259 | 2016-02-19 | 2006-07-28 | Yajima | Haruko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21276 | 21276 | 1997-06-30 | 1994-08-19 | Yahagi | Shinichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23628 | 23628 | 2013-07-19 | 2011-04-07 | Winograd | Rachel | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
3207 | 3207 | 2019-01-04 | 2010-08-11 | Watt | Ian | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1806 | 1806 | 2022-09-19 | Watanabe | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
10891 | 10891 | 2004-03-27 | 2003-03-26 | Watanabe | Masanori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11087 | 11087 | 2009-03-29 | 2007-10-15 | Watanabe | Tomoko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13340 | 13340 | 2016-04-14 | 2015-04-23 | Watanabe | Mai | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20048 | 20048 | 2007-06-22 | 2004-07-30 | Watanabe | Hiroyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20398 | 20398 | 2006-06-27 | 2003-08-08 | Watanabe | Mototaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20457 | 20457 | 2002-06-28 | 1999-08-10 | Watanabe | Takayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22520 | 22520 | 1981-07-03 | 1979-03-07 | Watanabe | Osamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23623 | 23623 | 2001-07-19 | 1999-04-27 | Watanabe | Hidenao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25985 | 25985 | 1989-08-05 | 1987-02-03 | Watanabe | Noboru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29122 | 29122 | 2009-09-03 | 2006-07-20 | Watanabe | Yumiko | 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 |
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 |
21262 | 21262 | 1997-06-30 | 1992-02-04 | Washio | Tomoharu | 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 |
13338 | 13338 | 2016-04-14 | 2012-04-12 | Wakisaka | Michihiro | 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 |
19006 | 19006 | 2021-06-06 | 2018-07-05 | Wakabayashi | Kengo | 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 |
19459 | 19459 | 2016-06-14 | 2013-07-18 | Wada | Junichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20405 | 20405 | 2013-06-27 | 2010-06-30 | Wada | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11748 | 11748 | 1996-03-31 | 1993-08-09 | Utsumi | Hiromoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10699 | 10699 | 2000-03-24 | 1999-04-27 | Usuzawa | Tsutomu | 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 |
20452 | 20452 | 2001-06-28 | 2000-09-18 | Urata | Masutaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11075 | 11075 | 2002-03-29 | 1999-05-05 | Ueyama | Kazuo | 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 |
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 |
20181 | 20181 | 1997-06-24 | 1995-02-06 | Ueda | Michiharu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20254 | 20254 | 2008-06-25 | 2005-08-01 | Ueda | Yoji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1388 | 1388 | 2023-07-10 | Uchino | Yasuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
11224 | 11224 | 2012-03-30 | 2010-10-15 | Uchida | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
3118 | 3118 | 1974-01-03 | 1970-03-05 | Tsuyama | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23126 | 23126 | 1997-07-14 | 1995-02-06 | Tsutsumi | Michio | 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 |
11001 | 11001 | 2023-03-28 | 2021-10-12 | Tsukamoto | Kazunari | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21273 | 21273 | 1997-06-30 | 1992-08-06 | Tsukamoto | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19795 | 19795 | 1973-06-18 | 1971-02-14 | Tsuji | Ryosuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27226 | 27226 | 2007-08-22 | 2002-07-31 | Tsuchiya | Tomohiro | 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 |
15765 | 15765 | 2008-05-05 | 2005-08-01 | Toyama . | Tsuyoshi | 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 |
20180 | 20180 | 1995-06-24 | 1992-08-06 | Torika | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25178 | 25178 | 2011-07-31 | 2008-10-31 | Torii | Yoichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19814 | 19814 | 1996-06-18 | 1994-02-14 | Tomonari | Shinichi | 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 |
20090 | 20090 | 1982-06-23 | 1980-12-09 | Tominaga | Takao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20247 | 20247 | 1999-06-25 | 1995-07-28 | Tomatsu | Shushichi | 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 |
10984 | 10984 | 2007-03-28 | 2004-07-20 | Toda | Shigehiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19875 | 19875 | 2004-06-19 | 2001-09-18 | Terazawa | Tatsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19328 | 19328 | 2019-06-12 | 2016-07-07 | Teramura | Hidenobu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6710 | 6710 | 2021-02-12 | 2015-10-27 | Tasaki | O | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11081 | 11081 | 2004-03-29 | 2000-09-18 | Taoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11179 | 11179 | 1996-03-30 | 1993-08-09 | Taniguchi | Masaki | 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 |
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 |
283 | 283 | 2006-02-01 | Tanaka | Yumiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
6237 | 6237 | 1995-02-06 | 1992-02-04 | Tanaka | Hidetoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22791 | 22791 | 2011-07-08 | 2008-07-23 | Tanaka | Tetsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23981 | 23981 | 2018-07-24 | 2016-07-19 | Tanaka | Hirotoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26398 | 26398 | 2010-08-10 | 2006-07-14 | Tanaka | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27415 | 27415 | 1983-08-25 | 1980-12-09 | Tanaka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20179 | 20179 | 1995-06-24 | 1992-08-06 | Tamura | Yoshimasa | 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]) );