cdph-hospital-patient-state-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.
- 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.
1,006 rows sorted by icu_positive_patients
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | positive_patients | suspected_patients | icu_positive_patients ▼ | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|
249 | 249 | 2022-04-25 | 950 | 274 | 112 | 26 | 2399 |
250 | 250 | 2022-04-24 | 967 | 287 | 119 | 27 | 2352 |
252 | 252 | 2022-04-22 | 969 | 284 | 127 | 35 | 2195 |
251 | 251 | 2022-04-23 | 966 | 291 | 129 | 34 | 2226 |
246 | 246 | 2022-04-28 | 1025 | 345 | 130 | 35 | 2156 |
248 | 248 | 2022-04-26 | 1008 | 313 | 131 | 32 | 2256 |
253 | 253 | 2022-04-21 | 966 | 295 | 132 | 36 | 2163 |
254 | 254 | 2022-04-20 | 970 | 301 | 133 | 41 | 2133 |
247 | 247 | 2022-04-27 | 1012 | 320 | 138 | 34 | 2148 |
245 | 245 | 2022-04-29 | 1035 | 295 | 140 | 25 | 2257 |
256 | 256 | 2022-04-18 | 964 | 296 | 141 | 29 | 2331 |
241 | 241 | 2022-05-03 | 1109 | 268 | 142 | 24 | 2220 |
242 | 242 | 2022-05-02 | 1093 | 257 | 143 | 34 | 2360 |
258 | 258 | 2022-04-16 | 949 | 291 | 144 | 28 | 2177 |
259 | 259 | 2022-04-15 | 995 | 279 | 144 | 30 | 2166 |
257 | 257 | 2022-04-17 | 963 | 271 | 145 | 20 | 2306 |
244 | 244 | 2022-04-30 | 1037 | 286 | 146 | 26 | 2313 |
234 | 234 | 2022-05-10 | 1246 | 251 | 148 | 21 | 2280 |
243 | 243 | 2022-05-01 | 1052 | 294 | 148 | 26 | 2351 |
263 | 263 | 2022-04-11 | 1053 | 299 | 148 | 41 | 2338 |
233 | 233 | 2022-05-11 | 1273 | 274 | 152 | 19 | 2334 |
261 | 261 | 2022-04-13 | 1031 | 275 | 152 | 32 | 2172 |
264 | 264 | 2022-04-10 | 1013 | 323 | 152 | 39 | 2294 |
235 | 235 | 2022-05-09 | 1203 | 256 | 153 | 20 | 2391 |
255 | 255 | 2022-04-19 | 972 | 297 | 153 | 31 | 2217 |
260 | 260 | 2022-04-14 | 1000 | 271 | 155 | 33 | 2232 |
262 | 262 | 2022-04-12 | 1040 | 322 | 156 | 39 | 2204 |
232 | 232 | 2022-05-12 | 1339 | 274 | 162 | 18 | 2175 |
238 | 238 | 2022-05-06 | 1151 | 274 | 162 | 25 | 2210 |
265 | 265 | 2022-04-09 | 1045 | 302 | 162 | 28 | 2160 |
237 | 237 | 2022-05-07 | 1185 | 259 | 165 | 17 | 2187 |
239 | 239 | 2022-05-05 | 1123 | 256 | 168 | 19 | 2158 |
240 | 240 | 2022-05-04 | 1083 | 245 | 168 | 23 | 2171 |
236 | 236 | 2022-05-08 | 1190 | 263 | 173 | 20 | 2362 |
230 | 230 | 2022-05-14 | 1378 | 283 | 174 | 23 | 2188 |
266 | 266 | 2022-04-08 | 1064 | 297 | 175 | 26 | 2176 |
231 | 231 | 2022-05-13 | 1390 | 288 | 176 | 21 | 2160 |
228 | 228 | 2022-05-16 | 1527 | 297 | 182 | 28 | 2337 |
62 | 62 | 2022-10-29 | 1532 | 354 | 185 | 42 | 2088 |
70 | 70 | 2022-10-21 | 1579 | 320 | 186 | 33 | 2044 |
67 | 67 | 2022-10-24 | 1514 | 323 | 190 | 43 | 2212 |
267 | 267 | 2022-04-07 | 1098 | 288 | 190 | 25 | 2206 |
60 | 60 | 2022-10-31 | 1592 | 336 | 191 | 41 | 2223 |
229 | 229 | 2022-05-15 | 1409 | 297 | 191 | 25 | 2254 |
65 | 65 | 2022-10-26 | 1674 | 327 | 192 | 40 | 1983 |
57 | 57 | 2022-11-03 | 1730 | 407 | 193 | 48 | 2048 |
69 | 69 | 2022-10-22 | 1555 | 329 | 193 | 46 | 2074 |
268 | 268 | 2022-04-06 | 1126 | 292 | 193 | 21 | 2199 |
58 | 58 | 2022-11-02 | 1700 | 410 | 196 | 49 | 1985 |
55 | 55 | 2022-11-05 | 1671 | 411 | 198 | 57 | 1976 |
66 | 66 | 2022-10-25 | 1537 | 311 | 198 | 46 | 2011 |
59 | 59 | 2022-11-01 | 1634 | 353 | 200 | 40 | 2138 |
71 | 71 | 2022-10-20 | 1599 | 353 | 200 | 42 | 2032 |
227 | 227 | 2022-05-17 | 1615 | 370 | 200 | 30 | 2137 |
269 | 269 | 2022-04-05 | 1138 | 282 | 202 | 21 | 2195 |
61 | 61 | 2022-10-30 | 1626 | 342 | 203 | 50 | 2182 |
226 | 226 | 2022-05-18 | 1642 | 292 | 203 | 35 | 2104 |
64 | 64 | 2022-10-27 | 1599 | 368 | 208 | 47 | 2021 |
225 | 225 | 2022-05-19 | 1712 | 314 | 208 | 33 | 2077 |
83 | 83 | 2022-10-08 | 1693 | 326 | 209 | 33 | 2380 |
63 | 63 | 2022-10-28 | 1569 | 354 | 210 | 37 | 2039 |
72 | 72 | 2022-10-19 | 1617 | 331 | 210 | 33 | 1989 |
56 | 56 | 2022-11-04 | 1704 | 383 | 211 | 53 | 2010 |
68 | 68 | 2022-10-23 | 1558 | 312 | 211 | 41 | 2125 |
270 | 270 | 2022-04-04 | 1154 | 244 | 211 | 20 | 2377 |
73 | 73 | 2022-10-18 | 1601 | 323 | 212 | 38 | 2060 |
221 | 221 | 2022-05-23 | 1931 | 326 | 217 | 32 | 2253 |
272 | 272 | 2022-04-02 | 1165 | 291 | 217 | 29 | 2161 |
54 | 54 | 2022-11-06 | 1719 | 395 | 218 | 55 | 2081 |
74 | 74 | 2022-10-17 | 1615 | 322 | 218 | 41 | 2250 |
80 | 80 | 2022-10-11 | 1759 | 282 | 218 | 25 | 2223 |
572 | 572 | 2021-06-06 | 1011 | 264 | 218 | 32 | 2484 |
224 | 224 | 2022-05-20 | 1780 | 311 | 219 | 32 | 2048 |
50 | 50 | 2022-11-10 | 1871 | 395 | 220 | 46 | 1886 |
82 | 82 | 2022-10-09 | 1735 | 313 | 220 | 35 | 2256 |
274 | 274 | 2022-03-31 | 1270 | 273 | 220 | 19 | 2106 |
573 | 573 | 2021-06-05 | 1035 | 274 | 221 | 32 | 2268 |
273 | 273 | 2022-04-01 | 1209 | 280 | 222 | 21 | 2121 |
271 | 271 | 2022-04-03 | 1130 | 291 | 223 | 20 | 2250 |
76 | 76 | 2022-10-15 | 1649 | 322 | 224 | 47 | 2254 |
220 | 220 | 2022-05-24 | 1961 | 334 | 224 | 28 | 2130 |
51 | 51 | 2022-11-09 | 1842 | 427 | 225 | 55 | 1964 |
52 | 52 | 2022-11-08 | 1855 | 400 | 225 | 46 | 1938 |
77 | 77 | 2022-10-14 | 1669 | 294 | 225 | 44 | 2100 |
75 | 75 | 2022-10-16 | 1649 | 319 | 226 | 40 | 2244 |
81 | 81 | 2022-10-10 | 1765 | 299 | 228 | 34 | 2271 |
223 | 223 | 2022-05-21 | 1789 | 302 | 228 | 31 | 2095 |
571 | 571 | 2021-06-07 | 1015 | 263 | 228 | 37 | 2524 |
87 | 87 | 2022-10-04 | 1896 | 279 | 229 | 41 | 2247 |
78 | 78 | 2022-10-13 | 1700 | 290 | 230 | 40 | 2120 |
95 | 95 | 2022-09-26 | 2048 | 328 | 230 | 24 | 2290 |
559 | 559 | 2021-06-19 | 916 | 300 | 230 | 22 | 2328 |
53 | 53 | 2022-11-07 | 1756 | 393 | 231 | 57 | 2150 |
84 | 84 | 2022-10-07 | 1755 | 325 | 231 | 29 | 2289 |
90 | 90 | 2022-10-01 | 1803 | 286 | 231 | 21 | 2106 |
560 | 560 | 2021-06-18 | 932 | 282 | 231 | 33 | 2266 |
570 | 570 | 2021-06-08 | 1030 | 274 | 231 | 39 | 2390 |
48 | 48 | 2022-11-12 | 1942 | 410 | 232 | 48 | 1904 |
79 | 79 | 2022-10-12 | 1733 | 288 | 232 | 36 | 2037 |
562 | 562 | 2021-06-16 | 956 | 276 | 232 | 31 | 2276 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-state-totals" ( [date] TEXT, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );