Where are Australian jobs growing or shrinking (2002 - 2014; over 100 regions; SA4)?

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. 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. See #datavis below for explanation of image files. #

Method

Parent 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 areff2000.net16.net. #sourcedata ATO Data request at: data.gov.au Ideascale 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:=> Individual income by occupation / location at: areff2000.net16.net (offline) or 118.138.240.130 (Updated: 11.11.16) #datavis -How To To view on National Map (data.gov.au mapping tool). 1.

Save data as csv. Data (loaded here), currently at: 118.138.240.130/sa4_deltaHeadcountRaw_display.csv2. Open 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_formatYear | 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: stat.abs.gov.au/itt/r.jsp?databyregion#/. SA4 definition/description at: 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). #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: 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.3. A new #datavis - scatter plot - is available (linked below) at github: areff2000.github.io/2017/03/28/plotly.html (Mar '17).#usageThis #datavis was used in a University of Melbourne Library Hackathon - Hack for Good (25.8.16) - twitter.com/ValueMgmt/status/769041449862168577Slides attached below: (see Canva link; Ferrers, Li, Kreunen and Lindsay (2016). L^2 Local Livability Index. Online at: canva.com/design/DAB8-48tlEw/view)twitter.com/ValueMgmt/status/770144651953135616