Connecticut_warn_raw
Data source: Big Local News · About: big-local-datasette
8 rows where Closing = "Yes - temporary"
This data as json, copyable, CSV (advanced)
Suggested facets: WARN_Date, WARN_DATE_Received_processedbybln, Location_ of_Layoffs, Number_Affected_Workers, Date_of_Layoffs, Date_of_Closing
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
221 | 221 | 3/31/2020 Rec'd 4/1/2020 | 4/1/20 | Panera Bread (Farmington)* | Lisbon, Mashantucket, Bristol, Farmington, Hartford, West Hartford | 116 | 3/16/20 | Yes - temporary | 3/16/20 | ||
222 | 222 | 3/31/2020 Rec'd 4/1/2020 | 4/1/20 | Panera Bread (Hartford)* | Lisbon, Mashantucket, Bristol, Farmington, Hartford, West Hartford | 116 | 3/16/20 | Yes - temporary | 3/16/20 | ||
223 | 223 | 3/31/2020 Rec'd 4/1/2020 | 4/1/20 | Panera Bread (Lisbon)* | Lisbon, Mashantucket, Bristol, Farmington, Hartford, West Hartford | 116 | 3/16/20 | Yes - temporary | 3/16/20 | ||
224 | 224 | 3/31/2020 Rec'd 4/1/2020 | 4/1/20 | Panera Bread (Mashantucket)* | Lisbon, Mashantucket, Bristol, Farmington, Hartford, West Hartford | 116 | 3/16/20 | Yes - temporary | 3/16/20 | ||
225 | 225 | 3/31/2020 Rec'd 4/1/2020 | 4/1/20 | Panera Bread (West Hartford)* | Lisbon, Mashantucket, Bristol, Farmington, Hartford, West Hartford | 116 | 3/16/20 | Yes - temporary | 3/16/20 | ||
228 | 228 | 3/31/2020 Rec'd 4/3/2020 | 4/3/20 | Primark* | Danbury | 116 | 4/1/20 | Yes - temporary | 4/1/20 | No | |
232 | 232 | 3/25/2020 Rec'd 4/6/2020 | 4/6/20 | Mayflower Inn Spa* | Washington | 98 | 3/25/2020 - 3/28/2020 | Yes - temporary | 3/25/20 | No | |
234 | 234 | 4/1/2020 Rec'd 4/7/2020 | 4/7/20 | Barteca dba Bartaco* | Westport, West Harford, Stamford | 190 | 3/21/20 | Yes - temporary | 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 );