Historical: COVID-19 in Alberta: Case History by Municipality and Local Geographic Area

Note: Date last updated 2022-09-26, data is no longer provided.

COVID-19 case history for Alberta, by municipality and local geographic area. Be sure to filter on the map_type value e.g.:

• By municipality: https://data.edmonton.ca/resource/rrjc-ssaw.csv?$where=map_type=%27Municipality%27&$order=date&$limit=221497

• By local geographic area: https://data.edmonton.ca/resource/rrjc-ssaw.csv?$where=map_type=%27Local%20geographic%20area%27&$order=date&$limit=221497

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 each day's snapshot of data stored locally along with the "data as of" date in order to build the history. Gaps in this data (typically data pertaining to Fridays and Saturdays) are filled from https://www.alberta.ca/data/stats/covid-19-alberta-statistics-map-data.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-case-history-by-rrjc-ssaw\".\"historical_covid19_in_alberta_case_history_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.