Illinois_warn_raw
Data source: Big Local News · About: big-local-datasette
7 rows where Permanent or Temporary: = 43949
This data as json, copyable, CSV (advanced)
Suggested facets: CITY, STATE, ZIP:, LOCAL WORKFORCE AREA:, REGION NUMBER & NAME:, TYPE OF COMPANY:, TYPE OF EVENT:, WARN NOTIFIED DATE:, # WORKERS AFFECTED:, COUNTY:, COMPANY NAICS:
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: | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
112 | 112 | ArcelorMittal USA LLC | 1 South Dearborn, Suite 1300 | Chicago, IL 60603 | Marguerite Cogan | 312.899.3965 | No | No | 7 | 4 | Rolled Steel Shape Manufacturing (Manufacturing) | Temporary Layoff | 43949 | 43947 | 43959 | 26 | Furlough | COVID-19 | Cook | 331221 | ||
143 | 143 | Flex-N-Gate Corporation | 1306 E University Ave | Urbana, IL 61802 | Lesley Jenkins | 217-278-2317 | No | No | 17 | 2 | Other Motor Vehicle Parts Manufacturing (Manufacturing) | Temporary Layoff | 43949 | 43910 | 150 | Temporary Layoff | COVID-19 | Champaign | 336390 | |||
148 | 148 | Guardian West | Flex-N-Gate Corporation | 601 Guardian Drive | Urbana, IL 61802 | Anastasia Lloyd | 217-278-2406 | No | No | 17 | 2 | Other Motor Vehicle Parts Manufacturing (Manufacturing) | Temporary Layoff | 43949 | 43910 | 400 | Temporary Layoff | COVID-19 | Champaign | 336390 | ||
149 | 149 | Hard Rock Cafe | 63 West Ontario Street | Chicago, IL 60654 | Julissa Cabrera | 954-797-5478 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Temporary Layoff | 43949 | 43934 | 61 | Furlough | COVID-19 | Cook | 722511 | |||
156 | 156 | Larson-Juhl U.S., LLC | Larson-Juhl | 550 Congress Circle South | Roselle, IL 60172 | Heather Olson | No | No | 6 | 4 | All Other Miscellaneous Manufacturing (Manufacturing) | Temporary Layoff | 43949 | 43930 | 55 | Furlough | COVID-19 | DuPage | 339999 | |||
164 | 164 | Parkhurst Dining Services | Allstate Insurance (North Cafe)Allstate Insurance (South Cafe)Allstate Insurance (TechCor Cafe)Chamberlain Group CaféLake Forest College Café | 2775 Sanders Road3075 Sanders Road100 E. Palatine Road300 Windsor Drive555 North Sheridan Road | Northbrook, IL 60062Northbrook, IL 60062Wheeling, IL 60090Oak Brook, IL 60523Lake Forest, IL 60045 | Tony White | 412-461-2000 x2015 | No | No | 1, 6, 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Temporary Layoff | 43949 | 43891 | 43904 | 146 | Furlough | COVID-19 | LakeCookDuPage | 722511 | |
177 | 177 | The Hertz Corporation | Hertz O'HareHertz Midway | 10000 Bessie Coleman Dr5150 W 55th St | Chicago, IL 60666Chicago, IL 60638 | Karen Gittleman | 239-301-7018 | No | No | 7 | 4 | Passenger Car Rental (Real Estate and Rental and Leasing) | Mass Layoff | 43949 | 43935 | 43938 | 164 | Layoff | COVID-19 | Cook | 532111 |
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 );