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

96 rows where City = "New York", Registration_Number = 2319 and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY · 96 ✖

Registration_Number 1

  • Doremus & Company · 96 ✖

Registrant_Name 1

  • Doremus & Company 96

City 1

  • New York · 96 ✖
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
3056 3056 1985-01-02 1981-07-15 Rosenberg Gail A. E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
3643 3643 1978-01-13 1976-07-12 Usher Donald L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
4963 4963 1979-01-31 1977-03-24 Hoar Kathleen M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
4969 4969 1980-01-31 1978-02-14 Lawson James Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
4988 4988 1983-01-31 1976-07-12 Fischer George L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
4993 4993 1984-01-31 1972-02-18 Shankland Elmer M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
5728 5728 1981-02-01 1976-07-12 Garrick Robert M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
6926 6926 1980-02-15 1977-03-24 Kessler Leon M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
7197 7197 1977-02-18 1975-04-11 Fearon Robert A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
8727 8727 1978-03-01 1978-02-14 Price Arnold M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
10509 10509 1985-03-22 1975-04-11 Roth Stephen A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
12824 12824 1981-04-06 1977-03-24 Young Robert A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
12870 12870 1981-04-07 1978-10-31 Miller Christopher L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13166 13166 1980-04-11 1979-01-16 Jones Samuel L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13284 13284 1984-04-13 1983-10-28 Rossie Gregory M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13308 13308 1980-04-14 1977-03-24 O'Neill Brian Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13396 13396 1983-04-15 1977-03-24 Crossin Louis J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13619 13619 1981-04-17 1980-12-09 Bray Roger Peter , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
13950 13950 1982-04-23 1976-07-12 Summers Herbert Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
14498 14498 1974-04-30 1973-09-21 Gehle Ernest C. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
14517 14517 1979-04-30 1978-04-10 Rees J. David Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
14520 14520 1979-04-30 1976-09-21 Kelley Sheila Seymour Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
14522 14522 1980-04-30 1977-04-08 Codus William Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
14541 14541 1984-04-30 1975-04-11 Malley Francis J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
15841 15841 1982-05-07 1978-02-14 Enloe David H. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
18430 18430 1978-06-01 1978-01-04 Flynn Joseph P. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
18433 18433 1979-06-01 1978-01-12 Sonderegger David M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
19043 19043 1983-06-08 1980-04-09 Coplin Robert A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
19045 19045 1984-06-08 1978-09-29 Chafetz Anita Lynn Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
19642 19642 1978-06-16 1977-03-24 Maskaleris Dorothy Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
20942 20942 1979-06-30 1976-10-20 Khal Helen Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
20978 20978 1982-06-30 1978-02-14 Imhoff Howard C. , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
20981 20981 1982-06-30 1981-03-25 McSherry Donald T. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
21038 21038 1985-06-30 1975-04-11 Pucie Charles R. , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
22627 22627 1982-07-06 1982-01-26 Larmett John C. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
23224 23224 1983-07-15 1978-02-14 Sievers Phillip C. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
24483 24483 1982-07-30 1977-03-24 Johnson Gary Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
24740 24740 1985-07-31 1977-03-24 Brion John Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
26155 26155 1981-08-07 1981-03-23 Husband John D. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
26157 26157 1981-08-07 1978-09-29 Hubbard John Merrill , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
26697 26697 1980-08-15 1976-07-23 Frimann Rolf Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
28012 28012 1980-08-31 1975-04-11 Horton John E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
28056 28056 1982-08-31 1976-07-12 Beardsley Harrison T. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
29821 29821 1984-09-15 1975-04-11 Burke Eugene F. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30494 30494 1985-09-26 1978-01-04 Duome Joseph J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30495 30495 1985-09-26 1978-01-30 Cromer Harry Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30496 30496 1985-09-26 1978-01-30 McDonald Jack H. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30497 30497 1985-09-26 1978-01-30 McDonald James P. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30498 30498 1985-09-26 1978-02-07 Gillespie Rodger W. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30499 30499 1985-09-26 1978-02-14 Wakeman Robin E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30500 30500 1985-09-26 1972-02-18 McMennamin G. Barry Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30501 30501 1985-09-26 1972-02-18 Truesdell Wesley E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30502 30502 1985-09-26 1978-03-01 Shane Corinne Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30503 30503 1985-09-26 1985-03-12 Goodfader Alan L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30504 30504 1985-09-26 1977-03-24 Allen Patricia Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30505 30505 1985-09-26 1977-03-24 Bardsley Joseph F. , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30506 30506 1985-09-26 1977-03-24 Fitzgerald Gerald L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30507 30507 1985-09-26 1977-03-24 Gialleonardo Victor Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30508 30508 1985-09-26 1977-03-24 Guinther Fred E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30509 30509 1985-09-26 1977-03-24 Nunzio Paula Del Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30510 30510 1985-09-26 1978-03-27 Wiener Walter F. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30511 30511 1985-09-26 1976-03-29 Carlin James J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30512 30512 1985-09-26 1975-04-11 Carroll James P. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30513 30513 1985-09-26 1975-04-11 Schaffer Franklin E. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30514 30514 1985-09-26 1975-04-18 Henry John C. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30515 30515 1985-09-26 1977-04-18 Sheils Marylou Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30516 30516 1985-09-26 1981-04-29 Pomerantz Joel Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30517 30517 1985-09-26 1982-05-15 Pitman Theodore B. , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30523 30523 1985-09-26 1978-07-11 Monfort Don L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30524 30524 1985-09-26 1978-07-11 Pratt David Thomas Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30525 30525 1985-09-26 1976-07-12 Ekren Parker Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30526 30526 1985-09-26 1976-07-23 Collier Norma J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30527 30527 1985-09-26 1976-07-23 Salvaryn Dennis Lee Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30528 30528 1985-09-26 1982-07-26 Martin Yolanda C. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30529 30529 1985-09-26 1976-09-15 O'Connell John W. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30530 30530 1985-09-26 1974-09-19 Quinby Alan R. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30531 30531 1985-09-26 1984-10-02 Trujillo Tony Albert , Jr. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30532 30532 1985-09-26 1978-10-20 Howells Elizabeth J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
30533 30533 1985-09-26 1980-12-16 Gordon Arnold B. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
32668 32668 1984-10-12 1984-01-27 Canter Nan A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
33057 33057 1980-10-17 1978-10-31 Wells William S. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
34051 34051 1981-10-30 1976-07-12 DuPeza Gustav V. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
34189 34189 1977-10-31 1976-07-23 Morris Dennis M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
34192 34192 1977-10-31 1974-09-19 Muir J. Duncan Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
34223 34223 1982-10-31 1978-01-12 Braman Donald W. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
34244 34244 1984-10-31 1981-03-25 Millman Ronald B. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
35654 35654 1982-11-12 1982-11-12 Weinberger James M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
36638 36638 1978-11-30 1977-03-24 Cromwell Sharon K. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
36655 36655 1983-11-30 1981-04-29 Deitsch Thomas A. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40058 40058 1978-12-31 1978-01-04 Rubenstein Murray Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40071 40071 1978-12-31 1975-04-11 Farrell Thomas M. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40076 40076 1978-12-31 1976-07-12 Fisher Robert J. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40078 40078 1978-12-31 1976-09-21 Clarke Edward V. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40097 40097 1979-12-31 1978-06-16 Todd David L. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40098 40098 1979-12-31 1976-06-17 Bowen John S. Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
40126 40126 1980-12-31 1978-03-17 Bishop Louis F. , III Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271

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