california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Received Date descending
This data as json, copyable, CSV (advanced)
Link | rowid | Notice Date | Effective Date | Received Date ▲ | Company | City | County | Employees | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
2166 | 2166 | 12/14/2015 | 02/12/2016 | 12/22/2015 | Safeway, Inc. | Pleasanton | 33 | Layoff Unknown at this time | |
4346 | 4346 | 12/09/2014 | 02/16/2015 | 12/22/2014 | HACIENDA HOTEL | El Segundo | 93 | Closure Temporary | |
4347 | 4347 | 12/10/2014 | 02/08/2015 | 12/22/2014 | BANK OF AMERICA | Los Angeles | 3 | Layoff Permanent | |
4348 | 4348 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Cerritos | 24 | Layoff Permanent | |
4349 | 4349 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Downey | 26 | Layoff Permanent | |
4350 | 4350 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Lakewood | 25 | Layoff Permanent | |
4351 | 4351 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Los Angeles | 24 | Layoff Permanent | |
4352 | 4352 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | San Bernardino | 14 | Layoff Permanent | |
4353 | 4353 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Santa Monica | 44 | Layoff Permanent | |
4354 | 4354 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Thousand Oaks | 32 | Layoff Permanent | |
4355 | 4355 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Ventura | 26 | Layoff Permanent | |
4356 | 4356 | 12/15/2014 | 02/12/2015 | 12/22/2014 | MFS INC. SERVICES | Victorville | 19 | Layoff Permanent | |
4357 | 4357 | 12/15/2014 | 02/15/2015 | 12/22/2014 | MFS INC. SERVICES | Santa Barbara | 8 | Layoff Permanent | |
4358 | 4358 | 12/15/2014 | 12/31/2014 | 12/22/2014 | ARAMARK | Wheatland | 152 | Closure Permanent | |
4359 | 4359 | 12/18/2014 | 12/15/2014 | 12/22/2014 | ENSIGN UNITED STATES DRILLING | Bakersfield | 700 | Layoff Unknown at this time | |
4360 | 4360 | 12/19/2014 | 02/17/2015 | 12/22/2014 | NORCO DELIVERY SERVICES | Anaheim | 93 | Layoff Permanent | |
1499 | 1499 | 12/01/2020 | 11/30/2020 | 12/21/2020 | Hawaiian Gardens Casino | Hawaiian Gardens | Los Angeles County | 141 | Layoff Permanent |
1500 | 1500 | 12/01/2020 | 11/30/2020 | 12/21/2020 | Progressive Gaming, LLC | Hawaiian Gardens | Los Angeles County | 176 | Layoff Temporary |
1501 | 1501 | 12/01/2020 | 11/30/2020 | 12/21/2020 | Progressive Gaming, LLC dba Commerce Casino | Commerce | Los Angeles County | 175 | Layoff Temporary |
1502 | 1502 | 12/03/2020 | 12/04/2020 | 12/21/2020 | Santa monica Georgian Management LLC-Georgian Hotel | Santa Monica | Los Angeles County | 44 | Layoff Temporary |
1503 | 1503 | 12/09/2020 | 12/08/2020 | 12/21/2020 | San Diego Coaster Company LP | San Diego | San Diego County | 54 | Layoff Permanent |
1504 | 1504 | 12/04/2020 | 02/04/2021 | 12/21/2020 | Premier Healthcare Management, Inc. | El Cajon | San Diego County | 82 | Layoff Permanent |
1505 | 1505 | 12/01/2020 | 12/02/2020 | 12/21/2020 | CorePower Yoga, LLC | San Mateo | San Mateo County | 12 | Layoff Temporary |
1506 | 1506 | 12/02/2020 | 01/31/2020 | 12/21/2020 | Pulse Secure | San Jose | Santa Clara County | 78 | Layoff Permanent |
1507 | 1507 | 11/30/2020 | 02/05/2021 | 12/21/2020 | Crescent Hotels & Resort, LLC - Four Points by Sheraton LAX | Los Angeles | Los Angeles County | 214 | Closure Permanent |
1508 | 1508 | 11/10/2020 | 11/10/2020 | 12/21/2020 | Kaiser Foundation Hospitals - Downey Administration Offices | Downey | Los Angeles County | 1 | Layoff Permanent |
1509 | 1509 | 11/10/2020 | 11/10/2020 | 12/21/2020 | Kaiser Foundation Hospitals - Marketing, Sales, Service, Admin | Burbank | Los Angeles County | 1 | Layoff Permanent |
1510 | 1510 | 11/25/2020 | 11/30/2020 | 12/21/2020 | The Edward Thomas Hospitality Corp. - Shutters on the Beach | Santa Monica | Los Angeles County | 72 | Layoff Temporary |
1511 | 1511 | 11/10/2020 | 01/10/2021 | 12/21/2020 | Kaiser Foundation Hospitals - Corona Data Center Admin | Corona | Riverside County | 4 | Layoff Permanent |
2915 | 2915 | 12/14/2018 | 02/28/2019 | 12/21/2018 | Spectra Laboratories | Milpitas | Santa Clara | 46 | Layoff Permanent |
2916 | 2916 | 12/19/2018 | 12/28/2018 | 12/21/2018 | Legendary Baking of California LLC | Santa Ana | Orange County | 75 | Layoff Permanent |
2917 | 2917 | 12/19/2018 | 02/20/2019 | 12/21/2018 | CardioDx, Inc. | Redwood City | San Mateo County | 110 | Layoff Permanent |
9683 | 9683 | 12/20/2017 | 12/17/2017 | 12/21/2017 | P.F. Changs China Bistro, Inc. | Burbank | Los Angeles | 74 | Closure Permanent |
3682 | 3682 | 12/16/2016 | 02/17/2017 | 12/21/2016 | Boeing Company | El Segundo | 9 | Layoff Unknown at this time | |
3683 | 3683 | 12/16/2016 | 02/17/2017 | 12/21/2016 | Boeing Company | Huntington Beach | 13 | Layoff Unknown at this time | |
9125 | 9125 | 12/16/2019 | 12/31/2019 | 12/20/2019 | Chief Mechanical, Inc. | Sacramento | Sacramento County | 2 | Closure Permanent |
9126 | 9126 | 11/19/2019 | 01/17/2020 | 12/20/2019 | NortonLifeLock Inc. | Mountain View | Santa Clara County | 55 | Layoff Permanent |
9127 | 9127 | 12/13/2019 | 02/21/2020 | 12/20/2019 | Boeing Company | Huntington Beach | Orange County | 7 | Layoff Unknown at thistime |
2912 | 2912 | 12/14/2018 | 02/12/2019 | 12/20/2018 | Silver Lake Medical Center | Los Angeles | Los Angeles | 573 | Layoff Permanent |
2913 | 2913 | 12/14/2018 | 02/12/2019 | 12/20/2018 | Silver Lake Medical Center | Rosemead | Los Angeles | 254 | Layoff Permanent |
2914 | 2914 | 12/17/2018 | 02/18/2019 | 12/20/2018 | OpenX Technologies, Inc. | Pasadena | Los Angeles | 124 | Layoff Permanent |
3681 | 3681 | 10/19/2016 | 01/13/2017 | 12/20/2016 | Ryder | Rialto | 28 | Layoff Permanent | |
9128 | 9128 | 12/18/2019 | 02/01/2020 | 12/19/2019 | Adventist Health Feather River Palliative Care | Chico | Butte County | 8 | Closure Permanent |
9129 | 9129 | 12/18/2019 | 02/28/2020 | 12/19/2019 | Razer USA Ltd. | San Francisco | San Francisco County | 19 | Closure Permanent |
2911 | 2911 | 12/07/2018 | 12/07/2018 | 12/19/2018 | Daybreak Game Company | San Diego | San Diego County | 25 | Layoff Permanent |
9679 | 9679 | 12/01/2017 | 02/01/2018 | 12/19/2017 | Alstyle Apparels Anaheim Distribution Center | Anaheim | Orange County | 81 | Closure Permanent |
9680 | 9680 | 12/14/2017 | 02/12/2018 | 12/19/2017 | Huge, Inc. | Los Angeles | Los Angeles | 23 | Closure Permanent |
9681 | 9681 | 12/15/2017 | 02/18/2018 | 12/19/2017 | Evolution Hospitality, LLC | San Diego | San Diego County | 41 | Layoff Temporary |
9682 | 9682 | 12/18/2017 | 02/24/2018 | 12/19/2017 | WestRock Converting Companys | Moreno Valley | Riverside County | 76 | Closure Permanent |
3680 | 3680 | 12/19/2016 | 02/25/2017 | 12/19/2016 | GBW Railcar Services, LLC | Mira Loma | 142 | Closure Permanent | |
4335 | 4335 | 11/24/2014 | 01/30/2015 | 12/19/2014 | HCC INVESTORS, LLC | Rancho Santa Fe | 156 | Closure Permanent | |
4336 | 4336 | 12/05/2014 | 02/05/2015 | 12/19/2014 | ITT CANNON LLC | Santa Ana | 7 | Layoff Permanent | |
4337 | 4337 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | San Jose | 1 | Layoff Unknown at this time | |
4338 | 4338 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | San Jose | 45 | Layoff Unknown at this time | |
4339 | 4339 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | San Jose | 59 | Layoff Unknown at this time | |
4340 | 4340 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | Santa Clara | 2 | Layoff Unknown at this time | |
4341 | 4341 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | Santa Clara | 4 | Layoff Unknown at this time | |
4342 | 4342 | 12/10/2014 | 02/11/2015 | 12/19/2014 | Qualcomm Incorporated | San Diego | 178 | Layoff Unknown at this time | |
4343 | 4343 | 12/10/2014 | 02/15/2015 | 12/19/2014 | INTERMUNE, INC | Brisbane | 170 | Layoff Permanent | |
4344 | 4344 | 12/12/2014 | 01/15/2015 | 12/19/2014 | EXIDE TECHNOLOGIES | Los Angeles | 64 | Layoff Temporary | |
4345 | 4345 | 12/12/2014 | 02/22/2015 | 12/19/2014 | EL CENTRO REGIONAL MEDICAL | El Centro | 68 | Layoff Permanent | |
1493 | 1493 | 12/04/2020 | 11/30/2020 | 12/18/2020 | Seaside Dining Group | Hawthorne | Los Angeles County | 6 | Layoff Temporary |
1494 | 1494 | 12/04/2020 | 11/30/2020 | 12/18/2020 | Seaside Dining Group, Inc | Los Angeles | Los Angeles County | 6 | Layoff Temporary |
1495 | 1495 | 12/04/2020 | 11/30/2020 | 12/18/2020 | Seaside Dining Group, Inc. | Alhambra | Los Angeles County | 32 | Layoff Temporary |
1496 | 1496 | 12/04/2020 | 11/30/2020 | 12/18/2020 | SEASIDE DINING GROUP, INC. | Duarte | Los Angeles County | 7 | Layoff Temporary |
1497 | 1497 | 12/07/2020 | 12/09/2020 | 12/18/2020 | Stones South Bay Corp. dba Seven Mile Casino | Chula Vista | San Diego County | 250 | Layoff Temporary |
1498 | 1498 | 12/07/2020 | 02/13/2021 | 12/18/2020 | Valiant Integrated Services | Fort Irwin | San Bernardino County | 84 | Closure Temporary |
2906 | 2906 | 12/04/2018 | 02/02/2019 | 12/18/2018 | Aisle 1 | Alameda | Alameda County | 7 | Layoff Unknown at this time |
2907 | 2907 | 12/04/2018 | 02/02/2019 | 12/18/2018 | Aisle 1 | Modesto | Stanislaus County | 7 | Layoff Unknown at this time |
2908 | 2908 | 12/04/2018 | 02/02/2019 | 12/18/2018 | Aisle 1 | Stockton | San Joaquin | 8 | Layoff Unknown at this time |
2909 | 2909 | 12/04/2018 | 02/02/2019 | 12/18/2018 | Aisle 1 | Woodland | Yolo County | 5 | Layoff Unknown at this time |
2910 | 2910 | 12/17/2018 | 02/15/2019 | 12/18/2018 | TreeHouse Private Brands, Inc. | Visalia | Tulare County | 243 | Closure Permanent |
9678 | 9678 | 09/15/2017 | 11/17/2017 | 12/18/2017 | RMR Financial, LLC | Los Gatos | Santa Clara | 17 | Closure Permanent |
2163 | 2163 | 12/16/2015 | 12/14/2015 | 12/18/2015 | BAE SYSTEMS | San Francisco | 2 | Layoff Temporary | |
2164 | 2164 | 12/16/2015 | 12/14/2015 | 12/18/2015 | BAE SYSTEMS | San Francisco | 61 | Layoff Temporary | |
2165 | 2165 | 12/18/2015 | 02/25/2016 | 12/18/2015 | Gerawan Farming, Inc. | Kerman | 2551 | Closure Permanent | |
4330 | 4330 | 11/14/2014 | 01/14/2015 | 12/18/2014 | HERE North American LLC | Sunnyvale | 82 | Layoff Permanent | |
4331 | 4331 | 12/08/2014 | 03/12/2015 | 12/18/2014 | TOPPAN PHOTOMASKS, INC. | Santa Clara | 75 | Closure Permanent | |
4332 | 4332 | 12/08/2014 | 12/12/2014 | 12/18/2014 | SPG SOLAR, INC. | Petaluma | 10 | Closure Unknown at this time | |
4333 | 4333 | 12/10/2014 | 04/30/2015 | 12/18/2014 | GRANICUS INC | San Francisco | 47 | Closure Permanent | |
4334 | 4334 | 12/12/2014 | 02/12/2015 | 12/18/2014 | SEAWORLD LLC | San Diego | 108 | Layoff Permanent | |
1484 | 1484 | 12/04/2020 | 01/29/2020 | 12/17/2020 | Universal City Studios, LLC dba Universal Studios Hollywood | Universal City | Los Angeles County | 2 | Layoff Permanent |
1485 | 1485 | 11/13/2020 | 11/13/2020 | 12/17/2020 | Hyatt Corporation dba Andaz Napa | Napa | Napa County | 6 | Layoff Permanent |
1486 | 1486 | 12/04/2020 | 12/04/2020 | 12/17/2020 | Wencor Group, LLC | Temecula | Riverside County | 5 | Layoff Permanent |
1487 | 1487 | 12/07/2020 | 12/07/2020 | 12/17/2020 | Alisal Guest Ranch and Resort | Solvang | Santa Barbara County | 252 | Layoff Temporary |
1488 | 1488 | 12/01/2020 | 11/30/2020 | 12/17/2020 | Crystal Casino | Compton | Los Angeles County | 295 | Layoff Temporary |
1489 | 1489 | 11/25/2020 | 11/25/2020 | 12/17/2020 | TUPELO RESTAURANTS, INC. DBA BO-BEAU KITCHEN + ROOF TAP | Long Beach | Los Angeles County | 26 | Layoff Permanent |
1490 | 1490 | 11/30/2020 | 11/25/2020 | 12/17/2020 | Soho Warehouse, LLC | Los Angeles | Los Angeles County | 98 | Layoff Temporary |
1491 | 1491 | 11/29/2020 | 11/30/2020 | 12/17/2020 | Prime Time Athletic Club, Inc. | Burlingame | San Mateo County | 57 | Closure Temporary |
1492 | 1492 | 12/05/2020 | 12/06/2020 | 12/17/2020 | PLAYERS CASINO | Ventura | Ventura County | 62 | Layoff Temporary |
9130 | 9130 | 12/10/2019 | 02/08/2020 | 12/17/2019 | Waldorf Astoria Beverly Hills, Rooftop by JG | Los Angeles | Los Angeles County | 79 | Closure Temporary |
9131 | 9131 | 12/13/2019 | 02/10/2020 | 12/17/2019 | RAD Urban | Lathrop | San Joaquin County | 22 | Closure Permanent |
9132 | 9132 | 12/09/2019 | 02/11/2020 | 12/17/2019 | Medtronic, Inc. | Goleta | Santa Barbara County | 20 | Layoff Permanent |
2901 | 2901 | 12/04/2018 | 02/02/2019 | 12/17/2018 | Aisle 1 | Galt | Sacramento | 28 | Layoff Unknown at this time |
2902 | 2902 | 12/04/2018 | 02/02/2019 | 12/17/2018 | Aisle 1 | South Lake | El Dorado County | 19 | Layoff Unknown at this time |
2903 | 2903 | 12/07/2018 | 01/20/2019 | 12/17/2018 | Abercrombie & Fitch | Rolling Hills | Los Angeles | 17 | Closure Permanent |
2904 | 2904 | 12/13/2018 | 02/10/2019 | 12/17/2018 | Instacart | Cupertino | Santa Clara | 8 | Closure Permanent |
2905 | 2905 | 12/13/2018 | 02/10/2019 | 12/17/2018 | Instacart | Los Angeles | Los Angeles | 56 | Closure Permanent |
2162 | 2162 | 12/11/2015 | 02/15/2016 | 12/17/2015 | Parker Hannifin Corporation | Fontana | 69 | Closure Unknown at this time | |
4319 | 4319 | 11/04/2014 | 12/05/2014 | 12/17/2014 | Capitol Expressway Ford | San Jose | 102 | Layoff Permanent |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [california_warn_raw] ( [Notice Date] TEXT, [Effective Date] TEXT, [Received Date] TEXT, [Company] TEXT, [City] TEXT, [County] TEXT, [Employees] INTEGER, [Layoff/Closure] TEXT );