Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The ATO (Australian Tax Office) made a dataset openly available (see links) showing all the Australian Salary and Wages (2002, 2006, 2010, 2014) by detailed occupation (around 1,000) and over 100 SA4 regions. Sole Trader sales and earnings are also provided. This open data (csv) is now packaged into a database (*.sql) with 45 sample SQL queries (backupSQL[date]_public.txt).See more description at related Figshare #datavis record. Versions:V5: Following #datascience course, I have made main data (individual salary and wages) available as csv and Jupyter Notebook. Checksum matches #dataTotals. In 209,xxx rows.Also provided Jobs, and SA4(Locations) description files as csv. More details at: Where are jobs growing/shrinking? Figshare DOI: 4056282 (linked below). Noted 1% discrepancy ($6B) in 2010 wages total - to follow up.#dataTotals - Salary and WagesYearWorkers (M)Earnings ($B) 20028.528520069.4372201010.2481201410.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: http://118.138.240.130.(offline)This is only resourced for max 1 year, from July 2016, so will expire in June 2017. Hence the filing here. The sample home page is provided here (and pdf), but not all the supporting files, which may be packaged and added later. Until then all files are available at the Nectar URL. Nectar URL now offline - server files attached as package (html_backup[date].zip), including php scripts, html, csv, jpegs.#installIMPORT: DB SQL dump e.g. test_2016-12-20.sql (14.8Mb)1.Started MAMP on OSX.1.1 Go to PhpMyAdmin2. New Database: 3. Import: Choose file: test_2016-12-20.sql -> Go (about 15-20 seconds on MacBookPro 16Gb, 2.3 Ghz i5)4. four tables appeared: jobTitles 3,208 rows | salaryWages 209,697 rows | soleTrader 97,209 rows | stateNames 9 rowsplus views e.g. deltahair, Industrycodes, states5. Run test query under **#; Sum of Salary by SA4 e.g. 101 $4.7B, 102 $6.9B#sampleSQLselect sa4,(select sum(count) from salaryWageswhere year = '2014' and sa4 = sw.sa4) as thisYr14,(select sum(count) from salaryWageswhere year = '2010' and sa4 = sw.sa4) as thisYr10,(select sum(count) from salaryWageswhere year = '2006' and sa4 = sw.sa4) as thisYr06,(select sum(count) from salaryWageswhere year = '2002' and sa4 = sw.sa4) as thisYr02from salaryWages swgroup by sa4order by sa4
Attribution 2.5 (CC BY 2.5)https://creativecommons.org/licenses/by/2.5/
License information was derived automatically
covers 2004 to 2017 annual data source: Australian Bureau of Statistics cat no. 6333.0 tbls 3 and 4.
Between March 2024 and March 2025, wages in the professional, scientific, and technical services in Australia grew by around 2.9 percent. The electricity, gas, water and waste services industry had the highest wage growth, with an annual change of 4.4 percent.
In the financial year 2024, the total value of wages and salaries in the iron ore mining industry in Australia was approximately 9.16 billion Australian dollars. A consistent increase in wages was seen from the financial year 2018.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This data - count of employees by 100 regions within Australia (over 12 years; 2002 - 2014) - 8.5M 2002 -> 10.3M 2014.Parent data - Employee $ DATA by detailed occupation, by location (SA4), by year; This dataset is an aggregation of all Australian Salaries and Wages by location and over 12 years in four year snapshots (2002, 2006, 2010, 2014). Some data excluded which was not allocated to a SA4 location. Source Data from ATO; Australian Tax Office.HeadcountRaw.csv provides total data (employee count). Includes total counts per SA4 location, and percent change between each of the years; 2002 - 6; 2006 - 10; 2010 - 14 eg 101 means 1% increase.HeadcountRaw_display.csv provides data (employee count) to visualise at (1) National Map.gov.au or (2) Aurin.org.au. This only includes the data for SA4 regions which can be visualised.Method; CSV files loaded into MariaDB on Nectar Infrastructure (refer NCRIS). Access through http://areff2000.net16.net.Data request at: data.gov.au IdeascaleOriginal data (parent data) at: data.gov.auParent data description: "Individuals data for 2001-02, 2005-06, 2009-10 and 2013-14 income years. Table 1: Salary and Wages income, by Occupation and SA4 location Table 2: Sole trader business income, by Industry and SA4 location." Sole trader data not included in this sub-collection.See analysis in progress for:=> Individual income by occupation / location at: http://areff2000.net16.netTo recreate #datavis - How To To view on National Map (data.gov.au mapping tool). 1. Save data as csv. Data (loaded here), currently at: http://118.138.240.130/sa4_deltaHeadcountRaw_display.csv2. Open http://nationalmap.gov.au. 3. Click 'Add Data'. 4. Drag csv file onto map. 5. Click Done. 6. Select Year in control panel (lower left of screen). Raw shows count of jobs. Year shows % change from four years earlier. 7. Click on region (SA4) to see data for that region.Data format: Year | Occupation | Location (SA4) | Count of Workers | $ of Workers * Year: [2002, 2006, 2010, 2014]* Salary and Wages; 200,000 lines (summary only included here)* Sole Proprietors; 100,000 lines (not included here)* Occupation: Description at Australian Bureau of Statistics. (3,216 lines) (link below)* SA4 Location descriptions at: http://stat.abs.gov.au/itt/r.jsp?databyregion#/. #dataTotals - Salary and WagesYearWorkers (M)Earnings ($B)GDP USD($B)20028.528540020069.4372746201010.24811142201410.35841450Table 1: Aust. Salary and Wages 2002 - 2014.GDP info from: Trading Economics (link below).#datavis1. Three Chloro images made at aurin.org.au (AU researcher login required). eg Chloro12_2014 is 12 colour chloropeth, for 2010 - 2014, Chloro12_2010 is 2006 - 2010, Chloro12_2006 is 2002 - 2006.Please cite images as: Ferrers, R., ATO - User uploaded data (2016) visualised in AURIN portal (map visualisation chloropeth) on 25.8.2016. Viewed online at: https://dx.doi.org/10.6084/m9.figshare.4056282.v22. Red/Orange (year.tiff) images made at nationalmap.org.au, where 2014.tiff is percent difference 2010 - 2014, 2010.tiff is 2006 - 2010, 2006.tiff is 2002 - 2006.#usageThis #datavis was used in a University of Melbourne Library Hackathon - Hack for Good (25.8.16) - https://twitter.com/ValueMgmt/status/769041449862168577Slides attached below: (see Canva link; Ferrers, Li, Kreunen and Lindsay (2016). L^2 Local Livability Index. Online at: https://www.canva.com/design/DAB8-48tlEw/view)https://twitter.com/ValueMgmt/status/770144651953135616
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding employee jobs and median employee income per job, classified by industry subdivision at Statistical Area Level 2 (SA2). The data spans over the 2017-18 financial year and is aggregated to the 2016 SA2 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. An 'employee Job' refers to a job for which the occupant receives remuneration in wages, salary, payment in kind, or piece rates. This excludes self-employment jobs held by Owner-Managers of Unincorporated Enterprises (OMUE). The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
Attribution 2.5 (CC BY 2.5)https://creativecommons.org/licenses/by/2.5/
License information was derived automatically
ATO salary and wage occupation codes, which are six-digit codes individuals include on income tax returns that describe their main salary and wage occupation. Includes Code and Description of occupation, for the 2007-08 to 2024-25 income years.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding employee jobs and median employee income per job, classified by industry subdivision at Statistical Area Level 2 (SA2). The data spans over the 2013-14 financial year and is aggregated to the 2016 SA2 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. An 'employee Job' refers to a job for which the occupant receives remuneration in wages, salary, payment in kind, or piece rates. This excludes self-employment jobs held by Owner-Managers of Unincorporated Enterprises (OMUE). The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding all of the jobs within the relevant statistical regions, including the number of employee jobs and median employee income per job by industry subdivision, classified by Statistical Area Level 2 (SA2). The data spans 2018/2019 financial year and is aggregated to the 2016 SA2 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
This dataset presents aggregated data regarding the number of jobs and their respective median income by the relevant industry which the job is involved in for each statistical region specified. The …Show full descriptionThis dataset presents aggregated data regarding the number of jobs and their respective median income by the relevant industry which the job is involved in for each statistical region specified. The data spans over the 2014/15 financial year and is aggregated to the 2016 Statistical Level 2 (SA2) boundaries. Jobs in Australia is a new release that provides aggregate statistics from the recently developed Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. Jobs in Australia describes all job relationships accumulated over the course of a year. This means that job counts in this publication are higher than the estimates of filled jobs published in the quarterly Australian Labour Account, which provides a point-in-time, or stock measure. These statistics about jobs also differ from Labour Force Survey statistics, which estimate the number of people who held a job in each month. The purpose of this publication is to provide new information about the number and nature of filled jobs in Australia, the people who hold them, and their employers. It includes information about multiple job-holding and employment in local areas. Jobs in Australia counts all jobs held during the reference year. This complements and expands on quarterly stock estimates of filled jobs presented in the Australian Labour Account. This data is Australian Bureau of Statistics (ABS) data (catalogue number: 6160.0) used with permission from the ABS. For more information on the release please visit the Australian Bureau of Statistics. Please note: AURIN has spatially enabled the original data. Where data was not published for confidential reasons, "np" in the original data, the records have been set to null. Total values may be higher than the sum of the published components due to this confidentialisation. Copyright attribution: Government of the Commonwealth of Australia - Australian Bureau of Statistics, (2018): ; accessed from AURIN on 12/3/2020. Licence type: Creative Commons Attribution 4.0 International (CC BY 4.0)
In the financial year 2024, the total value of wages and salaries in the mining industry in Australia amounted to approximately 38.39 billion Australian dollars. A consistent increase in wages for the mining industry has been observed since the financial year 2017.
This dataset presents aggregated data regarding all of the jobs within the relevant statistical regions, including their number and median income. The data spans over the 2011/12 financial year and …Show full descriptionThis dataset presents aggregated data regarding all of the jobs within the relevant statistical regions, including their number and median income. The data spans over the 2011/12 financial year and is aggregated to the 2016 Greater Capital City Statistical Area (GCCSA) boundaries. Jobs in Australia is a new release that provides aggregate statistics from the recently developed Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. Jobs in Australia describes all job relationships accumulated over the course of a year. This means that job counts in this publication are higher than the estimates of filled jobs published in the quarterly Australian Labour Account, which provides a point-in-time, or stock measure. These statistics about jobs also differ from Labour Force Survey statistics, which estimate the number of people who held a job in each month. The purpose of this publication is to provide new information about the number and nature of filled jobs in Australia, the people who hold them, and their employers. It includes information about multiple job-holding and employment in local areas. Jobs in Australia counts all jobs held during the reference year. This complements and expands on quarterly stock estimates of filled jobs presented in the Australian Labour Account. This data is Australian Bureau of Statistics (ABS) data (catalogue number: 6160.0) used with permission from the ABS. For more information on the release please visit the Australian Bureau of Statistics. Please note: AURIN has spatially enabled the original data. Where data was not published for confidential reasons, "np" in the original data, the records have been set to null. Total values may be higher than the sum of the published components due to this confidentialisation. Copyright attribution: Government of the Commonwealth of Australia - Australian Bureau of Statistics, (2018): ; accessed from AURIN on 12/3/2020. Licence type: Creative Commons Attribution 4.0 International (CC BY 4.0)
This dataset presents aggregated data regarding all of the jobs within the relevant statistical regions, including their number and median income. The data spans over the 2014/15 financial year and …Show full descriptionThis dataset presents aggregated data regarding all of the jobs within the relevant statistical regions, including their number and median income. The data spans over the 2014/15 financial year and is aggregated to the 2016 Statistical Level 2 (SA2) boundaries. Jobs in Australia is a new release that provides aggregate statistics from the recently developed Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. Jobs in Australia describes all job relationships accumulated over the course of a year. This means that job counts in this publication are higher than the estimates of filled jobs published in the quarterly Australian Labour Account, which provides a point-in-time, or stock measure. These statistics about jobs also differ from Labour Force Survey statistics, which estimate the number of people who held a job in each month. The purpose of this publication is to provide new information about the number and nature of filled jobs in Australia, the people who hold them, and their employers. It includes information about multiple job-holding and employment in local areas. Jobs in Australia counts all jobs held during the reference year. This complements and expands on quarterly stock estimates of filled jobs presented in the Australian Labour Account. This data is Australian Bureau of Statistics (ABS) data (catalogue number: 6160.0) used with permission from the ABS. For more information on the release please visit the Australian Bureau of Statistics. Please note: AURIN has spatially enabled the original data. Where data was not published for confidential reasons, "np" in the original data, the records have been set to null. Total values may be higher than the sum of the published components due to this confidentialisation. Copyright attribution: Government of the Commonwealth of Australia - Australian Bureau of Statistics, (2018): ; accessed from AURIN on 12/3/2020. Licence type: Creative Commons Attribution 4.0 International (CC BY 4.0)
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding employed persons within the relevant statistical regions, including the number of employee jobs and median employee income per job by sex, classified by Statistical Area Level 2 (SA2). The data spans from 2014-15 to 2018-19 financial year and is aggregated to the 2016 SA2 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. Employee person refers to any person with one or more job. Employed persons in this publication can be employees, owner-managers of unincorporated enterprises, or both. Employed persons are persons who have employment income in the reference year, excluding those whose employment income is made up entirely of an employment termination payment. Employed persons have one or more jobs on the job file. The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding employee jobs and median employee income per job, classified by industry subdivision at Statistical Area Level 4 (SA4). The data spans over the 2014-15 financial year and is aggregated to the 2016 SA4 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. An 'employee Job' refers to a job for which the occupant receives remuneration in wages, salary, payment in kind, or piece rates. This excludes self-employment jobs held by Owner-Managers of Unincorporated Enterprises (OMUE). The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
In 2024, the industry with the leading male dominated gender pay gap in Australia was the Financial and Insurance Services sector, where ** percent of employers had a gender pay gap in favor of men. In contrast, the Public Administration and Safety industry saw only ** percent of employers having a gender pay gap in favor of men.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset presents aggregated data regarding employee jobs and median employee income per job, classified by industry subdivision at Statistical Area Level 4 (SA4). The data spans over the 2017-18 financial year and is aggregated to the 2016 SA4 boundaries. Jobs in Australia provide aggregate statistics and are sourced from the Linked Employer-Employee Dataset (LEED). It provides new information about filled jobs in Australia, the people who hold them, and their employers. An 'employee Job' refers to a job for which the occupant receives remuneration in wages, salary, payment in kind, or piece rates. This excludes self-employment jobs held by Owner-Managers of Unincorporated Enterprises (OMUE). The job counts in this release differ from the filled job estimates from other sources such as the Australian Labour Account and the Labour Force Australia. The Jobs in Australia release provides insights into all jobs held throughout the year, while the Labour Account data provides the number of filled jobs at a point-in-time each quarter (and annually for the financial year reference period), and Labour Force Survey data measures the number of people employed each month. For more information on the release please visit the Australian Bureau of Statistics This release provides statistics on the number and nature of jobs, the people who hold them, and their employers. These statistics can be used to understand regional labour markets or to identify the impact of major changes in local communities. The release also provides new insights into the number of jobs people hold, the duration of jobs, and the industries and employment income of concurrent jobs. The scope of these data includes individuals who submitted an individual tax return to the Australian Taxation Office (ATO), individuals who had a Pay As You Go (PAYG) payment summary issued by an employer and their employers.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Australia Employee Wages Index: 20-29 Years Old data was reported at 117.100 14Mar2020=100 in 12 Nov 2022. This records an increase from the previous number of 116.560 14Mar2020=100 for 05 Nov 2022. Australia Employee Wages Index: 20-29 Years Old data is updated weekly, averaging 103.660 14Mar2020=100 from Jan 2020 (Median) to 12 Nov 2022, with 150 observations. The data reached an all-time high of 119.560 14Mar2020=100 in 17 Sep 2022 and a record low of 91.530 14Mar2020=100 in 11 Apr 2020. Australia Employee Wages Index: 20-29 Years Old data remains active status in CEIC and is reported by Australian Bureau of Statistics. The data is categorized under Global Database’s Australia – Table AU.G055: Employee Jobs and Wages Index.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Australia Employee Wages Index: 70 Years Old & Over data was reported at 133.640 14Mar2020=100 in 12 Nov 2022. This records a decrease from the previous number of 134.680 14Mar2020=100 for 05 Nov 2022. Australia Employee Wages Index: 70 Years Old & Over data is updated weekly, averaging 114.455 14Mar2020=100 from Jan 2020 (Median) to 12 Nov 2022, with 150 observations. The data reached an all-time high of 148.570 14Mar2020=100 in 25 Jun 2022 and a record low of 90.250 14Mar2020=100 in 04 Jan 2020. Australia Employee Wages Index: 70 Years Old & Over data remains active status in CEIC and is reported by Australian Bureau of Statistics. The data is categorized under Global Database’s Australia – Table AU.G055: Employee Jobs and Wages Index.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Australia Employee Wages Index: Male: 30-39 Years Old data was reported at 105.130 14Mar2020=100 in 12 Nov 2022. This records an increase from the previous number of 105.050 14Mar2020=100 for 05 Nov 2022. Australia Employee Wages Index: Male: 30-39 Years Old data is updated weekly, averaging 102.470 14Mar2020=100 from Jan 2020 (Median) to 12 Nov 2022, with 150 observations. The data reached an all-time high of 113.880 14Mar2020=100 in 17 Sep 2022 and a record low of 89.680 14Mar2020=100 in 04 Jan 2020. Australia Employee Wages Index: Male: 30-39 Years Old data remains active status in CEIC and is reported by Australian Bureau of Statistics. The data is categorized under Global Database’s Australia – Table AU.G055: Employee Jobs and Wages Index.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The ATO (Australian Tax Office) made a dataset openly available (see links) showing all the Australian Salary and Wages (2002, 2006, 2010, 2014) by detailed occupation (around 1,000) and over 100 SA4 regions. Sole Trader sales and earnings are also provided. This open data (csv) is now packaged into a database (*.sql) with 45 sample SQL queries (backupSQL[date]_public.txt).See more description at related Figshare #datavis record. Versions:V5: Following #datascience course, I have made main data (individual salary and wages) available as csv and Jupyter Notebook. Checksum matches #dataTotals. In 209,xxx rows.Also provided Jobs, and SA4(Locations) description files as csv. More details at: Where are jobs growing/shrinking? Figshare DOI: 4056282 (linked below). Noted 1% discrepancy ($6B) in 2010 wages total - to follow up.#dataTotals - Salary and WagesYearWorkers (M)Earnings ($B) 20028.528520069.4372201010.2481201410.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: http://118.138.240.130.(offline)This is only resourced for max 1 year, from July 2016, so will expire in June 2017. Hence the filing here. The sample home page is provided here (and pdf), but not all the supporting files, which may be packaged and added later. Until then all files are available at the Nectar URL. Nectar URL now offline - server files attached as package (html_backup[date].zip), including php scripts, html, csv, jpegs.#installIMPORT: DB SQL dump e.g. test_2016-12-20.sql (14.8Mb)1.Started MAMP on OSX.1.1 Go to PhpMyAdmin2. New Database: 3. Import: Choose file: test_2016-12-20.sql -> Go (about 15-20 seconds on MacBookPro 16Gb, 2.3 Ghz i5)4. four tables appeared: jobTitles 3,208 rows | salaryWages 209,697 rows | soleTrader 97,209 rows | stateNames 9 rowsplus views e.g. deltahair, Industrycodes, states5. Run test query under **#; Sum of Salary by SA4 e.g. 101 $4.7B, 102 $6.9B#sampleSQLselect sa4,(select sum(count) from salaryWageswhere year = '2014' and sa4 = sw.sa4) as thisYr14,(select sum(count) from salaryWageswhere year = '2010' and sa4 = sw.sa4) as thisYr10,(select sum(count) from salaryWageswhere year = '2006' and sa4 = sw.sa4) as thisYr06,(select sum(count) from salaryWageswhere year = '2002' and sa4 = sw.sa4) as thisYr02from salaryWages swgroup by sa4order by sa4