TidyBank

Tidy dataset

4. Defendants finalised, New South Wales (Tables 21 to 26) — Table 24

A tidy Criminal Courts, Australia table with 304 rows. It reports recorded values by principal offence, period and outcome category.

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 304 rows
11401 Homicide2024–25Adjudicated outcomes(b)Method of finalisation
39202 Assault2024–25Adjudicated outcomes(b)Method of finalisation
83403 Sexual offences2024–25Adjudicated outcomes(b)Method of finalisation
25205 Robbery, blackmail, and extortion2024–25Adjudicated outcomes(b)Method of finalisation
35706 Burglary2024–25Adjudicated outcomes(b)Method of finalisation
8908 Fraud and related offences2024–25Adjudicated outcomes(b)Method of finalisation
47309 Drug offences2024–25Adjudicated outcomes(b)Method of finalisation
3060Total(a)2024–25Adjudicated outcomes(b)Method of finalisation
2301 Homicide2024–25AcquittedMethod of finalisation
4402 Assault2024–25AcquittedMethod of finalisation
18503 Sexual offences2024–25AcquittedMethod of finalisation
705 Robbery, blackmail, and extortion2024–25AcquittedMethod of finalisation
706 Burglary2024–25AcquittedMethod of finalisation
508 Fraud and related offences2024–25AcquittedMethod of finalisation
709 Drug offences2024–25AcquittedMethod of finalisation
285Total(a)2024–25AcquittedMethod of finalisation
8901 Homicide2024–25Guilty outcome(c)Method of finalisation
34802 Assault2024–25Guilty outcome(c)Method of finalisation
65103 Sexual offences2024–25Guilty outcome(c)Method of finalisation
24805 Robbery, blackmail, and extortion2024–25Guilty outcome(c)Method of finalisation
34706 Burglary2024–25Guilty outcome(c)Method of finalisation
8408 Fraud and related offences2024–25Guilty outcome(c)Method of finalisation
46709 Drug offences2024–25Guilty outcome(c)Method of finalisation
2775Total(a)2024–25Guilty outcome(c)Method of finalisation
5901 Homicide2024–25Guilty plea by defendantMethod of finalisation
31602 Assault2024–25Guilty plea by defendantMethod of finalisation
44003 Sexual offences2024–25Guilty plea by defendantMethod of finalisation
22805 Robbery, blackmail, and extortion2024–25Guilty plea by defendantMethod of finalisation
32706 Burglary2024–25Guilty plea by defendantMethod of finalisation
7108 Fraud and related offences2024–25Guilty plea by defendantMethod of finalisation

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-24/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 string — measure No —
principal_offence string — dimension No —
principal_offence_source string — attribute No —
period string — time Yes —
period_source string — attribute No —
outcome_category string — dimension No —
outcome_category_source string — attribute No —
outcome_section string — dimension No —
outcome_section_source string — attribute No —

How it was tidied

Quality checks

CheckStatusDetail
recipe-validation pass —
execution-warnings warn AMBIGUOUS_HEADER: 152
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:0440622e77f1a7c463f1a593b2e7e0848802c7da92e165a96262162f5fa63b1b

Source: https://github.com/ianmoran11/tidycell/commit/bae39c514e173be8a5b7f80ccc0fc5f3a3b54402#tidycell-path=abs-spreadsheets%2Fpeople%2Fcrime-and-justice%2Fcriminal-courts-australia%2Flatest-release%2F4.%20Defendants%20finalised-%20New%20South%20Wales%20-Tables%2021%20to%2026-.xlsx

Other approved releases