About this Dataset

LSOA (2011) To Clinical Commissioning Group To STP To CAL (July 2019) Lookup In EN

A lookup file between 2011 lower layer super output areas (LSOAs) clinical commissioning groups (CCGs), sustainability and transformation partnerships (STP) and Cancer Alliances (CAL) in England as at 1st July 2019. (File size - 14MB).

Field Names - LSOA11CD, LSOA11NM, CCG19CD, CCG19CDH, CCG19NM, STP19CD, STP19NM, CAL19CC, CAL19NM
Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 33, 9, 3, 57, 9, 49, 9, 45

File updated to include the changes of the 3 National Cancer Vanguards to Cancer Alliances - Greater Manchester, North Central and North East London and North West and South West London, the split of East of England Cancer alliance to form East of England - North and East of England - South, and the changes to the boundary of East Midlands Cancer Alliance and South Yorkshire and Bassetlaw Cancer Alliance.

File includes the merger of NHS Erewash CCG, NHS Hardwick CCG, NHS North Derbyshire CCG, and NHS Southern Derbyshire CCG to form E38000229 (15M) - NHS Derby and Derbyshire CCG and the merger of NHS Northern, Eastern and Western Devon CCG and NHS South Devon and Torbay CCG to form E38000230 (15N) - NHS Devon CCG

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

Tables

Table 1

@ukgov.lsoa_2011_to_clinical_commissioning_group_to_stp_to_ca_b3b91c84.table_1

666.22 KB
32844 rows
10 columns


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