Suburbs and localities to postal areas correspondence, 2021, Australia, version 2026-10-14

Files

• data.csv723 KB 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.json2.5 KB
• data.csv.gz163 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.json2.8 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 15,433 objects with typed values. Blank cells are null.
• data.ndjson2.8 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.parquet192 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.sqlite946 KB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
• data.xlsx554 KB Excel: One workbook with a records sheet of 15,433 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.json1.9 KB
• schema.json859 B
• schema.sql812 B
• source.zip35 MB

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.