Baselight

Covid Vaccination Stats In New Zealand

Covid Vaccination Stats in NZ as of 10 Aug 2021

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand

Loading...
Loading...

About this Dataset

Covid Vaccination Stats In New Zealand

Context / Content

With NZ moving into snap lockdown overnight, thought of checking the current status of Vaccination drive in NZ. This data was published on MoH website and stands corrected as of 10 Aug 2021.

Acknowledgements

Ministry of Health NZ

Tables

Cumulative

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.cumulative
  • 5.94 KB
  • 42 rows
  • 5 columns
Loading...

CREATE TABLE cumulative (
  "date" TIMESTAMP,
  "cumulative_vaccinations_planned" DOUBLE,
  "cumulative_vaccinations_administered" DOUBLE,
  "cumulative_stock_received" DOUBLE,
  "original_cumulative_vaccinations_model" DOUBLE
);

Dates

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.dates
  • 6.21 KB
  • 173 rows
  • 3 columns
Loading...

CREATE TABLE dates (
  "date" TIMESTAMP,
  "first_dose_administered" BIGINT,
  "second_dose_administered" BIGINT
);

Dhb

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.dhb
  • 20.9 KB
  • 18 rows
  • 23 columns
Loading...

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
);

Dhbplan

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.dhbplan
  • 19.06 KB
  • 36 rows
  • 22 columns
Loading...

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
);

Dosesbyethnicity

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.dosesbyethnicity
  • 13.91 KB
  • 2789 rows
  • 6 columns
Loading...

CREATE TABLE dosesbyethnicity (
  "dhb_of_residence" VARCHAR,
  "ethnic_group" VARCHAR,
  "ten_year_age_group" VARCHAR,
  "gender" VARCHAR,
  "dose_number" BIGINT,
  "n__doses_administered" BIGINT
);

Groupbydhbservice

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.groupbydhbservice
  • 13.54 KB
  • 2337 rows
  • 5 columns
Loading...

CREATE TABLE groupbydhbservice (
  "week_ending" TIMESTAMP,
  "group" VARCHAR,
  "dhb_of_service" VARCHAR,
  "dose_number" BIGINT,
  "n__doses_administered" BIGINT
);

Hsupopulation

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.hsupopulation
  • 12.23 KB
  • 1977 rows
  • 5 columns
Loading...

CREATE TABLE hsupopulation (
  "ethnic_group" VARCHAR,
  "age_group" VARCHAR,
  "gender" VARCHAR,
  "dhb_of_residence" VARCHAR,
  "population" BIGINT
);

Vaccinefordistribution

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.vaccinefordistribution
  • 2.85 KB
  • 25 rows
  • 2 columns
Loading...

CREATE TABLE vaccinefordistribution (
  "week_ending" VARCHAR,
  "vaccine_available_for_distribution_at_the_end_of_the_week" BIGINT
);

Workforce

@kaggle.kkhandekar_covid_vaccination_stats_in_new_zealand.workforce
  • 3.41 KB
  • 24 rows
  • 3 columns
Loading...

CREATE TABLE workforce (
  "date" TIMESTAMP,
  "trained_vaccinator" BIGINT,
  "active_vaccinator" BIGINT
);

Share link

Anyone who has the link will be able to view this.