Big Local News is collecting and updating WARN (layoff/furlough) notices from state government sites and is processing the data to make it more useable. So far, we are collecting and updating daily or weekly data from 36 states. A federal law -- the WARN Act (Worker Adjustment and Retraining Notification Act) requires companies with more than 100 employees to give 60 days notice of any layoff, closure or furlough and 17 states have their own similar statutes. This data provides much more granularity into the types of jobs being lost and the companies that are furloughing workers, or that plan to close completely. A key note is that "unforeseen business circumstances" can mean that a company doesn't have to provide 60 days notice. For example, California has lifted that level of notice for its state version, or mini-WARN Act. Nonetheless, even though the advance time limit is flexible, companies still have to submit. Please cite the WARN data as collected by Big Local News. California data can be cited as collected and processed by Stanford journalism student Vanessa Ochavillo. This project includes a general README, a more specific README for California and a more specific file layout README that details the fields by state. Some states are missing but we are working to obtain the data or build scrapers. If you are interested in contributing, please let us know at biglocalnews@stanford.edu.

Data source: Big Local News · About: big-local-datasette

53 rows

View and edit SQL

Suggested facets: Location

Link rowid ▼ Company Location Date Employees Affected
1 Remington Outdoor Company Sturgis 11/11/2020 5
2 Sheraton Sioux Falls 05/13/2020 140
3 EROS Sioux Falls /Garretson 04/23/2020 400
4 Bloomin' Brands Inc. (Outback Steakhouse) Sioux Falls 04/27/2020 70
5 Visionworks Sioux Falls 04/04/2020 8
6 PBM Packaging Inc. (RR Donnelley) Howard 03/04/2020 56
7 Littlelfuse Inc. Rapid City 02/25/2020 125
8 MetaBank Brookings, Sioux Falls 11/20/2019 74
9 Covington Care and Rehabilitation Center Sioux Falls 05/31/2019 90
10 Mobridge Care and Rehabilitation Center Mobridge 11/28/2018 67
11 TCF Bank Sioux Falls 09/05/2018 145
12 Ditech Rapid City 08/17/2018 39
13 Younkers (Bonton) Sioux Falls 06/05/2018 158
14 Wells Fargo & Co. Aberdeen 03/27/2018 108
15 Molded Fiber Glass Companies Aberdeen 02/15/2018 409
16 Bimbo Bakeries Sioux Falls 09/08/2017 58
17 Buhler Salem 03/09/2016 63
18 Nash Finch Company Rapid City 02/03/2015 49
19 Wyndham Hotel Group Aberdeen 09/09/2015 241
20 Asurion Rapid City 11/04/2014 227
21 Capital One Sioux Falls 06/24/2014 750
22 Minnesota Rubber & Plastic   (Quadion LLC) Watertown 11/15/2013 171
23 Raven - Aerostar Huron 09/20/2013 75
24 Sargento North Sioux City 07/29/2013 39
25 Communication Services for the Deaf, Inc. Sioux Falls 04/22/2013 43
26 Stream Global Services, Inc. Vermillion 08/22/2012 180
27 Verifications Aberdeen 05/07/2012 73
28 Verifications Mitchell 05/07/2012 75
29 Hostess Brands Sioux Falls 05/04/2012 10
30 Wells Fargo Aberdeen 02/02/2012 66
31 Bosselman Travel Center Rapid City 01/5/2012 30
32 Rockwell Collins, Inc. Ellsworth Air Force Base 10/24/2011 8
33 Alamo Group (SMC) Sioux Falls 10/20/2011 76
34 Premier Bankcard Spearfish 05/23/2011 335
35 Communication Services for the Deaf (CSD) Sioux Falls 03/29/2010 79
36 Verety LLC South Dakota 03/19/2010 1-5
37 Terex Load King Elk Point 12/03/2009 73
38 Terex Load King Elk Point 08/24/2009 10
39 Coventry Healthcare Inc. Aberdeen 08/19/2009 73
40 Wells Fargo Sioux Falls 07/30/2009 114
41 Merillat Rapid City 07/17/2009 158
42 VeraSun Energy Corporation Sioux Falls 05/25/2009 92
43 Terex Load King Elk Point 05/01/2009 63
44 Hutchinson Technology Inc. Sioux Falls 01/08/2009 275
45 MPC North Sioux City 01/02/2009 45
46 MPC North Sioux City 11/05/2008 89
47 Student Financial Loan Corporation   (SFLC) Aberdeen 05/20/2008 18
48 Qwest Sioux Falls 01/24/2008 58
49 Ideal Merchandising Apollo Beach, FL 12/06/2007 1
50 Artic Cat Madison 11/12/2007 89
51 Gateway North Sioux City 10/11/2007 60
52 Oak Valley Farms Watertown 07/30/2007 225
53 Gillette Dairy Rapid City 05/16/2007 48

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [southdakota_warn_raw] (
   [Company] TEXT,
   [Location] TEXT,
   [Date] TEXT,
   [Employees Affected] TEXT
);