Road crashes, Tasmania

What is in it

Column names are made snake_case and the publisher's original header is kept beside each one. Blank cells are null. Nothing is added, removed, ranked or summarised. Cells were typed and headers were made snake_case. The point geometry became longitude and latitude fields. Rows were left alone.

Download this table as a data dictionary (Excel), or read it as a Frictionless Table Schema at schema.json. The key is id.

A sample of 10 rows

From the latest version, newest first by date and time, each severity in turn, then in the publisher's order, with every field. A blank cell is shown as null.

GET https://publicdata.au/d/tas-road-crashes/latest/data.json
{
  "id": 1652,
  "vcrn": "13000032",
  "description": "136 - Vehicles in parallel lane/ right turn side swipe",
  "crash_date_time": "2013-03-30T00:16:00",
  "severity": "Property Damage Only",
  "visited": "Yes",
  "surface_type": "Sealed",
  "light_condition": "Daylight",
  "centre_line": "Single Continuous",
  "speed_zone": "060",
  "location_description": "Intersection of Brooker Avenue, Hobart, Hobart",
  "longitude": 147.3307030815645,
  "latitude": -42.878281459848566,
  "sa2_2021_code": "601051027",
  "sa2_2021_name": "Hobart",
  "lga_2025_code": "62810",
  "lga_2025_name": "Hobart",
  "sal_2021_code": "60276",
  "sal_2021_name": "Hobart",
  "poa_2021_code": "7000",
  "poa_2021_name": "7000",
  "sed_2025_code": "60303",
  "sed_2025_name": "Clark (Hobart)",
  "ced_2025_code": "603",
  "ced_2025_name": "Clark"
}Copy

Query it without downloading

The query API returns only the rows you ask for, as JSON, NDJSON or CSV, from the same typed rows as the files. It needs no key. Build a query here and run it, then copy the URL or the code into your own work.

Smaller files

The same rows split by a field, one JSON file each with a GeoJSON beside it. Each file carries the same provenance header.

By severity (6 files)

by/severity/index.json lists every file with its row count.

What changed

One version for every release the publisher has made since this site started following the dataset. The date is the day the file changed on the portal.

• 2026-10-04
  176,221 rows+18 added −0 removed 7 changed25 fieldsutf-86124d5a4dbba
  The layer states no edit date, so this version is dated by the newest record it holds.
  The publisher offers no file. These bytes are every feature of the layer as the service returned them in WGS84, ordered by its object id, so the same layer gives the same bytes.
• 2026-10-03
  176,203 rows+46 added −0 removed 39 changed25 fieldsutf-8b9524641c0a7
  The layer states no edit date, so this version is dated by the newest record it holds.
  The publisher offers no file. These bytes are every feature of the layer as the service returned them in WGS84, ordered by its object id, so the same layer gives the same bytes.
• 2026-10-01
  176,157 rows+8 added −0 removed 1 changed25 fieldsutf-8854c7df5ba96
  The layer states no edit date, so this version is dated by the newest record it holds.
  The publisher's file changed on 2026-09-30, which an earlier version already carries, so this version is dated 2026-10-01.
  The publisher offers no file. These bytes are every feature of the layer as the service returned them in WGS84, ordered by its object id, so the same layer gives the same bytes.
• 2026-09-30
  176,149 rows+18 added −2 removed 29 changed25 fieldsutf-8f1f3d528b711
  The layer states no edit date, so this version is dated by the newest record it holds.
  The publisher offers no file. These bytes are every feature of the layer as the service returned them in WGS84, ordered by its object id, so the same layer gives the same bytes.
• 2026-09-29
  176,133 rows25 fieldsutf-85d4f0e21680d
  The layer states no edit date, so this version is dated by the newest record it holds.
  The publisher offers no file. These bytes are every feature of the layer as the service returned them in WGS84, ordered by its object id, so the same layer gives the same bytes.

versions.json · changes.json · history.tar.zst (29 MB, every version's Parquet and manifest)

Questions