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 descending
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 ▲ |
---|---|---|---|---|---|---|---|---|---|
49906 | 49906 | 2020-07-21 | Glenn | 21 | 0 | 2 | 0 | 0 | |
49913 | 49913 | 2020-07-21 | Lassen | 35 | 0 | 0 | 0 | 0 | |
49917 | 49917 | 2020-07-21 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
49920 | 49920 | 2020-07-21 | Modoc | 49 | 0 | 0 | 0 | 0 | |
49927 | 49927 | 2020-07-21 | Plumas | 63 | 0 | 3 | 0 | 0 | |
49945 | 49945 | 2020-07-21 | Sutter | 101 | 0 | 0 | 0 | 0 | |
49947 | 49947 | 2020-07-21 | Trinity | 105 | 0 | 0 | 0 | 0 | |
49962 | 49962 | 2020-07-20 | Glenn | 21 | 0 | 1 | 0 | 0 | |
49969 | 49969 | 2020-07-20 | Lassen | 35 | 0 | 0 | 0 | 0 | |
49973 | 49973 | 2020-07-20 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
49976 | 49976 | 2020-07-20 | Modoc | 49 | 0 | 0 | 0 | 0 | |
49983 | 49983 | 2020-07-20 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50001 | 50001 | 2020-07-20 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50003 | 50003 | 2020-07-20 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50018 | 50018 | 2020-07-19 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50025 | 50025 | 2020-07-19 | Lassen | 35 | 0 | 0 | 0 | 0 | |
50029 | 50029 | 2020-07-19 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50032 | 50032 | 2020-07-19 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50039 | 50039 | 2020-07-19 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50057 | 50057 | 2020-07-19 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50059 | 50059 | 2020-07-19 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50074 | 50074 | 2020-07-18 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50081 | 50081 | 2020-07-18 | Lassen | 35 | 0 | 0 | 0 | 0 | |
50085 | 50085 | 2020-07-18 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50088 | 50088 | 2020-07-18 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50095 | 50095 | 2020-07-18 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50113 | 50113 | 2020-07-18 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50115 | 50115 | 2020-07-18 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50130 | 50130 | 2020-07-17 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50137 | 50137 | 2020-07-17 | Lassen | 35 | 0 | 0 | 0 | 0 | |
50141 | 50141 | 2020-07-17 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50144 | 50144 | 2020-07-17 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50151 | 50151 | 2020-07-17 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50169 | 50169 | 2020-07-17 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50171 | 50171 | 2020-07-17 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50186 | 50186 | 2020-07-16 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50193 | 50193 | 2020-07-16 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50197 | 50197 | 2020-07-16 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50200 | 50200 | 2020-07-16 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50207 | 50207 | 2020-07-16 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50225 | 50225 | 2020-07-16 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50227 | 50227 | 2020-07-16 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50242 | 50242 | 2020-07-15 | Glenn | 21 | 0 | 0 | 0 | 0 | |
50249 | 50249 | 2020-07-15 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50253 | 50253 | 2020-07-15 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50256 | 50256 | 2020-07-15 | Modoc | 49 | 0 | 1 | 0 | 0 | |
50263 | 50263 | 2020-07-15 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50281 | 50281 | 2020-07-15 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50283 | 50283 | 2020-07-15 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50298 | 50298 | 2020-07-14 | Glenn | 21 | 0 | 0 | 0 | 0 | |
50305 | 50305 | 2020-07-14 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50309 | 50309 | 2020-07-14 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50312 | 50312 | 2020-07-14 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50319 | 50319 | 2020-07-14 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50337 | 50337 | 2020-07-14 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50339 | 50339 | 2020-07-14 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50354 | 50354 | 2020-07-13 | Glenn | 21 | 0 | 0 | 0 | 0 | |
50361 | 50361 | 2020-07-13 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50365 | 50365 | 2020-07-13 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50368 | 50368 | 2020-07-13 | Modoc | 49 | 0 | 1 | 0 | 0 | |
50375 | 50375 | 2020-07-13 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50393 | 50393 | 2020-07-13 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50395 | 50395 | 2020-07-13 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50410 | 50410 | 2020-07-12 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50417 | 50417 | 2020-07-12 | Lassen | 35 | 0 | 2 | 0 | 0 | |
50421 | 50421 | 2020-07-12 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50424 | 50424 | 2020-07-12 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50431 | 50431 | 2020-07-12 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50449 | 50449 | 2020-07-12 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50451 | 50451 | 2020-07-12 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50466 | 50466 | 2020-07-11 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50473 | 50473 | 2020-07-11 | Lassen | 35 | 0 | 3 | 0 | 0 | |
50477 | 50477 | 2020-07-11 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50480 | 50480 | 2020-07-11 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50487 | 50487 | 2020-07-11 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50505 | 50505 | 2020-07-11 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50507 | 50507 | 2020-07-11 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50522 | 50522 | 2020-07-10 | Glenn | 21 | 0 | 0 | 0 | 0 | |
50529 | 50529 | 2020-07-10 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50533 | 50533 | 2020-07-10 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50536 | 50536 | 2020-07-10 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50543 | 50543 | 2020-07-10 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50561 | 50561 | 2020-07-10 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50563 | 50563 | 2020-07-10 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50578 | 50578 | 2020-07-09 | Glenn | 21 | 0 | 0 | 0 | 0 | |
50585 | 50585 | 2020-07-09 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50589 | 50589 | 2020-07-09 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50592 | 50592 | 2020-07-09 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50599 | 50599 | 2020-07-09 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50617 | 50617 | 2020-07-09 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50619 | 50619 | 2020-07-09 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50634 | 50634 | 2020-07-08 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50641 | 50641 | 2020-07-08 | Lassen | 35 | 0 | 1 | 0 | 0 | |
50645 | 50645 | 2020-07-08 | Mariposa | 43 | 0 | 0 | 0 | 0 | |
50648 | 50648 | 2020-07-08 | Modoc | 49 | 0 | 0 | 0 | 0 | |
50655 | 50655 | 2020-07-08 | Plumas | 63 | 0 | 0 | 0 | 0 | |
50673 | 50673 | 2020-07-08 | Sutter | 101 | 0 | 0 | 0 | 0 | |
50675 | 50675 | 2020-07-08 | Trinity | 105 | 0 | 0 | 0 | 0 | |
50690 | 50690 | 2020-07-07 | Glenn | 21 | 0 | 1 | 0 | 0 | |
50697 | 50697 | 2020-07-07 | Lassen | 35 | 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 );