Version Log
| Version | Version-Date | Changes |
|---|---|---|
| 2025.0.0 | 2025-05-09 | Partial build for testing and JSNA development |
| 2025.1.0 | 2025-06-05 | Full table build excluding 3 practices: - Forest Surgery (F86026) - WF Community & Family Health Services Ltd (F86644) - Beam Park Medical Practice (Y08371) |
| 2025.1.1 | 2025-06-06 | Fixed no patients in CORE_BK_pt and CORE_CH_pt |
lu_ons - Amended short_id for Barking and Dagenham from 'BD' to 'BK' |
||
lu_imd2019 - Amended area_id to lad_id and area2_id to area_id for consistency and improved usability |
||
| 2025.1.2 | 2025-06-16 | Deleted nolonger_homeless_temp table - left by build in error |
Fixed no data in lu_ethnicity2_map table |
||
Fixed bug in db_tables that meant it reported db_tables contained 0 rows |
||
Refreshed db_tables to provide counts forCORE_BK_pt and CORE_CH_pt |
||
| 2025-06-17 | Access provided to ELDB users and CEG staff | |
| 2025.1.3 | 2025-06-20 | Updated db_version for improved version control |
lu_imd2019 - Amended lad_id for Barking and Dagenham from 'BD' to 'BK' |
||
lu_imd2019 - Amended area_id to area2_id, as it contains combined boroughs and added area_id relating to the same geographies used in other tables. |
||
| 2025.2.0 | 2025-07-17 | Regenerated database to incorporate 3 practices that could not be included in initial build: - Forest Surgery (F86026) - Waltham Forest Community & Family Health Services Ltd (F86644) - Beam Park Medical Practice (Y08371) |
Added Beam Park Medical Practice (Y08371) to lu_practice |
||
Rebuilt depression with correct date range (01/04/2006 onwards) - previously built as 01/04/2007 onwards. |
||
Rebuilt cancer with correct date range (01/04/2003 onwards) - previously built as 01/04/2004 onwards. |
||
Added db_counts - previously missing |
||
Replaced db_codeset_ceg with db_codesets that includes all codesets (CEG and PCD) used in ELDB2025 |
||
| 2025.2.1 | 2025-10-24 | Fixed missing age and sex in core for 37 patients . Unable to fix missing age and sex for 4 patients - 3 missing both values, 1 missing age. |
| 2025.2.2 | 2026-01-26 | Added and amended tables for the latest IMD2025 information + changes to ONS UK LAD codes (LAD codes in London are unchanged): - lu_imd2025 - new table containing IMD2025 with quintiles for ICB and LAD- lu_localauthority25 - new table with updated ONS UK Local Authority codes- lu_lsoa2021 - added columns for IMD2025 score, quintile and rank- lu_ons - updated UK LAD codes to 2025 version |
| 2025.2.3 | 2026-03-26 | Amended ethnicity2 lookup tables to include SNOMED codes and ethnic categorisations used in the Scottish 2022 census.: - lu_ethnicity2 - Added SNOMED codes relating to the Scottish 2022 census ethnicity responses. Added columns for associated ethnic_21 categorisation and mapped new and existing SNOMED codes to these categories.- lu_ethnicity2_map - Added columns for the ethnic_21 categorisation. Include new categories:- Showman or Showwoman = W White / W5 Showman or Showwoman - Polish = W White / W6 Polish |
Expanded and adjusted the code mapping in lu_ethnicity2 and recalculated code counts:- Added emis_code column showing mapped EMIS Local codes.- Repositioned r2_code, r3_code and emis_code columns within the table.- Recalculated the code_count (count of code's appearance in observation table) |