Australian Population Data By Region
Population, Economy, Industry, Income, Education, Employment, Land & Environment
@kaggle.joebeachcapital_australian_population_data_by_region
Population, Economy, Industry, Income, Education, Employment, Land & Environment
@kaggle.joebeachcapital_australian_population_data_by_region
This release of Data by region presents various data for 2011-2022, including the Census of Population and Housing (Census) data for 2011, 2016 and 2021. Data by Region is a visual compendium of regional data, enabling users to find data for over 4,500 regions across Australia. It contains over 800 data items, covering a range of themes including Population, Economy and Industry, Income, Education, Employment and Land and Environment.
Source: https://www.abs.gov.au/methodologies/data-region-methodology/2011-22#overview
CREATE TABLE region_summary_australian_capital_territory_ste_8 (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_adelaide_gccsa_4gade (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_brisbane_gccsa_3gbri (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_darwin_gccsa_7gdar (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_hobart_gccsa_6ghob (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_melbourne_gccsa_2gmel (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_perth_gccsa_5gper (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);CREATE TABLE region_summary_greater_sydney_gccsa_1gsyd (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE -- 2011,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022
);Anyone who has the link will be able to view this.