Australian National Accounts - State Final Demand

Name: Australian National Accounts - State Final Demand
Creator: Australian Bureau of Statistics
License: Creative Commons Attribution 4.0 International

One row is an SDMX observation for this ABS dataflow, with OBS_VALUE broken down by the table's dimensions. Quarterly estimates of state final demand (SFD) and component series, measured in chain volume measures. Includes household and government expenditure, private and public sector investment, and compensation of employees by state. Catalogue number 5206.0. Profiled coverage: time coverage 1983-Q3 to 2026-Q1. Current profile has 535,392 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-ana-sfd·13 columns·2.2 MB·Creative Commons Attribution 4.0 International·updated 19d ago

Source: Australian Bureau of Statistics · connector code

Schema

dataflow	VARCHAR
measure	VARCHAR
data_item	VARCHAR
sector	VARCHAR
tsest	BIGINT
region	BIGINT
freq	VARCHAR
time_period	VARCHAR
obs_value	DOUBLE
unit_measure	VARCHAR
unit_mult	BIGINT
obs_status	VARCHAR
obs_comment	VARCHAR

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-ana-sfd\" 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.