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