About this Dataset

Clinical Commissioning Groups To STP To CAL And NCV (April 2017) Lookup In EN (V3)

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 2017.

The version 3 of the lookup supersedes the previous version of the same name and contains:

We were notified of a late CCG change between NHS Norwich CCG and NHS South Norfolk CCG. Eight LSOAs were moved from NHS South Norfolk CCG to NHS Norwich CCG. The eight LSOAs were E01026895, E01033538, E01033540, E01026924, E01026925, E01026916, E01026917 and E01026918 and have now been allocated to NHS Norwich CCG and the lookup have been recreated as V3. Please note that NHS Norwich CCG (E38000218) and NHS South Norfolk CCG (E38000219) have new 9 character codes. (09/05/2017).

Previous corrections include:

The newly formed clinical commissioning groups - NHS Cumbria CCG (E38000215), NHS Morecambe Bay CCG (E38000216) and NHS Manchester CCG (E38000217) and means that NHS Cumbria CCG is not split between two STPs.
A name change for NHS Cumbria CCG to NHS North Cumbria CCG (05/05/2017)

(File Size - 72 KB)

Column Descriptions:

CCG17CD | Text | 9

CCG17CDH | Text | 3

CCG17NM | Text | 54

STP17CD | Text | 9

STP17NM | Text | 65

CALNCV17CD | Text | 9

CALNCV17NM | Text | 61

FID | Number | 3

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

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_to_cal_and_ncv_ap_b17711c2.table_1

14.56 kB
207 rows
8 columns

CREATE TABLE table_1 (
  "ccg17cd" VARCHAR,
  "ccg17cdh" VARCHAR,
  "ccg17nm" VARCHAR,
  "stp17cd" VARCHAR,
  "stp17nm" VARCHAR,
  "calncv17cd" VARCHAR,
  "calncv17nm" VARCHAR,
  "fid" BIGINT
);