FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Registration_Number = 1601 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Date (date)
State 1
- NY · 25 ✖
Registration_Number 1
- Clinton E. Frank, Inc., New York · 25 ✖
Registrant_Name 1
City 1
- New York 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7578 | 7578 | 1966-02-25 | 1964-01-21 | Colton | Wendell Phillps , Jr. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
9685 | 9685 | 1964-03-12 | 1963-02-25 | McCarthy | Callaghan James , Jr. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
10364 | 10364 | 1964-03-20 | 1963-02-25 | Amory | Charles M. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
27859 | 27859 | 1966-08-31 | 1964-01-22 | Eastright | Robert Earl | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
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]) );