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 the prevalence of self-reported long COVID and associated activity limitation, using UK Coronavirus (COVID-19) Infection Survey data. Experimental Statistics.

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.

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.

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.

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

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

In past 24 hours, UK, Europe had N/A new cases, N/A deaths and N/A recoveries.

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/

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!

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.

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.

Based on a comparison of coronavirus deaths in 210 countries relative to their population, Peru had the most losses to COVID-19 up until July 13, 2022. As of the same date, the virus had infected over 557.8 million people worldwide, and the number of deaths had totaled more than 6.3 million. Note, however, that COVID-19 test rates can vary per country. Additionally, big differences show up between countries when combining the number of deaths against confirmed COVID-19 cases. The source seemingly does not differentiate between "the Wuhan strain" (2019-nCOV) of COVID-19, "the Kent mutation" (B.1.1.7) that appeared in the UK in late 2020, the 2021 Delta variant (B.1.617.2) from India or the Omicron variant (B.1.1.529) from South Africa.

The difficulties of death figures

This table aims to provide a complete picture on the topic, but it very much relies on data that has become more difficult to compare. As the coronavirus pandemic developed across the world, countries already used different methods to count fatalities, and they sometimes changed them during the course of the pandemic. On April 16, for example, the Chinese city of Wuhan added a 50 percent increase in their death figures to account for community deaths. These deaths occurred outside of hospitals and went unaccounted for so far. The state of New York did something similar two days before, revising their figures with 3,700 new deaths as they started to include “assumed” coronavirus victims. The United Kingdom started counting deaths in care homes and private households on April 29, adjusting their number with about 5,000 new deaths (which were corrected lowered again by the same amount on August 18). This makes an already difficult comparison even more difficult. Belgium, for example, counts suspected coronavirus deaths in their figures, whereas other countries have not done that (yet). This means two things. First, it could have a big impact on both current as well as future figures. On April 16 already, UK health experts stated that if their numbers were corrected for community deaths like in Wuhan, the UK number would change from 205 to “above 300”. This is exactly what happened two weeks later. Second, it is difficult to pinpoint exactly which countries already have “revised” numbers (like Belgium, Wuhan or New York) and which ones do not. One work-around could be to look at (freely accessible) timelines that track the reported daily increase of deaths in certain countries. Several of these are available on our platform, such as for Belgium, Italy and Sweden. A sudden large increase might be an indicator that the domestic sources changed their methodology.

Where are these numbers coming from?

The numbers shown here were collected by Johns Hopkins University, a source that manually checks the data with domestic health authorities. For the majority of countries, this is from national authorities. In some cases, like China, the United States, Canada or Australia, city reports or other various state authorities were consulted. In this statistic, these separately reported numbers were put together. For more information or other freely accessible content, please visit our dedicated Facts and Figures page.

The impact of the coronavirus (COVID-19) pandemic on people, households and communities in Great Britain – indicators from the Opinions and Lifestyle Survey (OPN).

Antibody data, by UK country and age, from the Coronavirus (COVID-19) Infection Survey.