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_2022_12_29 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_01_05 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_01_12 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_01_19 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_01_26 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_02_02 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_02_09 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_02_16 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_02_23 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_03_02 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_03_09 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_03_16 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_03_23 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_03_30 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_04_06 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_04_13 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_04_20 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_04_27 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT
);CREATE TABLE coverage_on_2023_05_04 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_05_11 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_05_18 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_05_25 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_06_01 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_06_08 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);CREATE TABLE coverage_on_2023_06_15 (
"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.