california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Employees
This data as json, copyable, CSV (advanced)
Link | rowid | Notice Date | Effective Date | Received Date | Company | City | County | Employees ▼ | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
2214 | 2214 | 01/15/2016 | 03/15/2016 | 01/19/2016 | Brice Manufacturing Company, Inc. | Pacoima | 1 | Layoff Permanent | |
2243 | 2243 | 01/27/2016 | 03/29/2016 | 01/28/2016 | VSE Corporation | Los Alamitos | 1 | Layoff Permanent | |
2245 | 2245 | 01/27/2016 | 03/29/2016 | 01/28/2016 | VSE Corporation | Riverside | 1 | Layoff Permanent | |
2246 | 2246 | 01/27/2016 | 03/29/2016 | 01/28/2016 | VSE Corporation | Van Nuys | 1 | Layoff Permanent | |
2266 | 2266 | 01/28/2016 | 03/28/2016 | 02/02/2016 | Blue Shield of California | San Jose | 1 | Layoff Permanent | |
2267 | 2267 | 01/28/2016 | 03/28/2016 | 02/02/2016 | Blue Shield of California | Walnut Creek | 1 | Layoff Permanent | |
2316 | 2316 | 02/22/2016 | 03/31/2016 | 02/23/2016 | Kabam LA | Los Angeles | 1 | Layoff Permanent | |
2332 | 2332 | 02/22/2016 | 04/29/2016 | 03/01/2016 | Investor's Business Daily, Inc. | Coto De Caza | 1 | Layoff Permanent | |
2334 | 2334 | 02/22/2016 | 04/29/2016 | 03/01/2016 | Investor's Business Daily, Inc. | San Diego | 1 | Layoff Permanent | |
2336 | 2336 | 02/22/2016 | 04/29/2016 | 03/01/2016 | Investor's Business Daily, Inc. | Valencia | 1 | Layoff Permanent | |
2359 | 2359 | 03/18/2016 | 05/17/2016 | 03/21/2016 | Williams-Sonoma, Inc. | Richmond | 1 | Layoff Permanent | |
2386 | 2386 | 03/29/2016 | 03/28/2016 | 04/06/2016 | BAE SYSTEMS | San Francisco | 1 | Layoff Temporary | |
2389 | 2389 | 04/05/2016 | 06/10/2016 | 04/07/2016 | Rockwell Collins, Inc. | Poway | 1 | Closure Permanent | |
2460 | 2460 | 05/06/2016 | 07/06/2016 | 05/09/2016 | Brake Parts Inc. | Chowchilla | 1 | Layoff Permanent | |
2515 | 2515 | 05/26/2016 | 05/24/2016 | 05/27/2016 | BAE SYSTEMS | San Francisco | 1 | Layoff Temporary | |
2557 | 2557 | 06/21/2016 | 08/21/2016 | 06/21/2016 | Jacobs Technology Inc. | Camarillo | 1 | Layoff Permanent | |
2585 | 2585 | 07/09/2018 | 09/10/2018 | 07/12/2018 | Marvell Semiconductor, Inc. | Aliso Viejo | Orange County | 1 | Layoff Permanent |
2601 | 2601 | 07/17/2018 | 07/17/2018 | 07/24/2018 | Performance Chevrolet, Inc. | Sacramento | Sacramento | 1 | Layoff Unknown at this time |
2745 | 2745 | 10/09/2018 | 12/31/2018 | 10/17/2018 | Warner Media, LLC | Burbank | Los Angeles | 1 | Layoff Unknown at this time |
2758 | 2758 | 10/18/2018 | 12/18/2018 | 10/19/2018 | Adventist Health Tehachapi Valley | Tehachapi | Kern County | 1 | Layoff Permanent |
2801 | 2801 | 10/18/2018 | 12/26/2018 | 10/31/2018 | Thermal Structures, Inc. | Corona | Riverside County | 1 | Closure Temporary |
2930 | 2930 | 01/07/2019 | 03/08/2019 | 01/08/2019 | Theravance Biopharma US, Inc. | Los Angeles | Los Angeles | 1 | Layoff Permanent |
2947 | 2947 | 01/16/2019 | 03/30/2019 | 01/22/2019 | Weatherby Inc. Legal Office | Redding | Shasta County | 1 | Closure Permanent |
2958 | 2958 | 01/18/2019 | 03/22/2019 | 01/24/2019 | TrueCar, Inc. | San Francisco | San Francisco | 1 | Layoff Permanent |
2972 | 2972 | 01/24/2019 | 02/15/2019 | 01/29/2019 | Symantec Corporation | San Francisco | San Francisco | 1 | Layoff Permanent |
3028 | 3028 | 02/12/2019 | 04/08/2019 | 02/13/2019 | Adventist Health Tehachapi Valley | Tehachapi | Kern County | 1 | Layoff Permanent |
3030 | 3030 | 02/13/2019 | 02/13/2019 | 02/13/2019 | eBay Inc. | Rancho Cordova | Sacramento | 1 | Layoff Permanent |
3042 | 3042 | 02/15/2019 | 04/16/2019 | 02/20/2019 | Verity Health System of California, Inc. | Daly City | San Mateo County | 1 | Layoff Permanent |
3047 | 3047 | 02/19/2019 | 04/20/2019 | 02/20/2019 | Adventist Health Tehachapi Valley | Tehachapi | Kern County | 1 | Layoff Permanent |
3059 | 3059 | 02/15/2019 | 04/16/2019 | 02/25/2019 | Verity Health System of California, Inc. | San Jose | Santa Clara | 1 | Layoff Permanent |
3151 | 3151 | 03/29/2019 | 06/01/2019 | 04/02/2019 | Saybrook University | Oakland | Alameda County | 1 | Closure Permanent |
3164 | 3164 | 04/05/2019 | 08/01/2019 | 04/09/2019 | Marvell Semiconductor, Inc. | Irvine | Orange County | 1 | Layoff Permanent |
3224 | 3224 | 04/23/2019 | 06/22/2019 | 04/25/2019 | Adventist Health Sonora | Sonora | Tuolumne County | 1 | Layoff Permanent |
3235 | 3235 | 04/29/2019 | 07/01/2019 | 04/29/2019 | Lolli & Pops Distribution Center | Concord | Contra Costa | 1 | Closure Permanent |
3240 | 3240 | 04/30/2019 | 06/30/2019 | 05/01/2019 | Verity Medical Foundation | El Segundo | Los Angeles | 1 | Layoff Permanent |
3304 | 3304 | 05/08/2019 | 07/11/2019 | 05/17/2019 | Anka Behavioral Health, Incorporated | Montebello | Los Angeles | 1 | Closure Permanent |
3348 | 3348 | 05/30/2019 | 07/30/2019 | 06/07/2019 | EDE GROUP, INC. | Union City | Alameda County | 1 | Closure Permanent |
3425 | 3425 | 06/30/2016 | 09/02/2016 | 07/07/2016 | Rockwell Collins, Inc. | Poway | 1 | Closure Permanent | |
3463 | 3463 | 08/03/2016 | 08/04/2016 | 08/08/2016 | SunEdison, Inc. | San Francisco | 1 | Layoff Permanent | |
3464 | 3464 | 08/04/2016 | 10/05/2016 | 08/09/2016 | Brake Parts Inc. | Chowchilla | 1 | Closure Permanent | |
3481 | 3481 | 08/22/2016 | 10/21/2016 | 08/23/2016 | Safeway Inc. | Pleasanton | 1 | Layoff Unknown at this time | |
3522 | 3522 | 09/12/2016 | 10/31/2016 | 09/13/2016 | Brake Parts Inc. | Chowchilla | 1 | Closure Permanent | |
3579 | 3579 | 10/14/2016 | 12/13/2016 | 10/18/2016 | Brake Parts Inc. | Chowchilla | 1 | Closure Permanent | |
3693 | 3693 | 12/30/2016 | 02/28/2017 | 12/30/2016 | Freeport-McMoRan Oil & Gas LLC | Oxnard | 1 | Layoff Permanent | |
3707 | 3707 | 01/11/2017 | 03/18/2017 | 01/12/2017 | Pacific Gas and Electric Company | Bakersfield | 1 | Layoff Permanent | |
3711 | 3711 | 01/11/2017 | 03/18/2017 | 01/12/2017 | Pacific Gas and Electric Company | Hollister | 1 | Layoff Permanent | |
3723 | 3723 | 01/11/2017 | 03/18/2017 | 01/13/2017 | Pacific Gas and Electric Company | Marysville | 1 | Layoff Permanent | |
3724 | 3724 | 01/11/2017 | 03/18/2017 | 01/13/2017 | Pacific Gas and Electric Company | Modesto | 1 | Layoff Permanent | |
3726 | 3726 | 01/11/2017 | 03/18/2017 | 01/13/2017 | Pacific Gas and Electric Company | San Carlos | 1 | Layoff Permanent | |
3730 | 3730 | 01/11/2017 | 03/18/2017 | 01/13/2017 | Pacific Gas and Electric Company | Ukiah | 1 | Layoff Permanent | |
3740 | 3740 | 01/09/2017 | 12/31/2016 | 01/18/2017 | Sears Hometown and Outlet | San Leandro | 1 | Closure Permanent | |
3762 | 3762 | 01/23/2017 | 01/24/2017 | 02/01/2017 | Stanford Health Care | Oakland | 1 | Layoff Permanent | |
3800 | 3800 | 02/22/2017 | 05/01/2017 | 02/23/2017 | Teva Pharmaceuticals USA, Inc. | Corona | 1 | Layoff Permanent | |
3805 | 3805 | 03/01/2017 | 05/01/2017 | 03/01/2017 | Marvell Semiconductor, Inc. | Aliso Viejo | 1 | Layoff Permanent | |
3924 | 3924 | 04/12/2017 | 04/13/2017 | 04/17/2017 | SunEdison, Inc. | Redwood City | 1 | Layoff Permanent | |
3932 | 3932 | 04/17/2017 | 06/19/2017 | 04/20/2017 | Marvell Semiconductor, Inc. | Santa Clara | 1 | Layoff Permanent | |
3934 | 3934 | 04/19/2017 | 06/23/2017 | 04/20/2017 | Rockwell Collins, Inc. | Irvine | 1 | Layoff Permanent | |
3961 | 3961 | 04/28/2017 | 06/28/2017 | 05/04/2017 | Brake Parts Inc. | Chowchilla | 1 | Closure Permanent | |
3974 | 3974 | 05/10/2017 | 07/10/2017 | 05/12/2017 | Marvell Semiconductor, Inc. | Aliso Viejo | 1 | Layoff Permanent | |
3988 | 3988 | 05/18/2017 | 07/17/2017 | 05/22/2017 | Marvell Semiconductor, Inc. | Aliso Viejo | 1 | Layoff Permanent | |
4072 | 4072 | 07/25/2014 | 09/25/2014 | 07/29/2014 | Grand Cafe | San Francisco | 1 | Layoff Permanent | |
4118 | 4118 | 08/11/2014 | 10/10/2014 | 08/14/2014 | RAD Harvest, LLC | Monterey | 1 | Layoff Permanent | |
4135 | 4135 | 08/22/2014 | 10/22/2014 | 09/02/2014 | Super Glue/Pacer Technology | Rancho | 1 | Layoff Permanent | |
4137 | 4137 | 08/05/2014 | 08/04/2014 | 09/03/2014 | BAE Systems | San Francisco | 1 | Layoff Unknown at this time | |
4138 | 4138 | 08/12/2014 | 08/11/2014 | 09/03/2014 | BAE Systems | San Francisco | 1 | Layoff Unknown at this time | |
4260 | 4260 | 10/27/2014 | 01/05/2015 | 11/06/2014 | Sutter Amador Hospital | Jackson | 1 | Layoff Permanent | |
4275 | 4275 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros - Shed Media USA | Los Angeles | 1 | Layoff Permanent | |
4283 | 4283 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Pictures | Burbank | 1 | Layoff Permanent | |
4289 | 4289 | 11/04/2014 | 01/10/2015 | 11/20/2014 | WBTV Distribution Inc | Burbank | 1 | Layoff Permanent | |
4337 | 4337 | 12/10/2014 | 02/11/2015 | 12/19/2014 | QUALCOMM INC. | San Jose | 1 | Layoff Unknown at this time | |
4447 | 4447 | 01/29/2015 | 03/29/2015 | 02/13/2015 | Sutter Roseville Medical Center | Roseville | 1 | Layoff Permanent | |
4565 | 4565 | 03/19/2015 | 05/08/2015 | 03/25/2015 | Keck Medicine of USC-Healthcare | Los Angeles | 1 | Layoff Temporary | |
4571 | 4571 | 03/19/2015 | 05/08/2015 | 03/26/2015 | Keck Medicine of USC-Pasadena | Pasadena | 1 | Layoff Temporary | |
4593 | 4593 | 04/03/2015 | 06/05/2015 | 04/07/2015 | Boeing Company | El Segundo | 1 | Layoff Unknown at this time | |
4620 | 4620 | 04/27/2015 | 06/26/2015 | 04/27/2015 | Safeway Inc. | Dublin | 1 | Layoff Unknown at this time | |
4660 | 4660 | 05/06/2015 | 05/08/2015 | 05/13/2015 | Zynga, Inc. | Santa Clara | 1 | Layoff Permanent | |
4703 | 4703 | 05/08/2015 | 08/28/2015 | 05/21/2015 | Emulex Corporation, Avago | San Jose | 1 | Layoff Permanent | |
4740 | 4740 | 05/21/2015 | 05/20/2015 | 06/04/2015 | BAE Systems | San Francisco | 1 | Layoff Temporary | |
4744 | 4744 | 05/27/2015 | 05/26/2015 | 06/08/2015 | BAE Systems | San Francisco | 1 | Layoff Temporary | |
4778 | 4778 | 06/24/2015 | 08/19/2015 | 06/30/2015 | SureFire, LLC | Fountain Valley | 1 | Layoff Permanent | |
4809 | 4809 | 06/17/2020 | 06/30/2020 | 06/30/2020 | Live Nation Worldwide, Inc | Mountain View | Santa Clara County | 1 | Layoff Temporary |
4838 | 4838 | 06/23/2020 | 06/23/2020 | 06/26/2020 | Hyatt House San Ramon | San Ramon | Contra Costa County | 1 | Layoff Permanent |
4868 | 4868 | 04/08/2020 | 06/08/2020 | 06/25/2020 | Adventist Health Tehachapi Valley | Tehachapi | Kern County | 1 | Layoff Permanent |
4913 | 4913 | 03/31/2020 | 03/31/2020 | 06/24/2020 | SAS Restaurant Ventures DBA Denny's | Barstow | San Bernardino County | 1 | Closure Permanent |
4935 | 4935 | 06/23/2020 | 06/14/2020 | 06/23/2020 | Eaton - Joslyn Sunbank Co., LLC | Paso Robles | San Luis Obispo County | 1 | Layoff Temporary |
4937 | 4937 | 06/08/2020 | 06/15/2020 | 06/22/2020 | Sunroad Bcv Auto Inc | El Cajon | San Diego County | 1 | Layoff Permanent |
4946 | 4946 | 06/08/2020 | 06/30/2020 | 06/18/2020 | AEG Global Partnerships LLC | Los Angeles | Los Angeles County | 1 | Layoff Temporary |
4955 | 4955 | 06/05/2020 | 04/11/2020 | 06/18/2020 | Borrego Community Health Foundation | La Mesa | San Diego County | 1 | Layoff Permanent |
4958 | 4958 | 06/08/2020 | 06/15/2020 | 06/18/2020 | PH Automotive Holding Corp Pacific Honda | San Diego | San Diego County | 1 | Layoff Permanent |
4977 | 4977 | 03/31/2020 | 03/31/2020 | 06/17/2020 | Murrieta Fitness & Health, LLC | Murrieta | Riverside County | 1 | Layoff Temporary |
4978 | 4978 | 03/31/2020 | 03/31/2020 | 06/17/2020 | SAS Restaurant Ventures, Inc. DBA Denny's | Big Bear Lake | San Bernardino County | 1 | Layoff Temporary |
4979 | 4979 | 03/31/2020 | 03/31/2020 | 06/17/2020 | Rancho Cucamonga Fitness LLC | Rancho Cucamonga | San Bernardino County | 1 | Layoff Temporary |
4980 | 4980 | 06/04/2020 | 06/05/2020 | 06/17/2020 | Pacific Clinics Advanced Behavioral Healthcare | Ontario | San Bernardino County | 1 | Layoff Permanent |
4984 | 4984 | 04/08/2020 | 04/08/2020 | 06/17/2020 | LB Construction Inc | Roseville | Placer County | 1 | Layoff Temporary |
4990 | 4990 | 06/08/2020 | 06/15/2020 | 06/16/2020 | Live Nation Entertainment, Inc. -- PurchasingDepartment | Los Angeles | Los Angeles County | 1 | Layoff Temporary |
5004 | 5004 | 04/20/2020 | 03/23/2020 | 06/16/2020 | Enterprise Holdings at Downtown SanFrancisco | San Francisco | San Francisco County | 1 | Layoff Temporary |
5009 | 5009 | 06/16/2020 | 06/16/2020 | 06/16/2020 | Terrietta | Sacramento | Sacramento County | 1 | Closure Temporary |
5015 | 5015 | 06/05/2020 | 03/17/2020 | 06/16/2020 | Decker Electric Co, Inc. | San Francisco | San Francisco County | 1 | Layoff Temporary |
5017 | 5017 | 06/08/2020 | 06/30/2020 | 06/15/2020 | AEG Anschutz Entertainment Group Inc. DBAAEG Sports | Carson | Los Angeles County | 1 | Layoff Permanent |
5018 | 5018 | 06/08/2020 | 06/30/2020 | 06/15/2020 | AEG AXS Holdco LLC | Los Angeles | Los Angeles County | 1 | 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 );