Skip to content

Changes from ELDB 2024

Data

All data has been rerun from 01/04/2025.

Core

Updated to include the new ethnicity and IMD fields (see below) LSOA has calculated from patient's postcode to ensure a precise definition for lsoa2021

  • Removed column ceg_16
  • Removed column nhs_5
  • Added column ethnic_5 - ethnicity 5+1 (2011) categorisation
  • Added column ethnic_16 - ethnicity 16+1 categorisation
  • Added column ethnic_18 - ethnicity 18+1 categorisation
  • Added column ethnic_19 - ethnicity 19+1 categorisation
  • Added column pt_lad2023 - LAD ONS code (2023) based on patient's identified current address
  • Added column imd2019 - Indices of Multiple Deprivation score calculated by ONS in 2019 (England only)
  • Added column imd2019_rank - IMD rank by country calculated by ONS
  • Added column lsoa2021 - ONS (e-code) for LSOA 2021

Database Info

  • Added table db_clusters - NHS and CEG code clusters used to build tables
  • Added table db_codeset_ceg - CEG code clusters used in ELDB

Ethnicity

Updated ethnicity tables to improve consistency and quality of groupings and incorporate the 2021 census categorisations.

LSOA and IMD

Updated LSOA and IMD tables to provide better incorporation of LSOA 2021 and greater information on LSOAs outside NEL.

  • Removed table lu_lsoa
  • Removed table lu_deprivation
  • Added table lu_imd2019 - IMD ranking and quintiles
  • Added table lu_localauthority - Local Authorities for UK
  • Added table lu_ons - ONS codes for UK geographies (Local Authorities, ICBs, Regions etc)
  • Improved quintile calculation in lu_imd2019 distributing uneven counts to first quintiles rather than last.
  • ONS datasets have two changes in north east London LSOAs:
    • LSOA E01003482 has been reclassified from LB Newham (2019) to LB Barking and Dagenham (2023)
    • LSOA E01004252 has been reclassified from LB Tower Hamlets (2019) to LB Newham (2023)