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.
56 rows where "date" is on date 2021-09-24
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_deaths, date (date)
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
25350 | 25350 | 2021-09-24 | Alameda | 1 | 1796 | 2455 | 5 | 146 |
25351 | 25351 | 2021-09-24 | Amador | 5 | 34 | 67 | 0 | 17 |
25352 | 25352 | 2021-09-24 | Butte | 7 | 379 | 517 | 0 | 49 |
25353 | 25353 | 2021-09-24 | Calaveras | 9 | 29 | 64 | 0 | 1 |
25354 | 25354 | 2021-09-24 | Colusa | 11 | 79 | 58 | 0 | 2 |
25355 | 25355 | 2021-09-24 | Contra Costa | 13 | 729 | 1117 | 5 | 102 |
25356 | 25356 | 2021-09-24 | Del Norte | 15 | 40 | 1 | 0 | 0 |
25357 | 25357 | 2021-09-24 | El Dorado | 17 | 230 | 210 | 0 | 33 |
25358 | 25358 | 2021-09-24 | Fresno | 19 | 1577 | 1605 | 3 | 179 |
25359 | 25359 | 2021-09-24 | Glenn | 21 | 44 | 43 | 0 | 1 |
25360 | 25360 | 2021-09-24 | Humboldt | 23 | 37 | 62 | 1 | 3 |
25361 | 25361 | 2021-09-24 | Imperial | 25 | 138 | 117 | 1 | 22 |
25362 | 25362 | 2021-09-24 | Inyo | 27 | 45 | 60 | 0 | 13 |
25363 | 25363 | 2021-09-24 | Kern | 29 | 1196 | 1227 | 1 | 76 |
25364 | 25364 | 2021-09-24 | Kings | 31 | 213 | 178 | 0 | 25 |
25365 | 25365 | 2021-09-24 | Lake | 33 | 109 | 110 | 1 | 13 |
25366 | 25366 | 2021-09-24 | Lassen | 35 | 22 | 33 | 1 | 1 |
25367 | 25367 | 2021-09-24 | Los Angeles | 37 | 18531 | 21360 | 103 | 3118 |
25368 | 25368 | 2021-09-24 | Madera | 39 | 222 | 301 | 0 | 25 |
25369 | 25369 | 2021-09-24 | Marin | 41 | 240 | 316 | 2 | 42 |
25370 | 25370 | 2021-09-24 | Mariposa | 43 | 1 | 0 | 0 | 0 |
25371 | 25371 | 2021-09-24 | Mendocino | 45 | 81 | 79 | 1 | 4 |
25372 | 25372 | 2021-09-24 | Merced | 47 | 259 | 261 | 1 | 16 |
25373 | 25373 | 2021-09-24 | Modoc | 49 | 60 | 48 | 0 | 2 |
25374 | 25374 | 2021-09-24 | Monterey | 53 | 468 | 551 | 0 | 55 |
25375 | 25375 | 2021-09-24 | Napa | 55 | 193 | 179 | 0 | 15 |
25376 | 25376 | 2021-09-24 | Nevada | 57 | 193 | 218 | 0 | 46 |
25377 | 25377 | 2021-09-24 | Orange | 59 | 3802 | 4441 | 14 | 602 |
25378 | 25378 | 2021-09-24 | Placer | 61 | 417 | 519 | 0 | 36 |
25379 | 25379 | 2021-09-24 | Plumas | 63 | 12 | 1 | 0 | 1 |
25380 | 25380 | 2021-09-24 | Riverside | 65 | 2646 | 3187 | 6 | 229 |
25381 | 25381 | 2021-09-24 | Sacramento | 67 | 1916 | 2463 | 4 | 164 |
25382 | 25382 | 2021-09-24 | San Benito | 69 | 33 | 2 | 1 | 2 |
25383 | 25383 | 2021-09-24 | San Bernardino | 71 | 2820 | 3444 | 8 | 304 |
25384 | 25384 | 2021-09-24 | San Diego | 73 | 4076 | 4702 | 8 | 333 |
25385 | 25385 | 2021-09-24 | San Francisco | 75 | 660 | 683 | 2 | 35 |
25386 | 25386 | 2021-09-24 | San Joaquin | 77 | 1530 | 1920 | 3 | 200 |
25387 | 25387 | 2021-09-24 | San Luis Obispo | 79 | 273 | 324 | 0 | 36 |
25388 | 25388 | 2021-09-24 | San Mateo | 81 | 485 | 834 | 3 | 107 |
25389 | 25389 | 2021-09-24 | Santa Barbara | 83 | 480 | 464 | 2 | 25 |
25390 | 25390 | 2021-09-24 | Santa Clara | 85 | 2064 | 2653 | 5 | 210 |
25391 | 25391 | 2021-09-24 | Santa Cruz | 87 | 247 | 460 | 0 | 66 |
25392 | 25392 | 2021-09-24 | Shasta | 89 | 567 | 461 | 0 | 59 |
25393 | 25393 | 2021-09-24 | Sierra | 91 | 1 | 0 | 0 | 0 |
25394 | 25394 | 2021-09-24 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
25395 | 25395 | 2021-09-24 | Solano | 95 | 226 | 306 | 0 | 19 |
25396 | 25396 | 2021-09-24 | Sonoma | 97 | 586 | 697 | 2 | 26 |
25397 | 25397 | 2021-09-24 | Stanislaus | 99 | 1274 | 1543 | 1 | 143 |
25398 | 25398 | 2021-09-24 | Sutter | 101 | 251 | 298 | 0 | 15 |
25399 | 25399 | 2021-09-24 | Tehama | 103 | 33 | 57 | 0 | 12 |
25400 | 25400 | 2021-09-24 | Trinity | 105 | 17 | 1 | 0 | 1 |
25401 | 25401 | 2021-09-24 | Tulare | 107 | 938 | 1019 | 2 | 147 |
25402 | 25402 | 2021-09-24 | Tuolumne | 109 | 65 | 92 | 0 | 15 |
25403 | 25403 | 2021-09-24 | Ventura | 111 | 903 | 1002 | 1 | 82 |
25404 | 25404 | 2021-09-24 | Yolo | 113 | 247 | 284 | 2 | 39 |
25405 | 25405 | 2021-09-24 | Yuba | 115 | 48 | 54 | 0 | 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 );