FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1994-12-31
This data as json, CSV (advanced)
Suggested facets: Address_1, Short_Form_Termination_Date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40770 | 40770 | 1994-12-31 | 1980-01-21 | McNally | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40773 | 40773 | 1994-12-31 | 1976-03-22 | Kendellen | Nicholas L. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40780 | 40780 | 1994-12-31 | 1980-03-28 | Barnum | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40781 | 40781 | 1994-12-31 | 1980-03-28 | Moskin | Morton | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40788 | 40788 | 1994-12-31 | 1988-06-14 | Chinitz | Zelig | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | 633 Third Avenue | 21st Floor | New York | NY | 10017 |
40794 | 40794 | 1994-12-31 | 1993-10-05 | Zoller | Kurt | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
40802 | 40802 | 1994-12-31 | 1991-12-05 | Caron | Benoit | French Film Office/Unifrance USA 2358 | 1972-07-20 | French Film Office/Unifrance USA | 972 Fifth Avenue | New York | NY | 10075 | |
40804 | 40804 | 1994-12-31 | 1990-12-27 | Conn | Ruth Green | Conn Communications 4454 | 1990-12-27 | Conn Communications | 33 West 95th Street | New York | NY | 10025-6753 | |
40805 | 40805 | 1994-12-31 | 1990-12-27 | Conn | Stephen R. | Conn Communications 4454 | 1990-12-27 | Conn Communications | 33 West 95th Street | New York | NY | 10025-6753 | |
40806 | 40806 | 1994-12-31 | 1990-12-27 | Grossinger | Tania | Conn Communications 4454 | 1990-12-27 | Conn Communications | 33 West 95th Street | New York | NY | 10025-6753 |
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]) );