FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Short_Form_Termination_Date" is on date 1986-05-31
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17693 | 17693 | 1986-05-31 | 1982-01-06 | Yit | Geoffrey Lim Boon | Singapore Trade Development Board 2979 | 1978-11-27 | Singapore Trade Development Board | 350 South Figueroa Street | Suite 264 | Los Angeles | CA | 90071 |
17694 | 17694 | 1986-05-31 | 1985-01-07 | Sato | Mitsuaki | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17695 | 17695 | 1986-05-31 | 1983-01-24 | Solovykh | Dmitry A. | Amtorg Trading Corporation 596 | 1949-11-07 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 |
17696 | 17696 | 1986-05-31 | 1985-02-06 | Hong | Jungpyo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
17697 | 17697 | 1986-05-31 | 1966-03-14 | Josephs | Jay Raphael (Ray) | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 352 Park Avenue, South | Suite 705 | New York | NY | 10010 |
17698 | 17698 | 1986-05-31 | 1980-03-28 | Ramseur | Thomas M. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17699 | 17699 | 1986-05-31 | 1986-04-09 | Ruster | Jeff | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
17700 | 17700 | 1986-05-31 | 1983-04-29 | Mizutani | Shiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
17701 | 17701 | 1986-05-31 | 1977-06-01 | Wynn | Ralph K. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
17702 | 17702 | 1986-05-31 | 1982-06-21 | deMercado | George Wilfred | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
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]) );