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 |
---|---|---|---|---|---|---|---|---|---|
46637 | 46637 | 2020-09-18 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 9 |
46638 | 46638 | 2020-09-18 | Solano | 95 | 27 | 10 | 7 | 0 | 7 |
46639 | 46639 | 2020-09-18 | Sonoma | 97 | 23 | 4 | 6 | 0 | 10 |
46640 | 46640 | 2020-09-18 | Stanislaus | 99 | 95 | 25 | 30 | 1 | 29 |
46641 | 46641 | 2020-09-18 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
46642 | 46642 | 2020-09-18 | Tehama | 103 | 1 | 0 | 0 | 0 | 4 |
46643 | 46643 | 2020-09-18 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
46644 | 46644 | 2020-09-18 | Tulare | 107 | 38 | 6 | 6 | 0 | 24 |
46645 | 46645 | 2020-09-18 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 2 |
46646 | 46646 | 2020-09-18 | Ventura | 111 | 48 | 13 | 21 | 3 | 51 |
46647 | 46647 | 2020-09-18 | Yolo | 113 | 4 | 0 | 2 | 0 | 4 |
46648 | 46648 | 2020-09-18 | Yuba | 115 | 21 | 1 | 6 | 0 | 8 |
46649 | 46649 | 2020-09-17 | Alameda | 1 | 98 | 37 | 31 | 5 | 117 |
46650 | 46650 | 2020-09-17 | Amador | 5 | 0 | 0 | 0 | 0 | 5 |
46651 | 46651 | 2020-09-17 | Butte | 7 | 9 | 0 | 3 | 0 | 13 |
46652 | 46652 | 2020-09-17 | Calaveras | 9 | 0 | 0 | 0 | 0 | 6 |
46653 | 46653 | 2020-09-17 | Colusa | 11 | 2 | 2 | 0 | 0 | 0 |
46654 | 46654 | 2020-09-17 | Contra Costa | 13 | 55 | 25 | 21 | 5 | 57 |
46655 | 46655 | 2020-09-17 | Del Norte | 15 | 0 | 0 | 0 | 0 | 0 |
46656 | 46656 | 2020-09-17 | El Dorado | 17 | 0 | 0 | 0 | 0 | 10 |
46657 | 46657 | 2020-09-17 | Fresno | 19 | 98 | 33 | 30 | 1 | 23 |
46658 | 46658 | 2020-09-17 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
46659 | 46659 | 2020-09-17 | Humboldt | 23 | 1 | 3 | 0 | 1 | 4 |
46660 | 46660 | 2020-09-17 | Imperial | 25 | 20 | 0 | 8 | 0 | 5 |
46661 | 46661 | 2020-09-17 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
46662 | 46662 | 2020-09-17 | Kern | 29 | 74 | 2 | 21 | 0 | 57 |
46663 | 46663 | 2020-09-17 | Kings | 31 | 23 | 0 | 4 | 0 | 8 |
46664 | 46664 | 2020-09-17 | Lake | 33 | 0 | 2 | 0 | 0 | 2 |
46665 | 46665 | 2020-09-17 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
46666 | 46666 | 2020-09-17 | Los Angeles | 37 | 732 | 340 | 228 | 36 | 941 |
46667 | 46667 | 2020-09-17 | Madera | 39 | 19 | 10 | 2 | 1 | 12 |
46668 | 46668 | 2020-09-17 | Marin | 41 | 10 | 9 | 2 | 1 | 9 |
46669 | 46669 | 2020-09-17 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
46670 | 46670 | 2020-09-17 | Mendocino | 45 | 6 | 1 | 1 | 0 | 4 |
46671 | 46671 | 2020-09-17 | Merced | 47 | 11 | 0 | 5 | 0 | 9 |
46672 | 46672 | 2020-09-17 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
46673 | 46673 | 2020-09-17 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
46674 | 46674 | 2020-09-17 | Monterey | 53 | 30 | 0 | 8 | 0 | 33 |
46675 | 46675 | 2020-09-17 | Napa | 55 | 4 | 3 | 2 | 0 | 24 |
46676 | 46676 | 2020-09-17 | Nevada | 57 | 2 | 0 | 0 | 0 | 5 |
46677 | 46677 | 2020-09-17 | Orange | 59 | 201 | 59 | 64 | 11 | 237 |
46678 | 46678 | 2020-09-17 | Placer | 61 | 26 | 28 | 9 | 0 | 32 |
46679 | 46679 | 2020-09-17 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
46680 | 46680 | 2020-09-17 | Riverside | 65 | 143 | 67 | 44 | 12 | 82 |
46681 | 46681 | 2020-09-17 | Sacramento | 67 | 109 | 32 | 34 | 10 | 101 |
46682 | 46682 | 2020-09-17 | San Benito | 69 | 2 | 0 | 0 | 0 | 2 |
46683 | 46683 | 2020-09-17 | San Bernardino | 71 | 172 | 51 | 55 | 8 | 146 |
46684 | 46684 | 2020-09-17 | San Diego | 73 | 217 | 59 | 77 | 14 | 286 |
46685 | 46685 | 2020-09-17 | San Francisco | 75 | 67 | 19 | 23 | 7 | 61 |
46686 | 46686 | 2020-09-17 | San Joaquin | 77 | 60 | 13 | 25 | 2 | 35 |
46687 | 46687 | 2020-09-17 | San Luis Obispo | 79 | 13 | 1 | 6 | 0 | 25 |
46688 | 46688 | 2020-09-17 | San Mateo | 81 | 39 | 10 | 13 | 1 | 31 |
46689 | 46689 | 2020-09-17 | Santa Barbara | 83 | 27 | 3 | 5 | 0 | 56 |
46690 | 46690 | 2020-09-17 | Santa Clara | 85 | 114 | 16 | 37 | 1 | 89 |
46691 | 46691 | 2020-09-17 | Santa Cruz | 87 | 18 | 0 | 2 | 0 | 10 |
46692 | 46692 | 2020-09-17 | Shasta | 89 | 2 | 0 | 0 | 0 | 7 |
46693 | 46693 | 2020-09-17 | Siskiyou | 93 | 1 | 0 | 0 | 0 | 9 |
46694 | 46694 | 2020-09-17 | Solano | 95 | 29 | 17 | 6 | 3 | 9 |
46695 | 46695 | 2020-09-17 | Sonoma | 97 | 30 | 1 | 8 | 0 | 10 |
46696 | 46696 | 2020-09-17 | Stanislaus | 99 | 98 | 21 | 30 | 3 | 19 |
46697 | 46697 | 2020-09-17 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
46698 | 46698 | 2020-09-17 | Tehama | 103 | 1 | 0 | 0 | 0 | 5 |
46699 | 46699 | 2020-09-17 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
46700 | 46700 | 2020-09-17 | Tulare | 107 | 38 | 9 | 6 | 0 | 21 |
46701 | 46701 | 2020-09-17 | Tuolumne | 109 | 1 | 0 | 0 | 0 | 2 |
46702 | 46702 | 2020-09-17 | Ventura | 111 | 46 | 20 | 18 | 6 | 47 |
46703 | 46703 | 2020-09-17 | Yolo | 113 | 5 | 0 | 2 | 0 | 2 |
46704 | 46704 | 2020-09-17 | Yuba | 115 | 23 | 1 | 6 | 1 | 10 |
46705 | 46705 | 2020-09-16 | Alameda | 1 | 101 | 46 | 33 | 4 | 121 |
46706 | 46706 | 2020-09-16 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
46707 | 46707 | 2020-09-16 | Butte | 7 | 10 | 1 | 3 | 0 | 8 |
46708 | 46708 | 2020-09-16 | Calaveras | 9 | 1 | 0 | 1 | 0 | 6 |
46709 | 46709 | 2020-09-16 | Colusa | 11 | 2 | 1 | 0 | 0 | 0 |
46710 | 46710 | 2020-09-16 | Contra Costa | 13 | 53 | 28 | 22 | 4 | 45 |
46711 | 46711 | 2020-09-16 | Del Norte | 15 | 0 | 0 | 0 | 0 | 0 |
46712 | 46712 | 2020-09-16 | El Dorado | 17 | 0 | 0 | 0 | 0 | 10 |
46713 | 46713 | 2020-09-16 | Fresno | 19 | 100 | 26 | 31 | 0 | 25 |
46714 | 46714 | 2020-09-16 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
46715 | 46715 | 2020-09-16 | Humboldt | 23 | 1 | 2 | 0 | 1 | 5 |
46716 | 46716 | 2020-09-16 | Imperial | 25 | 22 | 1 | 7 | 0 | 6 |
46717 | 46717 | 2020-09-16 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
46718 | 46718 | 2020-09-16 | Kern | 29 | 70 | 3 | 17 | 0 | 54 |
46719 | 46719 | 2020-09-16 | Kings | 31 | 20 | 0 | 3 | 0 | 8 |
46720 | 46720 | 2020-09-16 | Lake | 33 | 0 | 0 | 0 | 0 | 1 |
46721 | 46721 | 2020-09-16 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
46722 | 46722 | 2020-09-16 | Los Angeles | 37 | 739 | 379 | 232 | 40 | 958 |
46723 | 46723 | 2020-09-16 | Madera | 39 | 18 | 11 | 2 | 0 | 9 |
46724 | 46724 | 2020-09-16 | Marin | 41 | 11 | 5 | 2 | 0 | 8 |
46725 | 46725 | 2020-09-16 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
46726 | 46726 | 2020-09-16 | Mendocino | 45 | 6 | 1 | 1 | 0 | 4 |
46727 | 46727 | 2020-09-16 | Merced | 47 | 14 | 1 | 5 | 0 | 5 |
46728 | 46728 | 2020-09-16 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
46729 | 46729 | 2020-09-16 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
46730 | 46730 | 2020-09-16 | Monterey | 53 | 31 | 0 | 9 | 0 | 34 |
46731 | 46731 | 2020-09-16 | Napa | 55 | 4 | 2 | 2 | 0 | 24 |
46732 | 46732 | 2020-09-16 | Nevada | 57 | 3 | 0 | 0 | 0 | 6 |
46733 | 46733 | 2020-09-16 | Orange | 59 | 198 | 53 | 64 | 13 | 250 |
46734 | 46734 | 2020-09-16 | Placer | 61 | 29 | 15 | 9 | 1 | 26 |
46735 | 46735 | 2020-09-16 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
46736 | 46736 | 2020-09-16 | Riverside | 65 | 158 | 60 | 48 | 15 | 92 |
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 );