About this Dataset

Clinical Commissioning Groups To NHSRLO To NHSER (April 2019) Lookup In EN

This file is a lookup between Clinical Commissioning Groups, NHS England (Region, Local office) and NHS England (Region), as at 1 April 2019 in England. (File size - 104KB).

This file includes the newly formed clinical commissioning groups - NHS Derby and Derbyshire CCG (E38000229) and NHS Devon CCG (E38000230)

This contains the four new NHSRLOs of E39000045 - NHS England Midlands (Central Midlands), E39000046 - NHS England East of England (East), E39000047 - NHS England North East and Yorkshire (Cumbria and North East), and E39000048 - NHS England North East and Yorkshire (Yorkshire and Humber). There are names changes to: E39000026, E39000032, E39000033, E39000037 and E39000040

This file includes the newly formed East of England - (E40000007), Midlands - (E40000008), North East and Yorkshire (E40000009) and North West - (E40000010)

Field Names - CCG19CD, CCG19CDH, CCG19NM, NHSRLO19CD, NHSRLO19CDH, NHSRLO19NM, NHSER19CD, NHSER19CDH, NHSER19NM, FID
Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text, Numeric
Field Lengths - 9, 3, 57, 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/CCG19_NHSRLO19_NHSER19_EN_LU_0dcf1ec50b844f82b9204f1522e411b2/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:35:23Z

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_nhsrlo_to_nhser_april_a8fc31c4.table_1

13.74 KB
191 rows
10 columns


CREATE TABLE table_1 (
  "ccg19cd" VARCHAR,
  "ccg19cdh" VARCHAR,
  "ccg19nm" VARCHAR,
  "nhsrlo19cd" VARCHAR,
  "nhsrlo19cdh" VARCHAR,
  "nhsrlo19nm" VARCHAR,
  "nhser19cd" VARCHAR,
  "nhser19cdh" VARCHAR,
  "nhser19nm" VARCHAR,
  "fid" BIGINT
);