Australian Taxation Data - Individuals Table 14C (CSV)

Name: Australian Taxation Data - Individuals Table 14C (CSV)
Creator: ATO
License: Creative Commons Attribution 2.5 Australia

Australian Taxation Data - Individuals Table 14C (CSV) contains fact observations from the Australian Taxation Office taxation-statistics collection. Each row is one published record from the source file; the published table has 23716 rows and covers income years 2014-15 through 2015-16. The source format is CSV. Values are passed through from the source, so workbook-extracted tables may include header, label, and measure cells alongside numeric observations.

ato-taxation-statistics--individuals-table-14c-csv·53 columns·4.3 MB·Creative Commons Attribution 2.5 Australia·updated 1mo ago

Source: ATO · connector code

Schema

occupation	VARCHAR
work_related_expense	VARCHAR
size_of_expense_claimed	VARCHAR
male_no	VARCHAR
male	VARCHAR
female_no	VARCHAR
female	VARCHAR
total_no	VARCHAR
total	VARCHAR
income_year	VARCHAR
income_year_1	VARCHAR
occupation_unit_group	VARCHAR
gender	VARCHAR
taxable_income_ranges_tax_brackets	VARCHAR
number_of_individuals_no	VARCHAR
salary_or_wages_no	VARCHAR
salary_or_wages	VARCHAR
total_income_or_loss_no	VARCHAR
total_income_or_loss	VARCHAR
total_work_related_car_expenses_no	VARCHAR
total_work_related_car_expenses	VARCHAR
work_related_travel_expenses_no	VARCHAR
work_related_travel_expenses	VARCHAR
total_work_related_uniform_clothing_expenses_no	VARCHAR
total_work_related_uniform_clothing_expenses	VARCHAR
total_work_related_self_education_expenses_no	VARCHAR
total_work_related_self_education_expenses	VARCHAR
other_work_related_expenses_no	VARCHAR
other_work_related_expenses	VARCHAR
gifts_or_donations_no	VARCHAR
gifts_or_donations	VARCHAR
cost_of_managing_tax_affairs_no	VARCHAR
cost_of_managing_tax_affairs	VARCHAR
total_deductions_no	VARCHAR
total_deductions	VARCHAR
capital_gains_net_capital_gain_no	VARCHAR
capital_gains_net_capital_gain	VARCHAR
net_rent_profit_no	VARCHAR
net_rent_profit	VARCHAR
net_rent_loss_no	VARCHAR
net_rent_loss	VARCHAR
net_rent_no	VARCHAR
net_rent	VARCHAR
total_business_income_no	VARCHAR
total_business_income	VARCHAR
total_business_expenses_no	VARCHAR
total_business_expenses	VARCHAR
net_income_or_loss_from_business_no	VARCHAR
net_income_or_loss_from_business	VARCHAR
taxable_income_or_loss_no	VARCHAR
taxable_income_or_loss	VARCHAR
net_tax_no	VARCHAR
net_tax	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 \"ato-taxation-statistics--individuals-table-14c-csv\" 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.