FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
192 rows where Registrant_Name = "JETRO, Chicago"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
556 | 556 | 2013-03-26 | Stevenson | Naoko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
565 | 565 | 2018-03-27 | Hashimoto | Tsubasa | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
590 | 590 | 2020-03-30 | Nishizawa | Tomofumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
612 | 612 | 2000-04-05 | Inforzato | Ralph | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1539 | 1539 | 2018-09-25 | Kamimura | Makoto | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1540 | 1540 | 2018-09-25 | Ogawa | Yumeko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1551 | 1551 | 2016-09-27 | Kawachi | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1578 | 1578 | 2019-09-30 | Fujimoto | Fujio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
3318 | 3318 | 1989-01-12 | 1986-10-17 | Suzuki | Akio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
4400 | 4400 | 2002-01-29 | 1998-10-01 | Take | Nobumasa | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5040 | 5040 | 2008-01-31 | 2004-08-31 | Sasaki | Teruo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5042 | 5042 | 2008-01-31 | 2006-10-26 | Soobratty | Ayumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5095 | 5095 | 2012-01-31 | 2008-09-30 | Hashimoto (Behr) | Ritsuko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5309 | 5309 | 1977-02-01 | 1975-03-21 | Kimba | Hirofumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5435 | 5435 | 2006-02-01 | 2003-03-03 | Saito | Hidemi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
6200 | 6200 | 1999-02-11 | 1996-03-13 | Morita | Ikuhiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
7776 | 7776 | 2013-02-28 | 2012-03-30 | Florida | Tomoko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8137 | 8137 | 1967-03-01 | 1965-02-02 | Inui | Fumio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8141 | 8141 | 1969-03-01 | 1965-02-02 | Hikida | Joseph S. | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8595 | 8595 | 1971-03-05 | 1968-03-12 | Suzuki | Ken | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9002 | 9002 | 1999-03-10 | 1996-03-13 | Monden | Takao | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9054 | 9054 | 1993-03-11 | 1989-08-29 | Hamada | Kazuaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9127 | 9127 | 1986-03-12 | 1983-09-22 | Hoshino | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9144 | 9144 | 1998-03-12 | 1995-09-18 | Watanabe | Hisanori | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9206 | 9206 | 2008-03-13 | 2005-10-05 | Tsuchiya | Takashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9343 | 9343 | 1981-03-15 | 1977-09-07 | Koyanagi | Takeaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9826 | 9826 | 1973-03-21 | 1969-03-04 | Izawa | Chihiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9901 | 9901 | 1980-03-22 | 1977-03-11 | Saito | Shinichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9903 | 9903 | 1983-03-22 | 1981-01-23 | Nagata | Eiichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10099 | 10099 | 2000-03-24 | 1997-09-17 | Ishii | Yasumichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10147 | 10147 | 1994-03-25 | 1990-10-16 | Masuda | Koutaro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10148 | 10148 | 1994-03-25 | 1990-10-16 | Umezawa | Shigeyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10184 | 10184 | 1983-03-26 | 1981-01-23 | Tanaka | Sumio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10202 | 10202 | 1991-03-26 | 1988-10-25 | Ito | Tomoyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10212 | 10212 | 2003-03-26 | 2001-01-10 | Tomita | Tetsutaro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10264 | 10264 | 1988-03-27 | 1986-04-21 | Fujihara | Shiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10273 | 10273 | 1995-03-27 | 1992-09-10 | Hara | Noriyasu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10275 | 10275 | 2001-03-27 | 1998-10-15 | Ishii | Shigeru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10276 | 10276 | 2001-03-27 | 1998-10-15 | Wada | Aya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10282 | 10282 | 2004-03-27 | 2001-09-04 | Terahara | Yoshihito | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10288 | 10288 | 2009-03-27 | 2004-08-31 | Nakajo | Kazuya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10290 | 10290 | 2010-03-27 | 2008-09-30 | Takashi | Muneo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10355 | 10355 | 1996-03-28 | 1993-03-11 | Toyonaga | Yoshitaka | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10369 | 10369 | 2006-03-28 | 2003-09-23 | Funakoshi | Teruyo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10453 | 10453 | 1997-03-29 | 1994-03-25 | Sawano | Hiroshi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10465 | 10465 | 2004-03-29 | 2001-09-04 | Ohsawa | Hiroshi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10473 | 10473 | 2010-03-29 | 2006-10-26 | Toriyama | Takayuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10506 | 10506 | 1979-03-30 | 1975-09-11 | Tamura | Tadao | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10566 | 10566 | 2000-03-30 | 1997-06-13 | Komatsu | Kyuhei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10579 | 10579 | 2005-03-30 | 2002-02-27 | Washio | Tomoharu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10603 | 10603 | 2011-03-30 | 2008-04-15 | Nakamura | Kyoichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10830 | 10830 | 1975-03-31 | 1969-03-04 | Oshikawa | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11098 | 11098 | 1995-03-31 | 1992-03-10 | Suzuki | Minoru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11186 | 11186 | 1999-03-31 | 1996-03-13 | Kobayashi | Yukio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11438 | 11438 | 2009-03-31 | 2006-10-26 | Akiyama | Kazuhiko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11439 | 11439 | 2009-03-31 | 2006-10-26 | Takahara | Yoshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11758 | 11758 | 1986-04-01 | 1982-09-13 | Yamamoto | Tadashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
12629 | 12629 | 1971-04-15 | 1970-03-13 | Nii | Izumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13033 | 13033 | 1990-04-20 | 1987-10-08 | Hamano | Michio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13082 | 13082 | 1985-04-21 | 1982-09-13 | Hara | Joji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13592 | 13592 | 2011-04-29 | 2010-03-22 | Hata | Masayuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13786 | 13786 | 1987-04-30 | 1984-09-06 | Yamazaki | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14286 | 14286 | 2016-04-30 | 2013-03-26 | Okui | Kohei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14480 | 14480 | 1977-05-01 | 1975-03-21 | Okamoto | Shosaku | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14721 | 14721 | 1984-05-03 | 1982-02-24 | Setoya | Hideo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14749 | 14749 | 1996-05-03 | 1993-09-13 | Kuwayama | Shinya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15322 | 15322 | 1987-05-13 | 1984-09-06 | Nakamura | Toshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15567 | 15567 | 1980-05-16 | 1976-09-17 | Nishikawa | Yoshiharu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15801 | 15801 | 1978-05-20 | 1975-03-21 | Hatakeyama | Noboru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15804 | 15804 | 1981-05-20 | 1978-03-03 | Otera | Nobuyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15805 | 15805 | 1981-05-20 | 1978-08-15 | Ogawa | Shuji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
16141 | 16141 | 2006-05-25 | 2001-09-04 | Baba | Keiji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
16312 | 16312 | 1974-05-28 | 1971-09-08 | Kaneko | Kiyotaka | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
17371 | 17371 | 1968-06-01 | 1966-03-04 | Suzuki | Ryohei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
17402 | 17402 | 1977-06-01 | 1975-03-21 | Hirono | Tadashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18049 | 18049 | 1986-06-09 | 1983-09-22 | Nagao | Masaaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18052 | 18052 | 1989-06-09 | 1986-10-17 | Yokoyama | Mitsuhiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18064 | 18064 | 2001-06-09 | 1997-09-17 | Nagahama | Yuji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18076 | 18076 | 1970-06-10 | 1967-03-03 | Matsumoto | Kei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18276 | 18276 | 1984-06-13 | 1982-02-24 | Kudo | Tomiyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18286 | 18286 | 1996-06-13 | 1993-09-13 | Motoshima | Naoki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18291 | 18291 | 1999-06-13 | 1996-09-12 | Yamashita | Ko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18386 | 18386 | 2004-06-14 | 2001-09-04 | Maejima | Akinari | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18389 | 18389 | 2010-06-14 | 2007-10-03 | Mino | Toshikatsu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18435 | 18435 | 1970-06-15 | 1968-11-05 | Fuldauer | Ivan | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18506 | 18506 | 1998-06-15 | 1995-09-18 | Oyama | Seiichiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18572 | 18572 | 1989-06-16 | 1987-04-06 | Machino | Kazumichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18643 | 18643 | 2011-06-16 | 2008-09-30 | Sumitani | Yasushi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18683 | 18683 | 1999-06-17 | 1996-09-12 | Kato | Tomohiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18718 | 18718 | 1990-06-18 | 1987-10-08 | Fujino | Tatsuo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18721 | 18721 | 1992-06-18 | 1989-08-29 | Yamane | Yoshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18729 | 18729 | 2003-06-18 | 2001-01-10 | Sano | Shun | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18741 | 18741 | 2019-06-18 | 2016-09-27 | Kasahara | Ken | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18748 | 18748 | 1974-06-19 | 1971-09-08 | Sakakura | Shogo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18790 | 18790 | 2015-06-19 | 2012-09-28 | Okano | Yusuke | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18840 | 18840 | 1998-06-20 | 1995-09-18 | Okubo | Tetsuo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18849 | 18849 | 2008-06-20 | 2005-10-05 | Yamauchi | Terunobu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18853 | 18853 | 2018-06-20 | 2015-09-29 | Takahashi | Takahiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18955 | 18955 | 2007-06-22 | 2004-08-31 | Yamakuchi | Junichiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
19152 | 19152 | 2005-06-25 | 2003-03-03 | Horiguchi | Hikaru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
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) );