Covid Vaccination Stats In New Zealand
Covid Vaccination Stats in NZ as of 10 Aug 2021
@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand
Covid Vaccination Stats in NZ as of 10 Aug 2021
@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand
CREATE TABLE cumulative (
"date" TIMESTAMP,
"cumulative_vaccinations_planned" DOUBLE,
"cumulative_vaccinations_administered" DOUBLE,
"cumulative_stock_received" DOUBLE,
"original_cumulative_vaccinations_model" DOUBLE
);
CREATE TABLE dates (
"date" TIMESTAMP,
"first_dose_administered" BIGINT,
"second_dose_administered" BIGINT
);
CREATE TABLE dhb (
"dhb" VARCHAR,
"actual_vaccinations_21st_feb_to_4th_apr_2021_as_at_13__17e9db06" BIGINT,
"n_2021_04_11_00_00_00" DOUBLE,
"n_2021_04_18_00_00_00" BIGINT,
"n_2021_04_25_00_00_00" BIGINT,
"n_2021_05_02_00_00_00" BIGINT,
"n_2021_05_09_00_00_00" DOUBLE,
"n_2021_05_16_00_00_00" DOUBLE,
"n_2021_05_23_00_00_00" DOUBLE,
"n_2021_05_30_00_00_00" DOUBLE,
"n_2021_06_06_00_00_00" DOUBLE,
"n_2021_06_13_00_00_00" DOUBLE,
"n_2021_06_20_00_00_00" DOUBLE,
"n_2021_06_27_00_00_00" DOUBLE,
"n_2021_07_04_00_00_00" DOUBLE,
"n_2021_07_11_00_00_00" DOUBLE,
"n_2021_07_18_00_00_00" DOUBLE,
"n_2021_07_25_00_00_00" DOUBLE,
"n_2021_08_01_00_00_00" DOUBLE,
"n_2021_08_08_00_00_00" DOUBLE,
"n_2021_08_15_00_00_00" DOUBLE,
"n_2021_08_22_00_00_00" DOUBLE,
"n_2021_08_29_00_00_00" DOUBLE
);
CREATE TABLE dhbplan (
"dhb" VARCHAR,
"planvsactual" VARCHAR,
"to_4_april" BIGINT,
"n_11_april" BIGINT,
"n_18_april" BIGINT,
"n_25_april" BIGINT,
"n_02_may" BIGINT,
"n_09_may" BIGINT,
"n_16_may" BIGINT,
"n_23_may" BIGINT,
"n_30_may" BIGINT,
"n_06_june" BIGINT,
"n_13_june" BIGINT,
"n_20_june" BIGINT,
"n_27_june" BIGINT,
"n_04_july" BIGINT,
"n_11_july" BIGINT,
"n_18_july" BIGINT,
"n_25_july" BIGINT,
"n_01_august" BIGINT,
"n_08_august" BIGINT,
"cumulative" BIGINT
);
CREATE TABLE dosesbyethnicity (
"dhb_of_residence" VARCHAR,
"ethnic_group" VARCHAR,
"ten_year_age_group" VARCHAR,
"gender" VARCHAR,
"dose_number" BIGINT,
"n__doses_administered" BIGINT
);
CREATE TABLE groupbydhbservice (
"week_ending" TIMESTAMP,
"group" VARCHAR,
"dhb_of_service" VARCHAR,
"dose_number" BIGINT,
"n__doses_administered" BIGINT
);
CREATE TABLE hsupopulation (
"ethnic_group" VARCHAR,
"age_group" VARCHAR,
"gender" VARCHAR,
"dhb_of_residence" VARCHAR,
"population" BIGINT
);
CREATE TABLE vaccinefordistribution (
"week_ending" VARCHAR,
"vaccine_available_for_distribution_at_the_end_of_the_week" BIGINT
);
CREATE TABLE workforce (
"date" TIMESTAMP,
"trained_vaccinator" BIGINT,
"active_vaccinator" BIGINT
);
Anyone who has the link will be able to view this.