FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 2000-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41175 | 41175 | 2000-12-31 | 1984-01-06 | Leong | Constance Cecilia | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
41177 | 41177 | 2000-12-31 | 1996-02-12 | Hagiwara | Hisayo | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | 516 Fifth Avenue | Suite 801 | New York | NY | 10036 |
41178 | 41178 | 2000-12-31 | 1999-02-23 | Palladino | Amy | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
41181 | 41181 | 2000-12-31 | 1995-03-02 | Tedeschi | Anthony M. | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | 420 Madison Avenue | New York | NY | 10017 | |
41182 | 41182 | 2000-12-31 | 2000-03-02 | Fodor-Gernaert | Odette M. | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | 420 Madison Avenue | New York | NY | 10017 | |
41183 | 41183 | 2000-12-31 | 1977-03-09 | Hurlock | James B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41185 | 41185 | 2000-12-31 | 1998-04-20 | Neuhold | Erich | Alpine Tourist Office 2052 | 1967-09-27 | Alpine Tourist Office | C/O Austrian Tourist Office, Inc. | 608 Fifth Avenue | New York | NY | 10020 |
41190 | 41190 | 2000-12-31 | 1996-06-24 | Sise | Peyton | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41196 | 41196 | 2000-12-31 | 1982-10-08 | Erickson | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41202 | 41202 | 2000-12-31 | 1999-11-22 | Delage | Gisele | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
41204 | 41204 | 2000-12-31 | 1983-12-02 | Mone | Larry | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
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]) );