About this Dataset

Clinical Commissioning Groups To STP (April 2018) Lookup In EN (V2)

A lookup file between clinical commissioning groups (CCGs) and sustainability and transformation partnerships (STP) in England as at 1 April 2018. (File size - 64KB)

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.

The file has been updated to include the merger of 3 STPs - (E54000045, E54000046, E54000047) to form E54000049 - Cumbria and North East STP

Field Names - CCG18CD, CCG18CDH, CCG18NM, STP18CD, STP18NM

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

Field Lengths - 9, 3, 57, 9, 49

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

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_april_2018_lookup_in_en_v2.table_1

11.69 KB
195 rows
6 columns


CREATE TABLE table_1 (
  "ccg18cd" VARCHAR,
  "ccg18cdh" VARCHAR,
  "ccg18nm" VARCHAR,
  "stp18cd" VARCHAR,
  "stp18nm" VARCHAR,
  "fid" BIGINT
);