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-19
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_positive_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55105 | 55105 | 2020-04-19 | Alameda | 1 | 84 | 63 | 37 | 5 | 61 |
55106 | 55106 | 2020-04-19 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
55107 | 55107 | 2020-04-19 | Butte | 7 | 1 | 3 | 0 | 1 | 11 |
55108 | 55108 | 2020-04-19 | Calaveras | 9 | 0 | 0 | 0 | 0 | 11 |
55109 | 55109 | 2020-04-19 | Colusa | 11 | 1 | 0 | 0 | 0 | 6 |
55110 | 55110 | 2020-04-19 | Contra Costa | 13 | 34 | 40 | 14 | 7 | 69 |
55111 | 55111 | 2020-04-19 | Del Norte | 15 | 0 | 0 | 0 | 0 | 3 |
55112 | 55112 | 2020-04-19 | El Dorado | 17 | 0 | 11 | 0 | 3 | 11 |
55113 | 55113 | 2020-04-19 | Fresno | 19 | 32 | 35 | 14 | 2 | 59 |
55114 | 55114 | 2020-04-19 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55115 | 55115 | 2020-04-19 | Humboldt | 23 | 0 | 3 | 0 | 0 | 7 |
55116 | 55116 | 2020-04-19 | Imperial | 25 | 25 | 8 | 11 | 2 | 1 |
55117 | 55117 | 2020-04-19 | Inyo | 27 | 1 | 0 | 1 | 0 | 5 |
55118 | 55118 | 2020-04-19 | Kern | 29 | 34 | 20 | 18 | 2 | 49 |
55119 | 55119 | 2020-04-19 | Kings | 31 | 8 | 0 | 3 | 0 | 0 |
55120 | 55120 | 2020-04-19 | Lake | 33 | 0 | 2 | 0 | 0 | 5 |
55121 | 55121 | 2020-04-19 | Lassen | 35 | 0 | 1 | 0 | 0 | |
55122 | 55122 | 2020-04-19 | Los Angeles | 37 | 1739 | 549 | 595 | 115 | 577 |
55123 | 55123 | 2020-04-19 | Madera | 39 | 0 | 7 | 0 | 0 | 7 |
55124 | 55124 | 2020-04-19 | Marin | 41 | 3 | 7 | 1 | 3 | 10 |
55125 | 55125 | 2020-04-19 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
55126 | 55126 | 2020-04-19 | Mendocino | 45 | 0 | 0 | 0 | 0 | 9 |
55127 | 55127 | 2020-04-19 | Merced | 47 | 0 | 2 | 0 | 1 | 4 |
55128 | 55128 | 2020-04-19 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55129 | 55129 | 2020-04-19 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55130 | 55130 | 2020-04-19 | Monterey | 53 | 25 | 6 | 2 | 0 | 26 |
55131 | 55131 | 2020-04-19 | Napa | 55 | 0 | 3 | 0 | 0 | 14 |
55132 | 55132 | 2020-04-19 | Nevada | 57 | 1 | 4 | 1 | 4 | 4 |
55133 | 55133 | 2020-04-19 | Orange | 59 | 162 | 130 | 73 | 24 | 248 |
55134 | 55134 | 2020-04-19 | Placer | 61 | 11 | 12 | 1 | 5 | 6 |
55135 | 55135 | 2020-04-19 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55136 | 55136 | 2020-04-19 | Riverside | 65 | 236 | 113 | 76 | 22 | 145 |
55137 | 55137 | 2020-04-19 | Sacramento | 67 | 65 | 39 | 22 | 11 | 59 |
55138 | 55138 | 2020-04-19 | San Benito | 69 | 0 | 0 | 0 | 0 | 3 |
55139 | 55139 | 2020-04-19 | San Bernardino | 71 | 158 | 97 | 62 | 17 | 107 |
55140 | 55140 | 2020-04-19 | San Diego | 73 | 226 | 94 | 92 | 26 | 154 |
55141 | 55141 | 2020-04-19 | San Francisco | 75 | 73 | 34 | 27 | 10 | 76 |
55142 | 55142 | 2020-04-19 | San Joaquin | 77 | 23 | 16 | 12 | 2 | 32 |
55143 | 55143 | 2020-04-19 | San Luis Obispo | 79 | 2 | 7 | 2 | 1 | 27 |
55144 | 55144 | 2020-04-19 | San Mateo | 81 | 53 | 6 | 18 | 0 | 22 |
55145 | 55145 | 2020-04-19 | Santa Barbara | 83 | 29 | 7 | 16 | 1 | 60 |
55146 | 55146 | 2020-04-19 | Santa Clara | 85 | 143 | 32 | 67 | 5 | 105 |
55147 | 55147 | 2020-04-19 | Santa Cruz | 87 | 2 | 3 | 1 | 0 | 13 |
55148 | 55148 | 2020-04-19 | Shasta | 89 | 1 | 0 | 1 | 0 | 11 |
55149 | 55149 | 2020-04-19 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 4 |
55150 | 55150 | 2020-04-19 | Solano | 95 | 11 | 10 | 6 | 3 | 40 |
55151 | 55151 | 2020-04-19 | Sonoma | 97 | 2 | 8 | 0 | 2 | 27 |
55152 | 55152 | 2020-04-19 | Stanislaus | 99 | 13 | 16 | 5 | 3 | 41 |
55153 | 55153 | 2020-04-19 | Sutter | 101 | 0 | 0 | |||
55154 | 55154 | 2020-04-19 | Tehama | 103 | 0 | 0 | 0 | 0 | 5 |
55155 | 55155 | 2020-04-19 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55156 | 55156 | 2020-04-19 | Tulare | 107 | 27 | 0 | 9 | 0 | 13 |
55157 | 55157 | 2020-04-19 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
55158 | 55158 | 2020-04-19 | Ventura | 111 | 26 | 26 | 9 | 4 | 33 |
55159 | 55159 | 2020-04-19 | Yolo | 113 | 6 | 0 | 0 | 0 | 21 |
55160 | 55160 | 2020-04-19 | Yuba | 115 | 0 | 2 | 0 | 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 );