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.
3 rows where "date" is on date 2020-04-29 and icu_positive_patients = 2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: icu_suspected_patients
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54559 | 54559 | 2020-04-29 | Kings | 31 | 9 | 2 | 2 | 0 | 8 |
54588 | 54588 | 2020-04-29 | Shasta | 89 | 2 | 0 | 2 | 0 | 5 |
54591 | 54591 | 2020-04-29 | Sonoma | 97 | 5 | 14 | 2 | 2 | 51 |
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 );