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 |
---|---|---|---|---|---|---|---|---|---|
46537 | 46537 | 2020-09-19 | Alameda | 1 | 95 | 48 | 37 | 5 | 112 |
46538 | 46538 | 2020-09-19 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
46539 | 46539 | 2020-09-19 | Butte | 7 | 16 | 1 | 4 | 0 | 17 |
46540 | 46540 | 2020-09-19 | Calaveras | 9 | 0 | 0 | 0 | 0 | 7 |
46541 | 46541 | 2020-09-19 | Colusa | 11 | 2 | 3 | 0 | 0 | 0 |
46542 | 46542 | 2020-09-19 | Contra Costa | 13 | 51 | 25 | 18 | 5 | 49 |
46543 | 46543 | 2020-09-19 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
46544 | 46544 | 2020-09-19 | El Dorado | 17 | 0 | 0 | 0 | 0 | 6 |
46545 | 46545 | 2020-09-19 | Fresno | 19 | 92 | 23 | 28 | 4 | 30 |
46546 | 46546 | 2020-09-19 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
46547 | 46547 | 2020-09-19 | Humboldt | 23 | 2 | 2 | 0 | 1 | 1 |
46548 | 46548 | 2020-09-19 | Imperial | 25 | 18 | 0 | 8 | 0 | 7 |
46549 | 46549 | 2020-09-19 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
46550 | 46550 | 2020-09-19 | Kern | 29 | 72 | 4 | 21 | 0 | 69 |
46551 | 46551 | 2020-09-19 | Kings | 31 | 20 | 0 | 4 | 0 | 11 |
46552 | 46552 | 2020-09-19 | Lake | 33 | 0 | 2 | 0 | 0 | 4 |
46553 | 46553 | 2020-09-19 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
46554 | 46554 | 2020-09-19 | Los Angeles | 37 | 749 | 328 | 207 | 48 | 967 |
46555 | 46555 | 2020-09-19 | Madera | 39 | 14 | 11 | 3 | 0 | 8 |
46556 | 46556 | 2020-09-19 | Marin | 41 | 7 | 5 | 2 | 0 | 9 |
46557 | 46557 | 2020-09-19 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
46558 | 46558 | 2020-09-19 | Mendocino | 45 | 5 | 0 | 1 | 0 | 8 |
46559 | 46559 | 2020-09-19 | Merced | 47 | 9 | 0 | 6 | 0 | 9 |
46560 | 46560 | 2020-09-19 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
46561 | 46561 | 2020-09-19 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
46562 | 46562 | 2020-09-19 | Monterey | 53 | 32 | 2 | 7 | 2 | 30 |
46563 | 46563 | 2020-09-19 | Napa | 55 | 4 | 0 | 2 | 0 | 26 |
46564 | 46564 | 2020-09-19 | Nevada | 57 | 3 | 0 | 0 | 0 | 2 |
46565 | 46565 | 2020-09-19 | Orange | 59 | 185 | 52 | 65 | 7 | 246 |
46566 | 46566 | 2020-09-19 | Placer | 61 | 24 | 30 | 8 | 4 | 31 |
46567 | 46567 | 2020-09-19 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
46568 | 46568 | 2020-09-19 | Riverside | 65 | 138 | 54 | 47 | 7 | 105 |
46569 | 46569 | 2020-09-19 | Sacramento | 67 | 114 | 34 | 43 | 6 | 95 |
46570 | 46570 | 2020-09-19 | San Benito | 69 | 3 | 0 | 1 | 0 | 1 |
46571 | 46571 | 2020-09-19 | San Bernardino | 71 | 167 | 54 | 45 | 11 | 169 |
46572 | 46572 | 2020-09-19 | San Diego | 73 | 203 | 50 | 72 | 10 | 314 |
46573 | 46573 | 2020-09-19 | San Francisco | 75 | 58 | 9 | 18 | 2 | 61 |
46574 | 46574 | 2020-09-19 | San Joaquin | 77 | 57 | 10 | 24 | 0 | 39 |
46575 | 46575 | 2020-09-19 | San Luis Obispo | 79 | 10 | 2 | 4 | 0 | 19 |
46576 | 46576 | 2020-09-19 | San Mateo | 81 | 39 | 6 | 13 | 0 | 32 |
46577 | 46577 | 2020-09-19 | Santa Barbara | 83 | 23 | 3 | 4 | 0 | 64 |
46578 | 46578 | 2020-09-19 | Santa Clara | 85 | 111 | 20 | 38 | 1 | 102 |
46579 | 46579 | 2020-09-19 | Santa Cruz | 87 | 17 | 0 | 2 | 0 | 9 |
46580 | 46580 | 2020-09-19 | Shasta | 89 | 3 | 0 | 0 | 0 | 11 |
46581 | 46581 | 2020-09-19 | Siskiyou | 93 | 0 | 1 | 0 | 0 | 9 |
46582 | 46582 | 2020-09-19 | Solano | 95 | 26 | 11 | 6 | 0 | 7 |
46583 | 46583 | 2020-09-19 | Sonoma | 97 | 22 | 6 | 6 | 0 | 6 |
46584 | 46584 | 2020-09-19 | Stanislaus | 99 | 94 | 18 | 33 | 1 | 29 |
46585 | 46585 | 2020-09-19 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
46586 | 46586 | 2020-09-19 | Tehama | 103 | 2 | 0 | 0 | 0 | 4 |
46587 | 46587 | 2020-09-19 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
46588 | 46588 | 2020-09-19 | Tulare | 107 | 36 | 8 | 4 | 0 | 26 |
46589 | 46589 | 2020-09-19 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 2 |
46590 | 46590 | 2020-09-19 | Ventura | 111 | 48 | 11 | 18 | 4 | 54 |
46591 | 46591 | 2020-09-19 | Yolo | 113 | 5 | 0 | 2 | 0 | 4 |
46592 | 46592 | 2020-09-19 | Yuba | 115 | 21 | 1 | 6 | 0 | 6 |
46593 | 46593 | 2020-09-18 | Alameda | 1 | 99 | 39 | 36 | 5 | 113 |
46594 | 46594 | 2020-09-18 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
46595 | 46595 | 2020-09-18 | Butte | 7 | 14 | 1 | 5 | 1 | 10 |
46596 | 46596 | 2020-09-18 | Calaveras | 9 | 0 | 1 | 0 | 0 | 7 |
46597 | 46597 | 2020-09-18 | Colusa | 11 | 2 | 1 | 0 | 0 | 0 |
46598 | 46598 | 2020-09-18 | Contra Costa | 13 | 45 | 29 | 20 | 8 | 56 |
46599 | 46599 | 2020-09-18 | Del Norte | 15 | 0 | 0 | 0 | 0 | 1 |
46600 | 46600 | 2020-09-18 | El Dorado | 17 | 0 | 0 | 0 | 0 | 8 |
46601 | 46601 | 2020-09-18 | Fresno | 19 | 96 | 18 | 31 | 1 | 21 |
46602 | 46602 | 2020-09-18 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
46603 | 46603 | 2020-09-18 | Humboldt | 23 | 2 | 2 | 0 | 1 | 1 |
46604 | 46604 | 2020-09-18 | Imperial | 25 | 19 | 0 | 8 | 0 | 7 |
46605 | 46605 | 2020-09-18 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
46606 | 46606 | 2020-09-18 | Kern | 29 | 66 | 4 | 18 | 0 | 57 |
46607 | 46607 | 2020-09-18 | Kings | 31 | 24 | 0 | 5 | 0 | 9 |
46608 | 46608 | 2020-09-18 | Lake | 33 | 0 | 1 | 0 | 1 | 3 |
46609 | 46609 | 2020-09-18 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
46610 | 46610 | 2020-09-18 | Los Angeles | 37 | 765 | 363 | 227 | 46 | 941 |
46611 | 46611 | 2020-09-18 | Madera | 39 | 13 | 12 | 3 | 2 | 5 |
46612 | 46612 | 2020-09-18 | Marin | 41 | 7 | 4 | 2 | 0 | 9 |
46613 | 46613 | 2020-09-18 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
46614 | 46614 | 2020-09-18 | Mendocino | 45 | 5 | 0 | 2 | 0 | 5 |
46615 | 46615 | 2020-09-18 | Merced | 47 | 9 | 2 | 5 | 1 | 9 |
46616 | 46616 | 2020-09-18 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
46617 | 46617 | 2020-09-18 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
46618 | 46618 | 2020-09-18 | Monterey | 53 | 34 | 1 | 8 | 1 | 38 |
46619 | 46619 | 2020-09-18 | Napa | 55 | 5 | 0 | 3 | 0 | 22 |
46620 | 46620 | 2020-09-18 | Nevada | 57 | 3 | 0 | 0 | 0 | 3 |
46621 | 46621 | 2020-09-18 | Orange | 59 | 202 | 50 | 65 | 9 | 239 |
46622 | 46622 | 2020-09-18 | Placer | 61 | 26 | 28 | 8 | 4 | 30 |
46623 | 46623 | 2020-09-18 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
46624 | 46624 | 2020-09-18 | Riverside | 65 | 148 | 51 | 46 | 8 | 102 |
46625 | 46625 | 2020-09-18 | Sacramento | 67 | 110 | 41 | 41 | 9 | 92 |
46626 | 46626 | 2020-09-18 | San Benito | 69 | 3 | 0 | 0 | 0 | 1 |
46627 | 46627 | 2020-09-18 | San Bernardino | 71 | 169 | 47 | 50 | 10 | 156 |
46628 | 46628 | 2020-09-18 | San Diego | 73 | 208 | 41 | 71 | 11 | 284 |
46629 | 46629 | 2020-09-18 | San Francisco | 75 | 64 | 12 | 20 | 4 | 62 |
46630 | 46630 | 2020-09-18 | San Joaquin | 77 | 55 | 9 | 24 | 1 | 37 |
46631 | 46631 | 2020-09-18 | San Luis Obispo | 79 | 11 | 1 | 4 | 0 | 24 |
46632 | 46632 | 2020-09-18 | San Mateo | 81 | 39 | 9 | 15 | 1 | 29 |
46633 | 46633 | 2020-09-18 | Santa Barbara | 83 | 26 | 2 | 3 | 1 | 60 |
46634 | 46634 | 2020-09-18 | Santa Clara | 85 | 114 | 19 | 39 | 2 | 97 |
46635 | 46635 | 2020-09-18 | Santa Cruz | 87 | 17 | 0 | 2 | 0 | 10 |
46636 | 46636 | 2020-09-18 | Shasta | 89 | 4 | 0 | 0 | 0 | 8 |
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 );