FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
41 rows where Address_1 = "401 North Michigan Avenue"
This data as json, CSV (advanced)
Suggested facets: Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7699 | 7699 | 1985-02-26 | 1982-11-15 | Ebisawa | Yo | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
7727 | 7727 | 1999-02-26 | 1986-04-01 | Zic | Claude | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
8742 | 8742 | 1982-03-01 | 1979-09-24 | Abe | Tsunehiko | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
16123 | 16123 | 1989-05-12 | 1985-08-26 | Yamaguchi | Mitsuo | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
16191 | 16191 | 1976-05-13 | 1975-09-24 | Ajiro | Norimasa | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
16593 | 16593 | 1985-05-17 | 1981-05-15 | Sato | Hiroyasu | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
16694 | 16694 | 1992-05-19 | 1989-07-25 | Miyazaki | Yoshihiro | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
16868 | 16868 | 1973-05-22 | 1972-07-03 | Takata | Shinya | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
17194 | 17194 | 1995-05-26 | 1992-08-14 | Morimoto | Masayuki | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
17240 | 17240 | 1998-05-27 | 1995-07-27 | Tanimoto | Atsunori | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
18747 | 18747 | 1980-06-03 | 1976-04-24 | Bartolucci | Massimo | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
19551 | 19551 | 1988-06-15 | 1985-08-26 | Yamanouchi | Tamotsu | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
20460 | 20460 | 2003-06-28 | 2002-02-05 | Fujiwara | Iichiro | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
20947 | 20947 | 1980-06-30 | 1980-01-21 | Pala | Gabriele | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
22216 | 22216 | 1992-07-01 | 1987-02-02 | Ruggeri | Ruggero | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
24091 | 24091 | 1993-07-26 | 1988-08-05 | Sato | Tetsuya | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
24092 | 24092 | 1993-07-26 | 1992-08-14 | Oyama | Naoyuki | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
24094 | 24094 | 1994-07-26 | 1990-03-05 | Ricci | Paolo | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
24095 | 24095 | 1994-07-26 | 1993-08-12 | Bonifazi | Sergio | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
24096 | 24096 | 1994-07-26 | 1993-08-12 | Winiarski | Stanislaw | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
24220 | 24220 | 2001-07-27 | 1999-02-04 | Iwatsuki | Masahiro | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
25015 | 25015 | 2003-07-31 | 2001-02-02 | Tsukamoto | Yasutake | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
25334 | 25334 | 2018-07-31 | 2017-10-17 | Chillemi | Mina Amendola | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
25482 | 25482 | 1972-08-01 | 1972-02-07 | Marroni | Carlo | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
25605 | 25605 | 1994-08-01 | 1993-05-19 | Ruzbasan | Debra Ann | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
25607 | 25607 | 1994-08-01 | 1993-07-26 | Nakazono | Masato | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
25966 | 25966 | 2018-08-04 | 2017-10-17 | Hardwick | Gina | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
28888 | 28888 | 1989-09-01 | 1986-04-01 | Davis | Margaret Smith | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
31001 | 31001 | 1987-09-30 | 1986-04-01 | Cacciotti | Vittorio | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
31816 | 31816 | 1972-10-01 | 1972-07-03 | Sakurada | Kaoru | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
32567 | 32567 | 1979-10-10 | 1968-06-07 | Maggi | Enrico | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
33026 | 33026 | 2000-10-16 | 1997-04-01 | Nagaoka | Takashi | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
34182 | 34182 | 1976-10-31 | 1973-02-08 | Sato | Tetsuya | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
35231 | 35231 | 1997-11-04 | 1993-03-03 | Salvatore | Giuseppe | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
35234 | 35234 | 2002-11-04 | 1998-02-03 | Lucchesi | Mario G. | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
37393 | 37393 | 1988-12-01 | 1988-02-12 | Roccella | Maria Teresa | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
37800 | 37800 | 1996-12-05 | 1993-07-26 | Sawada | Toshihiko | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
37867 | 37867 | 1980-12-07 | 1977-07-13 | Okada | Toyokazu | Japan National Tourist Organization, Chicago 2347 | 1972-07-03 | Japan National Tourist Organization, Chicago | 401 North Michigan Avenue | Suite 770 | Chicago | IL | 60611 |
39064 | 39064 | 1992-12-24 | 1988-02-12 | Gaetano | Pasquale | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
39859 | 39859 | 1967-12-31 | 1968-07-03 | Scala | Pasquale M. | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
40096 | 40096 | 1979-12-31 | 1974-05-22 | Labia | Leonardo | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
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]) );