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_Termination_Date 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20411 | 20411 | 2023-06-27 | 2020-07-21 | Ishihara | Tetsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13347 | 13347 | 2023-04-14 | 2018-09-13 | Niikura | Yukari | 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 |
4190 | 4190 | 2023-01-20 | 2020-01-09 | Furujo | Tatsuya | 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 |
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 |
27031 | 27031 | 2022-08-19 | 2021-09-09 | Nakayama | Takaaki | 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 |
22008 | 22008 | 2022-06-30 | 2017-08-08 | Kasahara | Ryo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22009 | 22009 | 2022-06-30 | 2017-08-10 | Nakazawa | Kiyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22010 | 22010 | 2022-06-30 | 2019-08-27 | Takeda | Shinjiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22011 | 22011 | 2022-06-30 | 2019-08-30 | Ito | Sadanori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22012 | 22012 | 2022-06-30 | 2019-09-03 | Machii | Hiroaki | 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 |
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 |
21992 | 21992 | 2021-06-30 | 2017-08-31 | Sakado | Shunsuke | 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 |
10832 | 10832 | 2021-03-26 | 2019-10-03 | Inaba | Kotohumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10636 | 10636 | 2021-03-23 | 2018-04-12 | Suzuki | Hiroyuki | 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 |
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 |
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 |
27503 | 27503 | 2020-08-26 | 2018-07-23 | Hatakeyama | Issei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26803 | 26803 | 2020-08-15 | 2017-01-05 | Gonda | Tadashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26134 | 26134 | 2020-08-06 | 2017-01-31 | Nagao | Yusuke | 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 |
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 |
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 |
25363 | 25363 | 2019-07-31 | 2016-08-09 | Numata | Shigehito | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22800 | 22800 | 2019-07-08 | 2016-06-28 | Soda | Takeshi | 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 |
17065 | 17065 | 2019-05-24 | 2015-07-28 | Kayama | Hirobumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12975 | 12975 | 2019-04-08 | 2016-04-12 | Higuchi | Taisuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11096 | 11096 | 2019-03-29 | 2014-09-18 | Suzuki | Atsushi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10408 | 10408 | 2019-03-20 | 2018-04-12 | Okimoto | Kyoko | 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 |
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 |
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 |
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 |
20332 | 20332 | 2018-06-26 | 2015-08-18 | Mori | Masahiro | 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 |
10907 | 10907 | 2018-03-27 | 2016-06-30 | Igawa | Shinichi | 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 |
27442 | 27442 | 2017-08-25 | 2013-05-23 | Oshima | Kentaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
25302 | 25302 | 2017-07-31 | 2014-09-23 | Kawabata | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24335 | 24335 | 2017-07-28 | 2014-07-01 | Maruoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20484 | 20484 | 2017-06-28 | 2014-06-17 | Imamura | Wataru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19991 | 19991 | 2017-06-21 | 2014-02-20 | Hachiyama | Koji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12196 | 12196 | 2017-03-31 | 2016-03-01 | Okazawa | Mamiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
12204 | 12204 | 2017-03-31 | 2015-09-15 | Rachmilowitz | Michael | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10717 | 10717 | 2017-03-24 | 2016-05-26 | Hiagakiuchi | Miyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
4867 | 4867 | 2017-01-30 | 2013-05-28 | Horita | Noriyasu | 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 |
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 |
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 |
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 |
26983 | 26983 | 2016-08-18 | 2013-09-03 | Mitsuhashi | Kenichi | 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 |
20481 | 20481 | 2016-06-28 | 2013-08-20 | Kume | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20195 | 20195 | 2016-06-24 | 2013-07-18 | Komoto | Takeshi | 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 |
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 |
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 |
10715 | 10715 | 2016-03-24 | 2014-10-30 | Ogawa | Yuta | 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 |
3833 | 3833 | 2016-01-15 | 2010-08-04 | Kobayashi | Nagisa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
3456 | 3456 | 2016-01-08 | 2014-05-27 | Ota | Naoko | 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 |
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 |
27366 | 27366 | 2015-08-24 | 2012-11-20 | Miyazaki | Atsufumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22993 | 22993 | 2015-07-11 | 2012-07-26 | Kawada | Mio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20330 | 20330 | 2015-06-26 | 2012-08-14 | Narita | Tatsuji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10403 | 10403 | 2015-03-20 | 2013-04-11 | Eno | Koichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10404 | 10404 | 2015-03-20 | 2013-08-27 | Koshiba | Jane | 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 |
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 |
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 |
26465 | 26465 | 2014-08-11 | 2010-03-10 | Guinn | Robert | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24598 | 24598 | 2014-07-30 | 2010-06-30 | Fujihara | Masaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24599 | 24599 | 2014-07-30 | 2011-08-16 | Takahashi | Aya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24329 | 24329 | 2014-07-28 | 2012-09-06 | Sakurai | Kazuhito | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20479 | 20479 | 2014-06-28 | 2011-06-29 | Morooka | Kenichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19005 | 19005 | 2014-06-06 | 2011-12-01 | Jacquemart | HirokoTachibana | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17521 | 17521 | 2014-05-30 | 2011-06-03 | Meagher | Thomas | 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 |
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 |
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 |
29068 | 29068 | 2013-09-02 | 2010-09-29 | Mizutani | Koichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24401 | 24401 | 2013-07-29 | 2010-10-15 | Matsushita | Miho | 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 |
21784 | 21784 | 2013-06-30 | 2010-08-25 | Sato | Tomoya | 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 |
20406 | 20406 | 2013-06-27 | 2010-11-09 | Kawamoto | Kenichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
18861 | 18861 | 2013-06-04 | 2012-03-22 | Ezuka | Saori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
18686 | 18686 | 2013-06-02 | 2010-08-04 | Okuya | Toshikazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17512 | 17512 | 2013-05-30 | 2009-06-09 | Aihara | Kimitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10829 | 10829 | 2013-03-26 | 2011-10-06 | Matsunoshita | Shuho | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10536 | 10536 | 2013-03-22 | 2010-03-31 | Kimura | Tadaaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10537 | 10537 | 2013-03-22 | 2010-09-15 | Takeuchi | Mikio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
5875 | 5875 | 2013-02-01 | 2010-04-09 | Nagai | Shingo | 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]) );