FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
490 rows where Registration_Number = 1643 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
State 1
- NY 390
Registration_Number 1
- JETRO, New York · 390 ✖
Registrant_Name 1
- JETRO, New York 390
City 1
- New York 390
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
39099 | 39099 | 1965-12-25 | 1963-06-25 | Koyama | Iwao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36070 | 36070 | 2010-11-19 | 2009-07-29 | Seal | Jacob Scott | 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 |
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 |
1491 | 1491 | 2022-07-26 | Yamaguchi | Jia | 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 |
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 |
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 |
39100 | 39100 | 1965-12-25 | 1963-06-25 | Tokuyama | Jiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
30762 | 30762 | 2004-09-29 | 2001-08-27 | Okumura | Jun | 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 |
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 |
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 |
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 |
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 |
1715 | 1715 | 2022-09-02 | Iwabuchi | Kana | 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 |
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 |
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 |
39107 | 39107 | 1990-12-25 | 1987-12-24 | Kojima | Katsuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
21274 | 21274 | 1997-06-30 | 1993-08-09 | Kaga | Katsumasa | 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 |
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 |
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 |
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 |
30621 | 30621 | 2003-09-27 | 2000-02-09 | Nishioka | Kazuhiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
35993 | 35993 | 1990-11-17 | 1987-02-03 | Takatsu | Kazuhiko | 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 |
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 |
30700 | 30700 | 2007-09-28 | 2006-04-05 | Yamaguchi | Kazuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36280 | 36280 | 2008-11-23 | 2006-01-30 | Iino | Kazumi | 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 |
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 |
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 |
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 |
21270 | 21270 | 1997-06-30 | 1990-08-03 | Matsunaga | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36121 | 36121 | 1995-11-20 | 1993-02-03 | Nakamura | Kazuo | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36531 | 36531 | 1969-11-29 | 1966-07-27 | Ino | Kazuo | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
2115 | 2115 | 2020-11-05 | Miyano | Keita | 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 |
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 |
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 |
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 |
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 |
21275 | 21275 | 1997-06-30 | 1989-08-14 | Maruyama | Kenichi | 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 |
30761 | 30761 | 2004-09-29 | 2002-08-23 | Ishihara | Kenichi | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
20589 | 20589 | 2012-06-29 | 2010-08-25 | Sato | Kiichiro | 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 |
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 |
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 |
3386 | 3386 | 1965-01-08 | 1969-03-14 | Hara | Kiyoshi | 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 |
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 |
36206 | 36206 | 1977-11-22 | 1975-03-31 | Tanigawa | Kiyoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
1615 | 1615 | 2022-08-15 | Fukuoka | Kohei | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
35952 | 35952 | 2000-11-16 | 1996-08-02 | Hashimoto | Koji | 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 |
33684 | 33684 | 2012-10-26 | 2009-09-25 | Mori | Kotaro | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
30645 | 30645 | 1971-09-28 | 1968-01-29 | Cho | Kyohei | 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 |
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 |
5709 | 5709 | 1977-02-01 | 1973-10-12 | Miyata | Kyoshiro | 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 |
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 |
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 |
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 |
32594 | 32594 | 2004-10-10 | 2000-12-29 | Kato | Makoto | 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]) );