Illinois_warn_raw

Table actions
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

4 rows where Permanent or Temporary: = 43945

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: CITY, STATE, ZIP:, UNION:, BUMPING RIGHTS:, TYPE OF EVENT:, WARN NOTIFIED DATE:, # WORKERS AFFECTED:, EVENT CAUSES:

Link rowid ▼ COMPANY NAME: DBA COMPANY ADDRESS: CITY, STATE, ZIP: COMPANY CONTACT: TELEPHONE: UNION: BUMPING RIGHTS: LOCAL WORKFORCE AREA: REGION NUMBER & NAME: TYPE OF COMPANY: TYPE OF EVENT: Permanent or Temporary: WARN NOTIFIED DATE: FIRST LAYOFF DATE: ENDING LAYOFF DATE: # WORKERS AFFECTED: EVENT CAUSES: COUNTY: COMPANY NAICS:
116 116 Bed Bath and Beyond   LakeDuPageCookSt. Clair Illinois Angela Leary 908-855-4563 No No 1, 6, 7, 24 4, 9 All Other Home Furnishings Stores (Retail Trade) Temporary Furloughs 43945 43925   402 Furlough COVID-19 LakeDuPageCookSt. Clair 442299  
142 142 Flexitech, Inc.   1719 E. Hamilton Road Bloomington, Illinois 61704 Alejandro Portugal 309-664-4225 No No 15 3 Automotive Parts and Accessories Stores Closing 43945 44348   139 Layoff Planned Action McLean 441310  
146 146 Greenlee Tools, Inc.   1122 Research Parkway Rockford, IL 61109 Shannon Connors 815 262-8078 Yes Yes 3 5 All Other Miscellaneous Electrical Equipment and Component Manufacturing Closing 43945 44008 44022 51 Layoff Relocation Winnebago 335999  
180 180 Visionworks   LakeMcHenryWinnebagoKaneDuPageCookKankakeeSt. Clair Illinois HR Support Center 833-ONE-HR4U No No 1, 2, 3, 5, 6, 7, 11, 24 4, 5, 9 Optical Goods Stores Partial temporary closing 43945 43925   224 Furloughs COVID-19 LakeMcHenryWinnebagoKaneDuPageCookKankakeeSt. Clair 446130  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [Illinois_warn_raw] (
   [COMPANY NAME:] TEXT,
   [DBA] TEXT,
   [COMPANY ADDRESS:] TEXT,
   [CITY, STATE, ZIP:] TEXT,
   [COMPANY CONTACT:] TEXT,
   [TELEPHONE:] TEXT,
   [UNION:] TEXT,
   [BUMPING RIGHTS:] TEXT,
   [LOCAL WORKFORCE AREA:] INTEGER,
   [REGION NUMBER & NAME:] INTEGER,
   [TYPE OF COMPANY:] TEXT,
   [TYPE OF EVENT:] TEXT,
   [Permanent or Temporary:] TEXT,
   [WARN NOTIFIED DATE:] INTEGER,
   [FIRST LAYOFF DATE:] INTEGER,
   [ENDING LAYOFF DATE:] INTEGER,
   [# WORKERS AFFECTED:] INTEGER,
   [EVENT CAUSES:] TEXT,
   [COUNTY:] TEXT,
   [COMPANY NAICS:] INTEGER,
   [] TEXT
);