About this Dataset

Clinical Commissioning Groups To STP And NHSER (April 2020) Lookup In EN

This file is a lookup between Clinical Commissioning Groups, Sustainability Transformation Partnerships and NHS England (Region), as at 1 April 2020 in England. (File size - 64KB).

Field Names - CCG20CD, CCG20CDH, CCG20NM, STP20CD, STP20CDH, STP20NM, NHSER20CD, NHSER20CDH, NHSER20NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text, Numeric
Field Lengths - 9, 3, 59, 9, 3, 67, 9, 3, 24

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/CCG20_STP20_NHSER20_EN_LU_acd8286a0ce74bc8a5b1d66e7b90b425/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:15:49Z

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_stp_and_nhser_april_2_0d077325.table_1

13.18 KB
135 rows
10 columns


CREATE TABLE table_1 (
  "ccg20cd" VARCHAR,
  "ccg20cdh" VARCHAR,
  "ccg20nm" VARCHAR,
  "stp20cd" VARCHAR,
  "stp20cdh" VARCHAR,
  "stp20nm" VARCHAR,
  "nhser20cd" VARCHAR,
  "nhser20cdh" VARCHAR,
  "nhser20nm" VARCHAR,
  "fid" BIGINT
);