Historical: COVID-19 in Alberta: Current cases by local geographic area

Note: Last updated 2022-09-26, no longer provided.

Current COVID-19 cases in Alberta, by local geographic area.

This is a mirror of the data presented in the map view at https://www.alberta.ca/stats/covid-19-alberta-statistics.htm ('Geospatial' tab), with vaccination progress data joined from https://www.alberta.ca/data/stats/lga-coverage.csv. Updated 2022-09-28 16:08 with data as of end of day 2022-09-26.

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-current-cases-by-ix8f-s9xp\".\"historical_covid19_in_alberta_current_cases_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.