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-06
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 |
---|---|---|---|---|---|---|---|---|---|
55833 | 55833 | 2020-04-06 | Alameda | 1 | 79 | 70 | 43 | 19 | 92 |
55834 | 55834 | 2020-04-06 | Amador | 5 | 0 | 0 | 0 | 0 | 2 |
55835 | 55835 | 2020-04-06 | Butte | 7 | 1 | 15 | 1 | 5 | 9 |
55836 | 55836 | 2020-04-06 | Calaveras | 9 | 0 | 0 | 0 | 0 | 6 |
55837 | 55837 | 2020-04-06 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55838 | 55838 | 2020-04-06 | Contra Costa | 13 | 30 | 28 | 15 | 11 | 78 |
55839 | 55839 | 2020-04-06 | Del Norte | 15 | 0 | 3 | 0 | 0 | 0 |
55840 | 55840 | 2020-04-06 | El Dorado | 17 | 16 | 1 | 0 | 0 | 10 |
55841 | 55841 | 2020-04-06 | Fresno | 19 | 18 | 81 | 11 | 20 | 45 |
55842 | 55842 | 2020-04-06 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55843 | 55843 | 2020-04-06 | Humboldt | 23 | 3 | 12 | 0 | 3 | 2 |
55844 | 55844 | 2020-04-06 | Imperial | 25 | 9 | 14 | 7 | 2 | 3 |
55845 | 55845 | 2020-04-06 | Inyo | 27 | 9 | 114 | 1 | 0 | 3 |
55846 | 55846 | 2020-04-06 | Kern | 29 | 24 | 36 | 12 | 5 | 39 |
55847 | 55847 | 2020-04-06 | Kings | 31 | 3 | 3 | 2 | 0 | 3 |
55848 | 55848 | 2020-04-06 | Lake | 33 | 0 | 8 | 0 | 2 | 1 |
55849 | 55849 | 2020-04-06 | Lassen | 35 | 0 | 0 | 0 | 0 | |
55850 | 55850 | 2020-04-06 | Los Angeles | 37 | 1166 | 1070 | 486 | 175 | 587 |
55851 | 55851 | 2020-04-06 | Madera | 39 | 0 | 2 | 0 | 1 | 8 |
55852 | 55852 | 2020-04-06 | Marin | 41 | 8 | 8 | 4 | 4 | 13 |
55853 | 55853 | 2020-04-06 | Mariposa | 43 | 0 | 3 | 0 | 0 | |
55854 | 55854 | 2020-04-06 | Mendocino | 45 | 0 | 2 | 0 | 2 | 10 |
55855 | 55855 | 2020-04-06 | Merced | 47 | 4 | 2 | 0 | 2 | 4 |
55856 | 55856 | 2020-04-06 | Modoc | 49 | 0 | 0 | 0 | 0 | |
55857 | 55857 | 2020-04-06 | Mono | 51 | 20 | 2 | 0 | 0 | 2 |
55858 | 55858 | 2020-04-06 | Monterey | 53 | 16 | 15 | 5 | 1 | 18 |
55859 | 55859 | 2020-04-06 | Napa | 55 | 0 | 7 | 0 | 0 | 15 |
55860 | 55860 | 2020-04-06 | Nevada | 57 | 1 | 5 | 1 | 2 | 4 |
55861 | 55861 | 2020-04-06 | Orange | 59 | 145 | 171 | 73 | 33 | 134 |
55862 | 55862 | 2020-04-06 | Placer | 61 | 20 | 12 | 10 | 1 | 24 |
55863 | 55863 | 2020-04-06 | Plumas | 63 | 0 | 0 | 0 | 0 | |
55864 | 55864 | 2020-04-06 | Riverside | 65 | 129 | 193 | 46 | 65 | 152 |
55865 | 55865 | 2020-04-06 | Sacramento | 67 | 77 | 78 | 26 | 19 | 75 |
55866 | 55866 | 2020-04-06 | San Benito | 69 | 3 | 3 | 2 | 0 | 0 |
55867 | 55867 | 2020-04-06 | San Bernardino | 71 | 148 | 185 | 60 | 43 | 102 |
55868 | 55868 | 2020-04-06 | San Diego | 73 | 187 | 224 | 83 | 25 | 270 |
55869 | 55869 | 2020-04-06 | San Francisco | 75 | 80 | 71 | 34 | 9 | 71 |
55870 | 55870 | 2020-04-06 | San Joaquin | 77 | 31 | 32 | 14 | 3 | 20 |
55871 | 55871 | 2020-04-06 | San Luis Obispo | 79 | 2 | 3 | 2 | 2 | 42 |
55872 | 55872 | 2020-04-06 | San Mateo | 81 | 68 | 20 | 25 | 5 | 36 |
55873 | 55873 | 2020-04-06 | Santa Barbara | 83 | 34 | 26 | 19 | 5 | 54 |
55874 | 55874 | 2020-04-06 | Santa Clara | 85 | 181 | 49 | 79 | 10 | 100 |
55875 | 55875 | 2020-04-06 | Santa Cruz | 87 | 5 | 9 | 4 | 2 | 5 |
55876 | 55876 | 2020-04-06 | Shasta | 89 | 6 | 3 | 2 | 2 | 28 |
55877 | 55877 | 2020-04-06 | Siskiyou | 93 | 0 | 0 | 0 | 0 | 5 |
55878 | 55878 | 2020-04-06 | Solano | 95 | 15 | 21 | 6 | 6 | 28 |
55879 | 55879 | 2020-04-06 | Sonoma | 97 | 6 | 18 | 2 | 4 | 20 |
55880 | 55880 | 2020-04-06 | Stanislaus | 99 | 28 | 28 | 12 | 4 | 37 |
55881 | 55881 | 2020-04-06 | Sutter | 101 | 0 | 0 | |||
55882 | 55882 | 2020-04-06 | Tehama | 103 | 0 | 0 | 0 | 0 | 4 |
55883 | 55883 | 2020-04-06 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55884 | 55884 | 2020-04-06 | Tulare | 107 | 12 | 24 | 8 | 3 | 16 |
55885 | 55885 | 2020-04-06 | Tuolumne | 109 | 0 | 0 | 0 | 0 | |
55886 | 55886 | 2020-04-06 | Ventura | 111 | 22 | 106 | 9 | 20 | 32 |
55887 | 55887 | 2020-04-06 | Yolo | 113 | 4 | 0 | 3 | 4 | -3 |
55888 | 55888 | 2020-04-06 | Yuba | 115 | 1 | 19 | 1 | 3 | 7 |
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 );