FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Yoshida"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 7
- New York 3
- New York 2
- Chicago 1
- Dallas 1
- Denver 1
- New Orleans 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1723 | 1723 | 2019-09-05 | Yoshida | Natsue | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
9116 | 9116 | 1982-03-04 | 1979-10-01 | Yoshida | Toshi | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
15714 | 15714 | 2000-05-04 | 1997-09-19 | Yoshida | Takashi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
17365 | 17365 | 2004-05-29 | 2001-07-10 | Yoshida | Masahiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
19273 | 19273 | 1970-06-12 | 1968-02-02 | Yoshida | Masahiko | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
20396 | 20396 | 2003-06-27 | 2000-07-19 | Yoshida | Akiko | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
22624 | 22624 | 1973-07-06 | 1970-02-12 | Yoshida | Kazuto | Japan Broadcasting Corporation 820 | 1954-03-15 | Japan Broadcasting Corporation | 1 Rockefeller Plaza | Room 1430 | New York | NY | 10020 |
30760 | 30760 | 2003-09-29 | 2001-01-10 | Yoshida | Shigeo | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
34183 | 34183 | 1976-10-31 | 1974-03-25 | Yoshida | Takeshi | Japan Trade Center, New Orleans 2309 | 1972-01-25 | Japan Trade Center, New Orleans | 1447 International Trade Mart | Building | New Orleans | LA | 70130 |
41616 | 41616 | 2008-12-31 | 2008-03-05 | Yoshida | Laura | Hyde Park Communications, Inc. 5854 | 2008-02-22 | Hyde Park Communications, Inc. | 1101 17th Street, NW | Suite 508 | 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]) );