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-30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54489 | 54489 | 2020-04-30 | Alameda | 1 | 74 | 52 | 34 | 12 | 165 |
54490 | 54490 | 2020-04-30 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
54491 | 54491 | 2020-04-30 | Butte | 7 | 0 | 0 | 0 | 0 | 20 |
54492 | 54492 | 2020-04-30 | Calaveras | 9 | 0 | 0 | 0 | 0 | 12 |
54493 | 54493 | 2020-04-30 | Colusa | 11 | 1 | 0 | 1 | 0 | 5 |
54494 | 54494 | 2020-04-30 | Contra Costa | 13 | 24 | 43 | 9 | 6 | 141 |
54495 | 54495 | 2020-04-30 | Del Norte | 15 | 0 | 4 | 0 | 2 | 2 |
54496 | 54496 | 2020-04-30 | El Dorado | 17 | 0 | 6 | 0 | 1 | 10 |
54497 | 54497 | 2020-04-30 | Fresno | 19 | 41 | 37 | 15 | 4 | 83 |
54498 | 54498 | 2020-04-30 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54499 | 54499 | 2020-04-30 | Humboldt | 23 | 0 | 7 | 0 | 2 | 8 |
54500 | 54500 | 2020-04-30 | Imperial | 25 | 29 | 3 | 13 | 0 | 4 |
54501 | 54501 | 2020-04-30 | Inyo | 27 | 0 | 0 | 0 | 0 | 6 |
54502 | 54502 | 2020-04-30 | Kern | 29 | 29 | 25 | 20 | 0 | 49 |
54503 | 54503 | 2020-04-30 | Kings | 31 | 10 | 0 | 2 | 0 | 3 |
54504 | 54504 | 2020-04-30 | Lake | 33 | 0 | 2 | 0 | 0 | 2 |
54505 | 54505 | 2020-04-30 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54506 | 54506 | 2020-04-30 | Los Angeles | 37 | 1894 | 470 | 591 | 93 | 1235 |
54507 | 54507 | 2020-04-30 | Madera | 39 | 0 | 3 | 0 | 0 | 21 |
54508 | 54508 | 2020-04-30 | Marin | 41 | 0 | 3 | 0 | 0 | 19 |
54509 | 54509 | 2020-04-30 | Mariposa | 43 | 0 | 2 | 0 | 0 | |
54510 | 54510 | 2020-04-30 | Mendocino | 45 | 0 | 0 | 0 | 0 | 5 |
54511 | 54511 | 2020-04-30 | Merced | 47 | 3 | 2 | 1 | 0 | 5 |
54512 | 54512 | 2020-04-30 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54513 | 54513 | 2020-04-30 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
54514 | 54514 | 2020-04-30 | Monterey | 53 | 6 | 6 | 3 | 3 | 106 |
54515 | 54515 | 2020-04-30 | Napa | 55 | 1 | 0 | 0 | 0 | 7 |
54516 | 54516 | 2020-04-30 | Nevada | 57 | 0 | 1 | 0 | 1 | 4 |
54517 | 54517 | 2020-04-30 | Orange | 59 | 214 | 68 | 74 | 13 | 457 |
54518 | 54518 | 2020-04-30 | Placer | 61 | 4 | 28 | 1 | 4 | 82 |
54519 | 54519 | 2020-04-30 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54520 | 54520 | 2020-04-30 | Riverside | 65 | 214 | 138 | 85 | 30 | 184 |
54521 | 54521 | 2020-04-30 | Sacramento | 67 | 37 | 35 | 17 | 5 | 129 |
54522 | 54522 | 2020-04-30 | San Benito | 69 | 1 | 0 | 0 | 0 | 2 |
54523 | 54523 | 2020-04-30 | San Bernardino | 71 | 158 | 100 | 58 | 17 | 184 |
54524 | 54524 | 2020-04-30 | San Diego | 73 | 283 | 81 | 122 | 19 | 357 |
54525 | 54525 | 2020-04-30 | San Francisco | 75 | 85 | 11 | 32 | 1 | 100 |
54526 | 54526 | 2020-04-30 | San Joaquin | 77 | 17 | 24 | 8 | 4 | 30 |
54527 | 54527 | 2020-04-30 | San Luis Obispo | 79 | 3 | 3 | 3 | 1 | 30 |
54528 | 54528 | 2020-04-30 | San Mateo | 81 | 53 | 10 | 16 | 1 | 48 |
54529 | 54529 | 2020-04-30 | Santa Barbara | 83 | 26 | 9 | 13 | 3 | 85 |
54530 | 54530 | 2020-04-30 | Santa Clara | 85 | 104 | 37 | 45 | 3 | 191 |
54531 | 54531 | 2020-04-30 | Santa Cruz | 87 | 3 | 0 | 2 | 0 | 16 |
54532 | 54532 | 2020-04-30 | Shasta | 89 | 2 | 0 | 2 | 0 | 10 |
54533 | 54533 | 2020-04-30 | Siskiyou | 93 | 0 | 2 | 0 | 0 | 4 |
54534 | 54534 | 2020-04-30 | Solano | 95 | 11 | 12 | 5 | 3 | 57 |
54535 | 54535 | 2020-04-30 | Sonoma | 97 | 5 | 7 | 2 | 3 | 50 |
54536 | 54536 | 2020-04-30 | Stanislaus | 99 | 35 | 27 | 3 | 5 | 100 |
54537 | 54537 | 2020-04-30 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54538 | 54538 | 2020-04-30 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
54539 | 54539 | 2020-04-30 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54540 | 54540 | 2020-04-30 | Tulare | 107 | 28 | 2 | 5 | 2 | 29 |
54541 | 54541 | 2020-04-30 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 0 |
54542 | 54542 | 2020-04-30 | Ventura | 111 | 33 | 18 | 10 | 4 | 51 |
54543 | 54543 | 2020-04-30 | Yolo | 113 | 0 | 0 | 0 | 0 | 12 |
54544 | 54544 | 2020-04-30 | Yuba | 115 | 0 | 0 | 0 | 0 | 14 |
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 );