Loading Dashboard
VBM EquiWait - Data and Analytics Engineering · NHS Elective Waiting List · May 2026
Analysis Overview

NHS Waiting List Minimum Dataset (WLMDS) Demographic Analysis: Performance, Geography and Equity


From July 2025, NHS England’s demographic WLMDS publication made it possible, for the first time, to see at provider level whether waiting list pressures are distributed equally across age, sex, ethnicity and deprivation groups. This project brings together the most recent releases of data to support commissioners, trust boards and regional teams in identifying performance gaps and targeted support needs.

Situation Summary

Over 7 million people are waiting for elective treatment on the NHS. The 18-week referral-to-treatment (RTT) standard has not been met nationally since 2016, and the pressures that produced the current backlog, a decade of demand growth, workforce constraints, and the profound disruption of COVID-19, are well understood.

The WLMDS data highlights distinct patterns of waiting time variation by specialty, geography and trust, and demographic characteristics:

Specialty
This is where variation is largest, with a 30 percentage point gap separating Ear Nose and Throat (approximately 48% breach rate) from Elderly Medicine (approximately 17%).
Geography and Trust
This shows the next greatest variation, with the East of England running around 5 percentage points above the national average in every month and the North East and Yorkshire running around 5 points below.
Demographic Characteristics
This shows the smallest variation across the three dimensions. Effect sizes are small at the individual level, but specific subgroup patterns are consistent and carry significance for equity monitoring.

Each dimension allows waiting time variation to be examined separately through the lens of specialty, geography and demographic characteristics.

Summary of Findings
FindingWhat the data shows
01Across all months, patients from more socioeconomically deprived areas are over-represented in the longest waiting time bands.Patients in IMD Decile 1 are over-represented in the longest waiting time bands in every month. Over-representation increases steadily with deprivation, from the least to the most deprived deciles. Although the association is small (Cramér’s V = 0.005-0.009), it is consistently non‑random across all eight monthly tests.
02Patients from Indian, Pakistani and Bangladeshi ethnic groups are consistently over‑represented in the 18-52 week waiting time band, with the pattern concentrated in specific specialties.This pattern is observed in all eight months, with a consistent direction of effect. The association is small (Cramér’s V = 0.009-0.013) but persistent. Over‑representation is concentrated in a subset of specialties, including Dermatology, Neurosurgical and General Internal Medicine.
03East of England shows the largest and most persistent regional gapIn all eight months, the East of England records the highest breach and severe breach rates. The overall breach rate runs approximately 4-5 percentage points above the national average, equating to around 32,000-40,000 additional patients in breach at any given snapshot.
04Mid and South Essex illustrates the upper end of trust‑level variation, with consistently high breach rates across all months.The trust has approximately 175,000 patients, with 50-52% in breach, around 10-13 percentage points above the national average. It appears among the ten highest breach rates in every one of the eight months, indicating a sustained trust‑level gap.
05Specialty shows the largest variation in waiting times.There is an approximately 30 percentage point gap between the highest and lowest specialty breach rates. The ordering of specialties is stable across all eight months, and the magnitude of variation by specialty is greater than that observed across regions or demographic groups.
06National waiting list performance is broadly stable at the 18-week threshold, while severe breaches (patients waiting 52+ weeks) have declined over time.At each snapshot, around 2.8 million patients are in breach, with the overall breach rate remaining within a 1 percentage point range across the period. In contrast, the severe breach rate declines from 2.79% to 1.92%, indicating improvement in the longest-waiting cohort while overall breach levels remain stable.
Key Findings
FINDING 01 - Deprivation: A Consistent Gradient in Long Waits
Across all eight monthly snapshots, patients from the most deprived areas are over-represented in long wait bands relative to their share of the waiting list. The gradient runs in the same direction across all deprivation deciles in every month.

Across all eight monthly snapshots (July 2025 to February 2026), patients from more deprived areas are consistently over-represented in longer waiting time bands relative to their share of the overall waiting list. This pattern is monotonic across deprivation deciles and is observed in the same direction in every month without exception.

Patients in IMD Decile 1 (most deprived) consistently account for a higher proportion of long waits than their representation in the total waiting list. This over-representation declines stepwise across deciles through to IMD Decile 10 (least deprived), forming a stable gradient across the full period.

The individual-level association is small (Cramér’s V = 0.005-0.009), based on chi-square tests of independence between waiting band and IMD decile. P-values are adjusted using the Benjamini-Hochberg procedure across 32 tests, with all eight IMD-adjusted p-values < 0.0001. Absolute differences between the most and least deprived groups range from 0.3 to 1.2 percentage points

Taken together, the findings indicate a highly consistent but low-magnitude association. The significance lies in its stability and direction across all months rather than the size of any single effect.

Deprivation and Geography

Trusts and regions serving more deprived populations also tend to have higher breach rates, raising the question of whether the observed deprivation gradient is driven primarily by geography. The WLMDS publication does not allow this relationship to be formally disentangled, because deprivation and geography are correlated and the data are published as aggregated cross-tabulations rather than linked patient-level records, preventing multivariable adjustment.

However, the gradient is observed across organisations with differing overall performance levels, suggesting that deprivation is not solely a proxy for geography within this dataset. It should therefore be considered alongside geographic variation as a related but distinct dimension, while recognising that the two are correlated.

FINDING 02 - Ethnicity: Consistent Over-Representation in Specific Pathways
In every monthly snapshot from July 2025 to February 2026, patients recorded as Indian, Pakistani or Bangladeshi are over-represented in the 18-52 week waiting band relative to their share of the total waiting list. This pattern is consistent across all eight months. The aggregate association is small (Cramér’s V = 0.009-0.013), indicating that most patients in all ethnic groups experience broadly similar waiting times. The finding is therefore defined by its consistency and distribution across groups rather than by effect size.

In every monthly snapshot from July 2025 to February 2026, patients recorded as Indian, Pakistani or Bangladeshi make up a larger share of the 18-52 week wait band than their share of the total waiting list. The same groups appear in the same direction in all eight months. The aggregate Cramér's V for ethnicity is 0.009-0.013 - negligible at the individual level. Most patients in every ethnic group wait similar lengths of time. The finding is noted for its consistency across time and its concentration in specific groups, not for the size of the individual-level effect.

The pattern is not explained by concentration in the highest-breach specialties. Representation is not elevated in Ear Nose and Throat, Oral Surgery or Plastic Surgery, all of which show representation index values at or below parity throughout the period. Instead, over-representation is observed in Dermatology, Neurosurgical and General Internal Medicine, which sit at or below average breach rates overall. This suggests the pattern is not simply driven by entry into the most pressured pathways.

Dermatology: the most stable specialty-level signal
Dermatology provides the clearest and most stable signal. The representation index remains above 1.0 across all months, with patient counts of approximately 3,000-3,700, sufficient to avoid volatility from small numbers. Its breach rate is close to the national average, indicating that over-representation is not explained by poor overall performance within the specialty. By contrast, very small subgroups (fewer than ~100 patients) produce unstable indices and are not treated as reliable signals.

Across all eight months, the persistence of the same directional pattern across the same groups is not plausibly explained by random variation alone. However, the data does not indicate any issue of individual or organisational conduct. It identifies where consistent patterns are observed, not why they arise. Possible explanations such as referral pathways, appointment uptake, or treatment sequencing, cannot be determined from waiting list counts alone.

FINDING 03 - Regional Geography: A Persistent East of England Gap
East of England has the highest breach rate and severe breach rate of any region in every month across the window. North East and Yorkshire has the lowest breach rate in every month. The gap between them has been stable throughout the observation period.

Regional breach rates show a consistent ordering across all eight months. No region switches position materially. East of England leads every regional breach rate chart and every severe breach rate chart throughout. Its waiting list of 757,000-859,000 is the fourth largest of seven regions, so list size alone does not account for the gap. Its breach rate runs approximately 4-5 percentage points above the national average in every month. As a descriptive illustration of scale: if East of England's breach rate were equal to the national average, approximately 32,000-40,000 fewer patients would be in breach at any given snapshot. This figure is offered as a translation of the gap into patient terms, not as a projection or target.

North East and Yorkshire carries a list of 870,000-994,000, comparable in size to East of England, and sits below the national average on breach rate in every month. The observation that two regions of similar size sit at opposite ends of the observed distribution, consistently across eight months, is recorded as a descriptive fact. The data does not establish what accounts for this difference.

September 2025 and the regional picture
September 2025 is the only month where every region shows above-average severe breach rates simultaneously - a feature of that month's data rather than a pattern specific to any one region. The regional ordering is maintained within it. Mid and South Essex sits within East of England and contributes materially to the regional picture, but East of England's breach rate exceeds the national average across its full set of constituent trusts, not only those appearing in the national top ten.

London carries the largest regional list (consistently 1.2-1.3M) and sits near the national average on breach rate throughout, with below-average severe breach rates in most months from December onwards. North West and South East are persistently above the national average on severe breach rate. South West is below average on both metrics in every month with the smallest regional list.

FINDING 04 - Trust-Level Variation: Mid and South Essex as Illustration
The data shows considerable and stable variation in breach rates across trusts. Mid and South Essex illustrates the upper end of that variation - not as an isolated case, but as the clearest example of a pattern visible across a number of persistently high-breach organisations.

Mid and South Essex NHS Foundation Trust carries a breach rate of 50-52% across the window, running 10-13 percentage points above the national average at every snapshot. Its severe breach rate (52 or more weeks) exceeds 7.5% in every month. At approximately 175,000 patients and a severe breach rate of around 8%, approximately 14,000 patients have been waiting more than a year. It appears in the top ten for breach rate in all eight months and holds the highest position in six of them. The WLMDS does not explain what produces this gap.

MonthWaiting ListBreach Ratevs National (pp)Severe Breach Rate
Jul 2025171,96550.39%+10.517.75%
Aug 2025174,72049.95%+9.998.15%
Sep 2025176,71550.02%+10.018.53%
Oct 2025179,40550.29%+11.008.75%
Nov 2025178,75051.18%+12.058.27%
Dec 2025177,56552.49%+12.668.19%
Jan 2026175,29052.56%+12.678.57%
Feb 2026175,27551.75%+12.647.98%

Mid and South Essex is the most visible example, but the wider pattern is one of stable trust-level variation rather than a single outlier. United Lincolnshire Teaching Hospitals and University Hospitals Sussex appear in the top ten in seven of eight months each. James Paget University Hospitals appears in all eight months with a list of approximately 32,000-35,000 patients; a notably different scale to Mid and South Essex, which reinforces that high breach rates are not confined to the largest trusts. Liverpool Women's records a severe breach rate of 12.02% in December at approximately 8,000 patients, illustrating that the headline breach rate does not always surface the most acute concentrations of very long waiters.

FINDING 05 - Specialty: The Largest Source of Variation in Waiting Times
Specialty accounts for the widest range of variation in waiting times observed in the data, with an approximate 30 percentage point gap between the highest and lowest breach rates. This is larger than the approximately 10 percentage point spread across regions and larger than the demographic effects observed in Findings 01 and 02. The pattern is stable across all eight months.

Ear, Nose and Throat has the highest breach rate of any specialty in every month, at approximately 47-50%, consistently 7-10 percentage points above the national average. Oral Surgery is consistently second or joint-first, followed by Plastic Surgery at approximately 42-48%. At the lower end, Elderly Medicine remains around 17% throughout the period, with Other Mental Health and Other services also consistently below the national average.

The ordering of specialties is stable across the eight-month window, with no material movement between high and low-breach categories. The scale of variation indicates that differences in waiting times are greatest when examined by specialty, although the underlying causes are not identifiable from WLMDS data alone.

Why specialty matters for reading the equity findings
The observation that ethnic group over-representation is concentrated in Dermatology, Neurosurgical and General Internal Medicine, rather than in the three highest-breach specialties, is analytically significant because specialty variation is so large. If over-representation tracked specialty breach rates, the pattern would be straightforwardly explained by pathway composition. The fact that it does not means the equity signal in Finding 02 cannot be dismissed as a specialty-mix artefact. Specialty-level variation is therefore important for interpreting the equity findings, as differences between pathways are substantially larger than differences between demographic groups.
FINDING 06 - National Context: Stable Access, Falling Extreme Waits
The national 18-week breach rate moves within a narrow band across the window. The severe breach rate falls from 2.79% to 1.92%, a consistent change from September onwards. This finding provides context rather than new insight from the demographic data.

The national 18-week breach rate opens at 39.87% and closes at 39.11%, moving within a band consistent with normal variation rather than any directional trend. Approximately 2.8 million patients are in breach at every snapshot. This is consistent with published RTT statistics over this period and is noted here as the context within which the other findings sit.

The severe breach rate, the proportion of patients waiting 52 or more weeks, shows a clearer change, falling from 2.79% in July to 1.92% in February. At a list size of approximately 7 million, this corresponds to approximately 61,000 fewer patients waiting more than a year by February compared to July. The WLMDS records this change but does not indicate what actions or factors produced it.

Data note: Sheffield Teaching Hospitals exclusion
Sheffield Teaching Hospitals, carrying approximately 90,000 pathways, is excluded from national and regional totals from October 2025 onwards due to EPR migration. This affects both list size figures and breach rate calculations from October onwards. The severe breach rate improvement is visible from July to September, before the exclusion, indicating it is not solely an artefact of this data change. All comparisons across the full window should be read with this discontinuity in mind.
About this analysis: This analysis uses publicly available NHS England data from the Waiting List Minimum Dataset (WLMDS) demographic publication. All findings are derived from the published data and the methodology described on the Data & Methodology tab. Figures are management information, not official statistics, and should be read with appropriate caution. The patterns identified here reflect the complexity of a large national health system operating under sustained pressure; they are offered as analytical input to support improvement, not as criticism of the individuals and organisations working within it. Sheffield Teaching Hospitals (~90,000 pathways) is excluded from national totals from October 2025 onwards due to EPR migration. Regional figures reflect NHS Acute providers only and exclude Independent Sector and Other pathways.

Methodology: Data pipeline built on Microsoft Fabric using dbt. Analytical model is a star schema with SCD Type-2 geography dimension. Power BI semantic model uses Import mode via the Fabric Warehouse SQL analytics endpoint. All percentage calculations enforce a consistent denominator; suppressed values and pre-computed total rows are handled explicitly in the modelling layer. Representation index values for specialties with very small patient numbers for the selected demographic group (n < 100) should be interpreted with caution as indices may be volatile.
Verulam Blue · Matthew Barr · Analytics Engineering (Microsoft Fabric · dbt · Power BI) May 2026
Data & Methodology

Sources, pipeline architecture and analytical constraints


This page documents the data sources and processing pipeline behind the analysis, and sets out the analytical constraints that shape how the results should be interpreted.

Primary Data Source: WLMDS Demographic Publication

The Waiting List Minimum Dataset (WLMDS) is a weekly data collection submitted by NHS providers to NHS England, in scope since April 2021. Every trust submits data weekly covering open pathways (patients currently waiting), clock starts (new referrals), and clock stops (treatment commencing or patient leaving the list).

NHS England began publishing aggregated WLMDS data monthly in April 2024. The demographic breakdowns, by age, sex, ethnicity and deprivation, were added in July 2025. The demographic publication takes the form of three CSV files released monthly.

FileContentGeographyTime Coverage
Geography Waiting list counts by age, sex, ethnicity and IMD decile, split by waiting band. One row per organisation, demographic category, and waiting band. England, 7 regions, 42 ICBs, 134 NHS acute trusts (183 organisations total) Monthly snapshot - most recent week only
Specialty The same four demographic dimensions cut by the 24 RTT treatment functions. Enables specialty-mix analysis of demographic inequality. England level only Monthly snapshot - most recent week only
Timeseries Historical weekly England-level data by age and sex from September 2021. Ethnicity and IMD are not available in the timeseries - a significant limitation for longitudinal equity analysis. England level only Weekly from September 2021 to present

We have assembled the complete published history: all eight monthly releases from July 2025 to February 2026. NHS England does not maintain a public archive on the publication page. The historical files were retrieved by reconstructing the URL pattern used for each monthly release on the NHS England server. This gives us 24 CSV files in total: 8 Geography, 8 Specialty, and 8 Timeseries snapshots. By stacking the Geography and Specialty snapshots we build the most complete longitudinal picture currently possible of how the demographic composition of the waiting list has evolved.

Dataset Scale
24
CSV files assembled - 8 Geography, 8 Specialty, 8 Timeseries
183
Organisations in the Geography file - England, 7 regions, 42 ICBs, 134 trusts
24
RTT treatment functions in the Specialty file
8 Months
Monthly snapshots assembled - July 2025 to February 2026
7M+
Patients on the NHS elective waiting list
52+wk
Longest waiting band - the primary equity analysis target
Pipeline Architecture

The platform is built end-to-end on Microsoft Fabric. A monthly automated pipeline downloads each new release from NHS England, validates it against expected schema and volumes, and loads it into the Fabric lakehouse. The modelling layer runs in dbt, transforming the raw CSVs through staging and intermediate layers before materialising the mart as tables in the Fabric Warehouse.

LayerMaterialisationSchemaRole
StagingViewsdbt_stagingRaw extraction, type casting, text standardisation, schema validation
IntermediateViewsdbt_intermediateParsing of demographic dimensions, separation of pre-computed total rows, suppression flagging, additivity enforcement
MartTablesdbt_martStar schema dimensions and fact table, ODS hierarchy enrichment, SCD Type-2 geography tracking

The dimensional model is structured as a single fact table holding waiting list counts by demographic group, with dimension tables for provider, specialty, date, waiting band, and demographic category. The provider dimension is enriched with ODS hierarchy data to link each trust to its ICB and region, enabling geographic roll-up and drill-down. SCD Type-2 tracking on the geography dimension ensures that organisational restructures do not silently rewrite historical relationships.

The Power BI semantic model connects to the mart via an Import mode connection to the Fabric Warehouse SQL analytics endpoint. All percentage calculations are computed in DAX with enforced denominator consistency.

Critical Modelling Decisions
Demographic exclusion gap
Patients with unknown demographic information are excluded from the relevant breakdown but remain in the overall total. The sum of counts across demographic categories will therefore never equal the total waiting list count. All percentage calculations use the demographic sub-total as the denominator, not the overall total, and the exclusion gap is surfaced explicitly in the report for every trust and dimension.
Pre-computed total rows and double-counting risk
Each file contains pre-computed total rows (across waiting bands, across demographic categories, and at each geography hierarchy level). Summing across these rows without filtering them out produces double-counting. The intermediate layer flags all total rows explicitly and enforces selection of either detail rows or pre-computed totals - never both - in every downstream model and DAX measure.
Snapshot additivity rule
The Geography and Specialty files are monthly snapshots of an open-pathway count, not flow data. They cannot be summed across time periods. All trend analysis is expressed as month-on-month comparison of snapshot values, not as cumulative totals. This constraint is enforced at the semantic model layer and documented on every time-series visual.
Geography hierarchy additivity
Trust-level figures do not sum to ICB totals, and ICB figures do not sum to regional totals, because the published files include independent rows for each level of the hierarchy. Analysis at each level uses only the rows for that level; cross-level aggregation is not performed.
SUS ethnicity augmentation
Where ethnicity is not recorded in the WLMDS submission, the Secondary Uses Service (SUS) ethnicity record is used instead. This improves coverage but means the ethnicity figures for each trust reflect a combined source. The degree of augmentation varies by trust and is not quantified in the published data. Unrecorded ethnicity rates are tracked in the model and surfaced in the dashboard to allow users to calibrate their confidence in trust-level ethnicity findings.
February 2024 structural break in the timeseries
RTT reporting guidance was updated in February 2024 to remove community service pathways from the data collection, primarily affecting community paediatric services. Approximately 40,000 patient pathways disappeared from the data at this point. The timeseries flag this discontinuity and trend analysis spanning February 2024 is treated with caution.
Known Analytical Constraints
ConstraintDetailImpact
Management information statusWLMDS is subject to less central validation than the monthly RTT official statistics. Trust-level figures should be treated with appropriate caution and validated against RTT totals where possible.Confidence in trust-level figures is lower than for national figures.
No specialty breakdown at trust levelThe Specialty file provides demographic-by-specialty at England level only. Trust-level specialty-demographic intersections are not available in the published data.Specialty-mix analysis of trust-level inequality is not directly possible from the published files.
Timeseries ethnicity and IMD absenceThe Timeseries file contains age and sex only. Ethnicity and IMD longitudinal analysis is limited to the eight Geography snapshots.Trend analysis for ethnicity and deprivation covers eight months only, not the full WLMDS history from September 2021.
Suppression thresholdCount values below the suppression threshold are shown as * rather than a figure. Small demographic groups at small trusts may be systematically suppressed.Equity analysis for minority ethnic groups at smaller trusts is limited.
Count roundingAll count values are rounded to the nearest 5. Percentage calculations using small counts are affected disproportionately.Low absolute impact at trust level for major demographic categories; significant for small groups.
Analytical Focus and Intended Use

This project is designed to support equity-aware performance analysis in a public-sector context, where data is incomplete, reporting conventions change over time, and many of the factors behind observed outcomes sit outside the dataset itself.

The emphasis throughout is on identifying consistent patterns rather than maximising statistical significance, distinguishing scale effects (specialty, geography) from distributional effects (demographic representation), and being explicit about what management information can and cannot support.

The analysis is not intended to optimise operational performance metrics or to rank organisations in isolation. Its purpose is to surface where differences in waiting time experience are persistent, directional, and potentially relevant to equity monitoring, and to do so in a way that is robust to the known limitations of NHS administrative data.

How Methodological Constraints Shape the Equity Findings

The equity findings in this analysis should be read as signals rather than precise measurements. Several features of the data and publication format affect how demographic patterns can be interpreted.

Suppression and rounding
Disproportionately affect smaller demographic groups and smaller organisations, meaning that equity patterns for minority groups at trust level are more likely to be understated than overstated.
Unknown demographic exclusion
Patients with unknown demographic information are excluded from the relevant breakdown. Demographic percentages are calculated on a sub-population whose completeness varies by trust and by dimension, particularly for ethnicity.
Monthly snapshot format
Limits equity analysis to cross-sectional comparison and consistency over time, rather than trajectory or rate-of-change analysis.
No trust-level specialty-demographic intersections
Specialty-specific equity patterns can be identified only at national level, not localised to individual providers.

For these reasons, demographic over or under-representation in long wait bands should be interpreted as an indication of where further investigation may be warranted, not as a definitive measure of inequity or performance.

Use of SUS Ethnicity to Improve Coverage

Where ethnicity is not recorded in the WLMDS submission, the Secondary Uses Service (SUS) ethnicity record is used instead. This is intended to reduce systematic under-representation of patients with missing ethnicity data, which would otherwise bias equity analysis toward trusts with better recording practices rather than better outcomes.

Using SUS improves overall coverage but introduces heterogeneity, as the degree of augmentation varies by trust and is not published. For that reason, ethnicity findings are interpreted cautiously, unrecorded ethnicity rates are surfaced alongside results, and comparisons are framed in terms of consistency and direction rather than precise magnitude.

Leaving ethnicity unaugmented would produce cleaner provenance but materially weaker analytical signal for equity monitoring at national scale.

Data status and interpretation: All data used in this project is drawn from publicly available NHS England publications and processed through a reproducible, documented pipeline. The WLMDS demographic publication is management information and has not been through the same validation processes as the official monthly RTT statistics. Findings should be interpreted as indicative analysis based on the best currently available data, not as authoritative performance assessments. This project is a demonstration of data engineering and analytics engineering capability applied to a real public health equity question.

Data source: NHS England · Waiting List Minimum Dataset (WLMDS) · Demographic Publication · Monthly releases July 2025 to February 2026.
Verulam Blue · Matthew Barr · Analytics Engineering (Microsoft Fabric · dbt · Power BI) May 2026