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-04-03
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
56001 | 56001 | 2020-04-03 | Alameda | 1 | 64 | 74 | 32 | 13 | 117 |
56002 | 56002 | 2020-04-03 | Amador | 5 | 0 | 0 | 0 | 0 | 1 |
56003 | 56003 | 2020-04-03 | Butte | 7 | 3 | 19 | 2 | 6 | 9 |
56004 | 56004 | 2020-04-03 | Calaveras | 9 | 0 | 1 | 0 | 0 | 5 |
56005 | 56005 | 2020-04-03 | Colusa | 11 | 1 | 0 | 1 | 0 | 5 |
56006 | 56006 | 2020-04-03 | Contra Costa | 13 | 31 | 39 | 15 | 10 | 75 |
56007 | 56007 | 2020-04-03 | Del Norte | 15 | 0 | 2 | 0 | 0 | 2 |
56008 | 56008 | 2020-04-03 | El Dorado | 17 | 15 | 9 | 0 | 4 | 14 |
56009 | 56009 | 2020-04-03 | Fresno | 19 | 15 | 81 | 7 | 16 | 35 |
56010 | 56010 | 2020-04-03 | Glenn | 21 | 0 | 0 | 0 | 0 | |
56011 | 56011 | 2020-04-03 | Humboldt | 23 | 1 | 7 | 0 | 0 | 10 |
56012 | 56012 | 2020-04-03 | Imperial | 25 | 9 | 7 | 7 | 0 | 5 |
56013 | 56013 | 2020-04-03 | Inyo | 27 | 8 | 102 | 1 | 2 | 1 |
56014 | 56014 | 2020-04-03 | Kern | 29 | 35 | 73 | 12 | 16 | 47 |
56015 | 56015 | 2020-04-03 | Kings | 31 | 0 | 3 | 1 | 0 | 3 |
56016 | 56016 | 2020-04-03 | Lake | 33 | 0 | 2 | 0 | 1 | 2 |
56017 | 56017 | 2020-04-03 | Lassen | 35 | 0 | 3 | 0 | 0 | |
56018 | 56018 | 2020-04-03 | Los Angeles | 37 | 962 | 1239 | 422 | 209 | 473 |
56019 | 56019 | 2020-04-03 | Madera | 39 | 0 | 5 | 0 | 1 | 7 |
56020 | 56020 | 2020-04-03 | Marin | 41 | 6 | 16 | 3 | 5 | 17 |
56021 | 56021 | 2020-04-03 | Mariposa | 43 | 0 | 2 | 0 | 0 | |
56022 | 56022 | 2020-04-03 | Mendocino | 45 | 0 | 5 | 0 | 1 | 6 |
56023 | 56023 | 2020-04-03 | Merced | 47 | 4 | 5 | 1 | 1 | 4 |
56024 | 56024 | 2020-04-03 | Modoc | 49 | 0 | 0 | 0 | 0 | |
56025 | 56025 | 2020-04-03 | Mono | 51 | 18 | 2 | 0 | 0 | 2 |
56026 | 56026 | 2020-04-03 | Monterey | 53 | 16 | 18 | 3 | 1 | 17 |
56027 | 56027 | 2020-04-03 | Napa | 55 | 1 | 9 | 0 | 1 | 9 |
56028 | 56028 | 2020-04-03 | Nevada | 57 | 2 | 4 | 2 | 1 | 5 |
56029 | 56029 | 2020-04-03 | Orange | 59 | 131 | 182 | 66 | 36 | 151 |
56030 | 56030 | 2020-04-03 | Placer | 61 | 21 | 23 | 10 | 1 | 7 |
56031 | 56031 | 2020-04-03 | Plumas | 63 | 0 | 0 | 0 | 0 | |
56032 | 56032 | 2020-04-03 | Riverside | 65 | 105 | 182 | 44 | 59 | 127 |
56033 | 56033 | 2020-04-03 | Sacramento | 67 | 77 | 76 | 28 | 17 | 76 |
56034 | 56034 | 2020-04-03 | San Benito | 69 | 2 | 0 | 2 | 0 | 0 |
56035 | 56035 | 2020-04-03 | San Bernardino | 71 | 118 | 204 | 44 | 53 | 57 |
56036 | 56036 | 2020-04-03 | San Diego | 73 | 171 | 308 | 84 | 28 | 216 |
56037 | 56037 | 2020-04-03 | San Francisco | 75 | 80 | 71 | 39 | 8 | 74 |
56038 | 56038 | 2020-04-03 | San Joaquin | 77 | 41 | 38 | 18 | 8 | 22 |
56039 | 56039 | 2020-04-03 | San Luis Obispo | 79 | 4 | 5 | 3 | 2 | 967 |
56040 | 56040 | 2020-04-03 | San Mateo | 81 | 65 | 39 | 26 | 4 | 38 |
56041 | 56041 | 2020-04-03 | Santa Barbara | 83 | 27 | 29 | 18 | 4 | 50 |
56042 | 56042 | 2020-04-03 | Santa Clara | 85 | 164 | 83 | 71 | 17 | 97 |
56043 | 56043 | 2020-04-03 | Santa Cruz | 87 | 4 | 8 | 3 | 0 | 2 |
56044 | 56044 | 2020-04-03 | Shasta | 89 | 2 | 9 | 1 | 3 | 14 |
56045 | 56045 | 2020-04-03 | Siskiyou | 93 | 0 | 3 | 0 | 1 | 4 |
56046 | 56046 | 2020-04-03 | Solano | 95 | 16 | 21 | 7 | 5 | 23 |
56047 | 56047 | 2020-04-03 | Sonoma | 97 | 6 | 24 | 2 | 3 | 15 |
56048 | 56048 | 2020-04-03 | Stanislaus | 99 | 28 | 45 | 12 | 8 | 22 |
56049 | 56049 | 2020-04-03 | Sutter | 101 | 0 | 0 | |||
56050 | 56050 | 2020-04-03 | Tehama | 103 | 0 | 0 | 0 | 0 | 8 |
56051 | 56051 | 2020-04-03 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56052 | 56052 | 2020-04-03 | Tulare | 107 | 6 | 15 | 5 | 2 | 3 |
56053 | 56053 | 2020-04-03 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 1 |
56054 | 56054 | 2020-04-03 | Ventura | 111 | 22 | 116 | 6 | 28 | 56 |
56055 | 56055 | 2020-04-03 | Yolo | 113 | 2 | 7 | 3 | 6 | 4 |
56056 | 56056 | 2020-04-03 | Yuba | 115 | 2 | 12 | 2 | 2 | 5 |
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 );