COVID-19 in Alberta: Cases by Zone

COVID-19 case data for Alberta. Zone boundaries are outlined at https://www.albertahealthservices.ca/ahs-map-ahs-zones.pdf.

This is a mirror of the full COVID-19 dataset published by the province at https://www.alberta.ca/data/stats/covid-19-alberta-statistics-data.csv.

DATA NOTES (from http://covid19stats.alberta.ca):

The Provincial Surveillance Information system (PSI) is a laboratory surveillance system which receives positive results for all Notifiable Diseases and diseases under laboratory surveillance from Alberta Precision Labs (APL). The system also receives negative results for a subset of organisms such as COVID-19. The system contains basic information on characteristics and demographics such as age, zone and gender.

Recovered is based on the assumption that a case is recovered 14 days after a particular date. For confirmed cases, we used specimen collected date and for probable cases, this is the date reported to Alberta Health.

Information such as hospitalizations and ICU admissions are received through enhanced case report forms sent by Alberta Health Services (AHS).

Disclaimer: The content and format of this report are subject to change. Cases are under investigation and numbers may fluctuate as cases are resolved. Data included in the interactive data application are up-to-date as of midday of the date of posting.

Data from https://www.alberta.ca/data/stats/covid-19-alberta-statistics-data.csv; 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/covid19-in-alberta-cases-by-zone-jmcu-tz8y\".\"covid19_in_alberta_cases_by_zone\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.