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.
49 rows where "date" is on date 2020-08-19
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_deaths, minimum_patients_deaths, date (date)
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
3221 | 3221 | 2020-08-19 | Alameda | 1 | 459 | 738 | 3 | 40 |
3222 | 3222 | 2020-08-19 | Amador | 5 | 22 | 51 | 0 | 15 |
3223 | 3223 | 2020-08-19 | Butte | 7 | 45 | 74 | 0 | 3 |
3224 | 3224 | 2020-08-19 | Calaveras | 9 | 1 | 1 | 0 | 1 |
3225 | 3225 | 2020-08-19 | Colusa | 11 | 40 | 29 | 0 | 1 |
3226 | 3226 | 2020-08-19 | Contra Costa | 13 | 181 | 331 | 4 | 46 |
3227 | 3227 | 2020-08-19 | El Dorado | 17 | 4 | 1 | 0 | 0 |
3228 | 3228 | 2020-08-19 | Fresno | 19 | 338 | 394 | 3 | 49 |
3229 | 3229 | 2020-08-19 | Glenn | 21 | 1 | 0 | 0 | 0 |
3230 | 3230 | 2020-08-19 | Humboldt | 23 | 2 | 1 | 1 | 1 |
3231 | 3231 | 2020-08-19 | Imperial | 25 | 98 | 81 | 1 | 18 |
3232 | 3232 | 2020-08-19 | Inyo | 27 | 16 | 46 | 0 | 1 |
3233 | 3233 | 2020-08-19 | Kern | 29 | 382 | 407 | 0 | 26 |
3234 | 3234 | 2020-08-19 | Kings | 31 | 77 | 90 | 0 | 23 |
3235 | 3235 | 2020-08-19 | Lake | 33 | 1 | 0 | 0 | 0 |
3236 | 3236 | 2020-08-19 | Los Angeles | 37 | 6513 | 9991 | 53 | 1516 |
3237 | 3237 | 2020-08-19 | Madera | 39 | 78 | 123 | 0 | 18 |
3238 | 3238 | 2020-08-19 | Marin | 41 | 88 | 158 | 1 | 19 |
3239 | 3239 | 2020-08-19 | Mendocino | 45 | 3 | 25 | 1 | 2 |
3240 | 3240 | 2020-08-19 | Merced | 47 | 42 | 77 | 1 | 2 |
3241 | 3241 | 2020-08-19 | Monterey | 53 | 85 | 38 | 0 | 2 |
3242 | 3242 | 2020-08-19 | Napa | 55 | 21 | 47 | 0 | 1 |
3243 | 3243 | 2020-08-19 | Nevada | 57 | 3 | 1 | 0 | 0 |
3244 | 3244 | 2020-08-19 | Orange | 59 | 1189 | 1603 | 8 | 217 |
3245 | 3245 | 2020-08-19 | Placer | 61 | 10 | 23 | 0 | 3 |
3246 | 3246 | 2020-08-19 | Plumas | 63 | 1 | 0 | 0 | 0 |
3247 | 3247 | 2020-08-19 | Riverside | 65 | 920 | 1265 | 5 | 114 |
3248 | 3248 | 2020-08-19 | Sacramento | 67 | 291 | 359 | 1 | 20 |
3249 | 3249 | 2020-08-19 | San Benito | 69 | 2 | 1 | 1 | 2 |
3250 | 3250 | 2020-08-19 | San Bernardino | 71 | 999 | 1596 | 6 | 121 |
3251 | 3251 | 2020-08-19 | San Diego | 73 | 572 | 888 | 2 | 97 |
3252 | 3252 | 2020-08-19 | San Francisco | 75 | 141 | 126 | 1 | 14 |
3253 | 3253 | 2020-08-19 | San Joaquin | 77 | 531 | 681 | 1 | 43 |
3254 | 3254 | 2020-08-19 | San Luis Obispo | 79 | 25 | 26 | 0 | 1 |
3255 | 3255 | 2020-08-19 | San Mateo | 81 | 106 | 227 | 3 | 23 |
3256 | 3256 | 2020-08-19 | Santa Barbara | 83 | 91 | 94 | 1 | 5 |
3257 | 3257 | 2020-08-19 | Santa Clara | 85 | 307 | 363 | 1 | 26 |
3258 | 3258 | 2020-08-19 | Santa Cruz | 87 | 7 | 4 | 0 | 0 |
3259 | 3259 | 2020-08-19 | Shasta | 89 | 6 | 4 | 0 | 1 |
3260 | 3260 | 2020-08-19 | Solano | 95 | 40 | 103 | 0 | 11 |
3261 | 3261 | 2020-08-19 | Sonoma | 97 | 152 | 259 | 1 | 7 |
3262 | 3262 | 2020-08-19 | Stanislaus | 99 | 344 | 538 | 0 | 36 |
3263 | 3263 | 2020-08-19 | Sutter | 101 | 17 | 3 | 0 | 0 |
3264 | 3264 | 2020-08-19 | Trinity | 105 | 1 | 0 | 0 | 0 |
3265 | 3265 | 2020-08-19 | Tulare | 107 | 351 | 556 | 1 | 87 |
3266 | 3266 | 2020-08-19 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
3267 | 3267 | 2020-08-19 | Ventura | 111 | 207 | 134 | 0 | 5 |
3268 | 3268 | 2020-08-19 | Yolo | 113 | 30 | 53 | 1 | 16 |
3269 | 3269 | 2020-08-19 | Yuba | 115 | 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 );