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

59 rows where Registration_Number = 1814

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)

State 1

  • NY 59

Registration_Number 1

  • Association Films, Inc. · 59 ✖

Registrant_Name 1

  • Association Films, Inc. 59

City 1

  • New York 59
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
4917 4917 1966-01-31 1965-08-10 Mogel Gretta Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
7873 7873 1975-02-28 1973-08-08 Imlach Robert Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
8716 8716 1973-03-01 1971-06-04 Samuelsen Gene Howard Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
9007 9007 1972-03-03 1968-05-07 Clark Ivan Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
10367 10367 1969-03-20 1967-08-07 Cotsis Renate Elizabeth Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
10787 10787 1976-03-26 1973-08-08 Troy William J. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
12624 12624 1974-04-02 1973-08-14 Basquiat Gerard Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
14483 14483 1972-04-30 1970-03-02 Adams Donald E. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
14503 14503 1975-04-30 1973-08-14 Brown Donald Paul Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
17602 17602 1967-05-31 1964-11-06 Barwick John Hershey Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
22943 22943 1968-07-11 1964-11-06 Bingham John Raymond Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
22944 22944 1968-07-11 1964-11-06 Bucher Robert Walter Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
22945 22945 1968-07-11 1964-11-06 Finehout Robert Milton Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
22946 22946 1968-07-11 1964-11-06 Joseph David Arthur Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
22947 22947 1968-07-11 1964-11-06 Miesegaes William Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
24680 24680 1974-07-31 1973-08-14 Smith Raymond M. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
24690 24690 1977-07-31 1973-08-14 Mitchell Robert D. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
26243 26243 1973-08-08 1968-05-07 Imlach Robert Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
26244 26244 1973-08-08 1968-05-07 Siler Winston O. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
26245 26245 1973-08-08 1971-06-04 Schweizer William C. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
26580 26580 1973-08-14 1970-03-02 O'Brien Eileen Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
26586 26586 1973-08-14 1964-11-06 Mitchell Robert Douglas Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28016 28016 1981-08-31 1976-01-20 Mahan Stephen J. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28018 28018 1981-08-31 1977-03-01 Botthof Kendrick Lance Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28020 28020 1981-08-31 1976-04-13 Farnsworth Bruce F. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28021 28021 1981-08-31 1976-04-13 Sathern Donald Scott Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28022 28022 1981-08-31 1975-05-13 Shumway William A. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28023 28023 1981-08-31 1975-05-13 Wagasky Loretta V. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28025 28025 1981-08-31 1975-06-25 Lauffer William R. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28026 28026 1981-08-31 1973-08-08 Fly William Owen Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28027 28027 1981-08-31 1973-08-08 Ring Kenneth A. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28028 28028 1981-08-31 1973-08-08 Saeugling Dorothy Eileen Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28029 28029 1981-08-31 1973-08-08 Schweizer William C. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28030 28030 1981-08-31 1973-08-08 Smith Shirley D. (Mr.) Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28031 28031 1981-08-31 1975-08-11 Smith Henry E. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28032 28032 1981-08-31 1973-08-14 Bucher Robert W. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28033 28033 1981-08-31 1973-08-14 Cahaney G. R. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28034 28034 1981-08-31 1973-08-14 Capuzzi Vincent J. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28035 28035 1981-08-31 1973-08-14 Hansen Frances F. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28036 28036 1981-08-31 1973-08-14 Lutz Ernst G. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28037 28037 1981-08-31 1973-08-14 Shumway, Jr. William H. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28038 28038 1981-08-31 1973-08-14 Wholey Tim Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28043 28043 1981-08-31 1973-09-06 Atwood Edward C. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28044 28044 1981-08-31 1973-09-06 Farnsworth Bruce F. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28045 28045 1981-08-31 1973-09-06 Wolf Frank Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28046 28046 1981-08-31 1973-09-24 Watts Gene Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28047 28047 1981-08-31 1973-09-25 Sathern Donald Scott Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28048 28048 1981-08-31 1974-10-31 McGowan Patrick Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28049 28049 1981-08-31 1964-11-06 Evans Reginald Stratford Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
28051 28051 1981-08-31 1973-11-23 Finehout Robert M. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
34170 34170 1970-10-31 1968-05-07 Liebich Joseph R. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
34179 34179 1974-10-31 1973-08-14 O'Brien Eileen Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
34180 34180 1974-10-31 1973-09-24 McLaughlin Arthur Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
34211 34211 1980-10-31 1973-08-08 Bryant C. Edgar Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
36637 36637 1977-11-30 1973-08-08 Siler Winston O. Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
38784 38784 1973-12-20 1964-11-06 Fredrick Alfred Lewis Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
38785 38785 1973-12-20 1964-12-21 Levine Gretta Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
38788 38788 1976-12-20 1964-11-06 Kahn Malcolm Buddy Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison Avenue   New York NY 10017
40042 40042 1977-12-31 1973-08-14 Brussaly Ophelia Association Films, Inc. 1814 1964-11-06 Association Films, Inc. 347 Madison 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 769.64ms · 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