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-24 sorted by positive_patients
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients
Link | rowid | date | county | fips | positive_patients ▼ | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54826 | 54826 | 2020-04-24 | Amador | 5 | 0 | 1 | 0 | 0 | 6 |
54827 | 54827 | 2020-04-24 | Butte | 7 | 0 | 4 | 0 | 3 | 18 |
54828 | 54828 | 2020-04-24 | Calaveras | 9 | 0 | 2 | 0 | 1 | 11 |
54831 | 54831 | 2020-04-24 | Del Norte | 15 | 0 | 4 | 0 | 0 | 6 |
54832 | 54832 | 2020-04-24 | El Dorado | 17 | 0 | 7 | 0 | 3 | 12 |
54834 | 54834 | 2020-04-24 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54840 | 54840 | 2020-04-24 | Lake | 33 | 0 | 1 | 0 | 1 | 4 |
54841 | 54841 | 2020-04-24 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54843 | 54843 | 2020-04-24 | Madera | 39 | 0 | 4 | 0 | 0 | 11 |
54845 | 54845 | 2020-04-24 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
54846 | 54846 | 2020-04-24 | Mendocino | 45 | 0 | 1 | 0 | 0 | 9 |
54847 | 54847 | 2020-04-24 | Merced | 47 | 0 | 5 | 0 | 1 | 6 |
54848 | 54848 | 2020-04-24 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54849 | 54849 | 2020-04-24 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54855 | 54855 | 2020-04-24 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54858 | 54858 | 2020-04-24 | San Benito | 69 | 0 | 0 | 0 | 0 | 2 |
54869 | 54869 | 2020-04-24 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 5 |
54873 | 54873 | 2020-04-24 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54874 | 54874 | 2020-04-24 | Tehama | 103 | 0 | 1 | 0 | 1 | 4 |
54875 | 54875 | 2020-04-24 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54877 | 54877 | 2020-04-24 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 4 |
54880 | 54880 | 2020-04-24 | Yuba | 115 | 0 | 2 | 0 | 2 | 10 |
54829 | 54829 | 2020-04-24 | Colusa | 11 | 1 | 0 | 1 | 0 | 5 |
54835 | 54835 | 2020-04-24 | Humboldt | 23 | 1 | 4 | 0 | 1 | 8 |
54837 | 54837 | 2020-04-24 | Inyo | 27 | 1 | 3 | 1 | 0 | 5 |
54851 | 54851 | 2020-04-24 | Napa | 55 | 1 | 0 | 1 | 0 | 7 |
54852 | 54852 | 2020-04-24 | Nevada | 57 | 1 | 4 | 0 | 2 | 6 |
54863 | 54863 | 2020-04-24 | San Luis Obispo | 79 | 1 | 8 | 1 | 5 | 24 |
54868 | 54868 | 2020-04-24 | Shasta | 89 | 1 | 0 | 1 | 0 | 16 |
54844 | 54844 | 2020-04-24 | Marin | 41 | 2 | 11 | 2 | 2 | 12 |
54871 | 54871 | 2020-04-24 | Sonoma | 97 | 3 | 20 | 0 | 3 | 45 |
54854 | 54854 | 2020-04-24 | Placer | 61 | 4 | 18 | 0 | 2 | 43 |
54867 | 54867 | 2020-04-24 | Santa Cruz | 87 | 4 | 1 | 2 | 0 | 12 |
54879 | 54879 | 2020-04-24 | Yolo | 113 | 4 | 0 | 1 | 0 | 17 |
54850 | 54850 | 2020-04-24 | Monterey | 53 | 5 | 8 | 4 | 1 | 112 |
54839 | 54839 | 2020-04-24 | Kings | 31 | 9 | 0 | 2 | 0 | 4 |
54870 | 54870 | 2020-04-24 | Solano | 95 | 10 | 16 | 4 | 3 | 32 |
54872 | 54872 | 2020-04-24 | Stanislaus | 99 | 12 | 15 | 6 | 2 | 58 |
54865 | 54865 | 2020-04-24 | Santa Barbara | 83 | 21 | 11 | 12 | 5 | 80 |
54836 | 54836 | 2020-04-24 | Imperial | 25 | 24 | 10 | 8 | 1 | 6 |
54878 | 54878 | 2020-04-24 | Ventura | 111 | 24 | 63 | 6 | 3 | 40 |
54830 | 54830 | 2020-04-24 | Contra Costa | 13 | 29 | 54 | 12 | 11 | 87 |
54862 | 54862 | 2020-04-24 | San Joaquin | 77 | 29 | 20 | 12 | 4 | 26 |
54838 | 54838 | 2020-04-24 | Kern | 29 | 30 | 17 | 16 | 1 | 59 |
54876 | 54876 | 2020-04-24 | Tulare | 107 | 33 | 0 | 11 | 0 | 19 |
54833 | 54833 | 2020-04-24 | Fresno | 19 | 41 | 37 | 19 | 1 | 47 |
54864 | 54864 | 2020-04-24 | San Mateo | 81 | 49 | 16 | 16 | 4 | 40 |
54857 | 54857 | 2020-04-24 | Sacramento | 67 | 53 | 37 | 17 | 11 | 121 |
54861 | 54861 | 2020-04-24 | San Francisco | 75 | 75 | 19 | 30 | 5 | 108 |
54825 | 54825 | 2020-04-24 | Alameda | 1 | 79 | 63 | 39 | 10 | 110 |
54866 | 54866 | 2020-04-24 | Santa Clara | 85 | 129 | 34 | 60 | 5 | 134 |
54859 | 54859 | 2020-04-24 | San Bernardino | 71 | 152 | 101 | 57 | 16 | 250 |
54853 | 54853 | 2020-04-24 | Orange | 59 | 175 | 138 | 68 | 24 | 391 |
54856 | 54856 | 2020-04-24 | Riverside | 65 | 223 | 120 | 82 | 26 | 222 |
54860 | 54860 | 2020-04-24 | San Diego | 73 | 257 | 78 | 107 | 13 | 408 |
54842 | 54842 | 2020-04-24 | Los Angeles | 37 | 1860 | 546 | 600 | 87 | 1378 |
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 );