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
CREATE TABLE region_summary_australian_capital_territory_ste_8 (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_adelaide_gccsa_4gade (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_brisbane_gccsa_3gbri (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_darwin_gccsa_7gdar (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_hobart_gccsa_6ghob (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_melbourne_gccsa_2gmel (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_perth_gccsa_5gper (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
CREATE TABLE region_summary_greater_sydney_gccsa_1gsyd (
"measure_code" VARCHAR,
"parent_description" VARCHAR,
"description" VARCHAR,
"n_2011" DOUBLE,
"n_2015" DOUBLE,
"n_2016" DOUBLE,
"n_2017" DOUBLE,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE,
"n_2022" DOUBLE
);
Anyone who has the link will be able to view this.