FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

17 rows where Registrant_Name = "John Moynahan & Associates"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Short_Form_First_Name

State 1

Registrant_Name 1

  • John Moynahan & Associates · 17 ✖

City 1

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
28730 28730 1955-09-01 1955-03-18 Moynahan John Francis John Moynahan & Associates 879 1955-03-18 John Moynahan & Associates 380 Madison Avenue   New York NY  
28731 28731 1955-09-01 1955-03-18 Ramsberger Jack F. John Moynahan & Associates 879 1955-03-18 John Moynahan & Associates 380 Madison Avenue   New York NY  
28732 28732 1955-09-01 1955-03-18 Reilly Arthur John Moynahan & Associates 879 1955-03-18 John Moynahan & Associates 380 Madison Avenue   New York NY  
28733 28733 1955-09-01 1955-03-18 Roberts Francis Vincent John Moynahan & Associates 879 1955-03-18 John Moynahan & Associates 380 Madison Avenue   New York NY  
28735 28735 1955-09-01 1955-06-09 Stein Julian Samuel , Jr. John Moynahan & Associates 879 1955-03-18 John Moynahan & Associates 380 Madison Avenue   New York NY  
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])
);