Illinois_warn_raw
Data source: Big Local News · About: big-local-datasette
5 rows where Permanent or Temporary: = 43951
This data as json, copyable, CSV (advanced)
Suggested facets: UNION:, BUMPING RIGHTS:, LOCAL WORKFORCE AREA:, TYPE OF EVENT:, EVENT CAUSES:, COUNTY:
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: | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
136 | 136 | Crescent Hotels & Resorts, LLC | Embassy Suites Deerfield | 1445 Lake Cook Rd. | Deerfield, Illinois | Laura Warner | 703-563-4931 | No | No | 1 | 4 | Hotels (except Casino Hotels) and Motels (Accommodation and Food Services) | Temporary Layoffs | 43951 | 43911 | 29 | Temporary Furloughs | COVID-20 | Lake | 721110 | ||
140 | 140 | Enterprise Leasing Company of Chicago, LLC. | 10255 W Zemke Blvd | Chicago, Illinois | Jennifer Mecklenburg | 847-815-7786. | Yes | Yes | 7 | 4 | Passenger Car Rental (Real Estate and Rental and Leasing) | Temporary Layoffs | 43951 | 43920 | 43951 | 9315 | FurloughsPermanent Layoffs | COVID-19 | Cook | 532111 | ||
150 | 150 | Hendrickson Bumper & Trim | 501 Caton Farm Road | Crest Hill, IL 60441 | Laura Boyne | 815-774-6955 | No | No | 10 | 4 | Other Motor Vehicle Parts Manufacturing | Mass Layoffs | 43951 | 43950 | 2313 | Permanent LayoffFurloughs | COVID-19 | Will | 336390 | |||
168 | 168 | Regal Cinemas | 550 East Rollins Road5000 W. Route 141471 W. Webster Avenue28250 Diehl Road2600 N. Western Avenue300 Parkway Drive | Round Lake Beach, IL 60073Crystal Lake, IL 60014Chicago, IL 60614Warrenville, IL 60555Chicago, IL 60647Lincolnshire, IL 60069 | Lorie Walker | 865-922-1123 | No | No | 1, 2, 6, 7 | 4 | Motion Picture Theaters (except Drive-Ins) (Information) | Temporary Closure | 43951 | 43938 | 142 | Furloughs | COVID-19 | LakeMcHenryDuPageCook | 512131 | |||
170 | 170 | Sodexo, United | Polaris Club | 10000 Bessie Coleman Dr | Chicago, IL 60666 | Todd Woodruff | 872-600-3350 | No | No | 7 | 4 | Food Service Contractors (Accommodation and Food Services) | Mass Layoffs | 43951 | 43951 | 120 | Permanent Layoff | COVID-19 | Cook | 722310 |
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 );