About this Dataset

Clinical Commissioning Groups To NHSRLO To NHSER (April 2018) 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 2018 in England. (File size - 88KB).

This file includes the newly formed CCGs - NHS Birmingham and Solihull CCG (E38000220), NHS Berkshire West CCG (E38000221), NHS Bristol, North Somerset and South Gloucestershire CCG (E380002220), NHS Buckinghamshire CCG (E38000223), NHS East Berkshire CCG (E38000224) and NHS Leeds CCG (E38000225) It also includes changes to the codes for NHS Fylde and Wyre CCG (E38000226), NHS Greater Preston CCG (E38000227) and NHS Morecambe Bay CCG (E38000228) following a boundary change. It also includes the newly formed NHSRLOs- NHS England South East (Hampshire, Isle of Wight and Thames Valley) (E39000042), NHS England South East (Kent, Surrey and Sussex) (E38000043), NHS England South West (South West North) (E39000043) and NHS England South West (South West South) (E39000044) It also includes the newly formed NHSERs - South East (E40000005) and South West (E40000006)

Field Names - CCG18CD, CCG18CDH, CCG18NM, NHSRLO18CD, NHSRLO18CDH, NHSRLO18NM, NHSER18CD, NHSER18CDH, NHSER18NM

Field Types - Text, Text, Text, Text, Text, Text, Text, Text, Text

Field Lengths - 9, 3, 57, 9, 3, 66, 9, 3, 28

REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/CCG18_NHSRLO18_NHSER18_EN_LU_60faa57d7df74d079451bc50ea10b8cd/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:16:39Z

Tables

Table 1

@ukgov.clinical_commissioning_groups_to_nhsrlo_to_nhser_april_3451ec15.table_1

14.21 kB
195 rows
10 columns

CREATE TABLE table_1 (
  "ccg18cd" VARCHAR,
  "ccg18cdh" VARCHAR,
  "ccg18nm" VARCHAR,
  "nhsrlo18cd" VARCHAR,
  "nhsrlo18cdh" VARCHAR,
  "nhsrlo18nm" VARCHAR,
  "nhser18cd" VARCHAR,
  "nhser18cdh" VARCHAR,
  "nhser18nm" VARCHAR,
  "fid" BIGINT
);