FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Termination_Date" is on date 1972-06-30 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20843 | 20843 | 1972-06-30 | 1972-01-18 | Belasco | Claire E. | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
20844 | 20844 | 1972-06-30 | 1969-01-22 | Egli | Gody | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
20845 | 20845 | 1972-06-30 | 1968-04-11 | Lewis | Joseph Barton | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
20846 | 20846 | 1972-06-30 | 1964-06-09 | Canning | Daniel Fayerweather | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
20847 | 20847 | 1972-06-30 | 1964-06-09 | Celliers | Peter Joubert | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
20848 | 20848 | 1972-06-30 | 1964-06-09 | Silverman | Ernest | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
20850 | 20850 | 1972-06-30 | 1964-08-21 | McManus | Francis | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | 275 Seventh Avenue | New York | NY | 100016788 | |
20851 | 20851 | 1972-06-30 | 1970-08-26 | Nyren | Edward A | Sontheimer Hazlett, Ltd. 1648 | 1963-07-19 | Sontheimer Hazlett, Ltd. | 275 Seventh Avenue | New York | NY | 100016788 | |
20854 | 20854 | 1972-06-30 | 1968-10-21 | Jokilehto | Kari Berndt | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | 655 Third Avenue | Suite 1810 | New York | NY | 10017-5617 |
20855 | 20855 | 1972-06-30 | 1968-10-21 | Jokilehto | Maj-Britt Linnea | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | 655 Third Avenue | Suite 1810 | New York | NY | 10017-5617 |
20857 | 20857 | 1972-06-30 | 1967-11-14 | Maisons | Jacques | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 | |
20858 | 20858 | 1972-06-30 | 1964-11-20 | Hicks | Rita | Tribune Films, Inc. 1810 | 1964-10-29 | Tribune Films, Inc. | 55 West 14th Street | Suite 8D | New York | NY | 10011 |
20859 | 20859 | 1972-06-30 | 1965-12-14 | Kass | Philip S. | Cannon Advertising Associates, Inc. 1945 | 1965-12-14 | Cannon Advertising Associates, Inc. | 444 Madison Avenue | Suite 301 | New York | NY | 10022 |
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]) );