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-07-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_confirmed_cases, minimum_patients_confirmed_cases, minimum_staff_deaths, minimum_patients_deaths
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
22214 | 22214 | 2021-07-30 | Alameda | 1 | 1735 | 2442 | 5 | 146 |
22215 | 22215 | 2021-07-30 | Amador | 5 | 29 | 61 | 0 | 17 |
22216 | 22216 | 2021-07-30 | Butte | 7 | 343 | 478 | 0 | 43 |
22217 | 22217 | 2021-07-30 | Calaveras | 9 | 25 | 58 | 0 | 1 |
22218 | 22218 | 2021-07-30 | Colusa | 11 | 79 | 58 | 0 | 2 |
22219 | 22219 | 2021-07-30 | Contra Costa | 13 | 683 | 1090 | 5 | 101 |
22220 | 22220 | 2021-07-30 | Del Norte | 15 | 25 | 1 | 0 | 0 |
22221 | 22221 | 2021-07-30 | El Dorado | 17 | 207 | 188 | 0 | 33 |
22222 | 22222 | 2021-07-30 | Fresno | 19 | 1480 | 1549 | 3 | 177 |
22223 | 22223 | 2021-07-30 | Glenn | 21 | 40 | 43 | 0 | 1 |
22224 | 22224 | 2021-07-30 | Humboldt | 23 | 35 | 61 | 1 | 3 |
22225 | 22225 | 2021-07-30 | Imperial | 25 | 136 | 117 | 1 | 22 |
22226 | 22226 | 2021-07-30 | Inyo | 27 | 44 | 60 | 0 | 13 |
22227 | 22227 | 2021-07-30 | Kern | 29 | 1126 | 1138 | 1 | 75 |
22228 | 22228 | 2021-07-30 | Kings | 31 | 193 | 169 | 0 | 25 |
22229 | 22229 | 2021-07-30 | Lake | 33 | 96 | 110 | 0 | 13 |
22230 | 22230 | 2021-07-30 | Lassen | 35 | 15 | 33 | 0 | 1 |
22231 | 22231 | 2021-07-30 | Los Angeles | 37 | 18092 | 21076 | 102 | 3110 |
22232 | 22232 | 2021-07-30 | Madera | 39 | 215 | 294 | 0 | 25 |
22233 | 22233 | 2021-07-30 | Marin | 41 | 237 | 316 | 2 | 42 |
22234 | 22234 | 2021-07-30 | Mariposa | 43 | 1 | 0 | 0 | 0 |
22235 | 22235 | 2021-07-30 | Mendocino | 45 | 36 | 41 | 1 | 3 |
22236 | 22236 | 2021-07-30 | Merced | 47 | 241 | 247 | 1 | 6 |
22237 | 22237 | 2021-07-30 | Modoc | 49 | 50 | 47 | 0 | 2 |
22238 | 22238 | 2021-07-30 | Monterey | 53 | 457 | 547 | 0 | 55 |
22239 | 22239 | 2021-07-30 | Napa | 55 | 175 | 146 | 0 | 15 |
22240 | 22240 | 2021-07-30 | Nevada | 57 | 159 | 197 | 0 | 46 |
22241 | 22241 | 2021-07-30 | Orange | 59 | 3703 | 4352 | 14 | 580 |
22242 | 22242 | 2021-07-30 | Placer | 61 | 373 | 466 | 0 | 36 |
22243 | 22243 | 2021-07-30 | Plumas | 63 | 2 | 1 | 0 | 1 |
22244 | 22244 | 2021-07-30 | Riverside | 65 | 2546 | 3060 | 6 | 216 |
22245 | 22245 | 2021-07-30 | Sacramento | 67 | 1818 | 2371 | 4 | 150 |
22246 | 22246 | 2021-07-30 | San Benito | 69 | 32 | 2 | 1 | 2 |
22247 | 22247 | 2021-07-30 | San Bernardino | 71 | 2726 | 3331 | 8 | 291 |
22248 | 22248 | 2021-07-30 | San Diego | 73 | 3807 | 4486 | 7 | 329 |
22249 | 22249 | 2021-07-30 | San Francisco | 75 | 624 | 663 | 2 | 34 |
22250 | 22250 | 2021-07-30 | San Joaquin | 77 | 1451 | 1849 | 3 | 198 |
22251 | 22251 | 2021-07-30 | San Luis Obispo | 79 | 262 | 310 | 0 | 35 |
22252 | 22252 | 2021-07-30 | San Mateo | 81 | 440 | 828 | 3 | 107 |
22253 | 22253 | 2021-07-30 | Santa Barbara | 83 | 454 | 458 | 2 | 25 |
22254 | 22254 | 2021-07-30 | Santa Clara | 85 | 2001 | 2598 | 5 | 209 |
22255 | 22255 | 2021-07-30 | Santa Cruz | 87 | 240 | 460 | 0 | 66 |
22256 | 22256 | 2021-07-30 | Shasta | 89 | 445 | 419 | 0 | 58 |
22257 | 22257 | 2021-07-30 | Sierra | 91 | 1 | 0 | 0 | 0 |
22258 | 22258 | 2021-07-30 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
22259 | 22259 | 2021-07-30 | Solano | 95 | 204 | 274 | 0 | 17 |
22260 | 22260 | 2021-07-30 | Sonoma | 97 | 549 | 642 | 2 | 25 |
22261 | 22261 | 2021-07-30 | Stanislaus | 99 | 1223 | 1521 | 1 | 143 |
22262 | 22262 | 2021-07-30 | Sutter | 101 | 243 | 264 | 0 | 15 |
22263 | 22263 | 2021-07-30 | Tehama | 103 | 20 | 43 | 0 | 11 |
22264 | 22264 | 2021-07-30 | Trinity | 105 | 11 | 1 | 0 | 1 |
22265 | 22265 | 2021-07-30 | Tulare | 107 | 844 | 992 | 1 | 147 |
22266 | 22266 | 2021-07-30 | Tuolumne | 109 | 51 | 79 | 0 | 13 |
22267 | 22267 | 2021-07-30 | Ventura | 111 | 875 | 993 | 1 | 82 |
22268 | 22268 | 2021-07-30 | Yolo | 113 | 220 | 275 | 2 | 39 |
22269 | 22269 | 2021-07-30 | Yuba | 115 | 44 | 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 );