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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
37577 | 37577 | 2021-02-26 | Alameda | 1 | 157 | 24 | 42 | 2 | 101 |
37578 | 37578 | 2021-02-26 | Amador | 5 | 3 | 0 | 0 | 0 | 1 |
37579 | 37579 | 2021-02-26 | Butte | 7 | 15 | 0 | 2 | 0 | 4 |
37580 | 37580 | 2021-02-26 | Calaveras | 9 | 1 | 0 | 1 | 0 | 4 |
37581 | 37581 | 2021-02-26 | Colusa | 11 | 0 | 0 | 0 | 0 | 5 |
37582 | 37582 | 2021-02-26 | Contra Costa | 13 | 72 | 11 | 29 | 2 | 47 |
37583 | 37583 | 2021-02-26 | Del Norte | 15 | 1 | 0 | 0 | 0 | 0 |
37584 | 37584 | 2021-02-26 | El Dorado | 17 | 6 | 0 | 1 | 0 | 6 |
37585 | 37585 | 2021-02-26 | Fresno | 19 | 207 | 20 | 48 | 2 | 16 |
37586 | 37586 | 2021-02-26 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
37587 | 37587 | 2021-02-26 | Humboldt | 23 | 6 | 2 | 0 | 1 | 9 |
37588 | 37588 | 2021-02-26 | Imperial | 25 | 22 | 0 | 8 | 0 | 5 |
37589 | 37589 | 2021-02-26 | Inyo | 27 | 2 | 0 | 0 | 0 | 2 |
37590 | 37590 | 2021-02-26 | Kern | 29 | 158 | 4 | 52 | 0 | 24 |
37591 | 37591 | 2021-02-26 | Kings | 31 | 34 | 0 | 6 | 0 | 0 |
37592 | 37592 | 2021-02-26 | Lake | 33 | 3 | 0 | 1 | 0 | 5 |
37593 | 37593 | 2021-02-26 | Lassen | 35 | 1 | 0 | 0 | 0 | 0 |
37594 | 37594 | 2021-02-26 | Los Angeles | 37 | 1661 | 194 | 533 | 32 | 461 |
37595 | 37595 | 2021-02-26 | Madera | 39 | 29 | 7 | 12 | 0 | 6 |
37596 | 37596 | 2021-02-26 | Marin | 41 | 15 | 2 | 5 | 1 | 16 |
37597 | 37597 | 2021-02-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
37598 | 37598 | 2021-02-26 | Mendocino | 45 | 5 | 0 | 3 | 0 | 4 |
37599 | 37599 | 2021-02-26 | Merced | 47 | 33 | 0 | 6 | 0 | 8 |
37600 | 37600 | 2021-02-26 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
37601 | 37601 | 2021-02-26 | Mono | 51 | 1 | 0 | 0 | 0 | 2 |
37602 | 37602 | 2021-02-26 | Monterey | 53 | 40 | 1 | 9 | 0 | 12 |
37603 | 37603 | 2021-02-26 | Napa | 55 | 7 | 3 | 2 | 0 | 47 |
37604 | 37604 | 2021-02-26 | Nevada | 57 | 2 | 2 | 1 | 0 | 3 |
37605 | 37605 | 2021-02-26 | Orange | 59 | 444 | 15 | 128 | 2 | 249 |
37606 | 37606 | 2021-02-26 | Placer | 61 | 52 | 10 | 18 | 2 | 15 |
37607 | 37607 | 2021-02-26 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
37608 | 37608 | 2021-02-26 | Riverside | 65 | 338 | 57 | 87 | 5 | 60 |
37609 | 37609 | 2021-02-26 | Sacramento | 67 | 177 | 17 | 49 | 4 | 71 |
37610 | 37610 | 2021-02-26 | San Benito | 69 | 6 | 0 | 4 | 0 | 0 |
37611 | 37611 | 2021-02-26 | San Bernardino | 71 | 327 | 23 | 85 | 4 | 116 |
37612 | 37612 | 2021-02-26 | San Diego | 73 | 523 | 39 | 167 | 6 | 222 |
37613 | 37613 | 2021-02-26 | San Francisco | 75 | 83 | 5 | 24 | 1 | 66 |
37614 | 37614 | 2021-02-26 | San Joaquin | 77 | 109 | 7 | 39 | 2 | 6 |
37615 | 37615 | 2021-02-26 | San Luis Obispo | 79 | 18 | 1 | 2 | 0 | 21 |
37616 | 37616 | 2021-02-26 | San Mateo | 81 | 54 | 3 | 16 | 3 | 12 |
37617 | 37617 | 2021-02-26 | Santa Barbara | 83 | 74 | 6 | 18 | 1 | 28 |
37618 | 37618 | 2021-02-26 | Santa Clara | 85 | 194 | 25 | 62 | 0 | 68 |
37619 | 37619 | 2021-02-26 | Santa Cruz | 87 | 16 | 2 | 1 | 0 | 7 |
37620 | 37620 | 2021-02-26 | Shasta | 89 | 18 | 1 | 4 | 0 | 17 |
37621 | 37621 | 2021-02-26 | Siskiyou | 93 | 3 | 0 | 0 | 0 | 3 |
37622 | 37622 | 2021-02-26 | Solano | 95 | 45 | 12 | 14 | 0 | 13 |
37623 | 37623 | 2021-02-26 | Sonoma | 97 | 35 | 1 | 12 | 0 | 14 |
37624 | 37624 | 2021-02-26 | Stanislaus | 99 | 128 | 14 | 31 | 1 | 19 |
37625 | 37625 | 2021-02-26 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
37626 | 37626 | 2021-02-26 | Tehama | 103 | 3 | 0 | 0 | 0 | 3 |
37627 | 37627 | 2021-02-26 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
37628 | 37628 | 2021-02-26 | Tulare | 107 | 69 | 8 | 9 | 0 | 21 |
37629 | 37629 | 2021-02-26 | Tuolumne | 109 | 2 | 0 | 0 | 0 | 0 |
37630 | 37630 | 2021-02-26 | Ventura | 111 | 144 | 9 | 38 | 2 | 44 |
37631 | 37631 | 2021-02-26 | Yolo | 113 | 11 | 0 | 4 | 0 | 4 |
37632 | 37632 | 2021-02-26 | Yuba | 115 | 18 | 0 | 5 | 0 | 1 |
37633 | 37633 | 2021-02-25 | Alameda | 1 | 168 | 19 | 46 | 1 | 87 |
37634 | 37634 | 2021-02-25 | Amador | 5 | 3 | 1 | 0 | 1 | 2 |
37635 | 37635 | 2021-02-25 | Butte | 7 | 13 | 0 | 2 | 0 | 5 |
37636 | 37636 | 2021-02-25 | Calaveras | 9 | 1 | 0 | 0 | 0 | 5 |
37637 | 37637 | 2021-02-25 | Colusa | 11 | 1 | 0 | 0 | 0 | 5 |
37638 | 37638 | 2021-02-25 | Contra Costa | 13 | 74 | 14 | 30 | 0 | 45 |
37639 | 37639 | 2021-02-25 | Del Norte | 15 | 1 | 0 | 0 | 0 | 1 |
37640 | 37640 | 2021-02-25 | El Dorado | 17 | 5 | 0 | 2 | 0 | 6 |
37641 | 37641 | 2021-02-25 | Fresno | 19 | 218 | 17 | 48 | 1 | 18 |
37642 | 37642 | 2021-02-25 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
37643 | 37643 | 2021-02-25 | Humboldt | 23 | 8 | 2 | 0 | 0 | 6 |
37644 | 37644 | 2021-02-25 | Imperial | 25 | 25 | 0 | 8 | 0 | 4 |
37645 | 37645 | 2021-02-25 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
37646 | 37646 | 2021-02-25 | Kern | 29 | 162 | 1 | 54 | 0 | 24 |
37647 | 37647 | 2021-02-25 | Kings | 31 | 39 | 0 | 7 | 0 | 7 |
37648 | 37648 | 2021-02-25 | Lake | 33 | 4 | 1 | 1 | 0 | 5 |
37649 | 37649 | 2021-02-25 | Lassen | 35 | 1 | 0 | 0 | 0 | 0 |
37650 | 37650 | 2021-02-25 | Los Angeles | 37 | 1733 | 229 | 550 | 39 | 474 |
37651 | 37651 | 2021-02-25 | Madera | 39 | 33 | 5 | 8 | 0 | 8 |
37652 | 37652 | 2021-02-25 | Marin | 41 | 13 | 2 | 4 | 1 | 15 |
37653 | 37653 | 2021-02-25 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
37654 | 37654 | 2021-02-25 | Mendocino | 45 | 5 | 0 | 3 | 0 | 2 |
37655 | 37655 | 2021-02-25 | Merced | 47 | 35 | 0 | 6 | 0 | 8 |
37656 | 37656 | 2021-02-25 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
37657 | 37657 | 2021-02-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
37658 | 37658 | 2021-02-25 | Monterey | 53 | 38 | 1 | 9 | 0 | 17 |
37659 | 37659 | 2021-02-25 | Napa | 55 | 8 | 1 | 3 | 0 | 1 |
37660 | 37660 | 2021-02-25 | Nevada | 57 | 2 | 2 | 1 | 0 | 2 |
37661 | 37661 | 2021-02-25 | Orange | 59 | 453 | 22 | 137 | 5 | 234 |
37662 | 37662 | 2021-02-25 | Placer | 61 | 56 | 17 | 18 | 4 | 16 |
37663 | 37663 | 2021-02-25 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
37664 | 37664 | 2021-02-25 | Riverside | 65 | 361 | 63 | 96 | 9 | 54 |
37665 | 37665 | 2021-02-25 | Sacramento | 67 | 177 | 16 | 50 | 2 | 73 |
37666 | 37666 | 2021-02-25 | San Benito | 69 | 6 | 0 | 4 | 0 | 0 |
37667 | 37667 | 2021-02-25 | San Bernardino | 71 | 352 | 26 | 91 | 3 | 110 |
37668 | 37668 | 2021-02-25 | San Diego | 73 | 535 | 26 | 173 | 2 | 217 |
37669 | 37669 | 2021-02-25 | San Francisco | 75 | 94 | 1 | 27 | 0 | 74 |
37670 | 37670 | 2021-02-25 | San Joaquin | 77 | 117 | 14 | 40 | 7 | 6 |
37671 | 37671 | 2021-02-25 | San Luis Obispo | 79 | 18 | 1 | 2 | 0 | 21 |
37672 | 37672 | 2021-02-25 | San Mateo | 81 | 54 | 2 | 16 | 0 | 17 |
37673 | 37673 | 2021-02-25 | Santa Barbara | 83 | 76 | 5 | 18 | 1 | 27 |
37674 | 37674 | 2021-02-25 | Santa Clara | 85 | 192 | 27 | 66 | 2 | 51 |
37675 | 37675 | 2021-02-25 | Santa Cruz | 87 | 17 | 1 | 2 | 0 | 10 |
37676 | 37676 | 2021-02-25 | Shasta | 89 | 18 | 1 | 4 | 0 | 17 |
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 );