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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|
101 | 101 | 2022-09-20 | 2184 | 337 | 275 | 34 | 2141 |
102 | 102 | 2022-09-19 | 2313 | 342 | 272 | 25 | 2257 |
103 | 103 | 2022-09-18 | 2319 | 354 | 284 | 22 | 2202 |
104 | 104 | 2022-09-17 | 2348 | 338 | 304 | 25 | 2214 |
105 | 105 | 2022-09-16 | 2548 | 324 | 313 | 28 | 2208 |
106 | 106 | 2022-09-15 | 2512 | 337 | 311 | 29 | 2097 |
107 | 107 | 2022-09-14 | 2580 | 344 | 316 | 30 | 1992 |
108 | 108 | 2022-09-13 | 2689 | 330 | 329 | 33 | 2039 |
109 | 109 | 2022-09-12 | 2768 | 331 | 346 | 29 | 2148 |
110 | 110 | 2022-09-11 | 2679 | 320 | 338 | 35 | 2193 |
111 | 111 | 2022-09-10 | 2694 | 351 | 333 | 30 | 2236 |
112 | 112 | 2022-09-09 | 2875 | 342 | 375 | 34 | 2022 |
113 | 113 | 2022-09-08 | 2865 | 348 | 370 | 35 | 2027 |
114 | 114 | 2022-09-07 | 2958 | 364 | 380 | 32 | 2067 |
115 | 115 | 2022-09-06 | 2983 | 351 | 381 | 47 | 2177 |
116 | 116 | 2022-09-05 | 2875 | 314 | 350 | 38 | 2230 |
117 | 117 | 2022-09-04 | 2803 | 303 | 352 | 34 | 2151 |
118 | 118 | 2022-09-03 | 2856 | 302 | 372 | 43 | 2085 |
119 | 119 | 2022-09-02 | 2957 | 315 | 351 | 43 | 1834 |
120 | 120 | 2022-09-01 | 3004 | 330 | 354 | 33 | 2134 |
121 | 121 | 2022-08-31 | 3047 | 352 | 377 | 41 | 1942 |
122 | 122 | 2022-08-30 | 3095 | 337 | 363 | 44 | 2135 |
123 | 123 | 2022-08-29 | 3103 | 319 | 351 | 39 | 2347 |
124 | 124 | 2022-08-28 | 2944 | 288 | 330 | 30 | 2012 |
125 | 125 | 2022-08-27 | 3010 | 302 | 362 | 29 | 2333 |
126 | 126 | 2022-08-26 | 3213 | 308 | 377 | 31 | 2174 |
127 | 127 | 2022-08-25 | 3137 | 280 | 373 | 33 | 1900 |
128 | 128 | 2022-08-24 | 3146 | 278 | 383 | 34 | 1912 |
129 | 129 | 2022-08-23 | 3481 | 347 | 416 | 34 | 2271 |
130 | 130 | 2022-08-22 | 3505 | 329 | 418 | 40 | 2375 |
131 | 131 | 2022-08-21 | 3405 | 323 | 418 | 39 | 2213 |
132 | 132 | 2022-08-20 | 3395 | 303 | 433 | 36 | 2242 |
133 | 133 | 2022-08-19 | 3554 | 325 | 420 | 38 | 2222 |
134 | 134 | 2022-08-18 | 3587 | 360 | 428 | 43 | 2196 |
135 | 135 | 2022-08-17 | 3719 | 340 | 450 | 38 | 2205 |
136 | 136 | 2022-08-16 | 3779 | 359 | 462 | 34 | 2251 |
137 | 137 | 2022-08-15 | 3811 | 333 | 448 | 36 | 2408 |
138 | 138 | 2022-08-14 | 3774 | 335 | 439 | 46 | 2315 |
139 | 139 | 2022-08-13 | 3762 | 345 | 428 | 45 | 2157 |
140 | 140 | 2022-08-12 | 3941 | 354 | 457 | 41 | 2137 |
141 | 141 | 2022-08-11 | 3988 | 318 | 457 | 36 | 2182 |
142 | 142 | 2022-08-10 | 4030 | 379 | 484 | 41 | 2175 |
143 | 143 | 2022-08-09 | 4100 | 338 | 491 | 32 | 2233 |
144 | 144 | 2022-08-08 | 4228 | 326 | 474 | 35 | 2356 |
145 | 145 | 2022-08-07 | 4166 | 350 | 473 | 36 | 2222 |
146 | 146 | 2022-08-06 | 4218 | 353 | 472 | 40 | 2091 |
147 | 147 | 2022-08-05 | 4368 | 362 | 508 | 32 | 2073 |
148 | 148 | 2022-08-04 | 4435 | 348 | 505 | 34 | 2147 |
149 | 149 | 2022-08-03 | 4551 | 324 | 522 | 31 | 2181 |
150 | 150 | 2022-08-02 | 4605 | 367 | 543 | 22 | 2221 |
151 | 151 | 2022-08-01 | 4654 | 325 | 535 | 30 | 2340 |
152 | 152 | 2022-07-31 | 4539 | 321 | 518 | 37 | 2218 |
153 | 153 | 2022-07-30 | 4525 | 355 | 522 | 41 | 2187 |
154 | 154 | 2022-07-29 | 4601 | 389 | 552 | 44 | 2103 |
155 | 155 | 2022-07-28 | 4672 | 343 | 546 | 48 | 2110 |
156 | 156 | 2022-07-27 | 4749 | 365 | 571 | 36 | 2085 |
157 | 157 | 2022-07-26 | 4843 | 338 | 543 | 42 | 2184 |
158 | 158 | 2022-07-25 | 4826 | 308 | 516 | 36 | 2286 |
159 | 159 | 2022-07-24 | 4642 | 356 | 497 | 39 | 2300 |
160 | 160 | 2022-07-23 | 4635 | 376 | 513 | 46 | 2143 |
161 | 161 | 2022-07-22 | 4626 | 350 | 515 | 41 | 2239 |
162 | 162 | 2022-07-21 | 4711 | 362 | 552 | 32 | 2181 |
163 | 163 | 2022-07-20 | 4762 | 416 | 550 | 43 | 2181 |
164 | 164 | 2022-07-19 | 4790 | 391 | 543 | 38 | 2233 |
165 | 165 | 2022-07-18 | 4676 | 382 | 528 | 39 | 2299 |
166 | 166 | 2022-07-17 | 4528 | 378 | 513 | 41 | 2227 |
167 | 167 | 2022-07-16 | 4490 | 396 | 499 | 45 | 2209 |
168 | 168 | 2022-07-15 | 4489 | 404 | 507 | 40 | 2138 |
169 | 169 | 2022-07-14 | 4432 | 381 | 481 | 39 | 2123 |
170 | 170 | 2022-07-13 | 4397 | 385 | 487 | 29 | 2178 |
171 | 171 | 2022-07-12 | 4377 | 427 | 490 | 34 | 2177 |
172 | 172 | 2022-07-11 | 4277 | 392 | 453 | 40 | 2262 |
173 | 173 | 2022-07-10 | 4126 | 406 | 456 | 49 | 2192 |
174 | 174 | 2022-07-09 | 4095 | 406 | 492 | 43 | 2209 |
175 | 175 | 2022-07-08 | 4024 | 426 | 457 | 53 | 2129 |
176 | 176 | 2022-07-07 | 4009 | 388 | 445 | 38 | 2112 |
177 | 177 | 2022-07-06 | 3865 | 423 | 429 | 48 | 2238 |
178 | 178 | 2022-07-05 | 3749 | 348 | 417 | 42 | 2351 |
179 | 179 | 2022-07-04 | 3560 | 352 | 393 | 45 | 2278 |
180 | 180 | 2022-07-03 | 3496 | 387 | 394 | 51 | 2205 |
181 | 181 | 2022-07-02 | 3475 | 398 | 395 | 43 | 2084 |
182 | 182 | 2022-07-01 | 3474 | 407 | 392 | 39 | 2121 |
183 | 183 | 2022-06-30 | 3467 | 398 | 372 | 40 | 2110 |
184 | 184 | 2022-06-29 | 3519 | 369 | 363 | 32 | 2183 |
185 | 185 | 2022-06-28 | 3411 | 360 | 347 | 61 | 2286 |
186 | 186 | 2022-06-27 | 3345 | 369 | 339 | 39 | 2377 |
187 | 187 | 2022-06-26 | 3231 | 376 | 318 | 36 | 2379 |
188 | 188 | 2022-06-25 | 3177 | 353 | 320 | 30 | 2355 |
189 | 189 | 2022-06-24 | 3169 | 365 | 331 | 25 | 2248 |
190 | 190 | 2022-06-23 | 3126 | 333 | 325 | 21 | 2229 |
191 | 191 | 2022-06-22 | 2993 | 368 | 324 | 33 | 2212 |
192 | 192 | 2022-06-21 | 2905 | 360 | 305 | 36 | 2274 |
193 | 193 | 2022-06-20 | 2862 | 347 | 310 | 30 | 2372 |
194 | 194 | 2022-06-19 | 2781 | 322 | 295 | 36 | 2353 |
195 | 195 | 2022-06-18 | 2746 | 316 | 294 | 35 | 2231 |
196 | 196 | 2022-06-17 | 2762 | 345 | 300 | 44 | 2169 |
197 | 197 | 2022-06-16 | 2741 | 354 | 319 | 42 | 2220 |
198 | 198 | 2022-06-15 | 2808 | 358 | 310 | 48 | 2266 |
199 | 199 | 2022-06-14 | 2796 | 335 | 298 | 46 | 2341 |
200 | 200 | 2022-06-13 | 2762 | 355 | 291 | 48 | 2379 |
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 );