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/

COVID-19 is a infectious Disease which has infected more than 500 people in UK and many more people world-wide.

Acknowledgements Sincere thanks to Public Health England and Local governments. Source of Data: UK Government and Public Health UK

****Notes on the methodology**** This service shows case numbers as reported to Public Health England (PHE), matched to Administrative Geography Codes from the Office of National Statistics. Cases include people who have recovered.

Events are time-stamped on the date that PHE was informed of the new case or death.

The map shows circles that grow or shrink in line with the number of cases in that geographic area.

Data from Scotland, Wales and Northern Ireland is represented on the charts, total indicators and on the country level map layer.

Contains Ordnance Survey data © Crown copyright and database right 2020. Contains National Statistics data © Crown copyright and database right 2020.

Terms of Use No special restrictions or limitations on using the item’s content have been provided.

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

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/

Data published on potential COVID-19 symptoms reported through NHS Pathways and 111 online Dashboard shows the total number of NHS Pathways triages through 111 and 999, and online assessments in 111 online which have received a potential COVID-19 final disposition. This data is based on potential COVID-19 symptoms reported by members of the public to NHS Pathways through NHS 111 or 999 and 111 online, and is not based on the outcomes of tests for coronavirus. This is not a count of people.

On January 12, 2021, over 4.5 thousand individuals in the UK were admitted to hospital with coronavirus (COVID-19), the highest single amount since the start of the pandemic. The daily hospital cases started to rise significantly at the end of 2020 and into January 2021, however since then the number of hospitalizations fell dramatically as the UK managed to vaccinate millions against COVID-19. Overall, since the pandemic started around 994 thousand people in the UK have been hospitalized with the virus.

The total number of cases in the UK can be found here. For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Links to a range of useful COVID-19 datasets and visualisations. For information and advice in relation to COVID-19 please use the following information from reliable, trusted sources such as the Government, the NHS, Public Health England and the Council. www.gov.uk/coronavirus www.nhs.uk/coronavirus www.calderdale.gov.uk/coronavirus

View daily updates and historical trends for UK Coronavirus Full Vaccination Rate. from United Kingdom. Source: Our World in Data. Track economic data wit…

The dashboard provides data on COVID-19 testing, cases, healthcare, and deaths in the UK. Data are covered by the UK Open Government Licence.

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.

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.

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.

Data forming the COVID-19 SARI-Watch data set relate to demographic, risk factor, treatment, and outcome information for patients admitted to hospital with a confirmed COVID-19 diagnosis, as recorded in the PHE COVID-19 SARI-Watch Surveillance System.

SARI-Watch data are to be collected for the purposes of direct care, service monitoring, planning and research in response to the spread of COVID-19, including for the following purposes identified in the COVID-19 Directions (see below): •understanding information about patient access to health services and adult social care services as a direct or indirect result of COVID-19 and the availability and capacity of those services •monitoring and managing the response to COVID-19 by health and social care bodies and the Government, including providing information to the public about COVID-19 and its effectiveness, and information about capacity, medicines, equipment, supplies, services and the workforce within the health services and adult social care services •research and planning in relation to COVID-19, such as providing COVID-19 diagnosis.

Timescales for dissemination can be found under 'Our Service Levels' at the following link: https://digital.nhs.uk/services/data-access-request-service-dars/data-access-request-service-dars-process Standard wording

NHS Digital will only disseminate SARI-Watch data collected from PHE where the information is linked to other information controlled by NHS Digital.

This is a release of management information for anonymous summary data for those patients that have been identified on the Shielded Patient List (SPL). Its purpose is to make the summary data available to a wider audience, as open data, to enable a broad base of users to perform analysis from it. The purpose behind releasing this data is to present regional and local data to allow for its use in public health. It will also allow for greater analysis, modelling and planning to be performed using the latest data, to aid in the response to the pandemic. We will update this weekly and we would welcome your feedback to help us develop our open data sets. The data that is published is based on version 74 of the SPL clinical methodology, with the data extracted as at 21 September 2021.

As of April 2020, the coronavirus (COVID-19) outbreak has affected, in some way, the living arrangements of around a third of healthcare professionals in the United Kingdom (UK). 12 percent of healthcare professionals still live in their home, but avoid contact with other members of their household, while three percent have had another member of the household live away from home due to coronavirus.

The latest number of cases in the UK can be found here. For further information about the coronavirus 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

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