Icon for Socrata external plugin
Open repository in Console
Updated 16 days ago
Indexed 3 hours ago

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.


  - 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" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/covid19-in-alberta-day-by-day-gxqm-z6fa\".\"covid19_in_alberta_day_by_day\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_in_alberta_day_by_day
Upstream Metadata