COVID-19 hospitalizations by date

The dataset provides information on the number of hospitalized patients with confirmed or suspected COVID-19. Data on hospitalized patients are provided by reporting hospitals and represent a snapshot of the hospitals’ patient census and capacity at that point in time. These data may vary greatly day to day as they are only accurate at the time hospitals report the data. Source: Santa Clara County Emergency Medical Services. Data Notes: A Person Under Investigation (PUI) is an individual that is believed to have COVID-19 based on symptoms. New COVID-19 patients represent either newly admitted patients with COVID-19 or PUIs already hospitalized that then test positive for COVID-19. Percent represents the percentage of staffable beds for each level of care that are occupied by patients with COVID-19. Percentages are provided as a rolling 7-day average.

This data table was updated for the last time on May 24, 2021. To access more recent hospitalization data please visit the state’s open data portal here.

https://data.ca.gov/dataset/covid-19-hospital-data1

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"sccgov/covid19-hospitalizations-by-date-5xkz-6esm\".\"covid19_hospitalizations_by_date\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.