FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where State = "CA" and Zip = "94109-5455"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9244 | 9244 | 1996-03-06 | 1991-08-05 | Fujimoto | Akemi | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
9626 | 9626 | 1983-03-11 | 1979-04-27 | Yamakawa | Ryuji | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
10452 | 10452 | 1991-03-21 | 1989-01-31 | Sato | Hiroyasu | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
11981 | 11981 | 2006-03-31 | 2004-06-24 | Takizawa | Hidenao | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
16389 | 16389 | 1983-05-15 | 1980-10-16 | Koyanagi | Terumasa | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
17219 | 17219 | 1975-05-27 | 1972-07-03 | Yamada | Takahide | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
18465 | 18465 | 1987-06-01 | 1983-08-17 | Yamashita | Tetsuro | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
18666 | 18666 | 1995-06-02 | 1992-07-28 | Kobori | Akio | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
18914 | 18914 | 1996-06-05 | 1993-07-21 | Igarashi | Kazumi | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
19111 | 19111 | 1992-06-09 | 1990-07-27 | Aochi | Toshihiro | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
19756 | 19756 | 1990-06-17 | 1988-02-04 | Ishizaka | Yukio | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
20389 | 20389 | 1999-06-27 | 1996-04-16 | Kawaguchi | Eriko | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
20450 | 20450 | 1999-06-28 | 1996-07-12 | Hara | Yoshinobu | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
22643 | 22643 | 1997-07-06 | 1994-07-14 | Hashimoto | Hiroyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
22651 | 22651 | 2003-07-06 | 2002-03-28 | Nakatsuka | Hidenori | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
22763 | 22763 | 1991-07-08 | 1989-01-31 | Ikushima | Fumiaki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
23124 | 23124 | 1994-07-14 | 1991-08-05 | Hirashima | Akihide | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
23649 | 23649 | 1978-07-20 | 1975-03-31 | Hara | Yoshitaka | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
23737 | 23737 | 1993-07-21 | 1990-07-27 | Chino | Yasuyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
23768 | 23768 | 1974-07-22 | 1972-07-03 | Yabuki | Yasuyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
24025 | 24025 | 2000-07-25 | 1998-02-19 | Yano | Hiroyuki | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
25634 | 25634 | 2002-08-01 | 1999-08-03 | Sampei | Fumihiro | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
27260 | 27260 | 1988-08-23 | 1983-08-17 | Narisada | Katsuhiko | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
27517 | 27517 | 1988-08-27 | 1986-08-14 | Yamada | Keiji | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
29665 | 29665 | 1978-09-13 | 1976-05-04 | Suzuki | Hisashi | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
32502 | 32502 | 1985-10-09 | 1983-08-17 | Takashima | Susumu | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
32628 | 32628 | 1976-10-11 | 1974-04-17 | Soma | Minoru | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
33024 | 33024 | 1998-10-16 | 1995-09-01 | Nagawa | Susumu | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
35445 | 35445 | 2001-11-08 | 1999-08-03 | Aida | Kazuhiko | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
36361 | 36361 | 1979-11-25 | 1977-07-13 | Kaneko | Fumio | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
37826 | 37826 | 1973-12-06 | 1972-07-03 | Soejima | Osamu | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
39133 | 39133 | 2004-12-26 | 2002-03-28 | Taniuchi | Takuo | Japan National Tourist Organization, San Francisco 2349 | 1972-07-03 | Japan National Tourist Organization, San Francisco | One Daniel Burnham Court | Suite 250 C | San Francisco | CA | 94109-5455 |
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]) );