About this Dataset

LSOA (2011) To CCG To STP (April 2021) Lookup In EN

This is a lookup file between 2011 lower layer super output areas, clinical commissioning groups, sustainability and transformation partnerships and local authority districts in England as at 1 April 2021. (File size - 14MB)

Field Names - LSOA11CD, LSOA11NM, CCG21CD, CCG21CDH, CCG21NM, STP21CD, STP21NM, LAD21CD, LAD21NM, FID

Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text

Field Lengths - 9, 33, 9, 5, 59, 9, 67, 9, 35

FID = The FID, or Feature ID is created by the publication process when the names and codes / lookup products are published to the Open Geography portal.

REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_CCG21_STP21_LAD21_EN_LU_ae1a442ee397483cab1a31f2e7b24029/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-13T11:13:52Z

Tables

Table 1

@ukgov.lsoa_2011_to_ccg_to_stp_april_2021_lookup_in_en.table_1

727.21 KB
32844 rows
10 columns


CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg21cd" VARCHAR,
  "ccg21cdh" VARCHAR,
  "ccg21nm" VARCHAR,
  "stp21cd" VARCHAR,
  "stp21nm" VARCHAR,
  "lad21cd" VARCHAR,
  "lad21nm" VARCHAR,
  "fid" BIGINT
);