california_warn_raw

Table actions
Big Local News is collecting and updating WARN (layoff/furlough) notices from state government sites and is processing the data to make it more useable. So far, we are collecting and updating daily or weekly data from 36 states. A federal law -- the WARN Act (Worker Adjustment and Retraining Notification Act) requires companies with more than 100 employees to give 60 days notice of any layoff, closure or furlough and 17 states have their own similar statutes. This data provides much more granularity into the types of jobs being lost and the companies that are furloughing workers, or that plan to close completely. A key note is that "unforeseen business circumstances" can mean that a company doesn't have to provide 60 days notice. For example, California has lifted that level of notice for its state version, or mini-WARN Act. Nonetheless, even though the advance time limit is flexible, companies still have to submit. Please cite the WARN data as collected by Big Local News. California data can be cited as collected and processed by Stanford journalism student Vanessa Ochavillo. This project includes a general README, a more specific README for California and a more specific file layout README that details the fields by state. Some states are missing but we are working to obtain the data or build scrapers. If you are interested in contributing, please let us know at biglocalnews@stanford.edu.

Data source: Big Local News · About: big-local-datasette

10,033 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ Notice Date Effective Date Received Date Company City County Employees Layoff/Closure
9933 9933 04/30/2018 07/02/2018 05/03/2018 C and D Zodiac, Inc. Garden Grove Orange County 13 Layoff Permanent
9932 9932 04/27/2018 06/29/2018 05/03/2018 AMETEK Inc. Irvine Orange County 42 Closure Permanent
9931 9931 04/27/2018 04/27/2018 05/03/2018 VSolvit LLC Ventura Ventura County 107 Layoff Permanent
9930 9930 04/26/2018 06/29/2018 05/03/2018 Frederick K.C. Price III Christian Schools Los Angeles Los Angeles 46 Closure Permanent
9929 9929 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company West Yolo County 4 Closure Permanent
9928 9928 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Watsonville Santa Cruz 1 Closure Permanent
9927 9927 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Turlock Stanislaus County 1 Closure Permanent
9926 9926 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Santa Maria Santa Barbara 1 Closure Permanent
9925 9925 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Santa Fe Los Angeles 5 Closure Permanent
9924 9924 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company San Diego San Diego County 1 Closure Permanent
9923 9923 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Ontario San Bernardino 6 Closure Permanent
9922 9922 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Hayward Alameda County 2 Closure Permanent
9921 9921 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Fresno Fresno County 3 Closure Permanent
9920 9920 04/18/2018 06/21/2018 05/02/2018 Boyd Coffee Company Arleta Los Angeles 2 Closure Permanent
9919 9919 04/30/2018 03/18/2019 05/01/2018 WWF Operating Company, LLC American Napa County 72 Closure Permanent
9918 9918 04/25/2018 06/25/2018 05/01/2018 Earl of Sandwich (Anaheim), LLC Anaheim Orange County 69 Closure Permanent
9917 9917 04/25/2018 06/22/2018 05/01/2018 Wells Fargo Rancho San Bernardino 58 Closure Unknown at this time
9916 9916 04/23/2018 05/17/2018 05/01/2018 Charter Communications Cerritos Los Angeles 66 Layoff Permanent
9915 9915 04/12/2018 06/13/2018 05/01/2018 SYR Service Company, LLC Montecito Santa Barbara 161 Layoff Permanent
9914 9914 04/25/2018 06/30/2018 04/27/2018 SMA Solar Technology America, LLC Rocklin Placer County 51 Layoff Permanent
9913 9913 04/23/2018 07/01/2018 04/26/2018 Diversified Silicone Products, Inc. Santa Fe Los Angeles 68 Closure Permanent
9912 9912 04/13/2018 06/18/2018 04/26/2018 LuLaRoe Fontana San Bernardino 127 Layoff Permanent
9911 9911 04/19/2018 06/29/2018 04/25/2018 Options For Youth Public San Gabriel Charter Los Angeles Los Angeles 19 Layoff Unknown at this time
9910 9910 04/19/2018 06/29/2018 04/25/2018 Options For Youth Public San Gabriel Charter Irwindale Los Angeles 49 Layoff Unknown at this time
9909 9909 04/19/2018 06/29/2018 04/25/2018 Options For Youth Public San Gabriel Charter Chino San Bernardino 33 Layoff Unknown at this time
9908 9908 04/02/2018 09/01/2018 04/25/2018 Curvature Wheatland Yuba County 1 Layoff Permanent
9907 9907 04/02/2018 06/08/2018 04/25/2018 Curvature Wallace Calaveras County 1 Layoff Permanent
9906 9906 04/02/2018 05/18/2018 04/25/2018 Curvature Sacramento Sacramento 3 Layoff Permanent
9905 9905 04/02/2018 04/27/2018 04/25/2018 Curvature Fresno Fresno County 1 Layoff Permanent
9904 9904 02/05/2018 04/13/2018 04/25/2018 CKE Restaurant Holdings, Inc. Anaheim Orange County 173 Layoff Unknown at this time
9903 9903 04/02/2018 09/01/2018 04/24/2018 Curvature Pittsburg Contra Costa 2 Layoff Permanent
9902 9902 04/02/2018 05/18/2018 04/24/2018 Curvature Riverside Riverside County 1 Layoff Permanent
9901 9901 04/02/2018 05/18/2018 04/24/2018 Curvature Fairfield Solano County 1 Layoff Permanent
9900 9900 04/02/2018 04/27/2018 04/24/2018 Curvature Roseville Placer County 1 Layoff Permanent
9899 9899 04/02/2018 04/02/2018 04/24/2018 Curvature Livermore Alameda County 20 Layoff Permanent
9898 9898 10/09/2017 12/11/2017 04/24/2018 Pacific Alliance Medical Center Los Angeles Los Angeles 750 Closure Permanent
9897 9897 04/02/2018 09/21/2018 04/23/2018 Curvature Garden Grove Orange County 3 Layoff Permanent
9896 9896 04/02/2018 09/01/2018 04/23/2018 Curvature Northridge Los Angeles 1 Layoff Permanent
9895 9895 04/02/2018 09/01/2018 04/23/2018 Curvature Escondido San Diego County 3 Layoff Permanent
9894 9894 04/02/2018 09/01/2018 04/23/2018 Curvature Duarte Los Angeles 1 Layoff Permanent
9893 9893 04/02/2018 04/27/2018 04/23/2018 Curvature Stockton San Joaquin 3 Layoff Permanent
9892 9892 04/02/2018 04/27/2018 04/23/2018 Curvature Diamond Bar Los Angeles 1 Layoff Permanent
9891 9891 04/02/2018 04/02/2018 04/23/2018 Curvature Norwalk Los Angeles 2 Layoff Permanent
9890 9890 04/02/2018 04/02/2018 04/23/2018 Curvature Chino San Bernardino 26 Layoff Permanent
9889 9889 04/18/2018 06/19/2018 04/19/2018 Qualcomm Incorporated Santa Clara Santa Clara 100 Layoff Unknown at this time
9888 9888 04/18/2018 06/19/2018 04/19/2018 Qualcomm Incorporated San Jose Santa Clara 169 Layoff Unknown at this time
9887 9887 04/18/2018 06/19/2018 04/19/2018 Qualcomm Incorporated San Diego San Diego County 1231 Layoff Unknown at this time
9886 9886 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation Roseville Placer County 64 Closure Permanent
9885 9885 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation Fairfield Solano County 80 Closure Permanent
9884 9884 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation Fairfield Solano County 9 Closure Permanent
9883 9883 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation El Cajon San Diego County 104 Closure Permanent
9882 9882 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation El Cajon San Diego County 11 Closure Permanent
9881 9881 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation Citrus Heights Sacramento 67 Closure Permanent
9880 9880 04/12/2018 07/08/2018 04/19/2018 Sears Holdings Corporation Citrus Heights Sacramento 9 Closure Permanent
9879 9879 04/13/2018 06/17/2018 04/18/2018 Rainforest Cafe, Inc. Anaheim Orange County 356 Closure Permanent
9878 9878 04/16/2018 06/15/2018 04/17/2018 Roth Staffing Companies, L.P., dba Ultimate Irvine Orange County 128 Layoff Permanent
9877 9877 04/13/2018 06/15/2018 04/17/2018 Nestle USA, Inc. Oakland Alameda County 2 Layoff Permanent
9876 9876 04/13/2018 06/15/2018 04/17/2018 Nestle USA, Inc. Glendale Los Angeles 52 Closure Permanent
9875 9875 04/12/2018 07/14/2018 04/17/2018 C and D Zodiac, Inc. Garden Grove Orange County 12 Closure Permanent
9874 9874 04/12/2018 03/20/2018 04/16/2018 Molina Healthcare, Inc. Sacramento Sacramento 4 Layoff Permanent
9873 9873 04/12/2018 03/20/2018 04/16/2018 Molina Healthcare of California and Molina Long Beach Los Angeles 75 Layoff Permanent
9872 9872 02/06/2018 06/01/2018 04/16/2018 Gateway One Lending and Finance, LLC Anaheim Orange County 30 Layoff Permanent
9871 9871 04/12/2018 04/12/2018 04/13/2018 Esterline Power Systems, Leach International Buena Park Orange County 46 Layoff Permanent
9870 9870 04/11/2018 06/15/2018 04/13/2018 Four Seasons General Merchandise, Inc. Los Angeles Los Angeles 150 Closure Permanent
9869 9869 04/11/2018 06/15/2018 04/11/2018 Hecny Transportation, Inc. Brisbane San Mateo County 2 Closure Permanent
9868 9868 04/03/2018 06/01/2018 04/09/2018 Total Airport Services, LLC Los Angeles Los Angeles 100 Closure Permanent
9867 9867 04/06/2018 07/01/2018 04/06/2018 COMP Management, Inc. Moreno Valley Riverside County 4 Closure Permanent
9866 9866 04/06/2018 06/30/2018 04/06/2018 Kizan International, Inc. Brisbane San Mateo County 60 Layoff Permanent
9865 9865 04/02/2018 06/01/2018 04/06/2018 Workrite Uniform Company Oxnard Ventura County 101 Closure Permanent
9864 9864 04/04/2018 06/03/2018 04/04/2018 Kraco Enterprises, LLC Compton Los Angeles 83 Layoff Permanent
9863 9863 03/12/2018 06/04/2018 04/04/2018 DHL Supply Chain Moreno Valley Riverside County 136 Closure Permanent
9862 9862 03/29/2018 04/02/2018 04/03/2018 Snap Inc. Santa Monica Los Angeles 26 Layoff Permanent
9861 9861 04/02/2018 07/03/2018 04/02/2018 Community Medical Center Long Beach Long Beach Los Angeles 353 Closure Permanent
9860 9860 03/30/2018 06/08/2018 04/02/2018 Walmart Simi Valley Ventura County 130 Closure Permanent
9859 9859 03/30/2018 05/31/2018 04/02/2018 Pacific South Farms, Ltd. Carpinteria Santa Barbara 16 Closure Permanent
9858 9858 03/29/2018 04/02/2018 04/02/2018 Snap, Inc. Venice Los Angeles 35 Layoff Permanent
9857 9857 03/28/2018 06/16/2018 04/02/2018 Roman Catholic Welfare Corporation of Oakland Alameda County 17 Closure Permanent
9856 9856 03/28/2018 06/09/2018 04/02/2018 Roman Catholic Welfare Corporation of Oakland Alameda County 39 Closure Permanent
9855 9855 03/28/2018 05/31/2018 04/02/2018 Roman Catholic Welfare Corporation of Richmond Contra Costa 128 Closure Permanent
9854 9854 03/28/2018 05/29/2018 04/02/2018 C and D Zodiac, Inc.-Garden Grove Garden Grove Orange County 21 Layoff Permanent
9853 9853 03/27/2018 05/31/2018 04/02/2018 Marys Gone Crackers Gridley Butte County 137 Closure Permanent
9852 9852 03/26/2018 05/28/2018 04/02/2018 San Diego Gaming Ventures, LLC Jamul San Diego County 650 Layoff Permanent
9851 9851 03/22/2018 05/25/2018 04/02/2018 KnuEdge, Inc. San Diego San Diego County 30 Closure Permanent
9850 9850 03/30/2018 06/01/2018 03/30/2018 FAA San Bruno. Inc., dba Melody Toyota San Bruno San Mateo County 52 Closure Permanent
9849 9849 03/30/2018 05/31/2018 03/30/2018 Compass Group USA, Inc. dba Chartwells Berkeley Alameda County 45 Closure Permanent
9848 9848 03/26/2018 07/14/2018 03/30/2018 C and D Zodiac, inc. Garden Grove Orange County 46 Closure Permanent
9847 9847 03/26/2018 05/30/2018 03/30/2018 Zone Enterprises of Anaheim, LLC Anaheim Orange County 216 Closure Permanent
9846 9846 03/26/2018 05/29/2018 03/29/2018 The Cheesecake Factory Restaurants, Inc. Palo Alto Santa Clara 140 Closure Permanent
9845 9845 03/26/2018 05/28/2018 03/28/2018 Adventist health Tehachapi Valley Tehachapi Kern County 1 Layoff Permanent
9844 9844 03/22/2018 05/22/2018 03/27/2018 Allied Business Schools, Inc. Laguna Hills Orange County 71 Layoff Permanent
9843 9843 03/26/2018 06/01/2018 03/26/2018 iQor Holdings US LLC Simi Valley Ventura County 129 Layoff Permanent
9842 9842 03/12/2018 05/18/2018 03/23/2018 Jonathan Louis International Ltd. Gardena Los Angeles 100 Closure Permanent
9841 9841 03/22/2018 05/22/2018 03/22/2018 Claim Jumper Temecula Riverside County 77 Closure Permanent
9840 9840 03/21/2018 05/25/2018 03/22/2018 Gayle Manufacturing Company Woodland Yolo County 76 Closure Permanent
9839 9839 03/19/2018 06/02/2018 03/22/2018 Raleys Windsor Sonoma County 63 Closure Temporary
9838 9838 03/21/2018 05/23/2018 03/21/2018 Boyd Coffee Company San Diego San Diego County 3 Closure Permanent
9837 9837 03/21/2018 05/22/2018 03/21/2018 General Electric Company San Ramon Contra Costa 120 Layoff Permanent
9836 9836 03/19/2018 04/25/2018 03/21/2018 Symantec Corporation San Francisco San Francisco 1 Layoff Permanent
9835 9835 03/19/2018 04/25/2018 03/21/2018 Symantec Corporation Mountain View Santa Clara 18 Layoff Permanent
9834 9834 03/20/2018 05/25/2018 03/20/2018 Johanson Dielectrics, Inc. Sylmar Los Angeles 197 Layoff Permanent

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);