Historical: COVID-19 in Alberta: Intensive Care Unit (ICU) bed and non-ICU bed capacity and utilization

Note: Date last updated 2022-05-28, dataset no longer provided.

ICU and non-ICU bed capacity and utilization over time, from Figures 7, 8, and 9 at https://www.alberta.ca/stats/covid-19-alberta-statistics.htm#healthcare-capacity.

Data included may only be available at a lagged interval. As a result, the number of COVID occupied ICU beds/non-ICU inpatient beds on a particular day may not match the number reported elsewhere on the AHS COVID-19 dashboard. Data reflects the non-ICU hospital occupancy at the 14 largest hospitals, excluding paediatrics.

This dataset was last updated 2022-07-13 16:08 with data as of end of day 2022-07-11.

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 \"edmonton-ca/historical-covid19-in-alberta-intensive-care-unit-xzbw-4krt\".\"historical_covid19_in_alberta_intensive_care_unit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.