Dear Health New Zealand,

Please provide machine readable datasets in csv format that shows the total number of people by age and gender enrolled with the NZ health system that are vaccinated with a specified number of COVID vaccine doses from 1 Jan 2020 through to the present day as at the end of each calendar month- so Sept 2024 is the latest month.

Where a person dies in a particular month then they would not be counted in the subsequent month as being enrolled in the NZ health system – and therefore not be included in the counts in each dataset after that month.

Please provide the dataset specified below for the people who received at least 1 dose (including those people who eventually had more than one dose), then another extract of the dataset for those people who have received at least 2 doses, another for “at least 3 doses”, a 4th dataset for “at least 4 doses” etc up to a final dataset for those who have received 7 or more doses.

The columns of the dataset would be expected to include:


1) Date: Date at the end of the month with the earliest date being 31 Jan 2020. That is, the first year of data will give a baseline of variation by month that subsequent years that included the vaccination programme can be compared to and is expected to be mostly zero for each dose dataset.


2) Age: Age from birth as at the end of the month. 0 is the age up to 364 days, 1 is from 1 year to 1 year and 364 days etc. The highest age category should be 100+


3) Gender: Male/Female/Unknown or Other
4) Number of People: Count of the population of people under the care/enrolled in the NZ public health system who are vaccinated with the dose number specified (eg 1+, 2+, 3+, 4+, …. 7+) of any of the COVID vaccines. The number in this column will change based on the variation in the enrolled population, the aging of the vaccinated each month and deaths. If a subsequent dose is received the person will still be counted (eg a 2 dose person will still be counted in the "1+" dose dataset from the point they receive their second dose).

Once a query has been written for one month, it should be able to be rerun for each subsequent month on a programmed loop - minimising the effort involved.

Cell obfuscation:
a) Where a cell is <5 people please populate this with "<5" for confidentiality. 
b) True zero cells should be shown - or at least not included in the dataset and not marked as <5. Please state which method has been used.
Please do consult as early as possible if there are any issues or questions.

This is similar in intensity and effort to previous OIAs for data that Health NZ has successfully responded to. An almost identical OIA was completed a few months ago so the previous query will just need to be adjusted.

Yours faithfully,

Chris Johnston