la_times_cdph_skilled_nursing_facilities

Table actions
⚠️ 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_skilled_nursing_facilities

776,631 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid date ▲ id 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
101 101 2022-01-15 140000092 140000092-orinda-care-center-llc ORINDA CARE CENTER, LLC Contra Costa 42 41 0 1 13       <11
102 102 2022-01-15 140000024 140000024-patterson-care-center PATTERSON CARE CENTER Contra Costa 1 1 1 1 13 <11 <11 <11 <11
103 103 2022-01-15 140000962 140000962-pittsburg-skilled-nursing-center PITTSBURG SKILLED NURSING CENTER Contra Costa 19 21 0 0 13        
104 104 2022-01-15 140000096 140000096-pleasant-hill-post-acute PLEASANT HILL POST ACUTE Contra Costa 38 50 0 1 13       <11
105 105 2022-01-15 140000049 140000049-richmond-post-acute-care RICHMOND POST ACUTE CARE Contra Costa 1 1 0 0 13 <11 <11    
106 106 2022-01-15 140000136 140000136-san-miguel-villa SAN MIGUEL VILLA Contra Costa 103 170 1 37 13     <11  
107 107 2022-01-15 140000030 140000030-san-pablo-healthcare-wellness-center SAN PABLO HEALTHCARE & WELLNESS CENTER Contra Costa 50 63 0 1 13       <11
108 108 2022-01-15 140000885 140000885-san-ramon-regional-medical-center-d-p-snf SAN RAMON REGIONAL MEDICAL CENTER D/P SNF Contra Costa 1 1 1 1 13 <11 <11 <11 <11
109 109 2022-01-15 140000396 140000396-shields-nursing-center SHIELDS NURSING CENTER Contra Costa 1 1 0 1 13 <11 <11   <11
110 110 2022-01-15 140000080 140000080-shields-richmond-nursing-center SHIELDS RICHMOND NURSING CENTER Contra Costa 19 1 0 1 13   <11   <11
111 111 2022-01-15 140000733 140000733-stonebrook-healthcare-center STONEBROOK HEALTHCARE CENTER Contra Costa 36 1 0 0 13   <11    
112 112 2022-01-15 140000078 140000078-tampico-terrace-care-center TAMPICO TERRACE CARE CENTER Contra Costa 1 27 0 1 13 <11     <11
113 113 2022-01-15 140001185 140001185-the-reutlinger-community THE REUTLINGER COMMUNITY Contra Costa 36 1 0 0 13   <11    
114 114 2022-01-15 140000061 140000061-vale-healthcare-center VALE HEALTHCARE CENTER Contra Costa 52 43 0 12 13        
115 115 2022-01-15 140000083 140000083-walnut-creek-skilled-nursing-rehabilitation-center WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER Contra Costa 49 17 0 1 13       <11
116 116 2022-01-15 140000121 140000121-willow-pass-healthcare-center WILLOW PASS HEALTHCARE CENTER Contra Costa 34 75 0 1 13       <11
117 117 2022-01-15 140000062 140000062-windsor-manor-rehabilitation-center-of-concord WINDSOR MANOR REHABILITATION CENTER OF CONCORD Contra Costa 95 212 1 15 13     <11  
118 118 2022-01-15 140000082 140000082-windsor-rosewood-care-center WINDSOR ROSEWOOD CARE CENTER Contra Costa 23 1 0 1 13   <11   <11
119 119 2022-01-15 10000004 010000004-crescent-city-skilled-nursing CRESCENT CITY SKILLED NURSING Del Norte 40 1 0 0 15   <11    
120 120 2022-01-15 30001525 030001525-barton-hospital-d-p-snf BARTON HOSPITAL D/P SNF El Dorado 34 1 0 0 17   <11    
121 121 2022-01-15 30000063 030000063-gold-country-health-center GOLD COUNTRY HEALTH CENTER El Dorado 28 44 0 14 17        
122 122 2022-01-15 30001064 030001064-marshall-medical-center-d-p-snf MARSHALL MEDICAL CENTER D/P SNF El Dorado 0 0 0 0 17        
123 123 2022-01-15 30000085 030000085-the-pines-at-placerville-healthcare-center THE PINES AT PLACERVILLE HEALTHCARE CENTER El Dorado 110 106 0 18 17        
124 124 2022-01-15 30000047 030000047-western-slope-health-center WESTERN SLOPE HEALTH CENTER El Dorado 99 105 0 1 17       <11
125 125 2022-01-15 40000015 040000015-bethel-lutheran-home-inc BETHEL LUTHERAN HOME, INC. Fresno 34 37 0 1 19       <11
126 126 2022-01-15 40000013 040000013-california-home-for-the-aged-inc CALIFORNIA HOME FOR THE AGED, INC. Fresno 113 36 0 1 19       <11
127 127 2022-01-15 40000798 040000798-coalinga-regional-medical-center-dp-snf COALINGA REGIONAL MEDICAL CENTER DP SNF Fresno 1 1 0 0 19 <11 <11    
128 128 2022-01-15 630013160 630013160-coalinga-regional-medical-center-dp-snf COALINGA REGIONAL MEDICAL CENTER DP/SNF Fresno 1 1 1 1 19 <11 <11 <11 <11
129 129 2022-01-15 40000474 040000474-community-subacute-and-transitional-care-center COMMUNITY SUBACUTE AND TRANSITIONAL CARE CENTER Fresno 73 26 0 1 19       <11
130 130 2022-01-15 40000019 040000019-dycora-transitional-health-clovis DYCORA TRANSITIONAL HEALTH - CLOVIS Fresno 31 29 0 1 19       <11
131 131 2022-01-15 40000033 040000033-dycora-transitional-health-fowler DYCORA TRANSITIONAL HEALTH - FOWLER Fresno 37 51 0 1 19       <11
132 132 2022-01-15 40000007 040000007-dycora-transitional-health-fresno DYCORA TRANSITIONAL HEALTH - FRESNO Fresno 123 255 1 49 19     <11  
133 133 2022-01-15 40000049 040000049-dycora-transitional-health-manchester DYCORA TRANSITIONAL HEALTH - MANCHESTER Fresno 42 68 0 14 19        
134 134 2022-01-15 40000026 040000026-dycora-transitional-health-memory-care-of-fresno DYCORA TRANSITIONAL HEALTH - MEMORY CARE OF FRESNO Fresno 34 42 0 14 19        
135 135 2022-01-15 40000067 040000067-dycora-transitional-health-reedley DYCORA TRANSITIONAL HEALTH - REEDLEY Fresno 39 34 0 1 19       <11
136 136 2022-01-15 40000077 040000077-dycora-transitional-health-sanger DYCORA TRANSITIONAL HEALTH - SANGER Fresno 66 73 0 1 19       <11
137 137 2022-01-15 40000012 040000012-evergreen-care-center EVERGREEN CARE CENTER Fresno 38 22 0 1 19       <11
138 138 2022-01-15 40000025 040000025-fowler-care-center FOWLER CARE CENTER Fresno 22 18 0 1 19       <11
139 139 2022-01-15 40000043 040000043-fresno-nursing-center FRESNO NURSING CENTER Fresno 63 63 0 11 19        
140 140 2022-01-15 40000004 040000004-fresno-postacute-care FRESNO POSTACUTE CARE Fresno 61 80 0 1 19       <11
141 141 2022-01-15 40000047 040000047-healthcare-centre-of-fresno HEALTHCARE CENTRE OF FRESNO Fresno 41 53 0 1 19       <11
142 142 2022-01-15 40000014 040000014-horizon-health-and-subacute-center HORIZON HEALTH AND SUBACUTE CENTER Fresno 56 64 1 1 19     <11 <11
143 143 2022-01-15 40000002 040000002-kingsburg-center KINGSBURG CENTER Fresno 71 81 0 13 19        
144 144 2022-01-15 40000036 040000036-manning-gardens-care-center-inc MANNING GARDENS CARE CENTER, INC. Fresno 41 40 0 1 19       <11
145 145 2022-01-15 40000059 040000059-north-pointe-healthcare-centre NORTH POINTE HEALTHCARE CENTRE Fresno 57 42 0 1 19       <11
146 146 2022-01-15 40000051 040000051-oakwood-gardens-care-center OAKWOOD GARDENS CARE CENTER Fresno 85 98 1 18 19     <11  
147 147 2022-01-15 40000069 040000069-orchard-post-acute ORCHARD POST ACUTE Fresno 48 75 0 1 19       <11
148 148 2022-01-15 40000063 040000063-pacific-gardens-nursing-and-rehabilitation-center PACIFIC GARDENS NURSING AND REHABILITATION CENTER Fresno 198 186 0 23 19        
149 149 2022-01-15 40000010 040000010-palm-village-retirement-community-health-care-ctr PALM VILLAGE RETIREMENT COMMUNITY HEALTH CARE CTR. Fresno 107 1 0 0 19   <11    
150 150 2022-01-15 40000052 040000052-rolling-hills-care-center ROLLING HILLS CARE CENTER Fresno 25 12 0 1 19       <11
151 151 2022-01-15 40000060 040000060-sierra-view-homes-inc SIERRA VIEW HOMES INC. Fresno 29 27 0 18 19        
152 152 2022-01-15 40000037 040000037-sierra-vista-healthcare SIERRA VISTA HEALTHCARE Fresno 92 94 0 1 19       <11
153 153 2022-01-15 40000061 040000061-sunnyside-convalescent-hospital SUNNYSIDE CONVALESCENT HOSPITAL Fresno 39 31 0 1 19       <11
154 154 2022-01-15 40000076 040000076-the-terraces-at-san-joaquin-gardens-village THE TERRACES AT SAN JOAQUIN GARDENS VILLAGE Fresno 38 1 0 0 19   <11    
155 155 2022-01-15 40000064 040000064-twilight-haven TWILIGHT HAVEN Fresno 53 37 0 1 19       <11
156 156 2022-01-15 630014894 630014894-veterans-home-of-california-fresno VETERANS HOME OF CALIFORNIA - FRESNO Fresno 88 12 0 0 19        
157 157 2022-01-15 40001040 040001040-willow-creek-healthcare-center WILLOW CREEK HEALTHCARE CENTER Fresno 108 151 0 16 19        
158 158 2022-01-15 230000044 230000044-willows-post-acute WILLOWS POST ACUTE Glenn 50 44 0 1 21       <11
159 159 2022-01-15 10000078 010000078-eureka-rehab-wellness-center-lp EUREKA REHAB & WELLNESS CENTER, LP Humboldt 0 1 0 0 23   <11    
160 160 2022-01-15 10000075 010000075-fortuna-rehabilitation-wellness-center-lp FORTUNA REHABILITATION & WELLNESS CENTER, LP Humboldt 22 1 0 1 23   <11   <11
161 161 2022-01-15 10000024 010000024-granada-rehab-wellness-center-lp GRANADA REHAB & WELLNESS CENTER, LP Humboldt 33 59 0 1 23       <11
162 162 2022-01-15 110000621 110000621-jerold-phelps-community-hospital-d-p-snf JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF Humboldt 1 0 0 0 23 <11      
163 163 2022-01-15 10000051 010000051-pacific-rehabilitation-wellness-center-lp PACIFIC REHABILITATION & WELLNESS CENTER, LP Humboldt 1 1 1 1 23 <11 <11 <11 <11
164 164 2022-01-15 10000060 010000060-seaview-rehabilitation-wellness-center-lp SEAVIEW REHABILITATION & WELLNESS CENTER, LP Humboldt 19 1 0 0 23   <11    
165 165 2022-01-15 90000092 090000092-el-centro-post-acute-care EL CENTRO POST-ACUTE CARE Imperial 60 90 0 21 25        
166 166 2022-01-15 90000015 090000015-imperial-heights-healthcare-wellness-centre-llc IMPERIAL HEIGHTS HEALTHCARE & WELLNESS CENTRE, LLC Imperial 68 30 1 1 25     <11 <11
167 167 2022-01-15 90000067 090000067-imperial-manor IMPERIAL MANOR Imperial 39 27 0 0 25        
168 168 2022-01-15 240001854 240001854-bishop-care-center BISHOP CARE CENTER Inyo 35 51 0 13 27        
169 169 2022-01-15 240001102 240001102-southern-inyo-hospital-d-p-snf SOUTHERN INYO HOSPITAL D/P SNF Inyo 27 17 0 1 27       <11
170 170 2022-01-15 120000399 120000399-adventist-health-delano-d-p-snf ADVENTIST HEALTH DELANO D/P SNF Kern 27 1 0 0 29   <11    
171 171 2022-01-15 120000323 120000323-bella-sera BELLA SERA Kern 46 0 0 0 29        
172 172 2022-01-15 120001395 120001395-brookdale-riverwalk-snf-ca BROOKDALE RIVERWALK SNF (CA) Kern 53 37 0 1 29       <11
173 173 2022-01-15 120000638 120000638-delano-district-skilled-nursing-facility DELANO DISTRICT SKILLED NURSING FACILITY Kern 73 31 0 0 29        
174 174 2022-01-15 120000331 120000331-height-street-skilled-care HEIGHT STREET SKILLED CARE Kern 98 71 0 18 29        
175 175 2022-01-15 630017642 630017642-kern-river-transitional-care KERN RIVER TRANSITIONAL CARE Kern 125 73 0 1 29       <11
176 176 2022-01-15 120000695 120000695-kern-valley-healthcare-district-d-p-snf KERN VALLEY HEALTHCARE DISTRICT D/P SNF Kern 34 30 0 1 29       <11
177 177 2022-01-15 120000377 120000377-kingston-healthcare-center-llc KINGSTON HEALTHCARE CENTER, LLC Kern 132 151 0 19 29        
178 178 2022-01-15 120000365 120000365-parkview-julian-healthcare-center PARKVIEW JULIAN HEALTHCARE CENTER Kern 88 107 0 1 29       <11
179 179 2022-01-15 630013665 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT Kern 13 0 0 0 29        
180 180 2022-01-15 120000369 120000369-rosewood-health-facility ROSEWOOD HEALTH FACILITY Kern 75 55 0 1 29       <11
181 181 2022-01-15 120000322 120000322-san-joaquin-nursing-center SAN JOAQUIN NURSING CENTER Kern 105 122 0 1 29       <11
182 182 2022-01-15 120000375 120000375-shafter-nursing-care SHAFTER NURSING CARE Kern 92 87 0 1 29       <11
183 183 2022-01-15 120000320 120000320-the-orchards-post-acute THE ORCHARDS POST-ACUTE Kern 115 128 0 1 29       <11
184 184 2022-01-15 120000328 120000328-the-rehabilitation-center-of-bakersfield THE REHABILITATION CENTER OF BAKERSFIELD Kern 144 153 0 16 29        
185 185 2022-01-15 120000355 120000355-valley-convalescent-hospital VALLEY CONVALESCENT HOSPITAL Kern 66 79 0 1 29       <11
186 186 2022-01-15 120000325 120000325-valley-view-care-center VALLEY VIEW CARE CENTER Kern 31 45 0 1 29       <11
187 187 2022-01-15 120000373 120000373-windsor-post-acute-center-of-arvin WINDSOR POST-ACUTE CENTER OF ARVIN Kern 70 96 0 1 29       <11
188 188 2022-01-15 120000379 120000379-windsor-post-acute-center-of-bakersfield WINDSOR POST-ACUTE CENTER OF BAKERSFIELD Kern 69 75 1 14 29     <11  
189 189 2022-01-15 40000042 040000042-hacienda-post-acute-inc HACIENDA POST ACUTE, INC. Kings 145 114 0 24 31        
190 190 2022-01-15 40001364 040001364-hanford-post-acute HANFORD POST ACUTE Kings 53 66 0 13 31        
191 191 2022-01-15 40001366 040001366-kings-nursing-rehabilitation-center KINGS NURSING & REHABILITATION CENTER Kings 53 30 0 0 31        
192 192 2022-01-15 110001255 110001255-lakeport-post-acute LAKEPORT POST ACUTE Lake 36 63 0 12 33        
193 193 2022-01-15 110001250 110001250-meadowood-nursing-center MEADOWOOD NURSING CENTER Lake 40 17 0 1 33       <11
194 194 2022-01-15 110001248 110001248-rocky-point-care-center ROCKY POINT CARE CENTER Lake 51 55 1 1 33     <11 <11
195 195 2022-01-15 230000039 230000039-lassen-nursing-rehabilitation-center LASSEN NURSING & REHABILITATION CENTER Lassen 23 33 1 1 35     <11 <11
196 196 2022-01-15 940000049 940000049-affinity-healthcare-center AFFINITY HEALTHCARE CENTER Los Angeles 106 47 0 16 37        
197 197 2022-01-15 920000077 920000077-alameda-care-center ALAMEDA CARE CENTER Los Angeles 67 101 1 26 37     <11  
198 198 2022-01-15 940000062 940000062-alamitos-belmont-rehabilitation-hospital ALAMITOS BELMONT REHABILITATION HOSPITAL Los Angeles 62 46 0 1 37       <11
199 199 2022-01-15 970000001 970000001-alcott-rehabilitation-hospital ALCOTT REHABILITATION HOSPITAL Los Angeles 78 77 1 1 37     <11 <11
200 200 2022-01-15 970000121 970000121-alden-terrace-convalescent-hospital ALDEN TERRACE CONVALESCENT HOSPITAL Los Angeles 50 141 0 33 37        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [la_times_cdph_skilled_nursing_facilities] (
   [date] TEXT,
   [id] INTEGER,
   [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
);