Recorded offences by region and month, Northern Territory, version 2026-10-12

Files

• data.csv1.1 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.json3.3 KB
• data.csv.gz57 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.5 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 10,354 objects with typed values. Blank cells are null.
• data.ndjson2.5 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.parquet24 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.9 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
• data.xlsx396 KB Excel: One workbook with a records sheet of 10,354 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.0 KB
• schema.json1.6 KB
• schema.sql1.4 KB
• source.csv969 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.

Smaller files by field: by/reporting_region/.

Change from 2026-09-14

322 rows added, 3 removed and 10032 changed by the key year, month, offence_category, offence_type, alcohol_involvement, dv_involvement, reporting_region, sa2. The full list is in diff/2026-09-14..2026-10-12.json.