california_warn_raw
Data source: Big Local News · About: big-local-datasette
33 rows where Layoff/Closure = "Closure Unknown at thistime"
This data as json, copyable, CSV (advanced)
Suggested facets: Notice Date, Effective Date, Received Date, City, County, Employees
Link | rowid ▼ | Notice Date | Effective Date | Received Date | Company | City | County | Employees | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
4893 | 4893 | 06/19/2020 | 06/21/2020 | 06/25/2020 | HomeState Hospitalities LLC dba HomeState | Los Angeles | Los Angeles County | 13 | Closure Unknown at thistime |
4971 | 4971 | 03/24/2020 | 03/26/2020 | 06/17/2020 | Frida Restaurant Americana LLC | Glendale | Los Angeles County | 94 | Closure Unknown at thistime |
5378 | 5378 | 04/30/2020 | 06/01/2020 | 06/02/2020 | Yellow Cab of Greater Orange County | Garden Grove | Orange County | 30 | Closure Unknown at thistime |
5441 | 5441 | 04/23/2020 | 06/22/2020 | 05/29/2020 | Trumpet Behavioral Health - Whittier | Lakewood | Los Angeles County | 23 | Closure Unknown at thistime |
5552 | 5552 | 04/01/2020 | 03/31/2020 | 05/26/2020 | ALPERT JEWISH COMMUNITY CENTER | Long Beach | Los Angeles County | 133 | Closure Unknown at thistime |
5822 | 5822 | 04/20/2020 | 04/20/2020 | 05/20/2020 | Coronado AV Guys LLC | Coronado | San Diego County | 2 | Closure Unknown at thistime |
5844 | 5844 | 03/24/2020 | 03/26/2020 | 05/19/2020 | Frida Restaurant Americana LLC, | Glendale | Los Angeles County | 94 | Closure Unknown at thistime |
6145 | 6145 | 04/29/2020 | 05/01/2020 | 05/12/2020 | Western Transit Systems Inc. | Garden Grove | Orange County | 39 | Closure Unknown at thistime |
6401 | 6401 | 04/17/2020 | 04/17/2020 | 05/02/2020 | Familly Health Centers of San Diego | San Diego | San Diego County | 109 | Closure Unknown at thistime |
6936 | 6936 | 04/10/2020 | 04/24/2020 | 04/24/2020 | Golden Gate National Parks Conservancy | San Francisco | San Francisco County | 215 | Closure Unknown at thistime |
6960 | 6960 | 04/06/2020 | 04/10/2020 | 04/23/2020 | Selma Hotel LLC dba: Dream Hollywood Hotel | Los Angeles | Los Angeles County | 67 | Closure Unknown at thistime |
7411 | 7411 | 03/17/2020 | 03/17/2020 | 04/17/2020 | Hotcakes Inc - IHOP 922 | Costa Mesa | Orange County | 54 | Closure Unknown at thistime |
7422 | 7422 | 03/17/2020 | 03/16/2020 | 04/17/2020 | Hotcakes Inc | National City | San Diego County | 95 | Closure Unknown at thistime |
7895 | 7895 | 03/31/2020 | 04/01/2020 | 04/14/2020 | Rancho Valencia Resort & Spa (RVR) | Rancho Santa Fe | San Diego County | 353 | Closure Unknown at thistime |
8161 | 8161 | 03/30/2020 | 03/20/2020 | 04/11/2020 | Spectex Inc., Dba. Specialty Textile Services | San Diego | San Diego County | 151 | Closure Unknown at thistime |
8573 | 8573 | 03/21/2020 | 03/31/2020 | 04/03/2020 | South Coast Winery Resort & Spa | Temecula | Riverside County | 205 | Closure Unknown at thistime |
8574 | 8574 | 03/21/2020 | 04/01/2020 | 04/03/2020 | Carter Estate Winery and Resort | Temecula | Riverside County | 24 | Closure Unknown at thistime |
8591 | 8591 | 03/23/2020 | 03/25/2020 | 04/03/2020 | Santa Barbara Zoo | Santa Barbara | Santa Barbara County | 120 | Closure Unknown at thistime |
8626 | 8626 | 03/14/2020 | 03/14/2020 | 04/02/2020 | North Plaza Restaurant Partners dba DragoCentro | Los Angeles | Los Angeles County | 70 | Closure Unknown at thistime |
8629 | 8629 | 03/19/2020 | 03/19/2020 | 04/02/2020 | Village Mexican Restaurant dba XOC TequilaGrill | Woodland Hills | Los Angeles County | 59 | Closure Unknown at thistime |
8630 | 8630 | 03/19/2020 | 03/19/2020 | 04/02/2020 | Frida Americana Restaurant LLC dba FridaAmericana | Glendale | Los Angeles County | 94 | Closure Unknown at thistime |
8631 | 8631 | 03/21/2020 | 03/21/2020 | 04/02/2020 | Walt's Wharf, Inc. | Seal Beach | Orange County | 82 | Closure Unknown at thistime |
8688 | 8688 | 03/20/2020 | 03/20/2020 | 04/01/2020 | Amici's East Coast Pizzeria | Vacaville | Solano County | 80 | Closure Unknown at thistime |
8712 | 8712 | 03/23/2020 | 04/30/2020 | 03/30/2020 | Taft Correctional Institution | Taft | Kern County | 322 | Closure Unknown at thistime |
8761 | 8761 | 03/19/2020 | 03/19/2020 | 03/27/2020 | Forty Five Ten Napa | Yountville | Napa County | 3 | Closure Unknown at thistime |
8799 | 8799 | 03/26/2020 | 03/23/2020 | 03/26/2020 | Pomona Valley Moning Co | Pomona | Los Angeles County | 83 | Closure Unknown at thistime |
8816 | 8816 | 03/25/2020 | 03/15/2020 | 03/26/2020 | Downtown Entertainment Group, Inc. dbaTakami Restaurant and Elevate Lounge | Los Angeles | Los Angeles County | 81 | Closure Unknown at thistime |
8827 | 8827 | 03/26/2020 | 03/26/2020 | 03/25/2020 | InterContinental Los Angeles Century City atBeverly Hills | Los Angeles | Los Angeles County | 262 | Closure Unknown at thistime |
8832 | 8832 | 03/26/2020 | 03/15/2020 | 03/25/2020 | 71 Above, Inc. dba 71Above Restaurant | Los Angeles | Los Angeles County | 120 | Closure Unknown at thistime |
8977 | 8977 | 03/09/2020 | 05/15/2020 | 03/10/2020 | Saccani Distributing Company | Sacramento | Sacramento County | 130 | Closure Unknown at thistime |
9163 | 9163 | 11/14/2019 | 12/02/2019 | 11/20/2019 | Denim-Tech, LLC | Vernon | Los Angeles County | 73 | Closure Unknown at thistime |
9171 | 9171 | 11/12/2019 | 12/13/2019 | 11/18/2019 | Albertsons Companies Inc | Union City | Alameda County | 193 | Closure Unknown at thistime |
9252 | 9252 | 10/01/2019 | 12/01/2019 | 10/10/2019 | RealWear, Inc. | San Jose | Santa Clara County | 6 | Closure 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 );