Australian Taxation Data - Company Table 4 (CSV)

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

Australian Taxation Data - Company Table 4 (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 197 rows and covers income year 2014-15. 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--company-table-4-csv·156 columns·289 KB·Creative Commons Attribution 2.5 Australia·updated 2mo ago

Source: ATO · connector code

Schema

broad_industry	VARCHAR
fine_industry	VARCHAR
number_of_companies_no	VARCHAR
other_sales_of_goods_and_services_no	VARCHAR
other_sales_of_goods_and_services	VARCHAR
gross_distribution_from_partnerships_no	VARCHAR
gross_distribution_from_partnerships	VARCHAR
gross_distribution_from_trusts_no	VARCHAR
gross_distribution_from_trusts	VARCHAR
gross_interest_no	VARCHAR
gross_interest	VARCHAR
gross_rent_and_other_leasing_and_hiring_income_no	VARCHAR
gross_rent_and_other_leasing_and_hiring_income	VARCHAR
total_dividends_no	VARCHAR
total_dividends	VARCHAR
fringe_benefit_employee_contributions_no	VARCHAR
fringe_benefit_employee_contributions	VARCHAR
assessable_government_industry_payments_no	VARCHAR
assessable_government_industry_payments	VARCHAR
other_gross_income_no	VARCHAR
other_gross_income	VARCHAR
total_income_no	VARCHAR
total_income	VARCHAR
cost_of_sales_no	VARCHAR
cost_of_sales	VARCHAR
contractor_sub_contractor_and_commission_expenses_no	VARCHAR
contractor_sub_contractor_and_commission_expenses	VARCHAR
superannuation_expenses_no	VARCHAR
superannuation_expenses	VARCHAR
bad_debts_no	VARCHAR
bad_debts	VARCHAR
lease_expenses_within_australia_no	VARCHAR
lease_expenses_within_australia	VARCHAR
rent_expenses_no	VARCHAR
rent_expenses	VARCHAR
interest_expenses_within_australia_no	VARCHAR
interest_expenses_within_australia	VARCHAR
depreciation_expenses_no	VARCHAR
depreciation_expenses	VARCHAR
motor_vehicle_expenses_no	VARCHAR
motor_vehicle_expenses	VARCHAR
repairs_and_maintenance_no	VARCHAR
repairs_and_maintenance	VARCHAR
all_other_expenses_no	VARCHAR
all_other_expenses	VARCHAR
total_expenses_no	VARCHAR
total_expenses	VARCHAR
total_profit_or_loss_no	VARCHAR
total_profit_or_loss	VARCHAR
net_capital_gain_no	VARCHAR
net_capital_gain	VARCHAR
franking_credits_no	VARCHAR
franking_credits	VARCHAR
other_assessable_income_no	VARCHAR
other_assessable_income	VARCHAR
non_deductible_expenses_no	VARCHAR
non_deductible_expenses	VARCHAR
subtotal_no	VARCHAR
subtotal	VARCHAR
deduction_for_decline_in_value_of_depreciating_assets_no	VARCHAR
deduction_for_decline_in_value_of_depreciating_assets	VARCHAR
capital_works_deductions_no	VARCHAR
capital_works_deductions	VARCHAR
section_40_880_deduction_no	VARCHAR
section_40_880_deduction	VARCHAR
other_income_not_included_in_assessable_income_no	VARCHAR
other_income_not_included_in_assessable_income	VARCHAR
other_deductible_expenses_no	VARCHAR
other_deductible_expenses	VARCHAR
tax_losses_deducted_no	VARCHAR
tax_losses_deducted	VARCHAR
subtraction_items_subtotal_no	VARCHAR
subtraction_items_subtotal	VARCHAR
taxable_income_or_loss_no	VARCHAR
taxable_income_or_loss	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
trade_debtors_no	VARCHAR
trade_debtors	VARCHAR
all_current_assets_no	VARCHAR
all_current_assets	VARCHAR
total_assets_no	VARCHAR
total_assets	VARCHAR
trade_creditors_no	VARCHAR
trade_creditors	VARCHAR
all_current_liabilities_no	VARCHAR
all_current_liabilities	VARCHAR
total_liabilities_no	VARCHAR
total_liabilities	VARCHAR
total_debt_no	VARCHAR
total_debt	VARCHAR
franked_dividends_paid_no	VARCHAR
franked_dividends_paid	VARCHAR
franking_account_balance_no	VARCHAR
franking_account_balance	VARCHAR
excess_franking_offsets_no	VARCHAR
excess_franking_offsets	VARCHAR
loans_to_shareholders_and_their_associates_no	VARCHAR
loans_to_shareholders_and_their_associates	VARCHAR
total_salary_and_wage_expenses_no	VARCHAR
total_salary_and_wage_expenses	VARCHAR
payments_to_associated_persons_no	VARCHAR
payments_to_associated_persons	VARCHAR
gross_foreign_income_no	VARCHAR
gross_foreign_income	VARCHAR
other_depreciating_assets_first_deducted_no	VARCHAR
other_depreciating_assets_first_deducted	VARCHAR
total_adjustable_values_at_end_of_income_year_no	VARCHAR
total_adjustable_values_at_end_of_income_year	VARCHAR
termination_value_of_other_depreciating_assets_no	VARCHAR
termination_value_of_other_depreciating_assets	VARCHAR
deduction_for_certain_assets_costing_less_than_6_500_no	VARCHAR
deduction_for_certain_assets_costing_less_than_6_500	VARCHAR
deduction_for_general_small_business_pool_no	VARCHAR
deduction_for_general_small_business_pool	VARCHAR
tax_losses_carried_forward_to_later_income_years_no	VARCHAR
tax_losses_carried_forward_to_later_income_years	VARCHAR
net_capital_losses_carried_forward_to_later_income_years_no	VARCHAR
net_capital_losses_carried_forward_to_later_income_years	VARCHAR
tax_withheld_from_interest_or_investments_no	VARCHAR
tax_withheld_from_interest_or_investments	VARCHAR
taxable_or_net_income_no	VARCHAR
taxable_or_net_income	VARCHAR
tax_on_taxable_income_no	VARCHAR
tax_on_taxable_income	VARCHAR
gross_tax_no	VARCHAR
gross_tax	VARCHAR
non_refundable_non_carry_forward_tax_offsets_no	VARCHAR
non_refundable_non_carry_forward_tax_offsets	VARCHAR
subtotal_1_no	VARCHAR
subtotal_1	VARCHAR
non_refundable_carry_forward_tax_offsets_no	VARCHAR
non_refundable_carry_forward_tax_offsets	VARCHAR
subtotal_2_no	VARCHAR
subtotal_2	VARCHAR
refundable_tax_offsets_no	VARCHAR
refundable_tax_offsets	VARCHAR
subtotal_3_no	VARCHAR
subtotal_3	VARCHAR
tax_payable_no	VARCHAR
tax_payable	VARCHAR
eligible_credits_no	VARCHAR
eligible_credits	VARCHAR
remainder_of_refundable_tax_offsets_no	VARCHAR
remainder_of_refundable_tax_offsets	VARCHAR
payg_instalments_raised_no	VARCHAR
payg_instalments_raised	VARCHAR
amount_due_or_refundable_no	VARCHAR
amount_due_or_refundable	VARCHAR
net_tax_no	VARCHAR
net_tax	VARCHAR
income_year	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--company-table-4-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.