About this Dataset

Household Projection Data For Modelling

The GLA is currently developing updated household projection models for use in its 2023-based projections. This page will initially contain raw input data to the projections, with processed data, calculated rates, draft outputs, and links to code being added as development progresses. Inputs: * Census estimates of population usually resident population by age, sex, local authority, and residence type. * Census estimates of household representative persons by age, sex, local authority, and household type Data from standard Census tables published by ONS have been downloaded from Nomis and republished here. Full metadata for these tables can be found on the relevant pages of the Nomis website. Additional Census tables were commissioned from ONS via the GLA's Census Information Scheme. For further information about the commissioned tables, please contact census.commissiontables@ons.gov.uk
Publisher name: Greater London Authority
Last updated: 2024-10-07T04:00:57Z

Tables

DC1104EW 2011 Population Age Sex Residence Type

@ukgov.household_projection_data_for_modelling_1.dc1104ew_2011_population_age_sex_residence_type

420.76 KB
29232 rows
40 columns


CREATE TABLE dc1104ew_2011_population_age_sex_residence_type (
  "date" BIGINT,
  "date_name" BIGINT,
  "date_code" BIGINT,
  "date_type" VARCHAR,
  "date_typecode" BIGINT,
  "date_sortorder" BIGINT,
  "geography" BIGINT,
  "geography_name" VARCHAR,
  "geography_code" VARCHAR,
  "geography_type" VARCHAR,
  "geography_typecode" BIGINT,
  "geography_sortorder" BIGINT,
  "c_age" BIGINT,
  "c_age_name" VARCHAR,
  "c_age_code" VARCHAR,
  "c_age_type" VARCHAR,
  "c_age_typecode" BIGINT,
  "c_age_sortorder" BIGINT,
  "c_residence_type" BIGINT,
  "c_residence_type_name" VARCHAR,
  "c_residence_type_code" VARCHAR,
  "c_residence_type_type" VARCHAR,
  "c_residence_type_typecode" BIGINT,
  "c_residence_type_sortorder" BIGINT,
  "c_sex" BIGINT,
  "c_sex_name" VARCHAR,
  "c_sex_code" VARCHAR,
  "c_sex_type" VARCHAR,
  "c_sex_typecode" BIGINT,
  "c_sex_sortorder" BIGINT,
  "measures" BIGINT,
  "measures_name" VARCHAR,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "obs_status_name" VARCHAR,
  "obs_conf" BOOLEAN,
  "obs_conf_name" VARCHAR,
  "urn" VARCHAR,
  "record_offset" BIGINT,
  "record_count" BIGINT
);

RM120–2021 Population Age Sex Residence Type

@ukgov.household_projection_data_for_modelling_1.rm120_2021_population_age_sex_residence_type

402.61 KB
29256 rows
40 columns


CREATE TABLE rm120_2021_population_age_sex_residence_type (
  "date" BIGINT,
  "date_name" BIGINT,
  "date_code" BIGINT,
  "date_type" VARCHAR,
  "date_typecode" BIGINT,
  "date_sortorder" BIGINT,
  "geography" BIGINT,
  "geography_name" VARCHAR,
  "geography_code" VARCHAR,
  "geography_type" VARCHAR,
  "geography_typecode" BIGINT,
  "geography_sortorder" BIGINT,
  "c2021_restype_3" BIGINT,
  "c2021_restype_3_name" VARCHAR,
  "c2021_restype_3_code" VARCHAR,
  "c2021_restype_3_type" VARCHAR,
  "c2021_restype_3_typecode" BIGINT,
  "c2021_restype_3_sortorder" BIGINT,
  "c2021_age_24" BIGINT,
  "c2021_age_24_name" VARCHAR,
  "c2021_age_24_code" VARCHAR,
  "c2021_age_24_type" VARCHAR,
  "c2021_age_24_typecode" BIGINT,
  "c2021_age_24_sortorder" BIGINT,
  "c_sex" BIGINT,
  "c_sex_name" VARCHAR,
  "c_sex_code" VARCHAR,
  "c_sex_type" VARCHAR,
  "c_sex_typecode" BIGINT,
  "c_sex_sortorder" BIGINT,
  "measures" BIGINT,
  "measures_name" VARCHAR,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "obs_status_name" VARCHAR,
  "obs_conf" BOOLEAN,
  "obs_conf_name" VARCHAR,
  "urn" VARCHAR,
  "record_offset" BIGINT,
  "record_count" BIGINT
);

ST001–2001 Population Age Sex Residence Type

@ukgov.household_projection_data_for_modelling_1.st001_2001_population_age_sex_residence_type

407.1 KB
29232 rows
40 columns


CREATE TABLE st001_2001_population_age_sex_residence_type (
  "date" BIGINT,
  "date_name" BIGINT,
  "date_code" BIGINT,
  "date_type" VARCHAR,
  "date_typecode" BIGINT,
  "date_sortorder" BIGINT,
  "geography" BIGINT,
  "geography_name" VARCHAR,
  "geography_code" VARCHAR,
  "geography_type" VARCHAR,
  "geography_typecode" BIGINT,
  "geography_sortorder" BIGINT,
  "c_age" BIGINT,
  "c_age_name" VARCHAR,
  "c_age_code" BIGINT,
  "c_age_type" VARCHAR,
  "c_age_typecode" BIGINT,
  "c_age_sortorder" BIGINT,
  "c_sex" BIGINT,
  "c_sex_name" VARCHAR,
  "c_sex_code" VARCHAR,
  "c_sex_type" VARCHAR,
  "c_sex_typecode" BIGINT,
  "c_sex_sortorder" BIGINT,
  "c_residence_type" BIGINT,
  "c_residence_type_name" VARCHAR,
  "c_residence_type_code" VARCHAR,
  "c_residence_type_type" VARCHAR,
  "c_residence_type_typecode" BIGINT,
  "c_residence_type_sortorder" BIGINT,
  "measures" BIGINT,
  "measures_name" VARCHAR,
  "obs_value" BIGINT,
  "obs_status" VARCHAR,
  "obs_status_name" VARCHAR,
  "obs_conf" BOOLEAN,
  "obs_conf_name" VARCHAR,
  "urn" VARCHAR,
  "record_offset" BIGINT,
  "record_count" BIGINT
);