Tidy dataset
ACMIDDC01 — Table 2
A tidy Permanent Migrants in Australia table with 130 rows. It reports recorded values by visa stream, area and state.
- Status
- approved
- Publisher
- Australian Bureau of Statistics
- Release
- 2021
- License
- CC-BY-4.0
Data preview
| 481569 | Skilled | no. | Greater Sydney | New South Wales |
| 312781 | Family | no. | Greater Sydney | New South Wales |
| 86398 | Humanitarian | no. | Greater Sydney | New South Wales |
| 396 | Other permanent | no. | Greater Sydney | New South Wales |
| 881146 | Total | no. | Greater Sydney | New South Wales |
| 55313 | Skilled | no. | Rest of New South Wales | New South Wales |
| 41779 | Family | no. | Rest of New South Wales | New South Wales |
| 9353 | Humanitarian | no. | Rest of New South Wales | New South Wales |
| 49 | Other permanent | no. | Rest of New South Wales | New South Wales |
| 106498 | Total | no. | Rest of New South Wales | New South Wales |
| 537121 | Skilled | no. | Total (a) | New South Wales |
| 354728 | Family | no. | Total (a) | New South Wales |
| 95797 | Humanitarian | no. | Total (a) | New South Wales |
| 448 | Other permanent | no. | Total (a) | New South Wales |
| 988099 | Total | no. | Total (a) | New South Wales |
| 465129 | Skilled | no. | Greater Melbourne | Victoria |
| 249190 | Family | no. | Greater Melbourne | Victoria |
| 86426 | Humanitarian | no. | Greater Melbourne | Victoria |
| 255 | Other permanent | no. | Greater Melbourne | Victoria |
| 800996 | Total | no. | Greater Melbourne | Victoria |
| 31869 | Skilled | no. | Rest of Victoria | Victoria |
| 22875 | Family | no. | Rest of Victoria | Victoria |
| 7827 | Humanitarian | no. | Rest of Victoria | Victoria |
| 60 | Other permanent | no. | Rest of Victoria | Victoria |
| 62625 | Total | no. | Rest of Victoria | Victoria |
| 497157 | Skilled | no. | Total (a) | Victoria |
| 272262 | Family | no. | Total (a) | Victoria |
| 94342 | Humanitarian | no. | Total (a) | Victoria |
| 305 | Other permanent | no. | Total (a) | Victoria |
| 864067 | Total | no. | Total (a) | Victoria |
Get the data
CSV
10.7 KiB
Download tidy.csvJSON
39.7 KiB
Download tidy.jsonPARQUET
3.8 KiB
Download tidy.parquetOpen 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/permanent-migrants-australia/2021/table-2/tidy.csv")data <- read.csv("https://data.tidybank.net/data/abs/permanent-migrants-australia/2021/table-2/tidy.csv")SELECT *
FROM read_parquet('https://data.tidybank.net/data/abs/permanent-migrants-australia/2021/table-2/tidy.parquet');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 | — |
| visa_stream | string | — | dimension | No | — |
| visa_stream_source | string | — | attribute | No | — |
| unit | string | — | attribute | No | — |
| unit_source | string | — | attribute | No | — |
| area | string | — | dimension | No | — |
| area_source | string | — | attribute | No | — |
| state | string | — | geography | Yes | — |
| state_source | string | — | attribute | No | — |
How it was tidied
Source overlay
See value and header roles on the original worksheet grid.
Open overlay evidenceReconstructed table
Compare the tidy output with a human-readable reconstruction.
Open reconstructed evidenceRecipe
The auditable RecipeV01 transformation used for this asset.
Download recipe.jsonQuality checks
| Check | Status | Detail |
|---|---|---|
| recipe-validation | pass | — |
| execution-warnings | pass | — |
| non-empty-output | pass | — |
| header-name-uniqueness | pass | — |
Generated by seeded ; pipeline version 0.1.0.
Coverage and lineage
- Release position
- 1 of 1
- Retrieved
- 2026-07-17T12:29:54.070Z
- Availability
- unchecked
- Workbook checksum
- sha256:9b84efd4619c52d5c5c1d331d643b935251f15a8340cd2347062ac47677fbe64
Other approved releases
Related tables
No other approved tables are published in this release.
Report a problem
Send a report only when you choose Submit. TidyBank uses no analytics or advertising cookies.
- Asset ID
- abs/permanent-migrants-australia/2021/table-2
- Release
- 2021
Prefer to verify or report manually? View the recorded source or open a public GitHub issue.