Australian Taxation Data - 2019 20 annual overview tables

Australian Taxation Data - 2019 20 annual overview tables contains fact observations from the Australian Taxation Office self-managed-superannuation-funds collection. Each row is one workbook cell identified by source resource, sheet, row number, and column number; the published table has 33104 rows and covers income years 2015-16 through 2019-20. The source format is XLSX. Values are passed through from the source, so workbook-extracted tables may include header, label, and measure cells alongside numeric observations.

ato-self-managed-superannuation-funds--annual-overview-tables·9 columns·175 KB·Creative Commons Attribution 2.5 Australia·updated 1mo ago
ATO

Source: ATO · connector code

Schema

source_resource_idVARCHAR
source_resource_nameVARCHAR
source_formatVARCHAR
source_urlVARCHAR
income_yearVARCHAR
sheet_nameVARCHAR
row_numberINTEGER
column_numberINTEGER
valueVARCHAR

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 \"ato-self-managed-superannuation-funds--annual-overview-tables\" 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.