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 |
---|---|---|---|---|---|---|---|---|---|
5153 | 5153 | 2022-09-28 | Alameda | 1 | 73 | 32 | 8 | 3 | 89 |
5154 | 5154 | 2022-09-28 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
5155 | 5155 | 2022-09-28 | Butte | 7 | 21 | 0 | 2 | 0 | 14 |
5156 | 5156 | 2022-09-28 | Calaveras | 9 | 1 | 0 | 0 | 0 | 1 |
5157 | 5157 | 2022-09-28 | Colusa | 11 | 2 | 0 | 0 | 0 | 0 |
5158 | 5158 | 2022-09-28 | Contra Costa | 13 | 42 | 20 | 10 | 2 | 49 |
5159 | 5159 | 2022-09-28 | Del Norte | 15 | 2 | 0 | 0 | 0 | 0 |
5160 | 5160 | 2022-09-28 | El Dorado | 17 | 5 | 0 | 0 | 0 | 2 |
5161 | 5161 | 2022-09-28 | Fresno | 19 | 93 | 21 | 7 | 2 | 27 |
5162 | 5162 | 2022-09-28 | Glenn | 21 | 5 | 0 | 0 | 0 | 0 |
5163 | 5163 | 2022-09-28 | Humboldt | 23 | 3 | 0 | 0 | 0 | 8 |
5164 | 5164 | 2022-09-28 | Imperial | 25 | 7 | 0 | 0 | 0 | 12 |
5165 | 5165 | 2022-09-28 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
5166 | 5166 | 2022-09-28 | Kern | 29 | 37 | 0 | 6 | 0 | 27 |
5167 | 5167 | 2022-09-28 | Kings | 31 | 3 | 0 | 0 | 0 | 2 |
5168 | 5168 | 2022-09-28 | Lake | 33 | 1 | 0 | 1 | 0 | 3 |
5169 | 5169 | 2022-09-28 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
5170 | 5170 | 2022-09-28 | Los Angeles | 37 | 499 | 48 | 58 | 2 | 712 |
5171 | 5171 | 2022-09-28 | Madera | 39 | 13 | 0 | 3 | 0 | 9 |
5172 | 5172 | 2022-09-28 | Marin | 41 | 9 | 5 | 0 | 0 | 12 |
5173 | 5173 | 2022-09-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
5174 | 5174 | 2022-09-28 | Mendocino | 45 | 3 | 0 | 0 | 0 | 0 |
5175 | 5175 | 2022-09-28 | Merced | 47 | 12 | 0 | 0 | 0 | 7 |
5176 | 5176 | 2022-09-28 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
5177 | 5177 | 2022-09-28 | Mono | 51 | 0 | 0 | 0 | 0 | 0 |
5178 | 5178 | 2022-09-28 | Monterey | 53 | 14 | 0 | 1 | 0 | 14 |
5179 | 5179 | 2022-09-28 | Napa | 55 | 3 | 0 | 1 | 0 | 3 |
5180 | 5180 | 2022-09-28 | Nevada | 57 | 3 | 0 | 0 | 0 | 4 |
5181 | 5181 | 2022-09-28 | Orange | 59 | 147 | 8 | 22 | 1 | 135 |
5182 | 5182 | 2022-09-28 | Placer | 61 | 47 | 16 | 6 | 3 | 14 |
5183 | 5183 | 2022-09-28 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
5184 | 5184 | 2022-09-28 | Riverside | 65 | 74 | 14 | 11 | 1 | 107 |
5185 | 5185 | 2022-09-28 | Sacramento | 67 | 111 | 31 | 17 | 8 | 78 |
5186 | 5186 | 2022-09-28 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
5187 | 5187 | 2022-09-28 | San Bernardino | 71 | 98 | 3 | 20 | 0 | 140 |
5188 | 5188 | 2022-09-28 | San Diego | 73 | 201 | 11 | 19 | 0 | 269 |
5189 | 5189 | 2022-09-28 | San Francisco | 75 | 48 | 5 | 6 | 0 | 83 |
5190 | 5190 | 2022-09-28 | San Joaquin | 77 | 33 | 3 | 3 | 1 | 19 |
5191 | 5191 | 2022-09-28 | San Luis Obispo | 79 | 5 | 1 | 1 | 0 | 20 |
5192 | 5192 | 2022-09-28 | San Mateo | 81 | 22 | 8 | 0 | 0 | 22 |
5193 | 5193 | 2022-09-28 | Santa Barbara | 83 | 21 | 0 | 1 | 0 | 29 |
5194 | 5194 | 2022-09-28 | Santa Clara | 85 | 131 | 25 | 16 | 2 | 57 |
5195 | 5195 | 2022-09-28 | Santa Cruz | 87 | 8 | 0 | 0 | 0 | 0 |
5196 | 5196 | 2022-09-28 | Shasta | 89 | 15 | 0 | 3 | 0 | 29 |
5197 | 5197 | 2022-09-28 | Siskiyou | 93 | 2 | 0 | 1 | 0 | 4 |
5198 | 5198 | 2022-09-28 | Solano | 95 | 28 | 21 | 2 | 2 | 10 |
5199 | 5199 | 2022-09-28 | Sonoma | 97 | 28 | 7 | 0 | 1 | 21 |
5200 | 5200 | 2022-09-28 | Stanislaus | 99 | 49 | 10 | 5 | 0 | 42 |
5201 | 5201 | 2022-09-28 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
5202 | 5202 | 2022-09-28 | Tehama | 103 | 1 | 0 | 0 | 0 | 6 |
5203 | 5203 | 2022-09-28 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
5204 | 5204 | 2022-09-28 | Tulare | 107 | 20 | 0 | 2 | 0 | 29 |
5205 | 5205 | 2022-09-28 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 5 |
5206 | 5206 | 2022-09-28 | Ventura | 111 | 43 | 2 | 4 | 0 | 30 |
5207 | 5207 | 2022-09-28 | Yolo | 113 | 8 | 0 | 2 | 0 | 5 |
5208 | 5208 | 2022-09-28 | Yuba | 115 | 9 | 0 | 0 | 0 | 5 |
5209 | 5209 | 2022-09-27 | Alameda | 1 | 85 | 37 | 7 | 3 | 90 |
5210 | 5210 | 2022-09-27 | Amador | 5 | 0 | 1 | 0 | 0 | 2 |
5211 | 5211 | 2022-09-27 | Butte | 7 | 23 | 0 | 2 | 0 | 15 |
5212 | 5212 | 2022-09-27 | Calaveras | 9 | 1 | 0 | 0 | 0 | 1 |
5213 | 5213 | 2022-09-27 | Colusa | 11 | 2 | 0 | 0 | 0 | 0 |
5214 | 5214 | 2022-09-27 | Contra Costa | 13 | 43 | 27 | 9 | 2 | 47 |
5215 | 5215 | 2022-09-27 | Del Norte | 15 | 2 | 0 | 0 | 0 | 0 |
5216 | 5216 | 2022-09-27 | El Dorado | 17 | 5 | 0 | 0 | 0 | 1 |
5217 | 5217 | 2022-09-27 | Fresno | 19 | 96 | 22 | 9 | 1 | 30 |
5218 | 5218 | 2022-09-27 | Glenn | 21 | 4 | 0 | 0 | 0 | 0 |
5219 | 5219 | 2022-09-27 | Humboldt | 23 | 4 | 0 | 0 | 0 | 8 |
5220 | 5220 | 2022-09-27 | Imperial | 25 | 8 | 0 | 0 | 0 | 15 |
5221 | 5221 | 2022-09-27 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
5222 | 5222 | 2022-09-27 | Kern | 29 | 40 | 0 | 10 | 0 | 27 |
5223 | 5223 | 2022-09-27 | Kings | 31 | 2 | 0 | 0 | 0 | 4 |
5224 | 5224 | 2022-09-27 | Lake | 33 | 2 | 0 | 1 | 0 | 2 |
5225 | 5225 | 2022-09-27 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
5226 | 5226 | 2022-09-27 | Los Angeles | 37 | 471 | 68 | 60 | 6 | 760 |
5227 | 5227 | 2022-09-27 | Madera | 39 | 10 | 5 | 3 | 1 | 9 |
5228 | 5228 | 2022-09-27 | Marin | 41 | 12 | 5 | 0 | 0 | 12 |
5229 | 5229 | 2022-09-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
5230 | 5230 | 2022-09-27 | Mendocino | 45 | 3 | 0 | 0 | 0 | 1 |
5231 | 5231 | 2022-09-27 | Merced | 47 | 13 | 0 | 0 | 0 | 8 |
5232 | 5232 | 2022-09-27 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
5233 | 5233 | 2022-09-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
5234 | 5234 | 2022-09-27 | Monterey | 53 | 17 | 0 | 2 | 0 | 22 |
5235 | 5235 | 2022-09-27 | Napa | 55 | 3 | 0 | 1 | 0 | 7 |
5236 | 5236 | 2022-09-27 | Nevada | 57 | 3 | 0 | 0 | 0 | 8 |
5237 | 5237 | 2022-09-27 | Orange | 59 | 135 | 7 | 22 | 1 | 143 |
5238 | 5238 | 2022-09-27 | Placer | 61 | 44 | 15 | 7 | 4 | 15 |
5239 | 5239 | 2022-09-27 | Plumas | 63 | 2 | 0 | 0 | 0 | 0 |
5240 | 5240 | 2022-09-27 | Riverside | 65 | 64 | 10 | 10 | 0 | 116 |
5241 | 5241 | 2022-09-27 | Sacramento | 67 | 118 | 26 | 16 | 5 | 85 |
5242 | 5242 | 2022-09-27 | San Benito | 69 | 1 | 0 | 1 | 0 | 0 |
5243 | 5243 | 2022-09-27 | San Bernardino | 71 | 96 | 3 | 14 | 0 | 155 |
5244 | 5244 | 2022-09-27 | San Diego | 73 | 211 | 18 | 17 | 0 | 260 |
5245 | 5245 | 2022-09-27 | San Francisco | 75 | 56 | 10 | 8 | 2 | 69 |
5246 | 5246 | 2022-09-27 | San Joaquin | 77 | 40 | 2 | 5 | 1 | 23 |
5247 | 5247 | 2022-09-27 | San Luis Obispo | 79 | 7 | 0 | 1 | 0 | 19 |
5248 | 5248 | 2022-09-27 | San Mateo | 81 | 24 | 11 | 1 | 0 | 19 |
5249 | 5249 | 2022-09-27 | Santa Barbara | 83 | 20 | 1 | 0 | 0 | 28 |
5250 | 5250 | 2022-09-27 | Santa Clara | 85 | 130 | 22 | 21 | 0 | 65 |
5251 | 5251 | 2022-09-27 | Santa Cruz | 87 | 12 | 0 | 0 | 0 | 1 |
5252 | 5252 | 2022-09-27 | Shasta | 89 | 18 | 0 | 4 | 0 | 27 |
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 );