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,333 rows sorted by date
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 |
---|---|---|---|---|---|---|---|---|---|
56269 | 56269 | 2020-03-30 | Sonoma | 97 | 7 | 22 | 3 | 4 | 29 |
56270 | 56270 | 2020-03-30 | Stanislaus | 99 | 17 | 51 | 9 | 5 | 29 |
56271 | 56271 | 2020-03-30 | Sutter | 101 | 0 | 0 | 0 | 0 | |
56272 | 56272 | 2020-03-30 | Tehama | 103 | 0 | 2 | 0 | 0 | 2 |
56273 | 56273 | 2020-03-30 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56274 | 56274 | 2020-03-30 | Tulare | 107 | 5 | 21 | 4 | 6 | 7 |
56275 | 56275 | 2020-03-30 | Tuolumne | 109 | 1 | 2 | 0 | 0 | 3 |
56276 | 56276 | 2020-03-30 | Ventura | 111 | 25 | 82 | 5 | 28 | 15 |
56277 | 56277 | 2020-03-30 | Yolo | 113 | 2 | 2 | 1 | 2 | 0 |
56278 | 56278 | 2020-03-30 | Yuba | 115 | 3 | 17 | 2 | 4 | 10 |
56169 | 56169 | 2020-03-31 | Alameda | 1 | 56 | 94 | 27 | 17 | 77 |
56170 | 56170 | 2020-03-31 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
56171 | 56171 | 2020-03-31 | Butte | 7 | 4 | 20 | 2 | 3 | 2 |
56172 | 56172 | 2020-03-31 | Calaveras | 9 | 0 | 1 | 0 | 0 | 4 |
56173 | 56173 | 2020-03-31 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
56174 | 56174 | 2020-03-31 | Contra Costa | 13 | 27 | 54 | 11 | 10 | 68 |
56175 | 56175 | 2020-03-31 | Del Norte | 15 | 0 | 4 | 0 | 0 | 3 |
56176 | 56176 | 2020-03-31 | El Dorado | 17 | 10 | 9 | 0 | 6 | 12 |
56177 | 56177 | 2020-03-31 | Fresno | 19 | 30 | 274 | 4 | 19 | 23 |
56178 | 56178 | 2020-03-31 | Glenn | 21 | 0 | 0 | 0 | 0 | |
56179 | 56179 | 2020-03-31 | Humboldt | 23 | 1 | 11 | 0 | 4 | 8 |
56180 | 56180 | 2020-03-31 | Imperial | 25 | 12 | 100 | 3 | 4 | 4 |
56181 | 56181 | 2020-03-31 | Inyo | 27 | 83 | 0 | 0 | 6 | |
56182 | 56182 | 2020-03-31 | Kern | 29 | 14 | 63 | 6 | 6 | 46 |
56183 | 56183 | 2020-03-31 | Kings | 31 | 1 | 3 | 1 | 2 | 4 |
56184 | 56184 | 2020-03-31 | Lake | 33 | 0 | 4 | 0 | 2 | 3 |
56185 | 56185 | 2020-03-31 | Lassen | 35 | 0 | 7 | 0 | 0 | |
56186 | 56186 | 2020-03-31 | Los Angeles | 37 | 713 | 1239 | 315 | 239 | 445 |
56187 | 56187 | 2020-03-31 | Madera | 39 | 1 | 3 | 1 | 0 | 5 |
56188 | 56188 | 2020-03-31 | Marin | 41 | 9 | 14 | 4 | 2 | 15 |
56189 | 56189 | 2020-03-31 | Mendocino | 45 | 0 | 1 | 0 | 0 | 7 |
56190 | 56190 | 2020-03-31 | Merced | 47 | 3 | 11 | 0 | 2 | 10 |
56191 | 56191 | 2020-03-31 | Modoc | 49 | 0 | 19 | 0 | 0 | |
56192 | 56192 | 2020-03-31 | Mono | 51 | 0 | 1 | 0 | 0 | 2 |
56193 | 56193 | 2020-03-31 | Monterey | 53 | 11 | 15 | 4 | 2 | 17 |
56194 | 56194 | 2020-03-31 | Napa | 55 | 1 | 5 | 1 | 1 | 12 |
56195 | 56195 | 2020-03-31 | Nevada | 57 | 36 | 40 | 2 | 1 | 6 |
56196 | 56196 | 2020-03-31 | Orange | 59 | 105 | 233 | 45 | 44 | 131 |
56197 | 56197 | 2020-03-31 | Placer | 61 | 18 | 27 | 6 | 0 | 28 |
56198 | 56198 | 2020-03-31 | Plumas | 63 | 0 | 0 | 0 | 0 | |
56199 | 56199 | 2020-03-31 | Riverside | 65 | 80 | 155 | 28 | 59 | 75 |
56200 | 56200 | 2020-03-31 | Sacramento | 67 | 53 | 110 | 20 | 31 | 66 |
56201 | 56201 | 2020-03-31 | San Benito | 69 | 1 | 0 | 1 | 0 | 1 |
56202 | 56202 | 2020-03-31 | San Bernardino | 71 | 82 | 231 | 33 | 48 | 63 |
56203 | 56203 | 2020-03-31 | San Diego | 73 | 158 | 408 | 75 | 39 | 208 |
56204 | 56204 | 2020-03-31 | San Francisco | 75 | 67 | 69 | 30 | 14 | 77 |
56205 | 56205 | 2020-03-31 | San Joaquin | 77 | 44 | 54 | 14 | 5 | 28 |
56206 | 56206 | 2020-03-31 | San Luis Obispo | 79 | 7 | 15 | 3 | 6 | 955 |
56207 | 56207 | 2020-03-31 | San Mateo | 81 | 60 | 23 | 18 | 5 | 37 |
56208 | 56208 | 2020-03-31 | Santa Barbara | 83 | 19 | 29 | 14 | 7 | 48 |
56209 | 56209 | 2020-03-31 | Santa Clara | 85 | 155 | 98 | 73 | 17 | 92 |
56210 | 56210 | 2020-03-31 | Santa Cruz | 87 | 1 | 10 | 1 | 2 | 7 |
56211 | 56211 | 2020-03-31 | Shasta | 89 | 1 | 5 | 1 | 0 | 4 |
56212 | 56212 | 2020-03-31 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
56213 | 56213 | 2020-03-31 | Solano | 95 | 15 | 15 | 6 | 5 | 42 |
56214 | 56214 | 2020-03-31 | Sonoma | 97 | 8 | 18 | 3 | 3 | 21 |
56215 | 56215 | 2020-03-31 | Stanislaus | 99 | 20 | 31 | 9 | 1 | 34 |
56216 | 56216 | 2020-03-31 | Sutter | 101 | 0 | 0 | 0 | 0 | |
56217 | 56217 | 2020-03-31 | Tehama | 103 | 0 | 2 | 0 | 0 | 4 |
56218 | 56218 | 2020-03-31 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56219 | 56219 | 2020-03-31 | Tulare | 107 | 6 | 14 | 4 | 5 | 9 |
56220 | 56220 | 2020-03-31 | Tuolumne | 109 | 0 | 37 | 0 | 0 | 4 |
56221 | 56221 | 2020-03-31 | Ventura | 111 | 21 | 90 | 5 | 24 | 12 |
56222 | 56222 | 2020-03-31 | Yolo | 113 | 3 | 2 | 2 | 2 | 1 |
56223 | 56223 | 2020-03-31 | Yuba | 115 | 2 | 21 | 2 | 4 | 6 |
56113 | 56113 | 2020-04-01 | Alameda | 1 | 52 | 76 | 27 | 15 | 106 |
56114 | 56114 | 2020-04-01 | Amador | 5 | 0 | 3 | 0 | 0 | 2 |
56115 | 56115 | 2020-04-01 | Butte | 7 | 5 | 33 | 2 | 4 | 9 |
56116 | 56116 | 2020-04-01 | Calaveras | 9 | 0 | 1 | 0 | 0 | 5 |
56117 | 56117 | 2020-04-01 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
56118 | 56118 | 2020-04-01 | Contra Costa | 13 | 31 | 42 | 12 | 12 | 61 |
56119 | 56119 | 2020-04-01 | Del Norte | 15 | 0 | 5 | 0 | 0 | 3 |
56120 | 56120 | 2020-04-01 | El Dorado | 17 | 14 | 8 | 1 | 3 | 9 |
56121 | 56121 | 2020-04-01 | Fresno | 19 | 19 | 101 | 5 | 13 | 53 |
56122 | 56122 | 2020-04-01 | Glenn | 21 | |||||
56123 | 56123 | 2020-04-01 | Humboldt | 23 | 1 | 9 | 0 | 3 | 7 |
56124 | 56124 | 2020-04-01 | Imperial | 25 | 4 | 15 | 3 | 4 | 7 |
56125 | 56125 | 2020-04-01 | Inyo | 27 | 7 | 89 | 0 | 0 | 6 |
56126 | 56126 | 2020-04-01 | Kern | 29 | 15 | 45 | 7 | 9 | 32 |
56127 | 56127 | 2020-04-01 | Kings | 31 | 2 | 6 | 1 | 2 | 1 |
56128 | 56128 | 2020-04-01 | Lake | 33 | 0 | 2 | 0 | 0 | 2 |
56129 | 56129 | 2020-04-01 | Lassen | 35 | 0 | 7 | 0 | 0 | |
56130 | 56130 | 2020-04-01 | Los Angeles | 37 | 739 | 1332 | 335 | 220 | 492 |
56131 | 56131 | 2020-04-01 | Madera | 39 | 1 | 3 | 1 | 0 | 4 |
56132 | 56132 | 2020-04-01 | Marin | 41 | 9 | 19 | 4 | 2 | 14 |
56133 | 56133 | 2020-04-01 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
56134 | 56134 | 2020-04-01 | Mendocino | 45 | 0 | 2 | 0 | 0 | 8 |
56135 | 56135 | 2020-04-01 | Merced | 47 | 3 | 15 | 0 | 3 | 9 |
56136 | 56136 | 2020-04-01 | Modoc | 49 | 0 | 1 | 0 | 0 | |
56137 | 56137 | 2020-04-01 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
56138 | 56138 | 2020-04-01 | Monterey | 53 | 13 | 16 | 4 | 4 | 15 |
56139 | 56139 | 2020-04-01 | Napa | 55 | 2 | 2 | 0 | 1 | 9 |
56140 | 56140 | 2020-04-01 | Nevada | 57 | 36 | 54 | 0 | 4 | 3 |
56141 | 56141 | 2020-04-01 | Orange | 59 | 117 | 221 | 50 | 48 | 118 |
56142 | 56142 | 2020-04-01 | Placer | 61 | 25 | 28 | 6 | 2 | 7 |
56143 | 56143 | 2020-04-01 | Plumas | 63 | 0 | 0 | 0 | 0 | |
56144 | 56144 | 2020-04-01 | Riverside | 65 | 85 | 182 | 29 | 47 | 76 |
56145 | 56145 | 2020-04-01 | Sacramento | 67 | 53 | 138 | 20 | 33 | 74 |
56146 | 56146 | 2020-04-01 | San Benito | 69 | 2 | 0 | 2 | 0 | 0 |
56147 | 56147 | 2020-04-01 | San Bernardino | 71 | 95 | 196 | 39 | 52 | 34 |
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 );