Icon for Socrata external plugin
Open repository in Console
Updated 8 months ago
Indexed 5 hours ago

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

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" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/covid19-in-alberta-current-cases-by-local-ix8f-s9xp\".\"covid19_in_alberta_current_cases_by_local\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_in_alberta_current_cases_by_local
Upstream Metadata