In most jurisdictions, hospitalization data is published online and updated regularly.
Be careful to look for figures expressed as a RATE (usually expressed per 100,000 or per million people), and not the raw number of vaccinated vs vaccinated patients admitted. Using the raw numbers to form an opinion on vaccine effectiveness would only be valid if the population is equal parts vaccinated and unvaccinated. Otherwise, this is an example of the base rate fallacy.
As of 2021-12-24 the Science Table COVID-19 Advisory for Ontario Canada shows that unvaccinated patients have a 13 times higher rate of hospitalization and a 26 times higher rate of ICU admittance. https://covid19-sciencetable.ca/ontario-dashboard/
In table 6, Alberta provides the count and rate of COVID-19 hospitalization by vaccination status, banded by age. In every age category, unvaccinated are hospitalized at multiple times higher rates than vaccinated people.
https://web.archive.org/web/20220321220704/https://www.alberta.ca/stats/covid-19-alberta-statistics.htm#vaccine-outcomes (2022-03-21)
In table 8, Alberta provides the count and rate of COVID-19 ICU hospitalization by vaccination status, banded by age. In every age category, unvaccinated are ICU hospitalized at many times higher rates than vaccinated people.
https://web.archive.org/web/20220321220704/https://www.alberta.ca/stats/covid-19-alberta-statistics.htm#vaccine-outcomes (2022-03-21)
Updated 2022-06-26, in table 3 & 5
https://web.archive.org/web/20220626170559/https://www.alberta.ca/stats/covid-19-alberta-statistics.htm#vaccine-outcomes
"Compared with controls, exclusively vaccinated subjects were 36% less likely to be infected than unvaccinated subjects (OR 0.64; 95%CI 0.62–0.66). For hospitalizations this probability was further decreased by 89% (OR 0.11; 95%CI 0.08–0.16)."
https://www.nature.com/articles/s41598-023-28129-7 (2023-02-03)
Title: Effectiveness of COVID-19 vaccines against hospital admission with the Delta (B.1.617.2) variant (2021-06-14)
96% VE vs Hospitalization (BNT152b2 Pfizer BioNTech) and 92% (ChAdOx1 Oxford AstraZeneca)
"These findings indicate very high levels of protection against hospitalization with the Delta variant with 1 or 2 doses of either vaccine." (BNT152b2 Pfizer BioNTech and ChAdOx1 Oxford AstraZeneca)
https://khub.net/web/phe-national/public-library/-/document_library/v2WsRK3ZlEig/view/479607266