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  -- Actual Vaccinations 21st Feb To 4th Apr 2021 (as At 13 April 2021),
  "n_2021_04_11_00_00_00" DOUBLE  -- 2021-04-11–00:00:00,
  "n_2021_04_18_00_00_00" BIGINT  -- 2021-04-18–00:00:00,
  "n_2021_04_25_00_00_00" BIGINT  -- 2021-04-25–00:00:00,
  "n_2021_05_02_00_00_00" BIGINT  -- 2021-05-02–00:00:00,
  "n_2021_05_09_00_00_00" DOUBLE  -- 2021-05-09–00:00:00,
  "n_2021_05_16_00_00_00" DOUBLE  -- 2021-05-16–00:00:00,
  "n_2021_05_23_00_00_00" DOUBLE  -- 2021-05-23–00:00:00,
  "n_2021_05_30_00_00_00" DOUBLE  -- 2021-05-30–00:00:00,
  "n_2021_06_06_00_00_00" DOUBLE  -- 2021-06-06–00:00:00,
  "n_2021_06_13_00_00_00" DOUBLE  -- 2021-06-13–00:00:00,
  "n_2021_06_20_00_00_00" DOUBLE  -- 2021-06-20–00:00:00,
  "n_2021_06_27_00_00_00" DOUBLE  -- 2021-06-27–00:00:00,
  "n_2021_07_04_00_00_00" DOUBLE  -- 2021-07-04–00:00:00,
  "n_2021_07_11_00_00_00" DOUBLE  -- 2021-07-11–00:00:00,
  "n_2021_07_18_00_00_00" DOUBLE  -- 2021-07-18–00:00:00,
  "n_2021_07_25_00_00_00" DOUBLE  -- 2021-07-25–00:00:00,
  "n_2021_08_01_00_00_00" DOUBLE  -- 2021-08-01–00:00:00,
  "n_2021_08_08_00_00_00" DOUBLE  -- 2021-08-08–00:00:00,
  "n_2021_08_15_00_00_00" DOUBLE  -- 2021-08-15–00:00:00,
  "n_2021_08_22_00_00_00" DOUBLE  -- 2021-08-22–00:00:00,
  "n_2021_08_29_00_00_00" DOUBLE  -- 2021-08-29–00:00:00
);

CREATE TABLE dhbplan (
  "dhb" VARCHAR,
  "planvsactual" VARCHAR,
  "to_4_april" BIGINT,
  "n_11_april" BIGINT  -- 11-April,
  "n_18_april" BIGINT  -- 18-April,
  "n_25_april" BIGINT  -- 25-April,
  "n_02_may" BIGINT  -- 02-May,
  "n_09_may" BIGINT  -- 09-May,
  "n_16_may" BIGINT  -- 16-May,
  "n_23_may" BIGINT  -- 23-May,
  "n_30_may" BIGINT  -- 30-May,
  "n_06_june" BIGINT  -- 06-June,
  "n_13_june" BIGINT  -- 13-June,
  "n_20_june" BIGINT  -- 20-June,
  "n_27_june" BIGINT  -- 27-June,
  "n_04_july" BIGINT  -- 04-July,
  "n_11_july" BIGINT  -- 11-July,
  "n_18_july" BIGINT  -- 18-July,
  "n_25_july" BIGINT  -- 25-July,
  "n_01_august" BIGINT  -- 01-August,
  "n_08_august" BIGINT  -- 08-August,
  "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  -- # Doses Administered
);

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

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