california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by County
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 |
---|---|---|---|---|---|---|---|---|---|
1842 | 1842 | 06/22/2015 | 03/25/2016 | 07/01/2015 | Maxim Integrated Product | San Jose | 150 | Closure Permanent | |
1843 | 1843 | 06/30/2015 | 08/29/2015 | 07/01/2015 | McGraw-Hill Education | Monterey | 137 | Layoff Unknown at this time | |
1844 | 1844 | 06/30/2015 | 08/30/2015 | 07/01/2015 | Long Beach Memorial Medical Center | Long Beach | 90 | Layoff Permanent | |
1845 | 1845 | 07/01/2015 | 09/02/2015 | 07/01/2015 | Leidos | El Segundo | 72 | Layoff Permanent | |
1846 | 1846 | 07/01/2015 | 09/30/2016 | 07/01/2015 | Bosch Healthcare Systems, Inc. | Palo Alto | 55 | Closure Permanent | |
1847 | 1847 | 06/29/2015 | 09/01/2015 | 07/02/2015 | Encompass Digital Media, Inc. | Los Angeles | 41 | Closure Permanent | |
1848 | 1848 | 07/02/2015 | 07/06/2015 | 07/02/2015 | Alphatec Spine | Carlsbad | 99 | Layoff Permanent | |
1849 | 1849 | 06/30/2015 | 08/07/2015 | 07/06/2015 | Symantec Corporation | Mountain View | 60 | Layoff Permanent | |
1850 | 1850 | 06/30/2015 | 08/31/2015 | 07/06/2015 | Fusion Contacts Centers, LLC | Santa Maria | 50 | Closure Permanent | |
1851 | 1851 | 06/30/2015 | 09/15/2015 | 07/06/2015 | KLA-Tencor Corporation | Milpitas | 213 | Layoff Permanent | |
1852 | 1852 | 07/01/2015 | 09/04/2015 | 07/06/2015 | Southern California Edison Company | San Clemente | 100 | Closure Permanent | |
1853 | 1853 | 07/02/2015 | 09/01/2015 | 07/06/2015 | State Fish Company, Inc. | Wilmington | 76 | Closure Permanent | |
1854 | 1854 | 07/02/2015 | 09/04/2015 | 07/06/2015 | Boeing Company | Long Beach | 56 | Layoff Unknown at this time | |
1855 | 1855 | 07/06/2015 | 09/04/2015 | 07/06/2015 | Bridgepoint Education, Inc. | San Diego | 22 | Layoff Permanent | |
1856 | 1856 | 07/01/2015 | 06/29/2015 | 07/07/2015 | BAE Systems | San Francisco | 4 | Layoff Temporary | |
1857 | 1857 | 07/01/2015 | 06/29/2015 | 07/07/2015 | BAE Systems | San Francisco | 78 | Layoff Temporary | |
1858 | 1858 | 07/01/2015 | 09/07/2015 | 07/07/2015 | Bay Bread LLC dba Bakery Los Angeles | San Fernando | 50 | Closure Permanent | |
1859 | 1859 | 07/01/2015 | 09/25/2015 | 07/07/2015 | Bay Bread LLC dba New French Bakery | South San | 121 | Closure Permanent | |
1860 | 1860 | 07/02/2015 | 06/12/2015 | 07/07/2015 | Hewlett-Packard Company | Palo Alto | 65 | Layoff Permanent | |
1861 | 1861 | 07/08/2015 | 09/06/2015 | 07/08/2015 | Microsoft Corporation | San Diego | 129 | Layoff Permanent | |
1862 | 1862 | 06/25/2015 | 10/09/2015 | 07/10/2015 | Aramark Healthcare Support Services, | Culver City | 53 | Closure Permanent | |
1863 | 1863 | 07/01/2015 | 09/10/2015 | 07/10/2015 | Maxim Integrated Product | San Jose | 20 | Layoff Permanent | |
1864 | 1864 | 07/06/2015 | 09/04/2015 | 07/10/2015 | ProCourier, Inc. | Los Angeles | 71 | Layoff Unknown at this time | |
1865 | 1865 | 07/06/2015 | 09/04/2015 | 07/10/2015 | ProCourier, Inc. | San Diego | 22 | Layoff Unknown at this time | |
1866 | 1866 | 07/07/2015 | 09/04/2015 | 07/10/2015 | ProCourier, Inc. | Irvine | 22 | Layoff Unknown at this time | |
1867 | 1867 | 07/09/2015 | 07/22/2015 | 07/10/2015 | Berkeley Pyramid Alehouse | Berkeley | 63 | Closure Permanent | |
1868 | 1868 | 07/09/2015 | 09/14/2015 | 07/10/2015 | Fireman's Fund Insurance Company | Novato | 35 | Layoff Permanent | |
1869 | 1869 | 06/30/2015 | 08/31/2015 | 07/13/2015 | First Transit | Rancho | 71 | Layoff Permanent | |
1870 | 1870 | 06/30/2015 | 08/31/2015 | 07/13/2015 | First Transit | San Bernardino | 127 | Layoff Permanent | |
1871 | 1871 | 07/10/2015 | 07/14/2015 | 07/13/2015 | 11 Main LLC | Chico | 44 | Layoff Permanent | |
1872 | 1872 | 07/10/2015 | 07/14/2015 | 07/13/2015 | 11 Main LLC | San Mateo | 35 | Closure Permanent | |
1873 | 1873 | 07/15/2015 | 07/15/2015 | 07/15/2015 | TaylorMade Golf Company | Carlsbad | 64 | Layoff Permanent | |
1874 | 1874 | 07/08/2015 | 09/06/2015 | 07/16/2015 | Southern California Edison Company | Rosemead | 38 | Layoff Permanent | |
1875 | 1875 | 07/14/2015 | 09/18/2015 | 07/20/2015 | Actavis, Inc. | Corona | 45 | Layoff Permanent | |
1876 | 1876 | 07/17/2015 | 07/13/2015 | 07/21/2015 | American Management Services LLC | Monterey | 56 | Closure Permanent | |
1877 | 1877 | 07/17/2015 | 09/18/2015 | 07/21/2015 | Boeing Company | El Segundo | 66 | Layoff Unknown at this time | |
1878 | 1878 | 07/17/2015 | 09/18/2015 | 07/21/2015 | Boeing Company | Huntington Beach | 65 | Layoff Unknown at this time | |
1879 | 1879 | 07/17/2015 | 09/18/2015 | 07/21/2015 | Boeing Company | Long Beach | 113 | Layoff Unknown at this time | |
1880 | 1880 | 07/17/2015 | 09/25/2015 | 07/21/2015 | Maxim Integrated Product | San Jose | 11 | Layoff Permanent | |
1881 | 1881 | 07/17/2015 | 09/26/2015 | 07/21/2015 | DS Services of America, Inc. | Los Angeles | 120 | Closure Permanent | |
1882 | 1882 | 07/17/2015 | 09/26/2015 | 07/21/2015 | DS Services of America, Inc. | Pasadena | 200 | Closure Permanent | |
1883 | 1883 | 07/20/2015 | 09/18/2015 | 07/21/2015 | Minno, Inc. | San Francisco | 255 | Closure Permanent | |
1884 | 1884 | 07/20/2015 | 09/18/2015 | 07/21/2015 | Safeway, Inc. | Pleasanton | 14 | Layoff Unknown at this time | |
1885 | 1885 | 07/15/2015 | 09/15/2015 | 07/22/2015 | Oakley, Inc. | Encinitas | 8 | Layoff Unknown at this time | |
1886 | 1886 | 07/15/2015 | 09/15/2015 | 07/22/2015 | Oakley, Inc. | Foothill Ranch | 159 | Layoff Unknown at this time | |
1887 | 1887 | 07/20/2015 | 12/31/2017 | 07/22/2015 | Toyota Motor North America | Gardena | 100 | Closure Permanent | |
1888 | 1888 | 07/20/2015 | 12/31/2017 | 07/22/2015 | Toyota Motor North America | Torrance | 3000 | Closure Permanent | |
1889 | 1889 | 07/21/2015 | 07/22/2015 | 07/22/2015 | Cisco Systems, Inc. | San Jose | 192 | Layoff Permanent | |
1890 | 1890 | 07/20/2015 | 09/30/2015 | 07/23/2015 | IAP Worldwide Services, Inc. | Mountain View | 67 | Layoff Permanent | |
1891 | 1891 | 07/21/2015 | 09/15/2015 | 07/23/2015 | Presse LLC dba Cafe de la Presse and | San Francisco | 85 | Closure Temporary | |
1892 | 1892 | 07/10/2015 | 10/04/2015 | 07/24/2015 | Sears Holdings Corporation | Cupertino | 17 | Closure Permanent | |
1893 | 1893 | 07/10/2015 | 10/04/2015 | 07/24/2015 | Sears Holdings Corporation | Cupertino | 81 | Closure Permanent | |
1894 | 1894 | 07/14/2015 | 09/14/2015 | 07/24/2015 | Associate Management Resources, Inc. | San Diego | 533 | Closure Permanent | |
1895 | 1895 | 07/10/2015 | 10/11/2015 | 07/27/2015 | Kmart | Atwater | 74 | Closure Permanent | |
1896 | 1896 | 07/27/2015 | 09/25/2015 | 07/27/2015 | Safeway, Inc. | Pleasanton | 37 | Layoff Unknown at this time | |
1897 | 1897 | 07/27/2015 | 09/30/2015 | 07/29/2015 | Hank Fisher Properties, Inc. | Sacramento | 242 | Layoff Permanent | |
1898 | 1898 | 07/29/2015 | 09/30/2015 | 07/29/2015 | SPS Distribution Center | Paso Robles | 8 | Closure Permanent | |
1899 | 1899 | 07/23/2015 | 07/31/2015 | 07/30/2015 | Turf Terminators, LLC | Los Angeles | 94 | Layoff Permanent | |
1900 | 1900 | 07/29/2015 | 07/28/2015 | 07/30/2015 | Relativity Media | Beverly Hills | 61 | Layoff Permanent | |
1901 | 1901 | 07/30/2015 | 09/30/2015 | 07/30/2015 | United Technologies Corporation | San Diego | 21 | Closure Permanent | |
1902 | 1902 | 07/28/2015 | 09/26/2015 | 07/31/2015 | Kixeye, Inc. | San Francisco | 62 | Layoff Permanent | |
1903 | 1903 | 07/31/2015 | 10/02/2015 | 07/31/2015 | Boston Scientific Corporation | Fremont | 284 | Closure Permanent | |
1904 | 1904 | 07/31/2015 | 10/02/2015 | 07/31/2015 | Boston Scientific Corporation | San Jose | 171 | Closure Permanent | |
1905 | 1905 | 07/20/2015 | 09/30/2015 | 08/03/2015 | Ruan Transportation Corporation | Ripon | 78 | Closure Permanent | |
1906 | 1906 | 07/27/2015 | 09/30/2015 | 08/03/2015 | Armstrong Growers | San Juan | 56 | Closure Permanent | |
1907 | 1907 | 07/28/2015 | 09/28/2015 | 08/03/2015 | CR Briggs Corporation | Trona | 5 | Layoff Permanent | |
1908 | 1908 | 07/29/2015 | 08/03/2015 | 08/03/2015 | Molycorp Minerals LLC | Mountain Pass | 474 | Layoff Permanent | |
1909 | 1909 | 07/30/2015 | 09/30/2015 | 08/03/2015 | Binder & Binder | Orange | 70 | Closure Permanent | |
1910 | 1910 | 07/31/2015 | 09/30/2015 | 08/03/2015 | Driscoll's Strawberry Associates, Inc. | Salinas | 38 | Closure Permanent | |
1911 | 1911 | 07/27/2015 | 10/23/2015 | 08/04/2015 | Hilton San Francisco Union Square | San Francisco | 78 | Layoff Permanent | |
1912 | 1912 | 08/03/2015 | 10/05/2015 | 08/04/2015 | Owens-Brockway Glass Container Inc. | Oakland | 202 | Closure Permanent | |
1913 | 1913 | 07/30/2015 | 07/30/2015 | 08/05/2015 | Abbott Vascular | Santa Clara | 81 | Layoff Permanent | |
1914 | 1914 | 07/30/2015 | 07/30/2015 | 08/05/2015 | Abbott Vascular | Temecula | 163 | Layoff Permanent | |
1915 | 1915 | 08/04/2015 | 09/11/2015 | 08/07/2015 | Anna's Linens, Inc. | Costa Mesa | 29 | Closure Permanent | |
1916 | 1916 | 07/31/2015 | 10/02/2015 | 08/10/2015 | Boeing Company | Long Beach | 8 | Layoff Unknown at this time | |
1917 | 1917 | 08/10/2015 | 10/09/2015 | 08/10/2015 | Safeway, Inc. | Pleasanton | 37 | Layoff Unknown at this time | |
1918 | 1918 | 08/04/2015 | 10/05/2015 | 08/11/2015 | CGR/Thompson Industries, Inc. | Fullerton | 102 | Closure Permanent | |
1919 | 1919 | 08/10/2015 | 10/15/2015 | 08/12/2015 | BI NUTRACEUTICALS, INC. | Long Beach | 54 | Layoff Permanent | |
1920 | 1920 | 08/05/2015 | 09/30/2015 | 08/13/2015 | Lyris, Inc. | Emeryville | 72 | Layoff Permanent | |
1921 | 1921 | 08/05/2015 | 09/30/2015 | 08/13/2015 | Lyris, Inc. | Santa Clara | 7 | Layoff Permanent | |
1922 | 1922 | 08/05/2015 | 10/09/2015 | 08/13/2015 | Ralphs Grocery Company | Pico Rivera | 67 | Layoff Permanent | |
1923 | 1923 | 08/12/2015 | 10/12/2015 | 08/13/2015 | Chevron | Richmond | 70 | Layoff Permanent | |
1924 | 1924 | 08/12/2015 | 10/12/2015 | 08/13/2015 | Chevron | San Ramon | 430 | Layoff Permanent | |
1925 | 1925 | 08/12/2015 | 10/16/2015 | 08/13/2015 | Quest Diagnostics Incorporated | San Jose | 78 | Layoff Permanent | |
1926 | 1926 | 08/13/2015 | 10/23/2015 | 08/13/2015 | Motorola Mobility LLC | Sunnyvale | 213 | Layoff Permanent | |
1927 | 1927 | 08/14/2015 | 10/14/2015 | 08/14/2015 | Raytheon Intelligence, Information & | Chula Vista | 41 | Closure Unknown at this time | |
1928 | 1928 | 08/14/2015 | 10/13/2015 | 08/17/2015 | Haggen, Inc. | Simi Valley | 101 | Closure Permanent | |
1929 | 1929 | 08/14/2015 | 10/13/2015 | 08/17/2015 | Haggen, Inc. | Tustin | 157 | Closure Permanent | |
1930 | 1930 | 08/14/2015 | 10/13/2015 | 08/17/2015 | Haggen, Inc. (Store #2154) | Newbury Park | 38 | Closure Permanent | |
1931 | 1931 | 08/14/2015 | 10/13/2015 | 08/17/2015 | Haggen, Inc. (Store #2213) | Santa Clarita | 33 | Closure Permanent | |
1932 | 1932 | 08/12/2015 | 10/16/2015 | 08/18/2015 | Sky Aerospace Products | Los Angeles | 53 | Closure Permanent | |
1933 | 1933 | 08/13/2015 | 10/16/2015 | 08/18/2015 | Ralphs Grocery Company | Hermosa Beach | 74 | Layoff Permanent | |
1934 | 1934 | 08/14/2015 | 10/13/2015 | 08/18/2015 | Haggen, Inc. | San Ysidro | 231 | Closure Permanent | |
1935 | 1935 | 08/14/2015 | 10/13/2015 | 08/18/2015 | Haggen, Inc. (Store #2208) | Bakersfield | 36 | Closure Permanent | |
1936 | 1936 | 08/14/2015 | 10/13/2015 | 08/18/2015 | Haggen, Inc. (Store #2210) | Los Osos | 24 | Closure Permanent | |
1937 | 1937 | 08/14/2015 | 10/25/2015 | 08/18/2015 | Ralphs Grocery Company | Santa Ana | 75 | Layoff Permanent | |
1938 | 1938 | 08/14/2015 | 10/27/2015 | 08/18/2015 | USS-POSCO Industries | Pittsburg | 661 | Layoff Temporary | |
1939 | 1939 | 08/06/2015 | 10/30/2015 | 08/19/2015 | Zimmer Biomet Dental | Carlsbad | 279 | Closure Permanent | |
1940 | 1940 | 08/18/2015 | 10/18/2015 | 08/19/2015 | KND Development 53, L.L.C., d/b/a | Hawaiian Gardens | 94 | Closure Permanent | |
1941 | 1941 | 08/17/2015 | 10/16/2015 | 08/21/2015 | Soitec Solar Industries, LLC | San Diego | 100 | 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 );