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

22 rows where Registration_Number = 134

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 22

Registration_Number 1

  • Doremus & Company · 22 ✖

Registrant_Name 1

  • Doremus & Company 22

City 1

  • New York 22
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
22739 22739 1944-07-08 1943-05-11 Millar W. Howard Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
30461 30461 1944-09-26 1943-05-11 Dock George , Jr. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38191 38191 1944-12-13 1943-05-11 Burnham Walter H. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38192 38192 1944-12-13 1943-05-11 Holland Dewey B. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38193 38193 1944-12-13 1943-05-11 Isaacs Mark Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38194 38194 1944-12-13 1943-05-11 Kopp Edgar A. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38195 38195 1944-12-13 1943-05-11 Long William H. , Jr. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38196 38196 1944-12-13 1943-05-11 Miller George L. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38197 38197 1944-12-13 1943-05-11 Oren Earl M. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38198 38198 1944-12-13 1943-05-11 Reid William Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38199 38199 1944-12-13 1943-05-11 Renault J. Paul Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38200 38200 1944-12-13 1943-05-11 Williams Richard E. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38201 38201 1944-12-13 1944-05-23 Gahan Edwin F. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38202 38202 1944-12-13 1944-05-23 Greene Charles C. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38203 38203 1944-12-13 1943-11-06 Blumenthal Daniel L. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38204 38204 1944-12-13 1943-11-06 Broderick John P. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38205 38205 1944-12-13 1943-11-06 Lyon Irving W. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38206 38206 1944-12-13 1943-11-06 Miller John E. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38207 38207 1944-12-13 1943-11-06 Randall Murray W. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38208 38208 1944-12-13 1943-11-06 Tickner Reginald W. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38209 38209 1944-12-13 1944-12-13 Huntington Douglas E. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  
38210 38210 1944-12-13 1944-12-13 McNamara Daniel F. Doremus & Company 134 1942-10-05 Doremus & Company 120 Broadway   New York NY  

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