Illinois_warn_raw
Data source: Big Local News · About: big-local-datasette
2 rows where Permanent or Temporary: = "TemporaryPermanent"
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: | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | Barrington Orthopedic Specialist, Ltd. | 864 West Stearns Rd.404 North McHenry Road120 East Higgins Road929 West Higgins Road | Barlett, IL 60103Buffalo Grove, IL 60089Buffalo Grove, IL 60089Elk Grove Village, IL 60007 | Rik Baier, CEO | 847-285-4283 | No | No | 7 | 4 | Offices of Physicians (except Mental Health Specialists) (Health Care and Social Assistance) | Furlough Layoffs | TemporaryPermanent | 43917 | 43920 | 1617 | COVID-19 | Cook | 621111 | |||
61 | 61 | Dixon Direct LLC | Arcade Beauty | 1226 W Seventh St | Dixon, IL 61201 | Larry Blake | 215-913-4668 | No | No | 4 | 6 | Commercial Printing (except Screen and Books) (Manufacturing) | Temporary Closing | TemporaryPermanent | 43911 | 43911 | 9545 | COVID-19 | Lee | 323111 |
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 );