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.

Annual data on death registrations by single year of age for the UK (1974 onwards) and England and Wales (1963 onwards).

The number of deaths registered in England and Wales due to and involving coronavirus (COVID-19). Breakdowns include age, sex, region, local authority, Middle-layer Super Output Area (MSOA), indices of deprivation and place of death. Includes age-specific and age-standardised mortality rates.

This data shows premature deaths (Age under 75), numbers and rates by gender, as 3-year moving-averages. All-Cause Mortality rates are a summary indicator of population health status. All-cause mortality is related to Life Expectancy, and both may be influenced by health inequalities. Directly Age-Standardised Rates (DASR) are shown in the data (where numbers are sufficient) so that death rates can be directly compared between areas. The DASR calculation applies Age-specific rates to a Standard (European) population to cancel out possible effects on crude rates due to different age structures among populations, thus enabling direct comparisons of rates. A limitation on using mortalities as a proxy for prevalence of health conditions is that mortalities may give an incomplete view of health conditions in an area, as ill-health might not lead to premature death. Data source: Office for Health Improvement and Disparities (OHID), Public Health Outcomes Framework (PHOF) indicator ID 108. This data is updated annually.

This mapping tool enables you to see how COVID-19 deaths in your area may relate to factors in the local population, which research has shown are associated with COVID-19 mortality. It maps COVID-19 deaths rates for small areas of London (known as MSOAs) and enables you to compare these to a number of other factors including the Index of Multiple Deprivation, the age and ethnicity of the local population, extent of pre-existing health conditions in the local population, and occupational data. Research has shown that the mortality risk from COVID-19 is higher for people of older age groups, for men, for people with pre-existing health conditions, and for people from BAME backgrounds. London boroughs had some of the highest mortality rates from COVID-19 based on data to April 17th 2020, based on data from the Office for National Statistics (ONS). Analysis from the ONS has also shown how mortality is also related to socio-economic issues such as occupations classified ‘at risk’ and area deprivation. There is much about COVID-19-related mortality that is still not fully understood, including the intersection between the different factors e.g. relationship between BAME groups and occupation. On their own, none of these individual factors correlate strongly with deaths for these small areas. This is most likely because the most relevant factors will vary from area to area. In some cases it may relate to the age of the population, in others it may relate to the prevalence of underlying health conditions, area deprivation or the proportion of the population working in ‘at risk occupations’, and in some cases a combination of these or none of them. Further descriptive analysis of the factors in this tool can be found here: https://data.london.gov.uk/dataset/covid-19--socio-economic-risk-factors-briefing

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

Number of Deaths registered annually in Lincolnshire and Districts, by gender. This ONS data is shown by the deceased person's area of usual residence, so in some cases a death might occur in an area but not be included in its figures. Low values below 5 are suppressed, so some figures may be missing (particularly for smaller geographies), and thus not tally to the numbers shown for larger areas. This dataset is updated annually. Source: Office for National Statistics (ONS). Note: Please be advised that the ONS currently has this dataset under consultation for review (as of 09/01/2025) so may not be updated annually until the review has concluded. The full notice can be found on the dataset source link (Below in the Additional Information section.)

United Kingdom UK: Death Rate: Crude: per 1000 People data was reported at 9.100 Ratio in 2016. This records a decrease from the previous number of 9.200 Ratio for 2015. United Kingdom UK: Death Rate: Crude: per 1000 People data is updated yearly, averaging 11.300 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 12.200 Ratio in 1963 and a record low of 8.700 Ratio in 2011. United Kingdom UK: Death Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s United Kingdom – Table UK.World Bank.WDI: Population and Urbanization Statistics. Crude death rate indicates the number of deaths occurring during the year, per 1,000 population estimated at midyear. Subtracting the crude death rate from the crude birth rate provides the rate of natural increase, which is equal to the rate of population change in the absence of migration.; ; (1) United Nations Population Division. World Population Prospects: 2017 Revision. (2) Census reports and other statistical publications from national statistical offices, (3) Eurostat: Demographic Statistics, (4) United Nations Statistical Division. Population and Vital Statistics Reprot (various years), (5) U.S. Census Bureau: International Database, and (6) Secretariat of the Pacific Community: Statistics and Demography Programme.; Weighted average;

This data shows premature deaths (Age under 75) from Liver Disease, numbers and rates by gender, as 3-year moving-averages. Most liver disease is preventable and much is influenced by alcohol consumption and obesity prevalence, which are both amenable to public health interventions. Directly Age-Standardised Rates (DASR) are shown in the data (where numbers are sufficient) so that death rates can be directly compared between areas. The DASR calculation applies Age-specific rates to a Standard (European) population to cancel out possible effects on crude rates due to different age structures among populations, thus enabling direct comparisons of rates. A limitation on using mortalities as a proxy for prevalence of health conditions is that mortalities may give an incomplete view of health conditions in an area, as ill-health might not lead to premature death. Low numbers may result in zero values or missing data. Data source: Office for Health Improvement and Disparities (OHID), Public Health Outcomes Framework (PHOF) indicator 40601 (E06a). The data is updated annually.

UK monthly death counts per region in the period 2006 - June 2020. This data was extracted and rearranged from the Excel files on these links: England and Wales: https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/monthlyfiguresondeathsregisteredbyareaofusualresidence Scotland: https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/vital-events/general-publications/weekly-and-monthly-data-on-births-and-deaths/monthly-data-on-births-and-deaths-registered-in-scotland Northern Ireland: https://www.nisra.gov.uk/publications/monthly-deaths

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

This report draws on data from the National Child Mortality Database (NCMD) to investigate infection related deaths in children and young people, and to draw out learning and recommendations for service providers and policymakers. This NCMD thematic report aims to identify common characteristics of children and young people who died with and because of an infection, investigate factors associated with these deaths and identify common themes, to help inform policymakers, commissioners, those providing services to children and young people, and those involved in reviewing deaths of children and young people.

Pre-existing conditions of people who died due to COVID-19, broken down by country, broad age group, and place of death occurrence, usual residents of England and Wales.

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.

Provisional deaths registration data for single year of age and average age of death (median and mean) of persons whose death involved coronavirus (COVID-19), England and Wales. Includes deaths due to COVID-19 and breakdowns by sex.

Context

• Coronavirus disease (COVID-19) is an infectious disease caused by a newly discovered coronavirus SARS-CoV2.
• Person to person transmission occurs via several different modes, mainly when people are in close proximity to one another through respiratory droplets.
• Mitigations by various countries have been put into place to limit the spread of this virus.

Content

• ConfirmedCasesByDateReported.csv
• ConfirmedCasesBySpecimenDate.csv
• Deaths.csv
• PatientNewAdmissions.csv
• PatientsInHospital.csv
• PatientsMVBeds.csv
• PCRTesting.csv
• Vaccinations.csv
• VaccinationsDaily.csv

Acknowledgements and Collection Methodology

Data downloaded from https://coronavirus.data.gov.uk

Version

• Version 11 - 25 - Various Files Updated.
• Version 10 - Added VaccinationsDaily File, data upto and including the 20th Jan 2021.
• Version 9 - Updated Deaths file, data upto and including the 20th Jan 2021.
• Version 8 - Updated ConfirmedCasesByDateReported and ConfirmedCasesBySpecimenDate files, data upto and including the 17th to 19th Jan 2021 respectively.
• Version 7 - Updated PatientNewAdmissions, PatientsInHospital and PatientsMVBeds files, data upto and including the 12th to 15th Jan 2020 depending on file.
• Version 6 - Updated PCR Testing file, data upto and including the 14th Jan 2021.
• Version 4 - Updated Vaccinations file, data upto and including the 3rd Jan 2021.
• Version 3 - Updated to include data unto and including the 28th December 2020. Additionally added data on the progress of Vaccinations.
• Version 2 - Updated to include data unto and including the 3rd November 2020.

Title: Monthly War Data on WWI and WWII (Synthetic)

Description: This dataset provides a synthetic month-by-month, country-level representation of key metrics during World War I and World War II. It encompasses key nations involved in the conflicts and aims to showcase patterns and events influenced by historical timelines.

Key Features:

Year: The year of the data entry. Month: The month of the data entry. Country: The nation in focus. The dataset includes the USA, UK, Germany, USSR/Russia, and France. War Status: A binary variable indicating if the war was ongoing for that nation during that month (1 for Yes, 0 for No). Civilian Deaths: An estimated count of civilian deaths during that month. Military Deaths: An estimated count of military deaths during that month. Economic Impact Factor: A fictional index from 0 to 100 indicating the economic strain on the nation (a higher score indicates more strain). Population: Estimated population of the nation during that month. Note:

The data provided in this dataset is synthetically generated and is influenced by historical events and timelines. However, it is not an accurate representation of actual events and should be used with caution for analytical purposes. It is primarily designed for educational and illustrative tasks, allowing users to practice data analysis techniques in a historically-inspired context.

Excess Winter Deaths (EWD) by age and conditions (underlying cause of death) expressed as average per year based on 7 years pooled data, 2004-2011. EWD trend expressed as average per year based on 3 years data. The Excess Winter Mortality Index (EWM Index was calculated based on the 'ONS Method' which defines the winter period as December to March, and the non-winter period as August to November of that same year and April to July of the following year. This winter period was selected as they are the months which over the last 50 years have displayed above average monthly mortality. However, if mortality starts to increase prior to this, for example in November, the number of deaths in the non-winter period will increase, which in turn will decrease the estimate of excess winter mortality. The EWM Index will be partly dependent on the proportion of older people in the population as most excess winter deaths effect older people (there is no standardisation in this calculation by age or any other factor). Excess winter mortality is calculated as winter deaths (deaths occurring in December to March) minus the average of non-winter deaths (April to July of the current year and August to November of the previous year). The Excess winter mortality index is calculated as excess winter deaths divided by the average non-winter deaths, expressed as a percentage. Relevant link: http://www.wmpho.org.uk/excesswinterdeathsinEnglandatlas/

11th January 2020 Change to vaccination data made available by UK gov - now just cumulative number of vaccines delivered are available for both first and second doses. For the devolved nations the cumulative totals are available for the dates from when given, however for the UK as a whole the total doses given is just on the last date of the index, regardless of when those vaccines were given.

4th January 2020 VACCINATION DATA ADDED - New and Cumulative First Dose Vaccination Data added to UK_National_Total_COVID_Dataset.csv and UK_Devolved_Nations_COVID_Dataset.csv

2nd December 2020:

NEW population, land area and population density data added in file NEW_Official_Population_Data_ONS_mid-2019.csv. This data is scraped from the Office for National Statistics and covers the UK, devolved UK nations, regions and local authorities (boroughs).

20th November 2020:

With European governments struggling with a 'second-wave' of rising cases, hospitalisations and deaths resulting from the SARS-CoV-2 virus (COVID-19), I wanted to make a comparative analysis between the data coming out of major European nations since the start of the pandemic.

I started by creating a Sweden COVID-19 dataset and now I'm looking at my own country, the United Kingdom.

The data comes from https://coronavirus.data.gov.uk/ and I used the Developer's Guide to scrape the data, so it was a fairly simple process. The notebook that scapes the data is public and can be found here. Further information about data collection methodologies and definitions can be found here.

The data includes the overall numbers for the UK as a whole, the numbers for each of the devolved UK nations (Eng, Sco, Wal & NI), English Regions and Upper Tier Local Authorities (UTLA) for all of the UK (what we call Boroughs). I have also included a small table with the populations of the 4 devolved UK nations, used to calculate the death rates per 100,000 population.

As I've said for before - I am not an Epidemiologist, Sociologist or even a Data Scientist. I am actually a Mechanical Engineer! The objective here is to improve my data science skills and maybe provide some useful data to the wider community.

Any questions, comments or suggestions are most welcome! I am open to requests and collaborations! Stay Safe!