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 441
Registration_Number 1
- JETRO, New York · 441 ✖
Registrant_Name 1
- JETRO, New York 441
City 1
- New York 441
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6067 | 6067 | 1993-02-03 | 1990-02-02 | Goto | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6068 | 6068 | 1993-02-03 | 1990-02-02 | Kojima | Ainosuke | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6198 | 6198 | 2005-02-05 | 2002-07-31 | Kaji | Katsuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6199 | 6199 | 2008-02-05 | 2006-11-02 | Takahashi | Kei | 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 |
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 |
6235 | 6235 | 1995-02-06 | 1992-02-04 | Kameya | Toshiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6236 | 6236 | 1995-02-06 | 1992-02-04 | Kubota | Hideo | 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 |
6238 | 6238 | 1995-02-06 | 1991-02-08 | Hirai | Sumihito | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6239 | 6239 | 1995-02-06 | 1991-02-08 | Sasamoto | Wataru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6242 | 6242 | 1995-02-06 | 1992-08-06 | Nishio | Akemi | 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 |
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 |
6827 | 6827 | 1994-02-14 | 1990-08-03 | Ohashi | Koshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
6829 | 6829 | 1994-02-14 | 1989-08-14 | Ito | Kunio | 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 |
6981 | 6981 | 2012-02-15 | 2009-09-25 | Makino | Hiroshi | 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 |
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 |
7486 | 7486 | 2010-02-23 | 2009-05-07 | Eiki-Law | Maya | 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 |
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 |
9411 | 9411 | 2001-03-07 | 1999-04-27 | Goto | Hideyuki | 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 |
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 |
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 |
10064 | 10064 | 1998-03-16 | 1995-02-06 | Ando | Masami | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10066 | 10066 | 1998-03-16 | 1995-07-28 | Sagane | Masakazu | 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 |
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 |
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 |
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]) );