FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "New York" and Short_Form_First_Name = "Akira"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13337 | 13337 | 2012-04-14 | 2009-05-15 | Imai | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20759 | 20759 | 1965-06-30 | 1962-04-18 | Noguchi | Akira | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
21277 | 21277 | 1997-06-30 | 1991-08-23 | Nakaya | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23766 | 23766 | 1969-07-22 | 1966-02-27 | Hirose | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
29646 | 29646 | 2006-09-12 | 2003-08-08 | Miura | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31525 | 31525 | 2011-09-30 | 2006-08-25 | Kajita | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
31775 | 31775 | 1959-10-01 | 1957-01-29 | Taketomi | Akira | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
36294 | 36294 | 1976-11-24 | 1974-08-27 | Kashiwagi | Akira | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
39831 | 39831 | 1966-12-31 | 1965-08-18 | Morikawa | Akira | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
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]) );