FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York", Registration_Number = 2319 and "Short_Form_Date" is on date 1977-03-24
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
State 1
- NY 15
Registration_Number 1
- Doremus & Company · 15 ✖
Registrant_Name 1
City 1
- New York · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
19642 | 19642 | 1978-06-16 | 1977-03-24 | Maskaleris | Dorothy | 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 | |
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 | |
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 |
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]) );