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-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_suspected_patients
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
55945 | 55945 | 2020-04-04 | Alameda | 1 | 60 | 95 | 35 | 18 | 120 |
55946 | 55946 | 2020-04-04 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
55947 | 55947 | 2020-04-04 | Butte | 7 | 3 | 14 | 1 | 4 | 7 |
55948 | 55948 | 2020-04-04 | Calaveras | 9 | 0 | 1 | 0 | 0 | 5 |
55949 | 55949 | 2020-04-04 | Colusa | 11 | 1 | 0 | 1 | 0 | 5 |
55950 | 55950 | 2020-04-04 | Contra Costa | 13 | 30 | 47 | 12 | 7 | 87 |
55951 | 55951 | 2020-04-04 | Del Norte | 15 | 0 | 2 | 0 | 0 | 1 |
55952 | 55952 | 2020-04-04 | El Dorado | 17 | 15 | 9 | 0 | 3 | 12 |
55953 | 55953 | 2020-04-04 | Fresno | 19 | 14 | 93 | 7 | 20 | 36 |
55954 | 55954 | 2020-04-04 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55955 | 55955 | 2020-04-04 | Humboldt | 23 | 1 | 4 | 0 | 0 | 7 |
55956 | 55956 | 2020-04-04 | Imperial | 25 | 9 | 10 | 5 | 2 | 5 |
55957 | 55957 | 2020-04-04 | Inyo | 27 | 8 | 106 | 1 | 1 | 2 |
55958 | 55958 | 2020-04-04 | Kern | 29 | 33 | 54 | 14 | 11 | 29 |
55959 | 55959 | 2020-04-04 | Kings | 31 | 1 | 9 | 1 | 0 | 0 |
55960 | 55960 | 2020-04-04 | Lake | 33 | 0 | 4 | 0 | 1 | 4 |
55961 | 55961 | 2020-04-04 | Lassen | 35 | 0 | 0 | 0 | 0 | |
55962 | 55962 | 2020-04-04 | Los Angeles | 37 | 1007 | 1190 | 449 | 181 | 537 |
55963 | 55963 | 2020-04-04 | Madera | 39 | 0 | 4 | 0 | 0 | 8 |
55964 | 55964 | 2020-04-04 | Marin | 41 | 5 | 16 | 3 | 5 | 12 |
55965 | 55965 | 2020-04-04 | Mariposa | 43 | 0 | 2 | 0 | 0 | |
55966 | 55966 | 2020-04-04 | Mendocino | 45 | 0 | 3 | 0 | 1 | 7 |
55967 | 55967 | 2020-04-04 | Merced | 47 | 5 | 14 | 1 | 1 | 6 |
55968 | 55968 | 2020-04-04 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55969 | 55969 | 2020-04-04 | Mono | 51 | 20 | 2 | 0 | 0 | 2 |
55970 | 55970 | 2020-04-04 | Monterey | 53 | 16 | 25 | 4 | 2 | 18 |
55971 | 55971 | 2020-04-04 | Napa | 55 | 1 | 8 | 0 | 1 | 6 |
55972 | 55972 | 2020-04-04 | Nevada | 57 | 2 | 6 | 2 | 2 | 5 |
55973 | 55973 | 2020-04-04 | Orange | 59 | 143 | 213 | 70 | 45 | 153 |
55974 | 55974 | 2020-04-04 | Placer | 61 | 23 | 14 | 10 | 1 | 12 |
55975 | 55975 | 2020-04-04 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55976 | 55976 | 2020-04-04 | Riverside | 65 | 126 | 186 | 39 | 56 | 125 |
55977 | 55977 | 2020-04-04 | Sacramento | 67 | 69 | 76 | 25 | 18 | 82 |
55978 | 55978 | 2020-04-04 | San Benito | 69 | 2 | 3 | 2 | 0 | 0 |
55979 | 55979 | 2020-04-04 | San Bernardino | 71 | 138 | 254 | 51 | 66 | 67 |
55980 | 55980 | 2020-04-04 | San Diego | 73 | 177 | 218 | 86 | 19 | 222 |
55981 | 55981 | 2020-04-04 | San Francisco | 75 | 80 | 65 | 37 | 7 | 79 |
55982 | 55982 | 2020-04-04 | San Joaquin | 77 | 43 | 30 | 16 | 7 | 24 |
55983 | 55983 | 2020-04-04 | San Luis Obispo | 79 | 4 | 6 | 3 | 3 | 954 |
55984 | 55984 | 2020-04-04 | San Mateo | 81 | 66 | 19 | 25 | 6 | 40 |
55985 | 55985 | 2020-04-04 | Santa Barbara | 83 | 28 | 34 | 18 | 2 | 53 |
55986 | 55986 | 2020-04-04 | Santa Clara | 85 | 159 | 79 | 72 | 19 | 91 |
55987 | 55987 | 2020-04-04 | Santa Cruz | 87 | 4 | 6 | 3 | 0 | 7 |
55988 | 55988 | 2020-04-04 | Shasta | 89 | 2 | 10 | 4 | 0 | 13 |
55989 | 55989 | 2020-04-04 | Siskiyou | 93 | 0 | 2 | 0 | 1 | 5 |
55990 | 55990 | 2020-04-04 | Solano | 95 | 16 | 19 | 7 | 2 | 23 |
55991 | 55991 | 2020-04-04 | Sonoma | 97 | 7 | 16 | 2 | 6 | 15 |
55992 | 55992 | 2020-04-04 | Stanislaus | 99 | 30 | 45 | 12 | 9 | 26 |
55993 | 55993 | 2020-04-04 | Sutter | 101 | 0 | 0 | |||
55994 | 55994 | 2020-04-04 | Tehama | 103 | 0 | 1 | 0 | 0 | 8 |
55995 | 55995 | 2020-04-04 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55996 | 55996 | 2020-04-04 | Tulare | 107 | 8 | 20 | 5 | 1 | 6 |
55997 | 55997 | 2020-04-04 | Tuolumne | 109 | 0 | 1 | 0 | 1 | 2 |
55998 | 55998 | 2020-04-04 | Ventura | 111 | 21 | 127 | 7 | 25 | 10 |
55999 | 55999 | 2020-04-04 | Yolo | 113 | 4 | 5 | 3 | 3 | 4 |
56000 | 56000 | 2020-04-04 | Yuba | 115 | 2 | 16 | 2 | 2 | 7 |
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 );