cdph-nursing-home-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- minimum_staff_confirmed_cases
- The minimum number of cumulative confirmed coronavirus case amoung staff at that time.
- minimum_patients_confirmed_cases
- The minimum number of cumulative confirmed coronavirus case amoung patients at that time.
- minimum_staff_deaths
- The minimum number of cumulative deaths amoung staff at that time.
- minimum_patients_deaths
- The minimum number of cumulative deaths amoung patients at that time.
31,733 rows sorted by minimum_patients_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths ▼ |
---|---|---|---|---|---|---|---|---|
2 | 2 | 2020-06-05 | Butte | 7 | 1 | 1 | 0 | 0 |
4 | 4 | 2020-06-05 | El Dorado | 17 | 1 | 0 | 0 | 0 |
9 | 9 | 2020-06-05 | Kings | 31 | 1 | 19 | 0 | 0 |
11 | 11 | 2020-06-05 | Madera | 39 | 1 | 1 | 0 | 0 |
14 | 14 | 2020-06-05 | Merced | 47 | 2 | 1 | 0 | 0 |
16 | 16 | 2020-06-05 | Napa | 55 | 1 | 0 | 0 | 0 |
26 | 26 | 2020-06-05 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
30 | 30 | 2020-06-05 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
36 | 36 | 2020-06-05 | Ventura | 111 | 21 | 4 | 0 | 0 |
39 | 39 | 2020-06-06 | Butte | 7 | 1 | 1 | 0 | 0 |
41 | 41 | 2020-06-06 | El Dorado | 17 | 1 | 0 | 0 | 0 |
46 | 46 | 2020-06-06 | Kings | 31 | 17 | 20 | 0 | 0 |
48 | 48 | 2020-06-06 | Madera | 39 | 1 | 1 | 0 | 0 |
51 | 51 | 2020-06-06 | Merced | 47 | 3 | 1 | 0 | 0 |
53 | 53 | 2020-06-06 | Napa | 55 | 1 | 0 | 0 | 0 |
63 | 63 | 2020-06-06 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
67 | 67 | 2020-06-06 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
73 | 73 | 2020-06-06 | Ventura | 111 | 21 | 4 | 0 | 0 |
76 | 76 | 2020-06-07 | Butte | 7 | 1 | 1 | 0 | 0 |
78 | 78 | 2020-06-07 | El Dorado | 17 | 1 | 0 | 0 | 0 |
83 | 83 | 2020-06-07 | Kings | 31 | 19 | 20 | 0 | 0 |
85 | 85 | 2020-06-07 | Madera | 39 | 1 | 1 | 0 | 0 |
88 | 88 | 2020-06-07 | Merced | 47 | 3 | 1 | 0 | 0 |
90 | 90 | 2020-06-07 | Napa | 55 | 1 | 0 | 0 | 0 |
100 | 100 | 2020-06-07 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
104 | 104 | 2020-06-07 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
110 | 110 | 2020-06-07 | Ventura | 111 | 22 | 4 | 0 | 0 |
113 | 113 | 2020-06-08 | Butte | 7 | 2 | 1 | 0 | 0 |
115 | 115 | 2020-06-08 | El Dorado | 17 | 1 | 0 | 0 | 0 |
120 | 120 | 2020-06-08 | Kings | 31 | 20 | 21 | 0 | 0 |
122 | 122 | 2020-06-08 | Madera | 39 | 1 | 1 | 0 | 0 |
125 | 125 | 2020-06-08 | Merced | 47 | 3 | 1 | 0 | 0 |
127 | 127 | 2020-06-08 | Napa | 55 | 1 | 0 | 0 | 0 |
137 | 137 | 2020-06-08 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
141 | 141 | 2020-06-08 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
147 | 147 | 2020-06-08 | Ventura | 111 | 22 | 4 | 0 | 0 |
150 | 150 | 2020-06-09 | Butte | 7 | 2 | 2 | 0 | 0 |
152 | 152 | 2020-06-09 | El Dorado | 17 | 1 | 0 | 0 | 0 |
157 | 157 | 2020-06-09 | Kings | 31 | 20 | 22 | 0 | 0 |
159 | 159 | 2020-06-09 | Madera | 39 | 1 | 1 | 0 | 0 |
162 | 162 | 2020-06-09 | Merced | 47 | 3 | 1 | 0 | 0 |
164 | 164 | 2020-06-09 | Napa | 55 | 1 | 0 | 0 | 0 |
174 | 174 | 2020-06-09 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
178 | 178 | 2020-06-09 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
184 | 184 | 2020-06-09 | Ventura | 111 | 22 | 4 | 0 | 0 |
187 | 187 | 2020-06-10 | Butte | 7 | 2 | 2 | 0 | 0 |
189 | 189 | 2020-06-10 | El Dorado | 17 | 1 | 0 | 0 | 0 |
194 | 194 | 2020-06-10 | Kings | 31 | 20 | 27 | 0 | 0 |
196 | 196 | 2020-06-10 | Madera | 39 | 1 | 1 | 0 | 0 |
199 | 199 | 2020-06-10 | Merced | 47 | 3 | 1 | 0 | 0 |
201 | 201 | 2020-06-10 | Napa | 55 | 1 | 0 | 0 | 0 |
211 | 211 | 2020-06-10 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
215 | 215 | 2020-06-10 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
220 | 220 | 2020-06-10 | Sutter | 101 | 1 | 0 | 0 | 0 |
222 | 222 | 2020-06-10 | Ventura | 111 | 22 | 5 | 0 | 0 |
225 | 225 | 2020-06-11 | Butte | 7 | 2 | 2 | 0 | 0 |
227 | 227 | 2020-06-11 | El Dorado | 17 | 1 | 0 | 0 | 0 |
232 | 232 | 2020-06-11 | Kings | 31 | 21 | 48 | 0 | 0 |
234 | 234 | 2020-06-11 | Madera | 39 | 1 | 1 | 0 | 0 |
237 | 237 | 2020-06-11 | Merced | 47 | 3 | 1 | 0 | 0 |
239 | 239 | 2020-06-11 | Napa | 55 | 1 | 0 | 0 | 0 |
249 | 249 | 2020-06-11 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
253 | 253 | 2020-06-11 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
258 | 258 | 2020-06-11 | Sutter | 101 | 1 | 0 | 0 | 0 |
260 | 260 | 2020-06-11 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
261 | 261 | 2020-06-11 | Ventura | 111 | 22 | 5 | 0 | 0 |
264 | 264 | 2020-06-12 | Butte | 7 | 2 | 2 | 0 | 0 |
266 | 266 | 2020-06-12 | El Dorado | 17 | 1 | 0 | 0 | 0 |
271 | 271 | 2020-06-12 | Kings | 31 | 23 | 49 | 0 | 0 |
273 | 273 | 2020-06-12 | Madera | 39 | 1 | 1 | 0 | 0 |
276 | 276 | 2020-06-12 | Merced | 47 | 3 | 1 | 0 | 0 |
278 | 278 | 2020-06-12 | Napa | 55 | 2 | 1 | 0 | 0 |
288 | 288 | 2020-06-12 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
292 | 292 | 2020-06-12 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
297 | 297 | 2020-06-12 | Sutter | 101 | 1 | 0 | 0 | 0 |
299 | 299 | 2020-06-12 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
300 | 300 | 2020-06-12 | Ventura | 111 | 22 | 5 | 0 | 0 |
303 | 303 | 2020-06-13 | Butte | 7 | 2 | 2 | 0 | 0 |
305 | 305 | 2020-06-13 | El Dorado | 17 | 1 | 0 | 0 | 0 |
310 | 310 | 2020-06-13 | Kings | 31 | 27 | 49 | 0 | 0 |
312 | 312 | 2020-06-13 | Madera | 39 | 1 | 1 | 0 | 0 |
315 | 315 | 2020-06-13 | Merced | 47 | 3 | 1 | 0 | 0 |
317 | 317 | 2020-06-13 | Napa | 55 | 2 | 1 | 0 | 0 |
327 | 327 | 2020-06-13 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
331 | 331 | 2020-06-13 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
336 | 336 | 2020-06-13 | Sutter | 101 | 1 | 0 | 0 | 0 |
338 | 338 | 2020-06-13 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
339 | 339 | 2020-06-13 | Ventura | 111 | 22 | 5 | 0 | 0 |
342 | 342 | 2020-06-14 | Butte | 7 | 2 | 2 | 0 | 0 |
344 | 344 | 2020-06-14 | El Dorado | 17 | 1 | 0 | 0 | 0 |
351 | 351 | 2020-06-14 | Madera | 39 | 1 | 1 | 0 | 0 |
354 | 354 | 2020-06-14 | Merced | 47 | 3 | 1 | 0 | 0 |
356 | 356 | 2020-06-14 | Napa | 55 | 2 | 1 | 0 | 0 |
366 | 366 | 2020-06-14 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
370 | 370 | 2020-06-14 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
375 | 375 | 2020-06-14 | Sutter | 101 | 1 | 0 | 0 | 0 |
377 | 377 | 2020-06-14 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
378 | 378 | 2020-06-14 | Ventura | 111 | 22 | 5 | 0 | 0 |
381 | 381 | 2020-06-15 | Butte | 7 | 2 | 2 | 0 | 0 |
383 | 383 | 2020-06-15 | El Dorado | 17 | 1 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-nursing-home-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [minimum_staff_confirmed_cases] INTEGER, [minimum_patients_confirmed_cases] INTEGER, [minimum_staff_deaths] INTEGER, [minimum_patients_deaths] INTEGER );