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-25
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54769 | 54769 | 2020-04-25 | Alameda | 1 | 83 | 53 | 39 | 6 | 197 |
54770 | 54770 | 2020-04-25 | Amador | 5 | 0 | 1 | 0 | 1 | 5 |
54771 | 54771 | 2020-04-25 | Butte | 7 | 0 | 3 | 0 | 0 | 14 |
54772 | 54772 | 2020-04-25 | Calaveras | 9 | 0 | 1 | 0 | 0 | 11 |
54773 | 54773 | 2020-04-25 | Colusa | 11 | 1 | 1 | 1 | 1 | 4 |
54774 | 54774 | 2020-04-25 | Contra Costa | 13 | 25 | 53 | 10 | 6 | 154 |
54775 | 54775 | 2020-04-25 | Del Norte | 15 | 0 | 4 | 0 | 0 | |
54776 | 54776 | 2020-04-25 | El Dorado | 17 | 1 | 7 | 0 | 2 | 11 |
54777 | 54777 | 2020-04-25 | Fresno | 19 | 41 | 45 | 19 | 2 | 86 |
54778 | 54778 | 2020-04-25 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54779 | 54779 | 2020-04-25 | Humboldt | 23 | 0 | 3 | 0 | 0 | 4 |
54780 | 54780 | 2020-04-25 | Imperial | 25 | 24 | 8 | 8 | 1 | 5 |
54781 | 54781 | 2020-04-25 | Inyo | 27 | 0 | 3 | 0 | 0 | 6 |
54782 | 54782 | 2020-04-25 | Kern | 29 | 29 | 18 | 22 | 3 | 56 |
54783 | 54783 | 2020-04-25 | Kings | 31 | 6 | 0 | 2 | 0 | 5 |
54784 | 54784 | 2020-04-25 | Lake | 33 | 0 | 2 | 0 | 0 | 3 |
54785 | 54785 | 2020-04-25 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54786 | 54786 | 2020-04-25 | Los Angeles | 37 | 1845 | 572 | 579 | 99 | 1359 |
54787 | 54787 | 2020-04-25 | Madera | 39 | 0 | 2 | 0 | 1 | 20 |
54788 | 54788 | 2020-04-25 | Marin | 41 | 2 | 13 | 2 | 3 | 16 |
54789 | 54789 | 2020-04-25 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
54790 | 54790 | 2020-04-25 | Mendocino | 45 | 0 | 0 | 0 | 0 | 10 |
54791 | 54791 | 2020-04-25 | Merced | 47 | 0 | 3 | 0 | 1 | 9 |
54792 | 54792 | 2020-04-25 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54793 | 54793 | 2020-04-25 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54794 | 54794 | 2020-04-25 | Monterey | 53 | 5 | 9 | 3 | 0 | 111 |
54795 | 54795 | 2020-04-25 | Napa | 55 | 1 | 1 | 1 | 1 | 1 |
54796 | 54796 | 2020-04-25 | Nevada | 57 | 1 | 3 | 0 | 2 | 2 |
54797 | 54797 | 2020-04-25 | Orange | 59 | 177 | 133 | 74 | 21 | 394 |
54798 | 54798 | 2020-04-25 | Placer | 61 | 4 | 30 | 0 | 3 | 106 |
54799 | 54799 | 2020-04-25 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54800 | 54800 | 2020-04-25 | Riverside | 65 | 218 | 138 | 81 | 30 | 235 |
54801 | 54801 | 2020-04-25 | Sacramento | 67 | 53 | 46 | 20 | 14 | 184 |
54802 | 54802 | 2020-04-25 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
54803 | 54803 | 2020-04-25 | San Bernardino | 71 | 147 | 101 | 53 | 14 | 277 |
54804 | 54804 | 2020-04-25 | San Diego | 73 | 268 | 96 | 110 | 19 | 395 |
54805 | 54805 | 2020-04-25 | San Francisco | 75 | 73 | 18 | 29 | 3 | 132 |
54806 | 54806 | 2020-04-25 | San Joaquin | 77 | 27 | 20 | 12 | 5 | 20 |
54807 | 54807 | 2020-04-25 | San Luis Obispo | 79 | 1 | 4 | 1 | 1 | 28 |
54808 | 54808 | 2020-04-25 | San Mateo | 81 | 47 | 27 | 15 | 11 | 43 |
54809 | 54809 | 2020-04-25 | Santa Barbara | 83 | 23 | 12 | 16 | 4 | 79 |
54810 | 54810 | 2020-04-25 | Santa Clara | 85 | 125 | 47 | 62 | 15 | 203 |
54811 | 54811 | 2020-04-25 | Santa Cruz | 87 | 4 | 4 | 2 | 3 | 4 |
54812 | 54812 | 2020-04-25 | Shasta | 89 | 1 | 0 | 1 | 0 | 11 |
54813 | 54813 | 2020-04-25 | Siskiyou | 93 | 0 | 1 | 0 | 0 | 5 |
54814 | 54814 | 2020-04-25 | Solano | 95 | 10 | 16 | 3 | 4 | 61 |
54815 | 54815 | 2020-04-25 | Sonoma | 97 | 3 | 9 | 0 | 0 | 64 |
54816 | 54816 | 2020-04-25 | Stanislaus | 99 | 21 | 23 | 5 | 1 | 90 |
54817 | 54817 | 2020-04-25 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54818 | 54818 | 2020-04-25 | Tehama | 103 | 0 | 1 | 0 | 1 | 4 |
54819 | 54819 | 2020-04-25 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54820 | 54820 | 2020-04-25 | Tulare | 107 | 26 | 0 | 7 | 0 | 22 |
54821 | 54821 | 2020-04-25 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 4 |
54822 | 54822 | 2020-04-25 | Ventura | 111 | 27 | 71 | 6 | 9 | 51 |
54823 | 54823 | 2020-04-25 | Yolo | 113 | 5 | 0 | 1 | 0 | 18 |
54824 | 54824 | 2020-04-25 | Yuba | 115 | 0 | 2 | 0 | 2 | 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 );