Tidy dataset

5. Defendants finalised, Victoria (Tables 27 to 32) — Table 31

A tidy Criminal Courts, Australia table with 684 rows. It reports recorded values by principal offence, year and outcome.

Status
approved
Publisher
Australian Bureau of Statistics
Release
2024-25
License
CC-BY-4.0

View the recorded source

Data preview

Showing the first 30 of 684 rows
601 Homicide(a)2024–25Adjudicated outcomes(d)
840802 Assault2024–25Adjudicated outcomes(d)
60603 Sexual offences2024–25Adjudicated outcomes(d)
253804 Harm or endanger persons2024–25Adjudicated outcomes(d)
10805 Robbery, blackmail, and extortion2024–25Adjudicated outcomes(d)
70906 Burglary2024–25Adjudicated outcomes(d)
442507 Theft2024–25Adjudicated outcomes(d)
186308 Fraud and related offences2024–25Adjudicated outcomes(d)
301609 Drug offences2024–25Adjudicated outcomes(d)
251110 Weapons and explosives offences2024–25Adjudicated outcomes(d)
258011 Property damage2024–25Adjudicated outcomes(d)
117612 Public order, health, and safety offences2024–25Adjudicated outcomes(d)
3695713 Traffic and vehicle offences2024–25Adjudicated outcomes(d)
760114 Offences against justice procedures and orders(b)2024–25Adjudicated outcomes(d)
32715 Offences against government2024–25Adjudicated outcomes(d)
101816 Environmental offences2024–25Adjudicated outcomes(d)
230517 Miscellaneous offences2024–25Adjudicated outcomes(d)
76162Total(c)2024–25Adjudicated outcomes(d)
001 Homicide(a)2024–25Acquitted
2902 Assault2024–25Acquitted
1203 Sexual offences2024–25Acquitted
1604 Harm or endanger persons2024–25Acquitted
005 Robbery, blackmail, and extortion2024–25Acquitted
306 Burglary2024–25Acquitted
1507 Theft2024–25Acquitted
508 Fraud and related offences2024–25Acquitted
1209 Drug offences2024–25Acquitted
010 Weapons and explosives offences2024–25Acquitted
1011 Property damage2024–25Acquitted
412 Public order, health, and safety offences2024–25Acquitted

Get the data

Open in Query with this immutable dataset version and a starter SQL query.

Copy-paste a stable URL

import pandas as pd

df = pd.read_csv("https://data.tidybank.net/data/abs/criminal-courts-australia/2024-25/table-31/tidy.csv")

Schema and semantics

Column Type Unit Semantic role Join key Distinct / range
row number attribute No
col number attribute No
address string attribute No
.value number measure No
principal_offence string dimension No
principal_offence_source string attribute No
year string time Yes
year_source string attribute No
outcome string dimension No
outcome_source string attribute No

How it was tidied

Quality checks

CheckStatusDetail
recipe-validation pass
execution-warnings warn AMBIGUOUS_HEADER: 342, UNUSED_HEADER: 3
non-empty-output pass
header-name-uniqueness pass

Generated by seeded ; pipeline version 0.1.0.

Open in Workspace

Coverage and lineage

Release position
1 of 1
Retrieved
2026-07-17T12:29:54.070Z
Availability
unchecked
Workbook checksum
sha256:72ec681f739e101be45b1d7bb722e0f77af35de35e01af0863f0014491f720e4

Source: https://github.com/ianmoran11/tidycell/commit/bae39c514e173be8a5b7f80ccc0fc5f3a3b54402#tidycell-path=abs-spreadsheets%2Fpeople%2Fcrime-and-justice%2Fcriminal-courts-australia%2Flatest-release%2F5.%20Defendants%20finalised-%20Victoria%20-Tables%2027%20to%2032-.xlsx

Other approved releases