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.
42 rows where "date" is on date 2020-07-06
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_confirmed_cases, minimum_staff_deaths, date (date)
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
1217 | 1217 | 2020-07-06 | Alameda | 1 | 201 | 414 | 1 | 31 |
1218 | 1218 | 2020-07-06 | Amador | 5 | 1 | 0 | 0 | 0 |
1219 | 1219 | 2020-07-06 | Butte | 7 | 3 | 2 | 0 | 0 |
1220 | 1220 | 2020-07-06 | Colusa | 11 | 1 | 0 | 0 | 0 |
1221 | 1221 | 2020-07-06 | Contra Costa | 13 | 90 | 202 | 4 | 25 |
1222 | 1222 | 2020-07-06 | El Dorado | 17 | 2 | 1 | 0 | 0 |
1223 | 1223 | 2020-07-06 | Fresno | 19 | 59 | 161 | 3 | 37 |
1224 | 1224 | 2020-07-06 | Humboldt | 23 | 1 | 1 | 1 | 1 |
1225 | 1225 | 2020-07-06 | Imperial | 25 | 87 | 59 | 1 | 2 |
1226 | 1226 | 2020-07-06 | Kern | 29 | 162 | 249 | 0 | 22 |
1227 | 1227 | 2020-07-06 | Kings | 31 | 55 | 70 | 0 | 16 |
1228 | 1228 | 2020-07-06 | Los Angeles | 37 | 4441 | 7756 | 46 | 1173 |
1229 | 1229 | 2020-07-06 | Madera | 39 | 2 | 1 | 0 | 0 |
1230 | 1230 | 2020-07-06 | Marin | 41 | 24 | 52 | 1 | 2 |
1231 | 1231 | 2020-07-06 | Mendocino | 45 | 1 | 1 | 1 | 1 |
1232 | 1232 | 2020-07-06 | Merced | 47 | 3 | 1 | 0 | 0 |
1233 | 1233 | 2020-07-06 | Monterey | 53 | 22 | 18 | 0 | 1 |
1234 | 1234 | 2020-07-06 | Napa | 55 | 3 | 1 | 0 | 0 |
1235 | 1235 | 2020-07-06 | Nevada | 57 | 1 | 0 | 0 | 0 |
1236 | 1236 | 2020-07-06 | Orange | 59 | 671 | 980 | 7 | 119 |
1237 | 1237 | 2020-07-06 | Placer | 61 | 5 | 3 | 0 | 1 |
1238 | 1238 | 2020-07-06 | Riverside | 65 | 582 | 864 | 2 | 82 |
1239 | 1239 | 2020-07-06 | Sacramento | 67 | 18 | 45 | 1 | 3 |
1240 | 1240 | 2020-07-06 | San Benito | 69 | 1 | 1 | 1 | 1 |
1241 | 1241 | 2020-07-06 | San Bernardino | 71 | 414 | 832 | 4 | 69 |
1242 | 1242 | 2020-07-06 | San Diego | 73 | 295 | 699 | 2 | 61 |
1243 | 1243 | 2020-07-06 | San Francisco | 75 | 117 | 122 | 1 | 14 |
1244 | 1244 | 2020-07-06 | San Joaquin | 77 | 99 | 127 | 1 | 19 |
1245 | 1245 | 2020-07-06 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
1246 | 1246 | 2020-07-06 | San Mateo | 81 | 104 | 213 | 1 | 20 |
1247 | 1247 | 2020-07-06 | Santa Barbara | 83 | 32 | 34 | 1 | 3 |
1248 | 1248 | 2020-07-06 | Santa Clara | 85 | 160 | 251 | 1 | 21 |
1249 | 1249 | 2020-07-06 | Santa Cruz | 87 | 1 | 1 | 0 | 0 |
1250 | 1250 | 2020-07-06 | Shasta | 89 | 3 | 3 | 0 | 1 |
1251 | 1251 | 2020-07-06 | Solano | 95 | 36 | 98 | 0 | 11 |
1252 | 1252 | 2020-07-06 | Sonoma | 97 | 22 | 32 | 1 | 2 |
1253 | 1253 | 2020-07-06 | Stanislaus | 99 | 79 | 130 | 0 | 25 |
1254 | 1254 | 2020-07-06 | Sutter | 101 | 2 | 0 | 0 | 0 |
1255 | 1255 | 2020-07-06 | Tulare | 107 | 264 | 469 | 1 | 74 |
1256 | 1256 | 2020-07-06 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
1257 | 1257 | 2020-07-06 | Ventura | 111 | 83 | 46 | 0 | 1 |
1258 | 1258 | 2020-07-06 | Yolo | 113 | 16 | 35 | 1 | 15 |
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 );