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 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 |
---|---|---|---|---|---|---|---|
566 | 566 | 2021-06-12 | 915 | 255 | 241 | 28 | 2296 |
559 | 559 | 2021-06-19 | 916 | 300 | 230 | 22 | 2328 |
558 | 558 | 2021-06-20 | 929 | 294 | 238 | 31 | 2436 |
560 | 560 | 2021-06-18 | 932 | 282 | 231 | 33 | 2266 |
565 | 565 | 2021-06-13 | 939 | 252 | 239 | 23 | 2439 |
258 | 258 | 2022-04-16 | 949 | 291 | 144 | 28 | 2177 |
557 | 557 | 2021-06-21 | 949 | 274 | 243 | 28 | 2567 |
249 | 249 | 2022-04-25 | 950 | 274 | 112 | 26 | 2399 |
561 | 561 | 2021-06-17 | 951 | 245 | 233 | 23 | 2255 |
555 | 555 | 2021-06-23 | 955 | 271 | 264 | 35 | 2262 |
567 | 567 | 2021-06-11 | 955 | 251 | 240 | 29 | 2298 |
562 | 562 | 2021-06-16 | 956 | 276 | 232 | 31 | 2276 |
553 | 553 | 2021-06-25 | 959 | 259 | 266 | 25 | 2320 |
554 | 554 | 2021-06-24 | 959 | 269 | 269 | 23 | 2306 |
257 | 257 | 2022-04-17 | 963 | 271 | 145 | 20 | 2306 |
256 | 256 | 2022-04-18 | 964 | 296 | 141 | 29 | 2331 |
552 | 552 | 2021-06-26 | 964 | 263 | 283 | 26 | 2323 |
251 | 251 | 2022-04-23 | 966 | 291 | 129 | 34 | 2226 |
253 | 253 | 2022-04-21 | 966 | 295 | 132 | 36 | 2163 |
250 | 250 | 2022-04-24 | 967 | 287 | 119 | 27 | 2352 |
252 | 252 | 2022-04-22 | 969 | 284 | 127 | 35 | 2195 |
254 | 254 | 2022-04-20 | 970 | 301 | 133 | 41 | 2133 |
255 | 255 | 2022-04-19 | 972 | 297 | 153 | 31 | 2217 |
564 | 564 | 2021-06-14 | 977 | 274 | 251 | 21 | 2588 |
556 | 556 | 2021-06-22 | 978 | 259 | 277 | 33 | 2360 |
551 | 551 | 2021-06-27 | 980 | 255 | 290 | 19 | 2423 |
563 | 563 | 2021-06-15 | 981 | 275 | 242 | 26 | 2443 |
568 | 568 | 2021-06-10 | 982 | 281 | 233 | 28 | 2241 |
259 | 259 | 2022-04-15 | 995 | 279 | 144 | 30 | 2166 |
260 | 260 | 2022-04-14 | 1000 | 271 | 155 | 33 | 2232 |
569 | 569 | 2021-06-09 | 1001 | 278 | 234 | 27 | 2262 |
248 | 248 | 2022-04-26 | 1008 | 313 | 131 | 32 | 2256 |
572 | 572 | 2021-06-06 | 1011 | 264 | 218 | 32 | 2484 |
247 | 247 | 2022-04-27 | 1012 | 320 | 138 | 34 | 2148 |
264 | 264 | 2022-04-10 | 1013 | 323 | 152 | 39 | 2294 |
571 | 571 | 2021-06-07 | 1015 | 263 | 228 | 37 | 2524 |
246 | 246 | 2022-04-28 | 1025 | 345 | 130 | 35 | 2156 |
570 | 570 | 2021-06-08 | 1030 | 274 | 231 | 39 | 2390 |
261 | 261 | 2022-04-13 | 1031 | 275 | 152 | 32 | 2172 |
245 | 245 | 2022-04-29 | 1035 | 295 | 140 | 25 | 2257 |
573 | 573 | 2021-06-05 | 1035 | 274 | 221 | 32 | 2268 |
244 | 244 | 2022-04-30 | 1037 | 286 | 146 | 26 | 2313 |
262 | 262 | 2022-04-12 | 1040 | 322 | 156 | 39 | 2204 |
574 | 574 | 2021-06-04 | 1042 | 320 | 243 | 39 | 2256 |
265 | 265 | 2022-04-09 | 1045 | 302 | 162 | 28 | 2160 |
550 | 550 | 2021-06-28 | 1050 | 222 | 288 | 17 | 2472 |
243 | 243 | 2022-05-01 | 1052 | 294 | 148 | 26 | 2351 |
263 | 263 | 2022-04-11 | 1053 | 299 | 148 | 41 | 2338 |
579 | 579 | 2021-05-30 | 1057 | 271 | 259 | 36 | 2454 |
577 | 577 | 2021-06-01 | 1060 | 270 | 263 | 36 | 2540 |
575 | 575 | 2021-06-03 | 1062 | 275 | 260 | 36 | 2314 |
266 | 266 | 2022-04-08 | 1064 | 297 | 175 | 26 | 2176 |
578 | 578 | 2021-05-31 | 1069 | 263 | 266 | 39 | 2566 |
547 | 547 | 2021-07-01 | 1071 | 295 | 295 | 22 | 2212 |
576 | 576 | 2021-06-02 | 1081 | 281 | 269 | 34 | 2365 |
240 | 240 | 2022-05-04 | 1083 | 245 | 168 | 23 | 2171 |
580 | 580 | 2021-05-29 | 1088 | 307 | 248 | 31 | 2468 |
549 | 549 | 2021-06-29 | 1089 | 261 | 307 | 22 | 2298 |
548 | 548 | 2021-06-30 | 1090 | 258 | 300 | 21 | 2244 |
242 | 242 | 2022-05-02 | 1093 | 257 | 143 | 34 | 2360 |
545 | 545 | 2021-07-03 | 1097 | 274 | 288 | 22 | 2287 |
267 | 267 | 2022-04-07 | 1098 | 288 | 190 | 25 | 2206 |
241 | 241 | 2022-05-03 | 1109 | 268 | 142 | 24 | 2220 |
581 | 581 | 2021-05-28 | 1110 | 247 | 255 | 31 | 2315 |
546 | 546 | 2021-07-02 | 1115 | 290 | 286 | 27 | 2253 |
544 | 544 | 2021-07-04 | 1122 | 277 | 287 | 29 | 2368 |
239 | 239 | 2022-05-05 | 1123 | 256 | 168 | 19 | 2158 |
268 | 268 | 2022-04-06 | 1126 | 292 | 193 | 21 | 2199 |
271 | 271 | 2022-04-03 | 1130 | 291 | 223 | 20 | 2250 |
269 | 269 | 2022-04-05 | 1138 | 282 | 202 | 21 | 2195 |
238 | 238 | 2022-05-06 | 1151 | 274 | 162 | 25 | 2210 |
543 | 543 | 2021-07-05 | 1153 | 257 | 298 | 29 | 2462 |
270 | 270 | 2022-04-04 | 1154 | 244 | 211 | 20 | 2377 |
582 | 582 | 2021-05-27 | 1161 | 246 | 272 | 23 | 2229 |
272 | 272 | 2022-04-02 | 1165 | 291 | 217 | 29 | 2161 |
583 | 583 | 2021-05-26 | 1175 | 249 | 284 | 28 | 2242 |
237 | 237 | 2022-05-07 | 1185 | 259 | 165 | 17 | 2187 |
236 | 236 | 2022-05-08 | 1190 | 263 | 173 | 20 | 2362 |
235 | 235 | 2022-05-09 | 1203 | 256 | 153 | 20 | 2391 |
273 | 273 | 2022-04-01 | 1209 | 280 | 222 | 21 | 2121 |
584 | 584 | 2021-05-25 | 1210 | 237 | 287 | 18 | 2339 |
585 | 585 | 2021-05-24 | 1222 | 244 | 297 | 26 | 2503 |
542 | 542 | 2021-07-06 | 1228 | 278 | 299 | 29 | 2555 |
234 | 234 | 2022-05-10 | 1246 | 251 | 148 | 21 | 2280 |
586 | 586 | 2021-05-23 | 1261 | 252 | 307 | 25 | 2437 |
274 | 274 | 2022-03-31 | 1270 | 273 | 220 | 19 | 2106 |
233 | 233 | 2022-05-11 | 1273 | 274 | 152 | 19 | 2334 |
587 | 587 | 2021-05-22 | 1276 | 280 | 306 | 26 | 2377 |
588 | 588 | 2021-05-21 | 1293 | 247 | 316 | 31 | 2303 |
1006 | 1006 | 2020-03-29 | 1306 | 2739 | 544 | 474 | 2423 |
541 | 541 | 2021-07-07 | 1319 | 250 | 318 | 16 | 2311 |
589 | 589 | 2021-05-20 | 1326 | 285 | 325 | 26 | 2249 |
232 | 232 | 2022-05-12 | 1339 | 274 | 162 | 18 | 2175 |
540 | 540 | 2021-07-08 | 1343 | 279 | 321 | 27 | 2247 |
275 | 275 | 2022-03-30 | 1352 | 257 | 246 | 16 | 2139 |
230 | 230 | 2022-05-14 | 1378 | 283 | 174 | 23 | 2188 |
593 | 593 | 2021-05-16 | 1379 | 310 | 328 | 36 | 2416 |
539 | 539 | 2021-07-09 | 1381 | 295 | 326 | 23 | 2206 |
591 | 591 | 2021-05-18 | 1387 | 270 | 342 | 35 | 2326 |
231 | 231 | 2022-05-13 | 1390 | 288 | 176 | 21 | 2160 |
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 );