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-07-09
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 |
---|---|---|---|---|---|---|---|---|
21038 | 21038 | 2021-07-09 | Alameda | 1 | 1718 | 2433 | 5 | 145 |
21039 | 21039 | 2021-07-09 | Amador | 5 | 29 | 61 | 0 | 17 |
21040 | 21040 | 2021-07-09 | Butte | 7 | 336 | 476 | 0 | 43 |
21041 | 21041 | 2021-07-09 | Calaveras | 9 | 24 | 58 | 0 | 1 |
21042 | 21042 | 2021-07-09 | Colusa | 11 | 75 | 58 | 0 | 2 |
21043 | 21043 | 2021-07-09 | Contra Costa | 13 | 664 | 1072 | 5 | 101 |
21044 | 21044 | 2021-07-09 | Del Norte | 15 | 23 | 1 | 0 | 0 |
21045 | 21045 | 2021-07-09 | El Dorado | 17 | 205 | 188 | 0 | 33 |
21046 | 21046 | 2021-07-09 | Fresno | 19 | 1462 | 1540 | 3 | 177 |
21047 | 21047 | 2021-07-09 | Glenn | 21 | 40 | 43 | 0 | 1 |
21048 | 21048 | 2021-07-09 | Humboldt | 23 | 33 | 60 | 1 | 3 |
21049 | 21049 | 2021-07-09 | Imperial | 25 | 136 | 117 | 1 | 22 |
21050 | 21050 | 2021-07-09 | Inyo | 27 | 44 | 60 | 0 | 13 |
21051 | 21051 | 2021-07-09 | Kern | 29 | 1118 | 1134 | 1 | 75 |
21052 | 21052 | 2021-07-09 | Kings | 31 | 188 | 168 | 0 | 25 |
21053 | 21053 | 2021-07-09 | Lake | 33 | 89 | 112 | 0 | 13 |
21054 | 21054 | 2021-07-09 | Lassen | 35 | 15 | 33 | 0 | 1 |
21055 | 21055 | 2021-07-09 | Los Angeles | 37 | 17943 | 21031 | 100 | 3107 |
21056 | 21056 | 2021-07-09 | Madera | 39 | 214 | 294 | 0 | 25 |
21057 | 21057 | 2021-07-09 | Marin | 41 | 236 | 311 | 2 | 42 |
21058 | 21058 | 2021-07-09 | Mariposa | 43 | 1 | 0 | 0 | 0 |
21059 | 21059 | 2021-07-09 | Mendocino | 45 | 36 | 41 | 1 | 3 |
21060 | 21060 | 2021-07-09 | Merced | 47 | 239 | 247 | 1 | 6 |
21061 | 21061 | 2021-07-09 | Modoc | 49 | 50 | 47 | 0 | 2 |
21062 | 21062 | 2021-07-09 | Monterey | 53 | 453 | 547 | 0 | 55 |
21063 | 21063 | 2021-07-09 | Napa | 55 | 172 | 146 | 0 | 15 |
21064 | 21064 | 2021-07-09 | Nevada | 57 | 153 | 194 | 0 | 46 |
21065 | 21065 | 2021-07-09 | Orange | 59 | 3674 | 4342 | 14 | 580 |
21066 | 21066 | 2021-07-09 | Placer | 61 | 367 | 466 | 0 | 36 |
21067 | 21067 | 2021-07-09 | Plumas | 63 | 2 | 1 | 0 | 1 |
21068 | 21068 | 2021-07-09 | Riverside | 65 | 2520 | 3053 | 6 | 216 |
21069 | 21069 | 2021-07-09 | Sacramento | 67 | 1782 | 2347 | 4 | 150 |
21070 | 21070 | 2021-07-09 | San Benito | 69 | 32 | 2 | 1 | 2 |
21071 | 21071 | 2021-07-09 | San Bernardino | 71 | 2694 | 3329 | 8 | 281 |
21072 | 21072 | 2021-07-09 | San Diego | 73 | 3757 | 4461 | 7 | 327 |
21073 | 21073 | 2021-07-09 | San Francisco | 75 | 595 | 625 | 2 | 34 |
21074 | 21074 | 2021-07-09 | San Joaquin | 77 | 1438 | 1847 | 3 | 198 |
21075 | 21075 | 2021-07-09 | San Luis Obispo | 79 | 254 | 310 | 0 | 35 |
21076 | 21076 | 2021-07-09 | San Mateo | 81 | 437 | 828 | 3 | 107 |
21077 | 21077 | 2021-07-09 | Santa Barbara | 83 | 452 | 458 | 2 | 25 |
21078 | 21078 | 2021-07-09 | Santa Clara | 85 | 1993 | 2598 | 5 | 209 |
21079 | 21079 | 2021-07-09 | Santa Cruz | 87 | 239 | 460 | 0 | 66 |
21080 | 21080 | 2021-07-09 | Shasta | 89 | 438 | 418 | 0 | 58 |
21081 | 21081 | 2021-07-09 | Sierra | 91 | 1 | 0 | 0 | 0 |
21082 | 21082 | 2021-07-09 | Siskiyou | 93 | 1 | 1 | 1 | 0 |
21083 | 21083 | 2021-07-09 | Solano | 95 | 200 | 274 | 0 | 17 |
21084 | 21084 | 2021-07-09 | Sonoma | 97 | 542 | 634 | 2 | 25 |
21085 | 21085 | 2021-07-09 | Stanislaus | 99 | 1215 | 1521 | 1 | 143 |
21086 | 21086 | 2021-07-09 | Sutter | 101 | 235 | 264 | 0 | 15 |
21087 | 21087 | 2021-07-09 | Tehama | 103 | 20 | 43 | 0 | 11 |
21088 | 21088 | 2021-07-09 | Trinity | 105 | 11 | 1 | 0 | 1 |
21089 | 21089 | 2021-07-09 | Tulare | 107 | 841 | 990 | 1 | 147 |
21090 | 21090 | 2021-07-09 | Tuolumne | 109 | 51 | 79 | 0 | 13 |
21091 | 21091 | 2021-07-09 | Ventura | 111 | 871 | 993 | 1 | 82 |
21092 | 21092 | 2021-07-09 | Yolo | 113 | 215 | 274 | 2 | 39 |
21093 | 21093 | 2021-07-09 | Yuba | 115 | 40 | 51 | 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 );