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 County

✎ 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
1942 1942 08/20/2015 10/19/2015 08/21/2015 Safeway Walnut Creek   63 Closure Permanent
1943 1943 08/20/2015 10/22/2015 08/21/2015 XOMA (US) LLC Berkeley   39 Layoff Permanent
1944 1944 08/21/2015 10/23/2015 08/21/2015 Western Digital Technologies, Inc. Irvine   81 Layoff Permanent
1945 1945 08/21/2015 10/23/2015 08/21/2015 Western Digital Technologies, Inc. Mountain View   56 Layoff Permanent
1946 1946 08/20/2015 10/25/2015 08/24/2015 Silgan Containers Riverbank   180 Layoff Temporary
1947 1947 08/21/2015 10/23/2015 08/25/2015 Boeing Company El Segundo   39 Layoff Unknown at this time
1948 1948 08/21/2015 10/23/2015 08/25/2015 Boeing Company Huntington Beach   26 Layoff Unknown at this time
1949 1949 08/21/2015 10/23/2015 08/25/2015 Boeing Company Long Beach   113 Layoff Unknown at this time
1950 1950 08/24/2015 10/31/2015 08/25/2015 Mesa Beverage Co., Inc. Santa Rosa   137 Layoff Permanent
1951 1951 08/25/2015 10/24/2015 08/26/2015 Patina Group NewCo, LLC. Los Angeles   317 Layoff Unknown at this time
1952 1952 08/27/2015 08/31/2015 08/27/2015 VT West, Inc. La Mirada   68 Layoff Permanent
1953 1953 08/25/2015 10/26/2015 08/28/2015 Intuit Inc. Menlo Park   8 Layoff Permanent
1954 1954 08/25/2015 10/26/2015 08/28/2015 Intuit Inc. Mountain View   45 Layoff Permanent
1955 1955 08/25/2015 10/26/2015 08/28/2015 Intuit Inc. San Diego   9 Layoff Permanent
1956 1956 08/25/2015 10/26/2015 08/28/2015 Intuit Inc. San Francisco   2 Layoff Permanent
1957 1957 08/25/2015 10/26/2015 08/28/2015 Intuit Inc. Woodland Hills   46 Layoff Permanent
1958 1958 08/27/2015 10/30/2015 08/28/2015 Sheraton Operating Corporation Palm Desert   124 Layoff Permanent
1959 1959 08/25/2015 11/07/2015 08/31/2015 San Jose Airport Garden Hotel San Jose   123 Closure Permanent
1960 1960 08/31/2015 10/30/2015 08/31/2015 Safeway Inc. Pleasanton   5 Layoff Unknown at this time
1961 1961 08/28/2015 10/30/2015 09/01/2015 Boeing Company El Segundo   106 Layoff Unknown at this time
1962 1962 08/28/2015 10/30/2015 09/01/2015 Boeing Company Huntington Beach   6 Layoff Unknown at this time
1963 1963 08/28/2015 10/30/2015 09/01/2015 Boeing Company Long Beach   2 Layoff Unknown at this time
1964 1964 08/28/2015 11/01/2015 09/01/2015 Kor Hotel Management, LLC dba Viceroy San Francisco   47 Closure Temporary
1965 1965 09/01/2015 11/02/2015 09/02/2015 M.E. Fox & Company, Inc. San Jose   127 Layoff Permanent
1966 1966 09/01/2015 11/03/2015 09/03/2015 Sheraton Operating Corporation Dana Point   610 Closure Temporary
1967 1967 08/24/2015 10/23/2015 09/04/2015 Park 'N Fly San Diego and Park 'N Fly, San Diego   71 Layoff Permanent
1968 1968 09/02/2015 11/06/2015 09/04/2015 Acclarent, Inc. Menlo Park   114 Layoff Unknown at this time
1969 1969 09/03/2015 10/30/2015 09/04/2015 FAMIMA Corporation Los Angeles   73 Layoff Unknown at this time
1970 1970 09/03/2015 10/30/2015 09/04/2015 FAMIMA Corporation Santa Monica   12 Layoff Unknown at this time
1971 1971 09/03/2015 10/30/2015 09/04/2015 FAMIMA Corporation Torrance   9 Layoff Unknown at this time
1972 1972 09/03/2015 11/02/2015 09/04/2015 MiaSole Hi-Tech Corp. Santa Clara   79 Layoff Permanent
1973 1973 08/28/2015 08/25/2015 09/08/2015 BAE SYSTEMS San Francisco   134 Layoff Temporary
1974 1974 09/02/2015 11/06/2015 09/10/2015 Mentor Worldwide LLC Santa Barbara   81 Layoff Unknown at this time
1975 1975 09/10/2015 11/09/2015 09/10/2015 Collecto, Inc. dba EOS CCA Novato   45 Closure Permanent
1976 1976 09/10/2015 11/10/2015 09/10/2015 Western Digital Technologies, Inc. Irvine   143 Layoff Permanent
1977 1977 09/01/2015 11/01/2015 09/11/2015 Zenith Education Group Santa Ana   18 Layoff Permanent
1978 1978 09/04/2015 09/04/2015 09/11/2015 Quiksilver, Inc. Huntington Beach   77 Layoff Permanent
1979 1979 09/04/2015 11/06/2015 09/14/2015 Boeing Company Long Beach   2 Layoff Unknown at this time
1980 1980 09/10/2015 11/09/2015 09/14/2015 Seagate US LLC Cupertino   62 Layoff Permanent
1981 1981 09/11/2015 09/14/2015 09/14/2015 Cisco Systems, Inc. San Jose   20 Layoff Permanent
1982 1982 09/11/2015 09/29/2015 09/14/2015 AT&T San Ramon   219 Layoff Permanent
1983 1983 09/15/2015 07/20/2015 09/16/2015 GREE International, Inc. San Francisco   114 Layoff Unknown at this time
1984 1984 09/15/2015 11/14/2015 09/16/2015 Brake Parts Inc. Chowchilla   107 Layoff Permanent
1985 1985 09/16/2015 09/17/2015 09/16/2015 Halliburton Energy Services, Inc. Bakersfield   52 Layoff Permanent
1986 1986 09/15/2015 09/30/2015 09/17/2015 CareFusion San Diego   95 Layoff Permanent
1987 1987 09/17/2015 11/20/2015 09/17/2015 Qualcomm Incorporated San Jose   60 Layoff Permanent
1988 1988 09/17/2015 11/20/2015 09/17/2015 Qualcomm Incorporated Santa Clara   70 Layoff Permanent
1989 1989 09/14/2015 11/20/2015 09/18/2015 AbilityFirst Woodland Hills   105 Closure Permanent
1990 1990 09/17/2015 11/20/2015 09/18/2015 Qualcomm Incorporated San Diego   1314 Layoff Permanent
1991 1991 09/11/2015 11/13/2015 09/21/2015 Boeing Company El Segundo   3 Layoff Temporary
1992 1992 09/16/2015 11/16/2015 09/22/2015 Intuit Inc. Woodland Hills   12 Layoff Permanent
1993 1993 09/16/2015 11/20/2015 09/22/2015 Ralphs Grocery Company Glendora   73 Layoff Permanent
1994 1994 09/17/2015 11/16/2015 09/22/2015 MCC BB Property LLC Santa Barbara   23 Layoff Permanent
1995 1995 09/21/2015 11/22/2015 09/22/2015 TGI Friday's Valencia   62 Closure Permanent
1996 1996 09/24/2015 01/06/2016 09/24/2015 Medtronic Distribution Mira Loma   21 Layoff Permanent
1997 1997 09/24/2015 11/23/2015 09/24/2015 Bridgepoint Education, Inc. San Diego   19 Layoff Permanent
1998 1998 09/18/2015 11/20/2015 09/28/2015 Boeing Company El Segundo   54 Layoff Permanent
1999 1999 09/18/2015 11/20/2015 09/28/2015 Boeing Company Huntington Beach   23 Layoff Permanent
2000 2000 09/18/2015 11/20/2015 09/28/2015 Boeing Company Long Beach   37 Layoff Permanent
2001 2001 09/21/2015 11/20/2015 09/28/2015 Safeway Inc. Pleasanton   15 Layoff Unknown at this time
2002 2002 09/24/2015 11/27/2015 09/28/2015 Brice Manufacturing Company, Inc. Pacoima   9 Layoff Permanent
2003 2003 09/28/2015 11/27/2015 09/28/2015 Safeway, Inc. Pleasanton   4 Layoff Unknown at this time
2004 2004 09/24/2015 09/24/2015 09/29/2015 Space Systems/Loral, LLC Palo Alto   90 Layoff Permanent
2005 2005 09/25/2015 11/23/2015 09/29/2015 Flagship Food Group Chatsworth   123 Closure Permanent
2006 2006 09/30/2015 05/01/2016 09/30/2015 Packaging Advantage Corporation DBA Los Angeles   192 Closure Permanent
2007 2007 09/30/2015 11/30/2015 09/30/2015 San Diego Sports, LLC San Diego   123 Closure Permanent
2008 2008 09/30/2015 11/30/2015 09/30/2015 United Technologies Corporation San Diego   7 Closure Permanent
2009 2009 09/28/2015 11/27/2015 10/01/2015 MobiTV, Inc. Emeryville   54 Layoff Permanent
2010 2010 09/30/2015 11/30/2015 10/01/2015 SunEdison, Inc. Belmont   51 Layoff Permanent
2011 2011 09/30/2015 11/30/2016 10/01/2015 SunEdison, Inc. San Francisco   11 Layoff Permanent
2012 2012 09/30/2015 12/04/2015 10/01/2015 Fireman's Fund Insurance Company Novato   73 Layoff Permanent
2013 2013 09/24/2015 12/01/2015 10/02/2015 Menzies Aviation Los Angeles   51 Layoff Permanent
2014 2014 10/01/2015 01/16/2016 10/02/2015 Kohl's Department Stores, Inc. Santa Clara   119 Closure Permanent
2015 2015 10/02/2015 10/02/2015 10/02/2015 Aerotek, Inc. Oxnard   58 Layoff Unknown at this time
2016 2016 09/29/2015 11/30/2015 10/05/2015 Kythera Biopharmaceuticals, Inc. Westlake Village   117 Layoff Permanent
2017 2017 10/02/2015 11/05/2015 10/05/2015 GMRI, Inc. Los Angeles   83 Closure Permanent
2018 2018 10/02/2015 12/04/2015 10/05/2015 Svenhard's Swedish Bakery Oakland   162 Closure Permanent
2019 2019 10/05/2015 12/05/2015 10/06/2015 Marine Terminal Corporation Los Angeles   136 Closure Permanent
2020 2020 10/05/2015 12/05/2015 10/06/2015 Marine Terminal Corporation Oakland   39 Closure Permanent
2021 2021 10/06/2015 12/07/2015 10/08/2015 MullinTBG El Segundo   50 Layoff Permanent
2022 2022 10/06/2015 12/07/2015 10/08/2015 MullinTBG Irvine   3 Layoff Permanent
2023 2023 10/08/2015 09/25/2015 10/08/2015 Onyx Pharmaceuticals, Inc South San   377 Closure Permanent
2024 2024 10/06/2015 12/05/2015 10/09/2015 Ports America Shared Services, Inc. Oakland   4 Layoff Permanent
2025 2025 10/06/2015 12/05/2015 10/09/2015 Ports America Shared Services, Inc. Terminal Island   7 Layoff Permanent
2026 2026 10/07/2015 11/24/2015 10/09/2015 Triple B Corporation Irwindale   124 Closure Permanent
2027 2027 10/06/2015 12/06/2015 10/12/2015 Apro Distribution, LLC Gardena   61 Layoff Permanent
2028 2028 10/07/2015 12/07/2015 10/12/2015 Southern California Edison Company Irwindale   32 Layoff Permanent
2029 2029 10/08/2015 12/28/2015 10/12/2015 Barclays Capital Inc. Los Angeles   15 Layoff Permanent
2030 2030 10/08/2015 12/28/2015 10/12/2015 Barclays Capital Inc. San Francisco   20 Layoff Permanent
2031 2031 10/01/2015 12/07/2015 10/13/2015 General Dynamics Advanced Information Thousand Oaks   55 Closure Permanent
2032 2032 10/13/2015 12/18/2015 10/13/2015 WD Media, LLC San Jose   2 Layoff Permanent
2033 2033 10/13/2015 12/18/2015 10/13/2015 Western Digital, LLC Fremont   109 Layoff Permanent
2034 2034 09/29/2015 10/14/2015 10/14/2015 TTM Technologies, Inc. Milpitas   175 Closure Unknown at this time
2035 2035 10/01/2015 12/01/2015 10/14/2015 Zenith Education Group Santa Ana   48 Layoff Permanent
2036 2036 10/12/2015 12/11/2015 10/14/2015 Rockwell Collins, Inc. Poway   29 Layoff Permanent
2037 2037 10/12/2015 12/13/2015 10/14/2015 Twitter, Inc. San Francisco   240 Layoff Permanent
2038 2038 10/14/2015 12/19/2015 10/14/2015 GENCO Eastvale   68 Layoff Permanent
2039 2039 10/01/2015 11/30/2015 10/15/2015 Boeing Company Long Beach   1 Layoff Unknown at this time
2040 2040 10/09/2015 12/11/2015 10/15/2015 Boeing Company El Segundo   109 Layoff Unknown at this time
2041 2041 10/09/2015 12/11/2015 10/15/2015 Boeing Company Huntington Beach   76 Layoff Unknown at this time

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