publicdata.au publicdata.au on GitHub

Traffic camera offences and fines, ACT, 2010 to 2021, version 2025-05-15

latest
Rows 91,662Fields 9Fetched 3 October 2026Source SHA-256 051fbff135512437…

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 publisher's file is here as source.csv, byte for byte.

Files

  • data.arrow2.1 MB 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.csv14 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.6 KB
  • data.csv.gz666 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.json28 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 91,662 objects with typed values. Blank cells are null.
  • data.ndjson28 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.parquet320 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.sqlite14 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx3.6 MB Excel: One workbook with a records sheet of 91,662 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.5 KB
  • schema.json1.0 KB
  • schema.sql863 B
  • source.csv13 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.

Smaller files by field: by/camera_type/.

Attribution the licence asks for

Access Canberra, ACT Government, Traffic camera offences and fines from 07/2010 to 06/2021, https://www.data.act.gov.au/d/2sx9-4wg7, accessed 3 October 2026, licensed under CC BY 4.0.

Provenance

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

020k40k60k80k2011 FIXED ONLY SPEED CAMERA: 26,3502011 MOBILE SPEED CAMERA: 11,1232011 RED LIGHT AND SPEED CAMERA: 23,79520112012 FIXED ONLY SPEED CAMERA: 22,2892012 MOBILE SPEED CAMERA: 7,0902012 POINT TO POINT CAMERA: 3,2852012 RED LIGHT AND SPEED CAMERA: 26,4842013 FIXED ONLY SPEED CAMERA: 20,1882013 MOBILE SPEED CAMERA: 8,2122013 POINT TO POINT CAMERA: 2,3192013 RED LIGHT AND SPEED CAMERA: 26,37620132014 FIXED ONLY SPEED CAMERA: 19,9402014 MOBILE SPEED CAMERA: 6,7762014 POINT TO POINT CAMERA: 2,4362014 RED LIGHT AND SPEED CAMERA: 20,6582015 FIXED ONLY SPEED CAMERA: 21,7472015 MOBILE SPEED CAMERA: 10,0542015 POINT TO POINT CAMERA: 3,0342015 RED LIGHT AND SPEED CAMERA: 21,45920152016 FIXED ONLY SPEED CAMERA: 20,4662016 MOBILE SPEED CAMERA: 19,5612016 POINT TO POINT CAMERA: 2,6902016 RED LIGHT AND SPEED CAMERA: 18,5982017 FIXED ONLY SPEED CAMERA: 19,0532017 MOBILE SPEED CAMERA: 21,5812017 POINT TO POINT CAMERA: 2,8952017 RED LIGHT AND SPEED CAMERA: 15,69220172018 FIXED ONLY SPEED CAMERA: 23,6482018 MOBILE SPEED CAMERA: 29,3302018 POINT TO POINT CAMERA: 3,7692018 RED LIGHT AND SPEED CAMERA: 14,3342019 FIXED ONLY SPEED CAMERA: 20,9902019 MOBILE SPEED CAMERA: 26,6612019 POINT TO POINT CAMERA: 3,4412019 RED LIGHT AND SPEED CAMERA: 11,1202019
FIXED ONLY SPEED CAMERAMOBILE SPEED CAMERAPOINT TO POINT CAMERARED LIGHT AND SPEED CAMERA
Infringements per year by camera type, 2011 to 2019. Rows where month is at least 2011-01-01 and month is under 2021-01-01 are drawn. 2020 is not drawn because the rows run to 1 December 2020. A sum of the infringements column 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, with a link to the diff file.