⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_adult_and_senior_care_facilities

93,716 rows sorted by date descending

View and edit SQL

Link rowid date ▲ slug name county staff_confirmed_cases patients_confirmed_cases staff_deaths patients_deaths fips staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths_note patients_deaths_note
7262 2021-02-19 acacia-creek-union-city ACACIA CREEK - UNION CITY Alameda 1 1 0 0 1 <11 <11    
7263 2021-02-19 aegis-assisted-living-of-fremont AEGIS ASSISTED LIVING OF FREMONT Alameda 12 15 0 0 1        
7264 2021-02-19 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
7265 2021-02-19 belmont-village-albany BELMONT VILLAGE ALBANY Alameda 15 1 0 0 1   <11    
7266 2021-02-19 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 26 0 1 1       <11
7267 2021-02-19 carefield-pleasanton CAREFIELD PLEASANTON Alameda 17 24 0 1 1       <11
7268 2021-02-19 carlton-plaza-of-fremont CARLTON PLAZA OF FREMONT Alameda 13 1 0 0 1   <11    
7269 2021-02-19 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 35 41 1 1 1     <11 <11
7270 2021-02-19 creekview-assisted-living CREEKVIEW ASSISTED LIVING Alameda 28 28 0 1 1       <11
7271 2021-02-19 diana-s-care-home DIANA'S CARE HOME Alameda 1 29 0 0 1 <11      
7272 2021-02-19 elder-ashram ELDER ASHRAM Alameda 1 18 0 0 1 <11      
7273 2021-02-19 fremont-hills FREMONT HILLS Alameda 1 1 0 0 1 <11 <11    
7274 2021-02-19 fremont-rtrmt-com-happy-lvng-by-cogir-cogir-fremon FREMONT RTRMT COM-HAPPY LVNG BY COGIR/COGIR FREMON Alameda 1 1 0 0 1 <11 <11    
7275 2021-02-19 fremont-village FREMONT VILLAGE Alameda 31 56 1 13 1     <11  
7276 2021-02-19 heritage-haven HERITAGE HAVEN Alameda 1 21 0 1 1 <11     <11
7277 2021-02-19 j-sei-home J-SEI HOME Alameda 1 1 0 1 1 <11 <11   <11
7278 2021-02-19 lakeside-park LAKESIDE PARK Alameda 20 18 0 1 1       <11
7279 2021-02-19 landmark-villa LANDMARK VILLA Alameda 1 1 0 0 1 <11 <11    
7280 2021-02-19 lincoln-villa LINCOLN VILLA Alameda 1 18 0 1 1 <11     <11
7281 2021-02-19 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 17 49 1 16 1     <11  
7282 2021-02-19 masonic-home-for-adults MASONIC HOME FOR ADULTS Alameda 17 1 0 0 1   <11    
7283 2021-02-19 merrill-gardens-at-rockridge MERRILL GARDENS AT ROCKRIDGE Alameda 11 1 1 1 1   <11 <11 <11
7284 2021-02-19 mori-manor MORI MANOR Alameda 1 1 0 1 1 <11 <11   <11
7285 2021-02-19 oakcreek OAKCREEK Alameda 1 15 0 1 1 <11     <11
7286 2021-02-19 oakmont-of-mariner-point OAKMONT OF MARINER POINT Alameda 24 26 0 1 1       <11
7287 2021-02-19 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 17 22 0 1 1       <11
7288 2021-02-19 pacifica-senior-living-san-leandro PACIFICA SENIOR LIVING SAN LEANDRO Alameda 1 1 0 0 1 <11 <11    
7289 2021-02-19 parkview-the PARKVIEW, THE Alameda 19 41 0 1 1       <11
7290 2021-02-19 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 19 0 1 1 <11     <11
7291 2021-02-19 quail-garden QUAIL GARDEN Alameda 1 16 0 1 1 <11     <11
7292 2021-02-19 rosegate ROSEGATE Alameda 11 19 0 0 1        
7293 2021-02-19 scott-villa SCOTT VILLA Alameda 1 30 0 1 1 <11     <11
7294 2021-02-19 silverado-senior-living-berkeley SILVERADO SENIOR LIVING - BERKELEY Alameda 33 58 0 14 1        
7295 2021-02-19 st-paul-s-towers ST. PAUL'S TOWERS Alameda 20 1 0 0 1   <11    
7296 2021-02-19 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 11 19 0 1 1       <11
7297 2021-02-19 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 34 1 0 0 1   <11    
7298 2021-02-19 sunrise-of-pleasanton SUNRISE OF PLEASANTON Alameda 13 15 0 0 1        
7299 2021-02-19 watermark-at-rosewood-gardens-the WATERMARK AT ROSEWOOD GARDENS, THE Alameda 14 34 0 1 1       <11
7300 2021-02-19 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 12 1 0 0 1   <11    
7301 2021-02-19 waters-edge-lodge WATERS EDGE LODGE Alameda 1 1 0 1 1 <11 <11   <11
7302 2021-02-19 willow-creek-alzheimer-s-dementia-care-center WILLOW CREEK ALZHEIMER'S & DEMENTIA CARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
7303 2021-02-19 woodside-residential-care-facility-for-elderly WOODSIDE RESIDENTIAL CARE FACILITY FOR ELDERLY Alameda 1 11 0 1 1 <11     <11
7304 2021-02-19 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
7305 2021-02-19 amber-grove-place AMBER GROVE PLACE Butte 13 19 0 1 7       <11
7306 2021-02-19 compass-rose COMPASS ROSE Butte 11 20 0 1 7       <11
7307 2021-02-19 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
7308 2021-02-19 country-house COUNTRY HOUSE Butte 1 15 0 0 7 <11      
7309 2021-02-19 courtyard-at-little-chico-creek-the COURTYARD AT LITTLE CHICO CREEK, THE Butte 18 22 0 0 7        
7310 2021-02-19 prestige-assisted-living-at-chico PRESTIGE ASSISTED LIVING AT CHICO Butte 14 0 1 0 7     <11  
7311 2021-02-19 roseleaf-gardens ROSELEAF GARDENS Butte 11 26 1 1 7     <11 <11
7312 2021-02-19 townsend-house TOWNSEND HOUSE Butte 1 17 0 0 7 <11      
7313 2021-02-19 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
7314 2021-02-19 aegis-assisted-living-of-moraga AEGIS ASSISTED LIVING OF MORAGA Contra Costa 1 1 0 0 13 <11 <11    
7315 2021-02-19 aegis-assisted-living-of-pleasant-hill AEGIS ASSISTED LIVING OF PLEASANT HILL Contra Costa 19 28 0 1 13       <11
7316 2021-02-19 atria-valley-view ATRIA VALLEY VIEW Contra Costa 12 1 0 0 13   <11    
7317 2021-02-19 atria-walnut-creek ATRIA WALNUT CREEK Contra Costa 1 1 0 0 13 <11 <11    
7318 2021-02-19 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 12 0 1 13 <11     <11
7319 2021-02-19 brookdale-san-ramon BROOKDALE SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
7320 2021-02-19 byron-park BYRON PARK Contra Costa 16 14 0 1 13       <11
7321 2021-02-19 carnelian-i CARNELIAN I Contra Costa 1 1 0 1 13 <11 <11   <11
7322 2021-02-19 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 27 28 0 1 13       <11
7323 2021-02-19 chateau-iii CHATEAU III Contra Costa 38 39 0 1 13       <11
7324 2021-02-19 commons-at-dallas-ranch-the COMMONS AT DALLAS RANCH, THE Contra Costa 13 16 0 1 13       <11
7325 2021-02-19 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
7326 2021-02-19 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
7327 2021-02-19 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 1 1 0 1 13 <11 <11   <11
7328 2021-02-19 heatherwood-memory-care HEATHERWOOD MEMORY CARE Contra Costa 1 1 0 0 13 <11 <11    
7329 2021-02-19 kensington-the KENSINGTON, THE Contra Costa 1 1 0 0 13 <11 <11    
7330 2021-02-19 montecito-oakmont-senior-living MONTECITO OAKMONT SENIOR LIVING Contra Costa 1 1 0 0 13 <11 <11    
7331 2021-02-19 pleasant-hill-oasis PLEASANT HILL OASIS Contra Costa 14 16 0 0 13        
7332 2021-02-19 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 14 1 0 1 13   <11   <11
7333 2021-02-19 sunrise-assisted-living-of-danville SUNRISE ASSISTED LIVING OF DANVILLE Contra Costa 33 25 0 1 13       <11
7334 2021-02-19 sunrise-assisted-living-of-walnut-creek SUNRISE ASSISTED LIVING OF WALNUT CREEK Contra Costa 17 25 0 1 13       <11
7335 2021-02-19 sunrise-villa-san-ramon SUNRISE VILLA SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
7336 2021-02-19 trevista-antioch TREVISTA ANTIOCH Contra Costa 28 45 0 1 13       <11
7337 2021-02-19 trevista-concord TREVISTA CONCORD Contra Costa 12 22 0 1 13       <11
7338 2021-02-19 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 1 13 <11 <11   <11
7339 2021-02-19 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 25 34 0 1 13       <11
7340 2021-02-19 westmont-of-pinole WESTMONT OF PINOLE Contra Costa 1 1 0 0 13 <11 <11    
7341 2021-02-19 eskaton-village-placerville ESKATON VILLAGE PLACERVILLE El Dorado 18 26 0 1 17       <11
7342 2021-02-19 new-west-haven-ii NEW WEST HAVEN II El Dorado 1 15 0 1 17 <11     <11
7343 2021-02-19 oakmont-of-el-dorado-hills OAKMONT OF EL DORADO HILLS El Dorado 1 1 0 0 17 <11 <11    
7344 2021-02-19 ponte-palmero PONTE PALMERO El Dorado 1 1 0 1 17 <11 <11   <11
7345 2021-02-19 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
7346 2021-02-19 belmar-villa BELMAR VILLA Fresno 1 14 0 1 19 <11     <11
7347 2021-02-19 carmel-village-at-clovis CARMEL VILLAGE AT CLOVIS Fresno 23 1 0 0 19   <11    
7348 2021-02-19 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 23 28 0 1 19       <11
7349 2021-02-19 compass-pointe-memory-care COMPASS POINTE MEMORY CARE Fresno 1 26 0 1 19 <11     <11
7350 2021-02-19 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 25 15 0 1 19       <11
7351 2021-02-19 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
7352 2021-02-19 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 19 12 0 1 19       <11
7353 2021-02-19 oakmont-of-fresno OAKMONT OF FRESNO Fresno 19 36 0 1 19       <11
7354 2021-02-19 pacifica-senior-living-fresno PACIFICA SENIOR LIVING FRESNO Fresno 16 15 1 1 19     <11 <11
7355 2021-02-19 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 17 32 0 0 19        
7356 2021-02-19 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 28 18 0 0 19        
7357 2021-02-19 rehabilitation-centre-of-fresno REHABILITATION CENTRE OF FRESNO Fresno 1 27 0 1 19 <11     <11
7358 2021-02-19 sierra-view-homes-residential-care SIERRA VIEW HOMES RESIDENTIAL CARE Fresno 13 1 0 0 19   <11    
7359 2021-02-19 terraces-at-san-joaquin-gardens-the TERRACES AT SAN JOAQUIN GARDENS, THE Fresno 39 32 0 1 19       <11
7360 2021-02-19 twilight-haven TWILIGHT HAVEN Fresno 12 11 0 0 19        
7361 2021-02-19 veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA- FRESNO Fresno 28 12 0 0 19        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] (
   [date] TEXT,
   [slug] TEXT,
   [name] TEXT,
   [county] TEXT,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [fips] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);