DOI: 10.6084/m9.figshare.4056282.v3
title: Where are Australian jobs growing or shrinking (2002 - 2014; over 100 regions; SA4)?

description: This data shows count of employees by 100 regions within Australia over 12 years (2002 - 2014). In 2002, there were 8.5M workers, rising to 10.3M in 2014. Maps show percent change in count of employees over preceding four years eg 2010-2014.Parent data - Employee $ DATA by detailed occupation, by location (SA4), by year; #Changelog:v4 - add description of SQL to extract published data from parent DB.v1 - 3. Minor edits.<br>#descriptionThis 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.<br>#file_description<br>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. This file also contains the SQL query to extract this file from the parent DB.<br>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. <br>See #datavis below for explanation of image files.<br>#MethodParent DB CSV files loaded into MariaDB on Nectar Infrastructure (refer NCRIS). SQL to extract this subset of data from parent DB is included in the header of HeadcountRaw.csv. Access through http://areff2000.net16.net.<br>#sourcedata<br>ATO Data request at: data.gov.au Ideascale<br>Original 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.#current_analysisSee analysis in progress for:=&gt; Individual income by occupation / location <br>at: http://areff2000.net16.net (offline) or http://118.138.240.130 (Updated: 11.11.16) #datavis -How To <b>To view on National Map (data.gov.au mapping tool).</b> 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'. <br>4. Drag csv file onto map. 5. Click Done. <br>6. Select Year in control panel (lower left of screen). Raw shows count of jobs. Year shows % change from four years earlier. <br>7. Click on region (SA4) to see data for that region.<br>#Data_formatYear | Occupation | Location (SA4) | Count of Workers | $ of Workers <br>* Year: [2002, 2006, 2010, 2014]<br><br>* Salary and Wages; 200,000 lines (summary only included here)<br>* 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#/. SA4 definition/description at: http://www.abs.gov.au/ausstats/abs@.nsf/0/B01A5912123E8D2BCA257801000C64F2?opendocument #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).<br>#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 (NM), where 2014.tiff is percent difference 2010 - 2014, 2010.tiff is 2006 - 2010, 2006.tiff is 2002 - 2006. Three scale files explain colours on each year.tiff, where related scale is [year]NM_scale.tiff.#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