california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | Notice Date | Effective Date | Received Date | Company | City | County | Employees | Layoff/Closure |
---|---|---|---|---|---|---|---|---|---|
201 | 201 | 07/16/2020 | 08/31/2020 | 07/22/2020 | Swiss Post Solutions, Inc. | Santa Ana | Orange County | 85 | Layoff Permanent |
202 | 202 | 07/08/2020 | 07/07/2020 | 07/22/2020 | 365 Hospitality Associates, LLC dba Hyatt Place San Francisco Downtown | San Francisco | San Francisco County | 29 | Layoff Permanent |
203 | 203 | 04/16/2020 | 04/08/2020 | 07/22/2020 | Restoration Hardware | Tracy | San Joaquin County | 9 | Layoff Temporary |
204 | 204 | 04/16/2020 | 04/08/2020 | 07/22/2020 | Restoration Hardware | Tracy | San Joaquin County | 60 | Layoff Permanent |
205 | 205 | 03/25/2020 | 03/20/2020 | 07/22/2020 | Goodwill Industries of San Joaquin | Lodi | San Joaquin County | 19 | Layoff Temporary |
206 | 206 | 07/14/2020 | 07/13/2020 | 07/22/2020 | Lucky Chances Casino | Colma | San Mateo County | 489 | Closure Temporary |
207 | 207 | 06/30/2020 | 08/31/2020 | 07/22/2020 | Coca Cola North America dba Odwalla's | Santa Rosa | Sonoma County | 17 | Closure Permanent |
208 | 208 | 07/13/2020 | 07/04/2002 | 07/23/2020 | Exodus Recovery, Inc. | Los Angeles | Los Angeles County | 85 | Layoff Temporary |
209 | 209 | 07/13/2020 | 06/12/2020 | 07/23/2020 | Sinai Akiba Academy/Sinai Temple | Los Angeles | Los Angeles County | 52 | Layoff Temporary |
210 | 210 | 07/15/2020 | 07/17/2020 | 07/23/2020 | Howmet Aerospace | Fontana | San Bernardino County | 13 | Layoff Permanent |
211 | 211 | 07/13/2020 | 09/14/2020 | 07/23/2020 | Intertek USA, Inc. | San Diego | San Diego County | 66 | Closure Permanent |
212 | 212 | 07/15/2020 | 08/17/2020 | 07/23/2020 | Instacart | Sunnyvale | Santa Clara County | 14 | Layoff Permanent |
213 | 213 | 03/18/2020 | 03/20/2020 | 07/23/2020 | Goodwill Industries of Sacramento Valley and Northern Nevada | West Sacramento | Yolo County | 21 | Layoff Temporary |
214 | 214 | 07/14/2020 | 07/16/2020 | 07/23/2020 | A'viands, LLC | Seaside | Monterey County | 197 | Layoff Permanent |
215 | 215 | 03/25/2020 | 03/20/2020 | 07/23/2020 | Goodwill Industries Bulk Buying SJV | Fresno | Fresno County | 24 | Layoff Temporary |
216 | 216 | 03/25/2020 | 03/20/2020 | 07/23/2020 | Goodwill Industries of San Joaquin Madera | Madera | Madera County | 18 | Layoff Temporary |
217 | 217 | 07/15/2020 | 07/13/2020 | 07/23/2020 | Howmet Aerospace | Rancho Cucamonga | San Bernardino County | 239 | Layoff Temporary |
218 | 218 | 07/15/2020 | 07/01/2020 | 07/23/2020 | Dave and Buster's | Ontario | San Bernardino County | 68 | Layoff Temporary |
219 | 219 | 07/14/2020 | 07/13/2020 | 07/23/2020 | Lucky Business Services, Inc dba Lucky Chances Casino | San Francisco | San Francisco County | 220 | Closure Temporary |
220 | 220 | 03/25/2020 | 03/20/2020 | 07/23/2020 | Goodwill Industries of San Joaquin-Stockton | Stockton | San Joaquin County | 23 | Layoff Temporary |
221 | 221 | 05/04/2020 | 07/06/2020 | 07/23/2020 | Verity Health System of California, Inc. | Daly City | San Mateo County | 1284 | Layoff Permanent |
222 | 222 | 05/04/2020 | 07/06/2020 | 07/23/2020 | Verity Health System of California, Inc. dba Verity Business Services | Daly City | San Mateo County | 27 | Layoff Permanent |
223 | 223 | 05/04/2020 | 07/06/2020 | 07/23/2020 | Verity Health System of California, Inc. dba VHS | Daly City | San Mateo County | 9 | Layoff Permanent |
224 | 224 | 03/25/2020 | 03/20/2020 | 07/23/2020 | Goodwill Industries of San Joaquin Valley | Turlock | Stanislaus County | 16 | Layoff Temporary |
225 | 225 | 03/25/2020 | 03/20/2020 | 07/23/2020 | Goodwill San Joaquin Valley | Visalia | Tulare County | 18 | Layoff Temporary |
226 | 226 | 07/17/2020 | 07/17/2020 | 07/24/2020 | Designed Metal Connection, Inc. | Gardena | Los Angeles County | 159 | Layoff Permanent |
227 | 227 | 07/17/2020 | 07/17/2020 | 07/24/2020 | PT Gaming, LLC dba Capitol Casino - Sacramento Facility | Sacramento | Sacramento County | 43 | Layoff Permanent |
228 | 228 | 07/17/2020 | 09/23/2020 | 07/24/2020 | JC Penney | Chino | San Bernardino County | 80 | Closure Permanent |
229 | 229 | 07/17/2020 | 08/01/2020 | 07/24/2020 | West CCRA, LLC dba West Steak and Seafood | Carlsbad | San Diego County | 56 | Closure Permanent |
230 | 230 | 04/09/2020 | 04/12/2020 | 07/24/2020 | Scripps Health | Encinitas | San Diego County | 31 | Layoff Temporary |
231 | 231 | 07/17/2020 | 07/17/2020 | 07/24/2020 | PT Gaming, LLC dba Artichoke Joe's Casino | San Bruno | San Mateo County | 124 | Layoff Permanent |
232 | 232 | 07/17/2020 | 09/18/2020 | 07/24/2020 | Genentech, Inc. and Genentech USA, Inc. | South San Francisco | San Mateo County | 474 | Layoff Permanent |
233 | 233 | 07/16/2020 | 07/17/2020 | 07/24/2020 | PT Gaming, LLC dba Bay 101 Casino | San Jose | Santa Clara County | 99 | Layoff Permanent |
234 | 234 | 07/17/2020 | 07/17/2020 | 07/24/2020 | PT Gaming, LLC dba Casino Club - Redding Facility | Redding | Shasta County | 4 | Layoff Permanent |
235 | 235 | 07/17/2020 | 07/17/2020 | 07/24/2020 | PT Gaming, LLC dba California Grand Casino - Pacheco Facility | Fairfield | Solano County | 34 | Layoff Permanent |
236 | 236 | 07/16/2020 | 09/15/2020 | 07/24/2020 | Camarillo Harvesting, L.P. | Ventura | Ventura County | 161 | Layoff Permanent |
237 | 237 | 07/15/2020 | 07/09/2020 | 07/24/2020 | ASM Global - Oakland | Concord | Contra Costa County | 13 | Layoff Temporary |
238 | 238 | 03/27/2020 | 03/20/2020 | 07/24/2020 | Angels Baseball LP | Anaheim | Orange County | 1 | Closure Type Unknown |
239 | 239 | 06/15/2020 | 06/12/2020 | 07/24/2020 | Jacobsen Daniels Enterprise, Inc. | Los Angeles | Los Angeles County | 4 | Layoff Permanent |
240 | 240 | 07/02/2020 | 07/02/2020 | 07/24/2020 | Parkwest Casino Lotus | Sacramento | Sacramento County | 167 | Layoff Temporary |
241 | 241 | 04/22/2020 | 03/19/2020 | 07/24/2020 | ALCC, LLC | Santa Barbara | Santa Barbara County | 1 | Layoff Type Unknown |
242 | 242 | 05/18/2020 | 06/05/2020 | 07/24/2020 | Uber Technologies, Inc. | Palo Alto | Santa Clara County | 167 | Layoff Permanent |
243 | 243 | 03/25/2020 | 03/20/2020 | 07/24/2020 | Goodwill Industries of San Joaquin-Turlock | Turlock | Stanislaus County | 19 | Layoff Temporary |
244 | 244 | 03/25/2020 | 03/20/2020 | 07/24/2020 | Goodwill Industries- San Joaquin | Modesto | Stanislaus County | 18 | Layoff Temporary |
245 | 245 | 04/22/2020 | 03/19/2020 | 07/24/2020 | Los Agaves Inc | Oxnard | Ventura County | 1 | Layoff Type Unknown |
246 | 246 | 04/23/2020 | 03/24/2020 | 07/27/2020 | Meribear Productions, Inc. dba Meredith Baer Home | South Gate | Los Angeles County | 133 | Layoff Temporary |
247 | 247 | 07/23/2020 | 09/21/2020 | 07/27/2020 | AT&T | El Segundo | Los Angeles County | 64 | Layoff Permanent |
248 | 248 | 03/30/2020 | 04/03/2020 | 07/27/2020 | Embassy Suites Irvine | Irvine | Orange County | 77 | Closure Temporary |
249 | 249 | 04/23/2020 | 04/23/2020 | 07/27/2020 | Hardin Automotive dba Hardin Buick Pontiac GMC | Anaheim | Orange County | 58 | Closure Temporary |
250 | 250 | 07/23/2020 | 07/08/2020 | 07/27/2020 | Johnson hospitality Services Associates LLC | Los Altos | Santa Clara County | 46 | Layoff Permanent |
251 | 251 | 07/23/2020 | 07/26/2020 | 07/27/2020 | Universal City Studios LLC dba Universal Studios Hollywood | Universal City | Los Angeles County | 37 | Layoff Temporary |
252 | 252 | 07/23/2020 | 07/29/2020 | 07/27/2020 | Howmet Aerospace | Fontana | San Bernardino County | 152 | Layoff Temporary |
253 | 253 | 07/07/2020 | 07/01/2020 | 07/27/2020 | Gatan, Inc | Pleasanton | Alameda County | 105 | Layoff Temporary |
254 | 254 | 07/22/2020 | 03/25/2020 | 07/27/2020 | Seaside Dining Group - Denny's | Maywood | Los Angeles County | 61 | Layoff Temporary |
255 | 255 | 04/06/2020 | 04/06/2020 | 07/27/2020 | Pacific Dental Services, LLC | Irvine | Orange County | 107 | Layoff Temporary |
256 | 256 | 07/06/2020 | 08/28/2020 | 07/27/2020 | APL America LLC | Newport Beach | Orange County | 44 | Layoff Permanent |
257 | 257 | 07/15/2020 | 10/02/2020 | 07/27/2020 | Zodiac Pool Systems LLC | Rancho Santa Margarita | Orange County | 15 | Closure Permanent |
258 | 258 | 07/21/2020 | 09/20/2020 | 07/27/2020 | Gannett Publishing Services/Palm Springs | Palm Springs | Riverside County | 36 | Layoff Permanent |
259 | 259 | 07/02/2020 | 07/02/2020 | 07/27/2020 | Parkwest Casino Cordova | Rancho Cordova | Sacramento County | 99 | Layoff Temporary |
260 | 260 | 07/02/2020 | 07/02/2020 | 07/27/2020 | LODI CARDROOM, INC. | Lodi | San Joaquin County | 122 | Layoff Temporary |
261 | 261 | 07/22/2020 | 03/25/2020 | 07/27/2020 | Seaside Dining Group, Inc. - Denny's | San Jose | Santa Clara County | 213 | Layoff Temporary |
262 | 262 | 07/17/2020 | 07/17/2020 | 07/28/2020 | PT Gaming, LLC dba Oak's Card Club - Emeryville Facility | Emeryville | Alameda County | 71 | Layoff Permanent |
263 | 263 | 07/17/2020 | 07/17/2020 | 07/28/2020 | PT Gaming, LLC dba Diamond Jim's Casino - Rosamund Facility | Rosamond | Kern County | 20 | Layoff Permanent |
264 | 264 | 07/20/2020 | 07/24/2020 | 07/28/2020 | Adventist Health dba AH Delano | Delano | Kern County | 71 | Layoff Permanent |
265 | 265 | 07/20/2020 | 06/26/2020 | 07/28/2020 | Oparc | Montclair | San Bernardino County | 4 | Layoff Temporary |
266 | 266 | 07/20/2020 | 06/26/2020 | 07/28/2020 | Oparc | San Bernardino | San Bernardino County | 32 | Layoff Temporary |
267 | 267 | 07/17/2020 | 08/08/2020 | 07/28/2020 | Stratasys Direct, Inc. | Poway | San Diego County | 71 | Layoff Temporary |
268 | 268 | 07/17/2020 | 07/17/2020 | 07/28/2020 | PT Gaming, LLC | Manteca | San Joaquin County | 94 | Layoff Permanent |
269 | 269 | 07/23/2020 | 06/19/2020 | 07/28/2020 | Avatar Foods International Inc, dba Global Gourmet Catering | Saratoga | Santa Clara County | 10 | Layoff Temporary |
270 | 270 | 07/23/2020 | 06/30/2020 | 07/28/2020 | LSI-Silvercreek, LLC. | San Jose | Santa Clara County | 139 | Layoff Type Unknown |
271 | 271 | 04/02/2020 | 03/31/2020 | 07/28/2020 | Dentemploy, Inc. | Fairfield | Solano County | 7 | Layoff Temporary |
272 | 272 | 04/10/2020 | 04/10/2020 | 07/28/2020 | Beta Beauty, LLC | Oxnard | Ventura County | 2 | Layoff Temporary |
273 | 273 | 04/10/2020 | 04/10/2020 | 07/28/2020 | ColourPop Cosmetics, LLC | Oxnard | Ventura County | 9 | Layoff Permanent |
274 | 274 | 04/10/2020 | 04/10/2020 | 07/28/2020 | The Spatz Corporation | Oxnard | Ventura County | 1 | Layoff Temporary |
275 | 275 | 07/28/2020 | 08/31/2020 | 07/28/2020 | test | West Sacramento | Yolo County | 52 | Layoff Temporary |
276 | 276 | 03/27/2020 | 03/27/2020 | 07/28/2020 | Angels Baseball LP Operations | Anaheim | Orange County | 1 | Layoff Type Unknown |
277 | 277 | 06/26/2020 | 06/26/2020 | 07/28/2020 | MOCA | Los Angeles | Los Angeles County | 5 | Closure Temporary |
278 | 278 | 07/23/2020 | 07/26/2020 | 07/28/2020 | Mayfield House, LLC dba Mayfield Bakery and Cafe | Palo Alto | Santa Clara County | 51 | Layoff Permanent |
279 | 279 | 07/06/2020 | 07/10/2020 | 07/29/2020 | Course At Wente Vineyards | Livermore | Alameda County | 48 | Layoff Type Unknown |
280 | 280 | 07/06/2020 | 07/10/2020 | 07/29/2020 | Wente Family Estates | Livermore | Alameda County | 331 | Closure Temporary |
281 | 281 | 05/08/2020 | 04/15/2020 | 07/29/2020 | Ricoh USA, Inc. | Culver City | Los Angeles County | 25 | Layoff Temporary |
282 | 282 | 07/23/2020 | 07/23/2020 | 07/29/2020 | NBCU et al | Universal City | Los Angeles County | 24 | Layoff Permanent |
283 | 283 | 07/23/2020 | 07/27/2020 | 07/29/2020 | Honeywell | Torrance | Los Angeles County | 260 | Layoff Temporary |
284 | 284 | 07/07/2020 | 07/07/2020 | 07/29/2020 | Summit Machine Inc | Ontario | San Bernardino County | 41 | Layoff Permanent |
285 | 285 | 07/20/2020 | 07/17/2020 | 07/29/2020 | Torrid, LLC | Ventura | Ventura County | 7 | Layoff Temporary |
286 | 286 | 07/24/2020 | 09/24/2020 | 07/29/2020 | Fairmont San Francisco | San Francisco | San Francisco County | 511 | Layoff Temporary |
287 | 287 | 07/15/2020 | 10/01/2020 | 07/29/2020 | American Airlines, Inc. - Oakland International Airport | Oakland | Alameda County | 378 | Layoff Temporary |
288 | 288 | 07/15/2020 | 10/01/2020 | 07/29/2020 | American Airlines, Inc. - Los Angeles International Airport | Los Angeles | Los Angeles County | 1890 | Layoff Temporary |
289 | 289 | 07/15/2020 | 10/01/2020 | 07/29/2020 | American Airlines, Inc. - San Francisco International Airport | San Francisco | San Francisco County | 378 | Layoff Temporary |
290 | 290 | 07/07/2020 | 07/07/2020 | 07/30/2020 | Applebee's Neithborhood Bar and Grill | Chatsworth | Los Angeles County | 51 | Layoff Temporary |
291 | 291 | 07/24/2020 | 09/24/2020 | 07/30/2020 | Crescent Resorts & Hotels, LLC dba Four Points by Sheraton LAX | Los Angeles | Los Angeles County | 28 | Closure Permanent |
292 | 292 | 07/17/2020 | 09/30/2020 | 07/30/2020 | Western Automotive Group LLC dba Big O Tires | Newport Beach | Orange County | 5 | Closure Permanent |
293 | 293 | 07/24/2020 | 07/28/2020 | 07/30/2020 | Hakkasan Holdings LLC dba Hakkasan Group | San Diego | San Diego County | 36 | Layoff Temporary |
294 | 294 | 07/28/2020 | 07/24/2020 | 07/30/2020 | In-Shape Health Clubs, LLC | Stockton | San Joaquin County | 20 | Closure Temporary |
295 | 295 | 07/28/2020 | 07/28/2020 | 07/30/2020 | Fujitsu Network Communications, Inc. | Sunnyvale | Santa Clara County | 70 | Layoff Permanent |
296 | 296 | 05/08/2020 | 04/13/2020 | 07/30/2020 | Ricoh USA, Inc. | Camarillo | Ventura County | 9 | Layoff Temporary |
297 | 297 | 07/24/2020 | 05/01/2020 | 07/30/2020 | SAG-AFTRA | Los Angeles | Los Angeles County | 60 | Layoff Permanent |
298 | 298 | 07/27/2020 | 07/02/2020 | 07/30/2020 | Ross Stores, Inc | El Centro | Imperial County | 153 | Layoff Temporary |
299 | 299 | 07/16/2020 | 09/14/2020 | 07/30/2020 | Camarillo Harvesting, LP | Spreckels | Monterey County | 161 | Layoff Permanent |
300 | 300 | 07/28/2020 | 07/15/2020 | 07/30/2020 | Dolphin California Management and Oasis Outsourcing, Inc. dba Westin Mission Hills Hotel | Rancho Mirage | Riverside County | 314 | Layoff Temporary |
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 );