Webvar
COVID-19 Vaccination in Canada (Redshift) - logo

COVID-19 Vaccination in Canada (Redshift)

This listing contains sample datasets for COVID-19 Vaccination in Canada data.

Available in

AWS Marketplace

Available in

AWS Marketplace

Purchase this listing from Webvar in AWS Marketplace using your AWS account. In AWS Marketplace, you can quickly launch pre-configured software with just a few clicks. AWS handles billing and payments, and charges on your AWS bill.

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

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.