newyork_warn_raw
Data source: Big Local News · About: big-local-datasette
1 row where Region = " New York CityMonroe "
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | notice_title | URL | Date of Notice | Event Number | Rapid Response Specialist | Reason Stated for Filing | Company | County | WDB Name | Region | Contact | Phone | Business Type | Number Affected | Total Employees | Layoff Date | Closing Date | Reason for Dislocation | FEIN NUM | Union | Classification | Amended | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2392 | 2392 | 2390 | Pepper Hamilton LLP - New York City and Finger Lakes Region | https://labor.ny.gov/app/warn/details.asp?id=7059 | 1/14/2020 | 2019-0230 | Stuart Goldberg and Regenna Darrah | Plant Closing | Pepper Hamilton LLP620 Eighth Avenue, 37th Floor New York, NY 10018 | New York | Finger Lakes | New York CityMonroe | Margaret A. Suender, Chief Talent Officer | (215) 981-4657 | Law Firm | 51 | 51 | 3/31/2020 - All Pepper Hamilton employees will be terminated from the Firm on 3/31/2020 and automatically become employees of Troutman Pepper on 4/1/2020. At some time thereafter, Pepper Hamilton will cease to exist. | To be determined | Merger with Troutman Sanders and to become known as Troutman Pepper. | 23-1433012 | The employees are not represented by a union. | Plant Closing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [newyork_warn_raw] ( [] INTEGER, [notice_title] TEXT, [URL] TEXT, [Date of Notice] TEXT, [Event Number] TEXT, [Rapid Response Specialist] TEXT, [Reason Stated for Filing] TEXT, [Company] TEXT, [County] TEXT, [WDB Name] TEXT, [Region] TEXT, [Contact] TEXT, [Phone] TEXT, [Business Type] TEXT, [Number Affected] TEXT, [Total Employees] TEXT, [Layoff Date] TEXT, [Closing Date] TEXT, [Reason for Dislocation] TEXT, [FEIN NUM] TEXT, [Union] TEXT, [Classification] TEXT, [Amended] TEXT );