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

31 rows where Registration_Number = 1468

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date

These facets timed out: Registrant_Name

State 1

  • NY 31

Registration_Number 1

  • Geyer & Oswald, Inc. · 31 ✖

City 1

  • New York 31
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
8449 8449 1968-02-29 1965-06-14 Link Gerald Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
8652 8652 1966-03-01 1965-06-14 Fell Norma Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
10423 10423 1969-03-21 1967-08-28 Paine Walter Robert Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
11394 11394 1965-03-31 1965-03-01 Stanley Mack Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
13361 13361 1965-04-15 1965-03-01 Flanagan Frederic Fionn Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
14445 14445 1964-04-30 1961-08-01 Tery Joseph Albert Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
17593 17593 1963-05-31 1962-08-23 Daly John Corry Wilson Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
22671 22671 1965-07-07 1961-08-01 Davidson DeWitt Sanger Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
24291 24291 1965-07-28 1961-08-01 Kaiser Gustav Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
24653 24653 1967-07-31 1966-03-03 Schraffenberger David Louis Jerome Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
26905 26905 1961-08-18 1961-08-01 Larner William Clifford Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
27093 27093 1967-08-21 1966-08-25 Wassmer John Stuart Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30036 30036 1967-09-19 1965-03-01 Malone Martin J. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30644 30644 1966-09-28 1961-08-01 McHugh John T. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30844 30844 1963-09-30 1961-08-11 Bandy Eugene Franklin , Jr. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30857 30857 1965-09-30 1965-06-14 Quinn Cornelius John Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30858 30858 1965-09-30 1965-06-14 Trazenfeld William Milton Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
30887 30887 1969-09-30 1966-03-03 Viverito Joseph Aloysius , Jr. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
32622 32622 1968-10-11 1968-03-15 Monahan Michael Jeffrey Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
34160 34160 1968-10-31 1968-09-05 Carter Paul Stephen Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
35790 35790 1965-11-15 1965-09-14 Haynes Patricia Ellen Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39239 39239 1970-12-28 1966-03-03 Hetrick Frederick Glen Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39240 39240 1970-12-28 1969-03-14 McGovern Charles J. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39241 39241 1970-12-28 1968-03-15 Hein Dennis R. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39242 39242 1970-12-28 1961-08-16 Mason Thomas Francis Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39243 39243 1970-12-28 1966-08-25 Schettino Patricia Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39244 39244 1970-12-28 1967-08-28 Howser McKenzie Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39245 39245 1970-12-28 1969-09-02 Kelleher Kerry L. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39246 39246 1970-12-28 1969-09-02 Tully Paul R. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39247 39247 1970-12-28 1965-11-10 Mauer Raymond John Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022
39753 39753 1963-12-31 1963-02-28 Welborn Marion E. Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. 555 Madison Avenue   New York NY 10022

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 2097.523ms · 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