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

43 rows where Registration_Number = 1648

View and edit SQL

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

State

Registration_Number

  • 1648 · 43

Registrant_Name

City

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
3860 1965-01-19 1964-08-21 Scheffey Frank 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6022 1966-02-08 1965-02-26 McCormack Richard 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6379 1991-02-13 1974-02-25 Helfand Harriet 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6380 1991-02-13 1977-03-03 Glover Rose-Marie 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6381 1991-02-13 1972-03-21 Kritzler Edward 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6382 1991-02-13 1984-04-05 Knopfler Gail 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6383 1991-02-13 1984-04-05 Nichie Yvonne 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6384 1991-02-13 1973-08-20 Henriques Arnold Paul 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6385 1991-02-13 1970-08-26 Eisley Richard Steven 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
6386 1991-02-13 1982-08-26 Mailliard Corinne 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
7317 1973-02-27 1963-07-19 Underhill Harold Noble 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
9680 1982-03-19 1963-07-19 Sontheimer Morton 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
9881 1968-03-22 1964-07-09 Knapp Paul Edward 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
10154 1969-03-26 1963-07-19 Hazlett Richard Carlton 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
10768 1967-03-31 1966-08-22 Krokosky Dorothy Patricia 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
12577 1968-04-15 1968-02-15 Butler Thomas B. , Jr. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
14435 1985-05-01 1984-04-05 Schwartz Leonard 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
15766 1971-05-21 1971-02-19 Havas Anne M. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
16534 1970-05-31 1968-08-30 Mesney Peter M. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
19611 1972-06-30 1964-08-21 McManus Francis 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
19612 1972-06-30 1970-08-26 Nyren Edward A 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
21442 1968-07-09 1967-04-11 Kritzler Edward Heywood 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
21450 1968-07-09 1967-08-22 Krupinski Joseph 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
21498 1968-07-10 1967-08-22 Mahoney Jerome R. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
22170 1964-07-19 1963-07-19 Baumgartner Susan 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
22171 1964-07-19 1963-07-19 Callahan Rosellen 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
22560 1966-07-25 1963-07-19 Mellon Imogen 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
25551 1966-08-22 1966-02-08 Carder Clyde D. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
25817 1977-08-26 1977-03-03 Harrison Louis A. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
26216 1971-08-31 1970-08-26 Cummings William B. J. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
26217 1971-08-31 1970-08-26 Potts Jane C. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
27840 1970-09-11 1968-02-15 Fleur Marcie Anne La 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
28602 1976-09-24 1964-02-19 Hurst Virginia Radcliffe 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
29118 1968-09-30 1967-08-30 Haine Margaret 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
29165 1979-09-30 1974-08-23 Gillies Ewen 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
29187 1982-09-30 1977-03-03 Grode Robert 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
32094 1969-10-30 1967-08-22 Smith Ralston 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
32250 1977-10-31 1975-02-27 McArdle Rose Frances 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
32251 1977-10-31 1975-02-27 Seligsohn Joy 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
32252 1977-10-31 1977-03-03 Miller Mary Lynn 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
32255 1977-10-31 1976-08-20 Blum Charlotte F. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
33775 1977-11-15 1975-02-27 Full Jerome K. 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788
37847 1979-12-31 1972-03-21 Myers Janet 1648 1648 1963-07-19 Sontheimer Hazlett, Ltd. 275 Seventh Avenue   New York NY 100016788

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 · Query took 354.911ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history