2015-based Population And Dwelling Stock Forecasts, Cambridgeshire And Peterborough
Cambridgeshire Insight
@ukgov.n_2015_based_population_and_dwelling_stock_forecasts_c_7d958134
Cambridgeshire Insight
@ukgov.n_2015_based_population_and_dwelling_stock_forecasts_c_7d958134
CREATE TABLE cambridgeshire_and_peterborough_2015_based_district_po_10a2aeca (
"district_code" VARCHAR,
"district_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_cambridge (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_south_cambridgeshire (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_peterborough (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_dwelling_stock_forecasts_for_cambridgeshi_5fdba63e (
"ward_code" VARCHAR,
"ward" VARCHAR,
"n_2011_forecast_dwelling" VARCHAR,
"n_2016_forcast_dwelling" BIGINT,
"n_2021_forecast_dwelling" BIGINT,
"n_2026_forecast_dwelling" BIGINT,
"n_2031_forecast_dwelling" BIGINT,
"n_2036_forecast_dwelling" BIGINT,
"n_2011_2016_dwelling_change" VARCHAR,
"n_2016_2021_dwelling_change" BIGINT,
"n_2021_2026_dwelling_change" BIGINT,
"n_2026_2031_dwelling_change" BIGINT,
"n_2031_2036_dwelling_change" BIGINT,
"n_2011_2036_dwelling_change" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_huntingdonshire (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_east_cambridgeshire (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_population_forecasts_for_fenland (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"total" BIGINT,
"n_0_4_years_old" BIGINT,
"n_5_14_years_old" BIGINT,
"n_15_24_years_old" BIGINT,
"n_25_44_years_old" BIGINT,
"n_45_64_years_old" BIGINT,
"n_65_74_years_old" BIGINT,
"n_75_84_years_old" BIGINT,
"over_85_years_old" BIGINT,
"n_16_64_years_old" BIGINT,
"n_18_64_years_old" BIGINT
);
CREATE TABLE n_2015_based_dwelling_stock_forecasts_for_cambridgeshi_9606238a (
"district_code" VARCHAR,
"district" VARCHAR,
"n_2011_estimated_dwelling" BIGINT,
"n_2016_forcast_dwelling" BIGINT,
"n_2021_forecast_dwelling" BIGINT,
"n_2026_forecast_dwelling" BIGINT,
"n_2031_forecast_dwelling" BIGINT,
"n_2036_forecast_dwelling" BIGINT,
"n_2011_2016_dwelling_change" BIGINT,
"n_2016_2021_dwelling_change" BIGINT,
"n_2021_2026_dwelling_change" BIGINT,
"n_2026_2031_dwelling_change" BIGINT,
"n_2031_2036_dwelling_change" BIGINT,
"total_dwelling_change" BIGINT
);
Anyone who has the link will be able to view this.