FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "New York", Registrant_Name = "Doremus & Company", "Short_Form_Termination_Date" is on date 2018-08-31 and State = "NY"
This data as json, CSV (advanced)
State 1
- NY · 16 ✖
Registration_Number 1
Registrant_Name 1
- Doremus & Company · 16 ✖
City 1
- New York · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );