cdph-hospital-patient-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
56 rows where "date" is on date 2020-05-27
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
52977 | 52977 | 2020-05-27 | Alameda | 1 | 95 | 69 | 37 | 10 | 128 |
52978 | 52978 | 2020-05-27 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
52979 | 52979 | 2020-05-27 | Butte | 7 | 6 | 1 | 3 | 0 | 21 |
52980 | 52980 | 2020-05-27 | Calaveras | 9 | 0 | 0 | 0 | 0 | 11 |
52981 | 52981 | 2020-05-27 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
52982 | 52982 | 2020-05-27 | Contra Costa | 13 | 11 | 30 | 7 | 6 | 115 |
52983 | 52983 | 2020-05-27 | Del Norte | 15 | 0 | 0 | 0 | 0 | 4 |
52984 | 52984 | 2020-05-27 | El Dorado | 17 | 1 | 2 | 1 | 2 | 7 |
52985 | 52985 | 2020-05-27 | Fresno | 19 | 71 | 44 | 19 | 4 | 93 |
52986 | 52986 | 2020-05-27 | Glenn | 21 | 0 | 0 | 0 | 0 | |
52987 | 52987 | 2020-05-27 | Humboldt | 23 | 5 | 4 | 1 | 0 | 3 |
52988 | 52988 | 2020-05-27 | Imperial | 25 | 67 | 17 | 14 | 0 | 13 |
52989 | 52989 | 2020-05-27 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
52990 | 52990 | 2020-05-27 | Kern | 29 | 63 | 5 | 28 | 0 | 72 |
52991 | 52991 | 2020-05-27 | Kings | 31 | 23 | 1 | 7 | 0 | 0 |
52992 | 52992 | 2020-05-27 | Lake | 33 | 0 | 0 | 0 | 0 | 0 |
52993 | 52993 | 2020-05-27 | Lassen | 35 | 0 | 1 | 0 | 0 | |
52994 | 52994 | 2020-05-27 | Los Angeles | 37 | 1462 | 628 | 464 | 90 | 1275 |
52995 | 52995 | 2020-05-27 | Madera | 39 | 2 | 2 | 0 | 0 | 24 |
52996 | 52996 | 2020-05-27 | Marin | 41 | 1 | 1 | 1 | 0 | 10 |
52997 | 52997 | 2020-05-27 | Mariposa | 43 | 0 | 2 | 0 | 0 | |
52998 | 52998 | 2020-05-27 | Mendocino | 45 | 3 | 1 | 1 | 1 | 3 |
52999 | 52999 | 2020-05-27 | Merced | 47 | 6 | 2 | 4 | 0 | 3 |
53000 | 53000 | 2020-05-27 | Modoc | 49 | 0 | 0 | 0 | 0 | |
53001 | 53001 | 2020-05-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
53002 | 53002 | 2020-05-27 | Monterey | 53 | 11 | 0 | 3 | 0 | 100 |
53003 | 53003 | 2020-05-27 | Napa | 55 | 1 | 1 | 1 | 0 | 2 |
53004 | 53004 | 2020-05-27 | Nevada | 57 | 1 | 3 | 1 | 2 | 6 |
53005 | 53005 | 2020-05-27 | Orange | 59 | 307 | 111 | 125 | 19 | 403 |
53006 | 53006 | 2020-05-27 | Placer | 61 | 6 | 14 | 3 | 1 | 45 |
53007 | 53007 | 2020-05-27 | Plumas | 63 | 0 | 0 | 0 | 0 | |
53008 | 53008 | 2020-05-27 | Riverside | 65 | 199 | 114 | 66 | 21 | 131 |
53009 | 53009 | 2020-05-27 | Sacramento | 67 | 8 | 21 | 6 | 3 | 87 |
53010 | 53010 | 2020-05-27 | San Benito | 69 | 1 | 0 | 0 | 0 | 1 |
53011 | 53011 | 2020-05-27 | San Bernardino | 71 | 159 | 101 | 54 | 19 | 222 |
53012 | 53012 | 2020-05-27 | San Diego | 73 | 329 | 79 | 144 | 12 | 315 |
53013 | 53013 | 2020-05-27 | San Francisco | 75 | 40 | 42 | 18 | 9 | 98 |
53014 | 53014 | 2020-05-27 | San Joaquin | 77 | 14 | 23 | 7 | 4 | 21 |
53015 | 53015 | 2020-05-27 | San Luis Obispo | 79 | 2 | 4 | 2 | 1 | 22 |
53016 | 53016 | 2020-05-27 | San Mateo | 81 | 33 | 8 | 16 | 3 | 46 |
53017 | 53017 | 2020-05-27 | Santa Barbara | 83 | 22 | 5 | 9 | 2 | 94 |
53018 | 53018 | 2020-05-27 | Santa Clara | 85 | 28 | 24 | 12 | 3 | 188 |
53019 | 53019 | 2020-05-27 | Santa Cruz | 87 | 3 | 0 | 1 | 0 | 15 |
53020 | 53020 | 2020-05-27 | Shasta | 89 | 0 | 0 | 0 | 0 | 15 |
53021 | 53021 | 2020-05-27 | Siskiyou | 93 | 0 | 3 | 0 | 1 | 5 |
53022 | 53022 | 2020-05-27 | Solano | 95 | 20 | 14 | 8 | 2 | 41 |
53023 | 53023 | 2020-05-27 | Sonoma | 97 | 9 | 22 | 3 | 2 | 51 |
53024 | 53024 | 2020-05-27 | Stanislaus | 99 | 17 | 8 | 6 | 3 | 89 |
53025 | 53025 | 2020-05-27 | Sutter | 101 | 0 | 0 | 0 | 0 | |
53026 | 53026 | 2020-05-27 | Tehama | 103 | 0 | 0 | 0 | 0 | 3 |
53027 | 53027 | 2020-05-27 | Trinity | 105 | 0 | 2 | 0 | 0 | |
53028 | 53028 | 2020-05-27 | Tulare | 107 | 36 | 5 | 10 | 3 | 13 |
53029 | 53029 | 2020-05-27 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 0 |
53030 | 53030 | 2020-05-27 | Ventura | 111 | 28 | 24 | 10 | 10 | 40 |
53031 | 53031 | 2020-05-27 | Yolo | 113 | 0 | 0 | 0 | 0 | 3 |
53032 | 53032 | 2020-05-27 | Yuba | 115 | 1 | 0 | 0 | 0 | 12 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );