About this Dataset

LSOA (2011) To Clinical Commissioning Group To STP To CAL (April 2020) 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 1 April 2020. (File size - 14MB).

Field Names - LSOA11CD, LSOA11NM, CCG20CD, CCG20CDH, CCG20NM, STP20CD, STP20NM, CAL20CD, CAL20NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 33, 9, 3, 59, 9, 67, 9, 67

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_CCG20_STP20_CAL20_LAD20_EN_LU_f1e17ac2abc84efca8ae1f4846fa951c/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:56:06Z

Tables

Table 1

@ukgov.lsoa_2011_to_clinical_commissioning_group_to_stp_to_ca_96d0c8e9.table_1

713.44 KB
32844 rows
12 columns


CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg20cd" VARCHAR,
  "ccg20cdh" VARCHAR,
  "ccg20nm" VARCHAR,
  "stp20cd" VARCHAR,
  "stp20nm" VARCHAR,
  "cal20cd" VARCHAR,
  "cal20nm" VARCHAR,
  "lad20cd" VARCHAR,
  "lad20nm" VARCHAR,
  "fid" BIGINT
);