York's Long Term Population Projection
City of York Council
@ukgov.yorks_long_term_population_projection
City of York Council
@ukgov.yorks_long_term_population_projection
CREATE TABLE long_term_population_projection_2012 (
"areacode" VARCHAR,
"areaname" VARCHAR,
"areatype" VARCHAR,
"agegroup" BIGINT,
"sex" VARCHAR,
"n_2012" BIGINT,
"n_2013" DOUBLE,
"n_2014" 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,
"n_2023" DOUBLE,
"n_2024" DOUBLE,
"n_2025" DOUBLE,
"n_2026" DOUBLE,
"n_2027" DOUBLE,
"n_2028" DOUBLE,
"n_2029" DOUBLE,
"n_2030" DOUBLE,
"n_2031" DOUBLE,
"n_2032" DOUBLE,
"n_2033" DOUBLE,
"n_2034" DOUBLE,
"n_2035" DOUBLE,
"n_2036" DOUBLE,
"n_2037" DOUBLE
);
CREATE TABLE long_term_population_projection_2014 (
"areacode" VARCHAR,
"areaname" VARCHAR,
"areatype" VARCHAR,
"agegroup" BIGINT,
"sex" VARCHAR,
"n_2014" BIGINT,
"n_2015" BIGINT,
"n_2016" BIGINT,
"n_2017" BIGINT,
"n_2018" BIGINT,
"n_2019" BIGINT,
"n_2020" BIGINT,
"n_2021" BIGINT,
"n_2022" BIGINT,
"n_2023" BIGINT,
"n_2024" BIGINT,
"n_2025" BIGINT,
"n_2026" BIGINT,
"n_2027" BIGINT,
"n_2028" BIGINT,
"n_2029" BIGINT,
"n_2030" BIGINT,
"n_2031" BIGINT,
"n_2032" BIGINT,
"n_2033" BIGINT,
"n_2034" BIGINT,
"n_2035" BIGINT,
"n_2036" BIGINT,
"n_2037" BIGINT,
"n_2038" BIGINT,
"n_2039" BIGINT
);
Anyone who has the link will be able to view this.