newyork_warn_raw
Data source: Big Local News · About: big-local-datasette
1 row where Region = " Long Island Nassau /WDB Name"
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2785 | 2785 | 2783 | The Great Atlantic & Pacific Tea Company, Inc. (A&P) - Long Island, New York City, and Hudson Valley Regions | https://labor.ny.gov/app/warn/details.asp?id=5260 | 8/12/2015 | 2015-0057 -- 2015-0059 | Elyse Adler, Fred Danks & Stuart Goldberg | Potential Plant Closing | The Great Atlantic & Pacific Tea Company, Inc. (A&P) (Various locations on Long Island, New York City and Hudson Valley Region) (See below for affected store locations) | Yonkers /WDB Name: Yonkers / Region: Hudson Valley Rockland /WDB Name: Rockland / Region: Hudson Valley Orange / WIB: Orange / Region: Hudson Valley Ulster / WIB: Ulster / Region: Hudson Valley Westchester/Putnam /WDB Name: Westchester/Putnam / Region: Hudson Valley Sullivan /WDB Name: Sullivan / Region: Hudson Valley Dutchess /WDB Name: Dutchess / Region: Hudson Valley Suffolk | SUFFOLK | Long Island Nassau /WDB Name | Sheryl Schermer, VP, HR & Labor Relations | (201) 571-4018 | Grocery Store | 13,097 (total number affected for all sites in New York State) | 13,097 (total number affected for all sites in New York State) | 11/12/2015 – 11/26/2015 | 11/26/2015 | The company has filed a voluntary petition in the United States Bankruptcy Court for the Southern District of New York under Chapter 11 of the Bankruptcy Code. | ----- | 1199 SEIU and UFCW Local 338, 342, 454A, 1262, 1245 and 1500. | Potential 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 );