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-08-26
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 |
---|---|---|---|---|---|---|---|---|
23726 | 23726 | 2021-08-26 | Alameda | 1 | 1774 | 2445 | 5 | 146 |
23727 | 23727 | 2021-08-26 | Amador | 5 | 33 | 67 | 0 | 17 |
23728 | 23728 | 2021-08-26 | Butte | 7 | 360 | 496 | 0 | 44 |
23729 | 23729 | 2021-08-26 | Calaveras | 9 | 25 | 58 | 0 | 1 |
23730 | 23730 | 2021-08-26 | Colusa | 11 | 79 | 58 | 0 | 2 |
23731 | 23731 | 2021-08-26 | Contra Costa | 13 | 715 | 1103 | 5 | 101 |
23732 | 23732 | 2021-08-26 | Del Norte | 15 | 38 | 1 | 0 | 0 |
23733 | 23733 | 2021-08-26 | El Dorado | 17 | 223 | 206 | 0 | 33 |
23734 | 23734 | 2021-08-26 | Fresno | 19 | 1540 | 1581 | 3 | 178 |
23735 | 23735 | 2021-08-26 | Glenn | 21 | 41 | 43 | 0 | 1 |
23736 | 23736 | 2021-08-26 | Humboldt | 23 | 36 | 62 | 1 | 3 |
23737 | 23737 | 2021-08-26 | Imperial | 25 | 137 | 117 | 1 | 22 |
23738 | 23738 | 2021-08-26 | Inyo | 27 | 44 | 60 | 0 | 13 |
23739 | 23739 | 2021-08-26 | Kern | 29 | 1155 | 1164 | 1 | 75 |
23740 | 23740 | 2021-08-26 | Kings | 31 | 208 | 171 | 0 | 25 |
23741 | 23741 | 2021-08-26 | Lake | 33 | 100 | 110 | 1 | 13 |
23742 | 23742 | 2021-08-26 | Lassen | 35 | 17 | 33 | 0 | 1 |
23743 | 23743 | 2021-08-26 | Los Angeles | 37 | 18380 | 21251 | 103 | 3113 |
23744 | 23744 | 2021-08-26 | Madera | 39 | 218 | 294 | 0 | 25 |
23745 | 23745 | 2021-08-26 | Marin | 41 | 238 | 316 | 2 | 42 |
23746 | 23746 | 2021-08-26 | Mariposa | 43 | 1 | 0 | 0 | 0 |
23747 | 23747 | 2021-08-26 | Mendocino | 45 | 54 | 41 | 1 | 3 |
23748 | 23748 | 2021-08-26 | Merced | 47 | 251 | 254 | 1 | 6 |
23749 | 23749 | 2021-08-26 | Modoc | 49 | 50 | 47 | 0 | 2 |
23750 | 23750 | 2021-08-26 | Monterey | 53 | 462 | 547 | 0 | 55 |
23751 | 23751 | 2021-08-26 | Napa | 55 | 187 | 170 | 0 | 15 |
23752 | 23752 | 2021-08-26 | Nevada | 57 | 185 | 217 | 0 | 46 |
23753 | 23753 | 2021-08-26 | Orange | 59 | 3762 | 4406 | 14 | 585 |
23754 | 23754 | 2021-08-26 | Placer | 61 | 395 | 499 | 0 | 36 |
23755 | 23755 | 2021-08-26 | Plumas | 63 | 2 | 1 | 0 | 1 |
23756 | 23756 | 2021-08-26 | Riverside | 65 | 2617 | 3160 | 6 | 219 |
23757 | 23757 | 2021-08-26 | Sacramento | 67 | 1886 | 2436 | 4 | 162 |
23758 | 23758 | 2021-08-26 | San Benito | 69 | 33 | 2 | 1 | 2 |
23759 | 23759 | 2021-08-26 | San Bernardino | 71 | 2770 | 3384 | 8 | 292 |
23760 | 23760 | 2021-08-26 | San Diego | 73 | 3954 | 4566 | 8 | 332 |
23761 | 23761 | 2021-08-26 | San Francisco | 75 | 644 | 681 | 2 | 34 |
23762 | 23762 | 2021-08-26 | San Joaquin | 77 | 1478 | 1867 | 3 | 198 |
23763 | 23763 | 2021-08-26 | San Luis Obispo | 79 | 272 | 324 | 0 | 36 |
23764 | 23764 | 2021-08-26 | San Mateo | 81 | 462 | 830 | 3 | 107 |
23765 | 23765 | 2021-08-26 | Santa Barbara | 83 | 467 | 463 | 2 | 25 |
23766 | 23766 | 2021-08-26 | Santa Clara | 85 | 2034 | 2647 | 5 | 209 |
23767 | 23767 | 2021-08-26 | Santa Cruz | 87 | 244 | 460 | 0 | 66 |
23768 | 23768 | 2021-08-26 | Shasta | 89 | 508 | 433 | 0 | 58 |
23769 | 23769 | 2021-08-26 | Sierra | 91 | 1 | 0 | 0 | 0 |
23770 | 23770 | 2021-08-26 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
23771 | 23771 | 2021-08-26 | Solano | 95 | 217 | 300 | 0 | 18 |
23772 | 23772 | 2021-08-26 | Sonoma | 97 | 567 | 670 | 2 | 26 |
23773 | 23773 | 2021-08-26 | Stanislaus | 99 | 1254 | 1529 | 1 | 143 |
23774 | 23774 | 2021-08-26 | Sutter | 101 | 248 | 273 | 0 | 15 |
23775 | 23775 | 2021-08-26 | Tehama | 103 | 21 | 43 | 0 | 11 |
23776 | 23776 | 2021-08-26 | Trinity | 105 | 14 | 1 | 0 | 1 |
23777 | 23777 | 2021-08-26 | Tulare | 107 | 878 | 1014 | 1 | 147 |
23778 | 23778 | 2021-08-26 | Tuolumne | 109 | 61 | 88 | 0 | 15 |
23779 | 23779 | 2021-08-26 | Ventura | 111 | 884 | 994 | 1 | 82 |
23780 | 23780 | 2021-08-26 | Yolo | 113 | 243 | 278 | 2 | 39 |
23781 | 23781 | 2021-08-26 | 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 );