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 suspected_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 |
---|---|---|---|---|---|---|---|
550 | 550 | 2021-06-28 | 1050 | 222 | 288 | 17 | 2472 |
584 | 584 | 2021-05-25 | 1210 | 237 | 287 | 18 | 2339 |
278 | 278 | 2022-03-27 | 1470 | 241 | 261 | 24 | 2185 |
270 | 270 | 2022-04-04 | 1154 | 244 | 211 | 20 | 2377 |
276 | 276 | 2022-03-29 | 1391 | 244 | 246 | 24 | 2216 |
585 | 585 | 2021-05-24 | 1222 | 244 | 297 | 26 | 2503 |
240 | 240 | 2022-05-04 | 1083 | 245 | 168 | 23 | 2171 |
561 | 561 | 2021-06-17 | 951 | 245 | 233 | 23 | 2255 |
284 | 284 | 2022-03-21 | 1850 | 246 | 313 | 24 | 2258 |
285 | 285 | 2022-03-20 | 1833 | 246 | 305 | 16 | 2181 |
582 | 582 | 2021-05-27 | 1161 | 246 | 272 | 23 | 2229 |
581 | 581 | 2021-05-28 | 1110 | 247 | 255 | 31 | 2315 |
588 | 588 | 2021-05-21 | 1293 | 247 | 316 | 31 | 2303 |
583 | 583 | 2021-05-26 | 1175 | 249 | 284 | 28 | 2242 |
541 | 541 | 2021-07-07 | 1319 | 250 | 318 | 16 | 2311 |
234 | 234 | 2022-05-10 | 1246 | 251 | 148 | 21 | 2280 |
567 | 567 | 2021-06-11 | 955 | 251 | 240 | 29 | 2298 |
565 | 565 | 2021-06-13 | 939 | 252 | 239 | 23 | 2439 |
586 | 586 | 2021-05-23 | 1261 | 252 | 307 | 25 | 2437 |
551 | 551 | 2021-06-27 | 980 | 255 | 290 | 19 | 2423 |
566 | 566 | 2021-06-12 | 915 | 255 | 241 | 28 | 2296 |
235 | 235 | 2022-05-09 | 1203 | 256 | 153 | 20 | 2391 |
239 | 239 | 2022-05-05 | 1123 | 256 | 168 | 19 | 2158 |
242 | 242 | 2022-05-02 | 1093 | 257 | 143 | 34 | 2360 |
275 | 275 | 2022-03-30 | 1352 | 257 | 246 | 16 | 2139 |
295 | 295 | 2022-03-10 | 2638 | 257 | 490 | 32 | 1994 |
543 | 543 | 2021-07-05 | 1153 | 257 | 298 | 29 | 2462 |
548 | 548 | 2021-06-30 | 1090 | 258 | 300 | 21 | 2244 |
237 | 237 | 2022-05-07 | 1185 | 259 | 165 | 17 | 2187 |
277 | 277 | 2022-03-28 | 1414 | 259 | 264 | 24 | 2308 |
291 | 291 | 2022-03-14 | 2263 | 259 | 419 | 32 | 2201 |
553 | 553 | 2021-06-25 | 959 | 259 | 266 | 25 | 2320 |
556 | 556 | 2021-06-22 | 978 | 259 | 277 | 33 | 2360 |
286 | 286 | 2022-03-19 | 1900 | 261 | 316 | 15 | 2073 |
549 | 549 | 2021-06-29 | 1089 | 261 | 307 | 22 | 2298 |
592 | 592 | 2021-05-17 | 1402 | 262 | 335 | 41 | 2470 |
236 | 236 | 2022-05-08 | 1190 | 263 | 173 | 20 | 2362 |
552 | 552 | 2021-06-26 | 964 | 263 | 283 | 26 | 2323 |
571 | 571 | 2021-06-07 | 1015 | 263 | 228 | 37 | 2524 |
578 | 578 | 2021-05-31 | 1069 | 263 | 266 | 39 | 2566 |
292 | 292 | 2022-03-13 | 2299 | 264 | 443 | 27 | 2239 |
572 | 572 | 2021-06-06 | 1011 | 264 | 218 | 32 | 2484 |
293 | 293 | 2022-03-12 | 2362 | 266 | 459 | 29 | 2137 |
296 | 296 | 2022-03-09 | 2797 | 266 | 516 | 31 | 2000 |
241 | 241 | 2022-05-03 | 1109 | 268 | 142 | 24 | 2220 |
279 | 279 | 2022-03-26 | 1512 | 269 | 267 | 31 | 2087 |
282 | 282 | 2022-03-23 | 1699 | 269 | 285 | 23 | 2068 |
554 | 554 | 2021-06-24 | 959 | 269 | 269 | 23 | 2306 |
577 | 577 | 2021-06-01 | 1060 | 270 | 263 | 36 | 2540 |
591 | 591 | 2021-05-18 | 1387 | 270 | 342 | 35 | 2326 |
257 | 257 | 2022-04-17 | 963 | 271 | 145 | 20 | 2306 |
260 | 260 | 2022-04-14 | 1000 | 271 | 155 | 33 | 2232 |
555 | 555 | 2021-06-23 | 955 | 271 | 264 | 35 | 2262 |
579 | 579 | 2021-05-30 | 1057 | 271 | 259 | 36 | 2454 |
274 | 274 | 2022-03-31 | 1270 | 273 | 220 | 19 | 2106 |
406 | 406 | 2021-11-19 | 3268 | 273 | 906 | 28 | 1741 |
232 | 232 | 2022-05-12 | 1339 | 274 | 162 | 18 | 2175 |
233 | 233 | 2022-05-11 | 1273 | 274 | 152 | 19 | 2334 |
238 | 238 | 2022-05-06 | 1151 | 274 | 162 | 25 | 2210 |
249 | 249 | 2022-04-25 | 950 | 274 | 112 | 26 | 2399 |
545 | 545 | 2021-07-03 | 1097 | 274 | 288 | 22 | 2287 |
557 | 557 | 2021-06-21 | 949 | 274 | 243 | 28 | 2567 |
564 | 564 | 2021-06-14 | 977 | 274 | 251 | 21 | 2588 |
570 | 570 | 2021-06-08 | 1030 | 274 | 231 | 39 | 2390 |
573 | 573 | 2021-06-05 | 1035 | 274 | 221 | 32 | 2268 |
261 | 261 | 2022-04-13 | 1031 | 275 | 152 | 32 | 2172 |
563 | 563 | 2021-06-15 | 981 | 275 | 242 | 26 | 2443 |
575 | 575 | 2021-06-03 | 1062 | 275 | 260 | 36 | 2314 |
536 | 536 | 2021-07-12 | 1594 | 276 | 357 | 34 | 2330 |
562 | 562 | 2021-06-16 | 956 | 276 | 232 | 31 | 2276 |
544 | 544 | 2021-07-04 | 1122 | 277 | 287 | 29 | 2368 |
590 | 590 | 2021-05-19 | 1394 | 277 | 346 | 25 | 2254 |
128 | 128 | 2022-08-24 | 3146 | 278 | 383 | 34 | 1912 |
289 | 289 | 2022-03-16 | 2147 | 278 | 384 | 35 | 2036 |
542 | 542 | 2021-07-06 | 1228 | 278 | 299 | 29 | 2555 |
569 | 569 | 2021-06-09 | 1001 | 278 | 234 | 27 | 2262 |
87 | 87 | 2022-10-04 | 1896 | 279 | 229 | 41 | 2247 |
259 | 259 | 2022-04-15 | 995 | 279 | 144 | 30 | 2166 |
540 | 540 | 2021-07-08 | 1343 | 279 | 321 | 27 | 2247 |
127 | 127 | 2022-08-25 | 3137 | 280 | 373 | 33 | 1900 |
273 | 273 | 2022-04-01 | 1209 | 280 | 222 | 21 | 2121 |
411 | 411 | 2021-11-14 | 3472 | 280 | 948 | 40 | 1947 |
531 | 531 | 2021-07-17 | 1927 | 280 | 477 | 38 | 2123 |
532 | 532 | 2021-07-16 | 1884 | 280 | 441 | 50 | 2038 |
587 | 587 | 2021-05-22 | 1276 | 280 | 306 | 26 | 2377 |
405 | 405 | 2021-11-20 | 3214 | 281 | 884 | 31 | 1791 |
537 | 537 | 2021-07-11 | 1484 | 281 | 341 | 35 | 2278 |
568 | 568 | 2021-06-10 | 982 | 281 | 233 | 28 | 2241 |
576 | 576 | 2021-06-02 | 1081 | 281 | 269 | 34 | 2365 |
80 | 80 | 2022-10-11 | 1759 | 282 | 218 | 25 | 2223 |
269 | 269 | 2022-04-05 | 1138 | 282 | 202 | 21 | 2195 |
560 | 560 | 2021-06-18 | 932 | 282 | 231 | 33 | 2266 |
594 | 594 | 2021-05-15 | 1402 | 282 | 362 | 35 | 2333 |
230 | 230 | 2022-05-14 | 1378 | 283 | 174 | 23 | 2188 |
407 | 407 | 2021-11-18 | 3313 | 283 | 926 | 25 | 1768 |
453 | 453 | 2021-10-03 | 4507 | 283 | 1291 | 29 | 1955 |
529 | 529 | 2021-07-19 | 2164 | 283 | 552 | 37 | 2232 |
530 | 530 | 2021-07-18 | 1990 | 283 | 502 | 41 | 2243 |
252 | 252 | 2022-04-22 | 969 | 284 | 127 | 35 | 2195 |
281 | 281 | 2022-03-24 | 1648 | 284 | 290 | 33 | 2116 |
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 );