california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Effective Date
This data as json, copyable, CSV (advanced)
Link | rowid | Notice Date | Effective Date ▼ | Received Date | Company | City | County | Employees | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
1370 | 1370 | 11/05/2020 | 01/05/2021 | 11/17/2020 | APL Logistics (APLL) | Redlands | San Bernardino County | 65 | Layoff Permanent |
1658 | 1658 | 01/05/2021 | 01/05/2021 | 01/11/2021 | Evolution Hospitality-Hrd Rock Hotel San Diego | San Diego | San Diego County | 27 | Layoff Temporary |
1767 | 1767 | 01/27/2021 | 01/05/2021 | 01/28/2021 | Academy Museum of Motion Pictures | Los Angeles | Los Angeles County | 11 | Layoff Temporary |
4374 | 4374 | 12/23/2014 | 01/06/2015 | 01/06/2015 | Bae Systems | San Francisco | 192 | Layoff Temporary | |
1996 | 1996 | 09/24/2015 | 01/06/2016 | 09/24/2015 | Medtronic Distribution | Mira Loma | 21 | Layoff Permanent | |
2086 | 2086 | 11/06/2015 | 01/06/2016 | 11/06/2015 | Microsemi | Garden Grove | 57 | Layoff Permanent | |
2094 | 2094 | 11/12/2015 | 01/06/2016 | 11/12/2015 | Forever 21 Retail, Inc. | San Luis Obispo | 72 | Closure Permanent | |
3533 | 3533 | 09/19/2016 | 01/06/2017 | 09/26/2016 | Balboa Water Group | Valencia | 245 | Closure Permanent | |
3610 | 3610 | 11/02/2016 | 01/06/2017 | 11/03/2016 | Teva Pharmaceuticals USA, Inc. | Corona | 29 | Layoff Permanent | |
3611 | 3611 | 11/03/2016 | 01/06/2017 | 11/03/2016 | NetApp, Inc. | Sunnyvale | 160 | Layoff Permanent | |
3613 | 3613 | 11/04/2016 | 01/06/2017 | 11/07/2016 | Visa Inc. | Foster City | 213 | Layoff Permanent | |
3614 | 3614 | 11/07/2016 | 01/06/2017 | 11/07/2016 | American Apparel, LLC | Garden Grove | 332 | Closure Permanent | |
3615 | 3615 | 11/07/2016 | 01/06/2017 | 11/07/2016 | American Apparel, LLC | Los Angeles | 2166 | Closure Permanent | |
3616 | 3616 | 11/07/2016 | 01/06/2017 | 11/07/2016 | American Apparel, LLC | South Gate | 959 | Closure Permanent | |
3623 | 3623 | 11/04/2016 | 01/06/2017 | 11/08/2016 | YMCA of Metropolitan Los Angeles | Los Angeles | 3 | Closure Permanent | |
9662 | 9662 | 11/07/2017 | 01/06/2018 | 12/01/2017 | General Electric Company | San Ramon | Contra Costa | 158 | Layoff Permanent |
9704 | 9704 | 01/04/2018 | 01/06/2018 | 01/09/2018 | Aurora Vista Del Mar, LLC (Hospital) | Ventura | Ventura County | 194 | Layoff Permanent |
9179 | 9179 | 11/01/2019 | 01/06/2020 | 11/14/2019 | Ironwood Management | Woodland Hills | Los Angeles County | 87 | Closure Permanent |
9181 | 9181 | 11/05/2019 | 01/06/2020 | 11/14/2019 | Marvell Semiconductor, Inc. | Santa Clara | Santa Clara County | 6 | Layoff Permanent |
9190 | 9190 | 11/04/2019 | 01/06/2020 | 11/06/2019 | VHG Santa Monica, LLC | Santa Monica | Los Angeles County | 50 | Layoff Temporary |
1388 | 1388 | 10/28/2020 | 01/06/2021 | 11/18/2020 | Craft Beer Guild Distributing | Cerritos | Los Angeles County | 68 | Closure Permanent |
1812 | 1812 | 01/14/2021 | 01/06/2021 | 02/19/2021 | Wells Fargo | San Francisco | San Francisco County | 3 | Layoff Permanent |
4291 | 4291 | 11/13/2014 | 01/07/2015 | 11/21/2014 | ITT Canon LLC | Santa Ana | 5 | Layoff Permanent | |
2085 | 2085 | 11/04/2015 | 01/07/2016 | 11/05/2015 | JC Entertainment Lighting Services, Inc. | Sun Valley | 169 | Layoff Permanent | |
3626 | 3626 | 11/04/2016 | 01/07/2016 | 11/10/2016 | FoodsCo Store | Redwood City | 69 | Closure Unknown at this time | |
3624 | 3624 | 11/07/2016 | 01/07/2017 | 11/08/2016 | Western Health Resources (Western | San Diego | 120 | Closure Permanent | |
9693 | 9693 | 12/28/2017 | 01/07/2018 | 12/29/2017 | Rubio Arts Corporation | Anaheim | Orange County | 5 | Layoff Permanent |
9806 | 9806 | 11/07/2017 | 01/07/2018 | 02/26/2018 | Zodiac Seats California LLC | Rancho | San Bernardino | 186 | Closure Permanent |
2836 | 2836 | 11/01/2018 | 01/07/2019 | 11/13/2018 | North American Services Inc. dba Command | Simi Valley | Ventura County | 26 | Closure Permanent |
9175 | 9175 | 11/08/2019 | 01/07/2020 | 11/15/2019 | Hard Rock Cafe International (USA), Inc. | Universal City | Los Angeles County | 136 | Closure Permanent |
1689 | 1689 | 12/21/2020 | 01/07/2021 | 01/13/2021 | Hartwell Corporation | Rancho Cucamonga | San Bernardino County | 49 | Layoff Temporary |
1816 | 1816 | 01/07/2021 | 01/07/2021 | 02/22/2021 | Intercontinental Hotel-Los Angeles Downtown | Los Angeles | Los Angeles County | 46 | Layoff Temporary |
2092 | 2092 | 11/09/2015 | 01/08/2016 | 11/10/2015 | Hyundai Capital America | Irvine | 41 | Layoff Permanent | |
9573 | 9573 | 10/19/2017 | 01/08/2018 | 10/20/2017 | Capital One, N.A. | San Francisco | San Francisco | 132 | Layoff Permanent |
9619 | 9619 | 11/07/2017 | 01/08/2018 | 11/07/2017 | Robert Talbott Inc. | Monterey | Monterey County | 38 | Layoff Permanent |
9620 | 9620 | 11/07/2017 | 01/08/2018 | 11/07/2017 | Telltale, Inc. | San Rafael | Marin County | 90 | Layoff Permanent |
9627 | 9627 | 11/03/2017 | 01/08/2018 | 11/13/2017 | Zenith Education Group (Zenith) | Santa Ana | Orange County | 29 | Layoff Permanent |
9703 | 9703 | 01/05/2018 | 01/08/2018 | 01/08/2018 | Smurfit Kappa North America, LLC | City of Industry | Los Angeles | 155 | Layoff Permanent |
2832 | 2832 | 11/07/2018 | 01/08/2019 | 11/08/2018 | Broadcom Inc. | Santa Clara | Santa Clara | 119 | Layoff Permanent |
1362 | 1362 | 11/06/2020 | 01/08/2020 | 11/17/2020 | Makita U.S.A., Inc. | La Mirada | Los Angeles County | 17 | Closure Permanent |
9112 | 9112 | 01/08/2020 | 01/08/2020 | 01/09/2020 | Marshall Freight Inc | Irvine | Orange County | 4 | Closure Permanent |
9168 | 9168 | 11/06/2019 | 01/08/2020 | 11/19/2019 | Brinker International Payroll Company, L.P. | Arroyo Grande | San Luis Obispo County | 44 | Closure Permanent |
1360 | 1360 | 11/05/2020 | 01/08/2021 | 11/17/2020 | California Institute of Technology | Pasadena | Los Angeles County | 1 | Layoff Temporary |
1361 | 1361 | 11/05/2020 | 01/08/2021 | 11/17/2020 | California Institute of Technology | Pasadena | Los Angeles County | 87 | Layoff Permanent |
1661 | 1661 | 01/08/2021 | 01/08/2021 | 01/12/2021 | Hyatt Corporation - Andaz West Hollywood | West Hollywood | Los Angeles County | 4 | Layoff Temporary |
1662 | 1662 | 01/08/2021 | 01/08/2021 | 01/12/2021 | Hyatt Corporation - Hyatt Centric, The Pike Beach | Long Beach | Los Angeles County | 1 | Layoff Temporary |
1671 | 1671 | 12/30/2020 | 01/08/2021 | 01/12/2021 | Hyatt Corporation- Hyatt | San Diego | San Diego County | 4 | Layoff Temporary |
1735 | 1735 | 01/08/2021 | 01/08/2021 | 01/21/2021 | InterContinental Mark Hopkins San Francisco | San Francisco | San Francisco County | 54 | Layoff Temporary |
1737 | 1737 | 01/15/2021 | 01/08/2021 | 01/21/2021 | Wyndham Vacation Ownership | Windsor | Sonoma County | 67 | Layoff Temporary |
4316 | 4316 | 11/11/2014 | 01/09/2015 | 12/16/2014 | PROVIDENCE HEALTH AND | Torrance | 59 | Closure Unknown at this time | |
2139 | 2139 | 11/12/2015 | 01/09/2016 | 12/10/2015 | abercrombie kids | Milpitas | 41 | Closure Permanent | |
3625 | 3625 | 11/08/2016 | 01/09/2017 | 11/08/2016 | Meggitt (North Hollywood), Inc. | Corona | 96 | Closure Permanent | |
3627 | 3627 | 11/09/2016 | 01/09/2017 | 11/10/2016 | QuinStreet | Foster City | 57 | Layoff Permanent | |
3701 | 3701 | 10/21/2016 | 01/09/2017 | 01/10/2017 | National Steel and Shipbuilding | San Diego | 844 | Layoff Permanent | |
3753 | 3753 | 01/26/2017 | 01/09/2017 | 01/27/2017 | DoubleDutch, Inc. | San Francisco | 57 | Layoff Permanent | |
9654 | 9654 | 11/17/2017 | 01/09/2018 | 11/28/2017 | The Boeing Company | El Segundo | Los Angeles | 1 | Layoff Permanent |
1728 | 1728 | 01/13/2021 | 01/09/2021 | 01/20/2021 | Renaissance Hotel Operating co. | Indian Wells | Riverside County | 70 | Layoff Temporary |
4275 | 4275 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros - Shed Media USA | Los Angeles | 1 | Layoff Permanent | |
4276 | 4276 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Burbank Television | Burbank | 6 | Layoff Permanent | |
4277 | 4277 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Consumer Products | Burbank | 4 | Layoff Permanent | |
4278 | 4278 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Distributing | Burbank | 17 | Layoff Permanent | |
4279 | 4279 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Distributing | Encino | 4 | Layoff Permanent | |
4280 | 4280 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Entertainment | Burbank | 13 | Layoff Permanent | |
4281 | 4281 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Home Entertainment | Burbank | 46 | Layoff Permanent | |
4282 | 4282 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. International Television | Burbank | 9 | Layoff Permanent | |
4283 | 4283 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Pictures | Burbank | 1 | Layoff Permanent | |
4284 | 4284 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Studio Facilities | Burbank | 24 | Layoff Permanent | |
4285 | 4285 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Technical Operations | Burbank | 11 | Layoff Permanent | |
4286 | 4286 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Television | Los Angeles | 4 | Layoff Permanent | |
4287 | 4287 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Theatrical Enterprises | Burbank | 6 | Layoff Permanent | |
4288 | 4288 | 11/04/2014 | 01/10/2015 | 11/20/2014 | Warner Bros. Worldwide Television | Burbank | 5 | Layoff Permanent | |
4289 | 4289 | 11/04/2014 | 01/10/2015 | 11/20/2014 | WBTV Distribution Inc | Burbank | 1 | Layoff Permanent | |
4301 | 4301 | 11/04/2014 | 01/10/2015 | 12/02/2014 | WCI Global Business Services Inc - | Burbank | 12 | Layoff Permanent | |
9204 | 9204 | 11/01/2019 | 01/10/2020 | 11/01/2019 | American General Life Insurance Company | Pasadena | Los Angeles County | 40 | Closure Permanent |
1511 | 1511 | 11/10/2020 | 01/10/2021 | 12/21/2020 | Kaiser Foundation Hospitals - Corona Data Center Admin | Corona | Riverside County | 4 | Layoff Permanent |
1522 | 1522 | 11/10/2020 | 01/10/2021 | 12/22/2020 | Kaiser Foundation Hospitals - Pleasanton Tech Center, Bldg. A | Pleasanton | Alameda County | 71 | Layoff Permanent |
1523 | 1523 | 11/10/2020 | 01/10/2021 | 12/22/2020 | Kaiser Foundation Hospitals - Via Monte | Walnut Creek | Contra Costa County | 4 | Layoff Permanent |
1524 | 1524 | 11/10/2020 | 01/10/2021 | 12/22/2020 | Kaiser Foundation Hospitals - Burbank Administration | Woodland Hills | Los Angeles County | 1 | Layoff Permanent |
1525 | 1525 | 11/10/2020 | 01/10/2021 | 12/22/2020 | Kaiser Foundation Hospitals - California Service Center | San Diego | San Diego County | 3 | Layoff Permanent |
4244 | 4244 | 10/15/2014 | 01/11/2015 | 10/29/2014 | Kmart | El Centro | 75 | Closure Permanent | |
2093 | 2093 | 11/10/2015 | 01/11/2016 | 11/12/2015 | SWAY Management LLC | Oakland | 102 | Layoff Permanent | |
2144 | 2144 | 12/11/2015 | 01/11/2016 | 12/11/2015 | PPG Industries | Fresno | 45 | Closure Temporary | |
2833 | 2833 | 10/22/2018 | 01/11/2019 | 11/09/2018 | Adventist Health Feather River | Paradise | Butte County | 11 | Layoff Permanent |
1398 | 1398 | 11/10/2020 | 01/11/2020 | 11/18/2020 | CSAA Insurance Group | Fairfield | Solano County | 18 | Closure Permanent |
9106 | 9106 | 01/08/2020 | 01/11/2020 | 01/10/2020 | Adventist Health St. Helena | Saint Helena | Napa County | 18 | Closure Permanent |
9164 | 9164 | 11/12/2019 | 01/11/2020 | 11/20/2019 | Singularity Education Group | Santa Clara | Santa Clara County | 62 | Layoff Permanent |
1406 | 1406 | 11/06/2020 | 01/11/2021 | 11/19/2020 | Southwest Airlines - Norman Y. Mineta San Jose International Airport | San Jose | Santa Clara County | 1 | Layoff Temporary |
1419 | 1419 | 11/16/2020 | 01/11/2021 | 11/23/2020 | Adventist Health Home Care | Chico | Butte County | 14 | Closure Permanent |
1631 | 1631 | 12/11/2020 | 01/11/2021 | 01/08/2021 | Paradise Point Resort | San Diego | San Diego County | 86 | Layoff Temporary |
2178 | 2178 | 01/04/2016 | 01/12/2016 | 01/04/2016 | Walnut Creek Pyramid Alehouse | Walnut Creek | 49 | Closure Unknown at this time | |
3737 | 3737 | 01/11/2017 | 01/12/2017 | 01/17/2017 | SunEdison, Inc. | Belmont | 2 | Layoff Permanent | |
1348 | 1348 | 11/05/2020 | 01/12/2021 | 11/16/2020 | Eaton | Santa Ana | Orange County | 111 | Closure Permanent |
1817 | 1817 | 01/18/2021 | 01/12/2021 | 02/22/2021 | The Estate Yountville | Yountville | Napa County | 27 | Layoff Permanent |
3585 | 3585 | 10/17/2016 | 01/13/2017 | 10/19/2016 | Shire | Los Angeles | 360 | Layoff Permanent | |
3681 | 3681 | 10/19/2016 | 01/13/2017 | 12/20/2016 | Ryder | Rialto | 28 | Layoff Permanent | |
3731 | 3731 | 01/12/2017 | 01/13/2017 | 01/13/2017 | Pandora Media, Inc. | Oakland | 91 | Layoff Permanent | |
2850 | 2850 | 11/14/2018 | 01/13/2019 | 11/14/2018 | Production Resource Group, LLC and Full | Glendale | Los Angeles | 339 | Layoff Permanent |
9066 | 9066 | 01/27/2020 | 01/13/2020 | 01/27/2020 | Safran Cabin Galleys US, Inc. | Huntington Beach | Orange County | 180 | Layoff Permanent |
9172 | 9172 | 11/12/2019 | 01/13/2020 | 11/18/2019 | Teradata Corporation | San Diego | San Diego County | 80 | Layoff Permanent |
1373 | 1373 | 11/12/2020 | 01/13/2021 | 11/17/2020 | Collins Aerospace | Chula Vista | San Diego County | 48 | 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 );