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-27
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: positive_patients, icu_positive_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54657 | 54657 | 2020-04-27 | Alameda | 1 | 81 | 47 | 39 | 8 | 183 |
54658 | 54658 | 2020-04-27 | Amador | 5 | 0 | 0 | 0 | 0 | 5 |
54659 | 54659 | 2020-04-27 | Butte | 7 | 0 | 0 | 0 | 0 | 22 |
54660 | 54660 | 2020-04-27 | Calaveras | 9 | 0 | 1 | 0 | 0 | 12 |
54661 | 54661 | 2020-04-27 | Colusa | 11 | 1 | 1 | 1 | 1 | 4 |
54662 | 54662 | 2020-04-27 | Contra Costa | 13 | 24 | 44 | 10 | 11 | 158 |
54663 | 54663 | 2020-04-27 | Del Norte | 15 | 0 | 5 | 0 | 2 | 5 |
54664 | 54664 | 2020-04-27 | El Dorado | 17 | 1 | 7 | 0 | 2 | 7 |
54665 | 54665 | 2020-04-27 | Fresno | 19 | 39 | 52 | 17 | 3 | 89 |
54666 | 54666 | 2020-04-27 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54667 | 54667 | 2020-04-27 | Humboldt | 23 | 0 | 3 | 0 | 0 | 4 |
54668 | 54668 | 2020-04-27 | Imperial | 25 | 27 | 7 | 11 | 1 | 4 |
54669 | 54669 | 2020-04-27 | Inyo | 27 | 0 | 0 | 0 | 0 | 6 |
54670 | 54670 | 2020-04-27 | Kern | 29 | 31 | 19 | 23 | 2 | 53 |
54671 | 54671 | 2020-04-27 | Kings | 31 | 9 | 2 | 2 | 0 | 5 |
54672 | 54672 | 2020-04-27 | Lake | 33 | 0 | 1 | 0 | 1 | 5 |
54673 | 54673 | 2020-04-27 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54674 | 54674 | 2020-04-27 | Los Angeles | 37 | 1940 | 609 | 592 | 117 | 1226 |
54675 | 54675 | 2020-04-27 | Madera | 39 | 0 | 0 | 0 | 0 | 10 |
54676 | 54676 | 2020-04-27 | Marin | 41 | 2 | 6 | 1 | 0 | 26 |
54677 | 54677 | 2020-04-27 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
54678 | 54678 | 2020-04-27 | Mendocino | 45 | 0 | 1 | 0 | 1 | 7 |
54679 | 54679 | 2020-04-27 | Merced | 47 | 1 | 3 | 0 | 0 | 7 |
54680 | 54680 | 2020-04-27 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54681 | 54681 | 2020-04-27 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
54682 | 54682 | 2020-04-27 | Monterey | 53 | 4 | 2 | 2 | 1 | 120 |
54683 | 54683 | 2020-04-27 | Napa | 55 | 1 | 0 | 1 | 0 | 8 |
54684 | 54684 | 2020-04-27 | Nevada | 57 | 1 | 1 | 0 | 1 | 2 |
54685 | 54685 | 2020-04-27 | Orange | 59 | 189 | 113 | 76 | 23 | 370 |
54686 | 54686 | 2020-04-27 | Placer | 61 | 5 | 17 | 1 | 3 | 111 |
54687 | 54687 | 2020-04-27 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54688 | 54688 | 2020-04-27 | Riverside | 65 | 220 | 118 | 73 | 25 | 208 |
54689 | 54689 | 2020-04-27 | Sacramento | 67 | 46 | 42 | 16 | 13 | 164 |
54690 | 54690 | 2020-04-27 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
54691 | 54691 | 2020-04-27 | San Bernardino | 71 | 154 | 83 | 49 | 18 | 183 |
54692 | 54692 | 2020-04-27 | San Diego | 73 | 277 | 59 | 115 | 15 | 377 |
54693 | 54693 | 2020-04-27 | San Francisco | 75 | 82 | 19 | 29 | 3 | 149 |
54694 | 54694 | 2020-04-27 | San Joaquin | 77 | 24 | 23 | 10 | 6 | 25 |
54695 | 54695 | 2020-04-27 | San Luis Obispo | 79 | 3 | 6 | 2 | 2 | 37 |
54696 | 54696 | 2020-04-27 | San Mateo | 81 | 52 | 28 | 16 | 4 | 62 |
54697 | 54697 | 2020-04-27 | Santa Barbara | 83 | 26 | 13 | 12 | 3 | 82 |
54698 | 54698 | 2020-04-27 | Santa Clara | 85 | 115 | 49 | 56 | 10 | 206 |
54699 | 54699 | 2020-04-27 | Santa Cruz | 87 | 2 | 1 | 1 | 0 | 3 |
54700 | 54700 | 2020-04-27 | Shasta | 89 | 1 | 1 | 1 | 0 | 12 |
54701 | 54701 | 2020-04-27 | Siskiyou | 93 | 0 | 1 | 0 | 1 | 3 |
54702 | 54702 | 2020-04-27 | Solano | 95 | 8 | 16 | 4 | 3 | 60 |
54703 | 54703 | 2020-04-27 | Sonoma | 97 | 2 | 11 | 0 | 2 | 63 |
54704 | 54704 | 2020-04-27 | Stanislaus | 99 | 30 | 36 | 8 | 8 | 90 |
54705 | 54705 | 2020-04-27 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54706 | 54706 | 2020-04-27 | Tehama | 103 | 0 | 0 | 0 | 0 | 3 |
54707 | 54707 | 2020-04-27 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54708 | 54708 | 2020-04-27 | Tulare | 107 | 29 | 0 | 7 | 0 | 27 |
54709 | 54709 | 2020-04-27 | Tuolumne | 109 | 0 | 1 | 0 | 1 | 2 |
54710 | 54710 | 2020-04-27 | Ventura | 111 | 28 | 75 | 6 | 10 | 36 |
54711 | 54711 | 2020-04-27 | Yolo | 113 | 0 | 1 | 0 | 0 | 15 |
54712 | 54712 | 2020-04-27 | Yuba | 115 | 0 | 3 | 0 | 3 | 13 |
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 );