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-01 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_suspected_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
56113 | 56113 | 2020-04-01 | Alameda | 1 | 52 | 76 | 27 | 15 | 106 |
56114 | 56114 | 2020-04-01 | Amador | 5 | 0 | 3 | 0 | 0 | 2 |
56115 | 56115 | 2020-04-01 | Butte | 7 | 5 | 33 | 2 | 4 | 9 |
56116 | 56116 | 2020-04-01 | Calaveras | 9 | 0 | 1 | 0 | 0 | 5 |
56117 | 56117 | 2020-04-01 | Colusa | 11 | 0 | 1 | 0 | 1 | 5 |
56118 | 56118 | 2020-04-01 | Contra Costa | 13 | 31 | 42 | 12 | 12 | 61 |
56119 | 56119 | 2020-04-01 | Del Norte | 15 | 0 | 5 | 0 | 0 | 3 |
56120 | 56120 | 2020-04-01 | El Dorado | 17 | 14 | 8 | 1 | 3 | 9 |
56121 | 56121 | 2020-04-01 | Fresno | 19 | 19 | 101 | 5 | 13 | 53 |
56122 | 56122 | 2020-04-01 | Glenn | 21 | |||||
56123 | 56123 | 2020-04-01 | Humboldt | 23 | 1 | 9 | 0 | 3 | 7 |
56124 | 56124 | 2020-04-01 | Imperial | 25 | 4 | 15 | 3 | 4 | 7 |
56125 | 56125 | 2020-04-01 | Inyo | 27 | 7 | 89 | 0 | 0 | 6 |
56126 | 56126 | 2020-04-01 | Kern | 29 | 15 | 45 | 7 | 9 | 32 |
56127 | 56127 | 2020-04-01 | Kings | 31 | 2 | 6 | 1 | 2 | 1 |
56128 | 56128 | 2020-04-01 | Lake | 33 | 0 | 2 | 0 | 0 | 2 |
56129 | 56129 | 2020-04-01 | Lassen | 35 | 0 | 7 | 0 | 0 | |
56130 | 56130 | 2020-04-01 | Los Angeles | 37 | 739 | 1332 | 335 | 220 | 492 |
56131 | 56131 | 2020-04-01 | Madera | 39 | 1 | 3 | 1 | 0 | 4 |
56132 | 56132 | 2020-04-01 | Marin | 41 | 9 | 19 | 4 | 2 | 14 |
56133 | 56133 | 2020-04-01 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
56134 | 56134 | 2020-04-01 | Mendocino | 45 | 0 | 2 | 0 | 0 | 8 |
56135 | 56135 | 2020-04-01 | Merced | 47 | 3 | 15 | 0 | 3 | 9 |
56136 | 56136 | 2020-04-01 | Modoc | 49 | 0 | 1 | 0 | 0 | |
56137 | 56137 | 2020-04-01 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
56138 | 56138 | 2020-04-01 | Monterey | 53 | 13 | 16 | 4 | 4 | 15 |
56139 | 56139 | 2020-04-01 | Napa | 55 | 2 | 2 | 0 | 1 | 9 |
56140 | 56140 | 2020-04-01 | Nevada | 57 | 36 | 54 | 0 | 4 | 3 |
56141 | 56141 | 2020-04-01 | Orange | 59 | 117 | 221 | 50 | 48 | 118 |
56142 | 56142 | 2020-04-01 | Placer | 61 | 25 | 28 | 6 | 2 | 7 |
56143 | 56143 | 2020-04-01 | Plumas | 63 | 0 | 0 | 0 | 0 | |
56144 | 56144 | 2020-04-01 | Riverside | 65 | 85 | 182 | 29 | 47 | 76 |
56145 | 56145 | 2020-04-01 | Sacramento | 67 | 53 | 138 | 20 | 33 | 74 |
56146 | 56146 | 2020-04-01 | San Benito | 69 | 2 | 0 | 2 | 0 | 0 |
56147 | 56147 | 2020-04-01 | San Bernardino | 71 | 95 | 196 | 39 | 52 | 34 |
56148 | 56148 | 2020-04-01 | San Diego | 73 | 168 | 340 | 71 | 32 | 215 |
56149 | 56149 | 2020-04-01 | San Francisco | 75 | 67 | 66 | 30 | 8 | 64 |
56150 | 56150 | 2020-04-01 | San Joaquin | 77 | 25 | 35 | 16 | 11 | 21 |
56151 | 56151 | 2020-04-01 | San Luis Obispo | 79 | 8 | 10 | 5 | 6 | 968 |
56152 | 56152 | 2020-04-01 | San Mateo | 81 | 57 | 35 | 19 | 9 | 36 |
56153 | 56153 | 2020-04-01 | Santa Barbara | 83 | 23 | 23 | 15 | 6 | 51 |
56154 | 56154 | 2020-04-01 | Santa Clara | 85 | 160 | 85 | 77 | 15 | 91 |
56155 | 56155 | 2020-04-01 | Santa Cruz | 87 | 2 | 12 | 2 | 2 | 3 |
56156 | 56156 | 2020-04-01 | Shasta | 89 | 1 | 4 | 0 | 1 | 13 |
56157 | 56157 | 2020-04-01 | Siskiyou | 93 | 0 | 5 | 0 | 2 | 3 |
56158 | 56158 | 2020-04-01 | Solano | 95 | 14 | 18 | 5 | 2 | 31 |
56159 | 56159 | 2020-04-01 | Sonoma | 97 | 5 | 18 | 1 | 2 | 22 |
56160 | 56160 | 2020-04-01 | Stanislaus | 99 | 25 | 39 | 10 | 6 | 31 |
56161 | 56161 | 2020-04-01 | Sutter | 101 | 0 | 0 | 0 | 0 | |
56162 | 56162 | 2020-04-01 | Tehama | 103 | 0 | 1 | 0 | 1 | 4 |
56163 | 56163 | 2020-04-01 | Trinity | 105 | 0 | 0 | 0 | 0 | |
56164 | 56164 | 2020-04-01 | Tulare | 107 | 4 | 12 | 3 | 4 | 9 |
56165 | 56165 | 2020-04-01 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
56166 | 56166 | 2020-04-01 | Ventura | 111 | 22 | 96 | 5 | 23 | 27 |
56167 | 56167 | 2020-04-01 | Yolo | 113 | 3 | 3 | 1 | 1 | 2 |
56168 | 56168 | 2020-04-01 | Yuba | 115 | 2 | 24 | 2 | 4 | 6 |
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 );