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

22 rows where LWIB Area = 6

View and edit SQL

Suggested facets: Employer Name, City, Zip, Notice Date

Link rowid ▼ url_suffix Employer Name City Zip LWIB Area Notice Date
12 11 mn_warn_dsp.cfm?id=273&callingfile=mn_warn_dsp.cfm&hash=40DDBCFAE24C5B397B6641FE670F67A2 Aearo Technologies Chickasha 73111 6 12/15/2008
33 32 mn_warn_dsp.cfm?id=382&callingfile=mn_warn_dsp.cfm&hash=0EBE6265F29C744844A1C2AC565749F2 Assurant Solutions Lawton 73505 6 03/29/2012
50 49 mn_warn_dsp.cfm?id=256&callingfile=mn_warn_dsp.cfm&hash=AD23BDFC9DBAB2520AFD359A04E62D55 Biomet Marlow 73055 6 01/04/2008
61 60 mn_warn_dsp.cfm?id=696&callingfile=mn_warn_dsp.cfm&hash=F9EE8F56AEEDB6AD598C0320FA51BCC4 CACI Lawton 73501 6 04/29/2019
62 61 mn_warn_dsp.cfm?id=659&callingfile=mn_warn_dsp.cfm&hash=10B60BC0F0A663D5A48C95756599A744 CACI Technologies, Inc. Lawton 73501 6 04/29/2019
128 127 mn_warn_dsp.cfm?id=205&callingfile=mn_warn_dsp.cfm&hash=FD4BFF32CF19AEB92131E292412C34D6 Delta Faucet Chickasha 73023 6 01/17/2006
130 129 mn_warn_dsp.cfm?id=714&callingfile=mn_warn_dsp.cfm&hash=628E8362CAB84D2FE87C3EEDC7E09EEA Dillard's Lawton 73501 6 05/13/2020
183 182 mn_warn_dsp.cfm?id=219&callingfile=mn_warn_dsp.cfm&hash=6B3A0C36477E01B7797789724407E606 Great Plains Correctional Facilit Hinton 73047 6 01/12/2007
184 183 mn_warn_dsp.cfm?id=238&callingfile=mn_warn_dsp.cfm&hash=635510A8313B94BA4EB97561F7B1E436 Great Plains Correctional Facilit Hinton 73047 6 01/12/2007
185 184 mn_warn_dsp.cfm?id=344&callingfile=mn_warn_dsp.cfm&hash=040213E7372C55DF455FB2BF289FD21E Great Plains Correctional Facility Hinton 11111 6 08/18/2010
193 192 mn_warn_dsp.cfm?id=671&callingfile=mn_warn_dsp.cfm&hash=122161D4180AD589252DC072E346D564 Halliburton Pocasset 73079 6 04/15/2020
194 193 mn_warn_dsp.cfm?id=672&callingfile=mn_warn_dsp.cfm&hash=A8AEB059DE110B169C076EA6375478B5 Halliburton Duncan 73536 6 04/06/2020
195 194 mn_warn_dsp.cfm?id=550&callingfile=mn_warn_dsp.cfm&hash=28422813057E29016059DB5A5983CD80 Halliburton Duncan 73533 6 05/23/2016
197 196 mn_warn_dsp.cfm?id=704&callingfile=mn_warn_dsp.cfm&hash=14613EBCCD86C9A3365D8339D5FA9630 Halliburton Energy Services, Inc. Duncan 73533 6 04/28/2020
199 198 mn_warn_dsp.cfm?id=232&callingfile=mn_warn_dsp.cfm&hash=28346EC22309B2E11CF290AFB4B14D9C Haulmark Trailers Duncan 73533 6 07/26/2007
266 265 mn_warn_dsp.cfm?id=728&callingfile=mn_warn_dsp.cfm&hash=31382E30BED5B58E63C1BDBC2A8E5860 Mathis Brothers Lawton 73505 6 03/25/2020
270 269 mn_warn_dsp.cfm?id=77&callingfile=mn_warn_dsp.cfm&hash=B1E9871807B613B45982AC6AAEA8E3F1 Montgomery Wards Lawton 73505 6 01/18/2001
284 283 mn_warn_dsp.cfm?id=337&callingfile=mn_warn_dsp.cfm&hash=FF3FEAAEC6973B96D7CE0DA887FE36DD Noble Energy Velma 11111 6 06/09/2010
291 290 mn_warn_dsp.cfm?id=538&callingfile=mn_warn_dsp.cfm&hash=7821C5E81CC1B7E4371BC112E5ED32A0 Novitex Lawton 73505 6 01/26/2016
355 354 mn_warn_dsp.cfm?id=684&callingfile=mn_warn_dsp.cfm&hash=77D287408584FCA5E47F1DE7ECD6D24A Simmons Bank Madill 73446 6 10/10/2019
384 383 mn_warn_dsp.cfm?id=136&callingfile=mn_warn_dsp.cfm&hash=362884584FC706133595AE4456222F80 Surgical Specialities Supply Ada 74820 6 10/25/2002
440 439 mn_warn_dsp.cfm?id=367&callingfile=mn_warn_dsp.cfm&hash=360E180E9B49712DC3F0B5CF00260CAA VT Group Ft. Sill 73503 6 08/03/2011

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [oklahoma_warn_raw] (
   [] INTEGER,
   [url_suffix] TEXT,
   [Employer Name] TEXT,
   [City] TEXT,
   [Zip] INTEGER,
   [LWIB Area] INTEGER,
   [Notice Date] TEXT
);