california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Layoff/Closure ✖
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 |
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 );