COVID-19 in Alberta: Day by day

COVID-19 data for Alberta:

From https://www.alberta.ca/covid-19-alberta-data.aspx:

  - Previous day's Confirmed Cases, Active Cases, Recovered Cases, In Hospital, In Intensive Care, Deaths.



From https://www.alberta.ca/stats/covid-19-alberta-statistics.htm:

  - Figure 9: Cumulative COVID-19 cases.

  - Figure None: Rate of COVID-19 cases (per 100,000 population)

  - Figure 10: Tests performed for COVID-19 in Alberta by day.



NB:

  - The relevant Alberta Health Services websites are typically updated late afternoon Monday to Friday (except holidays), and the newly-added data applies to the previous day. As such, for much of each weekday the most recent data in this dataset will be for two days prior.

  - This dataset was last updated 2023-05-17 16:08 with data as of end of day 2023-05-15.

  - Data rows are reflective of the relevant Alberta Health Services' website as of the specified date. The data may be changed or corrected by Alberta Health Services on its relevant website, rendering the recorded values herein inaccurate.



Some gaps in historical data were filled from https://docs.google.com/spreadsheets/d/1DAQ8_YJKdczjhFms9e8Hb0eVKX_GL5Et5CWvVcPKogM/edit#gid=0, with dates adjusted from "data published" date to "data applies to" date.

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/covid19-in-alberta-day-by-day-gxqm-z6fa\".\"covid19_in_alberta_day_by_day\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.