COVID_WARN_Notices: Illinois_warn_raw: 7 rows where where Permanent or Temporary: = 43934

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

7 rows where Permanent or Temporary: = 43934

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:
131	131	Covia Holdings Corporation	Covia Corporation, Utica Plant	402 Mill St.	Utica, IL 61373	Amy Mathias	815-343-4016	Yes	No	4	6	Industrial Sand Mining (Mining)	Layoff	43934	43934	65	Permanent	RestructuringReduction of Costs	LaSalle	212322
132	132	Covia Holdings Corporation	Covia Corporation, Logistics Center	2069 N. 3462nd Rd.	Wedron, IL 60557	Amy Mathias	815-343-4016	No	No	4	6	Industrial Sand Mining (Mining)	Layoff	43934	43934	3	Permanent	RestructuringReduction of Costs	LaSalle	212322
133	133	Covia Holdings Corporation	Covia Corporation, Ottawa Office North, Analytical Services Lab	4000 Baker Rd.	Ottawa, IL 61350	Amy Mathias	815-343-4016	No	No	4	6	Industrial Sand Mining (Mining)	Layoff	43934	43934	7	Permanent	RestructuringReduction of Costs	LaSalle	212322
134	134	Covia Holdings Corporation	Covia Corporation, LaSalle Fabrication Center	360 Civic Rd.	LaSalle, IL 61301	Amy Mathias	815-343-4016	No	No	4	6	Industrial Sand Mining (Mining)	Layoff	43934	43934	1	Permanent	RestructuringReduction of Costs	LaSalle	212322
144	144	Four Seasons Chicago Worldwide Sales Office		900 North Michigan Avenue, Suite 930	Chicago, Illinois 60611	Nisha Chand	416-441-4289	No	No	7	4	Hotels (except Casino Hotels) and Motels (Accommodation and Food Services)	Layoff	43934	43934	6	Permanent	COVID-19	Cook	721110
163	163	Millennium Knickerbocker Chicago Hotel		163 E. Walton Place	Chicago, Illinois 60611	Marc Kelley	312-867-7524	Yes	Yes	7	4	Hotels (except Casino Hotels) and Motels (Accommodation and Food Services)	Temporary Layoff	43934	43907	100	Temporary	COVID-19	Cook	721110
169	169	Scholastic Book Fairs		301 S. Gary Avenue, Suite A	Roselle, Illinois 60172	John Moore	513-714-1023	No	No	6	4	Book, Periodical, and Newspaper Merchant Wholesalers (Wholesale Trade)	Furlough	43934	43910	47	Temporary Furlough	COVID-19	DuPage	424920

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