Youth Justice Detention - Average Nightly Population

Name: Youth Justice Detention - Average Nightly Population
Creator: AIHW
License: Creative Commons Attribution 4.0 International (CC BY 4.0)

One row per quarter, year, state or territory, age group, Indigenous status, legal status, and sex, with the average nightly youth detention population. Coverage runs from June quarter 2008 through September quarter 2015 in the profiled table, across nine state and national categories. The table includes total rows alongside disaggregated rows, so users should filter dimensions carefully before summing.

aihw-c7edfa08-7bc9-404d-8f2b-22bcd0425021·9 columns·36 KB·Creative Commons Attribution 4.0 International (CC BY 4.0)·updated 2mo ago

Source: AIHW · connector code

Schema

age_group	string
indigenous_status	string
legal_status	string
sex	string
state	string
quarter	string
quarter_short	string
year	int64
avg_nightly_pop	double

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"aihw-c7edfa08-7bc9-404d-8f2b-22bcd0425021\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.