Illinois_warn_raw
Data source: Big Local News · About: big-local-datasette
3 rows where REGION NUMBER & NAME: = 2
This data as json, copyable, CSV (advanced)
Suggested facets: CITY, STATE, ZIP:, LOCAL WORKFORCE AREA:, TYPE OF COMPANY:, TYPE OF EVENT:, Permanent or Temporary:, 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: | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | Vermilion Valley Produce | 310 South St500 South Glover Ave1667 N Main St208 N 1st St | Danville, IL 61802Urbana, IL 61550Morton, IL 61820Champaign, IL 61820 | John Rollins | No | No | 18 | 2 | Fresh Fruit and Vegetable Merchant Wholesalers (Wholesale Trade) | Temporary Layoff | Temporary | 43909 | 43909 | 64 | COVID-19 | Vermilion | 424480 | ||||
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 |
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 );