COVID-19 Vaccination Coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
OpenDataNI
@ukgov.covid_19_vaccination_coverage
CREATE TABLE coverage_on_2023_06_22 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_06_29 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_07_06 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_07_13 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_07_20 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_07_27 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_08_03 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_08_10 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_08_17 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_08_24 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_08_31 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_09_07 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_09_14 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_09_21 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_09_28 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_10_05 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_10_12 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_10_19 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_10_26 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_11_02 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_11_09 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_11_16 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_11_23 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_11_30 (
"date" TIMESTAMP,
"ageband10yr" VARCHAR,
"lgd2014code" VARCHAR,
"dose1" BIGINT,
"dose2" BIGINT,
"dose3anybooster" BIGINT,
"autumn2022booster" BIGINT,
"spring2023booster" BIGINT
);
CREATE TABLE coverage_on_2023_12_07 (
"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.