COVID-19 in Alberta: Vaccination Progress by Zone

COVID-19 vaccines are safe, effective and save lives. The vaccine helps prevent you from getting infected and protects you from getting severely sick if you do get it.

Albertans are being vaccinated as fast as supply allows. This is happening in phases so people most at risk get it first. More groups will be eligible as we get more doses.

Until most Albertans are protected, fully vaccinated people must still follow all health measures: no indoor gatherings, keep 2 metres apart, wear a mask in public, and stay home when sick.

Between 2021-04-25 and 2021-05-15 this data was sourced from https://www.alberta.ca/data/stats/zone-coverage.csv. From 2021-05-16 onwards it's aggregated from the data at https://www.alberta.ca/data/stats/lga-coverage.csv; the population and other values changed slightly at this point, with the number of people vaccinated decreasing for some zones. This dataset was last updated 2023-08-29 15:15 with data as of end of day 2023-07-24.

Each day's data is stored locally along with its "Data included up to end of day" date in order to build this historical record.

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-vaccination-progress-by-zone-d43f-8ikp\".\"covid19_in_alberta_vaccination_progress_by_zone\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.