Connecticut_warn_raw
Data source: Big Local News · About: big-local-datasette
1 row where Closing = "Yes (Kaman Composites CT Business Unit)"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
120 | 120 | 9/6/17 Rec'd 9/7/17 | 9/7/17 | Kaman Aerospace/Kaman Composites CT | Bloomfield | 40 | Beginning 11/6/17 | Yes (Kaman Composites CT Business Unit) | Not provided | 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 );