About this Dataset

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

This is a lookup file between 2011 lower layer super output areas, 2017 clinical commissioning groups, 2017 sustainability and transformation partnerships and 2017 local authority districts in England as at 1 April 2017. This version of the lookup contains:

The newly formed clinical commissioning groups - NHS North Cumbria CCG (E38000215), NHS Morecambe Bay CCG (E38000216) and NHS Manchester CCG (E38000217) and means that NHS North Cumbria CCG is not split between two STPs.

(File Size - 9 MB)

Column Descriptions:

LSOA11CD | Text | 9

LSOA11NM | Text | 33

CCG17CD | Text | 9

CCG17CDH | Text | 3

CCG17NM | Text | 54

STP17CD | Text | 9

STP17NM | Text | 65

LAD17CD | Text | 9

LAD17NM | Text | 28

FID | Number | 5

REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_CCG17_STP17_LAD17_EN_LU_22df3826919f4726ad20df93570178fd/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:56:00Z

Tables

Table 1

@ukgov.lsoa_2011_to_ccg_to_stp_april_2017_lookup_in_en.table_1

753.51 KB
32844 rows
10 columns


CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg17cd" VARCHAR,
  "ccg17cdh" VARCHAR,
  "ccg17nm" VARCHAR,
  "stp17cd" VARCHAR,
  "stp17nm" VARCHAR,
  "lad17cd" VARCHAR,
  "lad17nm" VARCHAR,
  "fid" BIGINT
);