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

2 rows where Permanent or Temporary: = 43948

✎ 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: FIRST LAYOFF DATE: ENDING LAYOFF DATE: # WORKERS AFFECTED: EVENT CAUSES: COUNTY: COMPANY NAICS:
120 120 Chicago Botanic Garden   l 000 Lake Cook Road 3555 West Ogden Ave Glencoe, IL 60022Chicago, IL 60623 Aida Z. Giglio 847-370- 2330 No No 1, 7 4 Zoos and Botanical Gardens (Arts, Entertainment, and Recreation) Temporary closing 43948 43955   64 Furloughs COVID-19 CookLake 712130  
157 157 Lessie Bates Neighborhood House Lessie Bates Davis Neighborhood HouseEast St Louis Family Development CenterMary E Brown Center Private MathisonErnest Smith Continuum of Life Center (Paulyn House)Trinity Outreach Center 1200 N 13th Street 1045 State Street 606 S 15th Street 6801 Clarita 4731 Tudor 1274 N 37th Street 5110 Forest East St Louis, IL 62205 East St Louis, IL 62201 East St Louis, IL 62201 East St Louis, IL 62207 East St Louis, IL 62207 Washington Park, IL 62204 Washington Park, IL 62204 Gary Gaston 618-593-5249 No No 24 9 Other Individual and Family Services (Health Care and Social Assistance) Mass Layoff 43948 43948 43959 67 Permanent Lost Contract St. Clair 624190  

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