Census 2021, G01 Selected person characteristics by sex, 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 person characteristics by sex data for Main Statistical Areas Level 2 and up (SA2+), 2021 Census, Count of persons. This table is based on place of usual residence, except for counts by dwelling type which are based on place of enumeration and exclude overseas visitors. Eduction institution comprises 'Preschool', 'Primary' (including Government, Catholic, Other non-Government, Primary not further defined), 'Secondary' (including Government, Catholic, Other non-Government, Secondary not further defined) and 'Tertiary' (including vocational education (including TAFE and private training providers), university or other higher education, Tertiary not further defined). Excludes persons who did not state which type of education institution they were attending. Highest year of school completed is applicable to persons aged 15 years and over. Please note that there are small random adjustments made to all cell values to protect the confidentiality of data. These adjustments may cause the sum of rows or columns to differ by small amounts from table totals. Profiled coverage: time coverage 2021 to 2021. Current profile has 321,732 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-g01-sa2·8 columns·738 KB·Creative Commons Attribution 4.0 International·updated 1mo ago

Schema

dataflowVARCHAR
sexpBIGINT
pcharVARCHAR
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-g01-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.