california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Notice Date
This data as json, copyable, CSV (advanced)
Suggested facets: Layoff/Closure
Link | rowid | Notice Date ▼ | Effective Date | Received Date | Company | City | County | Employees | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
2934 | 2934 | 01/01/2019 | 03/14/2019 | 01/11/2019 | McCain Foods, Inc. | Colton | San Bernardino | 100 | Closure Permanent |
3694 | 3694 | 01/02/2017 | 03/06/2017 | 01/03/2017 | TGI Friday's | Yorba Linda | 42 | Closure Permanent | |
4376 | 4376 | 01/03/2015 | 03/06/2015 | 01/08/2015 | Boeing Company | Long Beach | 23 | Layoff Unknown at this time | |
3695 | 3695 | 01/03/2017 | 03/06/2017 | 01/04/2017 | CKE Restaurants Holdings, Inc. | Carpinteria | 25 | Closure Permanent | |
9697 | 9697 | 01/03/2018 | 03/06/2018 | 01/05/2018 | Act-On Software, Inc. | Roseville | Placer County | 96 | Closure Permanent |
2929 | 2929 | 01/03/2019 | 01/03/2019 | 01/03/2019 | Finance of America Holdings LLC | Roseville | Placer County | 33 | Closure Permanent |
9113 | 9113 | 01/03/2020 | 03/06/2020 | 01/09/2020 | Medtronic, Inc. | Goleta | Santa Barbara County | 33 | Layoff Permanent |
9116 | 9116 | 01/03/2020 | 03/04/2020 | 01/03/2020 | Aramark Services, Inc. | Anaheim | Orange County | 9 | Closure Permanent |
9117 | 9117 | 01/03/2020 | 03/04/2020 | 01/03/2020 | Aramark Services, Inc. | Rancho SantaMargarita | Orange County | 13 | Closure Permanent |
2178 | 2178 | 01/04/2016 | 01/12/2016 | 01/04/2016 | Walnut Creek Pyramid Alehouse | Walnut Creek | 49 | Closure Unknown at this time | |
2186 | 2186 | 01/04/2016 | 03/09/2016 | 01/07/2016 | Adecco Group NA | Palo Alto | 108 | Closure Permanent | |
2189 | 2189 | 01/04/2016 | 03/05/2016 | 01/11/2016 | Thomson Licensing LLC | Burbank | 7 | Closure Unknown at this time | |
3696 | 3696 | 01/04/2017 | 03/06/2017 | 01/06/2017 | Macy's | Santa Barbara | 96 | Closure Permanent | |
3697 | 3697 | 01/04/2017 | 03/06/2017 | 01/09/2017 | Macy's | San Diego | 193 | Closure Permanent | |
3698 | 3698 | 01/04/2017 | 03/06/2017 | 01/09/2017 | Macy's | San Francisco | 16 | Closure Permanent | |
3716 | 3716 | 01/04/2017 | 03/04/2017 | 01/13/2017 | Atmel Corporation | San Jose | 9 | Layoff Permanent | |
9698 | 9698 | 01/04/2018 | 01/04/2018 | 01/05/2018 | GoPro, Inc. | San Mateo | San Mateo County | 140 | Layoff Permanent |
9699 | 9699 | 01/04/2018 | 04/01/2018 | 01/05/2018 | Adventist Health (Hanford) | Hanford | Kings County | 205 | Layoff Permanent |
9700 | 9700 | 01/04/2018 | 04/01/2018 | 01/05/2018 | Adventist Health (Reedley and Selma) | Reedley | Fresno County | 115 | 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 |
9716 | 9716 | 01/04/2018 | 03/18/2018 | 01/10/2018 | Kmart Corporation | Cudahy | Los Angeles | 117 | Closure Permanent |
9717 | 9717 | 01/04/2018 | 03/18/2018 | 01/10/2018 | Sears Holdings Corporation | San Jose | Santa Clara | 76 | Closure Permanent |
9718 | 9718 | 01/04/2018 | 03/18/2018 | 01/10/2018 | Sears Holdings Corporation | Valencia | Los Angeles | 67 | Closure Permanent |
9719 | 9719 | 01/04/2018 | 04/08/2018 | 01/10/2018 | Kmart Corporation | Redding | Shasta County | 72 | Closure Permanent |
9720 | 9720 | 01/04/2018 | 04/08/2018 | 01/10/2018 | Kmart Corporation (Store #04749) | Ontario | San Bernardino | 79 | Closure Permanent |
9721 | 9721 | 01/04/2018 | 04/08/2018 | 01/10/2018 | Sears Holdings Corporation | Brea | Orange County | 72 | Closure Permanent |
9722 | 9722 | 01/04/2018 | 04/08/2018 | 01/10/2018 | Sears Holdings Corporation | Westminster | Orange County | 88 | Closure Permanent |
1627 | 1627 | 01/04/2021 | 01/04/2021 | 01/08/2021 | Auberge Du Soleil | Rutherford | Napa County | 159 | Closure Temporary |
1677 | 1677 | 01/04/2021 | 03/02/2021 | 01/12/2021 | McAfee, LLC | Alviso | Santa Clara County | 137 | Layoff Permanent |
1757 | 1757 | 01/04/2021 | 01/04/2021 | 01/26/2021 | Television City Services, LLC | Los Angeles | Los Angeles County | 40 | Layoff Temporary |
4372 | 4372 | 01/05/2015 | 03/06/2015 | 01/05/2015 | RadioShack Corporation | Woodland | 57 | Closure Permanent | |
4378 | 4378 | 01/05/2015 | 03/05/2015 | 01/09/2015 | ITT Cannon LLC | Santa Ana | 12 | Layoff Permanent | |
2190 | 2190 | 01/05/2016 | 03/07/2016 | 01/11/2016 | AT&T | San Ramon | 2 | Layoff Permanent | |
9701 | 9701 | 01/05/2018 | 03/05/2018 | 01/05/2018 | Schneider Electric | Clovis | Fresno County | 9 | Layoff Permanent |
9702 | 9702 | 01/05/2018 | 04/01/2018 | 01/05/2018 | Adventist Health St. Helena | Saint Helena | Napa County | 200 | 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 |
9705 | 9705 | 01/05/2018 | 12/04/2017 | 01/09/2018 | Creation Technologies | Milpitas | Santa Clara | 177 | Closure Permanent |
9706 | 9706 | 01/05/2018 | 01/05/2018 | 01/09/2018 | Activision Publishing, Inc. (Activision) | Fresno | Fresno County | 50 | Closure Permanent |
9707 | 9707 | 01/05/2018 | 03/18/2018 | 01/09/2018 | Macys | Laguna Hills | Orange County | 111 | Closure Permanent |
9708 | 9708 | 01/05/2018 | 03/18/2018 | 01/09/2018 | Macys | Los Angeles | Los Angeles | 128 | Closure Permanent |
9709 | 9709 | 01/05/2018 | 03/18/2018 | 01/09/2018 | Macys | San Francisco | San Francisco | 197 | Closure Permanent |
9710 | 9710 | 01/05/2018 | 04/01/2018 | 01/09/2018 | Adventist Health Simi Valley (Adventist Health) | Simi Valley | Ventura County | 70 | Closure Permanent |
9733 | 9733 | 01/05/2018 | 04/01/2018 | 01/12/2018 | Adventist Health Feather River | Paradise | Butte County | 72 | Closure Permanent |
1629 | 1629 | 01/05/2021 | 03/14/2021 | 01/08/2021 | Macy's Inc. | El Cajon | San Diego County | 103 | Closure Permanent |
1635 | 1635 | 01/05/2021 | 03/31/2021 | 01/08/2021 | Olympia Medical Center | Los Angeles | Los Angeles County | 451 | Closure Permanent |
1642 | 1642 | 01/05/2021 | 03/14/2021 | 01/11/2021 | Bloomingdale's - Santa Monica | Santa Monica | Los Angeles County | 97 | Closure 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 |
1752 | 1752 | 01/05/2021 | 01/05/2020 | 01/22/2021 | Hard Rock Hotel San Diego | San Diego | San Diego County | 27 | Layoff Temporary |
4384 | 4384 | 01/06/2015 | 03/09/2015 | 01/13/2015 | Southern California Edison Company | San Clemente | 45 | Closure Permanent | |
2187 | 2187 | 01/06/2016 | 03/14/2016 | 01/07/2016 | Macy's Country Club Plaza Store | Sacramento | 111 | Closure Permanent | |
2188 | 2188 | 01/06/2016 | 03/14/2016 | 01/07/2016 | Macy's Irvine Spectrum Store | Irvine | 112 | Closure Permanent | |
2216 | 2216 | 01/06/2016 | 03/07/2016 | 01/20/2016 | Citrix Systems, Inc. | Santa Clara | 65 | Layoff Permanent | |
3699 | 3699 | 01/06/2017 | 01/28/2017 | 01/09/2017 | Verizon Wireless | Rancho Cordova | 1070 | Layoff Permanent | |
3702 | 3702 | 01/06/2017 | 02/22/2017 | 01/10/2017 | GKN Aerospace Chem-tronics, Inc. DBA | Santa Ana | 15 | Layoff Permanent | |
3717 | 3717 | 01/06/2017 | 03/08/2017 | 01/13/2017 | Theranos, Inc. | Newark | 53 | Layoff Permanent | |
3718 | 3718 | 01/06/2017 | 03/08/2017 | 01/13/2017 | Theranos, Inc. | Palo Alto | 97 | Layoff Permanent | |
9114 | 9114 | 01/06/2020 | 03/07/2020 | 01/08/2020 | Edmunds.com, Inc. | Santa Monica | Los Angeles County | 122 | Layoff Permanent |
9115 | 9115 | 01/06/2020 | 03/09/2020 | 01/06/2020 | SunSelect Produce (California) Inc. | Tehachapi | Kern County | 236 | Closure Permanent |
1607 | 1607 | 01/06/2021 | 11/29/2020 | 01/06/2021 | Hollywood Park Casino Company | Inglewood | Los Angeles County | 328 | Layoff Temporary |
1644 | 1644 | 01/06/2021 | 03/09/2121 | 01/11/2021 | Dexcom, Inc. | San Diego | San Diego County | 178 | Layoff Permanent |
1660 | 1660 | 01/06/2021 | 11/28/2020 | 01/11/2021 | Real Farming, LLC | Oxnard | Ventura County | 174 | Layoff Temporary |
1672 | 1672 | 01/06/2021 | 03/06/2021 | 01/12/2021 | HII Fleet Sustainment | San Diego | San Diego County | 54 | Layoff Permanent |
1680 | 1680 | 01/06/2021 | 03/08/2021 | 01/12/2021 | Ormco/SPARK | Pomona | Los Angeles County | 235 | Layoff Permanent |
1708 | 1708 | 01/06/2021 | 03/07/2021 | 01/14/2021 | SyncTruck LLC | West Sacramento | Yolo County | 87 | Layoff Permanent |
1756 | 1756 | 01/06/2021 | 03/31/2021 | 01/26/2021 | BH White Corporation dba The Grill on the Alley | Beverly Hills | Los Angeles County | 74 | Layoff Permanent |
4377 | 4377 | 01/07/2015 | 03/10/2015 | 01/08/2015 | Brice Manufacturing Company, Inc | Pacoima | 61 | Layoff Permanent | |
4379 | 4379 | 01/07/2015 | 04/03/2015 | 01/09/2015 | ASCO Power Technologies | Stockton | 104 | Closure Permanent | |
2930 | 2930 | 01/07/2019 | 03/08/2019 | 01/08/2019 | Theravance Biopharma US, Inc. | Los Angeles | Los Angeles | 1 | Layoff Permanent |
2931 | 2931 | 01/07/2019 | 03/08/2019 | 01/08/2019 | Theravance Biopharma US, Inc. | South San | San Mateo County | 49 | Layoff Permanent |
9071 | 9071 | 01/07/2020 | 03/09/2020 | 01/24/2020 | Atrium LTS | San Francisco | San Francisco County | 76 | Layoff Unknown at thistime |
9078 | 9078 | 01/07/2020 | 03/15/2020 | 01/22/2020 | Transform SR LLC - 01088 | Glendale | Los Angeles County | 91 | Closure Permanent |
9091 | 9091 | 01/07/2020 | 03/06/2020 | 01/15/2020 | GILDAN DISTRIBUTION, INC. | Mira Loma | Riverside County | 121 | Closure Permanent |
1646 | 1646 | 01/07/2021 | 03/08/2021 | 01/11/2021 | Kinkisharyo International, LLC | Palmdale | Los Angeles County | 9 | Layoff Permanent |
1663 | 1663 | 01/07/2021 | 12/12/2020 | 01/12/2021 | Marriott Hotel Services, Inc. dba JW Marriott Desert Springs Resort & Spa | Palm Desert | Riverside County | 169 | Layoff Temporary |
1675 | 1675 | 01/07/2021 | 03/12/2021 | 01/12/2021 | TJX Companies, Inc. - Marshalls | San Francisco | San Francisco County | 84 | Closure Permanent |
1682 | 1682 | 01/07/2021 | 03/10/2021 | 01/12/2021 | SPS Ventures, Inc. | Thousand Oaks | Ventura County | 74 | Closure Permanent |
1816 | 1816 | 01/07/2021 | 01/07/2021 | 02/22/2021 | Intercontinental Hotel-Los Angeles Downtown | Los Angeles | Los Angeles County | 46 | Layoff Temporary |
4380 | 4380 | 01/08/2015 | 03/08/2015 | 01/09/2015 | Genco | Woodland | 50 | Closure Permanent | |
4381 | 4381 | 01/08/2015 | 03/16/2015 | 01/09/2015 | Macy's Furniture Gallery | Woodland Hills | 19 | Closure Unknown at this time | |
4382 | 4382 | 01/08/2015 | 03/21/2015 | 01/09/2015 | Macy's Vallco Shopping Mall | Cupertino | 107 | Closure Unknown at this time | |
4383 | 4383 | 01/08/2015 | 03/16/2015 | 01/12/2015 | Macy's Westfield Promenade Store | Woodland Hills | 109 | Closure Permanent | |
4388 | 4388 | 01/08/2015 | 03/09/2015 | 01/14/2015 | Rabobank, N.A. | Imperial | 79 | Closure Unknown at this time | |
2193 | 2193 | 01/08/2016 | 03/31/2016 | 01/13/2016 | Zodiac Pool Systems, Inc. | Vista | 52 | Closure Permanent | |
9711 | 9711 | 01/08/2018 | 03/09/2018 | 01/09/2018 | Mellanox Technologies Silicon Photonics, Inc. | Monterey Park | Los Angeles | 98 | Closure Permanent |
2950 | 2950 | 01/08/2019 | 03/09/2019 | 01/23/2019 | Wag Labs, Inc. | Los Angeles | Los Angeles | 38 | Closure Permanent |
2960 | 2960 | 01/08/2019 | 02/05/2019 | 01/25/2019 | Adventist Health Feather River | Paradise | Butte County | 1331 | Closure Temporary |
9068 | 9068 | 01/08/2020 | 03/08/2020 | 01/27/2020 | Golden Gate National Parks Conservancy | San Francisco | San Francisco County | 28 | Layoff Permanent |
9069 | 9069 | 01/08/2020 | 03/07/2020 | 01/27/2020 | Adventist Health | Sonora | Tuolumne County | 48 | Layoff Permanent |
9092 | 9092 | 01/08/2020 | 03/08/2020 | 01/15/2020 | Corning Research and DevelopmentCorporation | Santa Barbara | Santa Barbara County | 72 | Layoff Permanent |
9093 | 9093 | 01/08/2020 | 03/07/2020 | 01/14/2020 | Adventist Health Lodi Memorial | Lodi | San Joaquin County | 86 | Closure Permanent |
9096 | 9096 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Reedley | Reedley | Fresno County | 44 | Closure Permanent |
9097 | 9097 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Tehachapi Valley | Tehachapi | Kern County | 14 | Closure Permanent |
9098 | 9098 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Bakersfield | Bakersfield | Kern County | 33 | Closure Permanent |
9099 | 9099 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Hanford | Hanford | Kings County | 152 | Closure Permanent |
9100 | 9100 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health White Memorial | Los Angeles | Los Angeles County | 48 | Closure Permanent |
9101 | 9101 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Howard Memorial | Willits | Mendocino County | 20 | Closure Permanent |
9102 | 9102 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health and Rideout United Com-Serve | Yuba City | Sutter County | 21 | Closure Permanent |
9103 | 9103 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Tulare | Tulare | Tulare County | 45 | Closure Permanent |
9104 | 9104 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health Simi Valley | Simi Valley | Ventura County | 7 | Closure Permanent |
9105 | 9105 | 01/08/2020 | 03/07/2020 | 01/13/2020 | Adventist Health and Rideout | Marysville | Yuba County | 80 | Closure 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 );