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.

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.

A List of UK Health Workers Who Have Died from COVID-19

Made machine-readable by hand from data from the UK newspaper "The Guardian", in this article: "Doctors, nurses, porters, volunteers: the UK health workers who have died from Covid-19" https://www.theguardian.com/world/2020/apr/16/doctors-nurses-porters-volunteers-the-uk-health-workers-who-have-died-from-covid-19

The Guardian is continuing to update the list day-by-day, as the COVID-19 pandemic continues. I do not plan to update this dataset, assuming, since the data collection biases are unknown, that nobody else will find it very interesting. I am not a copyright lawyer and do not know if this data is protected copyright, and if so, in which parts of the world.

Caveat: Creating this dataset from a newspaper article required a lot of hand work. I've done my best, but there may be mistakes.

Columns: Name age institution city: I have filled this in myself; I am ignorant of UK geography and there may well be mistakes date_of_death possible_ppe_issue: mostly blank, but I have filled in "yes" where the article mentions a person who had doubts about the adequacy of PPE (personal protective equipment) MED_SPEC: I have attempted to fill in a medical specialty from the values used on the Eurostat web site for Physicians by Medical Specialty" and "Nursing and caring professionals" tables. The idea is to be able to calculate a fraction of affected individuals by specialty.

Provisional counts of the number of deaths and age-standardised mortality rates involving the coronavirus (COVID-19), by occupational groups, for deaths registered between 9 March and 28 December 2020 in England and Wales. Figures are provided for males and females.

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.

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.

The number of deaths registered in Leicester including deaths involving coronavirus (Covid-19).The data will be updated weekly.

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.

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

A new coronavirus designated 2019-nCoV was first identified in Wuhan, the capital of China's Hubei province. People developed pneumonia without a clear cause and for which existing vaccines or treatments were not effective. The virus has shown evidence of human-to-human transmission. You can use this data for Analysis

Content

City Province Country LastUpdate keyID Confirmed Deaths

Acknowledgements

https://rapidapi.com/KishCom/api/covid-19-coronavirus-statistics

Cover Image

https://c.files.bbci.co.uk/D505/production/_115033545_gettyimages-1226314512.jpg

Inspiration

You can use this dataset for analyzing the Covid19 cases in different countries...

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.

The features in the order shown under “Feature name” are: GDP, inter-state distance based on lat-long coordinates, gender, ethnicity, quality of health care facility, number of homeless people, total infected and death, population density, airport passenger traffic, age group, days for infection and death to peak, number of people tested for COVID-19, days elapsed between first reported infection and the imposition of lockdown measures at a given state.

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)

PIONEER: Deeply-phenotyped hospital COVID patients: severity, acuity, therapies, outcomes Dataset number 4.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 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.

Scope: All COVID swab confirmed hospitalised patients to UHB from January – May 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes but also primary care records& clinic letters. 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. Linked images available (radiographs, CT, MRI, ultrasound).

Available supplementary data: Health data preceding & following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data.

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.

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.

Update 2 March 2023: Following the merger of NHS Digital and NHS England on 1st February 2023 we are reviewing the future presentation of the NHS Outcomes Framework indicators. As part of this review, the annual publication which was due to be released in March 2023 has been delayed. Further announcements about this dataset will be made on this page in due course. Directly standardised mortality rate from cardiovascular disease for people aged under 75, per 100,000 population. To ensure that the NHS is held to account for doing all that it can to prevent deaths from cardiovascular disease in people under 75. Some different patterns have been observed in the 2020 mortality data which are likely to have been impacted by the coronavirus (COVID-19) pandemic. Statistics from this period should also be interpreted with care. Legacy unique identifier: P01730

Analysis of ‘Stroke Deaths 30 days hospital admission.’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/mpwolke/cusersmarildownloadsstrokecsv on 14 February 2022.

--- Dataset description provided by original source is as follows ---

Context

Deaths occurring in hospital and after discharge between 0 and 29 days (inclusive) of an emergency admission to hospital with a stroke. This indicator is available for males, females and persons at the following breakdowns: England/Region of residence/Local authority of residence/County of residence/London authority of residence/Provider

https://digital.nhs.uk/data-and-information/publications/clinical-indicators/compendium-of-population-health-indicators/compendium-hospital-care/current/deaths-within-30-days/deaths-within-30-days-of-emergency-admission-to-hospital-stroke-indirectly-standardised-rate-all-ages-annual-trend-f-m-p#

General Enquiries: enquiries@nhsdigital.nhs.uk

Freedom of Information (FOI) requests : FOI Enquiries enquiries@nhsdigital.nhs.uk https://digital.nhs.uk/about-nhs-digital/contact-us/freedom-of-information

Content

Some people with stroke die before they can be admitted to hospital. There are variations in death rates among those who survive long enough to be admitted, and some of these deaths may potentially be preventable. The National Service Framework for older people cites evidence that people who have strokes are more likely to survive if admitted promptly to a hospital-based stroke unit with treatment and care provided by a specialist coordinated stroke team within an integrated service. The National Health Service (NHS) may be helped to prevent some of these deaths by seeing comparative figures and learning lessons from follow-up investigations.

Legacy unique identifier: P02167

Acknowledgements

digital.nhs.uk

Photo by K. Mitch Hodge on Unsplash

Inspiration

Stroke cases among Covid-19 patients outside the risk group that puzzle American doctors. Studies attempt to unravel the relationship between strokes and younger people infected with coronavirus

--- Original source retains full ownership of the source dataset ---

These indicators are designed to accompany the SHMI publication. The SHMI methodology does not make any adjustment for deprivation. This is because adjusting for deprivation might create the impression that a higher death rate for those who are more deprived is acceptable. Patient records are assigned to 1 of 5 deprivation groups (called quintiles) using the Index of Multiple Deprivation (IMD). The deprivation quintile cannot be calculated for some records e.g. because the patient's postcode is unknown or they are not resident in England. Contextual indicators on the percentage of provider spells and deaths reported in the SHMI belonging to each deprivation quintile are produced to support the interpretation of the SHMI. Notes: 1. As of the July 2020 publication, COVID-19 activity has been excluded from the SHMI. The SHMI is not designed for this type of pandemic activity and the statistical modelling used to calculate the SHMI may not be as robust if such activity were included. Activity that is being coded as COVID-19, and therefore excluded, is monitored in the contextual indicator 'Percentage of provider spells with COVID-19 coding' which is part of this publication. 2. Please note that there was a fall in the overall number of spells from March 2020 due to COVID-19 impacting on activity for England and the number has not returned to pre-pandemic levels. Further information at Trust level is available in the contextual indicator ‘Provider spells compared to the pre-pandemic period’ which is part of this publication. 3. There is a shortfall in the number of records for County Durham and Darlington NHS Foundation Trust (trust code RXP), East Lancashire Hospitals NHS Trust (trust code RXR), Guy’s and St Thomas’ NHS Foundation Trust (trust code RJ1), King’s College Hospital NHS Foundation Trust (trust code RJZ) and The Princess Alexandra Hospital NHS Trust (trust code RQW). Values for these trusts are based on incomplete data and should therefore be interpreted with caution. 4. Frimley Health NHS Foundation Trust (trust code RDU) stopped submitting data to the Secondary Uses Service (SUS) during June 2022 and did not start submitting data again until April 2023 due to an issue with their patient records system. This is causing a large shortfall in records and values for this trust should be viewed in the context of this issue. 5. 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. 6. 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.

PIONEER: The impact of ethnicity and multi-morbidity on COVID-related outcomes; a primary care supplemented hospitalised dataset Dataset number 3.0

Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 65million cases and more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS) and death. Evidence suggests that older patients, those from some ethnic minority groups and those with multiple long-term health conditions have worse outcomes. This secondary care COVID dataset contains granular demographic and morbidity data, supplemented from primary care records, to add to the understanding of patient factors on disease outcomes.

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 and 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.

Scope: All COVID swab confirmed hospitalised patients to UHB from January – May 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes but also primary care records and clinic letters. 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. Linked images available (radiographs, CT, MRI, ultrasound).

Available supplementary data: Health data preceding and following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data.

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.

Methods: This was a national, population-based, cross-sectional study of routinely-collected mortality and demographic data pertaining to March-August of 2020 (COVID-19 pandemic) compared to the corresponding periods in 2015-2019. ICD-10-coded causes of death of deceased people of any age were obtained from a national mortality registry of death certificates. The G40-41 ICD-10 codes for epilepsy were used to define epilepsy-related deaths, with or without a U07*1-07*2 ICD-10 code for COVID-19 listed as an additional cause. Deaths unrelated to epilepsy were defined as all remaining Scottish deaths without G40-41 ICD-10 codes listed as a cause. We assessed the number of epilepsy-related deaths in 2020 compared to mean year-to-year variation observed in 2015-2019 (overall, men, women). We assessed proportionate mortality and odds ratios (OR) for deaths with COVID-19 listed as the underlying cause in people with epilepsy-related deaths compared to in deaths unrelated to epilepsy, reporting 95% confidence intervals (95% CIs). Sheet 1 contains a key to the remaining dataset.