Estimates of differences in coronavirus (COVID-19) mortality risk by self-reported disability status for deaths occurring up to 9 March 2022, using linked data from the Office for National Statistics’ Public Health Data Asset.

Findings from the Coronavirus (COVID-19) Infection Survey for England.

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/

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.

Age-standardised mortality rates (ASMRs) for deaths involving COVID-19 by ethnic group, England.

In early-February 2020, the first cases of COVID-19 in the United Kingdom (UK) were confirmed. The number of cases in the UK increased significantly at the end of 2021. On January 13, 2023, the number of confirmed cases in the UK amounted to 24,243,393. COVID deaths among highest in Europe There were 202,157 confirmed coronavirus deaths in the UK as of January 13, 2023. For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Current infection rate in Europe The current infection rate in the UK was 50 cases per 100,000 population in the last seven days as of January 16. San Marino had the highest seven day rate of infections in Europe at 336.

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

Headline estimates for England, Wales, Northern Ireland and Scotland. 

In early-February, 2020, the first cases of the coronavirus (COVID-19) were reported in the United Kingdom (UK). The number of cases in the UK has since risen to 24,243,393, with 1,062 new cases reported on January 13, 2023. The highest daily figure since the beginning of the pandemic was on January 6, 2022 at 275,646 cases.

COVID deaths in the UK COVID-19 has so far been responsible for 202,157 deaths in the UK as of January 13, 2023, and the UK has one of the highest death toll from COVID-19 in Europe. As of January 13, the incidence of deaths in the UK is 298 per 100,000 population.

Regional breakdown The South East has the highest amount of cases in the country with 3,123,050 confirmed cases as of January 11. London and the North West have 2,912,859 and 2,580,090 cases respectively.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Context

Public Health England (PHE) coronavirus cases reported daily. This data shows case numbers as reported to PHE. Cases includes people who have recovered.

Content

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.

Acknowledgements

https://www.gov.uk/government/publications/covid-19-track-coronavirus-cases https://coronavirus.data.gov.uk/

In early-February 2020, the first cases of COVID-19 in the United Kingdom (UK) were confirmed. As of December 2023, the South East had the highest number of confirmed first episode cases of the virus in the UK with 3,180,101 registered cases, while London had 2,947,727 confirmed first-time cases. Overall, there has been 24,243,393 confirmed cases of COVID-19 in the UK as of January 13, 2023.

COVID deaths in the UK COVID-19 was responsible for 202,157 deaths in the UK as of January 13, 2023, and the UK had the highest death toll from coronavirus in western Europe. The incidence of deaths in the UK was 297.8 per 100,000 population as January 13, 2023.

Current infection rate in Europe The infection rate in the UK was 43.3 cases per 100,000 population in the last seven days as of March 13, 2023. Austria had the highest rate at 224 cases per 100,000 in the last week.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

The COVID-19 Health Inequalities Monitoring in England (CHIME) tool brings together data relating to the direct impacts of coronavirus (COVID-19) on factors such as mortality rates, hospital admissions, confirmed cases and vaccinations.

By presenting inequality breakdowns - including by age, sex, ethnic group, level of deprivation and region - the tool provides a single point of access to:

• show how inequalities have changed during the course of the pandemic and what the current cumulative picture is
• bring together data in one tool to enable users to access and use the intelligence more easily
• provide indicators with a consistent methodology across different data sets to facilitate understanding
• support users to identify and address inequalities within their areas, and identify priority areas for recovery

In the March 2023 update, data has been updated for deaths, hospital admissions and vaccinations. Data on inequalities in vaccination uptake within upper tier local authorities has been added to the tool for the first time. This replaces data for lower tier local authorities, published in December 2022, allowing the reporting of a wider range of inequality breakdowns within these areas.

Please send any questions or comments to PHA-OHID@dhsc.gov.uk

Virus Watch will provide data relevant to a wide range of audiences involved in pandemic response. Virus Watch has collected personal and special category data.

Baseline survey – the baseline survey collects basic demographic information including sex, date of birth, age in years, ethnicity. It also includes details of the household structure, socioeconomic status including household income. The survey also collects health data used for the study including existing medical conditions (general and COVID-related) and access to health during the pandemic.

Weekly survey – the weekly survey collects data about any illnesses within the household during each week and the results of any COVID tests performed. The survey collects information on behaviours during illness of the household. Since Jan 2021, the weekly survey has also collected data on vaccination status of household members.

Monthly surveys – the monthly surveys collect regular data on contact patterns of household throughout the pandemic, regardless of symptoms or illnesses in the household. Each month additional bespoke questions have been asked in the monthly surveys in order to inform important policy questions at the time.

Laboratory data – the laboratory data includes information on the results of antibody tests for a subset of participants including nucleocapsid and spike antibody levels. It also includes PCR results for participants that took part in home COVID testing for Virus Watch.

COVID-19 Cases in England

Tracking Infection Risk at a Local Level

By Dan Winchester [source]

About this dataset

This dataset contains the total number of confirmed COVID-19 cases in each English Upper Tier Local Authority over the past eight days. Aggregated from Public Health England data, this dataset provides unprecedented insight into how quickly the virus has been able to spread in local communities throughout England. Despite testing limitations, understanding these localized patterns of infection can help inform important public health decisions by local authorities and healthcare workers alike.

It is essential to bear in mind that this data is likely an underestimation of true infection rates due to limited testing -- it is critical not to underestimate the risk the virus poses on a local scale! Use this dataset at your own discretion with caution and care; consider supplementing it with other health and socio-economic metrics for a holistic picture of regional trends over time.

This dataset features information surrounding GSS codes and names as well as total numbers of recorded COVID-19 cases per English Upper Tier Local Authority on January 5th 2023 (TotalCases_2023-01-05)

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

Research Ideas

• Comparing the total cases in each local authority to population density of the region, to identify areas with higher incidence of virus
• Tracking changes in total cases over a period of time to monitor trend shifts and detect possible outbreak hotspots
• Establishing correlations between the spread of COVID-19 and other non-coronavirus related health issues, such as mental health or cardiovascular risk factors

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: Dataset copyright by authors - You are free to: - Share - copy and redistribute the material in any medium or format for any purpose, even commercially. - Adapt - remix, transform, and build upon the material for any purpose, even commercially. - You must: - Give appropriate credit - Provide a link to the license, and indicate if changes were made. - ShareAlike - You must distribute your contributions under the same license as the original. - Keep intact - all notices that refer to this license, including copyright notices.

Columns

File: utla_by_day.csv | Column name | Description | |:--------------------------|:------------------------------------------------------------------------------------------------------| | GSS_CD | Government Statistical Service code for the local authority. (String) | | GSS_NM | Name of the local authority. (String) | | TotalCases_2023-01-05 | Total number of confirmed COVID-19 cases in the local authority on the 5th of January 2023. (Integer) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit Dan Winchester.

Estimates of the prevalence of self-reported long COVID and associated activity limitation, using UK Coronavirus (COVID-19) Infection Survey data. Experimental Statistics.

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