Bulk data help guide

Last updated: 20 November 2024

General information

The bulk data is a snapshot of data at a point in time and is uploaded to a shared folder in Box.com each month.

The data is made available as a zipped file that contains 18 files in comma separated value (csv) format. 

The New Zealand Business Number (NZBN) is the joining key for the files.

List of csv files available

  1. companies_abn.csv
    Registered companies that have provided an Australian Business Number (ABN).
  2. companies_address_for_service.csv
    Registered companies address for service.
  3. companies_business_industry_classification.csv
    Registered companies that have provided a public Business Industry Classification (BIC) code.
  4. companies_core_data.csv
    Core details of all registered and removed companies including company name, company type, status, registration date and removal date.
  5. companies_director.csv
    Active directors of registered companies.
  6. companies_gst.csv
    Registered companies that have provided a public GST number.
  7. companies_insolvency.csv
    All companies that have had an insolvency practitioner appointed for liquidation, receivership or voluntary administration.
  8. companies_public_address.csv
    Registered companies that have provided a public delivery, invoice, office and/or postal address.
  9. companies_registered_office_address.csv
    Registered companies registered office address (the address where company records are kept).
  10. companies_shareholder.csv
    Active shareholders of registered companies.
  11. companies_trading_area.csv
    Registered companies that have provided a public trading area.
  12. companies_trading_name.csv
    Registered companies that have provided a public trading name.
  13. companies_website.csv
    Registered companies that have provided a public website address.
  14. other_incorporated_entities_core_data.csv
    All registered and removed charitable trusts, incorporated societies and limited partnerships.
  15. unincorporated_entities_core_data.csv
    All registered and inactive sole traders, partnerships and trusts.
  16. retirement_villages_core_data.csv
    All registered and struck off retirement villages.
  17. public_sector_entities_core_data.csv
    All registered and inactive public sector entities with a New Zealand Business Number including central government, local government, education entities and other public entities.
  18. maori_business_identifier.csv
    All registered entities (including non-company entities) that have identified on the New Zealand Business Number Register as a Māori business .

companies_abn.csv

Registered companies that have provided an Australian Business Number (ABN).

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
ABN ABN Australian Business Number

companies_address_for_service.csv

Registered companies address for service.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of address
PAFID ADDRESS_FOR_SERVICE_PAF_ID NZ Post Postal Address File ID
CAREOF ADDRESS_FOR_SERVICE_CARE_OF Address care of
ADDRESS1 ADDRESS_FOR_SERVICE_1 Address line 1
ADDRESS2 ADDRESS_FOR_SERVICE_2 Address line 2
ADDRESS3 ADDRESS_FOR_SERVICE_3 Address line 3
ADDRESS4 ADDRESS_FOR_SERVICE_4 Address line 4
POSTCODE ADDRESS_FOR_SERVICE_POSTCODE Address postcode
COUNTRY ADDRESS_FOR_SERVICE_COUNTRY Address country

companies_business_industry_classification.csv

Registered companies that have provided a public Business Industry Classification (BIC) code.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of business industry classification (BIC)
CLASSIFICATIONCODE INDUSTRY_CLASSIFICATION_CODE Business industry classification code
CLASSIFICATION INDUSTRY_CLASSIFICATION_DESCRIPTION Business industry classification description

companies_core_data.csv

Core details of all registered and removed companies including company name, company type, status, registration date and removal date.

Old New Description
NZBN NZBN New Zealand Business Number
COMPANYIDENTIFIER COMPANY_IDENTIFIER Unique number assigned to the entity on the  New Zealand Companies Register
ENTITYNAME ENTITY_NAME Registered name
SOURCE (Column deleted) Column deleted 1 September 2024
REGISTRATIONDATE REGISTRATION_DATE The date the entity is registered on the register 
REMOVALDATE REMOVAL_DATE The date the entity was removed from the register
ENTITYTYPE ENTITY_TYPE Type of entity
ENTITYSTATUS ENTITY_STATUS Status of the entity

companies_director.csv

Active directors of registered companies.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of director
FIRSTNAME FIRST_NAME First name of director
MIDDLENAMES MIDDLE_NAMES Middle name(s) of director
LASTNAME LAST_NAME Last name of director
ASICDIRYN ASIC_DIR_YN Is director also a director of an Australian company Y/N?
ACN ACN Australian company number
ASIC ASIC_COMPANY_NAME Australian Securities and Investment Commission name

companies_gst.csv

Registered companies that have provided a public GST number.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of GST number
GSTNUMBER GST_NUMBER GST number

companies_insolvency.csv

All companies that have had an insolvency practitioner appointed for liquidation, receivership or voluntary administration.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
INSOLVENCYSTARTDATE START_DATE Start date of the insolvency
INSOLVENCYTYPE INSOLVENCY_TYPE Type of insolvency (liquidation, receivership, voluntary administration)
APPOINTMENTTYPE APPOINTMENT_TYPE Insolvency appointment type as prescribed by legislation
FIRSTNAME APPOINTEE_FIRST_NAME First name of appointee
MIDDLENAME APPOINTEE_MIDDLE_NAMES Middle name(s) of appointee
LASTNAME APPOINTEE_LAST_NAME Last name of appointee
APPOINTMENTDATE APPOINTMENT_DATE Date of appointment
APPOINTMENTVACATEDDATE APPOINTMENT_VACATED_DATE Date appointee vacated
ORGANISATION ORGANISATION Organisation of appointee
RESSOL RESSOLUTION_OF_SOLVENCY Has a resolution of solvency document been filed (Y)

companies_public_address.csv

Registered companies that have provided a public delivery, invoice, office and/or postal address.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
TYPE TYPE Type of address
STARTDATE START_DATE Start date of address
PAFID ADDRESS_PAF_ID NZ Post Postal Address File ID
CAREOF ADDRESS_CARE_OF Address care of
ADDRESS1 ADDRESS_1 Address line 1
ADDRESS2 ADDRESS_2 Address line 2
ADDRESS3 ADDRESS_3 Address line 3
ADDRESS4 ADDRESS_4 Address line 4
POSTCODE ADDRESS_POSTCODE Address postcode
COUNTRY ADDRESS_COUNTRY Address country

companies_registered_office_address.csv

Registered companies registered office address (the address where company records are kept).

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of address
PAFID REGISTERED_OFFICE_ADDRESS_PAF_ID NZ Post Postal Address File ID
CAREOF REGISTERED_OFFICE_ADDRESS_CARE_OF Address care of
ADDRESS1 REGISTERED_OFFICE_ADDRESS_1 Address line 1
ADDRESS2 REGISTERED_OFFICE_ADDRESS_2 Address line 2
ADDRESS3 REGISTERED_OFFICE_ADDRESS_3 Address line 3
ADDRESS4 REGISTERED_OFFICE_ADDRESS_4 Address line 4
POSTCODE REGISTERED_OFFICE_ADDRESS_POSTCODE Address postcode
COUNTRY REGISTERED_OFFICE_ADDRESS_COUNTRY Address country

companies_shareholder.csv

Active shareholders of registered companies.

New Description
NZBN New Zealand Business Number
ENTITY_NAME Registered name
SH_NAME Shareholder name
SH_TYPE Shareholder type (individual, company, other entity)
START_DATE Start date of shareholder
SH_STATUS Status of shareholder
PARCEL_IDENTIFIER A unique identifier for each parcel of shares
ASSIGNMENT_IDENTIFIER A unique identifier for the assignment of a shareholder to a parcel of shares
NUMBER_OF_SHARES Number of shares in a parcel
SH_EXTENSIVE_SHAREHOLDING_YN Is there an extensive shareholding Y/N?
SH_ADDRESS_PAF_ID Shareholder address NZ Post Postal Address File ID (see note *)
SH_ADDRESS_CARE_OF Shareholder address care of (see note *)
SH_ADDRESS_1 Shareholder address line 1 (see note *)
SH_ADDRESS_2 Shareholder address line 2 (see note *)
SH_ADDRESS_3 Shareholder address line 3 (see note *)
SH_ADDRESS_4 Shareholder address line 4 (see note *)
SH_ADDRESS_POSTCODE Shareholder address postcode (see note *)
SH_ADDRESS_COUNTRY Shareholder address country (see note *)

companies_trading_area.csv

Registered companies that have provided a public trading area.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of trading area
TRADINGAREA TRADING_AREA Trading area

companies_trading_name.csv

Registered companies that have provided a public trading name.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of trading name
TRADINGNAME TRADING_NAME Trading name

companies_website.csv

Registered companies that have provided a public website address.

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
STARTDATE START_DATE Start date of website address
WEBSITE WEBSITE Website address
PURPOSE (Column deleted) Column deleted 1 September 2024

other_incorporated_entities_core_data.csv

All registered and removed charitable trusts, incorporated societies and limited partnerships.

New Description
NZBN New Zealand Business Number
INCORPORATION_NUMBER Entity identifier
ENTITY_NAME Registered name
ENTITY_TYPE Type of entity (charitable trust, incorporated society, New Zealand limited partnership, overseas limited partnership)
ENTITY_STATUS Status of entity
REGISTRATION_DATE The date that the entity is registered on the register
DEREGISTRATION_DATE The date that the entity is deregistered on the register
INCORPORATED_SOCIETIES_ACT The Act that applies to an incorporated society
INCSOC2022ACT_REREGISTRATION_DATE The date that an incorporated society was registered on the Incorporated Societies Act 2022
CHARITIES_REGISTER_NUMBER Identifier on the Charities register
REGISTERED_OFFICE_ADDRESS_PAF_ID NZ Post Postal Address File ID
REGISTERED_OFFICE_ADDRESS_CARE_OF Registered office address care of
REGISTERED_OFFICE_ADDRESS_LINE_1 Registered office address line 1
REGISTERED_OFFICE_ADDRESS_LINE_2 Registered office address line 2
REGISTERED_OFFICE_ADDRESS_LINE_3 Registered office address line 3
REGISTERED_OFFICE_ADDRESS_LINE_4 Registered office address line 4
REGISTERED_OFFICE_ADDRESS_POSTCODE Registered office address line postcode
REGISTERED_OFFICE_ADDRESS_COUNTRY Registered office address line country

unincorporated_entities_core_data.csv

All registered and inactive sole traders, partnerships and trusts.

New Description
NZBN New Zealand Business Number
ENTITY_NAME Registered name
ENTITY_TYPE Type of entity (sole trader, partnership, trust)
ENTITY_STATUS The status of the entity
REGISTRATION_DATE Date the entity was registered on the register

retirement_villages_core_data.csv

All registered and struck off retirement villages.

New Description
ENTITY_NUMBER Unique identifier on the register
ENTITY_NAME Registered name
REGISTRATION_DATE Date the entity was registered on the register
ENTITY_STATUS Status of the entity
REGISTERED_OFFICE_ADDRESS_1 Registered office address line 1
REGISTERED_OFFICE_ADDRESS_2 Registered office address line 2
REGISTERED_OFFICE_ADDRESS_3 Registered office address line 3
REGISTERED_OFFICE_ADDRESS_4 Registered office address line 4
ADDRESS_FOR_COMMUNICATION_1 Address for communication line 1
ADDRESS_FOR_COMMUNICATION_2 Address for communication line 2
ADDRESS_FOR_COMMUNICATION_3 Address for communication line 3
ADDRESS_FOR_COMMUNICATION_4 Address for communication line 4
ADDRESS_FOR_PREMISES_1 Address for premises line 1
ADDRESS_FOR_PREMISES_2 Address for premises line 2
ADDRESS_FOR_PREMISES_3 Address for premises line 3
ADDRESS_FOR_PREMISES_4 Address for premises line 4
STATUTORY_SUPERVISOR_NAME Statutory supervisor of the entity
STATUTORY_SUPERVISOR_ADDRESS_1 Statutory supervisor address line 1
STATUTORY_SUPERVISOR_ADDRESS_2 Statutory supervisor address line 2
STATUTORY_SUPERVISOR_ADDRESS_3 Statutory supervisor address line 3
STATUTORY_SUPERVISOR_ADDRESS_4 Statutory supervisor address line 4
STATUTORY_SUPERVISOR_DATE_APPOINTED Date statutory supervisor was appointed
OPERATOR_NAME Operator name
OPERATOR_NUMBER Operator entity number
OPERATOR_ADDRESS_1 Operator address line 1
OPERATOR_ADDRESS_2 Operator address line 2
OPERATOR_ADDRESS_3 Operator address line 3
OPERATOR_ADDRESS_4 Operator address line 4
OPERATOR_DATE_APPOINTED Date operator was appointed

public_sector_entities_core_data.csv

All registered and inactive public sector entities with a New Zealand Business Number including central government, local government, education entities and other public entities.

New Description
NZBN New Zealand Business Number
ENTITY_NAME Registered name
ENTITY_TYPE Type of entity (central government, local government, education, other)
ENTITY_STATUS The status of the entity
REGISTRATION_DATE Date the entity was registered on the register

maori_business_identifier.csv

All registered entities (including non-company entities) that have identified on the New Zealand Business Number Register as a Māori business .

Old New Description
NZBN NZBN New Zealand Business Number
ENTITYNAME ENTITY_NAME Registered name
ENTITYTYPE ENTITY_TYPE Type of entity
STARTDATE START_DATE Start date of Māori business identifier
IDENTIFYINGFACTOR1 IDENTIFYING_FACTOR_1 Identifying factor 1
IDENTIFYINGFACTOR2 IDENTIFYING_FACTOR_2 Identifying factor 2
IDENTIFYINGFACTOR3 IDENTIFYING_FACTOR_3 Identifying factor 3
IDENTIFYINGFACTOR4 IDENTIFYING_FACTOR_4 Identifying factor 4
IDENTIFYINGFACTOR5 IDENTIFYING_FACTOR_5 Identifying factor 5
IDENTIFYINGFACTOR6 IDENTIFYING_FACTOR_6 Identifying factor 6
IDENTIFYINGFACTOR7 IDENTIFYING_FACTOR_7 Identifying factor 7
IDENTIFYINGFACTOR8 IDENTIFYING_FACTOR_8 Identifying factor 8
IDENTIFYINGFACTOR9 IDENTIFYING_FACTOR_9 Identifying factor 9
IDENTIFYINGFACTORFREETEXT IDENTIFYING_FACTOR_FREE_TEXT Identifying factor free text