cdph-hospital-patient-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
56 rows where "date" is on date 2020-04-21
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54993 | 54993 | 2020-04-21 | Alameda | 1 | 85 | 59 | 41 | 9 | 66 |
54994 | 54994 | 2020-04-21 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
54995 | 54995 | 2020-04-21 | Butte | 7 | 0 | 1 | 0 | 1 | 19 |
54996 | 54996 | 2020-04-21 | Calaveras | 9 | 0 | 0 | 0 | 0 | 12 |
54997 | 54997 | 2020-04-21 | Colusa | 11 | 1 | 0 | 1 | 0 | 4 |
54998 | 54998 | 2020-04-21 | Contra Costa | 13 | 33 | 44 | 13 | 11 | 71 |
54999 | 54999 | 2020-04-21 | Del Norte | 15 | 0 | 1 | 0 | 0 | 3 |
55000 | 55000 | 2020-04-21 | El Dorado | 17 | 0 | 3 | 0 | 0 | 12 |
55001 | 55001 | 2020-04-21 | Fresno | 19 | 35 | 35 | 15 | 3 | 46 |
55002 | 55002 | 2020-04-21 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55003 | 55003 | 2020-04-21 | Humboldt | 23 | 0 | 5 | 0 | 0 | 6 |
55004 | 55004 | 2020-04-21 | Imperial | 25 | 23 | 12 | 12 | 0 | 1 |
55005 | 55005 | 2020-04-21 | Inyo | 27 | 1 | 0 | 1 | 0 | 3 |
55006 | 55006 | 2020-04-21 | Kern | 29 | 31 | 12 | 13 | 1 | 57 |
55007 | 55007 | 2020-04-21 | Kings | 31 | 8 | 0 | 3 | 0 | 6 |
55008 | 55008 | 2020-04-21 | Lake | 33 | 0 | 2 | 0 | 0 | 6 |
55009 | 55009 | 2020-04-21 | Lassen | 35 | 0 | 1 | 0 | 0 | |
55010 | 55010 | 2020-04-21 | Los Angeles | 37 | 1854 | 617 | 613 | 111 | 941 |
55011 | 55011 | 2020-04-21 | Madera | 39 | 0 | 5 | 0 | 0 | 15 |
55012 | 55012 | 2020-04-21 | Marin | 41 | 5 | 4 | 2 | 1 | 11 |
55013 | 55013 | 2020-04-21 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
55014 | 55014 | 2020-04-21 | Mendocino | 45 | 0 | 1 | 0 | 0 | 9 |
55015 | 55015 | 2020-04-21 | Merced | 47 | 0 | 3 | 0 | 2 | 4 |
55016 | 55016 | 2020-04-21 | Modoc | 49 | 0 | 1 | 0 | 0 | |
55017 | 55017 | 2020-04-21 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
55018 | 55018 | 2020-04-21 | Monterey | 53 | 7 | 4 | 2 | 1 | 68 |
55019 | 55019 | 2020-04-21 | Napa | 55 | 1 | 1 | 1 | 0 | 9 |
55020 | 55020 | 2020-04-21 | Nevada | 57 | 1 | 4 | 1 | 2 | 7 |
55021 | 55021 | 2020-04-21 | Orange | 59 | 179 | 129 | 77 | 27 | 277 |
55022 | 55022 | 2020-04-21 | Placer | 61 | 4 | 18 | 2 | 2 | 11 |
55023 | 55023 | 2020-04-21 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55024 | 55024 | 2020-04-21 | Riverside | 65 | 250 | 120 | 81 | 32 | 112 |
55025 | 55025 | 2020-04-21 | Sacramento | 67 | 54 | 39 | 21 | 8 | 72 |
55026 | 55026 | 2020-04-21 | San Benito | 69 | 1 | 0 | 0 | 0 | 2 |
55027 | 55027 | 2020-04-21 | San Bernardino | 71 | 153 | 204 | 51 | 36 | 142 |
55028 | 55028 | 2020-04-21 | San Diego | 73 | 221 | 84 | 98 | 21 | 161 |
55029 | 55029 | 2020-04-21 | San Francisco | 75 | 76 | 45 | 25 | 9 | 79 |
55030 | 55030 | 2020-04-21 | San Joaquin | 77 | 27 | 24 | 16 | 5 | 30 |
55031 | 55031 | 2020-04-21 | San Luis Obispo | 79 | 1 | 5 | 1 | 3 | 25 |
55032 | 55032 | 2020-04-21 | San Mateo | 81 | 53 | 14 | 19 | 2 | 33 |
55033 | 55033 | 2020-04-21 | Santa Barbara | 83 | 26 | 8 | 13 | 5 | 82 |
55034 | 55034 | 2020-04-21 | Santa Clara | 85 | 144 | 34 | 70 | 16 | 120 |
55035 | 55035 | 2020-04-21 | Santa Cruz | 87 | 3 | 2 | 1 | 0 | 16 |
55036 | 55036 | 2020-04-21 | Shasta | 89 | 1 | 0 | 1 | 0 | 16 |
55037 | 55037 | 2020-04-21 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 5 |
55038 | 55038 | 2020-04-21 | Solano | 95 | 6 | 17 | 2 | 0 | 38 |
55039 | 55039 | 2020-04-21 | Sonoma | 97 | 2 | 17 | 0 | 6 | 28 |
55040 | 55040 | 2020-04-21 | Stanislaus | 99 | 11 | 20 | 4 | 7 | 72 |
55041 | 55041 | 2020-04-21 | Sutter | 101 | 0 | 0 | |||
55042 | 55042 | 2020-04-21 | Tehama | 103 | 0 | 0 | 0 | 0 | 3 |
55043 | 55043 | 2020-04-21 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55044 | 55044 | 2020-04-21 | Tulare | 107 | 27 | 0 | 9 | 0 | 15 |
55045 | 55045 | 2020-04-21 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 3 |
55046 | 55046 | 2020-04-21 | Ventura | 111 | 28 | 28 | 9 | 10 | 25 |
55047 | 55047 | 2020-04-21 | Yolo | 113 | 5 | 2 | 1 | 0 | 15 |
55048 | 55048 | 2020-04-21 | Yuba | 115 | 0 | 0 | 0 | 0 | 16 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "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 );