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

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