FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Address_1 = "666 Fifth Avenue"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7053 | 7053 | 1970-02-16 | 1968-04-02 | Bronson | Howard C. | Bronhill Associates, Inc. 2085 | 1968-04-02 | Bronhill Associates, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
7054 | 7054 | 1970-02-16 | 1968-04-02 | Hill | William F. | Bronhill Associates, Inc. 2085 | 1968-04-02 | Bronhill Associates, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11454 | 11454 | 1976-03-31 | 1976-02-11 | Falkenberg | Howard D. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11455 | 11455 | 1976-03-31 | 1976-02-11 | Spelce | William Bennett | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11457 | 11457 | 1976-03-31 | 1975-09-12 | Cummings | Constance P. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11458 | 11458 | 1976-03-31 | 1975-09-12 | Manning | Farley | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11459 | 11459 | 1976-03-31 | 1975-09-12 | Pearsall | William H. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11460 | 11460 | 1976-03-31 | 1975-09-12 | Rainey | Jean O. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11461 | 11461 | 1976-03-31 | 1975-09-12 | Rainey | John L. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11462 | 11462 | 1976-03-31 | 1975-09-12 | Schwartz | Robert N. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11463 | 11463 | 1976-03-31 | 1975-09-12 | Theil | Leon | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11464 | 11464 | 1976-03-31 | 1975-09-12 | Wark | Eleanor Ney | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11465 | 11465 | 1976-03-31 | 1975-09-12 | Zebrowski | Jeanne | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11467 | 11467 | 1976-03-31 | 1975-10-02 | Kraus | Herbert M. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
11468 | 11468 | 1976-03-31 | 1975-10-02 | Newman | Nancy B. | Manning, Selvage & Lee, Inc. 2605 | 1975-09-12 | Manning, Selvage & Lee, Inc. | 666 Fifth Avenue | New York | NY | 10019 | |
21195 | 21195 | 1993-06-30 | 1992-11-05 | Kelly | Brendan J. | International Communications Marketing, Inc. (ICM) 4733 | 1992-11-05 | International Communications Marketing, Inc. (ICM) | 666 Fifth Avenue | New York | NY | 10103 | |
21196 | 21196 | 1993-06-30 | 1992-11-05 | Van de Bovenkamp | Gerrit P. | International Communications Marketing, Inc. (ICM) 4733 | 1992-11-05 | International Communications Marketing, Inc. (ICM) | 666 Fifth Avenue | New York | NY | 10103 |
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]) );