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
CREATE TABLE cambridge_city_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
CREATE TABLE peterborough_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
CREATE TABLE south_cambridgeshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
CREATE TABLE east_cambridgeshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
CREATE TABLE huntingdonshire_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
CREATE TABLE fenland_0_19_years_population_forecast_2016_2036 (
"ward_code" VARCHAR,
"ward_name" VARCHAR,
"year" BIGINT,
"n_0_4_years" BIGINT,
"n_5_9_years" BIGINT,
"n_10_14_years" BIGINT,
"n_15_19_years" BIGINT,
"n_0_19_years" BIGINT
);
Anyone who has the link will be able to view this.