la_times_cdph_skilled_nursing_facilities

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

259,300 rows sorted by date descending

View and edit SQL

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