About this Dataset

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

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

This file includes the newly formed clinical commissioning groups - NHS Derby and Derbyshire CCG (E38000229) and NHS Devon CCG (E38000230). The names of some of the STPs have changed, the boundaries have stayed the same.

Field Names - LSOA11CD, LSOA11NM, CCG19CD, CCG19CDH, CCG19NM, STP19CD, STP19NM, LAD19CD, LAD19NM, FID

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

Field Lengths - 9, 33, 9, 3, 57, 9, 58, 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_CCG19_STP19_LAD19_EN_07ff742a3ce94aa99f44b96062fd1117/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:56:39Z

Tables

Table 1

@ukgov.lsoa_2011_to_ccg_to_stp_april_2019_lookup_in_en.table_1

705.75 kB
32,844 rows
10 columns

CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg19cd" VARCHAR,
  "ccg19cdh" VARCHAR,
  "ccg19nm" VARCHAR,
  "stp19cd" VARCHAR,
  "stp19nm" VARCHAR,
  "lad19cd" VARCHAR,
  "lad19nm" VARCHAR,
  "fid" BIGINT
);