Australian Taxation Data - Individuals Table 17 (CSV)

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

Australian Taxation Data - Individuals Table 17 (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 94 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-17-csv·190 columns·130 KB·Creative Commons Attribution 2.5 Australia·updated 2mo ago

Source: ATO · connector code

Schema

entity_size	VARCHAR
broad_industry	VARCHAR
number_of_individuals	VARCHAR
taxable_income_or_loss_no	VARCHAR
taxable_income_or_loss	VARCHAR
gross_tax_no	VARCHAR
gross_tax	VARCHAR
medicare_levy_no	VARCHAR
medicare_levy	VARCHAR
low_income_tax_offset_no	VARCHAR
low_income_tax_offset	VARCHAR
net_tax_no	VARCHAR
net_tax	VARCHAR
estimated_business_net_tax_no	VARCHAR
estimated_business_net_tax	VARCHAR
salary_or_wages_no	VARCHAR
salary_or_wages	VARCHAR
gross_interest_no	VARCHAR
gross_interest	VARCHAR
dividends_unfranked_amount_no	VARCHAR
dividends_unfranked_amount	VARCHAR
dividends_franked_amount_no	VARCHAR
dividends_franked_amount	VARCHAR
dividends_franking_credit_no	VARCHAR
dividends_franking_credit	VARCHAR
total_income_or_loss_no	VARCHAR
total_income_or_loss	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
net_rent_no	VARCHAR
net_rent	VARCHAR
personal_superannuation_contributions_no	VARCHAR
personal_superannuation_contributions	VARCHAR
total_gross_payments_where_australian_business_number_not_quoted_no	VARCHAR
total_gross_payments_where_australian_business_number_not_quoted	VARCHAR
total_gross_payments_voluntary_agreement_no	VARCHAR
total_gross_payments_voluntary_agreement	VARCHAR
total_gross_payments_labour_hire_or_other_specified_payments_no	VARCHAR
total_gross_payments_labour_hire_or_other_specified_payments	VARCHAR
total_assessable_government_industry_payments_no	VARCHAR
total_assessable_government_industry_payments	VARCHAR
total_other_business_income_no	VARCHAR
total_other_business_income	VARCHAR
total_business_income_no	VARCHAR
total_business_income	VARCHAR
opening_stock_no	VARCHAR
opening_stock	VARCHAR
purchases_and_other_costs_no	VARCHAR
purchases_and_other_costs	VARCHAR
closing_stock_no	VARCHAR
closing_stock	VARCHAR
cost_of_sales_no	VARCHAR
cost_of_sales	VARCHAR
contractor_subcontractor_and_commission_expenses_no	VARCHAR
contractor_subcontractor_and_commission_expenses	VARCHAR
superannuation_expenses_no	VARCHAR
superannuation_expenses	VARCHAR
bad_debts_no	VARCHAR
bad_debts	VARCHAR
lease_expenses_no	VARCHAR
lease_expenses	VARCHAR
rent_expenses_no	VARCHAR
rent_expenses	VARCHAR
interest_expenses_within_australia_no	VARCHAR
interest_expenses_within_australia	VARCHAR
interest_expenses_overseas_no	VARCHAR
interest_expenses_overseas	VARCHAR
depreciation_expenses_no	VARCHAR
depreciation_expenses	VARCHAR
motor_vehicle_expenses_no	VARCHAR
motor_vehicle_expenses	VARCHAR
repairs_and_maintenance_expenses_no	VARCHAR
repairs_and_maintenance_expenses	VARCHAR
all_other_expenses_no	VARCHAR
all_other_expenses	VARCHAR
total_business_expenses_no	VARCHAR
total_business_expenses	VARCHAR
total_net_income_or_loss_from_business_this_year_no	VARCHAR
total_net_income_or_loss_from_business_this_year	VARCHAR
total_deferred_non_commercial_business_losses_from_a_prior_year_no	VARCHAR
total_deferred_non_commercial_business_losses_from_a_prior_year	VARCHAR
net_income_or_loss_from_business_no	VARCHAR
net_income_or_loss_from_business	VARCHAR
people_with_private_health_insurance_no	VARCHAR
income_year	VARCHAR
taxable_income_or_loss_no_1	VARCHAR
taxable_income_or_loss_1	VARCHAR
tax_on_taxable_income_no	VARCHAR
tax_on_taxable_income	VARCHAR
medicare_levy_no_1	VARCHAR
medicare_levy_1	VARCHAR
medicare_levy_surcharge_no	VARCHAR
medicare_levy_surcharge	VARCHAR
total_medicare_levy_liability_no	VARCHAR
total_medicare_levy_liability	VARCHAR
low_income_tax_offset_no_1	VARCHAR
low_income_tax_offset_1	VARCHAR
net_tax_no_1	VARCHAR
net_tax_1	VARCHAR
estimated_business_net_tax_no_1	VARCHAR
estimated_business_net_tax_1	VARCHAR
salary_or_wages_no_1	VARCHAR
salary_or_wages_1	VARCHAR
gross_interest_no_1	VARCHAR
gross_interest_1	VARCHAR
dividends_unfranked_amount_no_1	VARCHAR
dividends_unfranked_amount_1	VARCHAR
dividends_franked_amount_no_1	VARCHAR
dividends_franked_amount_1	VARCHAR
dividends_franking_credit_no_1	VARCHAR
dividends_franking_credit_1	VARCHAR
total_income_or_loss_no_1	VARCHAR
total_income_or_loss_1	VARCHAR
total_work_related_expenses_no	VARCHAR
total_work_related_expenses	VARCHAR
gifts_or_donations_no_1	VARCHAR
gifts_or_donations_1	VARCHAR
cost_of_managing_tax_affairs_no_1	VARCHAR
cost_of_managing_tax_affairs_1	VARCHAR
total_deductions_no_1	VARCHAR
total_deductions_1	VARCHAR
net_rent_no_1	VARCHAR
net_rent_1	VARCHAR
personal_superannuation_contributions_no_1	VARCHAR
personal_superannuation_contributions_1	VARCHAR
total_gross_payments_where_australian_business_number_not_quoted_no_1	VARCHAR
total_gross_payments_where_australian_business_number_not_quoted_1	VARCHAR
total_gross_payments_voluntary_agreement_no_1	VARCHAR
total_gross_payments_voluntary_agreement_1	VARCHAR
total_gross_payments_labour_hire_or_other_specified_payments_no_1	VARCHAR
total_gross_payments_labour_hire_or_other_specified_payments_1	VARCHAR
total_assessable_government_industry_payments_no_1	VARCHAR
total_assessable_government_industry_payments_1	VARCHAR
total_other_business_income_no_1	VARCHAR
total_other_business_income_1	VARCHAR
total_business_income_no_1	VARCHAR
total_business_income_1	VARCHAR
opening_stock_no_1	VARCHAR
opening_stock_1	VARCHAR
purchases_and_other_costs_no_1	VARCHAR
purchases_and_other_costs_1	VARCHAR
closing_stock_no_1	VARCHAR
closing_stock_1	VARCHAR
cost_of_sales_no_1	VARCHAR
cost_of_sales_1	VARCHAR
contractor_subcontractor_and_commission_expenses_no_1	VARCHAR
contractor_subcontractor_and_commission_expenses_1	VARCHAR
superannuation_expenses_no_1	VARCHAR
superannuation_expenses_1	VARCHAR
bad_debts_no_1	VARCHAR
bad_debts_1	VARCHAR
lease_expenses_no_1	VARCHAR
lease_expenses_1	VARCHAR
rent_expenses_no_1	VARCHAR
rent_expenses_1	VARCHAR
interest_expenses_within_australia_no_1	VARCHAR
interest_expenses_within_australia_1	VARCHAR
interest_expenses_overseas_no_1	VARCHAR
interest_expenses_overseas_1	VARCHAR
depreciation_expenses_no_1	VARCHAR
depreciation_expenses_1	VARCHAR
motor_vehicle_expenses_no_1	VARCHAR
motor_vehicle_expenses_1	VARCHAR
repairs_and_maintenance_expenses_no_1	VARCHAR
repairs_and_maintenance_expenses_1	VARCHAR
all_other_expenses_no_1	VARCHAR
all_other_expenses_1	VARCHAR
total_business_expenses_no_1	VARCHAR
total_business_expenses_1	VARCHAR
total_net_income_or_loss_from_business_this_year_no_1	VARCHAR
total_net_income_or_loss_from_business_this_year_1	VARCHAR
total_deferred_non_commercial_business_losses_from_a_prior_year_no_1	VARCHAR
total_deferred_non_commercial_business_losses_from_a_prior_year_1	VARCHAR
net_income_or_loss_from_business_no_1	VARCHAR
net_income_or_loss_from_business_1	VARCHAR
people_with_private_health_insurance_no_1	VARCHAR
small_business_income_tax_offset_no	VARCHAR
small_business_income_tax_offset	VARCHAR
partnership_share_of_net_small_business_income_less_deductions_attributable_to_that_share_no	VARCHAR
partnership_share_of_net_small_business_income_less_deductions_attributable_to_that_share	VARCHAR
trust_share_of_net_small_business_income_less_deductions_attributable_to_that_share_no	VARCHAR
trust_share_of_net_small_business_income_less_deductions_attributable_to_that_share	VARCHAR
net_small_business_income_no	VARCHAR
net_small_business_income	VARCHAR
total_small_business_income_no	VARCHAR
total_small_business_income	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-17-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.