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 |
---|---|---|---|---|---|---|---|---|---|
19601 | 19601 | 2022-01-13 | Alameda | 1 | 401 | 37 | 52 | 5 | 76 |
19602 | 19602 | 2022-01-13 | Amador | 5 | 8 | 0 | 3 | 0 | 0 |
19603 | 19603 | 2022-01-13 | Butte | 7 | 54 | 0 | 5 | 0 | 5 |
19604 | 19604 | 2022-01-13 | Calaveras | 9 | 4 | 0 | 2 | 0 | 6 |
19605 | 19605 | 2022-01-13 | Colusa | 11 | 3 | 0 | 0 | 0 | 0 |
19606 | 19606 | 2022-01-13 | Contra Costa | 13 | 214 | 32 | 31 | 2 | 30 |
19607 | 19607 | 2022-01-13 | Del Norte | 15 | 3 | 0 | 1 | 0 | 4 |
19608 | 19608 | 2022-01-13 | El Dorado | 17 | 13 | 0 | 1 | 0 | 2 |
19609 | 19609 | 2022-01-13 | Fresno | 19 | 390 | 22 | 62 | 2 | 10 |
19610 | 19610 | 2022-01-13 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
19611 | 19611 | 2022-01-13 | Humboldt | 23 | 28 | 8 | 8 | 0 | 4 |
19612 | 19612 | 2022-01-13 | Imperial | 25 | 95 | 0 | 29 | 0 | 0 |
19613 | 19613 | 2022-01-13 | Inyo | 27 | 4 | 0 | 1 | 0 | 2 |
19614 | 19614 | 2022-01-13 | Kern | 29 | 244 | 4 | 42 | 0 | 25 |
19615 | 19615 | 2022-01-13 | Kings | 31 | 42 | 0 | 3 | 0 | 1 |
19616 | 19616 | 2022-01-13 | Lake | 33 | 4 | 0 | 2 | 0 | 0 |
19617 | 19617 | 2022-01-13 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
19618 | 19618 | 2022-01-13 | Los Angeles | 37 | 4257 | 150 | 600 | 18 | 433 |
19619 | 19619 | 2022-01-13 | Madera | 39 | 34 | 6 | 6 | 2 | 7 |
19620 | 19620 | 2022-01-13 | Marin | 41 | 33 | 2 | 4 | 0 | 15 |
19621 | 19621 | 2022-01-13 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
19622 | 19622 | 2022-01-13 | Mendocino | 45 | 13 | 0 | 1 | 0 | 1 |
19623 | 19623 | 2022-01-13 | Merced | 47 | 49 | 0 | 10 | 0 | 2 |
19624 | 19624 | 2022-01-13 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
19625 | 19625 | 2022-01-13 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
19626 | 19626 | 2022-01-13 | Monterey | 53 | 65 | 1 | 14 | 0 | 21 |
19627 | 19627 | 2022-01-13 | Napa | 55 | 30 | 0 | 5 | 0 | 2 |
19628 | 19628 | 2022-01-13 | Nevada | 57 | 14 | 0 | 1 | 0 | 2 |
19629 | 19629 | 2022-01-13 | Orange | 59 | 1154 | 20 | 171 | 4 | 148 |
19630 | 19630 | 2022-01-13 | Placer | 61 | 205 | 21 | 33 | 1 | 11 |
19631 | 19631 | 2022-01-13 | Plumas | 63 | 5 | 0 | 0 | 0 | 0 |
19632 | 19632 | 2022-01-13 | Riverside | 65 | 991 | 42 | 151 | 3 | 73 |
19633 | 19633 | 2022-01-13 | Sacramento | 67 | 505 | 15 | 82 | 1 | 65 |
19634 | 19634 | 2022-01-13 | San Benito | 69 | 8 | 0 | 3 | 0 | 0 |
19635 | 19635 | 2022-01-13 | San Bernardino | 71 | 1107 | 43 | 219 | 2 | 97 |
19636 | 19636 | 2022-01-13 | San Diego | 73 | 1180 | 24 | 178 | 4 | 170 |
19637 | 19637 | 2022-01-13 | San Francisco | 75 | 228 | 5 | 41 | 0 | 67 |
19638 | 19638 | 2022-01-13 | San Joaquin | 77 | 217 | 5 | 47 | 1 | 10 |
19639 | 19639 | 2022-01-13 | San Luis Obispo | 79 | 44 | 1 | 8 | 0 | 16 |
19640 | 19640 | 2022-01-13 | San Mateo | 81 | 138 | 12 | 21 | 3 | 13 |
19641 | 19641 | 2022-01-13 | Santa Barbara | 83 | 103 | 1 | 10 | 0 | 20 |
19642 | 19642 | 2022-01-13 | Santa Clara | 85 | 461 | 30 | 67 | 6 | 46 |
19643 | 19643 | 2022-01-13 | Santa Cruz | 87 | 35 | 0 | 3 | 0 | 3 |
19644 | 19644 | 2022-01-13 | Shasta | 89 | 60 | 8 | 11 | 0 | 10 |
19645 | 19645 | 2022-01-13 | Siskiyou | 93 | 4 | 0 | 2 | 0 | 2 |
19646 | 19646 | 2022-01-13 | Solano | 95 | 117 | 17 | 16 | 2 | 13 |
19647 | 19647 | 2022-01-13 | Sonoma | 97 | 85 | 0 | 11 | 0 | 16 |
19648 | 19648 | 2022-01-13 | Stanislaus | 99 | 220 | 11 | 29 | 3 | 27 |
19649 | 19649 | 2022-01-13 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
19650 | 19650 | 2022-01-13 | Tehama | 103 | 20 | 0 | 2 | 0 | 1 |
19651 | 19651 | 2022-01-13 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
19652 | 19652 | 2022-01-13 | Tulare | 107 | 91 | 6 | 10 | 1 | 13 |
19653 | 19653 | 2022-01-13 | Tuolumne | 109 | 11 | 0 | 3 | 0 | 2 |
19654 | 19654 | 2022-01-13 | Ventura | 111 | 310 | 3 | 43 | 1 | 38 |
19655 | 19655 | 2022-01-13 | Yolo | 113 | 14 | 0 | 4 | 0 | 0 |
19656 | 19656 | 2022-01-13 | Yuba | 115 | 34 | 1 | 6 | 0 | 2 |
19657 | 19657 | 2022-01-12 | Alameda | 1 | 371 | 50 | 46 | 8 | 81 |
19658 | 19658 | 2022-01-12 | Amador | 5 | 8 | 1 | 2 | 0 | 0 |
19659 | 19659 | 2022-01-12 | Butte | 7 | 64 | 1 | 5 | 1 | 9 |
19660 | 19660 | 2022-01-12 | Calaveras | 9 | 2 | 0 | 2 | 0 | 5 |
19661 | 19661 | 2022-01-12 | Colusa | 11 | 2 | 0 | 0 | 0 | 0 |
19662 | 19662 | 2022-01-12 | Contra Costa | 13 | 205 | 38 | 27 | 2 | 27 |
19663 | 19663 | 2022-01-12 | Del Norte | 15 | 3 | 0 | 0 | 0 | 3 |
19664 | 19664 | 2022-01-12 | El Dorado | 17 | 14 | 0 | 1 | 0 | 0 |
19665 | 19665 | 2022-01-12 | Fresno | 19 | 373 | 22 | 60 | 0 | 13 |
19666 | 19666 | 2022-01-12 | Glenn | 21 | 2 | 0 | 0 | 0 | 0 |
19667 | 19667 | 2022-01-12 | Humboldt | 23 | 20 | 10 | 5 | 0 | 6 |
19668 | 19668 | 2022-01-12 | Imperial | 25 | 87 | 1 | 24 | 0 | 0 |
19669 | 19669 | 2022-01-12 | Inyo | 27 | 4 | 0 | 0 | 0 | 2 |
19670 | 19670 | 2022-01-12 | Kern | 29 | 239 | 5 | 38 | 0 | 27 |
19671 | 19671 | 2022-01-12 | Kings | 31 | 39 | 0 | 2 | 0 | 2 |
19672 | 19672 | 2022-01-12 | Lake | 33 | 3 | 0 | 2 | 0 | 1 |
19673 | 19673 | 2022-01-12 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
19674 | 19674 | 2022-01-12 | Los Angeles | 37 | 4175 | 164 | 586 | 18 | 442 |
19675 | 19675 | 2022-01-12 | Madera | 39 | 34 | 5 | 6 | 1 | 4 |
19676 | 19676 | 2022-01-12 | Marin | 41 | 28 | 2 | 3 | 0 | 15 |
19677 | 19677 | 2022-01-12 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
19678 | 19678 | 2022-01-12 | Mendocino | 45 | 11 | 0 | 2 | 0 | 0 |
19679 | 19679 | 2022-01-12 | Merced | 47 | 44 | 0 | 10 | 0 | 3 |
19680 | 19680 | 2022-01-12 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
19681 | 19681 | 2022-01-12 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
19682 | 19682 | 2022-01-12 | Monterey | 53 | 68 | 1 | 15 | 0 | 17 |
19683 | 19683 | 2022-01-12 | Napa | 55 | 25 | 0 | 4 | 0 | 1 |
19684 | 19684 | 2022-01-12 | Nevada | 57 | 15 | 0 | 3 | 0 | 3 |
19685 | 19685 | 2022-01-12 | Orange | 59 | 1072 | 28 | 168 | 6 | 142 |
19686 | 19686 | 2022-01-12 | Placer | 61 | 211 | 15 | 34 | 2 | 12 |
19687 | 19687 | 2022-01-12 | Plumas | 63 | 6 | 0 | 0 | 0 | 0 |
19688 | 19688 | 2022-01-12 | Riverside | 65 | 976 | 43 | 145 | 5 | 72 |
19689 | 19689 | 2022-01-12 | Sacramento | 67 | 483 | 21 | 80 | 4 | 69 |
19690 | 19690 | 2022-01-12 | San Benito | 69 | 9 | 0 | 3 | 0 | 0 |
19691 | 19691 | 2022-01-12 | San Bernardino | 71 | 1080 | 50 | 196 | 5 | 97 |
19692 | 19692 | 2022-01-12 | San Diego | 73 | 1135 | 36 | 177 | 4 | 173 |
19693 | 19693 | 2022-01-12 | San Francisco | 75 | 219 | 11 | 37 | 1 | 70 |
19694 | 19694 | 2022-01-12 | San Joaquin | 77 | 217 | 7 | 44 | 1 | 10 |
19695 | 19695 | 2022-01-12 | San Luis Obispo | 79 | 45 | 1 | 8 | 0 | 17 |
19696 | 19696 | 2022-01-12 | San Mateo | 81 | 122 | 19 | 15 | 3 | 15 |
19697 | 19697 | 2022-01-12 | Santa Barbara | 83 | 98 | 0 | 14 | 0 | 15 |
19698 | 19698 | 2022-01-12 | Santa Clara | 85 | 443 | 30 | 65 | 6 | 43 |
19699 | 19699 | 2022-01-12 | Santa Cruz | 87 | 34 | 2 | 2 | 1 | 3 |
19700 | 19700 | 2022-01-12 | Shasta | 89 | 60 | 0 | 11 | 0 | 13 |
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 );