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-07
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 |
---|---|---|---|---|---|---|---|---|---|
55777 | 55777 | 2020-04-07 | Alameda | 1 | 76 | 84 | 43 | 25 | 90 |
55778 | 55778 | 2020-04-07 | Amador | 5 | 0 | 0 | 0 | 0 | 3 |
55779 | 55779 | 2020-04-07 | Butte | 7 | 1 | 14 | 1 | 5 | 6 |
55780 | 55780 | 2020-04-07 | Calaveras | 9 | 0 | 1 | 0 | 0 | 8 |
55781 | 55781 | 2020-04-07 | Colusa | 11 | 0 | 0 | 0 | 0 | 6 |
55782 | 55782 | 2020-04-07 | Contra Costa | 13 | 31 | 38 | 17 | 9 | 82 |
55783 | 55783 | 2020-04-07 | Del Norte | 15 | 0 | 3 | 0 | 1 | 2 |
55784 | 55784 | 2020-04-07 | El Dorado | 17 | 16 | 2 | 0 | 3 | 10 |
55785 | 55785 | 2020-04-07 | Fresno | 19 | 20 | 82 | 11 | 13 | 50 |
55786 | 55786 | 2020-04-07 | Glenn | 21 | 0 | 0 | 0 | 0 | |
55787 | 55787 | 2020-04-07 | Humboldt | 23 | 2 | 7 | 0 | 0 | 7 |
55788 | 55788 | 2020-04-07 | Imperial | 25 | 9 | 14 | 7 | 2 | 3 |
55789 | 55789 | 2020-04-07 | Inyo | 27 | 9 | 121 | 1 | 0 | 3 |
55790 | 55790 | 2020-04-07 | Kern | 29 | 28 | 91 | 14 | 13 | 50 |
55791 | 55791 | 2020-04-07 | Kings | 31 | 3 | 4 | 2 | 0 | 3 |
55792 | 55792 | 2020-04-07 | Lake | 33 | 0 | 0 | 0 | 0 | 1 |
55793 | 55793 | 2020-04-07 | Lassen | 35 | 0 | 1 | 0 | 0 | |
55794 | 55794 | 2020-04-07 | Los Angeles | 37 | 1251 | 1350 | 517 | 162 | 603 |
55795 | 55795 | 2020-04-07 | Madera | 39 | 0 | 3 | 0 | 1 | 7 |
55796 | 55796 | 2020-04-07 | Marin | 41 | 6 | 5 | 4 | 4 | 12 |
55797 | 55797 | 2020-04-07 | Mariposa | 43 | 0 | 3 | 0 | 0 | |
55798 | 55798 | 2020-04-07 | Mendocino | 45 | 0 | 2 | 0 | 0 | 9 |
55799 | 55799 | 2020-04-07 | Merced | 47 | 3 | 3 | 0 | 3 | 3 |
55800 | 55800 | 2020-04-07 | Modoc | 49 | 0 | 1 | 0 | 0 | |
55801 | 55801 | 2020-04-07 | Mono | 51 | 20 | 2 | 0 | 0 | 2 |
55802 | 55802 | 2020-04-07 | Monterey | 53 | 18 | 25 | 5 | 4 | 21 |
55803 | 55803 | 2020-04-07 | Napa | 55 | 0 | 5 | 0 | 3 | 7 |
55804 | 55804 | 2020-04-07 | Nevada | 57 | 1 | 4 | 1 | 2 | 3 |
55805 | 55805 | 2020-04-07 | Orange | 59 | 143 | 144 | 71 | 29 | 136 |
55806 | 55806 | 2020-04-07 | Placer | 61 | 19 | 18 | 9 | 3 | 20 |
55807 | 55807 | 2020-04-07 | Plumas | 63 | 0 | 1 | 0 | 0 | |
55808 | 55808 | 2020-04-07 | Riverside | 65 | 129 | 207 | 57 | 57 | 129 |
55809 | 55809 | 2020-04-07 | Sacramento | 67 | 74 | 91 | 28 | 18 | 72 |
55810 | 55810 | 2020-04-07 | San Benito | 69 | 3 | 3 | 2 | 0 | 0 |
55811 | 55811 | 2020-04-07 | San Bernardino | 71 | 146 | 178 | 54 | 49 | 126 |
55812 | 55812 | 2020-04-07 | San Diego | 73 | 203 | 124 | 87 | 29 | 189 |
55813 | 55813 | 2020-04-07 | San Francisco | 75 | 88 | 116 | 36 | 9 | 57 |
55814 | 55814 | 2020-04-07 | San Joaquin | 77 | 31 | 33 | 14 | 4 | 20 |
55815 | 55815 | 2020-04-07 | San Luis Obispo | 79 | 2 | 5 | 2 | 4 | 30 |
55816 | 55816 | 2020-04-07 | San Mateo | 81 | 63 | 13 | 26 | 2 | 35 |
55817 | 55817 | 2020-04-07 | Santa Barbara | 83 | 41 | 8 | 23 | 1 | 48 |
55818 | 55818 | 2020-04-07 | Santa Clara | 85 | 187 | 47 | 77 | 7 | 105 |
55819 | 55819 | 2020-04-07 | Santa Cruz | 87 | 4 | 4 | 4 | 3 | 4 |
55820 | 55820 | 2020-04-07 | Shasta | 89 | 5 | 8 | 2 | 3 | 6 |
55821 | 55821 | 2020-04-07 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 5 |
55822 | 55822 | 2020-04-07 | Solano | 95 | 14 | 24 | 7 | 6 | 31 |
55823 | 55823 | 2020-04-07 | Sonoma | 97 | 6 | 28 | 2 | 6 | 21 |
55824 | 55824 | 2020-04-07 | Stanislaus | 99 | 28 | 40 | 13 | 9 | 32 |
55825 | 55825 | 2020-04-07 | Sutter | 101 | 0 | 0 | |||
55826 | 55826 | 2020-04-07 | Tehama | 103 | 0 | 1 | 0 | 0 | 2 |
55827 | 55827 | 2020-04-07 | Trinity | 105 | 0 | 0 | 0 | 0 | |
55828 | 55828 | 2020-04-07 | Tulare | 107 | 8 | 23 | 5 | 6 | 10 |
55829 | 55829 | 2020-04-07 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 0 |
55830 | 55830 | 2020-04-07 | Ventura | 111 | 22 | 68 | 9 | 20 | 31 |
55831 | 55831 | 2020-04-07 | Yolo | 113 | 2 | 3 | 2 | 1 | 4 |
55832 | 55832 | 2020-04-07 | Yuba | 115 | 2 | 25 | 1 | 5 | 6 |
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 );