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 rows where "date" is on date 2020-04-26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54713 | 54713 | 2020-04-26 | Alameda | 1 | 84 | 43 | 42 | 5 | 191 |
54714 | 54714 | 2020-04-26 | Amador | 5 | 0 | 0 | 0 | 0 | 6 |
54715 | 54715 | 2020-04-26 | Butte | 7 | 0 | 0 | 0 | 0 | 18 |
54716 | 54716 | 2020-04-26 | Calaveras | 9 | 0 | 0 | 0 | 0 | 11 |
54717 | 54717 | 2020-04-26 | Colusa | 11 | 1 | 1 | 1 | 1 | 4 |
54718 | 54718 | 2020-04-26 | Contra Costa | 13 | 27 | 42 | 9 | 9 | 150 |
54719 | 54719 | 2020-04-26 | Del Norte | 15 | 0 | 2 | 0 | 1 | 5 |
54720 | 54720 | 2020-04-26 | El Dorado | 17 | 1 | 8 | 0 | 3 | 7 |
54721 | 54721 | 2020-04-26 | Fresno | 19 | 37 | 44 | 18 | 9 | 79 |
54722 | 54722 | 2020-04-26 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54723 | 54723 | 2020-04-26 | Humboldt | 23 | 0 | 0 | 0 | 0 | 4 |
54724 | 54724 | 2020-04-26 | Imperial | 25 | 26 | 12 | 8 | 2 | 5 |
54725 | 54725 | 2020-04-26 | Inyo | 27 | 0 | 0 | 0 | 0 | 6 |
54726 | 54726 | 2020-04-26 | Kern | 29 | 29 | 15 | 23 | 0 | 50 |
54727 | 54727 | 2020-04-26 | Kings | 31 | 9 | 0 | 2 | 0 | 6 |
54728 | 54728 | 2020-04-26 | Lake | 33 | 0 | 1 | 0 | 0 | 5 |
54729 | 54729 | 2020-04-26 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54730 | 54730 | 2020-04-26 | Los Angeles | 37 | 1887 | 575 | 588 | 122 | 1262 |
54731 | 54731 | 2020-04-26 | Madera | 39 | 0 | 1 | 0 | 0 | 20 |
54732 | 54732 | 2020-04-26 | Marin | 41 | 3 | 7 | 2 | 3 | 19 |
54733 | 54733 | 2020-04-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
54734 | 54734 | 2020-04-26 | Mendocino | 45 | 0 | 0 | 0 | 0 | 12 |
54735 | 54735 | 2020-04-26 | Merced | 47 | 0 | 4 | 0 | 2 | 6 |
54736 | 54736 | 2020-04-26 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54737 | 54737 | 2020-04-26 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54738 | 54738 | 2020-04-26 | Monterey | 53 | 5 | 5 | 3 | 2 | 113 |
54739 | 54739 | 2020-04-26 | Napa | 55 | 1 | 0 | 1 | 0 | 8 |
54740 | 54740 | 2020-04-26 | Nevada | 57 | 1 | 2 | 0 | 2 | 5 |
54741 | 54741 | 2020-04-26 | Orange | 59 | 180 | 109 | 73 | 23 | 378 |
54742 | 54742 | 2020-04-26 | Placer | 61 | 4 | 21 | 1 | 5 | 101 |
54743 | 54743 | 2020-04-26 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54744 | 54744 | 2020-04-26 | Riverside | 65 | 215 | 152 | 75 | 35 | 230 |
54745 | 54745 | 2020-04-26 | Sacramento | 67 | 48 | 40 | 16 | 6 | 171 |
54746 | 54746 | 2020-04-26 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
54747 | 54747 | 2020-04-26 | San Bernardino | 71 | 146 | 83 | 50 | 20 | 201 |
54748 | 54748 | 2020-04-26 | San Diego | 73 | 273 | 90 | 114 | 21 | 427 |
54749 | 54749 | 2020-04-26 | San Francisco | 75 | 79 | 21 | 31 | 3 | 126 |
54750 | 54750 | 2020-04-26 | San Joaquin | 77 | 24 | 19 | 9 | 4 | 23 |
54751 | 54751 | 2020-04-26 | San Luis Obispo | 79 | 1 | 3 | 1 | 2 | 21 |
54752 | 54752 | 2020-04-26 | San Mateo | 81 | 53 | 10 | 18 | 2 | 43 |
54753 | 54753 | 2020-04-26 | Santa Barbara | 83 | 24 | 13 | 12 | 4 | 85 |
54754 | 54754 | 2020-04-26 | Santa Clara | 85 | 118 | 64 | 60 | 17 | 194 |
54755 | 54755 | 2020-04-26 | Santa Cruz | 87 | 4 | 1 | 2 | 0 | 5 |
54756 | 54756 | 2020-04-26 | Shasta | 89 | 1 | 0 | 1 | 0 | 10 |
54757 | 54757 | 2020-04-26 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 5 |
54758 | 54758 | 2020-04-26 | Solano | 95 | 8 | 14 | 3 | 1 | 62 |
54759 | 54759 | 2020-04-26 | Sonoma | 97 | 1 | 9 | 0 | 1 | 63 |
54760 | 54760 | 2020-04-26 | Stanislaus | 99 | 28 | 19 | 7 | 4 | 97 |
54761 | 54761 | 2020-04-26 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54762 | 54762 | 2020-04-26 | Tehama | 103 | 0 | 0 | 0 | 0 | 3 |
54763 | 54763 | 2020-04-26 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54764 | 54764 | 2020-04-26 | Tulare | 107 | 26 | 0 | 8 | 0 | 21 |
54765 | 54765 | 2020-04-26 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 4 |
54766 | 54766 | 2020-04-26 | Ventura | 111 | 27 | 73 | 6 | 3 | 55 |
54767 | 54767 | 2020-04-26 | Yolo | 113 | 1 | 1 | 1 | 1 | 23 |
54768 | 54768 | 2020-04-26 | Yuba | 115 | 0 | 2 | 0 | 1 | 10 |
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 );