Dataset: Covid Vaccination Stats In New Zealand

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


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


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


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


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


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


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


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


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


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