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 |
---|---|---|---|---|---|---|---|---|---|
33881 | 33881 | 2021-05-03 | Alameda | 1 | 75 | 30 | 19 | 3 | 116 |
33882 | 33882 | 2021-05-03 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
33883 | 33883 | 2021-05-03 | Butte | 7 | 14 | 0 | 2 | 0 | 14 |
33884 | 33884 | 2021-05-03 | Calaveras | 9 | 1 | 0 | 0 | 0 | 7 |
33885 | 33885 | 2021-05-03 | Colusa | 11 | 1 | 0 | 0 | 0 | 5 |
33886 | 33886 | 2021-05-03 | Contra Costa | 13 | 26 | 20 | 9 | 2 | 58 |
33887 | 33887 | 2021-05-03 | Del Norte | 15 | 0 | 0 | 0 | 0 | 1 |
33888 | 33888 | 2021-05-03 | El Dorado | 17 | 3 | 0 | 2 | 0 | 2 |
33889 | 33889 | 2021-05-03 | Fresno | 19 | 79 | 6 | 18 | 1 | 15 |
33890 | 33890 | 2021-05-03 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
33891 | 33891 | 2021-05-03 | Humboldt | 23 | 11 | 3 | 5 | 1 | 7 |
33892 | 33892 | 2021-05-03 | Imperial | 25 | 12 | 1 | 5 | 0 | 6 |
33893 | 33893 | 2021-05-03 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
33894 | 33894 | 2021-05-03 | Kern | 29 | 20 | 1 | 4 | 0 | 38 |
33895 | 33895 | 2021-05-03 | Kings | 31 | 4 | 0 | 1 | 0 | 4 |
33896 | 33896 | 2021-05-03 | Lake | 33 | 0 | 1 | 0 | 0 | 2 |
33897 | 33897 | 2021-05-03 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
33898 | 33898 | 2021-05-03 | Los Angeles | 37 | 400 | 88 | 97 | 11 | 721 |
33899 | 33899 | 2021-05-03 | Madera | 39 | 6 | 16 | 1 | 2 | 6 |
33900 | 33900 | 2021-05-03 | Marin | 41 | 4 | 4 | 1 | 1 | 11 |
33901 | 33901 | 2021-05-03 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
33902 | 33902 | 2021-05-03 | Mendocino | 45 | 0 | 0 | 0 | 0 | 7 |
33903 | 33903 | 2021-05-03 | Merced | 47 | 9 | 0 | 3 | 0 | 9 |
33904 | 33904 | 2021-05-03 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
33905 | 33905 | 2021-05-03 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
33906 | 33906 | 2021-05-03 | Monterey | 53 | 9 | 0 | 2 | 0 | 27 |
33907 | 33907 | 2021-05-03 | Napa | 55 | 2 | 0 | 1 | 0 | 5 |
33908 | 33908 | 2021-05-03 | Nevada | 57 | 3 | 0 | 1 | 0 | 3 |
33909 | 33909 | 2021-05-03 | Orange | 59 | 97 | 17 | 26 | 4 | 274 |
33910 | 33910 | 2021-05-03 | Placer | 61 | 38 | 15 | 8 | 2 | 21 |
33911 | 33911 | 2021-05-03 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
33912 | 33912 | 2021-05-03 | Riverside | 65 | 68 | 18 | 17 | 5 | 97 |
33913 | 33913 | 2021-05-03 | Sacramento | 67 | 99 | 16 | 17 | 3 | 99 |
33914 | 33914 | 2021-05-03 | San Benito | 69 | 1 | 0 | 1 | 0 | 1 |
33915 | 33915 | 2021-05-03 | San Bernardino | 71 | 83 | 13 | 26 | 4 | 175 |
33916 | 33916 | 2021-05-03 | San Diego | 73 | 145 | 17 | 41 | 4 | 236 |
33917 | 33917 | 2021-05-03 | San Francisco | 75 | 15 | 6 | 6 | 3 | 143 |
33918 | 33918 | 2021-05-03 | San Joaquin | 77 | 45 | 1 | 16 | 0 | 5 |
33919 | 33919 | 2021-05-03 | San Luis Obispo | 79 | 2 | 0 | 1 | 0 | 25 |
33920 | 33920 | 2021-05-03 | San Mateo | 81 | 19 | 4 | 5 | 0 | 23 |
33921 | 33921 | 2021-05-03 | Santa Barbara | 83 | 6 | 0 | 2 | 0 | 35 |
33922 | 33922 | 2021-05-03 | Santa Clara | 85 | 68 | 14 | 20 | 0 | 94 |
33923 | 33923 | 2021-05-03 | Santa Cruz | 87 | 2 | 0 | 0 | 0 | 11 |
33924 | 33924 | 2021-05-03 | Shasta | 89 | 11 | 0 | 1 | 0 | 21 |
33925 | 33925 | 2021-05-03 | Siskiyou | 93 | 11 | 0 | 2 | 0 | 4 |
33926 | 33926 | 2021-05-03 | Solano | 95 | 30 | 6 | 4 | 0 | 19 |
33927 | 33927 | 2021-05-03 | Sonoma | 97 | 8 | 0 | 3 | 0 | 20 |
33928 | 33928 | 2021-05-03 | Stanislaus | 99 | 115 | 14 | 22 | 3 | 31 |
33929 | 33929 | 2021-05-03 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
33930 | 33930 | 2021-05-03 | Tehama | 103 | 3 | 0 | 1 | 0 | 2 |
33931 | 33931 | 2021-05-03 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
33932 | 33932 | 2021-05-03 | Tulare | 107 | 17 | 6 | 1 | 2 | 23 |
33933 | 33933 | 2021-05-03 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 5 |
33934 | 33934 | 2021-05-03 | Ventura | 111 | 27 | 5 | 3 | 0 | 44 |
33935 | 33935 | 2021-05-03 | Yolo | 113 | 5 | 0 | 0 | 0 | 6 |
33936 | 33936 | 2021-05-03 | Yuba | 115 | 14 | 0 | 1 | 0 | 4 |
33937 | 33937 | 2021-05-02 | Alameda | 1 | 81 | 30 | 20 | 4 | 117 |
33938 | 33938 | 2021-05-02 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
33939 | 33939 | 2021-05-02 | Butte | 7 | 12 | 0 | 2 | 0 | 17 |
33940 | 33940 | 2021-05-02 | Calaveras | 9 | 2 | 0 | 0 | 0 | 8 |
33941 | 33941 | 2021-05-02 | Colusa | 11 | 1 | 0 | 0 | 0 | 5 |
33942 | 33942 | 2021-05-02 | Contra Costa | 13 | 28 | 16 | 10 | 2 | 52 |
33943 | 33943 | 2021-05-02 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
33944 | 33944 | 2021-05-02 | El Dorado | 17 | 2 | 3 | 1 | 0 | 2 |
33945 | 33945 | 2021-05-02 | Fresno | 19 | 87 | 6 | 21 | 1 | 10 |
33946 | 33946 | 2021-05-02 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
33947 | 33947 | 2021-05-02 | Humboldt | 23 | 13 | 1 | 4 | 0 | 6 |
33948 | 33948 | 2021-05-02 | Imperial | 25 | 13 | 1 | 6 | 0 | 3 |
33949 | 33949 | 2021-05-02 | Inyo | 27 | 0 | 0 | 0 | 0 | 2 |
33950 | 33950 | 2021-05-02 | Kern | 29 | 19 | 0 | 4 | 0 | 37 |
33951 | 33951 | 2021-05-02 | Kings | 31 | 4 | 0 | 0 | 0 | 4 |
33952 | 33952 | 2021-05-02 | Lake | 33 | 0 | 1 | 0 | 0 | 1 |
33953 | 33953 | 2021-05-02 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
33954 | 33954 | 2021-05-02 | Los Angeles | 37 | 386 | 98 | 96 | 14 | 705 |
33955 | 33955 | 2021-05-02 | Madera | 39 | 6 | 10 | 2 | 1 | 11 |
33956 | 33956 | 2021-05-02 | Marin | 41 | 5 | 2 | 1 | 1 | 10 |
33957 | 33957 | 2021-05-02 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
33958 | 33958 | 2021-05-02 | Mendocino | 45 | 0 | 0 | 0 | 0 | 3 |
33959 | 33959 | 2021-05-02 | Merced | 47 | 10 | 0 | 3 | 0 | 10 |
33960 | 33960 | 2021-05-02 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
33961 | 33961 | 2021-05-02 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
33962 | 33962 | 2021-05-02 | Monterey | 53 | 9 | 0 | 2 | 0 | 29 |
33963 | 33963 | 2021-05-02 | Napa | 55 | 1 | 0 | 0 | 0 | 1 |
33964 | 33964 | 2021-05-02 | Nevada | 57 | 3 | 0 | 1 | 0 | 2 |
33965 | 33965 | 2021-05-02 | Orange | 59 | 95 | 16 | 21 | 1 | 260 |
33966 | 33966 | 2021-05-02 | Placer | 61 | 38 | 14 | 7 | 3 | 24 |
33967 | 33967 | 2021-05-02 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
33968 | 33968 | 2021-05-02 | Riverside | 65 | 80 | 19 | 16 | 7 | 94 |
33969 | 33969 | 2021-05-02 | Sacramento | 67 | 103 | 12 | 19 | 3 | 95 |
33970 | 33970 | 2021-05-02 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
33971 | 33971 | 2021-05-02 | San Bernardino | 71 | 82 | 15 | 25 | 2 | 157 |
33972 | 33972 | 2021-05-02 | San Diego | 73 | 141 | 12 | 39 | 0 | 245 |
33973 | 33973 | 2021-05-02 | San Francisco | 75 | 16 | 5 | 6 | 0 | 136 |
33974 | 33974 | 2021-05-02 | San Joaquin | 77 | 46 | 7 | 15 | 1 | 6 |
33975 | 33975 | 2021-05-02 | San Luis Obispo | 79 | 1 | 0 | 0 | 0 | 30 |
33976 | 33976 | 2021-05-02 | San Mateo | 81 | 21 | 3 | 5 | 1 | 25 |
33977 | 33977 | 2021-05-02 | Santa Barbara | 83 | 6 | 0 | 2 | 0 | 36 |
33978 | 33978 | 2021-05-02 | Santa Clara | 85 | 72 | 9 | 18 | 0 | 84 |
33979 | 33979 | 2021-05-02 | Santa Cruz | 87 | 3 | 0 | 0 | 0 | 8 |
33980 | 33980 | 2021-05-02 | Shasta | 89 | 11 | 0 | 1 | 0 | 5 |
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 );