FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
490 rows where Registration_Number = 1643
This data as json, CSV (advanced)
State 1
- NY 409
Registration_Number 1
- JETRO, New York · 409 ✖
Registrant_Name 1
- JETRO, New York 409
City 1
- New York 409
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
10261 | 10261 | 1997-03-18 | 1994-08-19 | Hemmi | Yoichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10326 | 10326 | 2003-03-19 | 2001-05-11 | Mori | Shigeki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10327 | 10327 | 2003-03-19 | 2000-09-18 | Kometani | Yuichi | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
10468 | 10468 | 1999-03-21 | 1996-02-05 | Hattori | Osamu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10534 | 10534 | 2010-03-22 | 2006-09-20 | Nishimoto | Keiichi | 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 |
10624 | 10624 | 2000-03-23 | 1999-04-27 | Morii | Motonao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10629 | 10629 | 2002-03-23 | 1999-05-12 | Deguchi | Koji | 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 |
10697 | 10697 | 1996-03-24 | 1992-08-06 | Moriai | Mineo | 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 |
10709 | 10709 | 2005-03-24 | 2004-04-07 | Hirose | Miki | 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 |
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 |
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 |
10824 | 10824 | 2010-03-26 | 2009-04-02 | Hikino | Teruki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10825 | 10825 | 2010-03-26 | 2006-07-13 | Kohama | Teruhiko | 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 |
10827 | 10827 | 2010-03-26 | 2008-10-15 | Ikeda | Kyo | 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 |
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 |
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 |
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 |
10895 | 10895 | 2006-03-27 | 2005-02-16 | Ihara | Makoto | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10896 | 10896 | 2006-03-27 | 2005-04-08 | Takahashi | Yukinaga | 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 |
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 |
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 |
10983 | 10983 | 2007-03-28 | 2006-04-05 | Fukuda | Naoto | 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 |
10988 | 10988 | 2012-03-28 | 2010-10-15 | Kamikatahira | Osamu | 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 |
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 |
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 |
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 |
11082 | 11082 | 2004-03-29 | 2002-12-11 | Miyazato | Akihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11083 | 11083 | 2004-03-29 | 2002-12-11 | Shinozaki | Shinichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11085 | 11085 | 2008-03-29 | 2004-10-19 | Nakayama | Yoshihiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11086 | 11086 | 2009-03-29 | 2008-03-31 | Morimune | Sanako | 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 |
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 |
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 |
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 |
11176 | 11176 | 1995-03-30 | 1992-02-04 | Koyama | Nobuyuki | 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 |
11190 | 11190 | 2004-03-30 | 2003-05-12 | Iida | Shinji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
11194 | 11194 | 2005-03-30 | 2000-02-09 | Katayama | Ken | 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 |
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 |
11676 | 11676 | 1992-03-31 | 1989-08-14 | Kirimura | Mitsuhiko | 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 |
11818 | 11818 | 1999-03-31 | 1996-08-02 | Iwao | Kyoichi | 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 |
12645 | 12645 | 2002-04-02 | 1999-05-05 | Hirano | Shusaku | 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 |
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 |
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 |
13101 | 13101 | 2000-04-10 | 1999-04-27 | Okuyama | Hiromi | 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 |
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 |
13337 | 13337 | 2012-04-14 | 2009-05-15 | Imai | Akira | 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 |
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 |
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 |
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 |
14282 | 14282 | 2002-04-28 | 1999-04-27 | Takahashi | Hideyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
14373 | 14373 | 2004-04-29 | 2002-07-31 | Halamar | Kimberly | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
14907 | 14907 | 2003-04-30 | 2002-12-11 | Nakayama | Midori | 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 |
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 |
15850 | 15850 | 2000-05-07 | 1996-08-02 | Takahara | Masaki | 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 |
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 |
16060 | 16060 | 1992-05-11 | 1990-02-02 | Hagiwara | Seiji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16275 | 16275 | 1998-05-13 | 1995-07-28 | Kotake | Toshiro | 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 |
16620 | 16620 | 1998-05-17 | 1995-07-28 | Mori | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16677 | 16677 | 2007-05-18 | 2002-06-17 | Fujii | Shinya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16702 | 16702 | 1996-05-19 | 1993-08-09 | Takatsuji | Ikushi | 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 |
16834 | 16834 | 1999-05-21 | 1996-08-02 | Eto | Toshihiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16980 | 16980 | 2008-05-23 | 2007-02-15 | Reda | William Richard | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
16981 | 16981 | 2009-05-23 | 2004-10-19 | Akiyama | Hiroyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17056 | 17056 | 2005-05-24 | 2002-07-31 | Ohashi | Naomi | 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 |
17097 | 17097 | 2007-05-25 | 2006-11-02 | Hirabara | Kenji | 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 |
17201 | 17201 | 2008-05-26 | 2006-09-13 | Nishihira | Kenya | 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]) );