COVID-19 in Alberta: Vaccination Sites

COVID-19 vaccination sites. This dataset includes pharmacy locations for all of Alberta, and AHS clinics for the Edmonton area. Dataset includes a link for booking at a pharmacy if it is available.

Pharmacy list retrieved 2021-12-23 16:19; Source was last updated 2021-12-23 13:00:00.

Pharmacy list source: https://www.ab.bluecross.ca/news/covid-immunization-program-listing.php.

Edmonton area AHS clinic locations are manually updated as needed. Additional locations can be found at https://www.albertahealthservices.ca/topics/page17295.aspx.

Geocoding sources:

• Edmonton: https://gis.edmonton.ca/arcgishosting/rest/services/City_of_Edmonton_Geocoder/GeocodeServer/findAddressCandidates

• Calgary: http://gis.calgary.ca/arcgis/rest/services/pub_Locators/CalgaryAddressLocator/GeocodeServer/findAddressCandidates

• Everywhere else: http://geocoder.ca/

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-sites-w7yp-px4i\".\"covid19_in_alberta_vaccination_sites\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.