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.
38 rows where "date" is on date 2020-06-10
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: minimum_staff_confirmed_cases, minimum_patients_confirmed_cases, minimum_patients_deaths
Link | rowid ▼ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
186 | 186 | 2020-06-10 | Alameda | 1 | 141 | 288 | 0 | 28 |
187 | 187 | 2020-06-10 | Butte | 7 | 2 | 2 | 0 | 0 |
188 | 188 | 2020-06-10 | Contra Costa | 13 | 38 | 88 | 3 | 5 |
189 | 189 | 2020-06-10 | El Dorado | 17 | 1 | 0 | 0 | 0 |
190 | 190 | 2020-06-10 | Fresno | 19 | 44 | 119 | 3 | 32 |
191 | 191 | 2020-06-10 | Humboldt | 23 | 1 | 1 | 1 | 1 |
192 | 192 | 2020-06-10 | Imperial | 25 | 20 | 3 | 1 | 1 |
193 | 193 | 2020-06-10 | Kern | 29 | 84 | 114 | 0 | 20 |
194 | 194 | 2020-06-10 | Kings | 31 | 20 | 27 | 0 | 0 |
195 | 195 | 2020-06-10 | Los Angeles | 37 | 3342 | 6247 | 38 | 897 |
196 | 196 | 2020-06-10 | Madera | 39 | 1 | 1 | 0 | 0 |
197 | 197 | 2020-06-10 | Marin | 41 | 6 | 1 | 1 | 2 |
198 | 198 | 2020-06-10 | Mendocino | 45 | 1 | 1 | 1 | 1 |
199 | 199 | 2020-06-10 | Merced | 47 | 3 | 1 | 0 | 0 |
200 | 200 | 2020-06-10 | Monterey | 53 | 2 | 13 | 0 | 1 |
201 | 201 | 2020-06-10 | Napa | 55 | 1 | 0 | 0 | 0 |
202 | 202 | 2020-06-10 | Orange | 59 | 318 | 699 | 4 | 64 |
203 | 203 | 2020-06-10 | Placer | 61 | 2 | 1 | 0 | 1 |
204 | 204 | 2020-06-10 | Riverside | 65 | 358 | 583 | 2 | 76 |
205 | 205 | 2020-06-10 | Sacramento | 67 | 7 | 27 | 1 | 3 |
206 | 206 | 2020-06-10 | San Benito | 69 | 1 | 1 | 1 | 1 |
207 | 207 | 2020-06-10 | San Bernardino | 71 | 279 | 591 | 3 | 61 |
208 | 208 | 2020-06-10 | San Diego | 73 | 240 | 454 | 2 | 52 |
209 | 209 | 2020-06-10 | San Francisco | 75 | 55 | 74 | 1 | 3 |
210 | 210 | 2020-06-10 | San Joaquin | 77 | 42 | 81 | 1 | 4 |
211 | 211 | 2020-06-10 | San Luis Obispo | 79 | 2 | 1 | 0 | 0 |
212 | 212 | 2020-06-10 | San Mateo | 81 | 100 | 193 | 1 | 18 |
213 | 213 | 2020-06-10 | Santa Barbara | 83 | 22 | 30 | 0 | 1 |
214 | 214 | 2020-06-10 | Santa Clara | 85 | 144 | 230 | 1 | 19 |
215 | 215 | 2020-06-10 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
216 | 216 | 2020-06-10 | Shasta | 89 | 2 | 2 | 0 | 1 |
217 | 217 | 2020-06-10 | Solano | 95 | 35 | 98 | 0 | 11 |
218 | 218 | 2020-06-10 | Sonoma | 97 | 5 | 1 | 1 | 1 |
219 | 219 | 2020-06-10 | Stanislaus | 99 | 61 | 104 | 0 | 22 |
220 | 220 | 2020-06-10 | Sutter | 101 | 1 | 0 | 0 | 0 |
221 | 221 | 2020-06-10 | Tulare | 107 | 179 | 376 | 1 | 35 |
222 | 222 | 2020-06-10 | Ventura | 111 | 22 | 5 | 0 | 0 |
223 | 223 | 2020-06-10 | Yolo | 113 | 14 | 32 | 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 );