About this Dataset

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

Field Names - LSOA11CD, LSOA11NM, CCG21CD, CCG21CDH, CCG21NM, STP21CD, STP21NM, CAL21CD, CAL21NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 33, 9, 5, 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_CCG21_STP21_CAL21_LAD21_EN_LU_f3b57157421d4eaa81e77d3ecc4b5bda/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:56:42Z

Tables

Table 1

@ukgov.lsoa_2011_to_clinical_commissioning_group_to_stp_to_ca_0f40de6d.table_1

702.1 KB
32844 rows
12 columns


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