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-22 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 |
---|---|---|---|---|---|---|---|---|---|
54937 | 54937 | 2020-04-22 | Alameda | 1 | 84 | 61 | 38 | 17 | 46 |
54938 | 54938 | 2020-04-22 | Amador | 5 | 0 | 1 | 0 | 0 | 3 |
54939 | 54939 | 2020-04-22 | Butte | 7 | 0 | 0 | 0 | 1 | 17 |
54940 | 54940 | 2020-04-22 | Calaveras | 9 | 0 | 0 | 0 | 0 | 12 |
54941 | 54941 | 2020-04-22 | Colusa | 11 | 1 | 0 | 1 | 0 | 4 |
54942 | 54942 | 2020-04-22 | Contra Costa | 13 | 32 | 52 | 13 | 14 | 75 |
54943 | 54943 | 2020-04-22 | Del Norte | 15 | 0 | 2 | 0 | 1 | 3 |
54944 | 54944 | 2020-04-22 | El Dorado | 17 | 0 | 5 | 0 | 1 | 13 |
54945 | 54945 | 2020-04-22 | Fresno | 19 | 36 | 43 | 14 | 4 | 52 |
54946 | 54946 | 2020-04-22 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54947 | 54947 | 2020-04-22 | Humboldt | 23 | 0 | 8 | 0 | 1 | 8 |
54948 | 54948 | 2020-04-22 | Imperial | 25 | 26 | 8 | 12 | 0 | 1 |
54949 | 54949 | 2020-04-22 | Inyo | 27 | 1 | 0 | 1 | 0 | 4 |
54950 | 54950 | 2020-04-22 | Kern | 29 | 32 | 25 | 14 | 1 | 58 |
54951 | 54951 | 2020-04-22 | Kings | 31 | 9 | 0 | 3 | 0 | 3 |
54952 | 54952 | 2020-04-22 | Lake | 33 | 0 | 3 | 0 | 1 | 4 |
54953 | 54953 | 2020-04-22 | Lassen | 35 | 0 | 1 | 0 | 0 | |
54954 | 54954 | 2020-04-22 | Los Angeles | 37 | 1858 | 590 | 602 | 125 | 1215 |
54955 | 54955 | 2020-04-22 | Madera | 39 | 0 | 3 | 0 | 0 | 22 |
54956 | 54956 | 2020-04-22 | Marin | 41 | 5 | 10 | 2 | 5 | 12 |
54957 | 54957 | 2020-04-22 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
54958 | 54958 | 2020-04-22 | Mendocino | 45 | 0 | 0 | 0 | 0 | 7 |
54959 | 54959 | 2020-04-22 | Merced | 47 | 3 | 3 | 0 | 0 | 4 |
54960 | 54960 | 2020-04-22 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54961 | 54961 | 2020-04-22 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54962 | 54962 | 2020-04-22 | Monterey | 53 | 6 | 3 | 2 | 1 | 95 |
54963 | 54963 | 2020-04-22 | Napa | 55 | 1 | 2 | 1 | 0 | 11 |
54964 | 54964 | 2020-04-22 | Nevada | 57 | 1 | 0 | 1 | 0 | 8 |
54965 | 54965 | 2020-04-22 | Orange | 59 | 172 | 111 | 73 | 21 | 293 |
54966 | 54966 | 2020-04-22 | Placer | 61 | 5 | 20 | 1 | 1 | 10 |
54967 | 54967 | 2020-04-22 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54968 | 54968 | 2020-04-22 | Riverside | 65 | 229 | 127 | 84 | 25 | 176 |
54969 | 54969 | 2020-04-22 | Sacramento | 67 | 47 | 23 | 18 | 5 | 79 |
54970 | 54970 | 2020-04-22 | San Benito | 69 | 0 | 0 | 0 | 0 | 1 |
54971 | 54971 | 2020-04-22 | San Bernardino | 71 | 149 | 201 | 54 | 32 | 167 |
54972 | 54972 | 2020-04-22 | San Diego | 73 | 241 | 77 | 104 | 21 | 365 |
54973 | 54973 | 2020-04-22 | San Francisco | 75 | 75 | 17 | 28 | 3 | 74 |
54974 | 54974 | 2020-04-22 | San Joaquin | 77 | 29 | 28 | 14 | 4 | 25 |
54975 | 54975 | 2020-04-22 | San Luis Obispo | 79 | 1 | 7 | 1 | 3 | 25 |
54976 | 54976 | 2020-04-22 | San Mateo | 81 | 50 | 17 | 15 | 2 | 32 |
54977 | 54977 | 2020-04-22 | Santa Barbara | 83 | 25 | 9 | 13 | 3 | 88 |
54978 | 54978 | 2020-04-22 | Santa Clara | 85 | 137 | 39 | 68 | 9 | 157 |
54979 | 54979 | 2020-04-22 | Santa Cruz | 87 | 3 | 4 | 1 | 1 | 10 |
54980 | 54980 | 2020-04-22 | Shasta | 89 | 1 | 0 | 1 | 0 | 14 |
54981 | 54981 | 2020-04-22 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 4 |
54982 | 54982 | 2020-04-22 | Solano | 95 | 10 | 18 | 2 | 2 | 32 |
54983 | 54983 | 2020-04-22 | Sonoma | 97 | 3 | 16 | 0 | 7 | 27 |
54984 | 54984 | 2020-04-22 | Stanislaus | 99 | 13 | 20 | 5 | 6 | 58 |
54985 | 54985 | 2020-04-22 | Sutter | 101 | 0 | 0 | |||
54986 | 54986 | 2020-04-22 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
54987 | 54987 | 2020-04-22 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54988 | 54988 | 2020-04-22 | Tulare | 107 | 27 | 0 | 9 | 0 | 25 |
54989 | 54989 | 2020-04-22 | Tuolumne | 109 | 0 | 1 | 0 | 0 | 2 |
54990 | 54990 | 2020-04-22 | Ventura | 111 | 27 | 30 | 8 | 9 | 33 |
54991 | 54991 | 2020-04-22 | Yolo | 113 | 4 | 0 | 1 | 0 | 14 |
54992 | 54992 | 2020-04-22 | Yuba | 115 | 0 | 0 | 0 | 0 | 13 |
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 );