API Early Childhood Centres and Schools
Using APIs
Click here to go to the data.govt.nz Data Explorer for the Early Childhood Education Directory API.
Click here to go to the data.govt.nz Data Explorer for the School Directory API.
Details are included on the data.govt.nz site regarding downloading this dataset, as well as further information related to using APIs to facilitate more in-depth querying capabilities.
These files can also be accessed via the data.govt.nz Application Programming Interfaces (APIs). Among other things the APIs 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 data.govt.nz DataStore API allows you to access and query the rows and columns of raw data listed by agencies in machine readable format via a JSON API endpoint. For SQL queries this endpoint is https://catalogue.data.govt.nz/api/action/datastore_search_sql and the data sources for the ?sql= parameter are identified by Resource IDs, shown in the table below:
Resource | ID |
---|---|
ECE Directory | 26f44973-b06d-479d-b697-8d7943c97c57 |
Schools Directory | bdfe0e4c-1554-4701-a8fe-ba1c8e0cc2ce |
For Instance, a request to: https://catalogue.data.govt.nz/api/3/action/datastore_search_sql?sql=SELECT * FROM"bdfe0e4c-1554-4701-a8fe-ba1c8e0cc2ce" will return all rows and columns from the Schools Directory dataset.
NB: 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.
Many of the datasets that the Ministry maintains in data.govt.nz are being converted to resources accessible through the APIs and this documentation will be amended as that conversion proceeds.
Further technical documentation is available at https://docs.ckan.org/en/2.7/maintaining/datastore.html#the-datastore-api.
ECE Description of Variables
Service Identification | |
---|---|
ECE_Id | An identifier used by the education sector to identify the organisation; aka MoE Number. |
Org_Name | The name of an early childhood education service. |
Contact Details | |
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) | |
Location | |
Add1_Line1 | Physical address: Street. |
Add1_Suburb | Physical address: Suburb. |
Add1_City | Physical address: Town / City. |
Institution Information | |
Org_Type |
The organisation type. Defined organisation types are:
|
Definition | Provides further descriptive information on the type of each institution. |
Authority |
Describes the ownership/operation or registration status of each educational institution. Defined authorities are:
|
Funding | |
20 Hours ECE | 20 Hours ECE allows for those aged three and over in licensed ECE services to receive up to 20 hours a week of early childhood education with no compulsory fees. |
Equity Index | Equity Funding is determined by a service's Equity Index value whihc is calculated using the addresses of children attending the service. |
Regional Information | |
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. |
Education_Region |
A region of New Zealand as defined by the Ministry and used for Ministry administrative purposes. Defined education regions are:
|
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. |
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.. |
Management Contacts | |
Contact1_Name | Contact name of management at the service. |
Add2_Line1 | Mailing Address: The street address or PO Box of management contact. |
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. |
Management_Telephone | Telephone number for management contact at each services, including area code. |
Management_Fax | Facsimilie number for management contact at each service, including area code. |
Community of Learning | |
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. |
Geospatial | |
Latitude | Latitudinal co-ordinate where the institution is located |
Longitude | Longitudinal co-ordinate where the institution is located |
Enrolment Information | |
All_Children | Maximum number of children that a service is licencsed to provide early childhood education at any one time. |
Under_2s | Maximum number of children under two years old that a service is licensed to provide early childhood education at any one time. |
ECERollYearMonth | The date when the enrolment summary was determined. |
Age_0 | The number of children enrolled in the service that are aged up to and including 364 days old. |
Age_1 | The number of children enrolled in the service that are one year old (1 year to 1 year and 364 days). |
Age_2 | The number of children enrolled in the service that are two years old (2 years to 2 years and 364 days). |
Age_3 | The number of children enrolled in the service that are three years old (3 years to 3 years and 364 days). |
Age_4 | The number of children enrolled in the service that are four years old (4 years to 4 years and 364 days). |
Age_5 | The number of children enrolled in the service that are five years old (5 years to 5 years and 364 days). |
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). |
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). |
Schooling Description of Variables
School Identification | |
---|---|
School ID | 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). |
Contact Details | |
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. |
Location | |
Add1_Line1 | Physical address: Street. |
Add1_Suburb | Physical address: Suburb. |
Add1_City | Physical address: Town / City. |
Postal Address | |
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 |
Rurality | |
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. |
Institution Information | |
Org_Type |
The organisation type. Defined organisation types are:
|
Definition |
Provides further descriptive information on the type of each institution.
|
CoEd_Status |
A summary description of the gender(s) accepted by the institution: Defined institution genders are:
|
Regional Information | |
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 |
Education_Region |
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 | |
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. |
Additional Notes
Schooling Organisations
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.
Email Addresses
Only ECE centres and 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 (Schools Directory)
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).
Ethnic Classification
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, ECE and 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.