About this Dataset

Clinical Commissioning Groups To STP (April 2019) Lookup In EN

A lookup file between clinical commissioning groups (CCGs), sustainability and transformation partnerships (STP) in England as at 1st April

2019. (File size - 56KB)

Field Names - CCG19CD, CCG19CDH, CCG19NM, STP19CD, STP19NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 3, 57, 9, 58,

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.

File includes the merger of NHS Erewash CCG, NHS Hardwick CCG, NHS North Derbyshire CCG, and NHS Southern Derbyshire CCG to form E38000229 (15M) - NHS Derby and Derbyshire CCG and the merger of NHS Northern, Eastern and Western Devon CCG and NHS South Devon and Torbay CCG to form E38000230 (15N) - NHS Devon CCG

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

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_april_2019_lookup_in_en.table_1

11.87 KB
191 rows
6 columns


CREATE TABLE table_1 (
  "ccg19cd" VARCHAR,
  "ccg19cdh" VARCHAR,
  "ccg19nm" VARCHAR,
  "stp19cd" VARCHAR,
  "stp19nm" VARCHAR,
  "fid" BIGINT
);