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

22 rows where City = "New York", Registrant_Name = "Doremus & Company" and Registration_Number = 6387

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

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
7488 7488 2018-02-23 2017-09-14 Quan Renee Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
16686 16686 2018-05-18 2017-09-14 Abueva Jerone Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28636 28636 2018-08-31 2018-05-09 Bine David Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28637 28637 2018-08-31 2018-05-09 Eselevsky Hayley Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28638 28638 2018-08-31 2018-05-09 Haimes Deborah Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28639 28639 2018-08-31 2018-05-09 Jones Jeff Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28640 28640 2018-08-31 2018-05-09 Patterson Camille Palo Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28645 28645 2018-08-31 2017-09-14 Don Matthew Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28646 28646 2018-08-31 2017-09-14 Garrett Stuart Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28647 28647 2018-08-31 2017-09-14 Katz Phillip Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28648 28648 2018-08-31 2017-09-14 Mitchell Catherine Downes Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28649 28649 2018-08-31 2017-09-14 Pathiyil Amy J. Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28650 28650 2018-08-31 2017-09-14 Peplov Artem Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28651 28651 2018-08-31 2017-09-14 Rakos Patricia Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28652 28652 2018-08-31 2017-09-14 Tellup Michael Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28653 28653 2018-08-31 2017-09-14 Waldner Robert Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28654 28654 2018-08-31 2017-09-14 Williams Kali Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
28655 28655 2018-08-31 2017-09-14 Zahir Mike Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
29781 29781 2018-09-14 2017-09-14 Buchan Debbie Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
30245 30245 2018-09-21 2017-09-14 Kunze Amanda Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
33442 33442 2018-10-22 2017-09-14 Becker David C. Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022
38851 38851 2017-12-20 2017-09-14 Hisler Rebecca Doremus & Company 6387 2016-10-28 Doremus & Company 437 Madison Avenue 5th Floor New York NY 10022

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])
);