API New Zealand Schools
An API that accesses details of New Zealand schools including contact details, institution information, geospatial information and decile information is maintained on the data.govt.nz website, by the Ministry of Education.
Click here to go to the data.govt.nz to access the API.
Among other things the API can assist you to:
- combine the data with other datasets
- make real-time calls to the datasets to make sure you’ve got the most recent data
- provide a link from your application to a dataset on Data.govt.nz
An API offers a series of actions, such as
- resource metadata show - Gets the metadata of a specific data resource. The data resource download link, last updated date, etc. can be retrieved.
- Datastore search sql - Execute SQL queries on the DataStore to search data in a resource or connect multiple resources with join expressions
The JSON end point for the search function is https://catalogue.data.govt.nz/api/action/datastore_search_sql?sql= and the id for the Schools Directory is bdfe0e4c-1554-4701-a8fe-ba1c8e0cc2ce (resource ids can be found by searching data.govt.nz at https://catalogue.data.govt.nz/dataset )
The api requires a parameter of ?sql= followed by a valid SQL statement.
https://catalogue.data.govt.nz/api/3/action/datastore_search_sql?sql=SELECT * from "bdfe0e4c-1554-4701-a8fe-ba1c8e0cc2ce" will return the entire dataset.
The data in Ministry datasets contain macrons, so the query needs macrons as well! That is, specifying the column “Māori” as “Maori” will fail with a complaint that no such column exists. For instance, https://catalogue.data.govt.nz/api/3/action/datastore_search_sql?sql=SELECT "School_Id", "Org_Name" from "bdfe0e4c-1554-4701-a8fe-ba1c8e0cc2ce" WHERE "Add1_City" = 'Auckland' AND "Māori" > 30
Further information on the APIs can be found at https://www.data.govt.nz/use-data/using-data-govt-nz-apis/, with further technical documentation at https://docs.ckan.org/en/2.7/maintaining/datastore.html#the-datastore-api.
|School Number||An identifier used by the education sector to identify the organisation; aka MoE Number.|
|Org Name||The name of school/campus/institution (see Schooling Organisations section).|
|Telephone||Telephone number for each institution, including area code.|
|Fax||Facsimile number for each institution, including area code.|
|Email address for appropriate administrative contact for institution (see Email Addresses section)|
|Contact1_Name||The name of the principal, acting principal or director (for activity centres). Presented as a combination of all name elements as one composite text element, e.g. “Mary Smith”.|
|URL||The institution website.|
|Add1_Line1||Physical address: Street.|
|Add1_Suburb||Physical address: Suburb.|
|Add1_City||Physical address: Town / City.|
|Add2_Line1||Mailing Address: Postal Address 1.|
|Add2_Suburb||Mailing Address: The suburb for an urban address in larger towns and cities. May be used for Rural Delivery Number for rural addresses.|
|Add2_City||Mailing Address: City or town as recognised for postal delivery|
|Add2_Postal_Code||Mailing Address: The post code for the address|
|Urban_Area||Urban Area as per Statistics NZ Urban Area- Urban areas are statistically defined areas with no administrative or legal basis. There are 150 urban areas in the 2017 urban area classification.|
The organisation type. Defined organisation types are:
Provides further descriptive information on the type of each institution.
A summary description of the gender(s) accepted by the institution: Defined institution genders are:
|Territorial_Authority||Territorial Authority as per Statistics NZ Territorial Authority - Territorial authorities are the second tier of local government in New Zealand, below regional councils. There are 67 territorial authorities in the Territorial Authority 2018 classification.|
|Regional_Council||Regional Council as per Statistics NZ Regional Council - Regional councils are the top tier of local government in New Zealand. There are 16 regions in the Regional Council 2018 classification which cover every territorial authority in New Zealand, with the exception of the Chatham Islands Territory. Five regions are administered as unitary authorities, which function as both regional council and territorial authority.|
|Local_Office_Name||Name of the Local Office|
A region of New Zealand as defined by the Ministry and used for Ministry administrative purposes. Defined education regions are:
|Area_Unit||Census Area Unit as per Statistics NZ Area Unit 2017 - Area units are non-administrative areas intermediate between meshblocks and territorial authorities|
|Ward||The Ward area of the school as per Statistics NZ Ward. Wards are subdivisions of territorial authorities and result from the division, for electoral purposes, of the district of a territorial authority. There are 245 wards in the 2017 ward classification..|
|General_Electorate||General Electorate as per Statistics NZ General Electoral District - General electoral districts are the voting districts for parliamentary elections. There are 64 electoral districts in the General Electoral District 2014 classification.|
|Māori_Electorate||Māori Electorate as per Statistics NZ Māori Electoral District - Māori electoral districts are the voting districts for parliamentary elections for people who choose to be on the Māori electoral roll. There are 7 Māori electoral districts in the Māori Electoral District 2014 classification.|
|Col_Id||Community of Learning: ID. An identifier used by the education sector to identify the Community of Learning | Kāhui Ako.|
|Col_Name||The name of the Community of Learning | Kāhui Ako.|
|Latitude||Latitudinal co-ordinate where the institution is located|
|Longitude||Longitudinal co-ordinate where the institution is located|
|Decile||A schools decile indicated the extent to which the school draws its students from the low socio-economic communities. Decile 1 schools are the 10% of schools with the highest proportion of students from the low socio-economic communities, whereas decile 10 schools are the 10% of schools with the lowest proportion of these students. A schools decile does not indicate the overall socio-economic mix of the school..|
|Indicative Roll Information|
|Roll_Date||The date when the enrolment summary was determined.|
|Total||The total roll of the institution (see Indicative Roll Numbers)|
|European||The number of student enrolled that affiliate as European, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section)|
|Māori||The number of student enrolled that affiliate as Māori, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section)|
|Pacific||The number of student enrolled that affiliate as Pacific, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section)|
|Asian||The number of student enrolled that affiliate as Asian, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section).|
|MELAA||The number of student enrolled that affiliate as Middle Eastern, Latin American or African, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section)|
|Other||The number of student enrolled that affiliate as Other ethnicity, as per Statistics NZ Ethnicity New Zealand Standard Classification 2005. Roll numbers presented here are prioritised (see Ethnic Classification section).|
|International||The number of international students enrolled in the institution.|
As well as open schools this directory shows proposed schools. Only limited information may be available for these proposed schools.
Some school boards of trustees have units that have been set up for specific purposes, such as teen parent units. Students from a number of schools may attend the unit for courses of varying length. Two type of special purpose units are included in this directory; teen parent units and activity centres.
Established by agreement of the Minister of Education, teen parent units are for students unable to learn in the mainstream educational system because of pregnancy and child rearing responsibilities.
Established by the Minster of Education, although no more are to be established, activity centres provide a specialised learning programme for secondary school students (years 9–13) who are at risk of disengaging from mainstream schooling and/or at risk of low educational, social, or vocational outcomes.
Only schools that agreed to the public release of their email address have those addresses listed here. Persons or organisations wishing to send email material to individuals or organisations whose email addresses appear in this directory must comply with the requirements of the Unsolicited Electronic Messages Act 2007. Publication of email addresses on this site should not be taken as deemed consent to receiving unsolicited email.
Indicative Roll Numbers
Roll numbers presented here are not from the Ministry’s formal roll collections. They are estimates calculated from ENROL, a Ministry of Education system. ENROL is a register of student enrolments. It lets schools update enrolments as students enrol, change schools or leave the school system. The system was developed to facilitate the accurate and efficient enrolment of students, and, to monitor and ensure student enrolment and attendance (particularly during the compulsory schooling ages).
The term "ethnicity" refers to the ethnic group or groups to which an individual belongs. The concept of ethnicity adopted by the Ministry of Education is a social construct of group affiliation and identity. The Ministry of Education uses the definition of ethnicity used by Statistics New Zealand, namely:
A social group whose members have one or more of the following characteristics:
- they share a sense of common origins,
- they claim a common and distinctive history and destiny,
- they possess one or more dimensions of collective cultural individuality,
- they feel a sense of unique collective solidarity.
Where possible, ethnicity data is presented as a multiple response. Multiple response works by considering each ethnicity a person affiliates with as one data entry. For example, the data relating to an individual who affiliates as both Māori and Pasifika will be included in both categories. They are, however, included only once in the total. This approach is easily undertaken when data is collected in a disaggregate fashion.
However, school rolls are based on prioritised ethnicity. Prioritisation of ethnicity is when people are allocated to one of the ethnicities they have recorded that they affiliate with. This usually occurs when data are collected manually and/or aggregate data returns are collected centrally. This allocation is performed using a predetermined order of ethnic groups. Where ethnicity is prioritised it is in the order of Māori, Pasifika, Asian, MELAA (Middle Eastern, Latin American, and African), other groups except European/Pākehā, and European/Pākehā.
European/Pākehā refers to people who affiliate as New Zealand European, Other European or European (not further defined). For example this includes, but is not limited to, people who consider themselves as Australian (not including Australian Aborigines), British and Irish, American, Spanish, and Ukrainian.
Go to the API Schools Directory page on the data.govt.nz website
Download the information on this web page:
API Support Information
Where to Find out More
For a range of education data pertaining to individual schools please visit: Find a School
Education Data Requests
If you have any questions about education data then please contact us at:
Email: Requests EDK
Phone: +64 4 463 8065
Updating School Details
If you would like to update the details for a school, please email the: Information Mailbox