Explore Speed and red light camera offences, South Australia
Charts and tables over the 45,229 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: South Australia Police, Government of South Australia, Expiation Notice System Data, https://data.sa.gov.au/data/dataset/expiation-notice-system-data, accessed 3 October 2026, licensed under CC BY 4.0. 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. 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 |
|---|---|---|---|
| Event ID | event_id | string | |
| Notice revision | notice_revision | string | |
| Notice type | notice_type | string | |
| Notice status | notice_status | string | |
| Offence status | offence_status | string | |
| Withdrawn reason | withdrawn_reason | string | |
| Incident date | incident_date | date | |
| Incident time | incident_time | string | 24-hour time, as published, such as 0:05. |
| Offence code | offence_code | string | |
| Offence | offence_description | string | |
| Issue date | issue_date | date | |
| Camera category | camera_category | string | |
| Location code | location_code | string | Kept as text to preserve leading zeros. |
| Location | location_description | string | |
| Suburb | location_suburb | string | |
| Police district or service area | district | string | |
| Vehicle | vehicle_description | string | |
| Licence state | licence_state | string | |
| Registration state | registration_state | string | |
| Vehicle speed (km/h) | vehicle_speed | integer | |
| Speed limit (km/h) | speed_limit | integer | |
| Penalty | penalty_amount | string | The legislated penalty for the offence at the time. As published, in dollars with a dollar sign, such as $1,002. |
| Victims of crime levy | victims_of_crime_levy | string | The levy at the time of the incident. As published, in dollars with a dollar sign, such as $1,002. |
| Corporate fee | corporate_fee | string | The fee where the vehicle is registered to a company. As published, in dollars with a dollar sign, such as $1,002. |
| Total | offence_total | string | The penalty, levy and corporate fee together. As published, in dollars with a dollar sign, such as $1,002. |
How it runs
The page downloads DuckDB and Perspective once, about 17 MB, then this version's data.parquet (949 KB). 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.