12 files

ABS 2021 Mesh Block dwelling counts to CSV (code and data)

posted on 31.08.2022, 23:03 authored by Carl HiggsCarl Higgs

As of 31 August 2022, the Australian Bureau of Statistics has only released the 2021 census Mesh Block dwelling counts as an Excel file, with data stratified across 12 worksheets. This is inconvenient for users who wish to link this data with digital boundaries, and not useful for data posterity. In addition to completing a feedback survey for the ABS, suggesting that a CSV download should be provided (which the Excel file itself suggests is the case in its Explanatory Notes, and was the case with the 2011 and 2016 census releases), I thought it would be useful to take the time to compile these and make them public for myself and others until an official release is produced. 

This repository contains the code to combine the 12 worksheets into a single national CSV file, as well as state-stratified CSV files of Mesh Block dwelling and person counts, along with the resulting data outputs.   

The code is also published in a Jupyter Notebook at https://github.com/carlhiggs/abs_mesh_block_counts_csv/blob/main/ABS Mesh Block counts to CSV.ipynb

Users of the data should note, "Cells ... have been randomly adjusted to avoid the release of confidential data.".  The data is © Commonwealth of Australia 2022, and data was made available by the Australian Bureau of Statistics under a Creative Commons Attribution 4.0 International licence as per https://www.abs.gov.au/website-privacy-copyright-and-disclaimer#copyright-and-creative-commons