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-11 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55553 | 55553 | 2020-04-11 | Alameda | 1 | 87 | 91 | 46 | 19 | 121 |
55554 | 55554 | 2020-04-11 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
55555 | 55555 | 2020-04-11 | Butte | 7 | 2 | 4 | 1 | 1 | 5 |
55556 | 55556 | 2020-04-11 | Calaveras | 9 | 0 | 1 | 0 | 1 | 11 |
55557 | 55557 | 2020-04-11 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55558 | 55558 | 2020-04-11 | Contra Costa | 13 | 39 | 38 | 15 | 15 | 75 |
55559 | 55559 | 2020-04-11 | Del Norte | 15 | 0 | 2 | 0 | 1 | 5 |
55560 | 55560 | 2020-04-11 | El Dorado | 17 | 17 | 2 | 0 | 1 | 9 |
55561 | 55561 | 2020-04-11 | Fresno | 19 | 28 | 63 | 11 | 8 | 52 |
55562 | 55562 | 2020-04-11 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55563 | 55563 | 2020-04-11 | Humboldt | 23 | 2 | 5 | 0 | 3 | 3 |
55564 | 55564 | 2020-04-11 | Imperial | 25 | 14 | 11 | 7 | 3 | 1 |
55565 | 55565 | 2020-04-11 | Inyo | 27 | 10 | 140 | 1 | 0 | 3 |
55566 | 55566 | 2020-04-11 | Kern | 29 | 32 | 52 | 17 | 4 | 41 |
55567 | 55567 | 2020-04-11 | Kings | 31 | 10 | 0 | 4 | 0 | 1 |
55568 | 55568 | 2020-04-11 | Lake | 33 | 0 | 0 | 0 | 0 | 0 |
55569 | 55569 | 2020-04-11 | Lassen | 35 | 0 | 4 | 0 | 0 | |
55570 | 55570 | 2020-04-11 | Los Angeles | 37 | 1362 | 905 | 555 | 135 | 595 |
55571 | 55571 | 2020-04-11 | Madera | 39 | 0 | 5 | 0 | 2 | 5 |
55572 | 55572 | 2020-04-11 | Marin | 41 | 2 | 27 | 1 | 3 | 14 |
55573 | 55573 | 2020-04-11 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
55574 | 55574 | 2020-04-11 | Mendocino | 45 | 0 | 1 | 0 | 1 | 9 |
55575 | 55575 | 2020-04-11 | Merced | 47 | 0 | 2 | 0 | 1 | 3 |
55576 | 55576 | 2020-04-11 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55577 | 55577 | 2020-04-11 | Mono | 51 | 0 | 3 | 0 | 0 | 2 |
55578 | 55578 | 2020-04-11 | Monterey | 53 | 18 | 17 | 5 | 2 | 24 |
55579 | 55579 | 2020-04-11 | Napa | 55 | 0 | 0 | 0 | 0 | 5 |
55580 | 55580 | 2020-04-11 | Nevada | 57 | 3 | 3 | 2 | 1 | 5 |
55581 | 55581 | 2020-04-11 | Orange | 59 | 144 | 109 | 44 | 20 | 219 |
55582 | 55582 | 2020-04-11 | Placer | 61 | 20 | 19 | 7 | 4 | 13 |
55583 | 55583 | 2020-04-11 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55584 | 55584 | 2020-04-11 | Riverside | 65 | 232 | 127 | 57 | 26 | 149 |
55585 | 55585 | 2020-04-11 | Sacramento | 67 | 67 | 46 | 29 | 10 | 80 |
55586 | 55586 | 2020-04-11 | San Benito | 69 | 2 | 2 | 0 | 0 | 2 |
55587 | 55587 | 2020-04-11 | San Bernardino | 71 | 153 | 213 | 57 | 42 | 117 |
55588 | 55588 | 2020-04-11 | San Diego | 73 | 239 | 118 | 98 | 23 | 140 |
55589 | 55589 | 2020-04-11 | San Francisco | 75 | 82 | 51 | 28 | 13 | 132 |
55590 | 55590 | 2020-04-11 | San Joaquin | 77 | 23 | 14 | 14 | 5 | 28 |
55591 | 55591 | 2020-04-11 | San Luis Obispo | 79 | 2 | 10 | 2 | 5 | 23 |
55592 | 55592 | 2020-04-11 | San Mateo | 81 | 54 | 15 | 18 | 2 | 42 |
55593 | 55593 | 2020-04-11 | Santa Barbara | 83 | 40 | 16 | 21 | 4 | 53 |
55594 | 55594 | 2020-04-11 | Santa Clara | 85 | 146 | 61 | 66 | 8 | 106 |
55595 | 55595 | 2020-04-11 | Santa Cruz | 87 | 4 | 14 | 3 | 6 | 6 |
55596 | 55596 | 2020-04-11 | Shasta | 89 | 5 | 3 | 2 | 0 | 12 |
55597 | 55597 | 2020-04-11 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 4 |
55598 | 55598 | 2020-04-11 | Solano | 95 | 13 | 16 | 9 | 4 | 32 |
55599 | 55599 | 2020-04-11 | Sonoma | 97 | 3 | 19 | 1 | 4 | 30 |
55600 | 55600 | 2020-04-11 | Stanislaus | 99 | 23 | 19 | 8 | 4 | 44 |
55601 | 55601 | 2020-04-11 | Sutter | 101 | 0 | 0 | |||
55602 | 55602 | 2020-04-11 | Tehama | 103 | 0 | 0 | 0 | 0 | 7 |
55603 | 55603 | 2020-04-11 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55604 | 55604 | 2020-04-11 | Tulare | 107 | 12 | 3 | 4 | 2 | 19 |
55605 | 55605 | 2020-04-11 | Tuolumne | 109 | 0 | 2 | 0 | 0 | 3 |
55606 | 55606 | 2020-04-11 | Ventura | 111 | 22 | 58 | 9 | 11 | 33 |
55607 | 55607 | 2020-04-11 | Yolo | 113 | 3 | 4 | 1 | 0 | 7 |
55608 | 55608 | 2020-04-11 | Yuba | 115 | 2 | 2 | 2 | 0 | 9 |
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 );