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

8 rows where LWIB Area = 2

View and edit SQL

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

LWIB Area

Link rowid ▼ url_suffix Employer Name City Zip LWIB Area Notice Date
42 41 mn_warn_dsp.cfm?id=489&callingfile=mn_warn_dsp.cfm&hash=68E3B7BB3BC5A0C97D4BCC59501E3AE1 Baker Hughes Clinton 77515 2 02/06/2015
81 80 mn_warn_dsp.cfm?id=416&callingfile=mn_warn_dsp.cfm&hash=29EFF731C5288EC554DD745C89E5BAB6 CGI Federal Lawton 73501 2 04/02/2013
82 81 mn_warn_dsp.cfm?id=499&callingfile=mn_warn_dsp.cfm&hash=E82FE55455A1A24D072C4A6D10717BCC CGI Federal Lawton 73501 2 02/11/2015
225 224 mn_warn_dsp.cfm?id=352&callingfile=mn_warn_dsp.cfm&hash=7DA4E74EBEA3FF9DF8EF4AFCF6B92793 Imation Weatherford 73096 2 01/19/2011
288 287 mn_warn_dsp.cfm?id=138&callingfile=mn_warn_dsp.cfm&hash=4F5FD751D120ECFB7AAB62AC4AE439C0 North Fork Correctional Facility Sayre 73662 2 06/12/2003
289 288 mn_warn_dsp.cfm?id=519&callingfile=mn_warn_dsp.cfm&hash=B99A4387458E36557CF1C03D86B746FE North Fork Correctional Facility Sayre 73662 2 06/12/2015
362 361 mn_warn_dsp.cfm?id=515&callingfile=mn_warn_dsp.cfm&hash=6C3F98263F5DDED8E3236F41367A0039 SKF Hobart 73651 2 05/19/2015
363 362 mn_warn_dsp.cfm?id=536&callingfile=mn_warn_dsp.cfm&hash=B2AA85AAE7FABC1D17F55B324F3F04E3 SKF USA Inc. Hobart 73651 2 05/19/2015

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
);