FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Date" is on date 1999-04-27
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9411 | 9411 | 2001-03-07 | 1999-04-27 | Goto | Hideyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10624 | 10624 | 2000-03-23 | 1999-04-27 | Morii | Motonao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
10699 | 10699 | 2000-03-24 | 1999-04-27 | Usuzawa | Tsutomu | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
13101 | 13101 | 2000-04-10 | 1999-04-27 | Okuyama | Hiromi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
14282 | 14282 | 2002-04-28 | 1999-04-27 | Takahashi | Hideyuki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17304 | 17304 | 2001-05-28 | 1999-04-27 | Sonoda | Toshihiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
18994 | 18994 | 2000-06-06 | 1999-04-27 | Evans | Terry | Ev Clay Associates, Inc. 5309 | 1999-04-27 | Ev Clay Associates, Inc. | 6161 Blue Lagoon Drive | Suite 270 | Miami | FL | 33126 |
19119 | 19119 | 2001-06-09 | 1999-04-27 | Nishiyama | Hidehiko | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
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 |
20570 | 20570 | 2001-06-29 | 1999-04-27 | Ito | Hitoshi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
20571 | 20571 | 2001-06-29 | 1999-04-27 | Yoshikawa | Hisashi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22648 | 22648 | 2001-07-06 | 1999-04-27 | Yatani | Kohei | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
22973 | 22973 | 2001-07-11 | 1999-04-27 | Murayama | Yutaka | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
23623 | 23623 | 2001-07-19 | 1999-04-27 | Watanabe | Hidenao | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27794 | 27794 | 2002-08-30 | 1999-04-27 | Kimura | Yoichi | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
34498 | 34498 | 2003-10-31 | 1999-04-27 | Clay | Dana L. | Ev Clay Associates, Inc. 5309 | 1999-04-27 | Ev Clay Associates, Inc. | 6161 Blue Lagoon Drive | Suite 270 | Miami | FL | 33126 |
36231 | 36231 | 2000-11-22 | 1999-04-27 | Matsumoto | Tetsuya | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
38055 | 38055 | 2003-12-10 | 1999-04-27 | Jenkins | Kempton B. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
38955 | 38955 | 2001-12-22 | 1999-04-27 | Maeda | Shigeki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
41305 | 41305 | 2003-12-31 | 1999-04-27 | Louison | Deborah | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
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]) );