Explore Road crashes, New South Wales
Charts and tables over the 92,189 rows of the latest version, worked out in your browser from the Parquet file. Nothing you do here leaves the browser until you save a link.
Paste this where the dashboard should appear. The frame shows the attribution and links back here.
The explorer needs JavaScript and a browser from the last few years. The dataset page has every file and the query API.
Press Edit on any panel to change its chart type and drag fields into Group by, Split by and Filter. Drag a panel by its title to move or dock it, and click a bar in the first chart to filter the rest.
Data: Transport for NSW, NSW Government, NSW Crash Data, sourced 29 September 2026, https://data.nsw.gov.au/data/dataset/2-nsw-crash-data, licensed under CC BY 3.0 AU. Licence terms.
How it works
Change a panel
Press Edit at the top right of a panel to open its settings. Drag fields into Group by, Split by, Sort by and Filter, pick a chart type at the top, and choose sum, count or average beside each number. More fields lists everything else in the dataset. The chart types include bars, lines, areas, scatter plots, heatmaps, treemaps and sunbursts, and maps of the coordinates. Add a chart puts a new panel on the dashboard. Drag a panel's title bar to move it, or drag the line between panels to resize.
Filter every panel at once
The chart marked Click to filter the others does just that: click a bar and the other panels show only those rows. Click it again to clear. Any panel can do the same. Open the menu at the left of its title bar and turn on filtering from there.
Share or keep a dashboard
The address bar holds the whole dashboard, so copying it is enough. Save a short link to store the dashboard on this site and get a shorter address. A saved dashboard never changes; saving again after an edit makes a new link. Embed gives a frame you can paste into a web page, with the attribution inside it.
Download what you see
The export button in a panel's settings toolbar downloads the panel as CSV, JSON or Arrow, or a chart as PNG. The copy button beside it puts the same data on the clipboard. The full files are on the dataset page.
What the fields mean
The explorer names each field in words. The files and the query API use the field name beside it.
| In the explorer | Field name | Type | Note |
|---|---|---|---|
| Crash ID | crash_id | integer | |
| Degree of crash | degree_of_crash | string | |
| Degree of crash, detailed | degree_of_crash_detailed | string | |
| Reporting year | reporting_year | integer | |
| Year of crash | year_of_crash | integer | |
| Month of crash | month_of_crash | string | |
| Day of week of crash | day_of_week_of_crash | string | |
| Time of day (two-hour band) | two_hour_intervals | string | |
| Street of crash | street_of_crash | string | |
| Street type | street_type | string | |
| Distance from feature (m) | distance | integer | |
| Direction from feature | direction | string | |
| Identifying feature | identifying_feature | string | |
| Identifying feature type | identifying_feature_type | string | |
| Town | town | string | |
| Route number | route_no | integer | |
| School zone location | school_zone_location | string | |
| School zone active | school_zone_active | string | |
| Type of location | type_of_location | string | |
| Latitude | latitude | number | As published. The publisher's data manual does not state the datum. |
| Longitude | longitude | number | As published. The publisher's data manual does not state the datum. |
| LGA | lga | string | |
| Urbanisation | urbanisation | string | |
| Conurbation 1 | conurbation_1 | string | |
| Alignment | alignment | string | |
| Primary permanent feature | primary_permanent_feature | string | |
| Primary temporary feature | primary_temporary_feature | string | |
| Primary hazardous feature | primary_hazardous_feature | string | |
| Street lighting | street_lighting | string | |
| Road surface | road_surface | string | |
| Surface condition | surface_condition | string | |
| Weather | weather | string | |
| Natural lighting | natural_lighting | string | |
| Signals operation | signals_operation | string | |
| Other traffic control | other_traffic_control | string | |
| Speed limit | speed_limit | string | |
| Road classification | road_classification_admin | string | |
| RUM code | rum_code | integer | |
| RUM description | rum_description | string | |
| DCA code | dca_code | integer | |
| DCA description | dca_description | string | |
| DCA supplement | dca_supplement | string | |
| First impact type | first_impact_type | string | |
| Key traffic unit type | key_tu_type | string | |
| Other traffic unit type | other_tu_type | string | |
| Traffic units involved | traffic_units | integer | |
| Killed | killed | integer | |
| Seriously injured | seriously_injured | integer | |
| Moderately injured | moderately_injured | integer | |
| Minor or other injury | minor_other_injured | integer | |
| SA2 code (2021) | sa2_2021_code | string | Code of the Statistical Area Level 2 (2021) the point falls in. Joined by location from abs-sa2-2021, not published by the publisher. |
| SA2 (2021) | sa2_2021_name | string | Name of the Statistical Area Level 2 (2021) the point falls in. Joined by location from abs-sa2-2021, not published by the publisher. |
| Council area code (LGA 2025) | lga_2025_code | string | Code of the Local Government Area (2025) the point falls in. Joined by location from abs-lga-2025, not published by the publisher. |
| Council area (LGA 2025) | lga_2025_name | string | Name of the Local Government Area (2025) the point falls in. Joined by location from abs-lga-2025, not published by the publisher. |
| Suburb or locality code (2021) | sal_2021_code | string | Code of the Suburb and Locality (2021) the point falls in. Joined by location from abs-suburbs-localities-2021, not published by the publisher. |
| Suburb or locality (2021) | sal_2021_name | string | Name of the Suburb and Locality (2021) the point falls in. Joined by location from abs-suburbs-localities-2021, not published by the publisher. |
| Postal area code (2021) | poa_2021_code | string | Code of the Postal Area (2021) the point falls in. Joined by location from abs-postal-areas-2021, not published by the publisher. |
| Postcode (postal area 2021) | poa_2021_name | string | Name of the Postal Area (2021) the point falls in. Joined by location from abs-postal-areas-2021, not published by the publisher. |
| State electorate code (2025) | sed_2025_code | string | Code of the State Electoral Division (2025) the point falls in. Joined by location from abs-state-electoral-divisions-2025, not published by the publisher. |
| State electorate (2025) | sed_2025_name | string | Name of the State Electoral Division (2025) the point falls in. Joined by location from abs-state-electoral-divisions-2025, not published by the publisher. |
| Federal electorate code (2025) | ced_2025_code | string | Code of the Commonwealth Electoral Division (2025) the point falls in. Joined by location from abs-federal-electoral-divisions-2025, not published by the publisher. |
| Federal electorate (2025) | ced_2025_name | string | Name of the Commonwealth Electoral Division (2025) the point falls in. Joined by location from abs-federal-electoral-divisions-2025, not published by the publisher. |
How it runs
The page downloads DuckDB and Perspective once, about 17 MB, then this version's data.parquet (5.0 MB). Every chart is a query DuckDB answers in the browser, so there is no rate limit and the files stay the only source. Dated versions never change, so a saved dashboard over one shows the same numbers for good. A map panel draws its background from OpenStreetMap tiles, so while one is on screen your browser asks OpenStreetMap for them and it sees your IP address. The data itself never leaves the browser.