Illinois_warn_raw
Data source: Big Local News · About: big-local-datasette
28 rows where Permanent or Temporary: = "Permanent"
This data as json, copyable, CSV (advanced)
Suggested facets: COMPANY NAME:, COMPANY ADDRESS:, CITY, STATE, ZIP:, COMPANY CONTACT:, TELEPHONE:, UNION:, BUMPING RIGHTS:, LOCAL WORKFORCE AREA:, REGION NUMBER & NAME:, TYPE OF COMPANY:, TYPE OF EVENT:, WARN NOTIFIED DATE:, FIRST LAYOFF DATE:, ENDING LAYOFF DATE:, # WORKERS AFFECTED:, EVENT CAUSES:, 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: | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | Adventurous Journeys LLC | Capital Partners LLC | 133 N Jefferson Street, 4th Floor | Chicago, IL 60661 | Sara Rose | 630-659-5840 | No | No | 7 | 4 | Offices of Real Estate Agents and Brokers (Real Estate and Rental and Leasing) | Mass Layoff | Permanent | 43914 | 43914 | 35 | COVID-19 | Cook | 531210 | Both | |
4 | 4 | Agency EA LLC | 311 W Walton St | Chicago, IL 60610 | Traci Pratt | 312-445-9423 | No | No | 7 | 4 | All Other Support Services (Administrative, Support, Waste Management, and Remediation Services) | Mass Layoff | Permanent | 43910 | 43913 | 43930 | 47 | COVID-19 | Cook | 561990 | ||
6 | 6 | Art Van Furniture LLC | 1021 Butterfield Rd | Downers Grove, IL 60515 | Cathrine Wenger | 586-983-2000 | No | No | 6 | 4 | Furniture Stores (Retail Trade) | Mass Layoff | Permanent | 43911 | 43911 | 43912 | 46 | COVID-19 | DuPage | 442110 | ||
7 | 7 | Art Van Furniture LLC | 1150 115th St | Bolingbrook, IL 60490 | Cathrine Wenger | 586-983-2000 | No | No | 6 | 4 | Furniture Stores (Retail Trade) | Mass Layoff | Permanent | 43911 | 43911 | 43912 | 62 | COVID-19 | DuPage | 442110 | ||
12 | 12 | Boqueria Operations LLC and Jaleo Management LLC | Boqueria | 807 West Fulton Market | Chicago, IL 60607 | Victoria Fabio | 212-477-9400 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Closing | Permanent | 43914 | 43910 | 85 | COVID-19 | Cook | 722511 | ||
20 | 20 | Castwell Products, LLC Revised Notice) | 7800 NorthAustin Avenue | Skokie, Il 60077 | Michael Goodall, HR Manager | 847-972-5087 | No | No | 7 | 4 | Iron Foundries (Manufacturing) | Closing | Permanent | 43909 | 43983 | 43996 | 149 | Cook | 331551 | |||
55 | 55 | Collecto, Inc. | EOS USA | 8201 W. 183rd St. | Tinley Park, Illinois | Matthew Clark | 781-753-4414 | No | No | 7 | 4 | Collection Agencies (Administrative, Support, Waste Management, and Remediation Services) | Closing | Permanent | 43910 | 43910 | 94 | COVID-19 | Cook | 561440 | ||
60 | 60 | DHL Supply Chain | 1701 Remington Blvd | Bolingbrook, IL 60490 | Courtney Young | 815-325-0824 | No | No | 10 | 4 | Couriers and Express Delivery Services (Transportation and Warehousing) | Closing | Permanent | 43907 | 44012 | 105 | Consolidation | Will | 492110 | |||
62 | 62 | DO & CO Catering Chicago | 2150 Frontage Rd | Des Plaines, IL 60018 | Tino Wohlfahrt | 718-529-4570 | No | No | 7 | 4 | Hotels (except Casino Hotels) | Mass Layoff | Permanent | 43913 | 43911 | 236 | COVID-19 | Cook | 721110 | |||
64 | 64 | Earl's Restaurants USA Inc | Lincoln Park, 1538 N Claybourn Ave, Unit A108 | Chicago, IL, | Tomelise Stefan | 604-396-4636 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Mass Layoff | Permanent | 43914 | 43910 | 65 | COVID-19 | Cook | 722511 | |||
65 | 65 | Energizer | 200 Corporate Drive | Dixon, IL 61021 | Patty Murray | 779-251-7084 | No | No | 4 | 6 | Storage Battery Manufacturing | Closing | Permanent | 43892 | 43952 | 125 | Consolidation | Lee | 335911 | |||
72 | 72 | Greyhound Lines, Inc | 630 W Harrison St | Chicago, IL 60607 | Ember Harbaugh | 214-849-8606 | ATI Local 1700 | Yes | 7 | 4 | Charter Bus Industry (Transportation and Warehousing) | Mass Layoff | Permanent | 43915 | 43915 | 43930 | 55 | COVID-19 | Cook | 485510 | ||
73 | 73 | Greyhound Lines, Inc | 901 N Halsted Street | Chicago, IL 60642 | Ember Harbaugh | 214-849-8606 | ATI Local 1700 | Yes | 7 | 4 | Charter Bus Industry (Transportation and Warehousing) | Mass Layoff | Permanent | 43915 | 43915 | 43930 | 56 | COVID-19 | Cook | 485510 | ||
75 | 75 | HMS Host (Oasis) | Starbucks, Popeyes, Travel Mart | 700 E Tri-State2510 Pearl St2700 Crego Rd5800 Tri-State Tollway13783 W. Oasis Service Rd | South Holland, IL 60473Belvidere, IL 60473Dekalb, IL 60115Hinsdale, IL 60521Lake Forest, IL 60045 | Stephanie Jones | 813-326-5052 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Temporary Closing | Permanent | 43914 | 43910 | 110 | COVID-19 | Cook | 722511 | ||
76 | 76 | HMS Host (O'Hare) | 10000 W O'Hare Ave | Chicago, IL 60666 | Yes | Yes | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Temporary Closing | Permanent | 43915 | 43910 | 1400 | ||||||||
80 | 80 | Impact Networking, LLC | 6 Territorial Court | Bolingbrook, IL 60440 | Mary Zellers | 847-473-7160 | No | No | 6 | 4 | Administrative Management and General Management Consulting Services (Professional and Technical Services) | Mass Layoff | Permanent | 43916 | 43908 | 43910 | 40 | COVID-19 | Lake | 541611 | ||
82 | 82 | Keep Truckin, Inc | 500 W. Madison St, Suite 1650 | Chicago, IL 60661 | Margaret Thering | 716-440-7367 | No | No | 7 | 4 | General Freight Trucking, Local (Transportation and Warehousing) | Closing | Permanent | 43921 | 43921 | 27 | COVID-19 | Cook | 484110 | |||
83 | 83 | Kemper Valve & Fittings Corp | 3001 Darrell Road | Island Lake, Illinois 60042 | Rachele L. Ackerman | 847-416-3162 | No | No | 2 | 4 | Other Metal Valve and Pipe Fitting Manufacturing | Mass Layoff | Permanent | 43920 | 43983 | 110 | Decrease in Scale | McHenry | 33291 | |||
86 | 86 | Mercury Products | 1201 S Mercury Drive | Schaumburg, IL 60193 | Bruce Havel | 847-524-4400 | Chemical and Production Workers Union Local 30 | No | 6 | 4 | Motor Vehicle Metal Stamping (Manufacturing) | Mass Layoff | Permanent | 43916 | 43916 | 107 | COVID-19 | DuPage | 336370 | |||
88 | 88 | Metro Tech Service LLC | 1827 Walden Office Square, Ste. 304 | Schaumburg, IL 60173 | James Walsh | 973-216-8450 | No | No | 6 | 4 | Plumbing, Heating, and Air-Conditioning Contractors (Construction) | Mass Layoff | Permanent | 43914 | 43915 | 54 | COVID-19 | DuPage | 238220 | |||
90 | 90 | Onni Properties, LLC | 352 N Union Ave369 W Grand Ave550 W Van Buren St 750 N Hudson Ave200 N LaSalle1140 N Wells St | Chicago IL 60661 Chicago IL 60654Chicago IL 60607Chicago IL 60654Chicago IL 60606Chicago IL 60610 | Jarred Elias | 602-595-4826 | No | No | 7 | 4 | Offices of Real Estate Agents and Brokers | Closing | Permanent | 43914 | 43921 | 49 | COVID-19 | Cook | 531210 | |||
94 | 94 | Prospect Airport Services | 10000 W Ohare Ave | Chicago, IL 60666 | Linda Suceska | SEIU Local 1 | Yes | 7 | 4 | All Other Miscellaneous Schools and Instruction (Educational Services) | Mass Layoff | Permanent | 43910 | 43912 | 216 | COVID-19 | Cook | 611699 | ||||
95 | 95 | Prospect Airport Services | 5700 S Cicero Ave | Chicago, IL 60638 | Linda Suceska | SEIU Local 1 | Yes | 7 | 4 | All Other Miscellaneous Schools and Instruction (Educational Services) | Mass Layoff | Permanent | 43910 | 43912 | 216 | COVID-19 | Cook | 611699 | ||||
96 | 96 | Punch Bowl Social | 1100 American Lane | Schaumburg, IL 60173 | Claire Clark | 720-414-2726 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Closing | Permanent | 43914 | 43910 | 131 | COVID-19 | Cook | 722511 | |||
97 | 97 | Punch Bowl Social | 310 N. Green St | Chicago, IL 60607 | Claire Clark | 720-414-2726 | No | No | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Closing | Permanent | 43914 | 43910 | 67 | COVID-19 | Cook | 722511 | |||
98 | 98 | Siffron | 1600 Birchwood Ave | Des Plaines, IL, 60018 | Shannon West | 815-713-3004 | No | NA | 7 | 4 | Full-Service Restaurants (Accommodation and Food Services) | Mass Layoff | Permanent | 43914 | 43910 | 70 | COVID-19 | Cook | 722511 | |||
105 | 105 | Trans States Airlines | 10000 W O'Hare Ave | Chicago, IL 60666 | Lauren B. Harris | 314-335-6839 | No | No | 7 | 4 | Scheduled Passenger Air Transportation (Transportation and Warehousing) | Mass Layoff | Permanent | 43909 | 43907 | 43923 | 184 | COVID-19 | Cook | 481110 | ||
106 | 106 | Trans States Airlines | 2200 69th Ave | Moline, IL | Lauren B. Harris | 314-335-6839 | No | No | 13 | 6 | Scheduled Passenger Air Transportation (Transportation and Warehousing) | Mass Layoff | Permanent | 43909 | 43907 | 43923 | 28 | COVID-19 | Cook | 481110 |
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 );