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-02 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
56057 | 56057 | 2020-04-02 | Alameda | 1 | 57 | 76 | 29 | 17 | 112 |
56058 | 56058 | 2020-04-02 | Amador | 5 | 0 | 3 | 0 | 0 | 2 |
56059 | 56059 | 2020-04-02 | Butte | 7 | 4 | 26 | 2 | 2 | 12 |
56060 | 56060 | 2020-04-02 | Calaveras | 9 | 0 | 1 | 0 | 0 | 5 |
56061 | 56061 | 2020-04-02 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
56062 | 56062 | 2020-04-02 | Contra Costa | 13 | 32 | 38 | 13 | 10 | 73 |
56063 | 56063 | 2020-04-02 | Del Norte | 15 | 0 | 3 | 0 | 0 | 2 |
56064 | 56064 | 2020-04-02 | El Dorado | 17 | 15 | 12 | 0 | 6 | 10 |
56065 | 56065 | 2020-04-02 | Fresno | 19 | 17 | 74 | 6 | 13 | 33 |
56066 | 56066 | 2020-04-02 | Glenn | 21 | 0 | 0 | 0 | 0 | |
56067 | 56067 | 2020-04-02 | Humboldt | 23 | 1 | 8 | 0 | 2 | 8 |
56068 | 56068 | 2020-04-02 | Imperial | 25 | 4 | 16 | 3 | 5 | 6 |
56069 | 56069 | 2020-04-02 | Inyo | 27 | 8 | 102 | 0 | 1 | 3 |
56070 | 56070 | 2020-04-02 | Kern | 29 | 27 | 77 | 12 | 23 | 36 |
56071 | 56071 | 2020-04-02 | Kings | 31 | 2 | 6 | 1 | 1 | 7 |
56072 | 56072 | 2020-04-02 | Lake | 33 | 0 | 1 | 0 | 0 | 2 |
56073 | 56073 | 2020-04-02 | Lassen | 35 | 0 | 7 | 0 | 0 | |
56074 | 56074 | 2020-04-02 | Los Angeles | 37 | 818 | 1270 | 346 | 193 | 488 |
56075 | 56075 | 2020-04-02 | Madera | 39 | 1 | 7 | 1 | 3 | 6 |
56076 | 56076 | 2020-04-02 | Marin | 41 | 7 | 16 | 3 | 1 | 16 |
56077 | 56077 | 2020-04-02 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
56078 | 56078 | 2020-04-02 | Mendocino | 45 | 0 | 1 | 0 | 0 | 8 |
56079 | 56079 | 2020-04-02 | Merced | 47 | 4 | 5 | 0 | 1 | 3 |
56080 | 56080 | 2020-04-02 | Modoc | 49 | 0 | 1 | 0 | 0 | |
56081 | 56081 | 2020-04-02 | Mono | 51 | 18 | 2 | 0 | 0 | 2 |
56082 | 56082 | 2020-04-02 | Monterey | 53 | 14 | 14 | 4 | 2 | 12 |
56083 | 56083 | 2020-04-02 | Napa | 55 | 1 | 4 | 1 | 1 | 12 |
56084 | 56084 | 2020-04-02 | Nevada | 57 | 38 | 58 | 2 | 1 | 6 |
56085 | 56085 | 2020-04-02 | Orange | 59 | 129 | 225 | 67 | 47 | 96 |
56086 | 56086 | 2020-04-02 | Placer | 61 | 32 | 15 | 9 | 0 | 11 |
56087 | 56087 | 2020-04-02 | Plumas | 63 | 0 | 0 | 0 | 0 | |
56088 | 56088 | 2020-04-02 | Riverside | 65 | 136 | 181 | 45 | 49 | 104 |
56089 | 56089 | 2020-04-02 | Sacramento | 67 | 71 | 92 | 24 | 19 | 80 |
56090 | 56090 | 2020-04-02 | San Benito | 69 | 2 | 0 | 2 | 0 | 0 |
56091 | 56091 | 2020-04-02 | San Bernardino | 71 | 126 | 185 | 50 | 45 | 37 |
56092 | 56092 | 2020-04-02 | San Diego | 73 | 144 | 343 | 69 | 35 | 206 |
56093 | 56093 | 2020-04-02 | San Francisco | 75 | 75 | 60 | 32 | 11 | 58 |
56094 | 56094 | 2020-04-02 | San Joaquin | 77 | 42 | 42 | 20 | 7 | 17 |
56095 | 56095 | 2020-04-02 | San Luis Obispo | 79 | 5 | 5 | 4 | 4 | 966 |
56096 | 56096 | 2020-04-02 | San Mateo | 81 | 62 | 40 | 26 | 4 | 26 |
56097 | 56097 | 2020-04-02 | Santa Barbara | 83 | 26 | 44 | 18 | 10 | 47 |
56098 | 56098 | 2020-04-02 | Santa Clara | 85 | 163 | 101 | 69 | 19 | 95 |
56099 | 56099 | 2020-04-02 | Santa Cruz | 87 | 4 | 4 | 3 | 0 | 7 |
56100 | 56100 | 2020-04-02 | Shasta | 89 | 2 | 4 | 1 | 0 | 10 |
56101 | 56101 | 2020-04-02 | Siskiyou | 93 | 0 | 3 | 0 | 2 | 4 |
56102 | 56102 | 2020-04-02 | Solano | 95 | 15 | 8 | 7 | 1 | 27 |
56103 | 56103 | 2020-04-02 | Sonoma | 97 | 8 | 18 | 1 | 0 | 10 |
56104 | 56104 | 2020-04-02 | Stanislaus | 99 | 30 | 43 | 11 | 7 | 22 |
56105 | 56105 | 2020-04-02 | Sutter | 101 | 0 | 0 | |||
56106 | 56106 | 2020-04-02 | Tehama | 103 | 0 | 1 | 0 | 1 | 4 |
56107 | 56107 | 2020-04-02 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56108 | 56108 | 2020-04-02 | Tulare | 107 | 4 | 26 | 4 | 5 | 3 |
56109 | 56109 | 2020-04-02 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
56110 | 56110 | 2020-04-02 | Ventura | 111 | 27 | 111 | 7 | 24 | 15 |
56111 | 56111 | 2020-04-02 | Yolo | 113 | 3 | 2 | 2 | 3 | 0 |
56112 | 56112 | 2020-04-02 | Yuba | 115 | 2 | 25 | 2 | 6 | 4 |
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 );