Social Investment Data Foundation (SIDF)

The Social Investment Data Foundation (SIDF) code produces datasets within the IDI that are ready for analysis. It reduces the time to generate datasets and speeds up the analysis.

We created the SIDF code to use within Stats NZ's Integrated Data Infrastructure(external link) (IDI). This code creates datasets with analysis variables based on a user’s specified population and time period for analysis.

In other words, a user can easily specify who, when and what they are interested in analysing, and datasets ready for analysis will be created.

Different projects require different datasets for analysis. The SIDF code has the flexibility to create datasets tailored to user specifications as well as to be extended by power users who wish to add more code to build custom variables for their dataset.


Building datasets ready for analysis is a time-consuming task – especially if you are a first time IDI user. Automating as much of the data preparation as possible will reduce the time to build datasets, leaving more time for analysis.

The code has been designed as a modular framework so you can run the code from end-to-end or create your own flow.

An example of the code being used in a modular format can be found in the Social Housing test case code(external link).

How SIDF code relates to the SIAL

The Social Investment Analytical Layer (SIAL) code(external link) creates a series of social sector service event tables, allowing the services people receive to be analysed in a standard way. This speeds up analysis and encourages consistent definitions.

The tables generated by the SIAL code are one of the inputs into the SIDF framework. They're used to create service-metric variables summarising a person’s interactions with government over a given time period, e.g.:

  • time spent receiving a benefit
  • total money received while on a benefit
  • number of benefit spells over a given time period.

Other inputs into the SIDF include demographic information and indicators tied to outcomes that require more detailed coding logic that can't be easily incorporated into the SIAL.

Accessing the SIDF code

Authorised IDI users will be able to create tables by running the SIDF code inside the IDI.

View and download code to build the SIDF tables.(external link)

Prerequisites for running the SIDF code

  1. Ensure you have the SIAL tables/views in your IDI project. If not, go to the SIAL repository(external link) and install the SIAL.
  2. Download the SIDF zip file(external link) from GitHub.
  3. Email (the Microdata team at StatsNZ),  and ask them to put the code into your project area.

Detailed instructions can be found in the README file(external link).

Feedback or contribution

You're welcome to contribute your code, or raise issues, on GitHub.

Please email your feedback to

Export PDF