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 = 1553

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Termination_Date (date)

State 1

  • NY 19

Registration_Number 1

  • Casey, Lane & Mittendorf · 19 ✖

Registrant_Name 1

  • Casey, Lane & Mittendorf 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
2541 2541 1967-01-01 1962-07-24 Casey James Joseph Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
9806 9806 1969-03-14 1967-06-13 Smith Edmund Chetwynd Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
10580 10580 1976-03-23 1976-03-15 Woody Robert J. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
10581 10581 1976-03-23 1976-03-23 McAnaney Edward G. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
17610 17610 1970-05-31 1969-06-25 Joyce William R. , Jr. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
18816 18816 1970-06-04 1969-04-08 Ludlum Stuart D. , Jr. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
19223 19223 1971-06-11 1964-12-21 Wentzel Alan R. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
19637 19637 1967-06-16 1966-02-07 Pritchett Mebane Moore Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
22429 22429 1972-07-02 1971-03-18 McGonagle John Joseph , Jr. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
26250 26250 1978-08-08 1977-02-02 Kelsey Alan R. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
26251 26251 1978-08-08 1964-05-08 McGrath John William , III Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
26252 26252 1978-08-08 1962-07-02 Mahoney John Regan Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
26253 26253 1978-08-08 1973-09-04 Mahoney John Regan Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
27462 27462 1976-08-26 1970-04-22 McKnight Philip R. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
30300 30300 1974-09-23 1962-07-02 Orlin David Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
32839 32839 1976-10-15 1971-03-18 Taliaferro Henry B. , Jr. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
32840 32840 1976-10-15 1972-08-31 Cinnamond William G. Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
34837 34837 1969-11-01 1968-08-07 Lloyd Boardman Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004
39794 39794 1965-12-31 1964-12-21 Sweet Robert Workman Casey, Lane & Mittendorf 1553 1962-07-02 Casey, Lane & Mittendorf 26 Broadway   New York NY 10004

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