publicdata.au publicdata.au on GitHub

Road crashes, Victoria, version 2026-09-15

Rows 200,754Fields 64Fetched 29 September 2026Source SHA-256 5d1621deef51bb92…

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.arrow35 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.csv108 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.json14 KB
  • data.csv.gz22 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.geo.parquet13 MB 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.geojson315 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.gpkg117 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.json295 MB JSON: One object with a publicdata header (publisher, licence, attribution, version, source hash), a fields list and a records array of 200,754 objects with typed values. Blank cells are null.
  • data.ndjson295 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.parquet13 MB 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.sqlite99 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
  • data.xlsx69 MB Excel: One workbook with a records sheet of 200,754 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.6 KB
  • schema.json11 KB
  • schema.sql5.4 KB
  • source.csv70 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/lga_name/.

Attribution the licence asks for

Department of Transport and Planning, Victoria, Victoria Road Crash Data, https://discover.data.vic.gov.au/dataset/victoria-road-crash-data, accessed 29 September 2026, licensed under CC BY 4.0.

Provenance

Fetched from opendata.transport.vic.gov.au on 29 September 2026. The portal listed the licence as Creative Commons Attribution 4.0 International at that moment. manifest.json has every detail.

05k10k15k20k2012 Fatal accident: 2612012 Other injury accident: 8,9412012 Serious injury accident: 4,7102013 Fatal accident: 2252013 Other injury accident: 9,0262013 Serious injury accident: 4,77220132014 Fatal accident: 2232014 Other injury accident: 9,1202014 Serious injury accident: 5,1602015 Fatal accident: 2312015 Other injury accident: 10,0352015 Serious injury accident: 5,41820152016 Fatal accident: 2752016 Other injury accident: 9,7072016 Serious injury accident: 5,7972017 Fatal accident: 2402017 Other injury accident: 7,5922017 Serious injury accident: 5,51920172018 Fatal accident: 2022018 Other injury accident: 7,0052018 Serious injury accident: 5,5582019 Fatal accident: 2482019 Non injury accident: 12019 Other injury accident: 8,4692019 Serious injury accident: 5,68120192020 Fatal accident: 1952020 Other injury accident: 7,3442020 Serious injury accident: 4,6312021 Fatal accident: 2162021 Non injury accident: 12021 Other injury accident: 8,7892021 Serious injury accident: 5,00720212022 Fatal accident: 2392022 Non injury accident: 22022 Other injury accident: 10,0332022 Serious injury accident: 4,7692023 Fatal accident: 2612023 Other injury accident: 10,1762023 Serious injury accident: 5,12520232024 Fatal accident: 2712024 Other injury accident: 10,2532024 Serious injury accident: 4,8682025 Fatal accident: 2652025 Other injury accident: 8,6322025 Serious injury accident: 5,1252025
Fatal accidentNon injury accidentOther injury accidentSerious injury accident
Crashes per year by severity, 2012 to 2025. 2026 is not drawn because the rows run to 31 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 accident_no, with a link to the diff file.

Other versions: 2026-10-12, 2026-11-09.