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/

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.

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.

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.

This feature service contains COVID-19 data automatically updated from the Public Health England (PHE) API service, daily. Using this API, this service takes the current day request minus two days. Therefore the data will always be two days behind. This is a result of the delay between PHE's specimen date and reporting date.The Polygon Layers, which all contain spatial data, provide information about the latest cumulative figures at three geographies; Local Authority, Regions and Nations. The Tables, which are not spatially aware, provide historical data for each feature. The format of these tables allow you to use the Join tool with the Polygon Layers and create a time enabled layer. This can be used within a dashboard or on the animation tool to view patterns over time.

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

As of November 24, 2024 there were over 274 million confirmed cases of coronavirus (COVID-19) across the whole of Europe since the first confirmed cases in France in January 2020. France has been the worst affected country in Europe with 39,028,437 confirmed cases, followed by Germany with 38,437,756 cases. Italy and the UK have approximately 26.8 million and 25 million cases respectively. For further information about the coronavirus pandemic, please visit our dedicated Facts and Figures page.

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 dataset contains daily data trackers for the COVID-19 pandemic, aggregated by month and starting 18.3.20. The first release of COVID-19 data on this platform was on 1.6.20. Updates have been provided on a quarterly basis throughout 2023/24. No updates are currently scheduled for 2024/25 as case rates remain low. The data is accurate as at 8.00 a.m. on 8.4.24. Some narrative for the data covering the latest period is provided here below: Diagnosed cases / episodes • As at 3.4.24 CYC residents have had a total 75,556 covid episodes since the start of the pandemic, a rate of 37,465 per 100,000 of population (using 2021 Mid-Year Population estimates). The cumulative rate in York is similar to the national (37,305) and regional (37,059) averages. • The latest rate of new Covid cases per 100,000 of population for the period 28.3.24 to 3.4.24 in York was 1.49 (3 cases). The national and regional averages at this date were 1.67 and 2.19 respectively (using data published on Gov.uk on 5.4.24).

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 dataset contains a weekly situation update on COVID-19, the epidemiological curve and the global geographical distribution (EU/EEA and the UK, worldwide).

Since the beginning of the coronavirus pandemic, ECDC’s Epidemic Intelligence team has collected the number of COVID-19 cases and deaths, based on reports from health authorities worldwide. This comprehensive and systematic process was carried out on a daily basis until 14/12/2020. See the discontinued daily dataset: COVID-19 Coronavirus data - daily. ECDC’s decision to discontinue daily data collection is based on the fact that the daily number of cases reported or published by countries is frequently subject to retrospective corrections, delays in reporting and/or clustered reporting of data for several days. Therefore, the daily number of cases may not reflect the true number of cases at EU/EEA level at a given day of reporting. Consequently, day to day variations in the number of cases does not constitute a valid basis for policy decisions.

ECDC continues to monitor the situation. Every week between Monday and Wednesday, a team of epidemiologists screen up to 500 relevant sources to collect the latest figures for publication on Thursday. The data screening is followed by ECDC’s standard epidemic intelligence process for which every single data entry is validated and documented in an ECDC database. An extract of this database, complete with up-to-date figures and data visualisations, is then shared on the ECDC website, ensuring a maximum level of transparency.

ECDC receives regular updates from EU/EEA countries through the Early Warning and Response System (EWRS), The European Surveillance System (TESSy), the World Health Organization (WHO) and email exchanges with other international stakeholders. This information is complemented by screening up to 500 sources every day to collect COVID-19 figures from 196 countries. This includes websites of ministries of health (43% of the total number of sources), websites of public health institutes (9%), websites from other national authorities (ministries of social services and welfare, governments, prime minister cabinets, cabinets of ministries, websites on health statistics and official response teams) (6%), WHO websites and WHO situation reports (2%), and official dashboards and interactive maps from national and international institutions (10%). In addition, ECDC screens social media accounts maintained by national authorities on for example Twitter, Facebook, YouTube or Telegram accounts run by ministries of health (28%) and other official sources (e.g. official media outlets) (2%). Several media and social media sources are screened to gather additional information which can be validated with the official sources previously mentioned. Only cases and deaths reported by the national and regional competent authorities from the countries and territories listed are aggregated in our database.

Disclaimer: National updates are published at different times and in different time zones. This, and the time ECDC needs to process these data, might lead to discrepancies between the national numbers and the numbers published by ECDC. Users are advised to use all data with caution and awareness of their limitations. Data are subject to retrospective corrections; corrected datasets are released as soon as processing of updated national data has been completed.

If you reuse or enrich this dataset, please share it with us.

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

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.

On March 4, 2020, the first death as a result of coronavirus (COVID-19) was recorded in the United Kingdom (UK). The number of deaths in the UK has increased significantly since then. As of January 13, 2023, the number of confirmed deaths due to coronavirus in the UK amounted to 202,157. On January 21, 2021, 1,370 deaths were recorded, which was the highest total in single day in the UK since the outbreak began.

Number of deaths among highest in Europe
The UK has had the highest number of deaths from coronavirus in western Europe. In terms of rate of coronavirus deaths, the UK has recorded 297.8 deaths per 100,000 population.

Cases in the UK The number of confirmed cases of coronavirus in the UK was 24,243,393 as of January 13, 2023. The South East has the highest number of first-episode confirmed cases of the virus in the UK with 3,123,050 cases, while London and the North West have 2,912,859 and 2,580,090 confirmed cases respectively. As of January 16, the UK has had 50 new cases per 100,000 in the last seven days.

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

Background

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.

How was this data generated?

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

Data Dictionary

The following provides a list of all 9 tables and the columns that can be found in each table.