edmonton-ca/covid19-in-edmonton-day-by-day-xwaa-ucvd
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 1 month ago

COVID-19 in Edmonton: Day by day

COVID-19 data for Edmonton:

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 12: Rate of new hospitalizations (7-day rolling average, average of current day and previous 6 days) by admission date.

  - Figure 14: Cumulative COVID-19 cases.

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

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

  - Figure 17: Positivity rate for COVID-19, and number of tests performed, by region.



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-08-29 15:15 with data as of end of day 2023-07-24.

  - 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-edmonton-day-by-day-xwaa-ucvd\".\"covid19_in_edmonton_day_by_day\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_in_edmonton_day_by_day
     
     
     
     
     
Upstream Metadata