⚠️ 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
1 2021-01-21 acacia-creek-union-city ACACIA CREEK - UNION CITY Alameda 1 1 0 0 1 <11 <11    
2 2021-01-21 aegis-assisted-living-of-fremont AEGIS ASSISTED LIVING OF FREMONT Alameda 12 13 0 0 1        
3 2021-01-21 arcadian-residential-community ARCADIAN RESIDENTIAL COMMUNITY Alameda 15 28 0 1 1       <11
4 2021-01-21 belmont-village-albany BELMONT VILLAGE ALBANY Alameda 12 1 0 0 1   <11    
5 2021-01-21 brookdale-north-fremont BROOKDALE NORTH FREMONT Alameda 22 21 0 1 1       <11
6 2021-01-21 carefield-pleasanton CAREFIELD PLEASANTON Alameda 17 24 0 1 1       <11
7 2021-01-21 carlton-plaza-of-fremont CARLTON PLAZA OF FREMONT Alameda 13 1 0 0 1   <11    
8 2021-01-21 carlton-plaza-of-san-leandro CARLTON PLAZA OF SAN LEANDRO Alameda 35 40 1 1 1     <11 <11
9 2021-01-21 creekview-assisted-living CREEKVIEW ASSISTED LIVING Alameda 21 11 0 1 1       <11
10 2021-01-21 elder-ashram ELDER ASHRAM Alameda 1 18 0 0 1 <11      
11 2021-01-21 fremont-hills FREMONT HILLS Alameda 1 1 0 0 1 <11 <11    
12 2021-01-21 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    
13 2021-01-21 fremont-village FREMONT VILLAGE Alameda 31 53 1 13 1     <11  
14 2021-01-21 lakeside-park LAKESIDE PARK Alameda 20 18 0 1 1       <11
15 2021-01-21 landmark-villa LANDMARK VILLA Alameda 1 1 0 0 1 <11 <11    
16 2021-01-21 lincoln-villa LINCOLN VILLA Alameda 1 15 0 1 1 <11     <11
17 2021-01-21 marymount-villa-retirement-center MARYMOUNT VILLA RETIREMENT CENTER Alameda 17 49 1 16 1     <11  
18 2021-01-21 masonic-home-for-adults MASONIC HOME FOR ADULTS Alameda 17 1 0 0 1   <11    
19 2021-01-21 merrill-gardens-at-rockridge MERRILL GARDENS AT ROCKRIDGE Alameda 1 1 0 1 1 <11 <11   <11
20 2021-01-21 oakcreek OAKCREEK Alameda 1 15 0 1 1 <11     <11
21 2021-01-21 oakmont-of-mariner-point OAKMONT OF MARINER POINT Alameda 16 1 0 0 1   <11    
22 2021-01-21 pacifica-senior-living-oakland PACIFICA SENIOR LIVING OAKLAND Alameda 13 21 0 1 1       <11
23 2021-01-21 parkview-the PARKVIEW, THE Alameda 19 40 0 1 1       <11
24 2021-01-21 point-at-rockridge-the POINT AT ROCKRIDGE, THE Alameda 1 19 0 1 1 <11     <11
25 2021-01-21 quail-garden QUAIL GARDEN Alameda 1 16 0 1 1 <11     <11
26 2021-01-21 rosegate ROSEGATE Alameda 1 19 0 0 1 <11      
27 2021-01-21 scott-villa SCOTT VILLA Alameda 1 30 0 1 1 <11     <11
28 2021-01-21 silverado-senior-living-berkeley SILVERADO SENIOR LIVING - BERKELEY Alameda 32 58 0 14 1        
29 2021-01-21 st-paul-s-towers ST. PAUL'S TOWERS Alameda 12 1 0 0 1   <11    
30 2021-01-21 st-regis-retirement-center-inc ST. REGIS RETIREMENT CENTER, INC. Alameda 1 19 0 1 1 <11     <11
31 2021-01-21 stoneridge-creek-pleasanton STONERIDGE CREEK PLEASANTON Alameda 28 1 0 0 1   <11    
32 2021-01-21 watermark-at-rosewood-gardens-the WATERMARK AT ROSEWOOD GARDENS, THE Alameda 14 34 0 1 1       <11
33 2021-01-21 watermark-by-the-bay-the WATERMARK BY THE BAY, THE Alameda 12 1 0 0 1   <11    
34 2021-01-21 waters-edge-lodge WATERS EDGE LODGE Alameda 1 1 0 1 1 <11 <11   <11
35 2021-01-21 willow-creek-alzheimer-s-dementia-care-center WILLOW CREEK ALZHEIMER'S & DEMENTIA CARE CENTER Alameda 1 1 0 1 1 <11 <11   <11
36 2021-01-21 woodside-residential-care-facility-for-elderly WOODSIDE RESIDENTIAL CARE FACILITY FOR ELDERLY Alameda 1 1 0 0 1 <11 <11    
37 2021-01-21 amador-residential-care-facility AMADOR RESIDENTIAL CARE FACILITY Amador 1 1 0 1 5 <11 <11   <11
38 2021-01-21 amber-grove-place AMBER GROVE PLACE Butte 1 1 0 1 7 <11 <11   <11
39 2021-01-21 compass-rose COMPASS ROSE Butte 11 20 0 1 7       <11
40 2021-01-21 country-crest-assisted-living COUNTRY CREST ASSISTED LIVING Butte 1 1 0 1 7 <11 <11   <11
41 2021-01-21 country-house COUNTRY HOUSE Butte 1 15 0 0 7 <11      
42 2021-01-21 courtyard-at-little-chico-creek-the COURTYARD AT LITTLE CHICO CREEK, THE Butte 18 22 0 0 7        
43 2021-01-21 prestige-assisted-living-at-chico PRESTIGE ASSISTED LIVING AT CHICO Butte 11 0 1 0 7     <11  
44 2021-01-21 roseleaf-gardens ROSELEAF GARDENS Butte 1 17 0 0 7 <11      
45 2021-01-21 townsend-house TOWNSEND HOUSE Butte 1 17 0 0 7 <11      
46 2021-01-21 windchime-of-chico WINDCHIME OF CHICO Butte 1 20 1 1 7 <11   <11 <11
47 2021-01-21 atria-valley-view ATRIA VALLEY VIEW Contra Costa 12 1 0 0 13   <11    
48 2021-01-21 atria-walnut-creek ATRIA WALNUT CREEK Contra Costa 1 1 0 0 13 <11 <11    
49 2021-01-21 brookdale-diablo-lodge BROOKDALE DIABLO LODGE Contra Costa 1 11 0 1 13 <11     <11
50 2021-01-21 brookdale-san-ramon BROOKDALE SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
51 2021-01-21 byron-park BYRON PARK Contra Costa 16 14 0 1 13       <11
52 2021-01-21 carnelian-i CARNELIAN I Contra Costa 1 1 0 1 13 <11 <11   <11
53 2021-01-21 chateau-at-poets-corner CHATEAU AT POETS CORNER Contra Costa 27 28 0 1 13       <11
54 2021-01-21 chateau-iii CHATEAU III Contra Costa 38 39 0 1 13       <11
55 2021-01-21 commons-at-dallas-ranch-the COMMONS AT DALLAS RANCH, THE Contra Costa 12 12 0 1 13       <11
56 2021-01-21 concord-royale CONCORD ROYALE Contra Costa 1 1 0 1 13 <11 <11   <11
57 2021-01-21 friendship-care-home FRIENDSHIP CARE HOME Contra Costa 1 16 0 1 13 <11     <11
58 2021-01-21 greenridge-senior-care GREENRIDGE SENIOR CARE Contra Costa 0 1 0 1 13   <11   <11
59 2021-01-21 kensington-the KENSINGTON, THE Contra Costa 1 1 0 0 13 <11 <11    
60 2021-01-21 pleasant-hill-oasis PLEASANT HILL OASIS Contra Costa 14 16 0 0 13        
61 2021-01-21 reutlinger-community-the REUTLINGER COMMUNITY, THE Contra Costa 14 1 0 1 13   <11   <11
62 2021-01-21 sunrise-assisted-living-of-danville SUNRISE ASSISTED LIVING OF DANVILLE Contra Costa 32 25 0 1 13       <11
63 2021-01-21 sunrise-assisted-living-of-walnut-creek SUNRISE ASSISTED LIVING OF WALNUT CREEK Contra Costa 1 1 0 0 13 <11 <11    
64 2021-01-21 sunrise-villa-san-ramon SUNRISE VILLA SAN RAMON Contra Costa 1 1 0 1 13 <11 <11   <11
65 2021-01-21 trevista-antioch TREVISTA ANTIOCH Contra Costa 16 19 0 1 13       <11
66 2021-01-21 trevista-concord TREVISTA CONCORD Contra Costa 11 22 0 1 13       <11
67 2021-01-21 walnut-creek-willows WALNUT CREEK WILLOWS Contra Costa 1 1 0 1 13 <11 <11   <11
68 2021-01-21 westmont-of-brentwood WESTMONT OF BRENTWOOD Contra Costa 25 33 0 1 13       <11
69 2021-01-21 westmont-of-pinole WESTMONT OF PINOLE Contra Costa 1 1 0 0 13 <11 <11    
70 2021-01-21 eskaton-village-placerville ESKATON VILLAGE PLACERVILLE El Dorado 18 26 0 1 17       <11
71 2021-01-21 new-west-haven-ii NEW WEST HAVEN II El Dorado 1 15 0 1 17 <11     <11
72 2021-01-21 oakmont-of-el-dorado-hills OAKMONT OF EL DORADO HILLS El Dorado 1 1 0 0 17 <11 <11    
73 2021-01-21 ponte-palmero PONTE PALMERO El Dorado 1 1 0 1 17 <11 <11   <11
74 2021-01-21 autumn-ridge-assisted-living AUTUMN RIDGE ASSISTED LIVING Fresno 1 1 0 1 19 <11 <11   <11
75 2021-01-21 belmar-villa BELMAR VILLA Fresno 1 14 0 1 19 <11     <11
76 2021-01-21 carmel-village-at-clovis CARMEL VILLAGE AT CLOVIS Fresno 22 1 0 0 19   <11    
77 2021-01-21 carmel-village-memory-care CARMEL VILLAGE MEMORY CARE Fresno 21 28 0 1 19       <11
78 2021-01-21 compass-pointe-memory-care COMPASS POINTE MEMORY CARE Fresno 1 26 0 1 19 <11     <11
79 2021-01-21 fairwinds-woodward-park FAIRWINDS - WOODWARD PARK Fresno 25 15 0 1 19       <11
80 2021-01-21 gettysburg-christian-home GETTYSBURG CHRISTIAN HOME Fresno 0 1 0 1 19   <11   <11
81 2021-01-21 kingston-bay-senior-living KINGSTON BAY SENIOR LIVING Fresno 19 12 0 1 19       <11
82 2021-01-21 oakmont-of-fresno OAKMONT OF FRESNO Fresno 19 36 0 1 19       <11
83 2021-01-21 pacifica-senior-living-fresno PACIFICA SENIOR LIVING FRESNO Fresno 1 1 0 1 19 <11 <11   <11
84 2021-01-21 paintbrush-assisted-living-and-memory-care PAINTBRUSH ASSISTED LIVING AND MEMORY CARE Fresno 13 26 0 0 19        
85 2021-01-21 palm-village-retirement-community PALM VILLAGE RETIREMENT COMMUNITY Fresno 27 17 0 0 19        
86 2021-01-21 rehabilitation-centre-of-fresno REHABILITATION CENTRE OF FRESNO Fresno 1 27 0 1 19 <11     <11
87 2021-01-21 sierra-view-homes-residential-care SIERRA VIEW HOMES RESIDENTIAL CARE Fresno 13 1 0 0 19   <11    
88 2021-01-21 the-terraces-at-san-joaquin-gardens THE TERRACES AT SAN JOAQUIN GARDENS Fresno 21 28 0 0 19        
89 2021-01-21 twilight-haven TWILIGHT HAVEN Fresno 12 11 0 0 19        
90 2021-01-21 veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA-FRESNO Fresno 20 11 0 0 19        
91 2021-01-21 westmont-of-fresno WESTMONT OF FRESNO Fresno 11 1 0 0 19   <11    
92 2021-01-21 windham-the WINDHAM, THE Fresno 1 12 0 1 19 <11     <11
93 2021-01-21 westhaven-assisted-living WESTHAVEN ASSISTED LIVING Glenn 17 33 0 1 21       <11
94 2021-01-21 alder-bay-assisted-living ALDER BAY ASSISTED LIVING Humboldt 1 1 0 1 23 <11 <11   <11
95 2021-01-21 a-a-cottage-view-assisted-living-inc A&A COTTAGE VIEW ASSISTED LIVING,INC. Imperial 1 1 0 1 25 <11 <11   <11
96 2021-01-21 blossom-valley-inn BLOSSOM VALLEY INN Imperial 12 57 0 1 25       <11
97 2021-01-21 heart-hand-inc HEART & HAND, INC. Imperial 1 1 0 0 25 <11 <11    
98 2021-01-21 brookdale-riverwalk BROOKDALE RIVERWALK Kern 1 18 0 0 29 <11      
99 2021-01-21 golden-castle-assisted-living GOLDEN CASTLE ASSISTED LIVING Kern 0 15 0 0 29        
100 2021-01-21 hallmark-of-bakersfield HALLMARK OF BAKERSFIELD Kern 1 13 0 0 29 <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
);