FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "New York", Registration_Number = 5872, "Short_Form_Termination_Date" is on date 2014-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
State 1
- NY · 9 ✖
Registration_Number 1
- Spring O'Brien & Company, Inc. · 9 ✖
Registrant_Name 1
City 1
- New York · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41897 | 41897 | 2014-12-31 | 2013-01-28 | Knobloch | Leslie | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41900 | 41900 | 2014-12-31 | 2012-01-30 | Reisfeld | Jennifer | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41902 | 41902 | 2014-12-31 | 2014-01-30 | Cady | Lydia | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41903 | 41903 | 2014-12-31 | 2014-01-30 | Holland | Martha | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41904 | 41904 | 2014-12-31 | 2015-01-30 | Si | Fan | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41905 | 41905 | 2014-12-31 | 2011-01-31 | Vibert | Megan | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41959 | 41959 | 2014-12-31 | 2014-08-05 | Krusemann | Jil | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41978 | 41978 | 2014-12-31 | 2008-10-10 | Kaufman | Lauren | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
41979 | 41979 | 2014-12-31 | 2008-10-10 | Spring | Chris | Spring O'Brien & Company, Inc. 5872 | 2008-06-30 | Spring O'Brien & Company, Inc. | 20 W 22nd Street | Suite 906 | New York | NY | 10010 |
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]) );