la_times_cdph_hospital_patient_county_totals
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_hospital_patient_county_totals
56,333 rows sorted by icu_positive_patients descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | positive_patients | suspected_patients | icu_positive_patients ▲ | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
5999 | 5999 | 2022-09-13 | Del Norte | 15 | 3 | 2 | |||
6041 | 6041 | 2022-09-13 | Sutter | 101 | 0 | ||||
54929 | 54929 | 2020-04-23 | Sutter | 101 | 0 | 0 | 0 | ||
54985 | 54985 | 2020-04-22 | Sutter | 101 | 0 | 0 | |||
55041 | 55041 | 2020-04-21 | Sutter | 101 | 0 | 0 | |||
55097 | 55097 | 2020-04-20 | Sutter | 101 | 0 | 0 | |||
55153 | 55153 | 2020-04-19 | Sutter | 101 | 0 | 0 | |||
55209 | 55209 | 2020-04-18 | Sutter | 101 | 0 | 0 | |||
55265 | 55265 | 2020-04-17 | Sutter | 101 | 0 | 0 | |||
55321 | 55321 | 2020-04-16 | Sutter | 101 | 0 | 0 | |||
55377 | 55377 | 2020-04-15 | Sutter | 101 | 0 | 0 | |||
55433 | 55433 | 2020-04-14 | Sutter | 101 | 0 | 0 | |||
55489 | 55489 | 2020-04-13 | Sutter | 101 | 0 | 0 | |||
55545 | 55545 | 2020-04-12 | Sutter | 101 | 0 | 0 | |||
55601 | 55601 | 2020-04-11 | Sutter | 101 | 0 | 0 | |||
55657 | 55657 | 2020-04-10 | Sutter | 101 | 0 | 0 | |||
55713 | 55713 | 2020-04-09 | Sutter | 101 | 0 | 0 | |||
55769 | 55769 | 2020-04-08 | Sutter | 101 | 0 | 0 | |||
55825 | 55825 | 2020-04-07 | Sutter | 101 | 0 | 0 | |||
55881 | 55881 | 2020-04-06 | Sutter | 101 | 0 | 0 | |||
55993 | 55993 | 2020-04-04 | Sutter | 101 | 0 | 0 | |||
56049 | 56049 | 2020-04-03 | Sutter | 101 | 0 | 0 | |||
56105 | 56105 | 2020-04-02 | Sutter | 101 | 0 | 0 | |||
56122 | 56122 | 2020-04-01 | Glenn | 21 | |||||
56236 | 56236 | 2020-03-30 | Inyo | 27 | |||||
56281 | 56281 | 2020-03-29 | Butte | 7 | |||||
56282 | 56282 | 2020-03-29 | Calaveras | 9 | |||||
56283 | 56283 | 2020-03-29 | Colusa | 11 | |||||
56288 | 56288 | 2020-03-29 | Glenn | 21 | |||||
56291 | 56291 | 2020-03-29 | Inyo | 27 | |||||
56304 | 56304 | 2020-03-29 | Napa | 55 | 0 | 26 | 5 | ||
40338 | 40338 | 2021-01-08 | Los Angeles | 37 | 7964 | 289 | 1731 | 25 | 306 |
39834 | 39834 | 2021-01-17 | Los Angeles | 37 | 7322 | 302 | 1728 | 39 | 263 |
40170 | 40170 | 2021-01-11 | Los Angeles | 37 | 7949 | 330 | 1725 | 37 | 339 |
40226 | 40226 | 2021-01-10 | Los Angeles | 37 | 7926 | 344 | 1724 | 35 | 340 |
39890 | 39890 | 2021-01-16 | Los Angeles | 37 | 7328 | 296 | 1720 | 30 | 281 |
40394 | 40394 | 2021-01-07 | Los Angeles | 37 | 7966 | 327 | 1714 | 27 | 305 |
40282 | 40282 | 2021-01-09 | Los Angeles | 37 | 7910 | 280 | 1712 | 39 | 319 |
39946 | 39946 | 2021-01-15 | Los Angeles | 37 | 7498 | 328 | 1709 | 38 | 286 |
40114 | 40114 | 2021-01-12 | Los Angeles | 37 | 7906 | 295 | 1699 | 28 | 376 |
39778 | 39778 | 2021-01-18 | Los Angeles | 37 | 7253 | 347 | 1693 | 43 | 290 |
39722 | 39722 | 2021-01-19 | Los Angeles | 37 | 7263 | 308 | 1692 | 29 | 296 |
39666 | 39666 | 2021-01-20 | Los Angeles | 37 | 7073 | 340 | 1687 | 30 | 236 |
40058 | 40058 | 2021-01-13 | Los Angeles | 37 | 7715 | 371 | 1677 | 40 | 319 |
40002 | 40002 | 2021-01-14 | Los Angeles | 37 | 7597 | 300 | 1675 | 25 | 297 |
40450 | 40450 | 2021-01-06 | Los Angeles | 37 | 8074 | 311 | 1665 | 36 | 328 |
39610 | 39610 | 2021-01-21 | Los Angeles | 37 | 6881 | 345 | 1654 | 26 | 274 |
40562 | 40562 | 2021-01-04 | Los Angeles | 37 | 8023 | 295 | 1642 | 27 | 338 |
40506 | 40506 | 2021-01-05 | Los Angeles | 37 | 8098 | 324 | 1628 | 40 | 313 |
40618 | 40618 | 2021-01-03 | Los Angeles | 37 | 7898 | 305 | 1627 | 31 | 326 |
39554 | 39554 | 2021-01-22 | Los Angeles | 37 | 6697 | 317 | 1619 | 25 | 281 |
39498 | 39498 | 2021-01-23 | Los Angeles | 37 | 6486 | 307 | 1600 | 29 | 299 |
40786 | 40786 | 2020-12-31 | Los Angeles | 37 | 7627 | 270 | 1600 | 36 | 324 |
40674 | 40674 | 2021-01-02 | Los Angeles | 37 | 7697 | 274 | 1599 | 39 | 327 |
40730 | 40730 | 2021-01-01 | Los Angeles | 37 | 7544 | 280 | 1587 | 27 | 325 |
40842 | 40842 | 2020-12-30 | Los Angeles | 37 | 7628 | 300 | 1580 | 40 | 320 |
39442 | 39442 | 2021-01-24 | Los Angeles | 37 | 6307 | 299 | 1565 | 22 | 295 |
39386 | 39386 | 2021-01-25 | Los Angeles | 37 | 6213 | 287 | 1551 | 21 | 302 |
39330 | 39330 | 2021-01-26 | Los Angeles | 37 | 6026 | 345 | 1542 | 30 | 315 |
40898 | 40898 | 2020-12-29 | Los Angeles | 37 | 7546 | 279 | 1528 | 42 | 330 |
39274 | 39274 | 2021-01-27 | Los Angeles | 37 | 5855 | 355 | 1503 | 25 | 314 |
39218 | 39218 | 2021-01-28 | Los Angeles | 37 | 5669 | 372 | 1498 | 29 | 272 |
40954 | 40954 | 2020-12-28 | Los Angeles | 37 | 7415 | 297 | 1496 | 34 | 356 |
39162 | 39162 | 2021-01-29 | Los Angeles | 37 | 5511 | 325 | 1479 | 35 | 282 |
39106 | 39106 | 2021-01-30 | Los Angeles | 37 | 5398 | 320 | 1461 | 41 | 299 |
41010 | 41010 | 2020-12-27 | Los Angeles | 37 | 7181 | 332 | 1449 | 65 | 384 |
39050 | 39050 | 2021-01-31 | Los Angeles | 37 | 5259 | 300 | 1415 | 36 | 327 |
41066 | 41066 | 2020-12-26 | Los Angeles | 37 | 6914 | 303 | 1404 | 35 | 424 |
38994 | 38994 | 2021-02-01 | Los Angeles | 37 | 5165 | 278 | 1371 | 38 | 340 |
41122 | 41122 | 2020-12-25 | Los Angeles | 37 | 6815 | 309 | 1368 | 41 | 363 |
38938 | 38938 | 2021-02-02 | Los Angeles | 37 | 4990 | 314 | 1354 | 43 | 319 |
41178 | 41178 | 2020-12-24 | Los Angeles | 37 | 6770 | 286 | 1335 | 27 | 364 |
38882 | 38882 | 2021-02-03 | Los Angeles | 37 | 4796 | 346 | 1333 | 53 | 313 |
41234 | 41234 | 2020-12-23 | Los Angeles | 37 | 6708 | 292 | 1329 | 35 | 355 |
41290 | 41290 | 2020-12-22 | Los Angeles | 37 | 6499 | 321 | 1280 | 46 | 386 |
38826 | 38826 | 2021-02-04 | Los Angeles | 37 | 4607 | 319 | 1276 | 31 | 332 |
38770 | 38770 | 2021-02-05 | Los Angeles | 37 | 4421 | 338 | 1275 | 36 | 287 |
41346 | 41346 | 2020-12-21 | Los Angeles | 37 | 6155 | 305 | 1234 | 34 | 373 |
38714 | 38714 | 2021-02-06 | Los Angeles | 37 | 4186 | 306 | 1214 | 31 | 277 |
41402 | 41402 | 2020-12-20 | Los Angeles | 37 | 5866 | 358 | 1202 | 31 | 354 |
38658 | 38658 | 2021-02-07 | Los Angeles | 37 | 4079 | 255 | 1193 | 27 | 318 |
41458 | 41458 | 2020-12-19 | Los Angeles | 37 | 5709 | 309 | 1175 | 23 | 328 |
38602 | 38602 | 2021-02-08 | Los Angeles | 37 | 3973 | 267 | 1159 | 45 | 307 |
41514 | 41514 | 2020-12-18 | Los Angeles | 37 | 5549 | 323 | 1156 | 25 | 308 |
41570 | 41570 | 2020-12-17 | Los Angeles | 37 | 5424 | 339 | 1115 | 29 | 316 |
38546 | 38546 | 2021-02-09 | Los Angeles | 37 | 3772 | 312 | 1105 | 41 | 331 |
38490 | 38490 | 2021-02-10 | Los Angeles | 37 | 3614 | 256 | 1067 | 27 | 337 |
41626 | 41626 | 2020-12-16 | Los Angeles | 37 | 5100 | 366 | 1035 | 36 | 338 |
38434 | 38434 | 2021-02-11 | Los Angeles | 37 | 3415 | 223 | 1032 | 22 | 349 |
41682 | 41682 | 2020-12-15 | Los Angeles | 37 | 4864 | 344 | 991 | 35 | 369 |
38378 | 38378 | 2021-02-12 | Los Angeles | 37 | 3270 | 196 | 990 | 25 | 333 |
41738 | 41738 | 2020-12-14 | Los Angeles | 37 | 4656 | 314 | 988 | 38 | 390 |
41794 | 41794 | 2020-12-13 | Los Angeles | 37 | 4403 | 372 | 935 | 52 | 404 |
38322 | 38322 | 2021-02-13 | Los Angeles | 37 | 3092 | 201 | 930 | 33 | 379 |
38266 | 38266 | 2021-02-14 | Los Angeles | 37 | 2964 | 200 | 908 | 40 | 360 |
41850 | 41850 | 2020-12-12 | Los Angeles | 37 | 4203 | 365 | 883 | 53 | 392 |
38210 | 38210 | 2021-02-15 | Los Angeles | 37 | 2855 | 189 | 876 | 43 | 382 |
38154 | 38154 | 2021-02-16 | Los Angeles | 37 | 2757 | 223 | 859 | 37 | 391 |
41962 | 41962 | 2020-12-10 | Los Angeles | 37 | 3850 | 323 | 856 | 38 | 440 |
41906 | 41906 | 2020-12-11 | Los Angeles | 37 | 4009 | 353 | 845 | 47 | 444 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_hospital_patient_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );