Connecticut_warn_raw
Data source: Big Local News · About: big-local-datasette
9 rows where Closing = "Not Indicated"
This data as json, copyable, CSV (advanced)
Suggested facets: Location_ of_Layoffs, Date_of_Layoffs, Union
Link | rowid ▼ | WARN_Date | WARN_DATE_Received_processedbybln | Name_of_Affected Company * = layoffs due to the Coronavirus | Location_ of_Layoffs | Number_Affected_Workers | Date_of_Layoffs | Closing | Date_of_Closing | Union | Union Address |
---|---|---|---|---|---|---|---|---|---|---|---|
33 | 33 | 10/27/15 Rec'd 10/27/15 | 10/27/15 | Bristol-Myers Squibb | Wallingford | 78 | 12/31/15 - 3/1/16 | Not Indicated | No | ||
99 | 99 | 3/24/17 Rec'd 3/28/17 | 3/28/17 | Valley Tool & Manufacturing, Inc. | Orange | 65 | 6/2/17 | Not Indicated | 6/2/17 | No | International Association of Teamsters, Chauffeurs, Warehousemen and Helpers of America Local 67122 Britton Dr.Bloomfiled, CT 06002 |
129 | 129 | 11/17/17 Rec'd 11/20/17 | 11/20/17 | Conduent State Healthcare, LLC | East Hartford | 102 | 1/16/18 | Not Indicated | No | ||
133 | 133 | 12/29/17 Rec'd 12/29/17 | 12/29/17 | Towne Park at Yale-New Haven Hospital | New Haven | 195 | 2/28/18 | Not Indicated | No | ||
157 | 157 | 8/21/18 Rec'd 8/23/18 | 8/23/18 | Edible Arrangements, LLC | Wallingford | 125 | 12/31/18 | Not Indicated | No | ||
158 | 158 | 8/28/18 Rec'd 8/30/18 | 8/30/18 | Netsolace | Wallingford | 20 | 12/31/18 | Not Indicated | No | ||
183 | 183 | 7/15/19 Rec'd 7/19/19 | 7/19/19 | Vistra Energy (Norwalk) | Norwalk | 74 | 9/15/19 | Not Indicated | Not Indicated | ||
212 | 212 | 3/26/2020 Rec'd 3/26/2020 | 3/26/20 | Lecoq Cuisine Corp. | Bridgeport | 181 | 3/20/20 | Not Indicated | No | ||
213 | 213 | 3/27/2020 Rec'd 3/27/2020 | 3/27/20 | Mystic Seaport Museum, Inc. | Mystic | 199 | 4/1/20 | Not Indicated | No |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Connecticut_warn_raw] ( [WARN_Date] TEXT, [WARN_DATE_Received_processedbybln] TEXT, [Name_of_Affected Company * = layoffs due to the Coronavirus] TEXT, [Location_ of_Layoffs] TEXT, [Number_Affected_Workers] TEXT, [Date_of_Layoffs] TEXT, [Closing] TEXT, [Date_of_Closing] TEXT, [Union] TEXT, [Union Address] TEXT );