# 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 |