Clinical Commissioning Groups To STP (April 2020) Lookup In EN
Office for National Statistics
@ukgov.clinical_commissioning_groups_to_stp_april_2020_lookup_in_en
Office for National Statistics
@ukgov.clinical_commissioning_groups_to_stp_april_2020_lookup_in_en
A lookup file between clinical commissioning groups (CCGs), sustainability and transformation partnerships (STP) in England as at 1st April 2020. (File size - 48KB)
Field Names - CCG20CD, CCG20CDH, CCG20NM, STP20CD, STP20CDH, STP20NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text
Field Lengths - 9, 3, 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/CCG20_STP20_EN_LU_23f15570782b4e388a885fe8842d0858/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:19:32Z
CREATE TABLE table_1 (
"ccg20cd" VARCHAR,
"ccg20cdh" VARCHAR,
"ccg20nm" VARCHAR,
"stp20cd" VARCHAR,
"stp20cdh" VARCHAR,
"stp20nm" VARCHAR,
"fid" BIGINT
);Anyone who has the link will be able to view this.