Australia - ERP by LGA (2022), Age and Sex, 2001 to 2022

One row is an SDMX observation for this ABS dataflow, with OBS_VALUE broken down by the table's dimensions. Estimated Resident Population (ERP) is the official measure of the Australian population. ERP for sub-state regions (including SA2s and LGAs) is published annually, with a reference date of 30 June. Unit of measure: Persons. Geographic coverage: LGA2021. Catalogue number: 3218.0 Profiled coverage: time coverage 2001 to 2022; geographic coverage LGA2021. Current profile has 698,478 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-abs-annual-erp-lga2022·12 columns·1.5 MB·Creative Commons Attribution 4.0 International·updated 1mo ago
Australian Bureau of Statistics

Source: Australian Bureau of Statistics · connector code

Schema

dataflowVARCHAR
measureVARCHAR
sex_absBIGINT
ageVARCHAR
lga_2022VARCHAR
region_typeVARCHAR
frequencyVARCHAR
time_periodBIGINT
obs_valueDOUBLE
unit_measureVARCHAR
obs_statusVARCHAR
obs_commentVARCHAR

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-abs-annual-erp-lga2022\" 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.