publicdata.au publicdata.au on GitHub

NSW government schools, locations and enrolments, version 2026-10-02

latest
Rows 2,210Fields 45Fetched 3 October 2026Source SHA-256 2bc63daaf71d056e…

This version is kept for as long as this site exists, and its URL can be cited. Its files change only for the reasons the terms give, and each change is recorded in its notes. The ICSEA value column is left out because ACARA licenses ICSEA for non-commercial educational use only, and the Department has been asked whether its CC BY 4.0 licence covers it. The publisher's own file includes that column, so it is not kept beside each version.

Files

  • data.arrow387 KB Arrow: Arrow IPC file (Feather v2), zstd compressed, with the provenance in the schema metadata. Memory-maps in pyarrow, Polars, Arrow JS and R without parsing.
  • data.csv1.4 MB CSV: UTF-8 without a byte-order mark, RFC 4180 quoting, one header row using the normalised field names. Opens in Excel, Numbers and Sheets.
  • data.csv-metadata.json10 KB
  • data.csv.gz231 KB CSV (gzip): The same CSV, gzipped, at about a tenth of the size. curl, pandas, DuckDB and R read it directly.
  • data.duckdb DuckDB: One DuckDB database with a records table of typed columns, a fields table and a publicdata metadata table. It attaches read-only over HTTPS, so DuckDB, Python and R can query it without downloading it.
  • data.geo.parquet234 KB GeoParquet: the Parquet table with a WKB geometry column and its coordinate system in the file's geo metadata. Reads directly in DuckDB, GeoPandas, QGIS and GDAL.
  • data.geojson3.5 MB GeoJSON: A FeatureCollection with one Point per row and every field as a property. Rows without coordinates have a null geometry. Ready for QGIS, Leaflet, MapLibre and geopandas.
  • data.gpkg1.6 MB GeoPackage: A GeoPackage with one point layer, records, in the publisher's coordinate system, plus the fields and publicdata tables. Drag it into QGIS or ArcGIS.
  • data.json3.3 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 2,210 objects with typed values. Blank cells are null.
  • data.ndjson3.3 MB NDJSON: The first line is the provenance header, then one JSON object per line. For streaming and for tools that read line by line.
  • data.parquet241 KB Parquet: Columnar and typed. The smallest download and the fastest to query. Reads directly in DuckDB, pandas, Polars, Arrow and Spark. The provenance header is in the file metadata.
  • data.sqlite1.4 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx626 KB Excel: One workbook with a records sheet of 2,210 typed rows, a fields sheet and a publicdata sheet with the provenance. Dates are real Excel dates. Opens in Excel, Numbers, LibreOffice and Sheets.
  • manifest.json2.2 KB
  • schema.json7.1 KB
  • schema.sql3.4 KB

SHA256SUMS holds the SHA-256 of every file in this version under the name it downloads as. Check what you downloaded with sha256sum -c --ignore-missing SHA256SUMS in the same folder. On a Mac, use shasum -a 256 -c --ignore-missing SHA256SUMS. Each list is signed by the deploy that wrote it: gh attestation verify SHA256SUMS --repo National-Digital/publicdata.au --source-ref refs/heads/main shows it came from this project's main branch.

Attribution the licence asks for

NSW Department of Education, NSW Government, Master dataset: NSW government school locations and student enrolment numbers, sourced 3 October 2026, https://data.nsw.gov.au/data/dataset/nsw-education-nsw-public-schools-master-dataset, licensed under CC BY 4.0.

Provenance

Fetched from data.nsw.gov.au on 3 October 2026. The portal listed the licence as Creative Commons Attribution at that moment. manifest.json has every detail.

010203040501849: 111850: 61851: 51852: 71853: 21855: 31856: 31857: 41858: 241859: 111860: 141861: 221862: 171863: 121864: 91865: 181866: 61867: 181868: 381869: 2518691870: 151871: 171872: 141873: 91874: 91875: 181876: 181877: 151878: 321879: 251880: 171881: 261882: 311883: 431884: 351885: 181886: 171887: 191888: 161889: 181890: 171891: 3018911892: 161893: 131894: 111895: 101896: 61897: 81898: 71899: 61900: 61901: 91902: 61903: 71904: 71905: 51906: 31907: 101908: 91909: 51910: 111911: 41912: 151913: 1219131914: 61915: 101916: 91917: 121918: 71919: 91920: 141921: 91922: 161923: 131924: 101925: 121926: 101927: 131928: 121929: 161930: 81931: 51932: 21933: 61934: 51935: 619351936: 41937: 61938: 71939: 91941: 41942: 111943: 51944: 71945: 51946: 41947: 81948: 31949: 61950: 151951: 121952: 301953: 261954: 211955: 351956: 321957: 271958: 2719581959: 411960: 301961: 441962: 251963: 221964: 241965: 211966: 181967: 221968: 211969: 251970: 201971: 171972: 241973: 171974: 221975: 101976: 271977: 201978: 181979: 111980: 1419801981: 181982: 151983: 121984: 101985: 171986: 121987: 61988: 101989: 51990: 61991: 161992: 101993: 71994: 71995: 81996: 61997: 51998: 51999: 42000: 92001: 152002: 420022003: 92004: 62005: 52006: 32007: 62008: 32009: 32010: 12011: 12012: 12014: 32015: 62016: 22017: 12018: 22019: 82020: 62021: 72022: 12023: 102024: 42025: 62025
Openings of schools still open per year, 1849 to 2025. 2026 is not drawn because the rows run to 27 January 2026. A count of rows in this version, worked out in the build.
Change from the version before

First version followed here.

When the publisher releases again, this panel shows rows added, removed and changed by school_code, with a link to the diff file.