About this Dataset

LSOA (2011) To Clinical Commissioning Group To LAD (April 2019) 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 2019. (File size - 9MB)
This file includes the newly formed CCGs - E38000229 - NHS Derby and Derbyshire CCG and E38000230 - NHS Devon CCG.

It also includes the following LAD changes

E06000058 - Bournemouth, Christchurch and Poole - new unitary authority

E06000059 - Dorset - new unitary authority - (Dorset county abolished)

E07000244 - East Suffolk - new local authority district (Suffolk Coastal and Waveney districts abolished)

E07000245 - West Suffolk - new local authority district (Forest Heath and St Edmundsbury districts abolished)

E07000246 - Somerset West and Taunton - new local authority district (Taunton Deane and West Somerset districts abolished
Field Names - LSOA11CD, LSOA11NM, CCG19CD, CCG19CDH, CCG19NM, LAD19CD, LAD19NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text, Numeric
Field Lengths - 9, 33, 9, 3, 57, 9, 35

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

Tables

Table 1

@ukgov.lsoa_2011_to_clinical_commissioning_group_to_lad_april_0f83245e.table_1

695.6 KB
32844 rows
8 columns


CREATE TABLE table_1 (
  "lsoa11cd" VARCHAR,
  "lsoa11nm" VARCHAR,
  "ccg19cd" VARCHAR,
  "ccg19cdh" VARCHAR,
  "ccg19nm" VARCHAR,
  "lad19cd" VARCHAR,
  "lad19nm" VARCHAR,
  "fid" BIGINT
);