FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Yamada"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
Registrant_Name 10
City 6
- New York 5
- San Francisco 3
- Washington 2
- Houston 1
- Los Angeles 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6202 | 6202 | 2010-02-05 | 2004-10-19 | Yamada | Ryohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
7113 | 7113 | 1994-02-16 | 1989-12-22 | Yamada | Masayuki | Hitachi, Ltd. 3855 | 1986-07-18 | Hitachi, Ltd. | 1900 K Street, N.W. | Suite 800 | Washington | DC | 20006 |
10405 | 10405 | 2016-03-20 | 2015-10-30 | Yamada | Masayoshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
16649 | 16649 | 1986-05-18 | 1983-07-18 | Yamada | Masahito | JETRO, Los Angeles 1833 | 1964-12-14 | JETRO, Los Angeles | 777 South Figueroa Street | Suite 3750 | Los Angeles | CA | 90017-2513 |
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 |
19983 | 19983 | 2000-06-21 | 1999-04-27 | Yamada | Noriyasu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
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 |
28526 | 28526 | 2008-08-31 | 1984-12-06 | Yamada | T. Albert | Masaoka & Associates, Inc. 2521 | 1974-06-19 | Masaoka & Associates, Inc. | 1126 Sixteenth Street, NW | Suite 210 | Washington | DC | 20036-4823 |
29939 | 29939 | 1971-09-16 | 1970-02-16 | Yamada | Keizaburo | Japan Trade Promotion Office (JTPO) 1113 | 1958-02-06 | Japan Trade Promotion Office (JTPO) | 39 Broadway | New York | NY | 10006 | |
30458 | 30458 | 2014-09-25 | 2013-04-11 | Yamada | Shona | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
33250 | 33250 | 1992-10-20 | 1989-08-07 | Yamada | Hisashi | JETRO, Houston 2277 | 1971-09-20 | JETRO, Houston | 1221 McKinney Street | Suite 4141 | Houston | TX | 77010 |
33958 | 33958 | 1981-10-29 | 1973-07-02 | Yamada | Kotaro | Kobe Trade Information Office 2438 | 1973-07-02 | Kobe Trade Information Office | 1001 Fourth Avenue | Suite 4310 | Seattle | WA | 98154 |
35166 | 35166 | 1992-11-03 | 1992-04-30 | Yamada | Yukio | NHK Cosmomedia America, Inc. 4490 | 1991-03-26 | NHK Cosmomedia America, Inc. | 100 Broadway | 15th Floor | New York | NY | 10005-1983 |
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]) );