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,333 rows sorted by icu_available_beds
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds ▼ |
---|---|---|---|---|---|---|---|---|---|
49866 | 49866 | 2020-07-22 | Monterey | 53 | 41 | 2 | 11 | 1 | -110 |
7006 | 7006 | 2022-08-26 | Contra Costa | 13 | 53 | 23 | 8 | 1 | -70 |
6614 | 6614 | 2022-09-02 | Contra Costa | 13 | 53 | 23 | 9 | 4 | -59 |
6645 | 6645 | 2022-09-02 | San Francisco | 75 | 69 | 2 | 9 | 0 | -48 |
49870 | 49870 | 2020-07-22 | Placer | 61 | 53 | 35 | 13 | 3 | -46 |
15755 | 15755 | 2022-03-23 | Madera | 39 | 8 | 4 | 1 | 0 | -39 |
7052 | 7052 | 2022-08-26 | Tulare | 107 | 36 | 2 | 1 | 0 | -22 |
6660 | 6660 | 2022-09-02 | Tulare | 107 | 39 | 1 | 1 | 0 | -20 |
6253 | 6253 | 2022-09-09 | San Francisco | 75 | 82 | 9 | 12 | 2 | -19 |
49873 | 49873 | 2020-07-22 | Sacramento | 67 | 236 | 57 | 65 | 10 | -19 |
49886 | 49886 | 2020-07-22 | Solano | 95 | 57 | 10 | 20 | 0 | -18 |
7037 | 7037 | 2022-08-26 | San Francisco | 75 | 81 | 5 | 9 | 0 | -13 |
3052 | 3052 | 2022-11-05 | Nevada | 57 | 4 | 4 | 0 | 0 | -12 |
6318 | 6318 | 2022-09-08 | Solano | 95 | 28 | 26 | 4 | 3 | -11 |
49846 | 49846 | 2020-07-22 | Contra Costa | 13 | 106 | 41 | 39 | 3 | -11 |
7102 | 7102 | 2022-08-25 | Solano | 95 | 50 | 15 | 7 | 3 | -9 |
49880 | 49880 | 2020-07-22 | San Mateo | 81 | 70 | 13 | 16 | 3 | -9 |
49887 | 49887 | 2020-07-22 | Sonoma | 97 | 38 | 11 | 5 | 2 | -9 |
49841 | 49841 | 2020-07-22 | Alameda | 1 | 166 | 75 | 52 | 7 | -8 |
4172 | 4172 | 2022-10-16 | Nevada | 57 | 4 | 3 | 0 | 0 | -6 |
6222 | 6222 | 2022-09-09 | Contra Costa | 13 | 58 | 22 | 9 | 4 | -6 |
4883 | 4883 | 2022-10-03 | Humboldt | 23 | 7 | 0 | 1 | 0 | -5 |
46414 | 46414 | 2020-09-22 | Solano | 95 | 22 | 20 | 3 | 2 | -5 |
49888 | 49888 | 2020-07-22 | Stanislaus | 99 | 232 | 52 | 51 | 7 | -5 |
4228 | 4228 | 2022-10-15 | Nevada | 57 | 3 | 2 | 0 | 0 | -4 |
4939 | 4939 | 2022-10-02 | Humboldt | 23 | 6 | 0 | 0 | 0 | -4 |
21635 | 21635 | 2021-12-08 | Madera | 39 | 18 | 5 | 3 | 0 | -4 |
43745 | 43745 | 2020-11-08 | Fresno | 19 | 109 | 21 | 26 | 1 | -4 |
3461 | 3461 | 2022-10-29 | Siskiyou | 93 | 1 | 0 | 0 | 0 | -3 |
26267 | 26267 | 2021-09-16 | Butte | 7 | 111 | 1 | 19 | 1 | -3 |
38316 | 38316 | 2021-02-13 | Imperial | 25 | 31 | 2 | 18 | 1 | -3 |
55887 | 55887 | 2020-04-06 | Yolo | 113 | 4 | 0 | 3 | 4 | -3 |
4884 | 4884 | 2022-10-03 | Imperial | 25 | 6 | 0 | 0 | 0 | -2 |
5029 | 5029 | 2022-10-01 | Siskiyou | 93 | 1 | 0 | 0 | 0 | -2 |
5830 | 5830 | 2022-09-16 | Contra Costa | 13 | 79 | 25 | 8 | 2 | -2 |
6709 | 6709 | 2022-09-01 | Siskiyou | 93 | 1 | 1 | 0 | 0 | -2 |
49843 | 49843 | 2020-07-22 | Butte | 7 | 26 | 1 | 8 | 1 | -2 |
54224 | 54224 | 2020-05-05 | Lake | 33 | 0 | 2 | 0 | 1 | -2 |
54434 | 54434 | 2020-05-01 | Amador | 5 | 0 | 0 | 0 | 0 | -2 |
1501 | 1501 | 2022-12-03 | Siskiyou | 93 | 2 | 0 | 0 | 0 | -1 |
6268 | 6268 | 2022-09-09 | Tulare | 107 | 36 | 2 | 1 | 1 | -1 |
6530 | 6530 | 2022-09-04 | San Benito | 69 | 2 | 0 | 2 | 0 | -1 |
6707 | 6707 | 2022-09-01 | Santa Cruz | 87 | 10 | 0 | 3 | 0 | -1 |
7099 | 7099 | 2022-08-25 | Santa Cruz | 87 | 15 | 0 | 2 | 0 | -1 |
11219 | 11219 | 2022-06-12 | Madera | 39 | 9 | 4 | 1 | 0 | -1 |
27448 | 27448 | 2021-08-26 | El Dorado | 17 | 28 | 0 | 8 | 0 | -1 |
40892 | 40892 | 2020-12-29 | Imperial | 25 | 176 | 2 | 53 | 0 | -1 |
43020 | 43020 | 2020-11-21 | Imperial | 25 | 57 | 0 | 18 | 0 | -1 |
45372 | 45372 | 2020-10-10 | Imperial | 25 | 31 | 0 | 11 | 0 | -1 |
55283 | 55283 | 2020-04-16 | Humboldt | 23 | 1 | 5 | 4 | 2 | -1 |
2 | 2 | 2022-12-29 | Amador | 5 | 5 | 1 | 0 | 0 | 0 |
4 | 4 | 2022-12-29 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
5 | 5 | 2022-12-29 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
10 | 10 | 2022-12-29 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
15 | 15 | 2022-12-29 | Kings | 31 | 3 | 0 | 1 | 0 | 0 |
16 | 16 | 2022-12-29 | Lake | 33 | 8 | 0 | 2 | 0 | 0 |
17 | 17 | 2022-12-29 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
21 | 21 | 2022-12-29 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
22 | 22 | 2022-12-29 | Mendocino | 45 | 9 | 0 | 4 | 0 | 0 |
24 | 24 | 2022-12-29 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
31 | 31 | 2022-12-29 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
34 | 34 | 2022-12-29 | San Benito | 69 | 1 | 0 | 1 | 0 | 0 |
43 | 43 | 2022-12-29 | Santa Cruz | 87 | 24 | 0 | 2 | 0 | 0 |
49 | 49 | 2022-12-29 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
51 | 51 | 2022-12-29 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
55 | 55 | 2022-12-29 | Yolo | 113 | 8 | 0 | 1 | 0 | 0 |
58 | 58 | 2022-12-28 | Amador | 5 | 6 | 0 | 0 | 0 | 0 |
60 | 60 | 2022-12-28 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
61 | 61 | 2022-12-28 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
66 | 66 | 2022-12-28 | Glenn | 21 | 1 | 0 | 0 | 0 | 0 |
67 | 67 | 2022-12-28 | Humboldt | 23 | 3 | 0 | 1 | 0 | 0 |
72 | 72 | 2022-12-28 | Lake | 33 | 7 | 0 | 2 | 0 | 0 |
73 | 73 | 2022-12-28 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
77 | 77 | 2022-12-28 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
80 | 80 | 2022-12-28 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
83 | 83 | 2022-12-28 | Napa | 55 | 10 | 0 | 0 | 0 | 0 |
87 | 87 | 2022-12-28 | Plumas | 63 | 1 | 0 | 0 | 0 | 0 |
90 | 90 | 2022-12-28 | San Benito | 69 | 1 | 0 | 1 | 0 | 0 |
105 | 105 | 2022-12-28 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
107 | 107 | 2022-12-28 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
111 | 111 | 2022-12-28 | Yolo | 113 | 9 | 0 | 0 | 0 | 0 |
114 | 114 | 2022-12-27 | Amador | 5 | 6 | 0 | 0 | 0 | 0 |
116 | 116 | 2022-12-27 | Calaveras | 9 | 1 | 0 | 0 | 0 | 0 |
117 | 117 | 2022-12-27 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
122 | 122 | 2022-12-27 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
128 | 128 | 2022-12-27 | Lake | 33 | 5 | 1 | 2 | 0 | 0 |
129 | 129 | 2022-12-27 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
133 | 133 | 2022-12-27 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
136 | 136 | 2022-12-27 | Modoc | 49 | 0 | 0 | 0 | 0 | 0 |
143 | 143 | 2022-12-27 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
146 | 146 | 2022-12-27 | San Benito | 69 | 2 | 0 | 1 | 0 | 0 |
155 | 155 | 2022-12-27 | Santa Cruz | 87 | 29 | 0 | 1 | 0 | 0 |
161 | 161 | 2022-12-27 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
163 | 163 | 2022-12-27 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
170 | 170 | 2022-12-26 | Amador | 5 | 5 | 0 | 0 | 0 | 0 |
173 | 173 | 2022-12-26 | Colusa | 11 | 0 | 0 | 0 | 0 | 0 |
178 | 178 | 2022-12-26 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
184 | 184 | 2022-12-26 | Lake | 33 | 4 | 1 | 1 | 0 | 0 |
185 | 185 | 2022-12-26 | Lassen | 35 | 0 | 0 | 0 | 0 | 0 |
189 | 189 | 2022-12-26 | Mariposa | 43 | 0 | 0 | 0 | 0 | 0 |
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 );