COVID_WARN_Notices: Illinois_warn_raw: 4 rows where where Permanent or Temporary: = 43928

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: = 43928

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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:	ENDING LAYOFF DATE:	# WORKERS AFFECTED:	EVENT CAUSES:	COUNTY:	COMPANY NAICS:
113	113	Areas RHHG ORD JV, LLC	Areas	10000 W O'Hare Ave	Chicago, IL 60666	George Garcia	305-267-8510	Unite Here Local 1	Yes	7	4	Full-Service Restaurants (Accommodation and Food Services)	Temporary Closure	43928	43910	156	Furlough	COVID-19	Cook	722511
171	171	Sofitel Chicago Magnificent Mile		20 E. Chestnut St	Chicago, IL 60611	Michelle Reed	312-324-4003	Unite Here Local 1	Yes	7	4	Hotels (except Casino Hotels) and Motels (Accommodation and Food Services)	Temporary Closure	43928	43927	200	Furlough	COVID-19	Cook	721110
173	173	Staffing Network/QPA		1815 S. Meyers Rd.	Oakbrook Terrace, IL 60181	Sakina Raza	847-250-4944	No	No	7	4	Temporary Help Services (Administrative, Support, Waste Management, and Remediation Services)	Temporary Layoff	43928	43928	29	Furlough	COVID-19	Cook	561320
183	183	ZF Services, LLC		777 Hickory Hill Drive	Vernon Hills, IL 60061	Maureen Jennings	847-478-5874	No	No	1	4	Other Motor Vehicle Parts Manufacturing (Manufacturing)	Temporary Layoff	43928	43920	52	Furlough	COVID-19	Lake	336391

Advanced export

JSON shape: default, array, newline-delimited

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