Census 2021, G02 Selected medians and averages, Main Statistical Areas Level 2 and up (SA2+)

One row is an SDMX observation for this ABS dataflow, with OBS_VALUE broken down by the table's dimensions. Selected medians and averages data for Main Statistical Areas Level 2 and up (SA2+), 2021 Census. Median age of persons excludes overseas visitors. Median total personal income is applicable to persons aged 15 years and over. Median total family income is applicable to families in family households. It excludes families where at least one member aged 15 years and over did not state an income and families where at least one member aged 15 years and over was temporarily absent on Census Night. Median total household income is applicable to occupied private dwellings. It excludes households where at least one member aged 15 years and over did not state an income and households where at least one member aged 15 years and over was temporarily absent on Census Night. It excludes 'Visitors only' and 'Other non-classifiable' households. Median mortgage repayment is applicable to occupied private dwellings being purchased and includes dwellings being purchased under a shared equity scheme. It excludes 'Visitors only' and 'Other non-classifiable' households. Median rent is applicable to occupied private dwellings being rented. It excludes 'Visitors only' and 'Other non-classifiable' households. For 2021, median rent calculations exclude dwellings being 'Occupied rent-free' and will not be comparable to 2016 Census data. Average number of persons per bedroom is applicable to occupied private dwellings. It excludes 'Visitors only' and 'Other non-classifiable' households. Average household size is applicable to number of persons usually resident in occupied private dwellings. It includes partners, children, and co-tenants (in group households) who were temporarily absent on Census Night. A maximum of three temporary absentees can be counted in each household. It excludes 'Visitors only' and 'Other non-classifiable' households. Profiled coverage: time coverage 2021 to 2021. Current profile has 23,632 rows. Dimension values are ABS SDMX codes; use the source code lists for full labels where a label column is not present.

australian-bureau-of-statistics-c21-g02-sa2·7 columns·72 KB·Creative Commons Attribution 4.0 International·updated 1mo ago

Schema

dataflowVARCHAR
medavgBIGINT
regionVARCHAR
region_typeVARCHAR
stateVARCHAR
time_periodBIGINT
obs_valueDOUBLE

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 \"australian-bureau-of-statistics-c21-g02-sa2\" 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.