ACT Road Crash Data

<b>DATASET DISCLAIMER: Spatial location of road crashes within the ACT from 2012 to 2021 that have been reported by the Police or the Public through the AFP Crash Report Form. This dataset only represents crashes that have been reported using the AFP Crash Report Form, and any crashes which have been reported through other channels are not displayed within this dataset.

Note that this data may not represent the exact spatial location of each reported road crash, as the points of each crash are purely indicative of the intersection or midblock location as indicated by the point attributes. Crashes are reviewed on an annual basis, so the existing data may change over time as a result of this review.</b>

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"data-act-gov-au/act-road-crash-data-6jn4-m8rx\".\"act_road_crash_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.