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-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients, icu_available_beds
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55385 | 55385 | 2020-04-14 | Alameda | 1 | 92 | 106 | 34 | 21 | 61 |
55386 | 55386 | 2020-04-14 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
55387 | 55387 | 2020-04-14 | Butte | 7 | 1 | 6 | 1 | 6 | 4 |
55388 | 55388 | 2020-04-14 | Calaveras | 9 | 0 | 1 | 0 | 0 | 12 |
55389 | 55389 | 2020-04-14 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55390 | 55390 | 2020-04-14 | Contra Costa | 13 | 37 | 51 | 15 | 9 | 61 |
55391 | 55391 | 2020-04-14 | Del Norte | 15 | 0 | 5 | 0 | 4 | 4 |
55392 | 55392 | 2020-04-14 | El Dorado | 17 | 20 | 3 | 0 | 0 | 12 |
55393 | 55393 | 2020-04-14 | Fresno | 19 | 24 | 45 | 12 | 8 | 42 |
55394 | 55394 | 2020-04-14 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55395 | 55395 | 2020-04-14 | Humboldt | 23 | 2 | 7 | 0 | 0 | 10 |
55396 | 55396 | 2020-04-14 | Imperial | 25 | 19 | 14 | 6 | 3 | 3 |
55397 | 55397 | 2020-04-14 | Inyo | 27 | 10 | 156 | 0 | 1 | 5 |
55398 | 55398 | 2020-04-14 | Kern | 29 | 35 | 23 | 17 | 3 | 45 |
55399 | 55399 | 2020-04-14 | Kings | 31 | 8 | 0 | 2 | 0 | 2 |
55400 | 55400 | 2020-04-14 | Lake | 33 | 0 | 3 | 0 | 0 | 3 |
55401 | 55401 | 2020-04-14 | Lassen | 35 | 0 | 6 | 0 | 0 | |
55402 | 55402 | 2020-04-14 | Los Angeles | 37 | 1587 | 613 | 588 | 115 | 614 |
55403 | 55403 | 2020-04-14 | Madera | 39 | 0 | 4 | 0 | 2 | 7 |
55404 | 55404 | 2020-04-14 | Marin | 41 | 2 | 23 | 2 | 3 | 9 |
55405 | 55405 | 2020-04-14 | Mariposa | 43 | 0 | 3 | 0 | 0 | |
55406 | 55406 | 2020-04-14 | Mendocino | 45 | 0 | 0 | 0 | 0 | 6 |
55407 | 55407 | 2020-04-14 | Merced | 47 | 0 | 4 | 0 | 2 | 4 |
55408 | 55408 | 2020-04-14 | Modoc | 49 | 0 | 1 | 0 | 0 | |
55409 | 55409 | 2020-04-14 | Mono | 51 | 0 | 1 | 0 | 0 | 2 |
55410 | 55410 | 2020-04-14 | Monterey | 53 | 18 | 13 | 3 | 0 | 25 |
55411 | 55411 | 2020-04-14 | Napa | 55 | 0 | 0 | 0 | 0 | 8 |
55412 | 55412 | 2020-04-14 | Nevada | 57 | 3 | 4 | 2 | 1 | 7 |
55413 | 55413 | 2020-04-14 | Orange | 59 | 147 | 111 | 57 | 31 | 259 |
55414 | 55414 | 2020-04-14 | Placer | 61 | 17 | 15 | 5 | 4 | 9 |
55415 | 55415 | 2020-04-14 | Plumas | 63 | 0 | 1 | 0 | 0 | |
55416 | 55416 | 2020-04-14 | Riverside | 65 | 235 | 117 | 64 | 36 | 141 |
55417 | 55417 | 2020-04-14 | Sacramento | 67 | 70 | 46 | 24 | 8 | 59 |
55418 | 55418 | 2020-04-14 | San Benito | 69 | 1 | 1 | 0 | 0 | 2 |
55419 | 55419 | 2020-04-14 | San Bernardino | 71 | 166 | 149 | 59 | 43 | 117 |
55420 | 55420 | 2020-04-14 | San Diego | 73 | 243 | 109 | 101 | 22 | 162 |
55421 | 55421 | 2020-04-14 | San Francisco | 75 | 87 | 53 | 28 | 5 | 69 |
55422 | 55422 | 2020-04-14 | San Joaquin | 77 | 22 | 10 | 12 | 1 | 12 |
55423 | 55423 | 2020-04-14 | San Luis Obispo | 79 | 3 | 15 | 2 | 6 | 18 |
55424 | 55424 | 2020-04-14 | San Mateo | 81 | 55 | 12 | 19 | 4 | 25 |
55425 | 55425 | 2020-04-14 | Santa Barbara | 83 | 42 | 8 | 19 | 1 | 64 |
55426 | 55426 | 2020-04-14 | Santa Clara | 85 | 144 | 47 | 66 | 5 | 104 |
55427 | 55427 | 2020-04-14 | Santa Cruz | 87 | 4 | 4 | 3 | 0 | 3 |
55428 | 55428 | 2020-04-14 | Shasta | 89 | 1 | 4 | 1 | 2 | 9 |
55429 | 55429 | 2020-04-14 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 2 |
55430 | 55430 | 2020-04-14 | Solano | 95 | 12 | 25 | 6 | 4 | 27 |
55431 | 55431 | 2020-04-14 | Sonoma | 97 | 3 | 9 | 1 | 3 | 23 |
55432 | 55432 | 2020-04-14 | Stanislaus | 99 | 18 | 25 | 9 | 7 | 50 |
55433 | 55433 | 2020-04-14 | Sutter | 101 | 0 | 0 | |||
55434 | 55434 | 2020-04-14 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
55435 | 55435 | 2020-04-14 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55436 | 55436 | 2020-04-14 | Tulare | 107 | 15 | 5 | 6 | 0 | 18 |
55437 | 55437 | 2020-04-14 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 1 |
55438 | 55438 | 2020-04-14 | Ventura | 111 | 24 | 35 | 9 | 7 | 43 |
55439 | 55439 | 2020-04-14 | Yolo | 113 | 3 | 0 | 2 | 0 | 12 |
55440 | 55440 | 2020-04-14 | Yuba | 115 | 1 | 1 | 0 | 1 | 7 |
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 );