About this Dataset

Local Authority District To PHEC To PHEREG (December 2019) Lookup In EN

This is a lookup file between local authority districts, Public Health England Centres and Public Health England Regions in England as at 31st December 2019. (File Size - 26 KB)Field Names - LAD19CD, LAD19NM, PHEC19CD, PHEC19CDH, PHEC19NM, PHEREG19CD, PHEREG19CDH, PHEREG19NM, FID

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

Field Lengths - 9, 35, 9, 8, 20, 9, 6, 28

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/LAD19_PHEC19_PHEREG19_EN_LU_38a702459dca46bd83d9f925ba32ef73/FeatureServer
Publisher name: Office for National Statistics
Last updated: 2024-12-10T02:53:46Z

Tables

Table 1

@ukgov.local_authority_district_to_phec_to_phereg_december_20_aafdd8dd.table_1

13.96 KB
317 rows
9 columns


CREATE TABLE table_1 (
  "lad19cd" VARCHAR,
  "lad19nm" VARCHAR,
  "phec19cd" VARCHAR,
  "phec19cdh" VARCHAR,
  "phec19nm" VARCHAR,
  "phereg19cd" VARCHAR,
  "phereg19cdh" VARCHAR,
  "phereg19nm" VARCHAR,
  "fid" BIGINT
);