About this Dataset

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

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

Field Names - CCG21CD, CCG21CDH, CCG21NM, STP21CD, STP21CDH, STP21NM, FID

Field Types - Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 5, 59, 9, 3, 67

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

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_april_2021_lookup_in_en.table_1

10.21 KB
106 rows
7 columns


CREATE TABLE table_1 (
  "ccg21cd" VARCHAR,
  "ccg21cdh" VARCHAR,
  "ccg21nm" VARCHAR,
  "stp21cd" VARCHAR,
  "stp21cdh" VARCHAR,
  "stp21nm" VARCHAR,
  "fid" BIGINT
);