Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
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.
Facebook
TwitterDue 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
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
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
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
Provisional counts of the number of deaths and age-standardised mortality rates involving the coronavirus (COVID-19) in England and Wales. Figures are provided by age, sex, geographies down to local authority level and deprivation indices.
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Facebook
TwitterThis 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
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
United Kingdom recorded 225324 Coronavirus Deaths since the epidemic began, according to the World Health Organization (WHO). In addition, United Kingdom reported 24603076 Coronavirus Cases. This dataset includes a chart with historical data for the United Kingdom Coronavirus Deaths.
Facebook
TwitterAttribution-NonCommercial 4.0 (CC BY-NC 4.0)https://creativecommons.org/licenses/by-nc/4.0/
License information was derived automatically
This Sqlite database contains data publicly available from GOV.UK and can be found here: https://coronavirus.data.gov.uk/. The data is available via a REST API and come data is available in CSV format. However, it can be difficult to pull all this data together, so this Sqlite database contains a number of tables which includes all the data imported via the API.
For more information on how to generate this database, and extract and load the data using the REST API, you can use the additional Jupyter Notebooks which can be found in the following Git Repo: https://github.com/happyadam73/c19-notebooks
Currently this data runs up to 25 February 2022.
NOTE: As of 31st January 2022, publish date based cases include all episodes but historic data has not been updated. It is recommended for historical analysis to use specimen date cases. For more details, see: https://coronavirus.data.gov.uk/details/whats-new/record/beb802ac-1ed2-47ac-b314-69a5c3f712b5
The following provides a list of all 9 tables and the columns that can be found in each table.
| table_name | column_name | column_type | column_nullability |
|---|---|---|---|
| c19dashboard_uk_ltla_daily_metrics | area_type | TEXT | Not Nullable |
| c19dashboard_uk_ltla_daily_metrics | area_name | TEXT | Not Nullable |
| c19dashboard_uk_ltla_daily_metrics | area_code | TEXT | Not Nullable |
| c19dashboard_uk_ltla_daily_metrics | date | DATE | Not Nullable |
| c19dashboard_uk_ltla_daily_metrics | new_cases_by_publish_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_cases_by_publish_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_cases_by_publish_date_rate | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | new_cases_by_specimen_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_cases_by_specimen_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_cases_by_specimen_date_rate | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | new_deaths_28_days_by_publish_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_deaths_28_days_by_publish_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_deaths_28_days_by_publish_date_rate | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | new_deaths_28_days_by_death_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_deaths_28_days_by_death_date | NUMERIC | Nullable |
| c19dashboard_uk_ltla_daily_metrics | cum_deaths_28_days_by_death_date_rate | NUMERIC | Nullable |
| c19dashboard_uk_national_cases_by_age_gender | area_type | TEXT | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | area_name | TEXT | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | area_code | TEXT | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | date | DATE | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | gender | TEXT | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | age | TEXT | Not Nullable |
| c19dashboard_uk_national_cases_by_age_gender | rate | NUMERIC | Nullable |
| ... |
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
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.
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
The number of deaths registered in Leicester including deaths involving coronavirus (Covid-19).The data will be updated weekly.
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
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!
Facebook
TwitterCOVID-19 is a Pandemic which was spread worldwide in the early months of 2020, Which has had a major impact on the United Kingdom. As the UK has recently carried out wide spread vaccination and ended Lockdown I am providing the recent COVID-19 figures.
Several Datasets are provided, focusing on Deaths, Cases, Hospitalisation and Vaccination. Files often protray the same information but from a different reference point. For example for Deaths there is one displaying figures from people who died using there positive date as a reference point, whereas the other is using the date of death.
These datasets was scrapped off the UK Gov website in regards to COVID-19. For those looking to build a more complex project using a constant data flow, they do provide an API which may assist.
Possible area to explore are: What was the Impact of Vaccines on the COVID-19 Pandemic? What was the Impact of a Lockdown on the COVID-19 Pandemic? Which Nation managed the spread of COVID-19 the best?
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
Provisional counts of the number of deaths registered in England and Wales, including deaths involving coronavirus (COVID-19), by local authority, health board and place of death in the latest weeks for which data are available. The occurrence tabs in the 2021 edition of this dataset were updated for the last time on 25 October 2022.
Facebook
Twitterhttps://www.ons.gov.uk/aboutus/whatwedo/statistics/requestingstatistics/approvedresearcherschemehttps://www.ons.gov.uk/aboutus/whatwedo/statistics/requestingstatistics/approvedresearcherscheme
The Public Health Research Database (PHRD) is a linked asset which currently includes Census 2011 data; Mortality Data; Hospital Episode Statistics (HES); GP Extraction Service (GPES) Data for Pandemic Planning and Research data. Researchers may apply for these datasets individually or any combination of the current 4 datasets.
The purpose of this dataset is to enable analysis of deaths involving COVID-19 by multiple factors such as ethnicity, religion, disability and known comorbidities as well as age, sex, socioeconomic and marital status at subnational levels. 2011 Census data for usual residents of England and Wales, who were not known to have died by 1 January 2020, linked to death registrations for deaths registered between 1 January 2020 and 8 March 2021 on NHS number. The data exclude individuals who entered the UK in the year before the Census took place (due to their high propensity to have left the UK prior to the study period), and those over 100 years of age at the time of the Census, even if their death was not linked. The dataset contains all individuals who died (any cause) during the study period, and a 5% simple random sample of those still alive at the end of the study period. For usual residents of England, the dataset also contains comorbidity flags derived from linked Hospital Episode Statistics data from April 2017 to December 2019 and GP Extraction Service Data from 2015-2019.
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
Provisional age-standardised mortality rates for deaths due to COVID-19 by sex, local authority and deprivation indices, and numbers of deaths by middle-layer super output area.
Facebook
Twitterhttps://www.ons.gov.uk/aboutus/whatwedo/statistics/requestingstatistics/approvedresearcherschemehttps://www.ons.gov.uk/aboutus/whatwedo/statistics/requestingstatistics/approvedresearcherscheme
These datasets include all deaths registered in England and Wales for the time periods specified. Data are supplied to ONS by the Local Registration Service, in partnership with the General Register Office (GRO). Coding for cause of death is carried out according to the World Health Organization (WHO) International Classification of Diseases (ICD-10) and internationally agreed rules, allowing for international comparisons.
Deaths registered in England and Wales to those usually resident outside of England and Wales are included. Deaths registered outside of England and Wales to those usually resident in England and Wales are excluded.
This dataset was created to provide timely statistics needed for COVID-19 analysis. Therefore, the provisional death registration data is only to be used only for COVID-19 accredited projects. The data are provisional, and cover the period 2020-2021. For Death registration data prior to this period, please see 'Death registration data - Finalised Extracts.'
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Public Health England (PHE) coronavirus cases reported daily. This data shows case numbers as reported to PHE. Cases includes people who have recovered.
DateVal : dd/mm/yyyy CMODateCount : The number of cases reported for the day CumCases: The cumulative number of cases IncreasePercent: The percentage increase in cases from the previous day DeathPercent: The percentage increase/decrease in daily deaths from the previous day CumCases7DayAvg: 7 day moving average of the cumulative number of cases CumDeaths7DayAvg: 7 day moving average of the cumulative number of deaths DailyDeath7DayAvg: 7 day moving average of the daily number of deaths
IncreasePercent and moving 7 day averages are calculated fields added to the original source.
https://www.gov.uk/government/publications/covid-19-track-coronavirus-cases https://coronavirus.data.gov.uk/
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
This open data publication has moved to COVID-19 Statistical Data in Scotland (from 02/11/2022) Novel coronavirus (COVID-19) is a new strain of coronavirus first identified in Wuhan, China. Clinical presentation may range from mild-to-moderate illness to pneumonia or severe acute respiratory infection. This dataset provides information on demographic characteristics (age, sex, deprivation) of confirmed novel coronavirus (COVID-19) cases, as well as trend data regarding the wider impact of the virus on the healthcare system. Data includes information on primary care out of hours consultations, respiratory calls made to NHS24, contact with COVID-19 Hubs and Assessment Centres, incidents received by Scottish Ambulance Services (SAS), as well as COVID-19 related hospital admissions and admissions to ICU (Intensive Care Unit). Further data on the wider impact of the COVID-19 response, focusing on hospital admissions, unscheduled care and volume of calls to NHS24, is available on the COVID-19 Wider Impact Dashboard. There is a large amount of data being regularly published regarding COVID-19 (for example, Coronavirus in Scotland - Scottish Government and Deaths involving coronavirus in Scotland - National Records of Scotland. Additional data sources relating to this topic area are provided in the Links section of the Metadata below. Information on COVID-19, including stay at home advice for people who are self-isolating and their households, can be found on NHS Inform. All publications and supporting material to this topic area can be found in the weekly COVID-19 Statistical Report. The date of the next release can be found on our list of forthcoming publications. Data visualisation is available to view in the interactive dashboard accompanying the COVID-19 Statistical Report. Please note information on COVID-19 in children and young people of educational age, education staff and educational settings is presented in a new COVID-19 Education Surveillance dataset going forward.
Facebook
Twitterhttps://www.pioneerdatahub.co.uk/data/data-request-process/https://www.pioneerdatahub.co.uk/data/data-request-process/
OMOP dataset: Hospital COVID patients: severity, acuity, therapies, outcomes Dataset number 2.0
Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 6 million cases & more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS) & death. There is a pressing need for tools to stratify patients, to identify those at greatest risk. Acuity scores are composite scores which help identify patients who are more unwell to support & prioritise clinical care. There are no validated acuity scores for COVID-19 & it is unclear whether standard tools are accurate enough to provide this support. This secondary care COVID OMOP dataset contains granular demographic, morbidity, serial acuity and outcome data to inform risk prediction tools in COVID-19.
PIONEER geography The West Midlands (WM) has a population of 5.9 million & includes a diverse ethnic & socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day >100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions in both wave 1 & 2.
EHR. University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services & specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds & 100 ITU beds. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary & secondary care record (Your Care Connected) & a patient portal “My Health”. UHB has cared for >5000 COVID admissions to date. This is a subset of data in OMOP format.
Scope: All COVID swab confirmed hospitalised patients to UHB from January – August 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), presenting complaint, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed & administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support), all outcomes.
Available supplementary data: Health data preceding & following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data. Further OMOP data available as an additional service.
Available supplementary support: Analytics, Model build, validation & refinement; A.I.; Data partner support for ETL (extract, transform & load) process, Clinical expertise, Patient & end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
Age-standardised mortality rates for deaths involving coronavirus (COVID-19), non-COVID-19 deaths and all deaths by vaccination status, broken down by age group.
Facebook
TwitterOpen Government Licence 3.0http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
License information was derived automatically
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.