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 2022-11-11
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_suspected_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
2689 | 2689 | 2022-11-11 | Alameda | 1 | 85 | 53 | 10 | 8 | 86 |
2690 | 2690 | 2022-11-11 | Amador | 5 | 0 | 1 | 0 | 0 | 0 |
2691 | 2691 | 2022-11-11 | Butte | 7 | 11 | 0 | 4 | 0 | 19 |
2692 | 2692 | 2022-11-11 | Calaveras | 9 | 0 | 0 | 0 | 0 | 3 |
2693 | 2693 | 2022-11-11 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
2694 | 2694 | 2022-11-11 | Contra Costa | 13 | 45 | 46 | 6 | 1 | 39 |
2695 | 2695 | 2022-11-11 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
2696 | 2696 | 2022-11-11 | El Dorado | 17 | 9 | 0 | 1 | 0 | 3 |
2697 | 2697 | 2022-11-11 | Fresno | 19 | 76 | 17 | 11 | 2 | 25 |
2698 | 2698 | 2022-11-11 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
2699 | 2699 | 2022-11-11 | Humboldt | 23 | 6 | 0 | 0 | 0 | 6 |
2700 | 2700 | 2022-11-11 | Imperial | 25 | 9 | 0 | 1 | 0 | 8 |
2701 | 2701 | 2022-11-11 | Inyo | 27 | 0 | 0 | 0 | 0 | 4 |
2702 | 2702 | 2022-11-11 | Kern | 29 | 45 | 0 | 4 | 0 | 23 |
2703 | 2703 | 2022-11-11 | Kings | 31 | 7 | 0 | 0 | 0 | 4 |
2704 | 2704 | 2022-11-11 | Lake | 33 | 2 | 0 | 0 | 0 | 1 |
2705 | 2705 | 2022-11-11 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
2706 | 2706 | 2022-11-11 | Los Angeles | 37 | 531 | 47 | 59 | 6 | 562 |
2707 | 2707 | 2022-11-11 | Madera | 39 | 8 | 3 | 2 | 1 | 5 |
2708 | 2708 | 2022-11-11 | Marin | 41 | 13 | 2 | 0 | 0 | 11 |
2709 | 2709 | 2022-11-11 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
2710 | 2710 | 2022-11-11 | Mendocino | 45 | 3 | 0 | 0 | 0 | 1 |
2711 | 2711 | 2022-11-11 | Merced | 47 | 7 | 0 | 0 | 0 | 14 |
2712 | 2712 | 2022-11-11 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
2713 | 2713 | 2022-11-11 | Mono | 51 | 0 | 0 | 0 | 0 | 2 |
2714 | 2714 | 2022-11-11 | Monterey | 53 | 20 | 1 | 1 | 0 | 24 |
2715 | 2715 | 2022-11-11 | Napa | 55 | 9 | 0 | 0 | 0 | 7 |
2716 | 2716 | 2022-11-11 | Nevada | 57 | 3 | 3 | 2 | 0 | 5 |
2717 | 2717 | 2022-11-11 | Orange | 59 | 105 | 9 | 18 | 1 | 136 |
2718 | 2718 | 2022-11-11 | Placer | 61 | 54 | 14 | 8 | 1 | 18 |
2719 | 2719 | 2022-11-11 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
2720 | 2720 | 2022-11-11 | Riverside | 65 | 82 | 15 | 6 | 3 | 103 |
2721 | 2721 | 2022-11-11 | Sacramento | 67 | 92 | 37 | 13 | 9 | 59 |
2722 | 2722 | 2022-11-11 | San Benito | 69 | 0 | 0 | 0 | 0 | 0 |
2723 | 2723 | 2022-11-11 | San Bernardino | 71 | 99 | 5 | 10 | 0 | 139 |
2724 | 2724 | 2022-11-11 | San Diego | 73 | 156 | 12 | 26 | 1 | 227 |
2725 | 2725 | 2022-11-11 | San Francisco | 75 | 53 | 11 | 10 | 2 | 70 |
2726 | 2726 | 2022-11-11 | San Joaquin | 77 | 19 | 3 | 3 | 0 | 11 |
2727 | 2727 | 2022-11-11 | San Luis Obispo | 79 | 6 | 0 | 3 | 0 | 18 |
2728 | 2728 | 2022-11-11 | San Mateo | 81 | 20 | 21 | 1 | 1 | 15 |
2729 | 2729 | 2022-11-11 | Santa Barbara | 83 | 14 | 0 | 0 | 0 | 19 |
2730 | 2730 | 2022-11-11 | Santa Clara | 85 | 124 | 32 | 20 | 7 | 26 |
2731 | 2731 | 2022-11-11 | Santa Cruz | 87 | 7 | 0 | 0 | 0 | 2 |
2732 | 2732 | 2022-11-11 | Shasta | 89 | 10 | 0 | 1 | 0 | 19 |
2733 | 2733 | 2022-11-11 | Siskiyou | 93 | 2 | 0 | 0 | 0 | 3 |
2734 | 2734 | 2022-11-11 | Solano | 95 | 26 | 28 | 4 | 5 | 12 |
2735 | 2735 | 2022-11-11 | Sonoma | 97 | 13 | 5 | 0 | 0 | 25 |
2736 | 2736 | 2022-11-11 | Stanislaus | 99 | 54 | 15 | 7 | 2 | 23 |
2737 | 2737 | 2022-11-11 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
2738 | 2738 | 2022-11-11 | Tehama | 103 | 2 | 0 | 0 | 0 | 6 |
2739 | 2739 | 2022-11-11 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
2740 | 2740 | 2022-11-11 | Tulare | 107 | 10 | 0 | 0 | 0 | 29 |
2741 | 2741 | 2022-11-11 | Tuolumne | 109 | 3 | 0 | 0 | 0 | 5 |
2742 | 2742 | 2022-11-11 | Ventura | 111 | 35 | 2 | 2 | 0 | 37 |
2743 | 2743 | 2022-11-11 | Yolo | 113 | 4 | 0 | 0 | 0 | 0 |
2744 | 2744 | 2022-11-11 | Yuba | 115 | 5 | 0 | 1 | 0 | 8 |
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 );