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-31
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_deaths
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
24006 | 24006 | 2021-08-31 | Alameda | 1 | 1778 | 2448 | 6 | 147 |
24007 | 24007 | 2021-08-31 | Amador | 5 | 34 | 67 | 0 | 17 |
24008 | 24008 | 2021-08-31 | Butte | 7 | 365 | 496 | 0 | 45 |
24009 | 24009 | 2021-08-31 | Calaveras | 9 | 25 | 58 | 0 | 1 |
24010 | 24010 | 2021-08-31 | Colusa | 11 | 79 | 58 | 0 | 2 |
24011 | 24011 | 2021-08-31 | Contra Costa | 13 | 723 | 1108 | 5 | 101 |
24012 | 24012 | 2021-08-31 | Del Norte | 15 | 40 | 1 | 0 | 0 |
24013 | 24013 | 2021-08-31 | El Dorado | 17 | 226 | 206 | 0 | 33 |
24014 | 24014 | 2021-08-31 | Fresno | 19 | 1547 | 1585 | 3 | 179 |
24015 | 24015 | 2021-08-31 | Glenn | 21 | 41 | 43 | 0 | 1 |
24016 | 24016 | 2021-08-31 | Humboldt | 23 | 36 | 62 | 1 | 3 |
24017 | 24017 | 2021-08-31 | Imperial | 25 | 137 | 117 | 1 | 22 |
24018 | 24018 | 2021-08-31 | Inyo | 27 | 44 | 60 | 0 | 13 |
24019 | 24019 | 2021-08-31 | Kern | 29 | 1161 | 1169 | 1 | 75 |
24020 | 24020 | 2021-08-31 | Kings | 31 | 208 | 173 | 0 | 25 |
24021 | 24021 | 2021-08-31 | Lake | 33 | 101 | 110 | 1 | 13 |
24022 | 24022 | 2021-08-31 | Lassen | 35 | 17 | 33 | 1 | 1 |
24023 | 24023 | 2021-08-31 | Los Angeles | 37 | 18414 | 21275 | 103 | 3113 |
24024 | 24024 | 2021-08-31 | Madera | 39 | 218 | 294 | 0 | 25 |
24025 | 24025 | 2021-08-31 | Marin | 41 | 239 | 316 | 2 | 42 |
24026 | 24026 | 2021-08-31 | Mariposa | 43 | 1 | 0 | 0 | 0 |
24027 | 24027 | 2021-08-31 | Mendocino | 45 | 60 | 41 | 1 | 3 |
24028 | 24028 | 2021-08-31 | Merced | 47 | 252 | 255 | 1 | 6 |
24029 | 24029 | 2021-08-31 | Modoc | 49 | 50 | 47 | 0 | 2 |
24030 | 24030 | 2021-08-31 | Monterey | 53 | 463 | 548 | 0 | 55 |
24031 | 24031 | 2021-08-31 | Napa | 55 | 188 | 171 | 0 | 15 |
24032 | 24032 | 2021-08-31 | Nevada | 57 | 188 | 217 | 0 | 46 |
24033 | 24033 | 2021-08-31 | Orange | 59 | 3768 | 4406 | 14 | 587 |
24034 | 24034 | 2021-08-31 | Placer | 61 | 404 | 500 | 0 | 36 |
24035 | 24035 | 2021-08-31 | Plumas | 63 | 2 | 1 | 0 | 1 |
24036 | 24036 | 2021-08-31 | Riverside | 65 | 2626 | 3167 | 6 | 219 |
24037 | 24037 | 2021-08-31 | Sacramento | 67 | 1889 | 2445 | 4 | 163 |
24038 | 24038 | 2021-08-31 | San Benito | 69 | 33 | 2 | 1 | 2 |
24039 | 24039 | 2021-08-31 | San Bernardino | 71 | 2778 | 3389 | 8 | 293 |
24040 | 24040 | 2021-08-31 | San Diego | 73 | 3978 | 4592 | 8 | 333 |
24041 | 24041 | 2021-08-31 | San Francisco | 75 | 653 | 683 | 2 | 34 |
24042 | 24042 | 2021-08-31 | San Joaquin | 77 | 1485 | 1869 | 3 | 198 |
24043 | 24043 | 2021-08-31 | San Luis Obispo | 79 | 273 | 324 | 0 | 36 |
24044 | 24044 | 2021-08-31 | San Mateo | 81 | 479 | 833 | 3 | 107 |
24045 | 24045 | 2021-08-31 | Santa Barbara | 83 | 471 | 463 | 2 | 25 |
24046 | 24046 | 2021-08-31 | Santa Clara | 85 | 2048 | 2650 | 5 | 209 |
24047 | 24047 | 2021-08-31 | Santa Cruz | 87 | 245 | 460 | 0 | 66 |
24048 | 24048 | 2021-08-31 | Shasta | 89 | 523 | 445 | 0 | 58 |
24049 | 24049 | 2021-08-31 | Sierra | 91 | 1 | 0 | 0 | 0 |
24050 | 24050 | 2021-08-31 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
24051 | 24051 | 2021-08-31 | Solano | 95 | 217 | 302 | 0 | 18 |
24052 | 24052 | 2021-08-31 | Sonoma | 97 | 569 | 681 | 2 | 26 |
24053 | 24053 | 2021-08-31 | Stanislaus | 99 | 1263 | 1532 | 1 | 143 |
24054 | 24054 | 2021-08-31 | Sutter | 101 | 250 | 284 | 0 | 15 |
24055 | 24055 | 2021-08-31 | Tehama | 103 | 21 | 43 | 0 | 11 |
24056 | 24056 | 2021-08-31 | Trinity | 105 | 14 | 1 | 0 | 1 |
24057 | 24057 | 2021-08-31 | Tulare | 107 | 888 | 1014 | 1 | 147 |
24058 | 24058 | 2021-08-31 | Tuolumne | 109 | 61 | 90 | 0 | 15 |
24059 | 24059 | 2021-08-31 | Ventura | 111 | 888 | 994 | 1 | 82 |
24060 | 24060 | 2021-08-31 | Yolo | 113 | 245 | 281 | 2 | 39 |
24061 | 24061 | 2021-08-31 | 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 );