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

12 rows where Registration_Number = 1033

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date)

State 1

  • NY 12

Registration_Number 1

  • John Moynahan & Associates · 12 ✖

Registrant_Name 1

  • John Moynahan & Associates 12

City 1

  • New York 12
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
16359 16359 1962-05-15 1961-11-16 Major Ralph H. , Jr. John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33447 33447 1963-10-23 1963-04-10 Adams John Bucher John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33448 33448 1963-10-23 1963-04-10 Carr George Grant John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33449 33449 1963-10-23 1958-04-24 McTigue John Daniel John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33450 33450 1963-10-23 1957-06-06 Holcomb Blake R. John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33451 33451 1963-10-23 1957-06-06 Moynahan John Francis John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33452 33452 1963-10-23 1963-07-05 Dorsey Thomas Brookshier John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33453 33453 1963-10-23 1959-09-18 Carty Walter Vincent John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33454 33454 1963-10-23 1959-09-18 Phillips Merrill Cochran John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
33455 33455 1963-10-23 1959-09-18 Sullivan Donal Mark John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
36594 36594 1962-11-30 1957-06-06 Ramsberger Jack F. John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   New York NY 10017
39729 39729 1962-12-31 1958-03-18 Bahn Chester B. , Jr. John Moynahan & Associates 1033 1957-06-06 John Moynahan & Associates 155 East 44th Street   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 670.211ms · 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