COVID-19 in Alberta: Vaccination Progress by Local Geographic Area

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.

Data from https://www.alberta.ca/data/stats/lga-coverage.csv; 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-local-tgzq-jumt\".\"covid19_in_alberta_vaccination_progress_by_local\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.