About this Dataset

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

A lookup file between clinical commissioning groups (CCGs), sustainability and transformation partnerships (STP) and Cancer Alliances / National Cancer Vanguards (CALNCV) in England as at 1 April 2018. (File size - 64 KB)
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.

This 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, CALNCV18CD, CALNCV18NM
Field Types - Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 3, 57, 9, 49, 9, 61

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

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_to_cal_and_ncv_ap_7f31366c.table_1

13.6 KB
195 rows
8 columns


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