LABOUR FORCE PIVOT TABLES
Commencing with the March 2017 issue of Labour Force, Australia, Detailed - Electronic Delivery (cat. no. 6291.0.55.001), the ABS is now publishing a new detailed data pivot table LM9 - Labour Force Status by Age (detailed), Greater Capital City and Rest of State (ASGS) and Sex, January 1991 onwards. This table enhances the suite of data available in the pivot table format.
This follows the commencement, with the August 2016 issue of Labour Force, Australia, Detailed - Electronic Delivery (cat. no. 6291.0.55.001) and the November 2016 issue of Labour Force, Australia, Detailed, Quarterly (cat. no. 6291.0.55.003), of publishing detailed Labour Force data in pivot table format, in addition to the existing suite of SuperTable data cube outputs.
Pivot tables will increase the accessibility of Labour Force data, as well as provide a long term replacement for the unsupported Summary Record Database (SRD) format. The pivot table products reflect the design and utility of the existing Summary Record Database (SRD) data cubes as closely as possible. In addition, the inclusion of a comma separated variable (CSV) source worksheet in each pivot table is expected to be of particular interest to people who undertake statistical analysis using a range of software.
The median data that were previously released in SuperTable data cubes have been converted to timeseries spreadsheets 14c, 14d, 14e and 16c, to reduce the complexity of pivot table products.
The ABS will continue to release the SRD data cubes until July 2017 for monthly data and August 2017 for quarterly data, to allow for a transition to pivot tables, after which point the ABS intends to cease publishing Labour Force SRD data cubes.
A similar transition for the GM1 data cube in Labour Force, Australia (cat. no. 6202.0) will also commence, most likely in 2017.