COVID-19 Vaccination Coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
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.