figshare
Browse
1/1
19 files

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

Version 7 2017-03-29, 05:51
Version 6 2017-03-28, 01:26
Version 5 2017-01-17, 04:42
Version 4 2016-12-20, 02:23
Version 3 2016-10-25, 04:53
Version 2 2016-10-25, 04:00
Version 1 2016-10-25, 03:27
figure
posted on 2017-03-29, 05:51 authored by Richard FerrersRichard Ferrers, Australian Tax Office, AURIN

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:
v6.1 - added jpg bubble plot - linked below at github.
v6 - added new csv file including SA4 names and States.
Data from: http://118.138.240.130/viewSA4fullList2010-14.html
v4.3 - added jpg combining three maps; 2006, 2010, 2014.
v4.2 - added link to full database of underlying data now added to figshare (m9.figshare.4522895)
v4.1 - add index.html, background20-12-16.pdf - Nectar.org.au archive of site at http://118.138.240.130 (now offline);
amended data totals to include AU GDP per ABS
v4 - add description of SQL to extract published data from parent DB.
v1 - 3. Minor edits.

#description
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.

#file_description
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.

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 http://areff2000.net16.net (now offline).

#sourcedata
ATO Data request at: data.gov.au Ideascale

Original data (parent data) at: data.gov.au
Parent 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_analysis

See analysis in progress for:

=> Individual income by occupation / location

at: http://areff2000.net16.net (offline) or http://118.138.240.130 (offline) (Updated: 11.11.16, 10.07.17)

#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.csv - now available as html_backup[date].zip at ATO DATAbase - see Figshare link below.

2. 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#/.

SA4 definition/description at: http://www.abs.gov.au/ausstats/abs@.nsf/0/B01A5912123E8D2BCA257801000C64F2?opendocument

#dataTotals - Salary and Wages

YearWorkers (M)Earnings ($B)GDP USD($B)
20028.5285400
20069.4372746
201010.24811142
201410.35841450

Table 1: Aust. Salary and Wages 2002 - 2014.

GDP info from: Trading Economics (link below).


#datavis

1. 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.v2

2. 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: http://areff2000.github.io/2017/03/28/plotly.html (Mar '17).

#usage

This #datavis was used in a University of Melbourne Library Hackathon - Hack for Good (25.8.16) - https://twitter.com/ValueMgmt/status/769041449862168577

Slides 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

    Funding

    n/a

    History