About this Dataset

NHS England (Region, Local Office) To NHS England (Region) (April 2019) Lookup In EN

This file is a lookup between NHS England (Region, Local Office) and NHS England (Region) areas, as at 1 April 2019 in England. (File size - 16KB)

This file 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 - NHSRLO19D, NHSRLO19NM, NHSER19CD, NHSER19NM, FID
Field Types - Text, Text, Text, Text, Numeric
Field Lengths - 9, 67, 9, 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/NHSRLO19_NHSER19_EN_LU_9257ee412bfb4676b5a0e6a1e0cfef31/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T04:35:02Z

Tables

Table 1

@ukgov.nhs_england_region_local_office_to_nhs_england_region__02546f2d.table_1

4.81 KB
14 rows
5 columns


CREATE TABLE table_1 (
  "nhsrlo19cd" VARCHAR,
  "nhsrlo19nm" VARCHAR,
  "nhser19cd" VARCHAR,
  "nhser19nm" VARCHAR,
  "fid" BIGINT
);