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