FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Registration_Number = 2347 and State = "IL" sorted by Short_Form_Last_Name
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Registration_Date (date)
Short_Form_Date (date) 18 ✖
- 1972-07-03 2
- 1985-08-26 2
- 1992-08-14 2
- 1993-07-26 2
- 1973-02-08 1
- 1975-09-24 1
- 1977-07-13 1
- 1979-09-24 1
- 1981-05-15 1
- 1982-11-15 1
- 1988-08-05 1
- 1989-07-25 1
- 1993-05-19 1
- 1995-07-27 1
- 1997-04-01 1
- 1999-02-04 1
- 2001-02-02 1
- 2002-02-05 1
State 1
- IL · 22 ✖
Registration_Number 1
- Japan National Tourist Organization, Chicago · 22 ✖
Registrant_Name 1
City 1
- Chicago 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]) );