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-09-11
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
46985 | 46985 | 2020-09-11 | Alameda | 1 | 131 | 47 | 33 | 10 | 100 |
46986 | 46986 | 2020-09-11 | Amador | 5 | 2 | 0 | 0 | 0 | 3 |
46987 | 46987 | 2020-09-11 | Butte | 7 | 11 | 0 | 3 | 0 | 8 |
46988 | 46988 | 2020-09-11 | Calaveras | 9 | 2 | 1 | 2 | 0 | 4 |
46989 | 46989 | 2020-09-11 | Colusa | 11 | 0 | 3 | 0 | 0 | 0 |
46990 | 46990 | 2020-09-11 | Contra Costa | 13 | 73 | 20 | 25 | 3 | 40 |
46991 | 46991 | 2020-09-11 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
46992 | 46992 | 2020-09-11 | El Dorado | 17 | 1 | 1 | 1 | 1 | 6 |
46993 | 46993 | 2020-09-11 | Fresno | 19 | 112 | 15 | 29 | 1 | 37 |
46994 | 46994 | 2020-09-11 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
46995 | 46995 | 2020-09-11 | Humboldt | 23 | 2 | 1 | 2 | 0 | 4 |
46996 | 46996 | 2020-09-11 | Imperial | 25 | 25 | 0 | 9 | 0 | 12 |
46997 | 46997 | 2020-09-11 | Inyo | 27 | 0 | 0 | 0 | 0 | 3 |
46998 | 46998 | 2020-09-11 | Kern | 29 | 66 | 17 | 20 | 1 | 50 |
46999 | 46999 | 2020-09-11 | Kings | 31 | 31 | 0 | 3 | 0 | 9 |
47000 | 47000 | 2020-09-11 | Lake | 33 | 0 | 1 | 0 | 1 | 4 |
47001 | 47001 | 2020-09-11 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
47002 | 47002 | 2020-09-11 | Los Angeles | 37 | 813 | 345 | 275 | 59 | 942 |
47003 | 47003 | 2020-09-11 | Madera | 39 | 18 | 7 | 6 | 0 | 3 |
47004 | 47004 | 2020-09-11 | Marin | 41 | 9 | 2 | 2 | 1 | 10 |
47005 | 47005 | 2020-09-11 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
47006 | 47006 | 2020-09-11 | Mendocino | 45 | 3 | 0 | 1 | 0 | 6 |
47007 | 47007 | 2020-09-11 | Merced | 47 | 15 | 1 | 8 | 0 | 2 |
47008 | 47008 | 2020-09-11 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
47009 | 47009 | 2020-09-11 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
47010 | 47010 | 2020-09-11 | Monterey | 53 | 28 | 1 | 9 | 0 | 33 |
47011 | 47011 | 2020-09-11 | Napa | 55 | 5 | 0 | 2 | 0 | 15 |
47012 | 47012 | 2020-09-11 | Nevada | 57 | 2 | 1 | 1 | 0 | 1 |
47013 | 47013 | 2020-09-11 | Orange | 59 | 215 | 47 | 65 | 6 | 245 |
47014 | 47014 | 2020-09-11 | Placer | 61 | 34 | 18 | 10 | 1 | 32 |
47015 | 47015 | 2020-09-11 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
47016 | 47016 | 2020-09-11 | Riverside | 65 | 171 | 61 | 45 | 14 | 85 |
47017 | 47017 | 2020-09-11 | Sacramento | 67 | 135 | 26 | 50 | 7 | 79 |
47018 | 47018 | 2020-09-11 | San Benito | 69 | 0 | 0 | 0 | 0 | 3 |
47019 | 47019 | 2020-09-11 | San Bernardino | 71 | 201 | 49 | 67 | 10 | 149 |
47020 | 47020 | 2020-09-11 | San Diego | 73 | 227 | 60 | 88 | 12 | 281 |
47021 | 47021 | 2020-09-11 | San Francisco | 75 | 74 | 18 | 22 | 4 | 67 |
47022 | 47022 | 2020-09-11 | San Joaquin | 77 | 68 | 15 | 29 | 1 | 41 |
47023 | 47023 | 2020-09-11 | San Luis Obispo | 79 | 7 | 3 | 3 | 1 | 18 |
47024 | 47024 | 2020-09-11 | San Mateo | 81 | 38 | 10 | 11 | 5 | 36 |
47025 | 47025 | 2020-09-11 | Santa Barbara | 83 | 33 | 4 | 8 | 1 | 57 |
47026 | 47026 | 2020-09-11 | Santa Clara | 85 | 112 | 20 | 41 | 1 | 82 |
47027 | 47027 | 2020-09-11 | Santa Cruz | 87 | 16 | 0 | 2 | 0 | 7 |
47028 | 47028 | 2020-09-11 | Shasta | 89 | 3 | 0 | 1 | 0 | 5 |
47029 | 47029 | 2020-09-11 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 6 |
47030 | 47030 | 2020-09-11 | Solano | 95 | 25 | 8 | 6 | 2 | 6 |
47031 | 47031 | 2020-09-11 | Sonoma | 97 | 32 | 3 | 9 | 1 | 9 |
47032 | 47032 | 2020-09-11 | Stanislaus | 99 | 119 | 44 | 44 | 2 | 18 |
47033 | 47033 | 2020-09-11 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
47034 | 47034 | 2020-09-11 | Tehama | 103 | 2 | 0 | 1 | 0 | 2 |
47035 | 47035 | 2020-09-11 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
47036 | 47036 | 2020-09-11 | Tulare | 107 | 47 | 3 | 7 | 0 | 22 |
47037 | 47037 | 2020-09-11 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 2 |
47038 | 47038 | 2020-09-11 | Ventura | 111 | 55 | 25 | 21 | 5 | 44 |
47039 | 47039 | 2020-09-11 | Yolo | 113 | 5 | 0 | 5 | 0 | 2 |
47040 | 47040 | 2020-09-11 | Yuba | 115 | 20 | 1 | 4 | 0 | 9 |
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 );