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-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_patients_deaths, date (date)
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
2280 | 2280 | 2020-07-30 | Alameda | 1 | 258 | 542 | 2 | 35 |
2281 | 2281 | 2020-07-30 | Amador | 5 | 1 | 19 | 0 | 0 |
2282 | 2282 | 2020-07-30 | Butte | 7 | 27 | 29 | 0 | 1 |
2283 | 2283 | 2020-07-30 | Calaveras | 9 | 1 | 0 | 0 | 0 |
2284 | 2284 | 2020-07-30 | Colusa | 11 | 40 | 29 | 0 | 1 |
2285 | 2285 | 2020-07-30 | Contra Costa | 13 | 133 | 245 | 4 | 42 |
2286 | 2286 | 2020-07-30 | El Dorado | 17 | 3 | 1 | 0 | 0 |
2287 | 2287 | 2020-07-30 | Fresno | 19 | 214 | 288 | 3 | 43 |
2288 | 2288 | 2020-07-30 | Glenn | 21 | 1 | 0 | 0 | 0 |
2289 | 2289 | 2020-07-30 | Humboldt | 23 | 1 | 1 | 1 | 1 |
2290 | 2290 | 2020-07-30 | Imperial | 25 | 95 | 68 | 1 | 18 |
2291 | 2291 | 2020-07-30 | Kern | 29 | 290 | 360 | 0 | 26 |
2292 | 2292 | 2020-07-30 | Kings | 31 | 77 | 90 | 0 | 23 |
2293 | 2293 | 2020-07-30 | Los Angeles | 37 | 5778 | 9005 | 47 | 1372 |
2294 | 2294 | 2020-07-30 | Madera | 39 | 50 | 88 | 0 | 1 |
2295 | 2295 | 2020-07-30 | Marin | 41 | 75 | 130 | 1 | 18 |
2296 | 2296 | 2020-07-30 | Mendocino | 45 | 3 | 18 | 1 | 2 |
2297 | 2297 | 2020-07-30 | Merced | 47 | 20 | 21 | 0 | 2 |
2298 | 2298 | 2020-07-30 | Monterey | 53 | 45 | 23 | 0 | 2 |
2299 | 2299 | 2020-07-30 | Napa | 55 | 4 | 39 | 0 | 1 |
2300 | 2300 | 2020-07-30 | Nevada | 57 | 3 | 0 | 0 | 0 |
2301 | 2301 | 2020-07-30 | Orange | 59 | 1035 | 1361 | 7 | 158 |
2302 | 2302 | 2020-07-30 | Placer | 61 | 9 | 5 | 0 | 2 |
2303 | 2303 | 2020-07-30 | Plumas | 63 | 1 | 0 | 0 | 0 |
2304 | 2304 | 2020-07-30 | Riverside | 65 | 820 | 1086 | 5 | 110 |
2305 | 2305 | 2020-07-30 | Sacramento | 67 | 103 | 86 | 1 | 6 |
2306 | 2306 | 2020-07-30 | San Benito | 69 | 2 | 1 | 1 | 2 |
2307 | 2307 | 2020-07-30 | San Bernardino | 71 | 807 | 1362 | 5 | 114 |
2308 | 2308 | 2020-07-30 | San Diego | 73 | 496 | 842 | 2 | 87 |
2309 | 2309 | 2020-07-30 | San Francisco | 75 | 134 | 125 | 1 | 14 |
2310 | 2310 | 2020-07-30 | San Joaquin | 77 | 370 | 425 | 1 | 29 |
2311 | 2311 | 2020-07-30 | San Luis Obispo | 79 | 21 | 16 | 0 | 1 |
2312 | 2312 | 2020-07-30 | San Mateo | 81 | 104 | 213 | 3 | 23 |
2313 | 2313 | 2020-07-30 | Santa Barbara | 83 | 81 | 89 | 1 | 3 |
2314 | 2314 | 2020-07-30 | Santa Clara | 85 | 246 | 287 | 1 | 24 |
2315 | 2315 | 2020-07-30 | Santa Cruz | 87 | 5 | 4 | 0 | 0 |
2316 | 2316 | 2020-07-30 | Shasta | 89 | 4 | 3 | 0 | 1 |
2317 | 2317 | 2020-07-30 | Solano | 95 | 39 | 99 | 0 | 11 |
2318 | 2318 | 2020-07-30 | Sonoma | 97 | 69 | 132 | 1 | 4 |
2319 | 2319 | 2020-07-30 | Stanislaus | 99 | 188 | 309 | 0 | 31 |
2320 | 2320 | 2020-07-30 | Sutter | 101 | 3 | 1 | 0 | 0 |
2321 | 2321 | 2020-07-30 | Tulare | 107 | 294 | 514 | 1 | 84 |
2322 | 2322 | 2020-07-30 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
2323 | 2323 | 2020-07-30 | Ventura | 111 | 179 | 94 | 1 | 4 |
2324 | 2324 | 2020-07-30 | Yolo | 113 | 18 | 52 | 1 | 16 |
2325 | 2325 | 2020-07-30 | 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 );