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

19 rows where Registration_Number = 1677

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

  • NY 19

Registration_Number 1

  • Gotham-Vladimir Advertising, Inc. · 19 ✖

Registrant_Name 1

  • Gotham-Vladimir Advertising, Inc. 19

City 1

  • New York 19
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
5919 5919 1967-02-02 1964-01-03 Beyea Archibald Lester Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5920 5920 1967-02-02 1964-01-03 Choate Rufus Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5921 5921 1967-02-02 1964-01-03 Hansen Arnold Christian Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5922 5922 1967-02-02 1964-01-03 Hildebrant Walter G. Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5923 5923 1967-02-02 1964-01-03 Hobbs Richard Hutchinson Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5924 5924 1967-02-02 1964-01-03 Kaufherr Daniel Clinton Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5925 5925 1967-02-02 1964-01-03 Kron Arthur Adam Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5926 5926 1967-02-02 1964-01-03 Pecorini Lillian Allen Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5927 5927 1967-02-02 1964-01-03 Priest Chester A. Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5928 5928 1967-02-02 1964-01-03 Ricigliano William V. Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5929 5929 1967-02-02 1964-01-03 Rourke Cornelius G. Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5930 5930 1967-02-02 1964-01-03 Vladimir Irwin Alfred Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5933 5933 1967-02-02 1965-08-03 Novak Frank Walter Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5934 5934 1967-02-02 1964-08-11 Caporaso Frank Adolph Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5935 5935 1967-02-02 1964-08-11 Glass James Lowell Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5936 5936 1967-02-02 1964-08-11 Oliver Anthony Thomas Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5937 5937 1967-02-02 1964-08-11 Ricigliano Robert Joseph Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5938 5938 1967-02-02 1964-08-11 Stark Margaret Eleanor Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 Madison Avenue   New York NY 10017
5939 5939 1967-02-02 1965-09-10 Pedersen Ruth Mildred Gotham-Vladimir Advertising, Inc. 1677 1964-01-03 Gotham-Vladimir Advertising, Inc. 342 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 303.135ms · 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