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-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_positive_patients, date (date)
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54881 | 54881 | 2020-04-23 | Alameda | 1 | 81 | 90 | 37 | 24 | 95 |
54882 | 54882 | 2020-04-23 | Amador | 5 | 0 | 1 | 0 | 0 | 2 |
54883 | 54883 | 2020-04-23 | Butte | 7 | 0 | 0 | 0 | 1 | 14 |
54884 | 54884 | 2020-04-23 | Calaveras | 9 | 0 | 1 | 0 | 1 | 11 |
54885 | 54885 | 2020-04-23 | Colusa | 11 | 1 | 0 | 1 | 0 | 4 |
54886 | 54886 | 2020-04-23 | Contra Costa | 13 | 31 | 51 | 13 | 13 | 81 |
54887 | 54887 | 2020-04-23 | Del Norte | 15 | 0 | 6 | 0 | 3 | 3 |
54888 | 54888 | 2020-04-23 | El Dorado | 17 | 0 | 8 | 0 | 1 | 15 |
54889 | 54889 | 2020-04-23 | Fresno | 19 | 39 | 39 | 16 | 4 | 52 |
54890 | 54890 | 2020-04-23 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
54891 | 54891 | 2020-04-23 | Humboldt | 23 | 0 | 7 | 0 | 1 | 4 |
54892 | 54892 | 2020-04-23 | Imperial | 25 | 23 | 4 | 9 | 0 | 1 |
54893 | 54893 | 2020-04-23 | Inyo | 27 | 1 | 0 | 1 | 0 | 5 |
54894 | 54894 | 2020-04-23 | Kern | 29 | 30 | 11 | 16 | 1 | 63 |
54895 | 54895 | 2020-04-23 | Kings | 31 | 9 | 0 | 3 | 0 | 4 |
54896 | 54896 | 2020-04-23 | Lake | 33 | 0 | 1 | 0 | 0 | 4 |
54897 | 54897 | 2020-04-23 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
54898 | 54898 | 2020-04-23 | Los Angeles | 37 | 1863 | 595 | 600 | 118 | 1263 |
54899 | 54899 | 2020-04-23 | Madera | 39 | 0 | 3 | 0 | 1 | 16 |
54900 | 54900 | 2020-04-23 | Marin | 41 | 3 | 14 | 2 | 4 | 12 |
54901 | 54901 | 2020-04-23 | Mariposa | 43 | 0 | 1 | 0 | 0 | 0 |
54902 | 54902 | 2020-04-23 | Mendocino | 45 | 0 | 1 | 0 | 1 | 7 |
54903 | 54903 | 2020-04-23 | Merced | 47 | 0 | 2 | 0 | 0 | 7 |
54904 | 54904 | 2020-04-23 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
54905 | 54905 | 2020-04-23 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54906 | 54906 | 2020-04-23 | Monterey | 53 | 6 | 6 | 4 | 1 | 122 |
54907 | 54907 | 2020-04-23 | Napa | 55 | 1 | 1 | 1 | 0 | 2 |
54908 | 54908 | 2020-04-23 | Nevada | 57 | 1 | 3 | 0 | 1 | 6 |
54909 | 54909 | 2020-04-23 | Orange | 59 | 170 | 143 | 75 | 25 | 293 |
54910 | 54910 | 2020-04-23 | Placer | 61 | 4 | 21 | 1 | 1 | 11 |
54911 | 54911 | 2020-04-23 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
54912 | 54912 | 2020-04-23 | Riverside | 65 | 222 | 118 | 83 | 24 | 232 |
54913 | 54913 | 2020-04-23 | Sacramento | 67 | 48 | 40 | 17 | 7 | 80 |
54914 | 54914 | 2020-04-23 | San Benito | 69 | 0 | 0 | 0 | 0 | 1 |
54915 | 54915 | 2020-04-23 | San Bernardino | 71 | 146 | 94 | 54 | 19 | 175 |
54916 | 54916 | 2020-04-23 | San Diego | 73 | 253 | 65 | 105 | 12 | 389 |
54917 | 54917 | 2020-04-23 | San Francisco | 75 | 75 | 29 | 31 | 6 | 70 |
54918 | 54918 | 2020-04-23 | San Joaquin | 77 | 31 | 34 | 15 | 6 | 25 |
54919 | 54919 | 2020-04-23 | San Luis Obispo | 79 | 1 | 4 | 1 | 1 | 30 |
54920 | 54920 | 2020-04-23 | San Mateo | 81 | 53 | 19 | 16 | 1 | 35 |
54921 | 54921 | 2020-04-23 | Santa Barbara | 83 | 24 | 16 | 13 | 4 | 90 |
54922 | 54922 | 2020-04-23 | Santa Clara | 85 | 137 | 28 | 67 | 5 | 137 |
54923 | 54923 | 2020-04-23 | Santa Cruz | 87 | 3 | 3 | 1 | 0 | 9 |
54924 | 54924 | 2020-04-23 | Shasta | 89 | 1 | 0 | 1 | 0 | 16 |
54925 | 54925 | 2020-04-23 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 4 |
54926 | 54926 | 2020-04-23 | Solano | 95 | 11 | 15 | 5 | 4 | 31 |
54927 | 54927 | 2020-04-23 | Sonoma | 97 | 3 | 17 | 0 | 5 | 48 |
54928 | 54928 | 2020-04-23 | Stanislaus | 99 | 14 | 17 | 6 | 2 | 62 |
54929 | 54929 | 2020-04-23 | Sutter | 101 | 0 | 0 | 0 | ||
54930 | 54930 | 2020-04-23 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
54931 | 54931 | 2020-04-23 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
54932 | 54932 | 2020-04-23 | Tulare | 107 | 30 | 1 | 11 | 0 | 16 |
54933 | 54933 | 2020-04-23 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 2 |
54934 | 54934 | 2020-04-23 | Ventura | 111 | 25 | 24 | 10 | 5 | 47 |
54935 | 54935 | 2020-04-23 | Yolo | 113 | 4 | 0 | 1 | 0 | 14 |
54936 | 54936 | 2020-04-23 | Yuba | 115 | 0 | 2 | 0 | 2 | 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 );