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_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 |
---|---|---|---|---|---|---|---|
286 | 286 | 2022-03-19 | 1900 | 261 | 316 | 15 | 2073 |
275 | 275 | 2022-03-30 | 1352 | 257 | 246 | 16 | 2139 |
285 | 285 | 2022-03-20 | 1833 | 246 | 305 | 16 | 2181 |
541 | 541 | 2021-07-07 | 1319 | 250 | 318 | 16 | 2311 |
218 | 218 | 2022-05-26 | 2056 | 316 | 244 | 17 | 2111 |
237 | 237 | 2022-05-07 | 1185 | 259 | 165 | 17 | 2187 |
550 | 550 | 2021-06-28 | 1050 | 222 | 288 | 17 | 2472 |
232 | 232 | 2022-05-12 | 1339 | 274 | 162 | 18 | 2175 |
584 | 584 | 2021-05-25 | 1210 | 237 | 287 | 18 | 2339 |
233 | 233 | 2022-05-11 | 1273 | 274 | 152 | 19 | 2334 |
239 | 239 | 2022-05-05 | 1123 | 256 | 168 | 19 | 2158 |
274 | 274 | 2022-03-31 | 1270 | 273 | 220 | 19 | 2106 |
551 | 551 | 2021-06-27 | 980 | 255 | 290 | 19 | 2423 |
235 | 235 | 2022-05-09 | 1203 | 256 | 153 | 20 | 2391 |
236 | 236 | 2022-05-08 | 1190 | 263 | 173 | 20 | 2362 |
257 | 257 | 2022-04-17 | 963 | 271 | 145 | 20 | 2306 |
270 | 270 | 2022-04-04 | 1154 | 244 | 211 | 20 | 2377 |
271 | 271 | 2022-04-03 | 1130 | 291 | 223 | 20 | 2250 |
456 | 456 | 2021-09-30 | 4880 | 343 | 1382 | 20 | 1804 |
90 | 90 | 2022-10-01 | 1803 | 286 | 231 | 21 | 2106 |
190 | 190 | 2022-06-23 | 3126 | 333 | 325 | 21 | 2229 |
231 | 231 | 2022-05-13 | 1390 | 288 | 176 | 21 | 2160 |
234 | 234 | 2022-05-10 | 1246 | 251 | 148 | 21 | 2280 |
268 | 268 | 2022-04-06 | 1126 | 292 | 193 | 21 | 2199 |
269 | 269 | 2022-04-05 | 1138 | 282 | 202 | 21 | 2195 |
273 | 273 | 2022-04-01 | 1209 | 280 | 222 | 21 | 2121 |
548 | 548 | 2021-06-30 | 1090 | 258 | 300 | 21 | 2244 |
564 | 564 | 2021-06-14 | 977 | 274 | 251 | 21 | 2588 |
103 | 103 | 2022-09-18 | 2319 | 354 | 284 | 22 | 2202 |
150 | 150 | 2022-08-02 | 4605 | 367 | 543 | 22 | 2221 |
283 | 283 | 2022-03-22 | 1774 | 284 | 299 | 22 | 2207 |
545 | 545 | 2021-07-03 | 1097 | 274 | 288 | 22 | 2287 |
547 | 547 | 2021-07-01 | 1071 | 295 | 295 | 22 | 2212 |
549 | 549 | 2021-06-29 | 1089 | 261 | 307 | 22 | 2298 |
559 | 559 | 2021-06-19 | 916 | 300 | 230 | 22 | 2328 |
230 | 230 | 2022-05-14 | 1378 | 283 | 174 | 23 | 2188 |
240 | 240 | 2022-05-04 | 1083 | 245 | 168 | 23 | 2171 |
282 | 282 | 2022-03-23 | 1699 | 269 | 285 | 23 | 2068 |
287 | 287 | 2022-03-18 | 1960 | 302 | 325 | 23 | 2017 |
401 | 401 | 2021-11-24 | 3126 | 313 | 863 | 23 | 1842 |
539 | 539 | 2021-07-09 | 1381 | 295 | 326 | 23 | 2206 |
554 | 554 | 2021-06-24 | 959 | 269 | 269 | 23 | 2306 |
561 | 561 | 2021-06-17 | 951 | 245 | 233 | 23 | 2255 |
565 | 565 | 2021-06-13 | 939 | 252 | 239 | 23 | 2439 |
582 | 582 | 2021-05-27 | 1161 | 246 | 272 | 23 | 2229 |
95 | 95 | 2022-09-26 | 2048 | 328 | 230 | 24 | 2290 |
207 | 207 | 2022-06-06 | 2581 | 328 | 276 | 24 | 2311 |
241 | 241 | 2022-05-03 | 1109 | 268 | 142 | 24 | 2220 |
276 | 276 | 2022-03-29 | 1391 | 244 | 246 | 24 | 2216 |
277 | 277 | 2022-03-28 | 1414 | 259 | 264 | 24 | 2308 |
278 | 278 | 2022-03-27 | 1470 | 241 | 261 | 24 | 2185 |
284 | 284 | 2022-03-21 | 1850 | 246 | 313 | 24 | 2258 |
445 | 445 | 2021-10-11 | 3958 | 296 | 1084 | 24 | 2114 |
80 | 80 | 2022-10-11 | 1759 | 282 | 218 | 25 | 2223 |
91 | 91 | 2022-09-30 | 1903 | 302 | 235 | 25 | 2085 |
102 | 102 | 2022-09-19 | 2313 | 342 | 272 | 25 | 2257 |
104 | 104 | 2022-09-17 | 2348 | 338 | 304 | 25 | 2214 |
189 | 189 | 2022-06-24 | 3169 | 365 | 331 | 25 | 2248 |
213 | 213 | 2022-05-31 | 2281 | 344 | 242 | 25 | 2297 |
229 | 229 | 2022-05-15 | 1409 | 297 | 191 | 25 | 2254 |
238 | 238 | 2022-05-06 | 1151 | 274 | 162 | 25 | 2210 |
245 | 245 | 2022-04-29 | 1035 | 295 | 140 | 25 | 2257 |
267 | 267 | 2022-04-07 | 1098 | 288 | 190 | 25 | 2206 |
407 | 407 | 2021-11-18 | 3313 | 283 | 926 | 25 | 1768 |
553 | 553 | 2021-06-25 | 959 | 259 | 266 | 25 | 2320 |
586 | 586 | 2021-05-23 | 1261 | 252 | 307 | 25 | 2437 |
590 | 590 | 2021-05-19 | 1394 | 277 | 346 | 25 | 2254 |
212 | 212 | 2022-06-01 | 2329 | 317 | 272 | 26 | 2190 |
243 | 243 | 2022-05-01 | 1052 | 294 | 148 | 26 | 2351 |
244 | 244 | 2022-04-30 | 1037 | 286 | 146 | 26 | 2313 |
249 | 249 | 2022-04-25 | 950 | 274 | 112 | 26 | 2399 |
266 | 266 | 2022-04-08 | 1064 | 297 | 175 | 26 | 2176 |
294 | 294 | 2022-03-11 | 2497 | 293 | 469 | 26 | 2075 |
404 | 404 | 2021-11-21 | 3174 | 291 | 876 | 26 | 1918 |
431 | 431 | 2021-10-25 | 3791 | 326 | 976 | 26 | 2003 |
463 | 463 | 2021-09-23 | 5782 | 352 | 1633 | 26 | 1618 |
535 | 535 | 2021-07-13 | 1648 | 287 | 359 | 26 | 2180 |
552 | 552 | 2021-06-26 | 964 | 263 | 283 | 26 | 2323 |
563 | 563 | 2021-06-15 | 981 | 275 | 242 | 26 | 2443 |
585 | 585 | 2021-05-24 | 1222 | 244 | 297 | 26 | 2503 |
587 | 587 | 2021-05-22 | 1276 | 280 | 306 | 26 | 2377 |
589 | 589 | 2021-05-20 | 1326 | 285 | 325 | 26 | 2249 |
88 | 88 | 2022-10-03 | 1894 | 299 | 247 | 27 | 2303 |
89 | 89 | 2022-10-02 | 1889 | 320 | 254 | 27 | 2279 |
92 | 92 | 2022-09-29 | 1930 | 420 | 242 | 27 | 2217 |
250 | 250 | 2022-04-24 | 967 | 287 | 119 | 27 | 2352 |
292 | 292 | 2022-03-13 | 2299 | 264 | 443 | 27 | 2239 |
381 | 381 | 2021-12-14 | 3613 | 339 | 929 | 27 | 1725 |
415 | 415 | 2021-11-10 | 3665 | 334 | 968 | 27 | 1776 |
454 | 454 | 2021-10-02 | 4580 | 287 | 1320 | 27 | 1846 |
486 | 486 | 2021-08-31 | 8353 | 413 | 2096 | 27 | 1603 |
540 | 540 | 2021-07-08 | 1343 | 279 | 321 | 27 | 2247 |
546 | 546 | 2021-07-02 | 1115 | 290 | 286 | 27 | 2253 |
569 | 569 | 2021-06-09 | 1001 | 278 | 234 | 27 | 2262 |
93 | 93 | 2022-09-28 | 2001 | 291 | 238 | 28 | 2160 |
94 | 94 | 2022-09-27 | 1999 | 337 | 243 | 28 | 2255 |
105 | 105 | 2022-09-16 | 2548 | 324 | 313 | 28 | 2208 |
217 | 217 | 2022-05-27 | 2111 | 297 | 263 | 28 | 2033 |
220 | 220 | 2022-05-24 | 1961 | 334 | 224 | 28 | 2130 |
228 | 228 | 2022-05-16 | 1527 | 297 | 182 | 28 | 2337 |
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 );