Data and calculations for the New Zealand Herald’s investigation into unresolved sexual assaults.

The investigation examines the increasing number of sexual assaults in New Zealand that are not being resolved.


Four charts were produced for the article. The sources and analysis used to generate the data for these charts in included below. The data extracts used are available for download and the analysis has been done in R using tidyverse libraries.

The charts where produced using Semiotic and exported into Adobe Illustrator for fine tuning.

Unresolved sexual assaults over time. This time series needs to be used with care as the NZ police data collection system was changed in 2014. The charts attempt to highlight this difference to readers while still showing a meaningful time series.