FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
490 rows where Registrant_Name = "JETRO, New York" sorted by Short_Form_Date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11033 | 11033 | 1984-03-29 | 1961-05-28 | Miyake | Yutaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
7691 | 7691 | 1973-02-26 | 1963-06-25 | Hara | Tsutomu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
8647 | 8647 | 1964-03-01 | 1963-06-25 | Someya | Keiji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10117 | 10117 | 1966-03-17 | 1963-06-25 | Moriguchi | Ryouichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10366 | 10366 | 1966-03-20 | 1963-06-25 | Aoyama | Haruo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
15307 | 15307 | 1963-05-01 | 1963-06-25 | Fujise | Eijiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23755 | 23755 | 1964-07-22 | 1963-06-25 | Hirata | Kozo | 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 |
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 |
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 |
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 |
13202 | 13202 | 1967-04-12 | 1965-03-01 | Shimada | Katsumi | 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 |
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 |
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 |
10422 | 10422 | 1969-03-21 | 1966-01-27 | Kuroda | Akio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23766 | 23766 | 1969-07-22 | 1966-02-27 | Hirose | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10785 | 10785 | 1975-03-26 | 1966-04-25 | Ishikawa | Samuel | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10940 | 10940 | 1975-03-28 | 1966-04-25 | Masaoka | Etsu Mineta | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19841 | 19841 | 1974-06-19 | 1966-04-25 | Masaoka | Mike Masara | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22079 | 22079 | 1969-07-01 | 1966-07-27 | Ohgami | Hitoshi | 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 |
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 |
23601 | 23601 | 1970-07-19 | 1967-07-28 | Nagao | Toshihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
4018 | 4018 | 1972-01-18 | 1968-01-29 | Ochi | Norio | 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 |
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 |
3386 | 3386 | 1965-01-08 | 1969-03-14 | Hara | Kiyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
4248 | 4248 | 1972-01-22 | 1969-09-11 | Nakaima | Hirokazu | 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 |
10851 | 10851 | 1972-03-27 | 1969-09-11 | Kawamoto | Shigeo | 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 |
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 |
13739 | 13739 | 1973-04-19 | 1970-03-05 | Shinohara | Jiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
15960 | 15960 | 1972-05-09 | 1970-03-05 | Kobori | Daitetsu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25938 | 25938 | 1973-08-04 | 1970-03-05 | Akashi | Masao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27184 | 27184 | 1973-08-22 | 1970-03-05 | Aiko | Jiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17122 | 17122 | 1973-05-26 | 1970-08-26 | Komatsu | Kunio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
9449 | 9449 | 1975-03-08 | 1971-02-14 | Mizuguchi | Yasuhiro | 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 |
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 |
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 |
7161 | 7161 | 1975-02-17 | 1972-07-20 | Kitamura | Toshio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11474 | 11474 | 1977-03-31 | 1972-07-20 | Kyozawa | Tomijiro | 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 |
5709 | 5709 | 1977-02-01 | 1973-10-12 | Miyata | Kyoshiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19638 | 19638 | 1976-06-16 | 1973-10-12 | Honobe | Susumu | 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 |
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 |
10372 | 10372 | 1977-03-20 | 1974-06-27 | Kimura | Nobuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27463 | 27463 | 1976-08-26 | 1974-08-27 | Matsuda | Iwao | 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 |
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 |
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 |
9385 | 9385 | 1980-03-07 | 1977-12-05 | Kuraishi | Fumiaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13167 | 13167 | 1981-04-11 | 1977-12-05 | Takii | Mitsuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16817 | 16817 | 1980-05-21 | 1977-12-05 | Suzuki | Ryohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19743 | 19743 | 1980-06-17 | 1977-12-05 | Sagawa | Toshio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20366 | 20366 | 1981-06-27 | 1978-10-11 | Takayuki | Hirano | 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 |
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 |
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 |
6929 | 6929 | 1983-02-15 | 1980-04-30 | Sugiura | Shogo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10430 | 10430 | 1983-03-21 | 1980-04-30 | Shioya | Takafusa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26826 | 26826 | 1988-08-16 | 1980-06-20 | Prosser | Linda | 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 |
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 |
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 |
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 |
19291 | 19291 | 1984-06-12 | 1981-09-29 | Nakano | Masataka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20376 | 20376 | 1984-06-27 | 1981-09-29 | Aoyagi | Keiichi | 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 |
22689 | 22689 | 1984-07-07 | 1982-10-05 | Hamaoka | Heiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6224 | 6224 | 1984-02-06 | 1983-04-29 | Kawamoto | Shigeo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17700 | 17700 | 1986-05-31 | 1983-04-29 | Mizutani | Shiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
28830 | 28830 | 1984-09-01 | 1983-04-29 | Isayama | Takeshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21107 | 21107 | 1988-06-30 | 1983-11-11 | Nagasaka | Toshihisa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10127 | 10127 | 1986-03-17 | 1983-11-14 | Okamoto | Junichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24004 | 24004 | 1987-07-25 | 1983-11-14 | Hori | Hajimu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12728 | 12728 | 1987-04-04 | 1985-01-07 | Takai | Eiji | 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 |
17694 | 17694 | 1986-05-31 | 1985-01-07 | Sato | Mitsuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19233 | 19233 | 1987-06-11 | 1985-01-07 | Kawano | Hirobumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22173 | 22173 | 1987-07-01 | 1985-01-07 | Hayashi | Mitsuaki | 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 |
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 |
19806 | 19806 | 1988-06-18 | 1986-08-06 | Kitagawa | Yukimasa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22182 | 22182 | 1988-07-01 | 1986-08-06 | Hayashi | Hirokazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19807 | 19807 | 1989-06-18 | 1986-08-19 | Suzuki | Shitaro | 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 |
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 |
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 |
19160 | 19160 | 1990-06-10 | 1987-12-23 | Sakatsume | Masayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16599 | 16599 | 1990-05-17 | 1987-12-24 | Marui | Takao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23853 | 23853 | 1991-07-23 | 1987-12-24 | Takii | Mitsuo | 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 |
6462 | 6462 | 1988-02-09 | 1988-02-09 | Furuta | Hajime | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
9631 | 9631 | 1991-03-11 | 1988-02-09 | Ichikawa | Nobuharu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23851 | 23851 | 1991-07-23 | 1988-02-09 | Take | Nobumasa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
9835 | 9835 | 1992-03-14 | 1988-08-16 | Takahashi | Toshiki | 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]) );