COVID-19 Vaccination in Canada (Redshift)
Available in
AWS Marketplace
Available in
AWS Marketplace
Available in
AWS Marketplace
About
# COVID-19 Vaccination in Canada
The Public Health Agency of Canada provides the Canadian COVID-19 vaccination coverage report. The COVID-19 vaccination coverage data across Canada by key demographics and vaccine product. The data gets updated every Friday with data up to and including the previous Saturday.
## Vaccine Distribution
This datasets contains the vaccine distribution dataset which is updated every Thursday. The below describes the quantities of COVID-19 vaccines that have been delivered to provinces and territories.
**Source:** https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronavirus-infection/prevention-risks/covid-19-vaccine-treatment/vaccine-rollout.html
**Format:** Redshift Sharing
**Cadence:** Weekly (every Friday)
**Sample Data:**
|vaccine_distribution |pfizer_biontech|moderna|astrazeneca|total |
|---------------------------|---------------|-------|-----------|--------|
|Total distributed in Canada|42673134 |18041170|3005780 |63720084|
|Newfoundland and Labrador |543660 |271280 |41100 |856040 |
|Prince Edward Island |197445 |75980 |9900 |283325 |
|Nova Scotia |1099080 |502100 |60160 |1661340 |
|New Brunswick |846255 |407530 |52230 |1306015 |
|Quebec |9836643 |3469750|738110 |14044503|
|Ontario |17390421 |7627250|1157300 |26174971|
|Manitoba |1521300 |808920 |86460 |2416680 |
|Saskatchewan |1278585 |617990 |107500 |2004075 |
|Alberta |4540575 |1911560|316300 |6768435 |
|British Columbia |5393550 |1955720|436240 |7785510 |
|Yukon |3510 |64310 |20 |67840 |
|Northwest Territories |9360 |72870 |0 |82230 |
|Nunavut |9360 |51000 |0 |60360 |
|Federal allocation |3390 |204910 |460 |208760 |
**Sample Queries:**
* Get the number of Moderna doses administered in Quebec and get the percentage of doses administered with the Moderna vaccine.
```
SELECT vaccine_distribution, moderna_spikevax as number_of_dosis, (ROUND(convert(integer, number_of_dosis)/total,2) * 100) as percentage_dosis, total as total_dosis
FROM
canada_covid_vaccine_distribution
WHERE
vaccine_distribution = 'Quebec'
```
|number_of_dosis |percentage_dosis|total_dosis|
|---------------------------|----------------|-----------|
|3469750 |25 |14044503 |
Related Products
show moreBuyer guide
Read insights from real user interviews on why they chose this product.
How it works?
Search
Search 25000+ products and services vetted by AWS.
Request private offer
Our team will send you an offer link to view.
Purchase
Accept the offer in your AWS account, and start using the software.
Manage
All your transactions will be consolidated into one bill in AWS.
Create Your Marketplace with Webvar!
Launch your marketplace effortlessly with our solutions. Optimize sales processes and expand your reach with our platform.