home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

25 rows where Registration_Number = 1601

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date)

State 1

  • NY 25

Registration_Number 1

  • Clinton E. Frank, Inc., New York · 25 ✖

Registrant_Name 1

  • Clinton E. Frank, Inc., New York 25

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

CSV options:

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])
);
Powered by Datasette · Queries took 680.382ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows