TidyBank

Tidy dataset

310102_1 — Data1

A tidy National, state and territory population table with 6,221 rows. It reports recorded values by quarter, series title and collection month.

Status
approved
Publisher
Australian Bureau of Statistics
Release
2025-sep-quarter
License
CC-BY-4.0

View the recorded source

Data preview

Showing the first 30 of 6,221 rows
115161981-06-01T00:00:00.000ZNatural Increase ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060788C
92811981-06-01T00:00:00.000ZNet Overseas Migration ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060789F
-63301981-06-01T00:00:00.000ZNet Interstate Migration ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060790R
73021981-06-01T00:00:00.000ZNatural Increase ; Victoria ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060792V
55331981-06-01T00:00:00.000ZNet Overseas Migration ; Victoria ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060793W
-33301981-06-01T00:00:00.000ZNet Interstate Migration ; Victoria ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060794X
61911981-06-01T00:00:00.000ZNatural Increase ; Queensland ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060796C
46301981-06-01T00:00:00.000ZNet Overseas Migration ; Queensland ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060797F
85581981-06-01T00:00:00.000ZNet Interstate Migration ; Queensland ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060798J
24741981-06-01T00:00:00.000ZNatural Increase ; South Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060800J
13011981-06-01T00:00:00.000ZNet Overseas Migration ; South Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060801K
-16751981-06-01T00:00:00.000ZNet Interstate Migration ; South Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060802L
35791981-06-01T00:00:00.000ZNatural Increase ; Western Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060804T
37761981-06-01T00:00:00.000ZNet Overseas Migration ; Western Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060805V
6801981-06-01T00:00:00.000ZNet Interstate Migration ; Western Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060806W
9621981-06-01T00:00:00.000ZNatural Increase ; Tasmania ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060808A
1941981-06-01T00:00:00.000ZNet Overseas Migration ; Tasmania ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060809C
-2741981-06-01T00:00:00.000ZNet Interstate Migration ; Tasmania ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060810L
7331981-06-01T00:00:00.000ZNatural Increase ; Northern Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060812T
4001981-06-01T00:00:00.000ZNet Overseas Migration ; Northern Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060813V
18061981-06-01T00:00:00.000ZNet Interstate Migration ; Northern Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060814W
8471981-06-01T00:00:00.000ZNatural Increase ; Australian Capital Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060816A
-1311981-06-01T00:00:00.000ZNet Overseas Migration ; Australian Capital Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060817C
5651981-06-01T00:00:00.000ZNet Interstate Migration ; Australian Capital Territory ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060818F
336041981-06-01T00:00:00.000ZNatural Increase ; Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060784V
255751981-06-01T00:00:00.000ZNet Overseas Migration ; Australia ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060785W
95591981-09-01T00:00:00.000ZNatural Increase ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060788C
132841981-09-01T00:00:00.000ZNet Overseas Migration ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060789F
-77681981-09-01T00:00:00.000ZNet Interstate Migration ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060790R
145661981-09-01T00:00:00.000ZChange Over Previous Quarter ; New South Wales ;NumberOriginalFLOWQuarter31981-06-01T00:00:00.000Z2025-09-01T00:00:00.000Z178A2060791T

Get the data

Open in Query with this immutable dataset version and a starter SQL query.

Copy-paste a stable URL

import pandas as pd

df = pd.read_csv("https://data.tidybank.net/data/abs/national-state-and-territory-population/2025-sep-quarter/data1/tidy.csv")

Schema and semantics

Column Type Unit Semantic role Join key Distinct / range
row number — attribute No —
col number — attribute No —
address string — attribute No —
.value number — measure No —
quarter string — time Yes —
quarter_source string — attribute No —
series_title string — dimension No —
series_title_source string — attribute No —
unit string — attribute No —
unit_source string — attribute No —
series_type string — attribute No —
series_type_source string — attribute No —
data_type string — attribute No —
data_type_source string — attribute No —
frequency string — attribute No —
frequency_source string — attribute No —
collection_month number — time Yes —
collection_month_source string — attribute No —
series_start string — attribute No —
series_start_source string — attribute No —
series_end string — attribute No —
series_end_source string — attribute No —
no_obs number — attribute No —
no_obs_source string — attribute No —
series_id string — dimension No —
series_id_source string — attribute No —

How it was tidied

Quality checks

CheckStatusDetail
recipe-validation pass —
execution-warnings pass —
non-empty-output pass —
header-name-uniqueness pass —

Generated by seeded ; pipeline version 0.1.0.

Open in Workspace

Coverage and lineage

Release position
1 of 1
Retrieved
2026-07-17T12:29:54.070Z
Availability
unchecked
Workbook checksum
sha256:fe414a87f72c9a90836269740166ad729530eed731a90828f00353f761ac8251

Source: https://github.com/ianmoran11/tidycell/commit/bae39c514e173be8a5b7f80ccc0fc5f3a3b54402#tidycell-path=abs-spreadsheets%2Fpeople%2Fpopulation%2Fnational-state-and-territory-population%2Flatest-release%2F310102.xlsx

Other approved releases

No other approved tables are published in this release.