This publication of the SHMI relates to discharges in the reporting period June 2023 - May 2024. The SHMI is the ratio between the actual number of patients who die following hospitalisation at the trust and the number that would be expected to die on the basis of average England figures, given the characteristics of the patients treated there. The SHMI covers patients admitted to hospitals in England who died either while in hospital or within 30 days of being discharged. To help users of the data understand the SHMI, trusts have been categorised into bandings indicating whether a trust's SHMI is 'higher than expected', 'as expected' or 'lower than expected'. For any given number of expected deaths, a range of observed deaths is considered to be 'as expected'. If the observed number of deaths falls outside of this range, the trust in question is considered to have a higher or lower SHMI than expected. The expected number of deaths is a statistical construct and is not a count of patients. The difference between the number of observed deaths and the number of expected deaths cannot be interpreted as the number of avoidable deaths or excess deaths for the trust. The SHMI is not a measure of quality of care. A higher than expected number of deaths should not immediately be interpreted as indicating poor performance and instead should be viewed as a 'smoke alarm' which requires further investigation. Similarly, an 'as expected' or 'lower than expected' SHMI should not immediately be interpreted as indicating satisfactory or good performance. Trusts may be located at multiple sites and may be responsible for 1 or more hospitals. A breakdown of the data by site of treatment is also provided, as well as a breakdown of the data by diagnosis group. Further background information and supporting documents, including information on how to interpret the SHMI, are available on the SHMI homepage (see Related Links).

NHS UK - COVID-19 Daily Deaths

This section contains information on deaths of patients who have died in hospitals in England and had tested positive for COVID-19 at time of death. All deaths are recorded against the date of death rather than the date the deaths were announced. Interpretation of the figures should take into account the fact that totals by date of death, particularly for most recent days, are likely to be updated in future releases. For example as deaths are confirmed as testing positive for COVID-19, as more post-mortem tests are processed and data from them are validated. Any changes are made clear in the daily files.

These figures do not include deaths outside hospital, such as those in care homes. This approach makes it possible to compile deaths data on a daily basis using up to date figures.

Dataset Content

These figures will be updated at 2pm each day and include confirmed cases reported at 5pm the previous day. Confirmation of COVID-19 diagnosis, death notification and reporting in central figures can take up to several days and the hospitals providing the data are under significant operational pressure. This means that the totals reported at 5pm on each day may not include all deaths that occurred on that day or on recent prior days.

The original dataset is sourced directly from the NHS source site, this original dataset is then cleaned and converted to a csv format available for inclusion into a Kaggle notebook.

There are 3 files considered within the data :- 1. Fatalities_by_age_uk 2.Fatalities_by_region_uk 3.Fatalities_by_trust_uk

Data runs from March 1st up to the current day. Any discrepancies will be outlined. The first is cumulative for any previous days leading up to of relevance. The following days are not cumulative and represent the updated value for the date under consideration.

A start kernel is provided to demonstrate using the dataset.

Citations

This dataset is sourced from the NHS statistical work areas:- https://www.england.nhs.uk/statistics/statistical-work-areas/

This dataset has been sourced and provided to aid in the following competition:- https://www.kaggle.com/c/covid19-global-forecasting-week-4

Due to changes in the collection and availability of data on COVID-19 this page will no longer be updated. The webpage will no longer be available as of 11 May 2023. On-going, reliable sources of data for COVID-19 are available via the COVID-19 dashboard, Office for National Statistics, and the UKHSA

This page provides a weekly summary of data on deaths related to COVID-19 published by NHS England and the Office for National Statistics. More frequent reporting on COVID-19 deaths is now available here, alongside data on cases, hospitalisations, and vaccinations. This update contains data on deaths related to COVID-19 from:

NHS England COVID-19 Daily Deaths - last updated on 28 June 2022 with data up to and including 27 June 2022.


ONS weekly deaths by Local Authority - last updated on 16 August 2022 with data up to and including 05 August 2022.

Summary notes about each these sources are provided at the end of this document.

Note on interpreting deaths data: statistics from the available sources differ in definition, timing and completeness. It is important to understand these differences when interpreting the data or comparing between sources.

Weekly Key Points

An additional 24 deaths in London hospitals of patients who had tested positive for COVID-19 and an additional 5 where COVID-19 was mentioned on the death certificate were announced in the week ending 27 June 2022. This compares with 40 and 3 for the previous week. A total of 306 deaths in hospitals of patients who had tested positive for COVID-19 and 27 where COVID-19 was mentioned on the death certificate were announced for England as whole. This compares with 301 and 26 for the previous week. The total number of COVID-19 deaths reported in London hospitals of patients who had tested positive for COVID-19 is now 19,102. The total number of deaths in London hospitals where COVID-19 was mentioned on the death certificate is now 1,590. This compares to figures of 119,237 and 8,197 for English hospitals as a whole. Due to the delay between death occurrence and reporting, the estimated number of deaths to this point will be revised upwards over coming days These figures do not include deaths that occurred outside of hospitals. Data from ONS has indicated that the majority (79%) of COVID-19 deaths in London have taken place in hospitals.

Recently announced deaths in Hospitals

21 June 22 June 23 June 24 June 25 June 26 June 27 June London No positive test 0 0 1 4 0 0 0 London Positive test 3 7 2 10 0 0 2 Rest of England No positive test 2 6 4 4 0 0 6 Rest of England Positive test 47 49 41 58 6 0 81

16 May 23 May 30 May 06 June 13 June 20 June 27 June London No positive test 14 3 4 0 4 3 5 London Positive test 45 34 55 20 62 40 24 Rest of England No positive test 41 58 33 23 47 23 22 Rest of England Positive test 456 375 266 218 254 261 282 Deaths by date of occurrence

21 June 22 June 23 June 24 June 25 June 26 June 27 June London 20,683 20,686 20,690 20,691 20,692 20,692 20,692 Rest of England 106,604 106,635 106,679 106,697 106,713 106,733 106,742 Interpreting the data The data published by NHS England are incomplete due to:

delays in the occurrence and subsequent reporting of deaths deaths occurring outside of hospitals not being included

The total deaths reported up to a given point are therefore less than the actual number that have occurred by the same point. Delays in reporting NHS provide the following guidance regarding the delay between occurrence and reporting of deaths: Confirmation of COVID-19 diagnosis, death notification and reporting in central figures can take up to several days and the hospitals providing the data are under significant operational pressure. This means that the totals reported at 5pm on each day may not include all deaths that occurred on that day or on recent prior days. The data published by NHS England for reporting periods from April 1st onward includes both date of occurrence and date of reporting and so it is possible to illustrate the distribution of these reporting delays. This data shows that approximately 10% of COVID-19 deaths occurring in London hospitals are included in the reporting period ending on the same day, and that approximately two-thirds of deaths were reported by two days after the date of occurrence.

Deaths outside of hospitals The data published by NHS England does not include deaths that occur outside of hospitals, i.e. those in homes, hospices, and care homes. ONS have published data for deaths by place of occurrence. This shows that, up to 05 August, 79% of deaths in London recorded as involving COVID-19 occurred in hospitals (this compares with 44% for all causes of death). This would suggest that the NHS England data may underestimate overall deaths from COVID-19 by around 20%.

Comparison of data sources

Note on data sources

NHS England provides numbers of patients who have died in hos

The SHMI is the ratio between the actual number of patients who die following hospitalisation at the trust and the number that would be expected to die on the basis of average England figures, given the characteristics of the patients treated there. It includes deaths which occurred in hospital and deaths which occurred outside of hospital within 30 days (inclusive) of discharge. The SHMI gives an indication for each non-specialist acute NHS trust in England whether the observed number of deaths within 30 days of discharge from hospital was 'higher than expected' (SHMI banding=1), 'as expected' (SHMI banding=2) or 'lower than expected' (SHMI banding=3) when compared to the national baseline. Trusts may be located at multiple sites and may be responsible for 1 or more hospitals. A breakdown of the data by site of treatment is also provided. The SHMI is composed of 144 different diagnosis groups and these are aggregated to calculate the overall SHMI value for each trust. The number of finished provider spells, observed deaths and expected deaths at diagnosis group level for each trust is available in the SHMI diagnosis group breakdown files. For a subset of diagnosis groups, an indication of whether the observed number of deaths within 30 days of discharge from hospital was 'higher than expected', 'as expected' or 'lower than expected' when compared to the national baseline is also provided. Details of the 144 diagnosis groups can be found in Appendix A of the SHMI specification. Notes: 1. On 1st January 2025, North Middlesex University Hospital NHS Trust (trust code RAP) was acquired by Royal Free London NHS Foundation Trust (trust code RAL). Due to processing issues, we are currently producing separate indicator values for these trusts in the SHMI data. Data for the merged organisation will be produced at a future date. 2. There is a high percentage of records with a missing NHS Number for Wirral University Teaching Hospital NHS Foundation Trust (trust code RBL). Values for this trust are based on incomplete data and should therefore be interpreted with caution. 3. There is a shortfall in the number of records for North Middlesex University Hospital NHS Trust (trust code RAP), Northumbria Healthcare NHS Foundation Trust (trust code RTF), Somerset NHS Foundation Trust (trust code RH5), The Rotherham NHS Foundation Trust (trust code RFR), The Shrewsbury and Telford Hospital NHS Trust (trust code RXW), and Wirral University Teaching Hospital NHS Foundation Trust (trust code RBL). Values for these trusts are based on incomplete data and should therefore be interpreted with caution. 4. There is a high percentage of records with missing data for the Sex field for Guy’s and St Thomas’ NHS Foundation Trust (trust code RJ1) and University Hospitals Dorset NHS Foundation Trust (trust code R0D). Values for these trusts should therefore be interpreted with caution. 5. There is a high percentage of invalid diagnosis codes for Chesterfield Royal Hospital NHS Foundation Trust (trust code RFS), East Lancashire Hospitals NHS Trust (trust code RXR), Harrogate and District NHS Foundation Trust (trust code RCD), Milton Keynes University Hospital NHS Foundation Trust (trust code RD8), Portsmouth Hospitals University NHS Trust (trust code RHU), Royal United Hospitals Bath NHS Foundation Trust (trust code RD1), University Hospitals of North Midlands NHS Trust (trust code RJE), and University Hospitals Plymouth NHS Trust (trust code RK9). Values for these trusts should therefore be interpreted with caution. 6. A number of trusts are now submitting Same Day Emergency Care (SDEC) data to the Emergency Care Data Set (ECDS) rather than the Admitted Patient Care (APC) dataset. The SHMI is calculated using APC data. Removal of SDEC activity from the APC data may impact a trust’s SHMI value and may increase it. More information about this is available in the Background Quality Report. 7. Further information on data quality can be found in the SHMI background quality report, which can be downloaded from the 'Resources' section of this page.

Legacy unique identifier: P00085

England

England

Notes:

Notes:

Notes:

England

Notes:

England

Notes:

Notes:

Notes:

Notes:

Legacy unique identifier: P00247