COVID-19 Consolidated Deaths dataset.

This dataset contains more Covid-19 related information than the standard deaths extract (ADDE).

This dataset is no longer being updated. The last update was approximately November 2022.

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 hospitals in England and had tested positive for COVID-19, and from 25 April, the number of patients where COVID-19 is mentioned on the death certificate and no positive COVID-19 test result was received. Figures are updated each day at 2pm with deaths reported up to 5pm the previous day. There is a delay between the occurrence of a death to it being captured in the daily reporting. The data can be presented both as reported deaths by day and death occurrences by day. Reported occurrences for recent days should be considered incomplete as likely to be revised upwards as more data becomes available. The location of a death reflects the location of the hospital in which it occurred. Source: NHS England COVID-19 Daily Deaths The Office for National Statistics publishes deaths for England and Wales by the week in which they were registered. Due to the delay between the occurrence of a death and its registration, many deaths that occur in a given week will appear in the data for a subsequent week. For 2018, ONS estimated that 74% of deaths were registered within seven days. Additional delays in registration can occur over public holidays, with significant changes in numbers being observable over Easter and Christmas. The location of a death reflects the usual residence of the deceased. There are some differences in total numbers reported for different geographical levels. The figures published at the local authority level have been used in this analysis. The data is updated each Tuesday at 9.30am with data for the week ending eleven days prior. For the 2020 series, ONS has included the number of deaths where coronavirus (COVID-19) was mentioned on the death certificate. This data includes deaths for all places of occurrence. The ONS started publishing deaths in care homes notified to the Care Quality Commission on 28th April for local authorities in England by date of notification. This data includes an additional week of data compared to the main ONS publication. Source: Deaths registered weekly in England and Wales, provisional, Death registrations and occurrences by local authority, Deaths in care homes notified to the Care Quality Commission, report

COVID-19Plots and analysis relating to the coronavirus pandemic. Includes five sets of plots and associated R code to generate them.1) HeatmapsUpdated every few days - heatmaps of COVID-19 case and death trajectories for Local Authorities (or equivalent) in England, Wales, Scotland, Ireland and Germany.2) All cause mortalityUpdated on Tuesday (for England & Wales), Wednesday (for Scotland) and Friday (for Northern Ireland) - analysis and plots of weekly all-cause deaths in 2020 compared to previous years by country, age, sex and region. Also a set of international comparisons using data from mortality.org3) ExposuresNo longer updated - mapping of potential COVID-19 mortality exposure at local levels (LSOAs) in England based on the age-sex structure of the population and levels of poor health.There is also a Shiny app which creates slightly lower resolution versions of the same plots online, which you can find here: https://victimofmaths.shinyapps.io/covidmapper/, on GitHub https://github.com/VictimOfMaths/COVIDmapper and uploaded to this record4) Index of Multiple Deprivation No longer updated - preliminary analysis of the inequality impacts of COVID-19 based on Local Authority level cases and levels of deprivation. 5) Socioeconomic inequalities. No longer updated (unless ONS release more data) - Analysis of published ONS figures of COVID-19 and other cause mortality in 2020 compared to previous years by deprivation decile.Latest versions of plots and associated analysis can be found on Twitter: https://twitter.com/victimofmathsThis work is described in more detail on the UK Data Service Impact and Innovation Lab blog: https://blog.ukdataservice.ac.uk/visualising-high-risk-areas-for-covid-19-mortality/Adapted from data from the Office for National Statistics licensed under the Open Government Licence v.1.0.http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

For the week ending August 29, 2025, weekly deaths in England and Wales were 985 below the number expected, compared with 855 below what was expected in the previous week. In late 2022 and through early 2023, excess deaths were elevated for a number of weeks, with the excess deaths figure for the week ending January 13, 2023, the highest since February 2021. In the middle of April 2020, at the height of the COVID-19 pandemic, there were almost 12,000 excess deaths a week recorded in England and Wales. It was not until two months later, in the week ending June 19, 2020, that the number of deaths began to be lower than the five-year average for the corresponding week. Most deaths since 1918 in 2020 In 2020, there were 689,629 deaths in the United Kingdom, making that year the deadliest since 1918, at the height of the Spanish influenza pandemic. As seen in the excess death figures, April 2020 was by far the worst month in terms of deaths during the pandemic. The weekly number of deaths for weeks 16 and 17 of that year were 22,351, and 21,997 respectively. Although the number of deaths fell to more usual levels for the rest of that year, a winter wave of the disease led to a high number of deaths in January 2021, with 18,676 deaths recorded in the fourth week of that year. For the whole of 2021, there were 667,479 deaths in the UK, 22,150 fewer than in 2020. Life expectancy in the UK goes into reverse In 2022, life expectancy at birth for women in the UK was 82.6 years, while for men it was 78.6 years. This was the lowest life expectancy in the country for ten years, and came after life expectancy improvements stalled throughout the 2010s, and then declined from 2020 onwards. There is also quite a significant regional difference in life expectancy in the UK. In the London borough of Kensington and Chelsea, for example, the life expectancy for men was 81.5 years, and 86.5 years for women. By contrast, in Blackpool, in North West England, male life expectancy was just 73.1 years, while for women, life expectancy was lowest in Glasgow, at 78 years.

CVD-COVID-UK, co-ordinated by the British Heart Foundation (BHF) Data Science Centre (https://bhfdatasciencecentre.org/), is one of the NIHR-BHF Cardiovascular Partnership’s National Flagship Projects.

CVD-COVID-UK aims to understand the relationship between COVID-19 and cardiovascular diseases through analyses of de-identified, pseudonymised, linked, nationally collated health datasets across the four nations of the UK. The consortium has over 400 members across more than 50 institutions including data custodians, data scientists and clinicians, all of whom have signed up to an agreed set of principles with an inclusive, open and transparent ethos.

Approved researchers access data within secure trusted/secure research environments (TREs/SDEs) provided by NHS England (England), the National Safe Haven (Scotland), the Secure Anonymised Information Linkage (SAIL) Databank (Wales) and the Honest Broker Service (Northern Ireland). A dashboard of datasets available in each nation’s TRE can be found here: https://bhfdatasciencecentre.org/areas/cvd-covid-uk-covid-impact/

This dataset represents the linked datasets in SAIL Databank’s TRE for Wales and contains the following datasets: • Welsh Longitudinal GP Dataset - Welsh Primary Care (Daily COVID codes only) (GPCD) • Welsh Longitudinal General Practice Dataset (WLGP) - Welsh Primary Care • Critical Care Dataset (CCDS) • Emergency Department Dataset Daily (EDDD) • Emergency Department Dataset (EDDS) • Outpatient Database for Wales (OPDW) • Outpatient Referral (OPRD) • Patient Episode Dataset for Wales (PEDW) • COVID-19 Test Results (PATD) • COVID-19 Test Trace and Protect (CTTP) - Legacy • COVID-19 Shielded People List (CVSP) • SARS-CoV-2 viral sequencing data (COG-UK data)-Lineage/Variant Data-Wales (CVSD) • Covid Vaccination Dataset (CVVD) • Annual District Death Daily (ADDD) • Annual District Death Extract (ADDE) • COVID-19 Consolidated Deaths (CDDS) • Intensive Care National Audit and Research Centre (ICCD) - Legacy - COVID only • Intensive Care National Audit and Research Centre (ICNC) • Welsh Dispensing Dataset (WDDS) - Legacy • Annual District Birth Extract (ADBE) • Maternity Indicators Dataset (MIDS) • National Community Child Health Database (NCCHD) • Care Home Dataset (CARE) • Congenital Anomaly Register and Information Service (CARS) • Referral to Treatment Times (RTTD) • SAIL Dementia e-Cohort (SDEC) • Welsh Ambulance Services NHS Trust (WASD) • Welsh Demographic Service Dataset (WDSD) • Welsh Results Reports Service (WRRS) • ONS 2011 Census Wales (CENW)

Provisional counts of the number of deaths registered in England and Wales, by age, sex, region and Index of Multiple Deprivation (IMD), in the latest weeks for which data are available.

Dataset description

Daily official UK Covid data. The data is available per country (England, Scotland, Wales and Northern Ireland) and for different regions in England. The different regions are split into two different files as part of the data is directly gathered by the NHS (National Health Service). The files that contain the word 'nhsregion' in their name, include data related to hospitals only, such as number of admissions or number of people in respirators. The files containing the word 'region' in their name, include the rest of the data, such as number of cases, number of vaccinated people or number of tests performed per day. The next paragraphs describe the columns for the different file types.

Region files

Files related to regions (word 'region' included in the file name) have the following columns: - "date": date in YYYY-MM-DD format - "area type": type of area covered in the file (region or nation) - "area name": name of area covered in the file (region or nation name) - "daily cases": new cases on a given date - "cum cases": cumulative cases - "new deaths 28days": new deaths within 28 days of a positive test - "cum deaths 28days": cumulative deaths within 28 days of a positive test - "new deaths_60days": new deaths within 60 days of a positive test - "cum deaths 60days": cumulative deaths within 60 days of a positive test - "new_first_episode": new first episodes by date - "cum_first_episode": cumulative first episodes by date - "new_reinfections": new reinfections by specimen data - "cum_reinfections": cumualtive reinfections by specimen data - "new_virus_test": new virus tests by date - "cum_virus_test": cumulative virus tests by date - "new_pcr_test": new PCR tests by date - "cum_pcr_test": cumulative PCR tests by date - "new_lfd_test": new LFD tests by date - "cum_lfd_test": cumulative LFD tests by date - "test_roll_pos_pct": percentage of unique case positivity by date rolling sum - "test_roll_people": unique people tested by date rolling sum - "new first dose": new people vaccinated with a first dose - "cum first dose": cumulative people vaccinated with a first dose - "new second dose": new people vaccinated with a first dose - "cum second dose": cumulative people vaccinated with a first dose - "new third dose": new people vaccinated with a booster or third dose - "cum third dose": cumulative people vaccinated with a booster or third dose

Country files

Files related to countries (England, Northern Ireland, Scotland and Wales) have the above columns and also: - "new admissions": new admissions, - "cum admissions": cumulative admissions, - "hospital cases": patients in hospitals, - "ventilator beds": COVID occupied mechanical ventilator beds - "trans_rate_min": minimum transmission rate (R) - "trans_rate_max": maximum transmission rate (R) - "trans_growth_min": transmission rate growth min - "trans_growth_max": transmission rate growth max

NHS Region files

Files related to nhsregion (word 'nhsregion' included in the file name) have the following columns: - "new admissions": new admissions, - "cum admissions": cumulative admissions, - "hospital cases": patients in hospitals, - "ventilator beds": COVID occupied mechanical ventilator beds - "trans_rate_min": minimum transmission rate (R) - "trans_rate_max": maximum transmission rate (R) - "trans_growth_min": transmission rate growth min - "trans_growth_max": transmission rate growth max

It's worth noting that the dataset hasn't been cleaned and it needs cleaning. Also, different files have different null columns. This isn't an error in the dataset but the way different countries and regions report the data.

This data covers a time period during the coronavirus (COVID-19) pandemic, which has affected NHS services. During the pandemic, hospital services in Wales were reorganised due to enhanced infection prevention and control measures, and the need to treat COVID and non-COVID patients separately. Subsequently, planned operations were significantly reduced and non-urgent emergency admissions decreased. As a result, hospitals experienced lower occupancy rates in 2020-21 than in previous years. This table presents summary information, from the QueSt1 return, provided by the NHS Wales Informatics Service (NWIS), on bed use in Wales. Data presented in this statistical release are an annual average and illustrate yearly changing occupancy rates and bed availability. Therefore, these data won’t reflect changing levels of activity throughout the year. The data do not present data on average length of stay, turnover interval and bed use factor. These indicators are calculated using data on deaths and discharges which is no longer collected via the QS1 return, and need to be derived from the Patient Episode Database for Wales (PEDW) for 2012-13 onwards. When carrying out more detailed analysis of the deaths and discharges data from PEDW in preparation for the 2012-13 release, data quality issues arose in relation to assessment unit (AU) activity reporting in QS1 and in PEDW and how this should be treated in the data. It was identified that there is inconsistency in the reporting of assessment units, with some LHBs reporting AU activity within their beds data, and others omitting them. This inconsistency in the reporting of AU activity is also likely to affect historic data. Please find information on changes to the data published on NHS beds, as per the given weblink.