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-07
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 |
---|---|---|---|---|---|---|---|---|
1259 | 1259 | 2020-07-07 | Alameda | 1 | 201 | 424 | 1 | 31 |
1260 | 1260 | 2020-07-07 | Amador | 5 | 1 | 0 | 0 | 0 |
1261 | 1261 | 2020-07-07 | Butte | 7 | 3 | 2 | 0 | 0 |
1262 | 1262 | 2020-07-07 | Colusa | 11 | 1 | 0 | 0 | 0 |
1263 | 1263 | 2020-07-07 | Contra Costa | 13 | 90 | 207 | 4 | 25 |
1264 | 1264 | 2020-07-07 | El Dorado | 17 | 3 | 1 | 0 | 0 |
1265 | 1265 | 2020-07-07 | Fresno | 19 | 59 | 161 | 3 | 37 |
1266 | 1266 | 2020-07-07 | Humboldt | 23 | 1 | 1 | 1 | 1 |
1267 | 1267 | 2020-07-07 | Imperial | 25 | 88 | 63 | 1 | 2 |
1268 | 1268 | 2020-07-07 | Kern | 29 | 162 | 250 | 0 | 22 |
1269 | 1269 | 2020-07-07 | Kings | 31 | 56 | 70 | 0 | 16 |
1270 | 1270 | 2020-07-07 | Los Angeles | 37 | 4476 | 7803 | 46 | 1187 |
1271 | 1271 | 2020-07-07 | Madera | 39 | 2 | 1 | 0 | 0 |
1272 | 1272 | 2020-07-07 | Marin | 41 | 24 | 52 | 1 | 3 |
1273 | 1273 | 2020-07-07 | Mendocino | 45 | 2 | 1 | 1 | 1 |
1274 | 1274 | 2020-07-07 | Merced | 47 | 4 | 1 | 0 | 0 |
1275 | 1275 | 2020-07-07 | Monterey | 53 | 22 | 18 | 0 | 1 |
1276 | 1276 | 2020-07-07 | Napa | 55 | 3 | 2 | 0 | 0 |
1277 | 1277 | 2020-07-07 | Nevada | 57 | 1 | 0 | 0 | 0 |
1278 | 1278 | 2020-07-07 | Orange | 59 | 685 | 1007 | 7 | 122 |
1279 | 1279 | 2020-07-07 | Placer | 61 | 5 | 3 | 0 | 1 |
1280 | 1280 | 2020-07-07 | Riverside | 65 | 588 | 872 | 2 | 82 |
1281 | 1281 | 2020-07-07 | Sacramento | 67 | 18 | 46 | 1 | 4 |
1282 | 1282 | 2020-07-07 | San Benito | 69 | 1 | 1 | 1 | 1 |
1283 | 1283 | 2020-07-07 | San Bernardino | 71 | 422 | 837 | 4 | 69 |
1284 | 1284 | 2020-07-07 | San Diego | 73 | 295 | 700 | 2 | 61 |
1285 | 1285 | 2020-07-07 | San Francisco | 75 | 117 | 122 | 1 | 14 |
1286 | 1286 | 2020-07-07 | San Joaquin | 77 | 109 | 127 | 1 | 19 |
1287 | 1287 | 2020-07-07 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
1288 | 1288 | 2020-07-07 | San Mateo | 81 | 104 | 213 | 1 | 20 |
1289 | 1289 | 2020-07-07 | Santa Barbara | 83 | 32 | 34 | 1 | 3 |
1290 | 1290 | 2020-07-07 | Santa Clara | 85 | 160 | 252 | 1 | 21 |
1291 | 1291 | 2020-07-07 | Santa Cruz | 87 | 2 | 2 | 0 | 0 |
1292 | 1292 | 2020-07-07 | Shasta | 89 | 3 | 3 | 0 | 1 |
1293 | 1293 | 2020-07-07 | Solano | 95 | 36 | 98 | 0 | 11 |
1294 | 1294 | 2020-07-07 | Sonoma | 97 | 23 | 32 | 1 | 2 |
1295 | 1295 | 2020-07-07 | Stanislaus | 99 | 81 | 130 | 0 | 25 |
1296 | 1296 | 2020-07-07 | Sutter | 101 | 2 | 0 | 0 | 0 |
1297 | 1297 | 2020-07-07 | Tulare | 107 | 266 | 469 | 1 | 74 |
1298 | 1298 | 2020-07-07 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
1299 | 1299 | 2020-07-07 | Ventura | 111 | 83 | 46 | 0 | 1 |
1300 | 1300 | 2020-07-07 | 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 );