FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Registrant_Name = "Clinton E. Frank, Inc., New York" and Registration_Number = 1601
This data as json, CSV (advanced)
State 1
- NY 21
Registration_Number 1
- Clinton E. Frank, Inc., New York · 21 ✖
Registrant_Name 1
- Clinton E. Frank, Inc., New York · 21 ✖
City 1
- New York 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30846 | 30846 | 1964-09-30 | 1964-01-22 | Green | David Paul | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33529 | 33529 | 1968-10-24 | 1964-01-21 | Kreischer | Benno Walter | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33530 | 33530 | 1968-10-24 | 1964-01-21 | McDonald | William John | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33531 | 33531 | 1968-10-24 | 1964-01-21 | Mossman | Alexander Hyde | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33532 | 33532 | 1968-10-24 | 1964-01-22 | Brown | Kenneth Richard | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33533 | 33533 | 1968-10-24 | 1964-01-22 | McGrath | George E. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33534 | 33534 | 1968-10-24 | 1963-02-25 | Castells | Jose Rodolfo | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33535 | 33535 | 1968-10-24 | 1963-02-25 | Davis | Enoch D. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33536 | 33536 | 1968-10-24 | 1964-03-30 | Hubbard | Thomas Bassett | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33537 | 33537 | 1968-10-24 | 1966-03-31 | Davidson | De Witt S. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33538 | 33538 | 1968-10-24 | 1965-04-01 | Markel | Edward | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33539 | 33539 | 1968-10-24 | 1967-08-02 | Rathkopf | Clifford A. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33540 | 33540 | 1968-10-24 | 1965-10-01 | Anderson | James Alexander Douglas | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33541 | 33541 | 1968-10-24 | 1965-10-01 | Roboz | George T. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33542 | 33542 | 1968-10-24 | 1964-10-12 | Tery | Joseph A. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33543 | 33543 | 1968-10-24 | 1964-10-12 | Wilson | Graham Barrow | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33544 | 33544 | 1968-10-24 | 1966-11-09 | Swick | Thomas Ford | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
35136 | 35136 | 1963-11-03 | 1963-09-30 | Cornwell | Anthony Ewart Frank | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
36598 | 36598 | 1964-11-30 | 1964-10-12 | Jones | Geoffrey Montgomery Talbot | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
36605 | 36605 | 1967-11-30 | 1967-08-02 | Hammon | James | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
38776 | 38776 | 1964-12-20 | 1964-03-30 | Jacobson | David J. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third 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]) );