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 186
Registration_Number 1
- JETRO, New York · 186 ✖
Registrant_Name 1
- JETRO, New York 186
City 1
- New York 186
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
22540 | 22540 | 2009-07-03 | 2006-06-14 | Mitsumata | Hiroki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22545 | 22545 | 2012-07-03 | 2009-07-08 | Arai | Masyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22605 | 22605 | 2000-07-05 | 1997-09-25 | Ihara | Kazuhito | 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 |
22652 | 22652 | 2003-07-06 | 2000-09-18 | Fujii | Yasuhiro | 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 |
22714 | 22714 | 1997-07-07 | 1994-08-19 | Maegawa | Toru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22788 | 22788 | 2003-07-08 | 2000-10-12 | Iwaya | Takahiko | 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 |
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 |
22973 | 22973 | 2001-07-11 | 1999-04-27 | Murayama | Yutaka | 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 |
23071 | 23071 | 2006-07-13 | 2003-09-09 | Hiyama | Wataru | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23074 | 23074 | 2007-07-13 | 2004-08-11 | Moro | Kengo | 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 |
23390 | 23390 | 2010-07-16 | 2008-02-06 | Lyngaas | Sean | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23392 | 23392 | 2010-07-16 | 2007-07-23 | Kuroda | Junichiro | 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 |
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 |
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 |
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 |
23681 | 23681 | 2010-07-20 | 2008-09-18 | Ito | Hajime | 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 |
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 |
23796 | 23796 | 2007-07-22 | 2004-07-30 | Tada | Akihiro | 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 |
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 |
23930 | 23930 | 1997-07-23 | 1995-02-06 | Shimoto | Kenji | 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 |
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 |
24028 | 24028 | 2004-07-25 | 2001-08-27 | Kawata | Tadahiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24029 | 24029 | 2007-07-25 | 2004-08-06 | Iwata | Tsuyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24030 | 24030 | 2007-07-25 | 2005-08-17 | Nakao | Yasuhisa | 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 |
24111 | 24111 | 2010-07-26 | 2009-06-09 | Kato | Reiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24112 | 24112 | 2010-07-26 | 2007-07-23 | Nakaishi | Naritaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24318 | 24318 | 2008-07-28 | 2005-04-08 | Kimura | Keiichi | 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 |
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 |
24385 | 24385 | 2005-07-29 | 2002-07-31 | Satake | Yoshinori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
24392 | 24392 | 2010-07-29 | 2007-07-13 | Minami | Ryo | 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 |
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 |
25088 | 25088 | 2006-07-31 | 2003-08-08 | Mitsuishi | Hiroyuki | 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 |
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 |
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 |
25896 | 25896 | 2011-08-03 | 2007-09-12 | Hatano | Yuichi | 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 |
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 |
26057 | 26057 | 2010-08-05 | 2007-07-23 | Mizuta | Yutaka | 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 |
26183 | 26183 | 2004-08-07 | 2001-10-17 | Ohara | Tomoaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26392 | 26392 | 1997-08-10 | 1995-02-06 | Ando | Noboru | 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 |
26455 | 26455 | 1997-08-11 | 1995-02-06 | Katagiri | Kiyoshi | 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 |
26641 | 26641 | 2012-08-14 | 2008-08-29 | Semimoto | Atsushi | 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 |
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 |
26977 | 26977 | 2006-08-18 | 2002-03-04 | Shindo | Tatsuhiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
26979 | 26979 | 2006-08-18 | 2004-08-30 | Rhatigan | Marc Patrick | 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 |
27019 | 27019 | 1995-08-19 | 1993-02-03 | Fujimoto | Ichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27021 | 27021 | 1997-08-19 | 1994-08-19 | Takai | Yoshitsugu | 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 |
27155 | 27155 | 2006-08-21 | 2004-10-19 | Hosokawa | Masahiko | 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 |
27224 | 27224 | 2006-08-22 | 2001-07-10 | Matsumoto | Hiroki | 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 |
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 |
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 |
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 |
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 |
27493 | 27493 | 1997-08-26 | 1995-02-06 | Mizutani | Osamu | 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 |
27794 | 27794 | 2002-08-30 | 1999-04-27 | Kimura | Yoichi | 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 |
29038 | 29038 | 1997-09-02 | 1994-08-19 | Kanemaki | Tomonori | 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 |
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 |
29232 | 29232 | 2000-09-05 | 1997-09-25 | Ishii | Junzo | 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 |
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 |
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 |
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 |
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 |
29594 | 29594 | 2012-09-11 | 2011-10-20 | Higashino | Dai | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29646 | 29646 | 2006-09-12 | 2003-08-08 | Miura | Akira | 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 |
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 |
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 |
29955 | 29955 | 1995-09-16 | 1993-02-03 | Kajishima | Tatsuya | 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 |
30087 | 30087 | 1998-09-19 | 1995-07-28 | Hirai | Toshinaga | 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]) );