2015-based Population Forecasts, 0-19 Years, Cambridgeshire And Peterborough
Cambridgeshire Insight
@ukgov.n_2015_based_population_forecasts_0_19_years_cambridge_90e2503c
Cambridgeshire Insight
@ukgov.n_2015_based_population_forecasts_0_19_years_cambridge_90e2503c
This dataset is part of Cambridgeshire County Council's 2015-based population and dwelling stock forecasts. This dataset provides the population forecasts for the age group between 0-19 years. Forecasts are provided at county, district and ward level for the years 2016, 2021, 2026, 2031 and 2036.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:50:59Z
CREATE TABLE cambridge_city_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
CREATE TABLE east_cambridgeshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
CREATE TABLE fenland_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
CREATE TABLE huntingdonshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
CREATE TABLE peterborough_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
CREATE TABLE south_cambridgeshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT -- 0-4 Years,
"n_5_9_years" BIGINT -- 5-9 Years,
"n_10_14_years" BIGINT -- 10-14 Years,
"n_15_19_years" BIGINT -- 15-19 Years,
"n_0_19_years" BIGINT -- 0-19 Years
);
Anyone who has the link will be able to view this.