FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
192 rows where Registration_Number = 1850
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
558 | 558 | 2013-03-26 | Stevenson | Naoko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
567 | 567 | 2018-03-27 | Hashimoto | Tsubasa | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
591 | 591 | 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 | |
1508 | 1508 | 2018-09-25 | Kamimura | Makoto | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1509 | 1509 | 2018-09-25 | Ogawa | Yumeko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1520 | 1520 | 2016-09-27 | Kawachi | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
1546 | 1546 | 2019-09-30 | Fujimoto | Fujio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
3283 | 3283 | 1989-01-12 | 1986-10-17 | Suzuki | Akio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
4384 | 4384 | 2002-01-29 | 1998-10-01 | Take | Nobumasa | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5024 | 5024 | 2008-01-31 | 2004-08-31 | Sasaki | Teruo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5026 | 5026 | 2008-01-31 | 2006-10-26 | Soobratty | Ayumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5079 | 5079 | 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 |
5294 | 5294 | 1977-02-01 | 1975-03-21 | Kimba | Hirofumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
5420 | 5420 | 2006-02-01 | 2003-03-03 | Saito | Hidemi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
6187 | 6187 | 1999-02-11 | 1996-03-13 | Morita | Ikuhiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
7766 | 7766 | 2013-02-28 | 2012-03-30 | Florida | Tomoko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8127 | 8127 | 1967-03-01 | 1965-02-02 | Inui | Fumio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8131 | 8131 | 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 |
8586 | 8586 | 1971-03-05 | 1968-03-12 | Suzuki | Ken | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
8993 | 8993 | 1999-03-10 | 1996-03-13 | Monden | Takao | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9045 | 9045 | 1993-03-11 | 1989-08-29 | Hamada | Kazuaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9118 | 9118 | 1986-03-12 | 1983-09-22 | Hoshino | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9135 | 9135 | 1998-03-12 | 1995-09-18 | Watanabe | Hisanori | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9197 | 9197 | 2008-03-13 | 2005-10-05 | Tsuchiya | Takashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9334 | 9334 | 1981-03-15 | 1977-09-07 | Koyanagi | Takeaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9817 | 9817 | 1973-03-21 | 1969-03-04 | Izawa | Chihiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9893 | 9893 | 1980-03-22 | 1977-03-11 | Saito | Shinichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
9895 | 9895 | 1983-03-22 | 1981-01-23 | Nagata | Eiichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10091 | 10091 | 2000-03-24 | 1997-09-17 | Ishii | Yasumichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10140 | 10140 | 1994-03-25 | 1990-10-16 | Masuda | Koutaro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10141 | 10141 | 1994-03-25 | 1990-10-16 | Umezawa | Shigeyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10177 | 10177 | 1983-03-26 | 1981-01-23 | Tanaka | Sumio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10195 | 10195 | 1991-03-26 | 1988-10-25 | Ito | Tomoyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10205 | 10205 | 2003-03-26 | 2001-01-10 | Tomita | Tetsutaro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10257 | 10257 | 1988-03-27 | 1986-04-21 | Fujihara | Shiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10266 | 10266 | 1995-03-27 | 1992-09-10 | Hara | Noriyasu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10268 | 10268 | 2001-03-27 | 1998-10-15 | Ishii | Shigeru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10269 | 10269 | 2001-03-27 | 1998-10-15 | Wada | Aya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10275 | 10275 | 2004-03-27 | 2001-09-04 | Terahara | Yoshihito | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10281 | 10281 | 2009-03-27 | 2004-08-31 | Nakajo | Kazuya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10283 | 10283 | 2010-03-27 | 2008-09-30 | Takashi | Muneo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10348 | 10348 | 1996-03-28 | 1993-03-11 | Toyonaga | Yoshitaka | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10362 | 10362 | 2006-03-28 | 2003-09-23 | Funakoshi | Teruyo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10446 | 10446 | 1997-03-29 | 1994-03-25 | Sawano | Hiroshi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10458 | 10458 | 2004-03-29 | 2001-09-04 | Ohsawa | Hiroshi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10466 | 10466 | 2010-03-29 | 2006-10-26 | Toriyama | Takayuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10499 | 10499 | 1979-03-30 | 1975-09-11 | Tamura | Tadao | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10559 | 10559 | 2000-03-30 | 1997-06-13 | Komatsu | Kyuhei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10572 | 10572 | 2005-03-30 | 2002-02-27 | Washio | Tomoharu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10596 | 10596 | 2011-03-30 | 2008-04-15 | Nakamura | Kyoichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10823 | 10823 | 1975-03-31 | 1969-03-04 | Oshikawa | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11091 | 11091 | 1995-03-31 | 1992-03-10 | Suzuki | Minoru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11179 | 11179 | 1999-03-31 | 1996-03-13 | Kobayashi | Yukio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11431 | 11431 | 2009-03-31 | 2006-10-26 | Akiyama | Kazuhiko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11432 | 11432 | 2009-03-31 | 2006-10-26 | Takahara | Yoshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
11751 | 11751 | 1986-04-01 | 1982-09-13 | Yamamoto | Tadashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
12622 | 12622 | 1971-04-15 | 1970-03-13 | Nii | Izumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13027 | 13027 | 1990-04-20 | 1987-10-08 | Hamano | Michio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13076 | 13076 | 1985-04-21 | 1982-09-13 | Hara | Joji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13586 | 13586 | 2011-04-29 | 2010-03-22 | Hata | Masayuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
13780 | 13780 | 1987-04-30 | 1984-09-06 | Yamazaki | Akira | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14280 | 14280 | 2016-04-30 | 2013-03-26 | Okui | Kohei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14474 | 14474 | 1977-05-01 | 1975-03-21 | Okamoto | Shosaku | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14716 | 14716 | 1984-05-03 | 1982-02-24 | Setoya | Hideo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
14744 | 14744 | 1996-05-03 | 1993-09-13 | Kuwayama | Shinya | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15317 | 15317 | 1987-05-13 | 1984-09-06 | Nakamura | Toshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15562 | 15562 | 1980-05-16 | 1976-09-17 | Nishikawa | Yoshiharu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15796 | 15796 | 1978-05-20 | 1975-03-21 | Hatakeyama | Noboru | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15799 | 15799 | 1981-05-20 | 1978-03-03 | Otera | Nobuyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
15800 | 15800 | 1981-05-20 | 1978-08-15 | Ogawa | Shuji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
16136 | 16136 | 2006-05-25 | 2001-09-04 | Baba | Keiji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
16308 | 16308 | 1974-05-28 | 1971-09-08 | Kaneko | Kiyotaka | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
17367 | 17367 | 1968-06-01 | 1966-03-04 | Suzuki | Ryohei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
17398 | 17398 | 1977-06-01 | 1975-03-21 | Hirono | Tadashi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18045 | 18045 | 1986-06-09 | 1983-09-22 | Nagao | Masaaki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18048 | 18048 | 1989-06-09 | 1986-10-17 | Yokoyama | Mitsuhiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18060 | 18060 | 2001-06-09 | 1997-09-17 | Nagahama | Yuji | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18073 | 18073 | 1970-06-10 | 1967-03-03 | Matsumoto | Kei | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18274 | 18274 | 1984-06-13 | 1982-02-24 | Kudo | Tomiyuki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18284 | 18284 | 1996-06-13 | 1993-09-13 | Motoshima | Naoki | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18289 | 18289 | 1999-06-13 | 1996-09-12 | Yamashita | Ko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18384 | 18384 | 2004-06-14 | 2001-09-04 | Maejima | Akinari | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18387 | 18387 | 2010-06-14 | 2007-10-03 | Mino | Toshikatsu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18433 | 18433 | 1970-06-15 | 1968-11-05 | Fuldauer | Ivan | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18504 | 18504 | 1998-06-15 | 1995-09-18 | Oyama | Seiichiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18570 | 18570 | 1989-06-16 | 1987-04-06 | Machino | Kazumichi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18641 | 18641 | 2011-06-16 | 2008-09-30 | Sumitani | Yasushi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18681 | 18681 | 1999-06-17 | 1996-09-12 | Kato | Tomohiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18716 | 18716 | 1990-06-18 | 1987-10-08 | Fujino | Tatsuo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18719 | 18719 | 1992-06-18 | 1989-08-29 | Yamane | Yoshio | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18727 | 18727 | 2003-06-18 | 2001-01-10 | Sano | Shun | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18739 | 18739 | 2019-06-18 | 2016-09-27 | Kasahara | Ken | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18746 | 18746 | 1974-06-19 | 1971-09-08 | Sakakura | Shogo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18788 | 18788 | 2015-06-19 | 2012-09-28 | Okano | Yusuke | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18838 | 18838 | 1998-06-20 | 1995-09-18 | Okubo | Tetsuo | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18847 | 18847 | 2008-06-20 | 2005-10-05 | Yamauchi | Terunobu | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18851 | 18851 | 2018-06-20 | 2015-09-29 | Takahashi | Takahiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
18953 | 18953 | 2007-06-22 | 2004-08-31 | Yamakuchi | Junichiro | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
19150 | 19150 | 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) );