COVID-19 Vaccination Coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
The data source for this dataset is the NI Vaccine Management System (VMS). VMS holds vaccination reports for COVID-19 and influenza vaccines which were either administered in NI or to NI residents. This dataset is an aggregated summary of COVID-19 vaccinations recorded in VMS. It is effectively a day-by-day count of living people vaccinated by dose, age band (on the day that the dataset was extracted from VMS) and LGD of residence. Aggregated summary data from VMS is published daily to the NI COVID-19 Vaccinations Dashboard. This dataset is updated weekly and allows NI vaccination coverage to be included in the GOV.UK Coronavirus (COVID-19) in the UK dashboard.
Publisher name: OpenDataNI
Last updated: 2024-09-14T01:50:37Z
CREATE TABLE coverage_on_2023_12_14 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_12_21 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_12_28 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_01_11 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_01_18 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_01_25 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_02_01 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_02_08 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_02_15 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_02_22 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_02_29 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_03_07 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_03_14 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_03_21 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_03_28 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_04_04 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_04_11 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_04_18 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_04_25 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_05_02 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_05_09 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_05_16 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_05_23 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2024_05_30 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);Anyone who has the link will be able to view this.