FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Last_Name = "Saito"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Date (date)
Registration_Number 9
Registrant_Name 9
City 7
- Chicago 5
- Los Angeles 4
- Washington 3
- Mayaguez 2
- Atlanta 1
- Houston 1
- San Francisco 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5833 | 5833 | 2006-02-01 | 2003-03-03 | Saito | Hidemi | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10502 | 10502 | 1980-03-22 | 1977-03-11 | Saito | Shinichi | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
10862 | 10862 | 1980-03-27 | 1977-07-19 | Saito | Itaru | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
11640 | 11640 | 1991-03-31 | 1989-05-22 | Saito | Seiro | JETRO, Puerto Rico 2468 | 1973-10-23 | JETRO, Puerto Rico | Calle Cruz #3 Urb. | Bellas Lomas, Miradero | Mayaguez | PR | 00708 |
14215 | 14215 | 2012-04-27 | 2009-06-09 | Saito | Manabu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
17478 | 17478 | 1996-05-30 | 1993-10-12 | Saito | Sadayuki | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
19515 | 19515 | 1974-06-15 | 1971-07-19 | Saito | Kazumi | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20096 | 20096 | 1991-06-23 | 1988-01-27 | Saito | Jiro | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
20451 | 20451 | 2000-06-28 | 1997-09-17 | Saito | Kazunori | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
20574 | 20574 | 2002-06-29 | 2000-04-05 | Saito | Masahiko | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
23661 | 23661 | 1990-07-20 | 1987-04-06 | Saito | Shinichi | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
25604 | 25604 | 1994-08-01 | 1991-03-19 | Saito | Tadashi | Japan Federation of Economic Organizations (Keidanren) 4487 | 1991-03-19 | Japan Federation of Economic Organizations (Keidanren) | 1000 Connecticut Avenue, N.W. | Suite 211 - (U.S. Rep. Office) | Washington | DC | 20036 |
25606 | 25606 | 1994-08-01 | 1990-07-23 | Saito | Tadashi | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
31222 | 31222 | 1999-09-30 | 1997-06-06 | Saito | Hajime | U.S. Representative Offices of the Japan Development Bank 5152 | 1997-01-21 | U.S. Representative Offices of the Japan Development Bank | 1101 - 17th Street, N.W. | Suite 1001 | Washington | DC | 20036 |
33467 | 33467 | 1975-10-23 | 1973-10-23 | Saito | Seiro | JETRO, Puerto Rico 2468 | 1973-10-23 | JETRO, Puerto Rico | Calle Cruz #3 Urb. | Bellas Lomas, Miradero | Mayaguez | PR | 00708 |
35579 | 35579 | 1983-11-10 | 1980-07-16 | Saito | Toshiki | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
38432 | 38432 | 2009-12-15 | 2006-08-01 | Saito | Takeshi | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
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]) );