Traffic and camera offences and fines, ACT, version 2026-10-12

Files

• data.csv20 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.json2.5 KB
• data.csv.gz1.1 MB 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.ndjson50 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.parquet513 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.sqlite20 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
• data.xlsx6.3 MB Excel: One workbook with a records sheet of 200,143 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.7 KB
• schema.json1.0 KB
• schema.sql816 B
• source.csv19 MB

JSON is not offered because the table is 50.4 MB as NDJSON, over the 50 MB limit for JSON.

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/infringement_type/.

Change from 2026-10-06

199,446 rows in 2026-10-06 and 200,143 in this version. No key is declared, so rows are compared by count only. The comparison is in diff/2026-10-06..2026-10-12.json.