Tidy dataset

2. Defendants with a guilty outcome, Australia (Tables 8 to 15) — Table 13

A tidy Criminal Courts, Australia table with 270 rows. It reports recorded values by principal sentence, year and sex.

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 270 rows
62Custody in a correctional institution2024–25Males10–14 years
62Intensive penalty in the community2024–25Males10–14 years
41Fully suspended sentence of imprisonment2024–25Males10–14 years
81Community service / work2024–25Males10–14 years
434Moderate penalty in the community2024–25Males10–14 years
6Fines2024–25Males10–14 years
194Good behaviour (incl. bonds)2024–25Males10–14 years
1198Nominal and other penalties2024–25Males10–14 years
2071Total(a)2024–25Males10–14 years
877Custody in a correctional institution2024–25Males15–19 years
395Intensive penalty in the community2024–25Males15–19 years
257Fully suspended sentence of imprisonment2024–25Males15–19 years
406Community service / work2024–25Males15–19 years
2263Moderate penalty in the community2024–25Males15–19 years
434Fines2024–25Males15–19 years
2098Good behaviour (incl. bonds)2024–25Males15–19 years
5178Nominal and other penalties2024–25Males15–19 years
11952Total(a)2024–25Males15–19 years
4Custody in a correctional institution2024–25Males20–24 years
3Intensive penalty in the community2024–25Males20–24 years
3Fully suspended sentence of imprisonment2024–25Males20–24 years
3Community service / work2024–25Males20–24 years
8Moderate penalty in the community2024–25Males20–24 years
3Fines2024–25Males20–24 years
19Good behaviour (incl. bonds)2024–25Males20–24 years
30Nominal and other penalties2024–25Males20–24 years
80Total(a)2024–25Males20–24 years
7Custody in a correctional institution2024–25Males25 years and over
3Intensive penalty in the community2024–25Males25 years and over
0Fully suspended sentence of imprisonment2024–25Males25 years and over

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-13/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_sentence string dimension No
principal_sentence_source string attribute No
year string time Yes
year_source string attribute No
sex string dimension Yes
sex_source string attribute No
age string dimension Yes
age_source string attribute No

How it was tidied

Quality checks

CheckStatusDetail
recipe-validation pass
execution-warnings warn AMBIGUOUS_HEADER: 135
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:8366a0e8ffd99372928686440ba026115b90be081f1b082799bbc70a5b9742cf

Source: https://github.com/ianmoran11/tidycell/commit/bae39c514e173be8a5b7f80ccc0fc5f3a3b54402#tidycell-path=abs-spreadsheets%2Fpeople%2Fcrime-and-justice%2Fcriminal-courts-australia%2Flatest-release%2F2.%20Defendants%20with%20a%20guilty%20outcome-%20Australia%20-Tables%208%20to%2015-.xlsx

Other approved releases