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