twoHelixestwoHelixes Start free

Datasets / CC BY 4.0 · New Zealand Ministry of Education

New Zealand · school locations

Publicly sourced regional school directory. Location-only: no achievement scores or catchment polygons. Source dates and coverage vary; see /schools/region/nz.

2,578 rows16 columns CC BY 4.0 · New Zealand Ministry of Education

Worked examples

Each of these is a real run: the pipeline picked the columns, shaped the rows and chose the form. Open the trace to see what it decided and why.

New Zealand directory coverage

Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

New Zealand directory records0200400600Auckland RegionCanterbury RegionManawatū-Whanganu…Northland RegionHawke's Bay RegionSouthland RegionTasman RegionMarlborough RegionSchools
How many school location records are in each region? — 16 rows charted from 2,578, drawn as a hbar
How it decided
Finding the data885 ms

New Zealand · school locations: 2,578 rows, 16 columns. The directory identifier and region classify source records; missing coordinates are still counted.

Shaping the data7 ms

2,578 rows in, 16 out across 2 columns. Counts describe source directory records, not school quality or complete worldwide coverage. Smaller groups are retained as Other when needed.

Choosing the chart4 ms

hbar. A count comparison describes coverage without inventing achievement scores or attendance boundaries.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

Schema

16 columns, typed as the pipeline sees them — which is how it knows what can go on a time axis and what can be summed.

Column TypeExample
school_idtext1
school_nametextTe Kura o Te Kao
latitudenumber-34.6547
longitudenumber172.9659
achievement_scoretext
ranktext
countrytextNZ
regiontextNorthland Region
statetextNorthland Region
sectortextState
school_typetextComposite
addresstext6603 Far North Road
suburbtextTe Kao
postcodetext
statustextOpen
data_yeartext2026

First 8 rows

school_idschool_namelatitudelongitudeachievement_scorerankcountryregionstatesectorschool_typeaddresssuburbpostcodestatusdata_year
1Te Kura o Te Kao-34.6547172.9659NoneNoneNZNorthland RegionNorthland RegionStateComposite6603 Far North RoadTe KaoNoneOpen2026
2Taipa Area School-34.9947173.4643NoneNoneNZNorthland RegionNorthland RegionStateComposite578 State Highway 10TaipaNoneOpen2026
3Kaitaia College-35.1213173.2587NoneNoneNZNorthland RegionNorthland RegionStateSecondary (Year 9-15)53 Redan RoadKaitaiaNoneOpen2026
4Whangaroa College-35.1009173.7869NoneNoneNZNorthland RegionNorthland RegionStateSecondary (Year 7-15)4157 State Highway 10KaeoNoneOpen2026
5Kerikeri High School-35.2284173.9554NoneNoneNZNorthland RegionNorthland RegionStateSecondary (Year 7-15)48 Hone Heke RoadKerikeriNoneOpen2026
6Broadwood Area School-35.2612173.395NoneNoneNZNorthland RegionNorthland RegionStateComposite1041 Broadwood RoadBroadwoodNoneOpen2026
7Okaihau College-35.3238173.7658NoneNoneNZNorthland RegionNorthland RegionStateSecondary (Year 7-15)58 Settlers WayOkaihauNoneOpen2026
8Bay of Islands College-35.3795174.0759NoneNoneNZNorthland RegionNorthland RegionStateSecondary (Year 9-15)1-9 Derrick RoadKawakawaNoneOpen2026