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 2021-03-11
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 |
---|---|---|---|---|---|---|---|---|---|
36849 | 36849 | 2021-03-11 | Alameda | 1 | 107 | 30 | 31 | 1 | 86 |
36850 | 36850 | 2021-03-11 | Amador | 5 | 2 | 0 | 1 | 0 | 3 |
36851 | 36851 | 2021-03-11 | Butte | 7 | 21 | 0 | 4 | 0 | 11 |
36852 | 36852 | 2021-03-11 | Calaveras | 9 | 0 | 0 | 0 | 0 | 6 |
36853 | 36853 | 2021-03-11 | Colusa | 11 | 1 | 1 | 0 | 0 | 5 |
36854 | 36854 | 2021-03-11 | Contra Costa | 13 | 50 | 11 | 18 | 4 | 37 |
36855 | 36855 | 2021-03-11 | Del Norte | 15 | 0 | 0 | 0 | 0 | 4 |
36856 | 36856 | 2021-03-11 | El Dorado | 17 | 2 | 0 | 0 | 0 | 6 |
36857 | 36857 | 2021-03-11 | Fresno | 19 | 147 | 25 | 37 | 1 | 16 |
36858 | 36858 | 2021-03-11 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
36859 | 36859 | 2021-03-11 | Humboldt | 23 | 4 | 3 | 2 | 0 | 2 |
36860 | 36860 | 2021-03-11 | Imperial | 25 | 15 | 0 | 7 | 0 | 3 |
36861 | 36861 | 2021-03-11 | Inyo | 27 | 3 | 0 | 1 | 0 | 1 |
36862 | 36862 | 2021-03-11 | Kern | 29 | 98 | 8 | 34 | 0 | 33 |
36863 | 36863 | 2021-03-11 | Kings | 31 | 20 | 0 | 3 | 0 | 8 |
36864 | 36864 | 2021-03-11 | Lake | 33 | 1 | 0 | 1 | 0 | 0 |
36865 | 36865 | 2021-03-11 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
36866 | 36866 | 2021-03-11 | Los Angeles | 37 | 979 | 167 | 285 | 20 | 578 |
36867 | 36867 | 2021-03-11 | Madera | 39 | 8 | 10 | 2 | 0 | 12 |
36868 | 36868 | 2021-03-11 | Marin | 41 | 15 | 3 | 7 | 0 | 8 |
36869 | 36869 | 2021-03-11 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
36870 | 36870 | 2021-03-11 | Mendocino | 45 | 2 | 0 | 1 | 0 | 4 |
36871 | 36871 | 2021-03-11 | Merced | 47 | 23 | 0 | 7 | 0 | 6 |
36872 | 36872 | 2021-03-11 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
36873 | 36873 | 2021-03-11 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
36874 | 36874 | 2021-03-11 | Monterey | 53 | 35 | 0 | 8 | 0 | 22 |
36875 | 36875 | 2021-03-11 | Napa | 55 | 5 | 0 | 2 | 0 | 5 |
36876 | 36876 | 2021-03-11 | Nevada | 57 | 6 | 0 | 2 | 0 | 2 |
36877 | 36877 | 2021-03-11 | Orange | 59 | 245 | 21 | 74 | 5 | 237 |
36878 | 36878 | 2021-03-11 | Placer | 61 | 30 | 12 | 9 | 3 | 26 |
36879 | 36879 | 2021-03-11 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
36880 | 36880 | 2021-03-11 | Riverside | 65 | 217 | 25 | 52 | 4 | 85 |
36881 | 36881 | 2021-03-11 | Sacramento | 67 | 118 | 19 | 30 | 6 | 76 |
36882 | 36882 | 2021-03-11 | San Benito | 69 | 1 | 0 | 0 | 0 | 0 |
36883 | 36883 | 2021-03-11 | San Bernardino | 71 | 217 | 34 | 54 | 2 | 146 |
36884 | 36884 | 2021-03-11 | San Diego | 73 | 293 | 23 | 90 | 4 | 249 |
36885 | 36885 | 2021-03-11 | San Francisco | 75 | 41 | 10 | 19 | 0 | 87 |
36886 | 36886 | 2021-03-11 | San Joaquin | 77 | 75 | 8 | 25 | 2 | 10 |
36887 | 36887 | 2021-03-11 | San Luis Obispo | 79 | 9 | 1 | 1 | 0 | 20 |
36888 | 36888 | 2021-03-11 | San Mateo | 81 | 38 | 8 | 15 | 3 | 21 |
36889 | 36889 | 2021-03-11 | Santa Barbara | 83 | 43 | 0 | 15 | 0 | 32 |
36890 | 36890 | 2021-03-11 | Santa Clara | 85 | 131 | 16 | 45 | 6 | 68 |
36891 | 36891 | 2021-03-11 | Santa Cruz | 87 | 6 | 1 | 2 | 0 | 5 |
36892 | 36892 | 2021-03-11 | Shasta | 89 | 9 | 0 | 3 | 0 | 18 |
36893 | 36893 | 2021-03-11 | Siskiyou | 93 | 3 | 0 | 2 | 0 | 6 |
36894 | 36894 | 2021-03-11 | Solano | 95 | 21 | 7 | 6 | 1 | 22 |
36895 | 36895 | 2021-03-11 | Sonoma | 97 | 21 | 1 | 10 | 0 | 14 |
36896 | 36896 | 2021-03-11 | Stanislaus | 99 | 128 | 16 | 26 | 2 | 19 |
36897 | 36897 | 2021-03-11 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
36898 | 36898 | 2021-03-11 | Tehama | 103 | 6 | 0 | 1 | 0 | 4 |
36899 | 36899 | 2021-03-11 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
36900 | 36900 | 2021-03-11 | Tulare | 107 | 36 | 7 | 7 | 0 | 30 |
36901 | 36901 | 2021-03-11 | Tuolumne | 109 | 2 | 0 | 0 | 0 | 2 |
36902 | 36902 | 2021-03-11 | Ventura | 111 | 88 | 6 | 22 | 0 | 49 |
36903 | 36903 | 2021-03-11 | Yolo | 113 | 1 | 4 | 2 | 0 | 2 |
36904 | 36904 | 2021-03-11 | Yuba | 115 | 12 | 0 | 3 | 0 | 2 |
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 );