california_warn_raw
Data source: Big Local News · About: big-local-datasette
10,033 rows sorted by Employees 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 |
---|---|---|---|---|---|---|---|---|---|
6130 | 6130 | 05/05/2020 | 04/13/2020 | 05/12/2020 | Tesla, Inc | Fremont | Alameda County | 11083 | Layoff Temporary |
1007 | 1007 | 07/08/2020 | 10/01/2020 | 09/28/2020 | United Airlines, Inc. - San Francisco International Airport | San Francisco | San Francisco County | 6912 | Layoff Temporary |
6370 | 6370 | 04/27/2020 | 04/20/2020 | 05/02/2020 | Fox Sports Productions, LLC | Los Angeles | Los Angeles County | 3595 | Layoff Temporary |
1833 | 1833 | 01/29/2021 | 04/01/2021 | 02/23/2021 | United Airlines - SFO | San Francisco | San Francisco County | 3139 | Layoff Temporary |
7651 | 7651 | 03/31/2020 | 04/01/2020 | 04/16/2020 | Pacific Dental Services, LLC | Irvine | Orange County | 3029 | Layoff Temporary |
6100 | 6100 | 05/07/2020 | 05/03/2020 | 05/13/2020 | UNIVERSAL CITY STUDIOS DBAUNIVERSAL STUDIOS HOLLYWOOD | Universal City | Los Angeles County | 3025 | Layoff Temporary |
1888 | 1888 | 07/20/2015 | 12/31/2017 | 07/22/2015 | Toyota Motor North America | Torrance | 3000 | Closure Permanent | |
5570 | 5570 | 04/03/2020 | 04/06/2020 | 05/26/2020 | Cal Poly Corporation | San Luis Obispo | San Luis Obispo County | 2626 | Layoff Temporary |
4100 | 4100 | 07/29/2014 | 09/30/2014 | 08/04/2014 | Tatitlek Corporation | Twentynine Palms | 2562 | Layoff Permanent | |
2165 | 2165 | 12/18/2015 | 02/25/2016 | 12/18/2015 | Gerawan Farming, Inc. | Kerman | 2551 | Closure Permanent | |
820 | 820 | 05/26/2020 | 03/30/2020 | 09/19/2020 | LAZ Parking California, LLC | San Diego | San Diego County | 2260 | Layoff Temporary |
7896 | 7896 | 03/27/2020 | 04/01/2020 | 04/14/2020 | Sea World | San Diego | San Diego County | 2250 | Closure Temporary |
8070 | 8070 | 03/26/2020 | 04/01/2020 | 04/11/2020 | SeaWorld San Diego | San Diego | San Diego County | 2225 | Layoff Temporary |
3615 | 3615 | 11/07/2016 | 01/06/2017 | 11/07/2016 | American Apparel, LLC | Los Angeles | 2166 | Closure Permanent | |
5220 | 5220 | 05/29/2020 | 08/01/2020 | 06/06/2020 | Verity Health System of California, Inc. DBA St.Francis Medical Center | Lynwood | Los Angeles County | 2030 | Closure Permanent |
9822 | 9822 | 02/20/2018 | 09/30/2018 | 03/09/2018 | Seneca Foods Corporation | Modesto | Stanislaus County | 1975 | Closure Permanent |
8760 | 8760 | 03/20/2020 | 03/14/2020 | 03/27/2020 | Hawaiian Gardens Casino | Hawaiian Gardens | Los Angeles County | 1900 | 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 |
5852 | 5852 | 03/19/2020 | 03/14/2020 | 05/19/2020 | THE CALIFORNIA COMMERCE CLUB DBATHE COMMERCE CASUNO & HOTEL | Los Angeles | Los Angeles County | 1884 | Closure Temporary |
7275 | 7275 | 04/07/2020 | 03/13/2020 | 04/20/2020 | Aramark - Yosemite | Yosemite National Park | Mariposa County | 1829 | Layoff Temporary |
6877 | 6877 | 03/31/2020 | 03/27/2020 | 04/24/2020 | LEGOLAND California LLC, dba LEGOLANDCalifornia Resort | Carlsbad | San Diego County | 1810 | Closure Temporary |
8919 | 8919 | 03/23/2020 | 03/18/2020 | 03/23/2020 | Pebble Beach Company | Pebble Beach | Monterey County | 1800 | Closure Temporary |
1004 | 1004 | 07/08/2020 | 10/01/2020 | 09/28/2020 | United Airlines, Inc. - Los Angeles International Airport | Los Angeles | Los Angeles County | 1750 | Layoff Temporary |
6254 | 6254 | 05/01/2020 | 03/12/2020 | 05/09/2020 | GSW Arena LLC-Chase Center | San Francisco | San Francisco County | 1720 | Layoff Temporary |
2175 | 2175 | 12/22/2015 | 02/29/2016 | 12/28/2015 | DNC Parks & Resorts at Yosemite, Inc. | Yosemite National | 1718 | Closure Permanent | |
1448 | 1448 | 04/28/2020 | 04/20/2020 | 12/02/2020 | Zoological Society of San Diego dba San Diego Zoo Global | San Diego | San Diego County | 1690 | Layoff Temporary |
495 | 495 | 05/15/2020 | 05/15/2020 | 08/18/2020 | Irvine Management Company, dba Irvine Company | Irvine | Orange County | 1681 | Layoff Permanent |
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 |
7168 | 7168 | 04/08/2020 | 04/03/2020 | 04/21/2020 | Burlington Distribution Corp. | San Bernardino | San Bernardino County | 1653 | Closure Temporary |
31 | 31 | 04/15/2020 | 03/16/2020 | 07/02/2020 | BON APPETIT Management Company | San Francisco | San Francisco County | 1529 | Layoff Temporary |
8905 | 8905 | 03/23/2020 | 03/17/2020 | 03/23/2020 | YogaWorks | Culver City | Los Angeles County | 1514 | Layoff Unknown at thistime |
1553 | 1553 | 12/03/2020 | 11/29/2020 | 01/04/2021 | Bicycle Casino L.P. dba The Bicycle Hotel & Casino | Bell Gardens | Los Angeles County | 1500 | Closure Temporary |
8969 | 8969 | 03/14/2020 | 03/14/2020 | 03/16/2020 | Bicycle Casino, L.P. | Bell Gardens | Los Angeles County | 1500 | Layoff Temporary |
2617 | 2617 | 07/30/2018 | 09/26/2018 | 08/03/2018 | National Steel and Shipbuilding Company | San Diego | San Diego County | 1493 | Layoff Unknown at this time |
5392 | 5392 | 04/17/2020 | 03/13/2020 | 06/02/2020 | Magic Mountain, LLC | Valencia | Los Angeles County | 1454 | Layoff Temporary |
6452 | 6452 | 04/21/2020 | 04/03/2020 | 05/01/2020 | HCAL, LLC dba Harrah's Resort SouthernCalifornia | Funner | San Diego County | 1440 | Closure Temporary |
4997 | 4997 | 06/01/2020 | 06/05/2020 | 06/16/2020 | Stitch Fix | San Francisco | San Francisco County | 1420 | Layoff Permanent |
8513 | 8513 | 03/25/2020 | 03/19/2020 | 04/07/2020 | Cohn Restaurant Group | San Diego | San Diego County | 1358 | Layoff Permanent |
486 | 486 | 08/12/2020 | 07/29/2020 | 08/17/2020 | Bon Apetite | San Francisco | San Francisco County | 1356 | Layoff Type Unknown |
2960 | 2960 | 01/08/2019 | 02/05/2019 | 01/25/2019 | Adventist Health Feather River | Paradise | Butte County | 1331 | Closure Temporary |
9660 | 9660 | 11/22/2017 | 12/31/2017 | 11/30/2017 | Volume Services, Inc. dba Centerplate | San Francisco | San Francisco | 1330 | Layoff Permanent |
2928 | 2928 | 12/28/2018 | 02/28/2019 | 12/31/2018 | Verity Health System of California, Inc. | San Jose | Santa Clara | 1326 | Layoff Permanent |
1990 | 1990 | 09/17/2015 | 11/20/2015 | 09/18/2015 | Qualcomm Incorporated | San Diego | 1314 | Layoff Permanent | |
8379 | 8379 | 03/19/2020 | 03/09/2020 | 04/09/2020 | TeamSanJose | San Jose | Santa Clara County | 1304 | 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 |
6696 | 6696 | 04/02/2020 | 04/03/2020 | 04/28/2020 | Goodwill Industries of San Diego County(GISD) | San Diego | San Diego County | 1235 | Layoff Temporary |
9887 | 9887 | 04/18/2018 | 06/19/2018 | 04/19/2018 | Qualcomm Incorporated | San Diego | San Diego County | 1231 | Layoff Unknown at this time |
7705 | 7705 | 04/03/2020 | 03/21/2020 | 04/15/2020 | YMCA of Metropolitan Los Angeles | Los Angeles | Los Angeles County | 1228 | Layoff Temporary |
4619 | 4619 | 04/27/2015 | 06/26/2015 | 04/27/2015 | Health Net, Inc. (CANCELLED)** | Woodland Hills | 1217 | Layoff Unknown at this time | |
7624 | 7624 | 03/30/2020 | 03/26/2020 | 04/16/2020 | Padres LP | San Diego | San Diego County | 1215 | Layoff Temporary |
763 | 763 | 09/10/2020 | 09/11/2020 | 09/14/2020 | Universal City Studios, LLC dba Universal Studios Hollywood | Universal City | Los Angeles County | 1207 | Layoff Permanent |
7373 | 7373 | 04/04/2020 | 03/23/2020 | 04/18/2020 | San Francisco Giants | San Francisco | San Francisco County | 1200 | Layoff Temporary |
1268 | 1268 | 05/29/2020 | 05/31/2020 | 11/04/2020 | Hawaiian Gardens Casino | Hawaiian Gardens | Los Angeles County | 1185 | Layoff Permanent |
9266 | 9266 | 09/26/2019 | 01/16/2020 | 09/30/2019 | Forever 21 Logistics, LLC | Los Angeles | Los Angeles County | 1170 | Closure Permanent |
864 | 864 | 03/20/2020 | 03/20/2020 | 09/21/2020 | LDD Long Point Management LLC @ Terranea Resort | Rancho Palos Verdes | Los Angeles County | 1136 | Closure Temporary |
3751 | 3751 | 01/24/2017 | 03/31/2017 | 01/27/2017 | San Diego Sportservice, Inc. | San Diego | 1130 | Closure Permanent | |
5707 | 5707 | 03/20/2020 | 03/20/2020 | 05/21/2020 | LDD Long Point Management LLC @ TerraneaResort | Rancho Palos Verdes | Los Angeles County | 1107 | Closure Temporary |
6203 | 6203 | 05/01/2020 | 03/12/2020 | 05/11/2020 | Santa Cruz Seaside Company | Santa Cruz | Santa Cruz County | 1097 | Layoff Temporary |
7846 | 7846 | 03/20/2020 | 03/19/2020 | 04/14/2020 | The Brigantine Inc | San Diego | San Diego County | 1092 | Closure Temporary |
7890 | 7890 | 06/25/2020 | 04/11/2020 | 04/14/2020 | Marriott Hotel Services, Inc - JW MarriottDesert Springs Resort & Spa | Palm Desert | Riverside County | 1084 | Layoff Temporary |
3699 | 3699 | 01/06/2017 | 01/28/2017 | 01/09/2017 | Verizon Wireless | Rancho Cordova | 1070 | Layoff Permanent | |
6671 | 6671 | 04/16/2020 | 03/28/2020 | 04/28/2020 | The Performing Arts Center of Los AngelesCounty | Los Angeles | Los Angeles County | 1069 | Layoff Temporary |
7986 | 7986 | 03/31/2020 | 03/20/2020 | 04/13/2020 | Chukchansi Gold Resort & Casino | Coarsegold | Madera County | 1065 | Closure Temporary |
7311 | 7311 | 04/06/2020 | 03/20/2020 | 04/20/2020 | Curio Employer LLC, dba Hotel del Coronado | Coronado | San Diego County | 1064 | Layoff Temporary |
7407 | 7407 | 04/03/2020 | 03/30/2020 | 04/17/2020 | Irvine Management Company, dba IrvineCompany | Irvine | Orange County | 1059 | Layoff Temporary |
7304 | 7304 | 04/06/2020 | 03/22/2020 | 04/20/2020 | Hilton Hotel Employer LLC dba Hilton Anaheim | Anaheim | Orange County | 1038 | Layoff Temporary |
4221 | 4221 | 10/16/2014 | 10/17/2014 | 10/20/2014 | Chukchansi Gold Resort & Casino | Coarsegold | 1034 | Closure Temporary | |
8133 | 8133 | 03/20/2020 | 03/23/2020 | 04/11/2020 | Robinson Helicopter Company, Inc. (RHC) | Torrance | Los Angeles County | 1014 | Layoff Temporary |
8450 | 8450 | 06/25/2020 | 04/04/2020 | 04/08/2020 | The Ritz-Carlton, Los Angeles, JW MarriottL.A. LIVE | Los Angeles | Los Angeles County | 1009 | Layoff Temporary |
4187 | 4187 | 09/22/2014 | 10/10/2014 | 10/01/2014 | Cisco Systems, Inc. | San Jose | 1005 | Layoff Permanent | |
5748 | 5748 | 05/06/2020 | 03/16/2020 | 05/21/2020 | Darden Restaurant, Inc. | Moreno Valley | Riverside County | 984 | Layoff Temporary |
2319 | 2319 | 02/18/2016 | 03/31/2016 | 02/24/2016 | Freedom Communications, Inc. | Santa Ana | 969 | Layoff Unknown at this time | |
2048 | 2048 | 10/15/2015 | 12/22/2015 | 10/19/2015 | PCM, Inc. | Laguna Woods | 968 | Layoff Permanent | |
5517 | 5517 | 05/07/2020 | 05/16/2020 | 05/27/2020 | Associated Students of San Diego StateUniversity | San Diego | San Diego County | 965 | Layoff Temporary |
3364 | 3364 | 01/29/2019 | 03/20/2019 | 06/17/2019 | Tesla, Inc. | Fremont | Alameda County | 964 | Layoff Permanent |
9485 | 9485 | 08/31/2017 | 10/31/2017 | 09/01/2017 | Oracle America, Inc. | Santa Clara | Santa Clara | 964 | Layoff Permanent |
3616 | 3616 | 11/07/2016 | 01/06/2017 | 11/07/2016 | American Apparel, LLC | South Gate | 959 | Closure Permanent | |
8753 | 8753 | 03/30/2020 | 03/30/2020 | 03/30/2020 | LAZ Parking California, LLC | San Diego | San Diego County | 943 | Layoff Temporary |
6913 | 6913 | 04/10/2020 | 04/20/2020 | 04/24/2020 | Oakley Inc | Foothill Ranch | Orange County | 942 | Layoff Temporary |
4652 | 4652 | 04/30/2015 | 04/30/2015 | 05/11/2015 | Toyota Motor Credit Corporation, | Torrance | 941 | Closure Permanent | |
1113 | 1113 | 06/04/2020 | 03/07/2020 | 10/05/2020 | The Westin St. Francis San Francisco On Union Square | San Francisco | San Francisco County | 940 | Layoff Temporary |
7505 | 7505 | 04/03/2020 | 02/23/2020 | 04/17/2020 | Hilton Hotel Employer LLC, dba Hilton SanFrancisco Union Square | San Francisco | San Francisco County | 923 | Layoff Temporary |
5211 | 5211 | 05/19/2020 | 03/15/2020 | 06/06/2020 | University Enterprises, Inc. | Sacramento | Sacramento County | 912 | Layoff Temporary |
5402 | 5402 | 04/18/2020 | 03/13/2020 | 06/02/2020 | Six Flags Discovery Kingdom | Vallejo | Solano County | 911 | Layoff Temporary |
3768 | 3768 | 01/30/2017 | 04/30/2017 | 02/02/2017 | Live Nation Worldwide, Inc. | Irvine | 905 | Closure Permanent | |
8402 | 8402 | 03/27/2020 | 03/14/2020 | 04/09/2020 | Marriott International, Inc. DBA MarriottMarquis San Diego Marina | San Diego | San Diego County | 903 | Layoff Temporary |
3484 | 3484 | 08/25/2016 | 10/25/2016 | 08/26/2016 | Ashley Furniture Industries, Inc. | Colton | 900 | Closure Permanent | |
8411 | 8411 | 03/24/2020 | 03/29/2020 | 04/08/2020 | Bartell Hotels San Diego's Premier Properties | San Diego | San Diego County | 900 | Layoff Temporary |
3473 | 3473 | 08/17/2016 | 08/18/2016 | 08/18/2016 | Cisco Systems, Inc. | San Jose | 899 | Layoff Permanent | |
711 | 711 | 09/01/2020 | 11/01/2020 | 09/10/2020 | Alorica, Inc. | Clovis | Fresno County | 891 | Closure Permanent |
9951 | 9951 | 05/04/2018 | 07/04/2018 | 05/10/2018 | Spartan Shops Inc. | San Jose | Santa Clara | 881 | Layoff Permanent |
683 | 683 | 08/18/2020 | 09/09/2020 | 09/08/2020 | Richmark Capital Corp | Gardena | Los Angeles County | 864 | Layoff Permanent |
3701 | 3701 | 10/21/2016 | 01/09/2017 | 01/10/2017 | National Steel and Shipbuilding | San Diego | 844 | Layoff Permanent | |
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 |
6248 | 6248 | 03/20/2020 | 03/31/2020 | 05/09/2020 | YMCA Child Care | Aliso Viejo | Orange County | 837 | Closure Temporary |
4550 | 4550 | 03/13/2015 | 04/16/2015 | 03/17/2015 | Service America Corporation, d/b/a | San Diego | 831 | Layoff Unknown at this time | |
9051 | 9051 | 02/03/2020 | 04/04/2020 | 02/03/2020 | Macy's | San Francisco | San Francisco County | 831 | Closure Permanent |
7086 | 7086 | 04/06/2020 | 03/17/2020 | 04/21/2020 | HLT Conrad Domestic Employer LLC dbaHilton San Diego Bayfront | San Diego | San Diego County | 830 | Layoff Temporary |
2598 | 2598 | 07/17/2018 | 09/21/2018 | 07/23/2018 | Swissport SA, LLC | Los Angeles | Los Angeles | 829 | Layoff Permanent |
1549 | 1549 | 12/09/2020 | 12/09/2020 | 12/31/2020 | SeaWorld | San Diego | San Diego County | 827 | 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 );