TidyBank

Tidy dataset

1. Defendants finalised, Australia (Tables 1 to 7) — Table 1

A tidy Criminal Courts, Australia table with 4,425 rows. It reports recorded values by year, court level and characteristic group.

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 4,425 rows
defendants_finalised_all_courts4405092010–11(a)All CourtsSexMales
defendants_finalised_all_courts4299102011–12(a)All CourtsSexMales
defendants_finalised_all_courts4218722012–13(a)All CourtsSexMales
defendants_finalised_all_courts4310672013–14(a)All CourtsSexMales
defendants_finalised_all_courts4362732014–15(a)All CourtsSexMales
defendants_finalised_all_courts4443142015–16(a)All CourtsSexMales
defendants_finalised_all_courts4418362016–17(a)All CourtsSexMales
defendants_finalised_all_courts4302012017–18(a)All CourtsSexMales
defendants_finalised_all_courts4189182018–19(a)(b)All CourtsSexMales
defendants_finalised_all_courts3525352019–20(a)All CourtsSexMales
defendants_finalised_all_courts3827152020–21(a)All CourtsSexMales
defendants_finalised_all_courts3670942021–22(a)All CourtsSexMales
defendants_finalised_all_courts3996482022–23(a)All CourtsSexMales
defendants_finalised_all_courts3840972023–24All CourtsSexMales
defendants_finalised_all_courts3911152024–25All CourtsSexMales
defendants_finalised_all_courts1232092010–11(a)All CourtsSexFemales
defendants_finalised_all_courts1212672011–12(a)All CourtsSexFemales
defendants_finalised_all_courts1195182012–13(a)All CourtsSexFemales
defendants_finalised_all_courts1257032013–14(a)All CourtsSexFemales
defendants_finalised_all_courts1295072014–15(a)All CourtsSexFemales
defendants_finalised_all_courts1358182015–16(a)All CourtsSexFemales
defendants_finalised_all_courts1398632016–17(a)All CourtsSexFemales
defendants_finalised_all_courts1356322017–18(a)All CourtsSexFemales
defendants_finalised_all_courts1321482018–19(a)(b)All CourtsSexFemales
defendants_finalised_all_courts1107892019–20(a)All CourtsSexFemales
defendants_finalised_all_courts1199722020–21(a)All CourtsSexFemales
defendants_finalised_all_courts1142612021–22(a)All CourtsSexFemales
defendants_finalised_all_courts1260842022–23(a)All CourtsSexFemales
defendants_finalised_all_courts1228962023–24All CourtsSexFemales
defendants_finalised_all_courts1218602024–25All CourtsSexFemales

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-1/tidy.csv")

Schema and semantics

Column Type Unit Semantic role Join key Distinct / range
table string — attribute No —
row number — attribute No —
col number — attribute No —
address string — attribute No —
.value string — measure No —
year string — time Yes —
year_source string — attribute No —
court_level string — dimension No —
court_level_source string — attribute No —
characteristic_group string — dimension No —
characteristic_group_source string — attribute No —
summary_characteristic string — attribute No —
summary_characteristic_source string — attribute No —

How it was tidied

Quality checks

CheckStatusDetail
recipe-validation pass —
execution-warnings warn UNUSED_HEADER: 12
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:686d5091f9fb9397827d4f11cc9a743d26b0156f6df3eb4f22ff44b1de268ecc

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

Other approved releases