FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Last_Name = "Mori"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3544 | 3544 | 2019-01-10 | 2015-07-31 | Mori | Norikazu | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
10326 | 10326 | 2003-03-19 | 2001-05-11 | Mori | Shigeki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
14098 | 14098 | 1991-04-25 | 1988-08-16 | Mori | Shiro | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
16620 | 16620 | 1998-05-17 | 1995-07-28 | Mori | Takashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20332 | 20332 | 2018-06-26 | 2015-08-18 | Mori | Masahiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33684 | 33684 | 2012-10-26 | 2009-09-25 | Mori | Kotaro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36562 | 36562 | 1999-11-29 | 1996-09-12 | Mori | Norikazu | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
36654 | 36654 | 1983-11-30 | 1978-04-24 | Mori | Fumiko | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
40063 | 40063 | 1978-12-31 | 1977-01-25 | Mori | Fumiko | Runkle, Scott F. 2318 | 1972-02-16 | Runkle, Scott F. | 1128 - 16th Street, N.W. | Washington | DC | 20036 |
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]) );