FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
44 rows where Address_1 = "666 Third Avenue"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_2, Short_Form_Termination_Date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
21154 | 21154 | 1991-06-30 | 1991-06-03 | Dorf | Robert | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24511 | 24511 | 1992-07-30 | 1992-01-29 | Ludwig | Judith | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24512 | 24512 | 1992-07-30 | 1992-01-29 | Schacter | Howard | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24513 | 24513 | 1992-07-30 | 1991-06-03 | Carberry | Michael G. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24514 | 24514 | 1992-07-30 | 1991-06-03 | Cowan | Warren J. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24515 | 24515 | 1992-07-30 | 1991-06-03 | Devaney | Frank | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24516 | 24516 | 1992-07-30 | 1991-06-03 | Kaplan | Larry A. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24518 | 24518 | 1992-07-30 | 1991-12-26 | Carliner | Kathryn | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24519 | 24519 | 1992-07-30 | 1991-12-26 | Davis | Jennifer | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24520 | 24520 | 1992-07-30 | 1991-12-26 | Jacobson | Scott M. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24521 | 24521 | 1992-07-30 | 1991-12-26 | Jernstedt | Richard D. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
24522 | 24522 | 1992-07-30 | 1991-12-26 | Philippides | Daphne | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | 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 | |
35330 | 35330 | 1991-11-06 | 1991-06-03 | Beck | Elizabeth B. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
35331 | 35331 | 1991-11-06 | 1991-06-03 | Chamberlin | Amy Beth | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
35332 | 35332 | 1991-11-06 | 1991-06-03 | Kip | Donald W. , Jr. Jr. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
35333 | 35333 | 1991-11-06 | 1991-06-03 | Kravitz | Steven | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
35334 | 35334 | 1991-11-06 | 1991-06-03 | Pomerantz | Sharon | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | New York | NY | 10017 |
35335 | 35335 | 1991-11-06 | 1991-06-03 | Walsh | Elizabeth A. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | 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 | |
36751 | 36751 | 1991-11-30 | 1991-12-26 | Walsh | David B. | Shandwick North America, Inc. 4521 | 1991-06-03 | Shandwick North America, Inc. | 666 Third Avenue | 2nd Floor | 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]) );