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_staff_confirmed_cases
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 |
6 | 6 | 2020-06-05 | Humboldt | 23 | 1 | 1 | 1 | 1 |
9 | 9 | 2020-06-05 | Kings | 31 | 1 | 19 | 0 | 0 |
11 | 11 | 2020-06-05 | Madera | 39 | 1 | 1 | 0 | 0 |
13 | 13 | 2020-06-05 | Mendocino | 45 | 1 | 1 | 1 | 1 |
16 | 16 | 2020-06-05 | Napa | 55 | 1 | 0 | 0 | 0 |
21 | 21 | 2020-06-05 | San Benito | 69 | 1 | 1 | 1 | 1 |
30 | 30 | 2020-06-05 | Santa Cruz | 87 | 1 | 0 | 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 |
43 | 43 | 2020-06-06 | Humboldt | 23 | 1 | 1 | 1 | 1 |
48 | 48 | 2020-06-06 | Madera | 39 | 1 | 1 | 0 | 0 |
50 | 50 | 2020-06-06 | Mendocino | 45 | 1 | 1 | 1 | 1 |
53 | 53 | 2020-06-06 | Napa | 55 | 1 | 0 | 0 | 0 |
58 | 58 | 2020-06-06 | San Benito | 69 | 1 | 1 | 1 | 1 |
67 | 67 | 2020-06-06 | Santa Cruz | 87 | 1 | 0 | 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 |
80 | 80 | 2020-06-07 | Humboldt | 23 | 1 | 1 | 1 | 1 |
85 | 85 | 2020-06-07 | Madera | 39 | 1 | 1 | 0 | 0 |
87 | 87 | 2020-06-07 | Mendocino | 45 | 1 | 1 | 1 | 1 |
90 | 90 | 2020-06-07 | Napa | 55 | 1 | 0 | 0 | 0 |
95 | 95 | 2020-06-07 | San Benito | 69 | 1 | 1 | 1 | 1 |
104 | 104 | 2020-06-07 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
115 | 115 | 2020-06-08 | El Dorado | 17 | 1 | 0 | 0 | 0 |
117 | 117 | 2020-06-08 | Humboldt | 23 | 1 | 1 | 1 | 1 |
122 | 122 | 2020-06-08 | Madera | 39 | 1 | 1 | 0 | 0 |
124 | 124 | 2020-06-08 | Mendocino | 45 | 1 | 1 | 1 | 1 |
127 | 127 | 2020-06-08 | Napa | 55 | 1 | 0 | 0 | 0 |
132 | 132 | 2020-06-08 | San Benito | 69 | 1 | 1 | 1 | 1 |
141 | 141 | 2020-06-08 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
152 | 152 | 2020-06-09 | El Dorado | 17 | 1 | 0 | 0 | 0 |
154 | 154 | 2020-06-09 | Humboldt | 23 | 1 | 1 | 1 | 1 |
159 | 159 | 2020-06-09 | Madera | 39 | 1 | 1 | 0 | 0 |
161 | 161 | 2020-06-09 | Mendocino | 45 | 1 | 1 | 1 | 1 |
164 | 164 | 2020-06-09 | Napa | 55 | 1 | 0 | 0 | 0 |
169 | 169 | 2020-06-09 | San Benito | 69 | 1 | 1 | 1 | 1 |
178 | 178 | 2020-06-09 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
189 | 189 | 2020-06-10 | El Dorado | 17 | 1 | 0 | 0 | 0 |
191 | 191 | 2020-06-10 | Humboldt | 23 | 1 | 1 | 1 | 1 |
196 | 196 | 2020-06-10 | Madera | 39 | 1 | 1 | 0 | 0 |
198 | 198 | 2020-06-10 | Mendocino | 45 | 1 | 1 | 1 | 1 |
201 | 201 | 2020-06-10 | Napa | 55 | 1 | 0 | 0 | 0 |
206 | 206 | 2020-06-10 | San Benito | 69 | 1 | 1 | 1 | 1 |
215 | 215 | 2020-06-10 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
220 | 220 | 2020-06-10 | Sutter | 101 | 1 | 0 | 0 | 0 |
227 | 227 | 2020-06-11 | El Dorado | 17 | 1 | 0 | 0 | 0 |
229 | 229 | 2020-06-11 | Humboldt | 23 | 1 | 1 | 1 | 1 |
234 | 234 | 2020-06-11 | Madera | 39 | 1 | 1 | 0 | 0 |
236 | 236 | 2020-06-11 | Mendocino | 45 | 1 | 1 | 1 | 1 |
239 | 239 | 2020-06-11 | Napa | 55 | 1 | 0 | 0 | 0 |
244 | 244 | 2020-06-11 | San Benito | 69 | 1 | 1 | 1 | 1 |
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 |
266 | 266 | 2020-06-12 | El Dorado | 17 | 1 | 0 | 0 | 0 |
268 | 268 | 2020-06-12 | Humboldt | 23 | 1 | 1 | 1 | 1 |
273 | 273 | 2020-06-12 | Madera | 39 | 1 | 1 | 0 | 0 |
275 | 275 | 2020-06-12 | Mendocino | 45 | 1 | 1 | 1 | 1 |
283 | 283 | 2020-06-12 | San Benito | 69 | 1 | 1 | 1 | 1 |
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 |
305 | 305 | 2020-06-13 | El Dorado | 17 | 1 | 0 | 0 | 0 |
307 | 307 | 2020-06-13 | Humboldt | 23 | 1 | 1 | 1 | 1 |
312 | 312 | 2020-06-13 | Madera | 39 | 1 | 1 | 0 | 0 |
314 | 314 | 2020-06-13 | Mendocino | 45 | 1 | 1 | 1 | 1 |
322 | 322 | 2020-06-13 | San Benito | 69 | 1 | 1 | 1 | 1 |
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 |
344 | 344 | 2020-06-14 | El Dorado | 17 | 1 | 0 | 0 | 0 |
346 | 346 | 2020-06-14 | Humboldt | 23 | 1 | 1 | 1 | 1 |
351 | 351 | 2020-06-14 | Madera | 39 | 1 | 1 | 0 | 0 |
353 | 353 | 2020-06-14 | Mendocino | 45 | 1 | 1 | 1 | 1 |
361 | 361 | 2020-06-14 | San Benito | 69 | 1 | 1 | 1 | 1 |
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 |
383 | 383 | 2020-06-15 | El Dorado | 17 | 1 | 0 | 0 | 0 |
385 | 385 | 2020-06-15 | Humboldt | 23 | 1 | 1 | 1 | 1 |
390 | 390 | 2020-06-15 | Madera | 39 | 1 | 1 | 0 | 0 |
392 | 392 | 2020-06-15 | Mendocino | 45 | 1 | 1 | 1 | 1 |
400 | 400 | 2020-06-15 | San Benito | 69 | 1 | 1 | 1 | 1 |
409 | 409 | 2020-06-15 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
414 | 414 | 2020-06-15 | Sutter | 101 | 1 | 0 | 0 | 0 |
416 | 416 | 2020-06-15 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
422 | 422 | 2020-06-16 | El Dorado | 17 | 1 | 0 | 0 | 0 |
424 | 424 | 2020-06-16 | Humboldt | 23 | 1 | 1 | 1 | 1 |
429 | 429 | 2020-06-16 | Madera | 39 | 1 | 1 | 0 | 0 |
431 | 431 | 2020-06-16 | Mendocino | 45 | 1 | 1 | 1 | 1 |
439 | 439 | 2020-06-16 | San Benito | 69 | 1 | 1 | 1 | 1 |
448 | 448 | 2020-06-16 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
453 | 453 | 2020-06-16 | Sutter | 101 | 1 | 0 | 0 | 0 |
455 | 455 | 2020-06-16 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
461 | 461 | 2020-06-17 | El Dorado | 17 | 1 | 0 | 0 | 0 |
463 | 463 | 2020-06-17 | Humboldt | 23 | 1 | 1 | 1 | 1 |
468 | 468 | 2020-06-17 | Madera | 39 | 1 | 1 | 0 | 0 |
470 | 470 | 2020-06-17 | Mendocino | 45 | 1 | 1 | 1 | 1 |
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 );