Australian Taxation Data - Individuals Table 19B (CSV)

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

Australian Taxation Data - Individuals Table 19B (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 80 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-19b-csv·95 columns·65 KB·Creative Commons Attribution 2.5 Australia·updated 1mo ago

Source: ATO · connector code

Schema

income_year	VARCHAR
state_territory_of_rental_property1	VARCHAR
rental_property_schedules_no	VARCHAR
rental_income_no	VARCHAR
rental_income	VARCHAR
other_rental_income_no	VARCHAR
other_rental_income	VARCHAR
advertising_for_tenants_no	VARCHAR
advertising_for_tenants	VARCHAR
body_corporate_fees_no	VARCHAR
body_corporate_fees	VARCHAR
borrowing_expenses_no	VARCHAR
borrowing_expenses	VARCHAR
cleaning_expenses_no	VARCHAR
cleaning_expenses	VARCHAR
council_rates_no	VARCHAR
council_rates	VARCHAR
plant_depreciation_no	VARCHAR
plant_depreciation	VARCHAR
gardening_lawn_moving_expenses_no	VARCHAR
gardening_lawn_moving_expenses	VARCHAR
insurance_no	VARCHAR
insurance	VARCHAR
interest_on_loan_s_no	VARCHAR
interest_on_loan_s	VARCHAR
land_tax_no	VARCHAR
land_tax	VARCHAR
legal_fees_no	VARCHAR
legal_fees	VARCHAR
pest_control_no	VARCHAR
pest_control	VARCHAR
property_agent_fees_commission_no	VARCHAR
property_agent_fees_commission	VARCHAR
repairs_and_maintenance_no	VARCHAR
repairs_and_maintenance	VARCHAR
stationary_telephone_and_postage_no	VARCHAR
stationary_telephone_and_postage	VARCHAR
travel_expenses_no	VARCHAR
travel_expenses	VARCHAR
water_charges_no	VARCHAR
water_charges	VARCHAR
sundry_rental_expenses_no	VARCHAR
sundry_rental_expenses	VARCHAR
capital_works_deduction_no	VARCHAR
capital_works_deduction	VARCHAR
net_rental_income_no	VARCHAR
net_rental_income	VARCHAR
income_year_1	VARCHAR
state_territory_of_rental_property	VARCHAR
net_rent_position	VARCHAR
rental_property_schedules_no_1	VARCHAR
rental_income_no_1	VARCHAR
rental_income_1	VARCHAR
other_rental_income_no_1	VARCHAR
other_rental_income_1	VARCHAR
advertising_for_tenants_no_1	VARCHAR
advertising_for_tenants_1	VARCHAR
body_corporate_fees_no_1	VARCHAR
body_corporate_fees_1	VARCHAR
borrowing_expenses_no_1	VARCHAR
borrowing_expenses_1	VARCHAR
cleaning_expenses_no_1	VARCHAR
cleaning_expenses_1	VARCHAR
council_rates_no_1	VARCHAR
council_rates_1	VARCHAR
plant_depreciation_no_1	VARCHAR
plant_depreciation_1	VARCHAR
gardening_lawn_moving_expenses_no_1	VARCHAR
gardening_lawn_moving_expenses_1	VARCHAR
insurance_no_1	VARCHAR
insurance_1	VARCHAR
interest_on_loan_s_no_1	VARCHAR
interest_on_loan_s_1	VARCHAR
land_tax_no_1	VARCHAR
land_tax_1	VARCHAR
legal_fees_no_1	VARCHAR
legal_fees_1	VARCHAR
pest_control_no_1	VARCHAR
pest_control_1	VARCHAR
property_agent_fees_commission_no_1	VARCHAR
property_agent_fees_commission_1	VARCHAR
repairs_and_maintenance_no_1	VARCHAR
repairs_and_maintenance_1	VARCHAR
stationary_telephone_and_postage_no_1	VARCHAR
stationary_telephone_and_postage_1	VARCHAR
travel_expenses_no_1	VARCHAR
travel_expenses_1	VARCHAR
water_charges_no_1	VARCHAR
water_charges_1	VARCHAR
sundry_rental_expenses_no_1	VARCHAR
sundry_rental_expenses_1	VARCHAR
capital_works_deduction_no_1	VARCHAR
capital_works_deduction_1	VARCHAR
net_rental_income_no_1	VARCHAR
net_rental_income_1	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-19b-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.