Detailed data instructions

Filters and pivot tables are two useful features of Microsoft Excel that you can use to find answers to your questions in the source data we provide on our data report pages.

There are two main ways to use the detailed data tables and Microsoft Excel to answer questions. For simple counts of notifications, assessment or enforcement activity, using filters on the data sheet is easiest. For more complex questions, PivotTables often produce better results. More experienced users can also use other programmes and tools to analyse this data.

Whichever method you use, we recommend reading the following section on column and field names to gain a better understanding of the ways in which the detailed data should be used.

How to filter data (PDF 791 KB)

Pivot table instructions (PDF 500 KB)

Column/field names

This section contains information about the columns included in the tables referenced above. Reading this section will give you a better understanding about how particular variables should be used. While some of these columns are included in all of the tables, others are only included in particular tables.

1. Year

The year the matter in question was first entered into WorkSafe’s data entry system (e.g. when the initial notification was received, or the date that a proactive assessment was undertaken, or the date the enforcement was issued). Please note: due to delays in receipt of notifications, the date that an accident occurred, or an assessment relating to an accident was undertaken, can differ from the date that an event occurred.

2. Month

The month the matter in question was first entered into WorkSafe’s data entry system (e.g. when the initial notification was received, or the date that a proactive assessment was undertaken – data in the enforcement tables relate to either the date of notification, or the assessment date where no notification was received). It is displayed using the month’s number e.g. 1 = January. Please note: due to delays in receipt of notifications, the date that an accident occurred, or an assessment relating to an accident was undertaken can differ from the date that an event occurred.

3. Month_Year

A combination of Year and Month from point 1 and 2 above. This column allows Year and Month to be filtered in one column; it is especially useful for pivot tables.

4. Notification type

Shows the type of Notification.

Under HSE, notifications included:

  • Harm Notifications (Harm notifications are notifications of injury that did not meet the requirements to be classified as serious harms(external link))
  • Potential for Harm Notifications (Potential for Harm notifications include complaints about unsafe work practices and notifications of potentially unsafe conditions (including near miss events). Potential for Harm notifications were not required under law.)
  • Serious Harm Notifications (as defined here(external link)).

Under HSWA, notifications include:

5. Notice type

Shows the type of enforcement action taken.

The HSE Enforcement Data Table includes:

  • written warnings
  • negotiated agreements/agreement letters
  • Improvement notices (Improvement Notices issued under HSWA that related to notifications received prior to 4 April 2016 are prefixed with HSWA)
  • Prohibition notices (Prohibition Notices issued under HSWA that related to notifications received prior to 4 April 2016 are prefixed with HSWA)
  • Hazardous Substance and New Organism (HSNO) compliance orders
  • Infringement notices.

The HSWA Enforcement Data Activity Table includes:

  • Improvement notices
  • Prohibition notices
  • Hazardous Substance and New Organism (HSNO) compliance orders
  • Infringement notices.

Prosecutions are not included in these tables, but prosecution summaries can be found here.

6. Old industry groups

WorkSafe has historically used a custom breakdown of  Australia New Zealand Standard Industry Classification (ANZSIC)(external link) industries to replace the ANZSIC level one Agriculture, Forestry, and Fishing sector. This breakdown groups all of the sub-industries in this sector into Agriculture, Forestry, or Fishing.

7. ANZSICYear

Shows the version of the Australia New Zealand Standard Industrial Classification (ANZSIC) system used in that line of data. There are two versions of this system used in the detailed data tables: ANZSIC1996 and ANZSIC2006. While older records are entered using the 1996 version of the system, WorkSafe transitioned to ANZSIC 2006 in 2011. There are slight differences between the two versions. See Statistics New Zealand for more detail:

Industrial classification(external link)

Industrial classification 1996(external link)

8. Industry (Lvl1-Lvl4)

The Industry associated with the event. This is based on the information initially provided to WorkSafe, and is sometimes updated as new information becomes available. Because WorkSafe does not always receive detailed industry information it is not always possible to fill these fields. As a result, counts of the more detailed industry levels are not always accurate, and should be used with caution.

9. Locations

Location is displayed in three columns: Local_Government_Region, Region_Detail and Local_Government_District.

The Local_Government_Region and Local_Government_District columns are based on the Local Government New Zealand regional boundaries(external link). WorkSafe record the location of the event with the Region_Detail column. Local_Government_Region and Local_Government_District are then derived from the Region_Detail column.

Some Region_Detail options exist in one or more Local_Government_Regions or Local_Government_Districts. The most appropriate Local_Government_Regions or Local_Government_Districts have been chosen.

10. Investigated

Shows whether the notification was investigated by WorkSafe or not. Cells marked ‘yes’ have been investigated. Please note: investigations being undertaken at the time of data update may not be included in this column, these numbers should not be used as an official count of Investigations.

11. Notice warning or agreement

Shows whether a Notice, Written Warning, or Negotiated Agreement letter was issued in response to the notification/assessment. Prosecution data is kept in a separate location and can be found here.

12. No. of notifications/assessments/notices

This column should be used to count the number of notifications, assessments, or notices (depending on the table) that fit within the variable descriptions on that row; a number greater than one represents more than file with that combination of variables. This column should be summed to provide a count. Because each row can include more than one notification/assessment/notice, counting the number of rows will produce an undercount.

13. HSWA_Classification

This column displays the type of injury, illness, or notifiable incident notified under the Health and Safety at Work Act 2015. This information is not available for notifications made under the Health and Safety in Employment Act 1992.

Points of note:

Changes in recording criteria for investigations:

It is difficult to compare the number of investigations before and after 1 July 2013 as the decision-making criteria for what is described as a workplace investigation changed from 1 July 2013.  Prior to that date decisions on whether to investigate were made by local offices.  However, from 1 July 2013, the decision-making process was centralised, and all decisions to investigate are now made by a specialist response team using standardised criteria.

Changes in recording criteria for serious harms:

In mid-2013 the process for recording serious harm notifications was changed. Previously, any notification was recorded as it was received. From mid-2013, only notifications that met the legal definition of serious harm have been recorded as serious harms ( see definition(external link)). This means that data for serious harm notifications before and after this change are not comparable.