Road crashes, New South Wales, version 2026-10-09
latestThis 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.xlsx, byte for byte.
Files
- data.csv58 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.gz10 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.parquet5.8 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.gpkg61 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.ndjson159 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.parquet5.0 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.sqlite54 MB SQLite: One database with a records table, a fields table and a publicdata metadata table. Open it with any SQLite client.
- manifest.json3.4 KB
- schema.json11 KB
- schema.sql4.7 KB
- source.xlsx23 MB
Excel is not offered because the table is 58.1 MB as CSV, over the 50 MB limit for Excel. JSON is not offered because the table is 158.8 MB as NDJSON, over the 50 MB limit for JSON. GeoJSON is not offered because the file would be 168.0 MB, over the 100 MB limit for GeoJSON.
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/year_of_crash/.
Change from 2025-10-10
19557 rows added, 18704 removed and 139 changed by the key crash_id. The full list is in diff/2025-10-10..2026-10-09.json.
Transport for NSW, NSW Government, NSW Crash Data, sourced 12 October 2026, https://data.nsw.gov.au/data/dataset/2-nsw-crash-data, licensed under CC BY 3.0 AU.
Fetched from opendata.transport.nsw.gov.au on 12 October 2026. The portal listed the licence as Creative Commons Attribution at that moment. manifest.json has every detail.
+19557 added · −18704 removed · 139 changed
Against 2025-10-10, by the key crash_id. The full list is in diff/2025-10-10..2026-10-09.json.
Other versions: 2025-10-10.