california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Layoff/Closure
This data as json, copyable, CSV (advanced)
Link | rowid | Notice Date | Effective Date | Received Date | Company | City | County | Employees | Layoff/Closure ▼ |
---|---|---|---|---|---|---|---|---|---|
1215 | 1215 | 08/19/2020 | 06/05/2020 | 10/23/2020 | Rosa Mexicano | San Francisco | San Francisco County | 76 | Closure Permanent |
1248 | 1248 | 07/30/2020 | 07/21/2020 | 10/29/2020 | VFC | Alameda | Alameda County | 7 | Closure Permanent |
1251 | 1251 | 09/10/2020 | 11/14/2020 | 10/30/2020 | Wheel Pros, LLC | Rancho Dominguez | Los Angeles County | 88 | Closure Permanent |
1253 | 1253 | 10/01/2020 | 11/30/2020 | 10/30/2020 | Orora Visual LLC | Los Angeles | Los Angeles County | 5 | Closure Permanent |
1257 | 1257 | 09/03/2020 | 05/08/2020 | 11/02/2020 | Molson Coors Beverage Company | Baldwin Park | Los Angeles County | 462 | Closure Permanent |
1260 | 1260 | 10/20/2020 | 12/30/2020 | 11/02/2020 | TAMCO | Rancho Cucamonga | San Bernardino County | 66 | Closure Permanent |
1267 | 1267 | 04/30/2020 | 03/16/2020 | 11/03/2020 | Payne's Janitorial Services, Inc. | La Habra | Orange County | 65 | Closure Permanent |
1277 | 1277 | 10/06/2020 | 11/05/2020 | 11/09/2020 | Natomas Sports Club | Sacramento | Sacramento County | 89 | Closure Permanent |
1281 | 1281 | 10/14/2020 | 03/31/2021 | 11/09/2020 | Ichor Systems, Inc. | Union City | Alameda County | 42 | Closure Permanent |
1282 | 1282 | 10/01/2020 | 12/01/2020 | 11/09/2020 | Ace Beverage LLC | Los Angeles | Los Angeles County | 200 | Closure Permanent |
1283 | 1283 | 10/01/2020 | 12/11/2020 | 11/09/2020 | Ace Beverage LLC | Los Angeles | Los Angeles County | 200 | Closure Permanent |
1284 | 1284 | 10/02/2020 | 10/02/2020 | 11/09/2020 | Service King Paint & Body, LLC. | Mountain View | Santa Clara County | 16 | Closure Permanent |
1288 | 1288 | 10/27/2020 | 12/31/2020 | 11/10/2020 | Gulfstream | Long Beach | Los Angeles County | 608 | Closure Permanent |
1289 | 1289 | 10/26/2020 | 12/28/2020 | 11/10/2020 | DAMAC Products LLC | La Mirada | Los Angeles County | 79 | Closure Permanent |
1293 | 1293 | 10/26/2020 | 12/16/2020 | 11/10/2020 | Renaissance Newport Beach Hotel | Newport Beach | Orange County | 104 | Closure Permanent |
1296 | 1296 | 10/26/2020 | 11/24/2020 | 11/10/2020 | Residence Inn San Diego Mission Valley | San Diego | San Diego County | 29 | Closure Permanent |
1310 | 1310 | 10/30/2020 | 12/31/2020 | 11/12/2020 | Dynamic Aviation | Concord | Contra Costa County | 4 | Closure Permanent |
1319 | 1319 | 11/01/2020 | 12/31/2020 | 11/12/2020 | American Directions Research Group, inc. | Redding | Shasta County | 67 | Closure Permanent |
1348 | 1348 | 11/05/2020 | 01/12/2021 | 11/16/2020 | Eaton | Santa Ana | Orange County | 111 | Closure Permanent |
1349 | 1349 | 10/30/2020 | 12/31/2020 | 11/16/2020 | Integrated Oncology Network, LLC | Corona Del Mar | Orange County | 30 | Closure Permanent |
1359 | 1359 | 11/05/2020 | 12/31/2020 | 11/17/2020 | MRI Manufacturing, Inc. | Santa Monica | Los Angeles County | 7 | Closure Permanent |
1362 | 1362 | 11/06/2020 | 01/08/2020 | 11/17/2020 | Makita U.S.A., Inc. | La Mirada | Los Angeles County | 17 | Closure Permanent |
1364 | 1364 | 11/04/2020 | 12/01/2020 | 11/17/2020 | True Leaf Farms | Gonzales | Monterey County | 202 | Closure Permanent |
1387 | 1387 | 11/11/2020 | 11/11/2020 | 11/18/2020 | J Brand, Inc. | Camarillo | Ventura County | 6 | Closure Permanent |
1388 | 1388 | 10/28/2020 | 01/06/2021 | 11/18/2020 | Craft Beer Guild Distributing | Cerritos | Los Angeles County | 68 | Closure Permanent |
1398 | 1398 | 11/10/2020 | 01/11/2020 | 11/18/2020 | CSAA Insurance Group | Fairfield | Solano County | 18 | Closure Permanent |
1399 | 1399 | 11/17/2020 | 11/17/2020 | 11/19/2020 | National Oilwell Varco | Orange | Orange County | 283 | Closure Permanent |
1407 | 1407 | 11/16/2020 | 10/31/2020 | 11/19/2020 | Westside Tavern | Los Angeles | Los Angeles County | 84 | Closure Permanent |
1411 | 1411 | 11/19/2020 | 03/31/2021 | 11/20/2020 | TridentCare | Burbank | Los Angeles County | 36 | Closure Permanent |
1417 | 1417 | 11/19/2020 | 01/29/2020 | 11/20/2020 | TAMCO | Rancho Cucamonga | San Bernardino County | 45 | Closure Permanent |
1419 | 1419 | 11/16/2020 | 01/11/2021 | 11/23/2020 | Adventist Health Home Care | Chico | Butte County | 14 | Closure Permanent |
1421 | 1421 | 11/18/2020 | 01/29/2021 | 11/23/2020 | Dun & Bradstreet | Malibu | Los Angeles County | 1 | Closure Permanent |
1429 | 1429 | 11/02/2020 | 12/31/2020 | 11/30/2020 | RockSugar Southeast Asian Kitchen | Los Angeles | Los Angeles County | 106 | Closure Permanent |
1431 | 1431 | 11/24/2020 | 11/24/2020 | 11/30/2020 | Hosopo, Corporation | Hemet | Riverside County | 137 | Closure Permanent |
1432 | 1432 | 11/16/2020 | 01/29/2021 | 11/30/2020 | Boston Scientific Corporation | Menlo Park | San Mateo County | 126 | Closure Permanent |
1433 | 1433 | 11/19/2020 | 01/19/2021 | 11/30/2020 | Greenberry Industrial, LLC | Fairfield | Solano County | 38 | Closure Permanent |
1434 | 1434 | 11/23/2020 | 11/23/2020 | 11/30/2020 | Tricap International, LLC | Rancho Dominguez | Los Angeles County | 180 | Closure Permanent |
1438 | 1438 | 11/30/2020 | 11/30/2020 | 12/01/2020 | Temple City Baekjeong, LLC | Temple City | Los Angeles County | 52 | Closure Permanent |
1458 | 1458 | 11/30/2020 | 01/29/2021 | 12/03/2020 | TE Connectivity | Campbell | Santa Clara County | 178 | Closure Permanent |
1459 | 1459 | 10/15/2020 | 12/15/2020 | 12/04/2020 | Century Blinds, Inc. | Corona | Riverside County | 46 | Closure Permanent |
1476 | 1476 | 12/01/2020 | 01/31/2021 | 12/14/2020 | Sundance Holdings Group, LLC | Corte Madera | Marin County | 7 | Closure Permanent |
1507 | 1507 | 11/30/2020 | 02/05/2021 | 12/21/2020 | Crescent Hotels & Resort, LLC - Four Points by Sheraton LAX | Los Angeles | Los Angeles County | 214 | Closure Permanent |
1515 | 1515 | 12/11/2020 | 02/12/2021 | 12/22/2020 | Armstrong Flooring, Inc. | South Gate | Los Angeles County | 66 | Closure Permanent |
1516 | 1516 | 12/11/2020 | 03/31/2021 | 12/22/2020 | EMPCO, LLC dba IMPCO Technologies | Santa Ana | Orange County | 91 | Closure Permanent |
1536 | 1536 | 11/19/2020 | 01/16/2021 | 12/24/2020 | Abercrombie & Fitch Co | San Luis Obispo | San Luis Obispo County | 40 | Closure Permanent |
1537 | 1537 | 12/19/2020 | 01/16/2021 | 12/24/2020 | Abercrombie & Fitch Co. | Santa Rosa | Sonoma County | 29 | Closure Permanent |
1538 | 1538 | 10/15/2020 | 12/15/2020 | 12/28/2020 | Century Blinds Inc. | Corona | Riverside County | 46 | Closure Permanent |
1546 | 1546 | 12/07/2020 | 12/09/2020 | 12/30/2020 | Fullerton Baekjeong, LLC | Buena Park | Orange County | 67 | Closure Permanent |
1547 | 1547 | 12/07/2020 | 12/09/2020 | 12/30/2020 | Irvine Baekjeong, LLC | Irvine | Orange County | 68 | Closure Permanent |
1557 | 1557 | 11/13/2020 | 11/13/2020 | 01/04/2021 | Advanced Sleep Medicine Services, Inc. | Redlands | San Bernardino County | 3 | Closure Permanent |
1559 | 1559 | 11/13/2020 | 11/13/2020 | 01/04/2021 | Advanced Sleep Medicine Services, Inc | Oceanside | San Diego County | 11 | Closure Permanent |
1560 | 1560 | 12/15/2020 | 02/14/2021 | 01/04/2021 | Corning Research and Development Corporation | Goleta | Santa Barbara County | 40 | Closure Permanent |
1585 | 1585 | 12/17/2020 | 02/26/2021 | 01/05/2021 | TAMCO | Rancho Cucamonga | San Bernardino County | 22 | Closure Permanent |
1588 | 1588 | 12/17/2020 | 02/19/2021 | 01/05/2021 | Analog Devices, Inc. | Milpitas | Santa Clara County | 255 | Closure Permanent |
1600 | 1600 | 11/30/2020 | 12/04/2020 | 01/06/2021 | Darden Restaurants, Inc. | San Francisco | San Francisco County | 53 | Closure Permanent |
1605 | 1605 | 11/11/2020 | 03/31/2021 | 01/06/2021 | Apeks | Santa Rosa | Sonoma County | 36 | Closure Permanent |
1614 | 1614 | 12/15/2020 | 12/27/2020 | 01/07/2021 | Main Street Security, a dba of Bedrock Creek Foundation | Riverside | Riverside County | 11 | Closure Permanent |
1626 | 1626 | 12/28/2020 | 03/01/2021 | 01/08/2021 | Courtyard Management Corporation dba Courtyard by Marriott Oakland Emeryville | Emeryville | Alameda County | 85 | Closure Permanent |
1629 | 1629 | 01/05/2021 | 03/14/2021 | 01/08/2021 | Macy's Inc. | El Cajon | San Diego County | 103 | Closure Permanent |
1632 | 1632 | 12/28/2020 | 03/01/2021 | 01/08/2021 | Courtyard Management Corporation dba Courtyard by Marriott San Francisco Airport/Oyster Point Waterf | South San Francisco | San Mateo County | 57 | Closure Permanent |
1633 | 1633 | 12/28/2020 | 03/01/2021 | 01/08/2021 | Residence Inn by Marriott, LLC dba Residence Inn by Marriott San Francisco Airport/Oyster Point Wate | South San Francisco | San Mateo County | 33 | 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 |
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 |
1683 | 1683 | 11/20/2020 | 01/15/2021 | 01/13/2021 | Edelbrock group | Torrance | Los Angeles County | 270 | Closure Permanent |
1688 | 1688 | 12/12/2020 | 02/10/2021 | 01/13/2021 | IRISNDT | Stanton | Orange County | 12 | Closure Permanent |
1695 | 1695 | 01/08/2021 | 01/30/2021 | 01/13/2021 | Cole Haan | San Francisco | San Francisco County | 5 | Closure Permanent |
1701 | 1701 | 11/19/2020 | 01/18/2021 | 01/14/2021 | Nazareth House | San Rafael | Marin County | 76 | Closure Permanent |
1705 | 1705 | 12/07/2020 | 02/28/2021 | 01/14/2021 | Transform KM LLC-07653 | Big Bear Lake | San Bernardino County | 1 | Closure Permanent |
1730 | 1730 | 01/15/2021 | 01/15/2021 | 01/21/2021 | Currency Capital | Los Angeles | Los Angeles County | 4 | Closure Permanent |
1739 | 1739 | 01/18/2021 | 03/22/2021 | 01/21/2021 | Schreiber Foods Inc. | Fullerton | Orange County | 87 | Closure Permanent |
1746 | 1746 | 01/14/2021 | 03/01/2021 | 01/21/2021 | Ancestry | San Francisco | San Francisco County | 60 | Closure Permanent |
1754 | 1754 | 01/14/2021 | 03/31/2021 | 01/25/2021 | L'Oreal USA Operations Open Manufacturing | Newport Beach | Orange County | 6 | Closure Permanent |
1769 | 1769 | 01/27/2021 | 04/02/2021 | 01/28/2021 | Premium Brands Services LLC | Riverside | Riverside County | 314 | Closure Permanent |
1771 | 1771 | 01/26/2021 | 04/30/2021 | 01/28/2021 | Stitch Fix Inc. | South San Francisco | San Mateo County | 162 | Closure Permanent |
1774 | 1774 | 01/28/2021 | 04/02/2021 | 01/29/2021 | CSAA Insurance Group | Fairfield | Solano County | 16 | Closure Permanent |
1775 | 1775 | 01/29/2021 | 03/20/2021 | 02/03/2021 | Jeni's Splendid Ice Creams | South El Monte | Los Angeles County | 2 | Closure Permanent |
1778 | 1778 | 02/01/2021 | 04/02/2021 | 02/04/2021 | CoorsTek Vista, Inc. | Vista | San Diego County | 20 | Closure Permanent |
1780 | 1780 | 01/29/2021 | 04/02/2021 | 02/09/2021 | Azlo Business Inc. | San Francisco | San Francisco County | 20 | Closure Permanent |
1781 | 1781 | 01/29/2021 | 04/02/2021 | 02/09/2021 | Upturn Business Inc. | San Francisco | San Francisco County | 9 | Closure Permanent |
1782 | 1782 | 02/01/2021 | 04/02/2021 | 02/09/2021 | UNIQLO California LLC | San Francisco | San Francisco County | 69 | Closure Permanent |
1783 | 1783 | 01/29/2021 | 04/19/2021 | 02/09/2021 | Paychex North America Inc.'s, a Delaware Corporation | Oxnard | Ventura County | 13 | Closure Permanent |
1784 | 1784 | 01/28/2021 | 04/18/2021 | 02/10/2021 | Transform SR LLC | Sacramento | Sacramento County | 4 | Closure Permanent |
1785 | 1785 | 01/28/2021 | 04/18/2021 | 02/10/2021 | Transform SR LLC | Sacramento | Sacramento County | 38 | Closure Permanent |
1786 | 1786 | 02/01/2021 | 04/10/2021 | 02/10/2021 | Quetico LLC | Chino | San Bernardino County | 304 | Closure Permanent |
1789 | 1789 | 01/27/2021 | 03/31/2021 | 02/10/2021 | Feed the Children | Ontario | San Bernardino County | 5 | Closure Permanent |
1790 | 1790 | 01/25/2021 | 04/15/2021 | 02/11/2021 | COA, Inc. DBA Coaster Company of America | City of Industry | Los Angeles County | 67 | Closure Permanent |
1796 | 1796 | 02/08/2021 | 04/08/2021 | 02/11/2021 | B&H Flowers | Carpinteria | Santa Barbara County | 75 | Closure Permanent |
1799 | 1799 | 02/11/2021 | 05/14/2021 | 02/16/2021 | Mechanix Wear LLC | Valencia | Los Angeles County | 27 | Closure Permanent |
1802 | 1802 | 02/12/2021 | 04/14/2021 | 02/16/2021 | True Leaf Farms, LLC | Gonzales | Monterey County | 44 | Closure Permanent |
1806 | 1806 | 02/11/2021 | 02/11/2021 | 02/16/2021 | Norwegian Air Shuttle ASA dba Norwegian Air Resources US | Los Angeles | Los Angeles County | 96 | Closure Permanent |
1824 | 1824 | 12/18/2020 | 03/01/2021 | 02/23/2021 | O.W. Lee Co., Inc. | Ontario | San Bernardino County | 120 | Closure Permanent |
1839 | 1839 | 01/20/2021 | 02/23/2021 | 02/24/2021 | PHCV, LLC dba Penske Honda Chula Vista | Chula Vista | San Diego County | 57 | Closure Permanent |
1840 | 1840 | 02/15/2021 | 02/16/2021 | 02/24/2021 | Cardenas Markets, LLC | Whittier | Los Angeles County | 97 | Closure Permanent |
1841 | 1841 | 01/19/2021 | 02/15/2021 | 02/24/2021 | Godiva Chocolatier, Inc. | Camarillo | Ventura County | 8 | Closure Permanent |
1842 | 1842 | 06/22/2015 | 03/25/2016 | 07/01/2015 | Maxim Integrated Product | San Jose | 150 | Closure 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 | |
1850 | 1850 | 06/30/2015 | 08/31/2015 | 07/06/2015 | Fusion Contacts Centers, LLC | Santa Maria | 50 | 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 );