About this Dataset

LSOA (2011) To Clinical Commissioning Group To LAD (April 2018) Lookup In EN

A lookup file between 2011 Lower Layer Super Output Areas (LSOA), to clinical commissioning groups (CCG) and local authority districts (LAD) in England, as at 1 April 2018. (File size - 8MB)

This file includes the newly formed CCGs - NHS Birmingham and Solihull CCG (E38000220), NHS Berkshire West CCG (E38000221), NHS Bristol, North Somerset and South Gloucestershire CCG (E380002220), NHS Buckinghamshire CCG (E38000223), NHS East Berkshire CCG (E38000224) and NHS Leeds CCG (E38000225) It also includes changes to the codes for NHS Fylde and Wyre CCG (E38000226), NHS Greater Preston CCG (E38000227) and NHS Morecambe Bay CCG (E38000228) following a boundary change. It also includes the local authority name change of Shepway to Folkestone and Hythe (E07000112)

Field Names - LSOA11CD, LSOA11NM, CCG18CD, CCG18CDH, CCG18NM, LAD18CD, LAD18NM

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

Field Lengths - 9, 33, 9, 3, 57, 9, 28

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

Tables

Table 1

@ukgov.lsoa_2011_to_clinical_commissioning_group_to_lad_april_28a17e4f.table_1

697.47 KB
32844 rows
8 columns


CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg18cd" VARCHAR,
  "ccg18cdh" VARCHAR,
  "ccg18nm" VARCHAR,
  "lad18cd" VARCHAR,
  "lad18nm" VARCHAR,
  "fid" BIGINT
);