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.
46 rows where "date" is on date 2020-07-29
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 |
---|---|---|---|---|---|---|---|---|
2234 | 2234 | 2020-07-29 | Alameda | 1 | 254 | 518 | 2 | 35 |
2235 | 2235 | 2020-07-29 | Amador | 5 | 1 | 19 | 0 | 0 |
2236 | 2236 | 2020-07-29 | Butte | 7 | 27 | 29 | 0 | 1 |
2237 | 2237 | 2020-07-29 | Calaveras | 9 | 1 | 0 | 0 | 0 |
2238 | 2238 | 2020-07-29 | Colusa | 11 | 40 | 29 | 0 | 1 |
2239 | 2239 | 2020-07-29 | Contra Costa | 13 | 119 | 241 | 4 | 41 |
2240 | 2240 | 2020-07-29 | El Dorado | 17 | 3 | 1 | 0 | 0 |
2241 | 2241 | 2020-07-29 | Fresno | 19 | 212 | 288 | 3 | 43 |
2242 | 2242 | 2020-07-29 | Glenn | 21 | 1 | 0 | 0 | 0 |
2243 | 2243 | 2020-07-29 | Humboldt | 23 | 1 | 1 | 1 | 1 |
2244 | 2244 | 2020-07-29 | Imperial | 25 | 95 | 68 | 1 | 18 |
2245 | 2245 | 2020-07-29 | Kern | 29 | 288 | 359 | 0 | 26 |
2246 | 2246 | 2020-07-29 | Kings | 31 | 77 | 90 | 0 | 23 |
2247 | 2247 | 2020-07-29 | Los Angeles | 37 | 5749 | 8970 | 47 | 1357 |
2248 | 2248 | 2020-07-29 | Madera | 39 | 49 | 87 | 0 | 1 |
2249 | 2249 | 2020-07-29 | Marin | 41 | 71 | 119 | 1 | 18 |
2250 | 2250 | 2020-07-29 | Mendocino | 45 | 3 | 16 | 1 | 2 |
2251 | 2251 | 2020-07-29 | Merced | 47 | 20 | 20 | 0 | 2 |
2252 | 2252 | 2020-07-29 | Monterey | 53 | 45 | 23 | 0 | 2 |
2253 | 2253 | 2020-07-29 | Napa | 55 | 4 | 37 | 0 | 1 |
2254 | 2254 | 2020-07-29 | Nevada | 57 | 2 | 0 | 0 | 0 |
2255 | 2255 | 2020-07-29 | Orange | 59 | 1016 | 1352 | 7 | 148 |
2256 | 2256 | 2020-07-29 | Placer | 61 | 9 | 5 | 0 | 2 |
2257 | 2257 | 2020-07-29 | Plumas | 63 | 1 | 0 | 0 | 0 |
2258 | 2258 | 2020-07-29 | Riverside | 65 | 813 | 1080 | 5 | 110 |
2259 | 2259 | 2020-07-29 | Sacramento | 67 | 94 | 82 | 1 | 6 |
2260 | 2260 | 2020-07-29 | San Benito | 69 | 2 | 1 | 1 | 1 |
2261 | 2261 | 2020-07-29 | San Bernardino | 71 | 788 | 1315 | 5 | 113 |
2262 | 2262 | 2020-07-29 | San Diego | 73 | 493 | 841 | 2 | 87 |
2263 | 2263 | 2020-07-29 | San Francisco | 75 | 134 | 124 | 1 | 14 |
2264 | 2264 | 2020-07-29 | San Joaquin | 77 | 356 | 386 | 1 | 29 |
2265 | 2265 | 2020-07-29 | San Luis Obispo | 79 | 21 | 16 | 0 | 1 |
2266 | 2266 | 2020-07-29 | San Mateo | 81 | 104 | 213 | 3 | 22 |
2267 | 2267 | 2020-07-29 | Santa Barbara | 83 | 70 | 87 | 1 | 3 |
2268 | 2268 | 2020-07-29 | Santa Clara | 85 | 245 | 287 | 1 | 24 |
2269 | 2269 | 2020-07-29 | Santa Cruz | 87 | 5 | 4 | 0 | 0 |
2270 | 2270 | 2020-07-29 | Shasta | 89 | 4 | 3 | 0 | 1 |
2271 | 2271 | 2020-07-29 | Solano | 95 | 39 | 99 | 0 | 11 |
2272 | 2272 | 2020-07-29 | Sonoma | 97 | 64 | 117 | 1 | 4 |
2273 | 2273 | 2020-07-29 | Stanislaus | 99 | 175 | 295 | 0 | 30 |
2274 | 2274 | 2020-07-29 | Sutter | 101 | 3 | 1 | 0 | 0 |
2275 | 2275 | 2020-07-29 | Tulare | 107 | 291 | 514 | 1 | 84 |
2276 | 2276 | 2020-07-29 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
2277 | 2277 | 2020-07-29 | Ventura | 111 | 164 | 93 | 0 | 4 |
2278 | 2278 | 2020-07-29 | Yolo | 113 | 18 | 52 | 1 | 16 |
2279 | 2279 | 2020-07-29 | 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 );