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 1999-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41127 | 41127 | 1999-12-31 | 1999-03-02 | Bahny | Barbara | Trombone Associates, Inc. 4601 | 1991-12-06 | Trombone Associates, Inc. | 420 Madison Avenue | New York | NY | 10017 | |
41130 | 41130 | 1999-12-31 | 1999-03-26 | O'Dwyer | Brian | O'Dwyer, Brian 5308 | 1999-03-26 | O'Dwyer, Brian | 52 Duane Street | New York | NY | 10007 | |
41133 | 41133 | 1999-12-31 | 1998-04-20 | Buhler | Joseph E. | Alpine Tourist Office 2052 | 1967-09-27 | Alpine Tourist Office | C/O Austrian Tourist Office, Inc. | 608 Fifth Avenue | New York | NY | 10020 |
41134 | 41134 | 1999-12-31 | 1975-04-22 | Herman | Paula | Herman Associates, Inc. 2578 | 1975-04-22 | Herman Associates, Inc. | 360 Lexington Avenue | New York | NY | 10017 | |
41135 | 41135 | 1999-12-31 | 1975-04-22 | Herman | Stuart | Herman Associates, Inc. 2578 | 1975-04-22 | Herman Associates, Inc. | 360 Lexington Avenue | New York | NY | 10017 | |
41153 | 41153 | 1999-12-31 | 1999-08-20 | Buhler | Joseph E. | European Travel Commission 574 | 1949-06-30 | European Travel Commission | c/o Spring O'Brien | 30 West 26th Street, 4th Floor | New York | NY | 10010 |
41154 | 41154 | 1999-12-31 | 1993-08-24 | Buhler | Joseph E. | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
41159 | 41159 | 1999-12-31 | 1996-09-13 | Watts | Jessica | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41164 | 41164 | 1999-12-31 | 1990-10-09 | Hassenbein | Donald | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
41168 | 41168 | 1999-12-31 | 1996-10-30 | Eaton | Richard K. | Stroock & Stroock & Lavan 5141 | 1996-04-23 | Stroock & Stroock & Lavan | 180 Maiden Lane | New York | NY | 10038 -4982 | |
41170 | 41170 | 1999-12-31 | 1982-11-26 | Yee | Lawrence S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );