Australia (ATO) Salary/Wages/SoleTrader Database by Occupation and Region (2002-14)

Sole Trader sales and earnings are also provided. This open data (csv) is now packaged into a database with 45 sample SQL queries. #dataTotals - Salary and WagesYearWorkers (M)Earnings ($B) 20028.5285 20069.4372 201010.2481 201410.3584 #dataTotal - Sole TradersYearWorkers (M)Sales ($B)Earnings ($B)20020.9611320061.0881920101.11122620141.19630 #links See ATO request for data at ideascale link below.See original csv open data set (CC-BY) at data.gov.au link below.This database was used to create maps of change in regional employment - see Figshare link below (m9.figshare.4056282). #packageThis file package contains a database (analysing the open data) in SQL package and sample SQL text, interrogating the DB.

DB name: test. There are 20 queries relating to Salary and Wages. #analysisThe database was analysed and outputs provided on Nectar(.org.au) resources at: 118.138.240.130.This is only resourced for max 1 year, from July 2016, so will expire in June 2017. Hence the filing here.