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"
This data as json, CSV (advanced)
State 1
- NY 309
Registration_Number 1
- JETRO, New York 309
Registrant_Name 1
- JETRO, New York · 309 ✖
City 1
- New York 309
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17304 | 17304 | 2001-05-28 | 1999-04-27 | Sonoda | Toshihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17363 | 17363 | 2002-05-29 | 1999-08-10 | Kuwahara | Yasuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17365 | 17365 | 2004-05-29 | 2001-07-10 | Yoshida | Masahiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17366 | 17366 | 2004-05-29 | 2001-08-27 | Mishima | Eiichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17369 | 17369 | 2008-05-29 | 2005-08-17 | Nishina | Takayuki | 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 |
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 |
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 |
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 |
17901 | 17901 | 1997-05-31 | 1994-08-19 | Ito | Hideki | 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 |
18762 | 18762 | 1992-06-03 | 1989-08-14 | Matsumoto | Kenji | 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 |
18993 | 18993 | 1998-06-06 | 1994-08-19 | Takatori | Akinori | 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 |
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 |
19118 | 19118 | 1998-06-09 | 1995-07-28 | Jubishi | Ryo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19119 | 19119 | 2001-06-09 | 1999-04-27 | Nishiyama | Hidehiko | 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 |
19195 | 19195 | 1996-06-10 | 1993-08-09 | Doi | Ryoji | 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 |
19240 | 19240 | 1991-06-11 | 1988-08-31 | Kodaira | Nobuyori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19246 | 19246 | 1995-06-11 | 1993-02-03 | Asonuma | Shinji | 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 |
19306 | 19306 | 1999-06-12 | 1996-08-02 | Ogoshi | Harushige | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19308 | 19308 | 2003-06-12 | 2000-09-18 | Matsuda | Hitoshi | 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 |
19358 | 19358 | 2004-06-13 | 2001-08-27 | Hasegawa | Naoyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19439 | 19439 | 1995-06-14 | 1992-08-06 | Bando | Kazuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19446 | 19446 | 1998-06-14 | 1996-02-05 | Masubuchi | Katuhiko | 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 |
19590 | 19590 | 2005-06-15 | 2002-07-31 | Miura | Kenji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19595 | 19595 | 2010-06-15 | 2006-08-02 | Ackroyd | James Cameron | 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 |
19685 | 19685 | 1998-06-16 | 1996-02-05 | Ikefuchi | Masakazu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19686 | 19686 | 1998-06-16 | 1995-07-28 | Kittaka | Kimihisa | 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 |
19766 | 19766 | 1996-06-17 | 1993-08-09 | Okada | Hideichi | 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 |
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 |
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 |
19811 | 19811 | 1992-06-18 | 1989-08-14 | Hirai | Toshifumi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19814 | 19814 | 1996-06-18 | 1994-02-14 | Tomonari | Shinichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19822 | 19822 | 2004-06-18 | 2001-10-18 | Ishii | Shinji | 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 |
19867 | 19867 | 1992-06-19 | 1991-08-23 | Matsufuji | Tetsuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19871 | 19871 | 1998-06-19 | 1996-08-02 | Iizuka | Kazunori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19873 | 19873 | 2002-06-19 | 1999-08-10 | Komoto | Mitsuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19874 | 19874 | 2004-06-19 | 2001-07-10 | Miyamoto | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19875 | 19875 | 2004-06-19 | 2001-09-18 | Terazawa | Tatsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19937 | 19937 | 1999-06-20 | 1996-08-02 | Ito | Takeshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19981 | 19981 | 1996-06-21 | 1994-08-19 | Noguchi | Nobuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19983 | 19983 | 2000-06-21 | 1999-04-27 | Yamada | Noriyasu | 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 |
20039 | 20039 | 1999-06-22 | 1996-08-02 | Ishiguro | Norihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20048 | 20048 | 2007-06-22 | 2004-07-30 | Watanabe | Hiroyoshi | 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 |
20095 | 20095 | 1990-06-23 | 1988-08-16 | Kojima | Mikio | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20113 | 20113 | 1998-06-23 | 1995-07-28 | Hosokawa | Masahiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20179 | 20179 | 1995-06-24 | 1992-08-06 | Tamura | Yoshimasa | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20180 | 20180 | 1995-06-24 | 1992-08-06 | Torika | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20181 | 20181 | 1997-06-24 | 1995-02-06 | Ueda | Michiharu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20186 | 20186 | 2000-06-24 | 1997-09-25 | Otaka | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20187 | 20187 | 2000-06-24 | 1997-09-25 | Yamashita | Tatsuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20190 | 20190 | 2005-06-24 | 2002-07-31 | Inoue | Satoshi | 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 |
20230 | 20230 | 1995-06-25 | 1992-08-06 | Suzuki | Yoshinori | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20247 | 20247 | 1999-06-25 | 1995-07-28 | Tomatsu | Shushichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20252 | 20252 | 2005-06-25 | 2002-07-31 | Nakagawa | Junichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20254 | 20254 | 2008-06-25 | 2005-08-01 | Ueda | Yoji | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20255 | 20255 | 2010-06-25 | 2007-07-23 | Ichikawa | Tagui | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20325 | 20325 | 2008-06-26 | 2006-09-19 | Okumura | Kazuo | 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 |
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 |
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 |
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 |
20390 | 20390 | 2001-06-27 | 1999-05-12 | Suzuki | Yasutomo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20398 | 20398 | 2006-06-27 | 2003-08-08 | Watanabe | Mototaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20402 | 20402 | 2011-06-27 | 2008-06-30 | Nakamaki | Toshiaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20403 | 20403 | 2011-06-27 | 2008-06-30 | Naruse | Takashi | 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 |
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 |
20452 | 20452 | 2001-06-28 | 2000-09-18 | Urata | Masutaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20455 | 20455 | 2002-06-28 | 1999-08-10 | Koyanagi | Masayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20456 | 20456 | 2002-06-28 | 1999-08-10 | Noguchi | Satoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20457 | 20457 | 2002-06-28 | 1999-08-10 | Watanabe | Takayuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20461 | 20461 | 2003-06-28 | 2002-07-31 | Murata | Keiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20462 | 20462 | 2003-06-28 | 2000-10-12 | Ichikawa | Yoshiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20463 | 20463 | 2003-06-28 | 2000-10-12 | Murayama | Katsuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20467 | 20467 | 2005-06-28 | 2002-07-31 | Kitaoka | Hiroshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20473 | 20473 | 2010-06-28 | 2007-04-26 | Sato | Taku | 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 |
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 |
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 |
20566 | 20566 | 1997-06-29 | 1994-08-19 | Kamata | Mitsuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20570 | 20570 | 2001-06-29 | 1999-04-27 | Ito | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20571 | 20571 | 2001-06-29 | 1999-04-27 | Yoshikawa | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20580 | 20580 | 2007-06-29 | 2004-07-20 | Ono | Yota | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20584 | 20584 | 2008-06-29 | 2005-08-01 | Sawai | Tomoki | 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]) );