FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
36 rows where Address_1 = "230 Park Avenue"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3216 | 3216 | 1971-01-05 | 1960-04-25 | Bial | Louis Charles | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
3217 | 3217 | 1972-01-05 | 1972-04-03 | Sutton | Leonard V.B. | Nierenberg, Zeif & Weinstein 2303 | 1972-01-12 | Nierenberg, Zeif & Weinstein | 230 Park Avenue | New York | NY | 10017 | |
3761 | 3761 | 1975-01-15 | 1972-01-28 | Jordan | Thomas R. | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
3762 | 3762 | 1975-01-15 | 1972-01-28 | Phillips | Harry S. | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
3763 | 3763 | 1975-01-15 | 1972-01-28 | Underwood | R. Donald | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
3767 | 3767 | 1975-01-15 | 1973-04-09 | Abrams | Joel M. | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
3769 | 3769 | 1975-01-15 | 1974-12-06 | Connor | Hugh F. | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
4671 | 4671 | 1974-01-28 | 1972-01-28 | Curry | Donald C. | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
8711 | 8711 | 1973-03-01 | 1972-01-17 | Lagarde | Henry W. , Jr. | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
8712 | 8712 | 1973-03-01 | 1973-03-02 | Noonan | Daniel | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
9147 | 9147 | 1973-03-05 | 1972-02-10 | Finn | A. Michael | Rosecoe & Finn, Inc. 2313 | 1972-02-10 | Rosecoe & Finn, Inc. | 230 Park Avenue | New York | NY | 10017 | |
9148 | 9148 | 1973-03-05 | 1972-02-10 | Roscoe | Gerald | Rosecoe & Finn, Inc. 2313 | 1972-02-10 | Rosecoe & Finn, Inc. | 230 Park Avenue | New York | NY | 10017 | |
11774 | 11774 | 1997-03-31 | 1996-09-17 | Hearle | Douglas G. | Douglas G. Hearle & Company, Inc. 5131 | 1996-09-17 | Douglas G. Hearle & Company, Inc. | 230 Park Avenue | New York | NY | 10169 | |
13846 | 13846 | 1982-04-21 | 1981-02-05 | Castelli | Octavio Abarca | PROCHILE 3109 | 1980-06-03 | PROCHILE | 230 Park Avenue | Suite 1430 | New York | NY | 10169 |
13847 | 13847 | 1982-04-21 | 1981-02-05 | Mora | Renato P. | PROCHILE 3109 | 1980-06-03 | PROCHILE | 230 Park Avenue | Suite 1430 | New York | NY | 10169 |
13848 | 13848 | 1982-04-21 | 1980-06-03 | Flisfisch | B. Raquel | PROCHILE 3109 | 1980-06-03 | PROCHILE | 230 Park Avenue | Suite 1430 | New York | NY | 10169 |
13849 | 13849 | 1982-04-21 | 1980-06-03 | Labra | Manuel B. | PROCHILE 3109 | 1980-06-03 | PROCHILE | 230 Park Avenue | Suite 1430 | New York | NY | 10169 |
14496 | 14496 | 1974-04-30 | 1972-01-28 | Lenci | Margaret Zellers | Underwood, Jordan Associates, Inc. 2361 | 1972-07-28 | Underwood, Jordan Associates, Inc. | 230 Park Avenue | New York | NY | 10017 | |
16742 | 16742 | 1971-05-20 | 1963-10-23 | Krupsak | Mary Ann | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
16743 | 16743 | 1971-05-20 | 1965-12-20 | Jones | Richard Peoples | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
17342 | 17342 | 1974-05-29 | 1963-07-02 | Shotkin | Isaiah Frederick | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
17619 | 17619 | 1973-05-31 | 1972-01-17 | Beaumont | Evelyn T. | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
22099 | 22099 | 1973-07-01 | 1972-01-17 | Berger | Frederick G. | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
22100 | 22100 | 1973-07-01 | 1972-01-17 | Olson | Martha A. | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
22105 | 22105 | 1973-07-01 | 1973-11-07 | Ievers | Carolyn | Berger, Olson & Beaumont, Inc. 2306 | 1972-01-17 | Berger, Olson & Beaumont, Inc. | 230 Park Avenue | New York | NY | 10017 | |
33985 | 33985 | 2017-10-29 | 2018-04-25 | Caiola | Matthew | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 230 Park Avenue | 32nd Floor | New York | NY | 10169 |
33986 | 33986 | 2017-10-29 | 2018-04-25 | Ford | Robert | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 230 Park Avenue | 32nd Floor | New York | NY | 10169 |
33987 | 33987 | 2017-10-29 | 2018-04-25 | Koulermos | Nicholas | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 230 Park Avenue | 32nd Floor | New York | NY | 10169 |
33988 | 33988 | 2017-10-29 | 2018-04-25 | Menken | Greg | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 230 Park Avenue | 32nd Floor | New York | NY | 10169 |
33989 | 33989 | 2017-10-29 | 2017-05-25 | Torossian | Ronn | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 230 Park Avenue | 32nd Floor | New York | NY | 10169 |
35261 | 35261 | 1972-11-05 | 1972-01-12 | Nierenberg | Gerard I. | Nierenberg, Zeif & Weinstein 2303 | 1972-01-12 | Nierenberg, Zeif & Weinstein | 230 Park Avenue | New York | NY | 10017 | |
35262 | 35262 | 1972-11-05 | 1972-01-12 | Zeif | Richard A. | Nierenberg, Zeif & Weinstein 2303 | 1972-01-12 | Nierenberg, Zeif & Weinstein | 230 Park Avenue | New York | NY | 10017 | |
36146 | 36146 | 1976-11-21 | 1960-03-22 | Slater | Carl | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
36147 | 36147 | 1976-11-21 | 1971-05-20 | Ganzglass | Martin R. | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
36148 | 36148 | 1976-11-21 | 1963-10-23 | King | Eugene George | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 | |
36149 | 36149 | 1976-11-21 | 1947-11-21 | Delson | Robert | Delson & Gordon 502 | 1947-11-21 | Delson & Gordon | 230 Park Avenue | New York | NY | 10017 |
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]) );