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-09-10
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_deaths, date (date)
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
24566 | 24566 | 2021-09-10 | Alameda | 1 | 1783 | 2451 | 5 | 146 |
24567 | 24567 | 2021-09-10 | Amador | 5 | 34 | 67 | 0 | 17 |
24568 | 24568 | 2021-09-10 | Butte | 7 | 367 | 504 | 0 | 49 |
24569 | 24569 | 2021-09-10 | Calaveras | 9 | 25 | 58 | 0 | 1 |
24570 | 24570 | 2021-09-10 | Colusa | 11 | 79 | 58 | 0 | 2 |
24571 | 24571 | 2021-09-10 | Contra Costa | 13 | 725 | 1111 | 5 | 102 |
24572 | 24572 | 2021-09-10 | Del Norte | 15 | 40 | 1 | 0 | 0 |
24573 | 24573 | 2021-09-10 | El Dorado | 17 | 228 | 210 | 0 | 33 |
24574 | 24574 | 2021-09-10 | Fresno | 19 | 1568 | 1599 | 3 | 179 |
24575 | 24575 | 2021-09-10 | Glenn | 21 | 43 | 43 | 0 | 1 |
24576 | 24576 | 2021-09-10 | Humboldt | 23 | 37 | 62 | 1 | 3 |
24577 | 24577 | 2021-09-10 | Imperial | 25 | 137 | 117 | 1 | 22 |
24578 | 24578 | 2021-09-10 | Inyo | 27 | 44 | 60 | 0 | 13 |
24579 | 24579 | 2021-09-10 | Kern | 29 | 1180 | 1208 | 1 | 75 |
24580 | 24580 | 2021-09-10 | Kings | 31 | 209 | 173 | 0 | 25 |
24581 | 24581 | 2021-09-10 | Lake | 33 | 103 | 110 | 1 | 13 |
24582 | 24582 | 2021-09-10 | Lassen | 35 | 17 | 33 | 1 | 1 |
24583 | 24583 | 2021-09-10 | Los Angeles | 37 | 18486 | 21310 | 103 | 3118 |
24584 | 24584 | 2021-09-10 | Madera | 39 | 219 | 294 | 0 | 25 |
24585 | 24585 | 2021-09-10 | Marin | 41 | 239 | 316 | 2 | 42 |
24586 | 24586 | 2021-09-10 | Mariposa | 43 | 1 | 0 | 0 | 0 |
24587 | 24587 | 2021-09-10 | Mendocino | 45 | 62 | 56 | 1 | 3 |
24588 | 24588 | 2021-09-10 | Merced | 47 | 255 | 261 | 1 | 6 |
24589 | 24589 | 2021-09-10 | Modoc | 49 | 52 | 47 | 0 | 2 |
24590 | 24590 | 2021-09-10 | Monterey | 53 | 466 | 550 | 0 | 55 |
24591 | 24591 | 2021-09-10 | Napa | 55 | 192 | 175 | 0 | 15 |
24592 | 24592 | 2021-09-10 | Nevada | 57 | 192 | 217 | 0 | 46 |
24593 | 24593 | 2021-09-10 | Orange | 59 | 3780 | 4411 | 14 | 589 |
24594 | 24594 | 2021-09-10 | Placer | 61 | 409 | 501 | 0 | 36 |
24595 | 24595 | 2021-09-10 | Plumas | 63 | 12 | 1 | 0 | 1 |
24596 | 24596 | 2021-09-10 | Riverside | 65 | 2636 | 3182 | 6 | 219 |
24597 | 24597 | 2021-09-10 | Sacramento | 67 | 1910 | 2462 | 4 | 163 |
24598 | 24598 | 2021-09-10 | San Benito | 69 | 33 | 2 | 1 | 2 |
24599 | 24599 | 2021-09-10 | San Bernardino | 71 | 2804 | 3425 | 8 | 294 |
24600 | 24600 | 2021-09-10 | San Diego | 73 | 4031 | 4658 | 8 | 333 |
24601 | 24601 | 2021-09-10 | San Francisco | 75 | 657 | 683 | 2 | 34 |
24602 | 24602 | 2021-09-10 | San Joaquin | 77 | 1495 | 1888 | 3 | 199 |
24603 | 24603 | 2021-09-10 | San Luis Obispo | 79 | 273 | 324 | 0 | 36 |
24604 | 24604 | 2021-09-10 | San Mateo | 81 | 484 | 834 | 3 | 107 |
24605 | 24605 | 2021-09-10 | Santa Barbara | 83 | 475 | 464 | 2 | 25 |
24606 | 24606 | 2021-09-10 | Santa Clara | 85 | 2055 | 2652 | 5 | 210 |
24607 | 24607 | 2021-09-10 | Santa Cruz | 87 | 247 | 460 | 0 | 66 |
24608 | 24608 | 2021-09-10 | Shasta | 89 | 549 | 451 | 0 | 59 |
24609 | 24609 | 2021-09-10 | Sierra | 91 | 1 | 0 | 0 | 0 |
24610 | 24610 | 2021-09-10 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
24611 | 24611 | 2021-09-10 | Solano | 95 | 218 | 304 | 0 | 18 |
24612 | 24612 | 2021-09-10 | Sonoma | 97 | 582 | 693 | 2 | 26 |
24613 | 24613 | 2021-09-10 | Stanislaus | 99 | 1269 | 1539 | 1 | 143 |
24614 | 24614 | 2021-09-10 | Sutter | 101 | 251 | 297 | 0 | 15 |
24615 | 24615 | 2021-09-10 | Tehama | 103 | 28 | 56 | 0 | 11 |
24616 | 24616 | 2021-09-10 | Trinity | 105 | 15 | 1 | 0 | 1 |
24617 | 24617 | 2021-09-10 | Tulare | 107 | 917 | 1019 | 1 | 147 |
24618 | 24618 | 2021-09-10 | Tuolumne | 109 | 65 | 90 | 0 | 15 |
24619 | 24619 | 2021-09-10 | Ventura | 111 | 897 | 1000 | 1 | 82 |
24620 | 24620 | 2021-09-10 | Yolo | 113 | 246 | 282 | 2 | 39 |
24621 | 24621 | 2021-09-10 | Yuba | 115 | 47 | 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 );