california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Layoff/Closure descending
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 ▲ |
---|---|---|---|---|---|---|---|---|---|
4901 | 4901 | 04/03/2020 | 04/04/2020 | 06/25/2020 | Club Demonstration Services | Oxnard | Ventura County | 132 | Layoff Unknown at thistime |
4902 | 4902 | 04/03/2020 | 04/04/2020 | 06/25/2020 | Club Demonstration Services, Inc. | Woodland | Yolo County | 26 | Layoff Unknown at thistime |
4928 | 4928 | 06/11/2020 | 06/12/2020 | 06/23/2020 | Connected Apparel Company LLC | Commerce | Los Angeles County | 32 | Layoff Unknown at thistime |
5045 | 5045 | 06/04/2020 | 06/15/2020 | 06/11/2020 | Reuland Electric Co | City of Industry | Los Angeles County | 74 | Layoff Unknown at thistime |
5190 | 5190 | 05/20/2020 | 05/20/2020 | 06/06/2020 | University Corporation at Monterey Bay | Seaside | Monterey County | 93 | Layoff Unknown at thistime |
5240 | 5240 | 05/08/2020 | 03/20/2020 | 06/05/2020 | Hillstone Restaurant Group, Inc. DBAHouston's Restaurant | Pasadena | Los Angeles County | 61 | Layoff Unknown at thistime |
5241 | 5241 | 05/08/2020 | 03/20/2020 | 06/05/2020 | Hillstone Restaurant Group, Inc. DBA SouthBeverly Grill Restaurant | Beverly Hills | Los Angeles County | 64 | Layoff Unknown at thistime |
5253 | 5253 | 05/08/2020 | 03/20/2020 | 06/05/2020 | Hillstone Restaurant Group, Inc DBAGulfstream Restaurant | Newport Beach | Orange County | 63 | Layoff Unknown at thistime |
5280 | 5280 | 03/24/2020 | 03/26/2020 | 06/05/2020 | Intercontinental Los Angeles Downtown | Los Angeles | Los Angeles County | 840 | Layoff Unknown at thistime |
5333 | 5333 | 05/05/2020 | 03/27/2020 | 06/04/2020 | California Fish Grill | San Jose | Santa Clara County | 22 | Layoff Unknown at thistime |
5366 | 5366 | 05/15/2020 | 05/15/2020 | 06/03/2020 | The New Children's Museum | San Diego | San Diego County | 52 | Layoff Unknown at thistime |
5445 | 5445 | 04/16/2020 | 05/16/2020 | 05/29/2020 | LOS ANGELES TIMES COMMUNICATIONS | Los Angeles | Los Angeles County | 14 | Layoff Unknown at thistime |
5446 | 5446 | 04/30/2020 | 06/01/2020 | 05/29/2020 | Keolis Transit Service LLC | Garden Grove | Orange County | 19 | Layoff Unknown at thistime |
5571 | 5571 | 04/13/2020 | 03/31/2020 | 05/26/2020 | Rocket Farms, Inc. | Half Moon Bay | San Mateo County | 7 | Layoff Unknown at thistime |
5630 | 5630 | 04/01/2020 | 03/16/2020 | 05/23/2020 | Fit Athletic Club | San Diego | San Diego County | 321 | Layoff Unknown at thistime |
5638 | 5638 | 03/20/2020 | 03/20/2020 | 05/22/2020 | International Grill, Inc. dba Massis Kabob | Arcadia | Los Angeles County | 14 | Layoff Unknown at thistime |
5639 | 5639 | 03/20/2020 | 03/20/2020 | 05/22/2020 | International Grill, Inc. dba Massis Kabob | Culver City | Los Angeles County | 15 | Layoff Unknown at thistime |
5640 | 5640 | 03/20/2020 | 03/20/2020 | 05/22/2020 | International Grill, Inc. dba Massis Kabob | Glendale | Los Angeles County | 34 | Layoff Unknown at thistime |
5681 | 5681 | 03/23/2020 | 03/23/2020 | 05/22/2020 | Concord Toyota | Concord | Contra Costa County | 32 | Layoff Unknown at thistime |
5691 | 5691 | 03/27/2020 | 03/30/2020 | 05/22/2020 | IP Entertainment LLC dba Pins N Pockets | Lake Elsinore | Riverside County | 133 | Layoff Unknown at thistime |
5712 | 5712 | 04/09/2020 | 03/31/2020 | 05/21/2020 | Growers Transplanting, Inc | Salinas | Monterey County | 34 | Layoff Unknown at thistime |
5740 | 5740 | 03/27/2020 | 03/17/2020 | 05/21/2020 | Novo Construction Inc. | Menlo Park | San Mateo County | 22 | Layoff Unknown at thistime |
5741 | 5741 | 04/13/2020 | 04/17/2020 | 05/21/2020 | Gardner Family Health Network, Inc. | San Jose | Santa Clara County | 158 | Layoff Unknown at thistime |
5742 | 5742 | 04/06/2020 | 03/20/2020 | 05/21/2020 | Hilton Hotel Employer, LLC, Hilton San Jose | San Jose | Santa Clara County | 157 | Layoff Unknown at thistime |
5843 | 5843 | 03/25/2020 | 04/01/2020 | 05/19/2020 | HotelCrafters LA LLC DBA The Standard,Downtown LA | Los Angeles | Los Angeles County | 184 | Layoff Unknown at thistime |
5860 | 5860 | 03/24/2020 | 03/24/2020 | 05/19/2020 | FUTURE FOAM | FULLERTON | Orange County | 98 | Layoff Unknown at thistime |
5885 | 5885 | 03/19/2020 | 03/20/2020 | 05/19/2020 | FLYING FOOD GROUP | Burlingame | San Mateo County | 14 | Layoff Unknown at thistime |
5897 | 5897 | 05/15/2020 | 05/01/2020 | 05/19/2020 | Amada America, Inc. | Brea | Orange County | 34 | Layoff Unknown at thistime |
5901 | 5901 | 03/31/2020 | 03/24/2020 | 05/19/2020 | Riverside Metro Auto Group, LLC, RiversideMetro Dealer, LLC, and Riverside MetroPartner, LLC. | Riverside | Riverside County | 51 | Layoff Unknown at thistime |
5930 | 5930 | 03/24/2020 | 03/18/2020 | 05/18/2020 | Fortune Builders, Inc., | San Diego | San Diego County | 154 | Layoff Unknown at thistime |
5941 | 5941 | 03/11/2020 | 03/11/2020 | 05/18/2020 | Hilton San Francisco Airport Bayfront | Burlingame | San Mateo County | 110 | Layoff Unknown at thistime |
5956 | 5956 | 04/26/2020 | 04/26/2020 | 05/18/2020 | Enterprise Rent-A-Car Co of Sacramento, LLC | Roseville | Placer County | 199 | Layoff Unknown at thistime |
5963 | 5963 | 03/16/2020 | 03/16/2020 | 05/15/2020 | NoMad Hotel Manager LA LLC | Los Angeles | Los Angeles County | 59 | Layoff Unknown at thistime |
5982 | 5982 | 03/21/2020 | 03/23/2020 | 05/15/2020 | Renoir HM, LLC dba San Francisco ProperHotel | San Francisco | San Francisco County | 149 | Layoff Unknown at thistime |
6004 | 6004 | 05/15/2020 | 05/01/2020 | 05/15/2020 | Amada America, Inc. | Brea | Orange County | 34 | Layoff Unknown at thistime |
6005 | 6005 | 03/19/2020 | 03/19/2020 | 05/15/2020 | Associated Students Sacramento State | Sacramento | Sacramento County | 227 | Layoff Unknown at thistime |
6012 | 6012 | 03/27/2020 | 03/17/2020 | 05/15/2020 | YMCA of Silicon Valley | Santa Clara | Santa Clara County | 1657 | Layoff Unknown at thistime |
6017 | 6017 | 03/24/2020 | 03/20/2020 | 05/14/2020 | FSC Corporation dba Il Pastaio | Beverly Hills | Los Angeles County | 148 | Layoff Unknown at thistime |
6030 | 6030 | 03/20/2020 | 03/17/2020 | 05/14/2020 | BAILEY FOOD AND BEVERAGE GROUP DBATHE LIBRARY GENTLEMEN'S | Anaheim | Orange County | 155 | Layoff Unknown at thistime |
6031 | 6031 | 03/19/2020 | 03/19/2020 | 05/14/2020 | Marriott Rancho Cordova | Rancho Cordova | Sacramento County | 100 | Layoff Unknown at thistime |
6033 | 6033 | 03/28/2020 | 04/01/2020 | 05/14/2020 | Valley Ho Hotels aka Kings Inn | San Diego | San Diego County | 82 | Layoff Unknown at thistime |
6050 | 6050 | 03/24/2020 | 03/24/2020 | 05/14/2020 | FAA CONCORD H DBA CONCORD HONDA | Concord | Contra Costa County | 49 | Layoff Unknown at thistime |
6101 | 6101 | 05/07/2020 | 05/07/2020 | 05/13/2020 | Queen Mary Hotel - Urban CommonsQueensway | Long Beach | Los Angeles County | 480 | Layoff Unknown at thistime |
6117 | 6117 | 05/07/2020 | 05/07/2020 | 05/13/2020 | Queen Mary Hotel | Long Beach | Los Angeles County | 80 | Layoff Unknown at thistime |
6118 | 6118 | 05/07/2020 | 05/07/2020 | 05/13/2020 | Sheraton Pasadena Hotel | Pasadena | Los Angeles County | 102 | Layoff Unknown at thistime |
6119 | 6119 | 05/07/2020 | 05/07/2020 | 05/13/2020 | Embassy Suites Anaheim North Hotel | Anaheim | Orange County | 72 | Layoff Unknown at thistime |
6244 | 6244 | 03/20/2020 | 03/20/2020 | 05/09/2020 | Maxfield Enterprises, Inc. | West Hollywood | Los Angeles County | 29 | Layoff Unknown at thistime |
6283 | 6283 | 04/23/2020 | 04/26/2020 | 05/05/2020 | Weber Metals Inc. an OTTO FUCHS Company | Paramount | Los Angeles County | 181 | Layoff Unknown at thistime |
6336 | 6336 | 04/24/2020 | 04/14/2020 | 05/04/2020 | The Hertz Corporation, dba Hertz | San Jose | Santa Clara County | 76 | Layoff Unknown at thistime |
6351 | 6351 | 04/15/2020 | 04/09/2020 | 05/02/2020 | Bedding Acquisition, LLC | Pico Rivera | Los Angeles County | 113 | Layoff Unknown at thistime |
6352 | 6352 | 04/15/2020 | 04/09/2020 | 05/02/2020 | Pacific Coast Feather Cushion LLC | Pico Rivera | Los Angeles County | 20 | Layoff Unknown at thistime |
6358 | 6358 | 04/28/2020 | 04/28/2020 | 05/02/2020 | Hycore Biomedical Inc. LLC | Garden Grove | Orange County | 68 | Layoff Unknown at thistime |
6374 | 6374 | 04/20/2020 | 05/02/2020 | 05/02/2020 | Ports America | San Pedro | Los Angeles County | 21 | Layoff Unknown at thistime |
6375 | 6375 | 04/20/2020 | 05/08/2020 | 05/02/2020 | Marine Terminals Corporation (dba PortsAmerica) | San Pedro | Los Angeles County | 97 | Layoff Unknown at thistime |
6451 | 6451 | 04/21/2020 | 03/30/2020 | 05/01/2020 | Connect Homes | San Bernardino | San Bernardino County | 41 | Layoff Unknown at thistime |
6477 | 6477 | 04/23/2020 | 04/03/2020 | 05/01/2020 | KNBC-TV, LLC | Universal City | Los Angeles County | 46 | Layoff Unknown at thistime |
6478 | 6478 | 04/23/2020 | 04/03/2020 | 05/01/2020 | Universal Content Productions, LLC | Los Angeles | Los Angeles County | 27 | Layoff Unknown at thistime |
6479 | 6479 | 04/23/2020 | 04/03/2020 | 05/01/2020 | Universal Content Productions, LLC | Universal City | Los Angeles County | 147 | Layoff Unknown at thistime |
6483 | 6483 | 04/10/2020 | 04/10/2020 | 05/01/2020 | Clark Pacific | Woodland | Yolo County | 100 | Layoff Unknown at thistime |
6487 | 6487 | 04/23/2020 | 04/03/2020 | 05/01/2020 | Open 4 Business Productions, LLC | Universal City | Los Angeles County | 17 | Layoff Unknown at thistime |
6528 | 6528 | 04/17/2020 | 03/16/2020 | 04/30/2020 | Victoria Club | Riverside | Riverside County | 66 | Layoff Unknown at thistime |
6559 | 6559 | 04/21/2020 | 03/19/2020 | 04/30/2020 | Westin Bonaventure Hotel & Suites | Los Angeles | Los Angeles County | 51 | Layoff Unknown at thistime |
6562 | 6562 | 04/20/2020 | 04/22/2020 | 04/30/2020 | Citadel Servicing Corporation | Irvine | Orange County | 108 | Layoff Unknown at thistime |
6584 | 6584 | 04/07/2020 | 03/28/2020 | 04/29/2020 | Goodwill Industries of Orange County | Santa Ana | Orange County | 122 | Layoff Unknown at thistime |
6652 | 6652 | 04/18/2020 | 04/24/2020 | 04/29/2020 | Tempo Automation | San Francisco | San Francisco County | 54 | Layoff Unknown at thistime |
6692 | 6692 | 03/17/2020 | 03/16/2020 | 04/28/2020 | Hof's Hut Restaurants, Inc. dba Lucille'sSmokehouse Bar-B-Que | Rancho Cucamonga | San Bernardino County | 103 | Layoff Unknown at thistime |
6728 | 6728 | 03/17/2020 | 03/18/2020 | 04/28/2020 | Hof's Hut Restaurants, Inc. dba Lucille'sSmokehouse Bar-B-Que | Rancho Cucamonga | San Bernardino County | 88 | Layoff Unknown at thistime |
6755 | 6755 | 04/08/2020 | 03/16/2020 | 04/27/2020 | V. Sattui Winery | Saint Helena | Napa County | 82 | Layoff Unknown at thistime |
6759 | 6759 | 04/15/2020 | 04/15/2020 | 04/27/2020 | Cashbak, LLC | San Bernardino | San Bernardino County | 18 | Layoff Unknown at thistime |
6766 | 6766 | 04/13/2020 | 04/10/2020 | 04/27/2020 | Fry's Electronics Inc. | San Jose | Santa Clara County | 57 | Layoff Unknown at thistime |
6770 | 6770 | 04/16/2020 | 05/16/2020 | 04/27/2020 | Times Community News, North | Los Angeles | Los Angeles County | 13 | Layoff Unknown at thistime |
6777 | 6777 | 04/03/2020 | 04/03/2020 | 04/27/2020 | Enterprise Rent-A-Car Co of San Francisco,LLC | San Jose | Santa Clara County | 44 | Layoff Unknown at thistime |
7039 | 7039 | 04/08/2020 | 04/06/2020 | 04/21/2020 | Golden State Drilling, Inc | Bakersfield | Kern County | 130 | Layoff Unknown at thistime |
7060 | 7060 | 04/06/2020 | 03/23/2020 | 04/21/2020 | Caliber Motors Inc., dba Mercedes-Benz ofAnaheim | Anaheim | Orange County | 73 | Layoff Unknown at thistime |
7079 | 7079 | 03/25/2020 | 03/18/2020 | 04/21/2020 | Ra Sushi Chino Hills Corp | Chino Hills | San Bernardino County | 53 | Layoff Unknown at thistime |
7237 | 7237 | 04/01/2020 | 04/03/2020 | 04/20/2020 | STANCE | San Clemente | Orange County | 65 | Layoff Unknown at thistime |
7283 | 7283 | 04/02/2020 | 03/24/2020 | 04/20/2020 | Pancakes 1702 INC | Chico | Butte County | 45 | Layoff Unknown at thistime |
7307 | 7307 | 04/02/2020 | 03/24/2020 | 04/20/2020 | Pancakes, Inc | Sacramento | Sacramento County | 327 | Layoff Unknown at thistime |
7315 | 7315 | 04/01/2020 | 03/31/2020 | 04/20/2020 | Cafe Venue dba Cafe Venue Fifth Street | San Francisco | San Francisco County | 12 | Layoff Unknown at thistime |
7316 | 7316 | 04/01/2020 | 03/31/2020 | 04/20/2020 | Cafe Venue dba Cafe Venue Fremont | San Francisco | San Francisco County | 12 | Layoff Unknown at thistime |
7317 | 7317 | 04/01/2020 | 03/31/2020 | 04/20/2020 | Cafe Venue dba Cafe Venue Montgomery | San Francisco | San Francisco County | 14 | Layoff Unknown at thistime |
7318 | 7318 | 04/01/2020 | 03/31/2020 | 04/20/2020 | Local Roots | San Francisco | San Francisco County | 9 | Layoff Unknown at thistime |
7319 | 7319 | 04/02/2020 | 03/24/2020 | 04/20/2020 | Pancakes 3546 INC | Stockton | San Joaquin County | 33 | Layoff Unknown at thistime |
7329 | 7329 | 04/02/2020 | 03/24/2020 | 04/20/2020 | Pancakes 3552 INC | San Jose | Santa Clara County | 82 | Layoff Unknown at thistime |
7330 | 7330 | 04/02/2020 | 03/24/2020 | 04/20/2020 | Pancakes 688 INC | Vallejo | Solano County | 29 | Layoff Unknown at thistime |
7417 | 7417 | 04/01/2020 | 03/31/2020 | 04/17/2020 | Pechanga Resorts Incorporated dba TemeculaCreek Inn | Temecula | Riverside County | 248 | Layoff Unknown at thistime |
7435 | 7435 | 04/03/2020 | 04/07/2020 | 04/17/2020 | Goodwill of Silicon Valley | San Jose | Santa Clara County | 617 | Layoff Unknown at thistime |
7450 | 7450 | 04/02/2020 | 04/03/2020 | 04/17/2020 | Brentwood Originals Inc | Carson | Los Angeles County | 17 | Layoff Unknown at thistime |
7573 | 7573 | 04/01/2020 | 03/18/2020 | 04/16/2020 | Bottaia Wines LP - Bottaia Winery | Temecula | Riverside County | 29 | Layoff Unknown at thistime |
7574 | 7574 | 04/01/2020 | 03/18/2020 | 04/16/2020 | Ponte Vineyard Inn LLC | Temecula | Riverside County | 85 | Layoff Unknown at thistime |
7575 | 7575 | 04/01/2020 | 03/18/2020 | 04/16/2020 | Wine Road Vintners LLC - Ponte Family Estate | Temecula | Riverside County | 129 | Layoff Unknown at thistime |
7596 | 7596 | 03/28/2020 | 03/27/2020 | 04/16/2020 | HOSOPO, CORPORATION DBA SUNGEVITY | Tracy | San Joaquin County | 25 | Layoff Unknown at thistime |
7662 | 7662 | 04/02/2020 | 06/01/2020 | 04/16/2020 | Ashford University, LLC | San Diego | San Diego County | 11 | Layoff Unknown at thistime |
7672 | 7672 | 04/02/2020 | 04/02/2020 | 04/16/2020 | InterContinental San Francisco | San Francisco | San Francisco County | 244 | Layoff Unknown at thistime |
7714 | 7714 | 04/01/2020 | 03/21/2020 | 04/15/2020 | Araca Merchandise LP. | San Fernando | Los Angeles County | 84 | Layoff Unknown at thistime |
7726 | 7726 | 04/01/2020 | 03/17/2020 | 04/15/2020 | Manhattan Beachwear, Inc | Cypress | Orange County | 155 | Layoff Unknown at thistime |
7793 | 7793 | 03/23/2020 | 03/23/2020 | 04/15/2020 | First Step Staffing/Employee ManagementSolutions LP | Torrance | Los Angeles County | 193 | Layoff Unknown at thistime |
7795 | 7795 | 03/31/2020 | 04/04/2020 | 04/15/2020 | Club Demonstration | Roseville | Placer County | 32 | Layoff Unknown at thistime |
7876 | 7876 | 03/28/2020 | 04/01/2020 | 04/14/2020 | Wilshire Country Club | Los Angeles | Los Angeles County | 98 | Layoff Unknown at thistime |
7897 | 7897 | 03/27/2020 | 03/26/2020 | 04/14/2020 | Frank Motors Inc | National City | San Diego County | 22 | Layoff Unknown at thistime |
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 );