⚠️ 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

67,223 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
5606 2021-01-12 acacia-creek-union-city ACACIA CREEK - UNION CITY Alameda 1 1 0 0 1 <11 <11    
5607 2021-01-12 aegis-assisted-living-of-fremont AEGIS ASSISTED LIVING OF FREMONT Alameda 12 1 0 0 1   <11    
5608 2021-01-12 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
5609 2021-01-12 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 21 0 1 1       <11
5610 2021-01-12 carefield-pleasanton CAREFIELD PLEASANTON Alameda 17 24 0 1 1       <11
5611 2021-01-12 carlton-plaza-of-fremont CARLTON PLAZA OF FREMONT Alameda 13 1 0 0 1   <11    
5612 2021-01-12 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 32 40 1 1 1     <11 <11
5613 2021-01-12 creekview-assisted-living CREEKVIEW ASSISTED LIVING Alameda 19 1 0 0 1   <11    
5614 2021-01-12 elder-ashram ELDER ASHRAM Alameda 1 18 0 0 1 <11      
5615 2021-01-12 fremont-hills FREMONT HILLS Alameda 1 1 0 0 1 <11 <11    
5616 2021-01-12 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    
5617 2021-01-12 fremont-village FREMONT VILLAGE Alameda 30 51 1 13 1     <11  
5618 2021-01-12 lakeside-park LAKESIDE PARK Alameda 20 18 0 1 1       <11
5619 2021-01-12 landmark-villa LANDMARK VILLA Alameda 1 1 0 0 1 <11 <11    
5620 2021-01-12 lincoln-villa LINCOLN VILLA Alameda 1 1 0 1 1 <11 <11   <11
5621 2021-01-12 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 17 49 1 16 1     <11  
5622 2021-01-12 masonic-home-for-adults MASONIC HOME FOR ADULTS Alameda 17 1 0 0 1   <11    
5623 2021-01-12 merrill-gardens-at-rockridge MERRILL GARDENS AT ROCKRIDGE Alameda 1 1 0 0 1 <11 <11    
5624 2021-01-12 oakcreek OAKCREEK Alameda 1 15 0 1 1 <11     <11
5625 2021-01-12 oakmont-of-mariner-point OAKMONT OF MARINER POINT Alameda 16 1 0 0 1   <11    
5626 2021-01-12 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 12 21 0 1 1       <11
5627 2021-01-12 parkview-the PARKVIEW, THE Alameda 18 37 0 1 1       <11
5628 2021-01-12 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 16 0 1 1 <11     <11
5629 2021-01-12 quail-garden QUAIL GARDEN Alameda 1 16 0 1 1 <11     <11
5630 2021-01-12 rosegate ROSEGATE Alameda 1 19 0 0 1 <11      
5631 2021-01-12 scott-villa SCOTT VILLA Alameda 1 30 0 1 1 <11     <11
5632 2021-01-12 silverado-senior-living-berkeley SILVERADO SENIOR LIVING - BERKELEY Alameda 30 56 0 1 1       <11
5633 2021-01-12 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 1 19 0 1 1 <11     <11
5634 2021-01-12 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 24 1 0 0 1   <11    
5635 2021-01-12 watermark-at-rosewood-gardens-the WATERMARK AT ROSEWOOD GARDENS, THE Alameda 14 34 0 1 1       <11
5636 2021-01-12 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 12 1 0 0 1   <11    
5637 2021-01-12 waters-edge-lodge WATERS EDGE LODGE Alameda 1 1 0 1 1 <11 <11   <11
5638 2021-01-12 willow-creek-alzheimer-s-dementia-care-center WILLOW CREEK ALZHEIMER'S & DEMENTIA CARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
5639 2021-01-12 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
5640 2021-01-12 compass-rose COMPASS ROSE Butte 1 20 0 1 7 <11     <11
5641 2021-01-12 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
5642 2021-01-12 country-house COUNTRY HOUSE Butte 1 14 0 0 7 <11      
5643 2021-01-12 courtyard-at-little-chico-creek-the COURTYARD AT LITTLE CHICO CREEK, THE Butte 18 22 0 0 7        
5644 2021-01-12 townsend-house TOWNSEND HOUSE Butte 1 17 0 0 7 <11      
5645 2021-01-12 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
5646 2021-01-12 atria-valley-view ATRIA VALLEY VIEW Contra Costa 12 1 0 0 13   <11    
5647 2021-01-12 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 1 0 1 13 <11 <11   <11
5648 2021-01-12 brookdale-san-ramon BROOKDALE SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
5649 2021-01-12 byron-park BYRON PARK Contra Costa 16 14 0 1 13       <11
5650 2021-01-12 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 27 28 0 1 13       <11
5651 2021-01-12 chateau-iii CHATEAU III Contra Costa 38 39 0 1 13       <11
5652 2021-01-12 commons-at-dallas-ranch-the COMMONS AT DALLAS RANCH, THE Contra Costa 11 1 0 0 13   <11    
5653 2021-01-12 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
5654 2021-01-12 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
5655 2021-01-12 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 1 0 1 13   <11   <11
5656 2021-01-12 kensington-the KENSINGTON, THE Contra Costa 1 1 0 0 13 <11 <11    
5657 2021-01-12 pleasant-hill-oasis PLEASANT HILL OASIS Contra Costa 1 15 0 0 13 <11      
5658 2021-01-12 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 1 1 0 1 13 <11 <11   <11
5659 2021-01-12 sunrise-assisted-living-of-danville SUNRISE ASSISTED LIVING OF DANVILLE Contra Costa 31 24 0 1 13       <11
5660 2021-01-12 sunrise-villa-san-ramon SUNRISE VILLA SAN RAMON Contra Costa 0 1 0 1 13   <11   <11
5661 2021-01-12 trevista-antioch TREVISTA ANTIOCH Contra Costa 15 1 0 1 13   <11   <11
5662 2021-01-12 trevista-concord TREVISTA CONCORD Contra Costa 11 22 0 1 13       <11
5663 2021-01-12 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 1 13 <11 <11   <11
5664 2021-01-12 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 21 31 0 1 13       <11
5665 2021-01-12 westmont-of-pinole WESTMONT OF PINOLE Contra Costa 1 1 0 0 13 <11 <11    
5666 2021-01-12 eskaton-village-placerville ESKATON VILLAGE PLACERVILLE El Dorado 18 26 0 1 17       <11
5667 2021-01-12 new-west-haven-ii NEW WEST HAVEN II El Dorado 1 15 0 1 17 <11     <11
5668 2021-01-12 oakmont-of-el-dorado-hills OAKMONT OF EL DORADO HILLS El Dorado 1 1 0 0 17 <11 <11    
5669 2021-01-12 ponte-palmero PONTE PALMERO El Dorado 1 1 0 1 17 <11 <11   <11
5670 2021-01-12 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
5671 2021-01-12 belmar-villa BELMAR VILLA Fresno 1 14 0 1 19 <11     <11
5672 2021-01-12 carmel-village-at-clovis CARMEL VILLAGE AT CLOVIS Fresno 22 1 0 0 19   <11    
5673 2021-01-12 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 19 28 0 1 19       <11
5674 2021-01-12 compass-pointe-memory-care COMPASS POINTE MEMORY CARE Fresno 1 26 0 1 19 <11     <11
5675 2021-01-12 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 25 15 0 1 19       <11
5676 2021-01-12 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
5677 2021-01-12 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 19 11 0 1 19       <11
5678 2021-01-12 oakmont-of-fresno OAKMONT OF FRESNO Fresno 19 36 0 1 19       <11
5679 2021-01-12 pacifica-senior-living-fresno PACIFICA SENIOR LIVING FRESNO Fresno 1 1 0 1 19 <11 <11   <11
5680 2021-01-12 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 12 17 0 0 19        
5681 2021-01-12 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 22 17 0 0 19        
5682 2021-01-12 rehabilitation-centre-of-fresno REHABILITATION CENTRE OF FRESNO Fresno 1 27 0 1 19 <11     <11
5683 2021-01-12 sierra-view-homes-residential-care SIERRA VIEW HOMES RESIDENTIAL CARE Fresno 12 1 0 0 19   <11    
5684 2021-01-12 the-terraces-at-san-joaquin-gardens THE TERRACES AT SAN JOAQUIN GARDENS Fresno 13 17 0 0 19        
5685 2021-01-12 twilight-haven TWILIGHT HAVEN Fresno 12 11 0 0 19        
5686 2021-01-12 veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA-FRESNO Fresno 20 11 0 0 19        
5687 2021-01-12 westmont-of-fresno WESTMONT OF FRESNO Fresno 11 1 0 0 19   <11    
5688 2021-01-12 windham-the WINDHAM, THE Fresno 1 12 0 1 19 <11     <11
5689 2021-01-12 westhaven-assisted-living WESTHAVEN ASSISTED LIVING Glenn 17 33 0 1 21       <11
5690 2021-01-12 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
5691 2021-01-12 a-a-cottage-view-assisted-living-inc A&A COTTAGE VIEW ASSISTED LIVING,INC. Imperial 1 1 0 1 25 <11 <11   <11
5692 2021-01-12 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 57 0 1 25       <11
5693 2021-01-12 heart-hand-inc HEART & HAND, INC. Imperial 1 1 0 0 25 <11 <11    
5694 2021-01-12 brookdale-riverwalk BROOKDALE RIVERWALK Kern 1 16 0 0 29 <11      
5695 2021-01-12 centre-village CENTRE VILLAGE Kern 36 1 0 0 29   <11    
5696 2021-01-12 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <11      
5697 2021-01-12 jasmin-terrace-at-bakersfield JASMIN TERRACE AT BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
5698 2021-01-12 pacifica-of-bakersfield PACIFICA OF BAKERSFIELD Kern 1 1 0 1 29 <11 <11   <11
5699 2021-01-12 pointe-at-summit-hills-the POINTE AT SUMMIT HILLS, THE Kern 19 1 0 1 29   <11   <11
5700 2021-01-12 riverside-ranch-asc-treatment-group RIVERSIDE RANCH, ASC TREATMENT GROUP Kern 1 1 0 0 29 <11 <11    
5701 2021-01-12 rosewood-retirement-community ROSEWOOD RETIREMENT COMMUNITY Kern 13 1 0 1 29   <11   <11
5702 2021-01-12 westchester-gardens WESTCHESTER GARDENS Kern 1 17 0 0 29 <11      
5703 2021-01-12 diamond-terraces DIAMOND TERRACES Kings 1 14 0 0 31 <11      
5704 2021-01-12 abbey-road-villa ABBEY ROAD VILLA Los Angeles 1 34 0 0 37 <11      
5705 2021-01-12 aegis-of-granada-hills AEGIS OF GRANADA HILLS Los Angeles 17 18 0 1 37       <11

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
);