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.

Data on activities that respondents have been doing more of since the start of the coronavirus pandemic and will keep doing after the end of the pandemic. Data are based on the COVID-19 module of the OPN, collected between 10 and 14 March 2021.

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/

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

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.

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

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!

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

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

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

Almost all sectors of the United Kingdom will see their output shrink considerably in the second quarter of 2020, due to the Coronavirus (COVID-19) pandemic and the lockdown measures enforced by the government. Education will be the most affected sector, seeing output decline by ** percent, while accommodation and food services will shrink by ** percent. The only sectors which are not forecast to see output losses are agriculture, which is expected to see no change in output, and human health and social activities, which is forecast to increase by ** percent.

This dataset includes CSV files that contain IDs and sentiment scores of the tweets related to the COVID-19 pandemic. The tweets have been collected by an on-going project deployed at https://live.rlamsal.com.np. The model monitors the real-time Twitter feed for coronavirus-related tweets using 90+ different keywords and hashtags that are commonly used while referencing the pandemic. This dataset has been wholly re-designed on March 20, 2020, to comply with the content redistribution policy set by Twitter. Below is the quick overview of this dataset.— Number of tweets : 468,019,953 tweets— Coverage : Global— Language : English (EN)— Geo-tagged tweets : Coronavirus (COVID-19) Geo-tagged Tweets Dataset— Keywords and hashtags (last updated on August 11, 2020) : "corona", "#corona", "coronavirus", "#coronavirus", "covid", "#covid", "covid19", "#covid19", "covid-19", "#covid-19", "sarscov2", "#sarscov2", "sars cov2", "sars cov 2", "covid_19", "#covid_19", "#ncov", "ncov", "#ncov2019", "ncov2019", "2019-ncov", "#2019-ncov", "pandemic", "#pandemic" "#2019ncov", "2019ncov", "quarantine", "#quarantine", "flatten the curve", "flattening the curve", "#flatteningthecurve", "#flattenthecurve", "hand sanitizer", "#handsanitizer", "#lockdown", "lockdown", "social distancing", "#socialdistancing", "work from home", "#workfromhome", "working from home", "#workingfromhome", "ppe", "n95", "#ppe", "#n95", "#covidiots", "covidiots", "herd immunity", "#herdimmunity", "pneumonia", "#pneumonia", "chinese virus", "#chinesevirus", "wuhan virus", "#wuhanvirus", "kung flu", "#kungflu", "wearamask", "#wearamask", "wear a mask", "vaccine", "vaccines", "#vaccine", "#vaccines", "corona vaccine", "corona vaccines", "#coronavaccine", "#coronavaccines", "face shield", "#faceshield", "face shields", "#faceshields", "health worker", "#health worker", "health workers", "#healthworkers", "#stayhomestaysafe", "#coronaupdate", "#frontlineheroes", "#coronawarriors", "#homeschool", "#homeschooling", "#hometasking", "#masks4all", "#wfh", "wash ur hands", "wash your hands", "#washurhands", "#washyourhands", "#stayathome", "#stayhome", "#selfisolating", "self isolating", "bars closed", "restaurants closed"— Dataset updates : Everyday— Usage policy : As per Twitter's Developer PolicyDataset Files (the local time mentioned below is GMT+5:45)corona_tweets_01.csv + corona_tweets_02.csv + corona_tweets_03.csv: 2,475,980 tweets (March 20, 2020 01:37 AM - March 21, 2020 09:25 AM)corona_tweets_04.csv: 1,233,340 tweets (March 21, 2020 09:27 AM - March 22, 2020 07:46 AM)corona_tweets_05.csv: 1,782,157 tweets (March 22, 2020 07:50 AM - March 23, 2020 09:08 AM)corona_tweets_06.csv: 1,771,295 tweets (March 23, 2020 09:11 AM - March 24, 2020 11:35 AM)corona_tweets_07.csv: 1,479,651 tweets (March 24, 2020 11:42 AM - March 25, 2020 11:43 AM)corona_tweets_08.csv: 1,272,592 tweets (March 25, 2020 11:47 AM - March 26, 2020 12:46 PM)corona_tweets_09.csv: 1,091,429 tweets (March 26, 2020 12:51 PM - March 27, 2020 11:53 AM)corona_tweets_10.csv: 1,172,013 tweets (March 27, 2020 11:56 AM - March 28, 2020 01:59 PM)corona_tweets_11.csv: 1,141,210 tweets (March 28, 2020 02:03 PM - March 29, 2020 04:01 PM)> March 29, 2020 04:02 PM - March 30, 2020 02:00 PM -- Some technical fault has occurred. Preventive measures have been taken. Tweets for this session won't be available.corona_tweets_12.csv: 793,417 tweets (March 30, 2020 02:01 PM - March 31, 2020 10:16 AM)corona_tweets_13.csv: 1,029,294 tweets (March 31, 2020 10:20 AM - April 01, 2020 10:59 AM)corona_tweets_14.csv: 920,076 tweets (April 01, 2020 11:02 AM - April 02, 2020 12:19 PM)corona_tweets_15.csv: 826,271 tweets (April 02, 2020 12:21 PM - April 03, 2020 02:38 PM)corona_tweets_16.csv: 612,512 tweets (April 03, 2020 02:40 PM - April 04, 2020 11:54 AM)corona_tweets_17.csv: 685,560 tweets (April 04, 2020 11:56 AM - April 05, 2020 12:54 PM)corona_tweets_18.csv: 717,301 tweets (April 05, 2020 12:56 PM - April 06, 2020 10:57 AM)corona_tweets_19.csv: 722,921 tweets (April 06, 2020 10:58 AM - April 07, 2020 12:28 PM)corona_tweets_20.csv: 554,012 tweets (April 07, 2020 12:29 PM - April 08, 2020 12:34 PM)corona_tweets_21.csv: 589,679 tweets (April 08, 2020 12:37 PM - April 09, 2020 12:18 PM)corona_tweets_22.csv: 517,718 tweets (April 09, 2020 12:20 PM - April 10, 2020 09:20 AM)corona_tweets_23.csv: 601,199 tweets (April 10, 2020 09:22 AM - April 11, 2020 10:22 AM)corona_tweets_24.csv: 497,655 tweets (April 11, 2020 10:24 AM - April 12, 2020 10:53 AM)corona_tweets_25.csv: 477,182 tweets (April 12, 2020 10:57 AM - April 13, 2020 11:43 AM)corona_tweets_26.csv: 288,277 tweets (April 13, 2020 11:46 AM - April 14, 2020 12:49 AM)corona_tweets_27.csv: 515,739 tweets (April 14, 2020 11:09 AM - April 15, 2020 12:38 PM)corona_tweets_28.csv: 427,088 tweets (April 15, 2020 12:40 PM - April 16, 2020 10:03 AM)corona_tweets_29.csv: 433,368 tweets (April 16, 2020 10:04 AM - April 17, 2020 10:38 AM)corona_tweets_30.csv: 392,847 tweets (April 17, 2020 10:40 AM - April 18, 2020 10:17 AM)> With the addition of some more coronavirus specific keywords, the number of tweets captured day has increased significantly, therefore, the CSV files hereafter will be zipped. Lets save some bandwidth.corona_tweets_31.csv: 2,671,818 tweets (April 18, 2020 10:19 AM - April 19, 2020 09:34 AM)corona_tweets_32.csv: 2,393,006 tweets (April 19, 2020 09:43 AM - April 20, 2020 10:45 AM)corona_tweets_33.csv: 2,227,579 tweets (April 20, 2020 10:56 AM - April 21, 2020 10:47 AM)corona_tweets_34.csv: 2,211,689 tweets (April 21, 2020 10:54 AM - April 22, 2020 10:33 AM)corona_tweets_35.csv: 2,265,189 tweets (April 22, 2020 10:45 AM - April 23, 2020 10:49 AM)corona_tweets_36.csv: 2,201,138 tweets (April 23, 2020 11:08 AM - April 24, 2020 10:39 AM)corona_tweets_37.csv: 2,338,713 tweets (April 24, 2020 10:51 AM - April 25, 2020 11:50 AM)corona_tweets_38.csv: 1,981,835 tweets (April 25, 2020 12:20 PM - April 26, 2020 09:13 AM)corona_tweets_39.csv: 2,348,827 tweets (April 26, 2020 09:16 AM - April 27, 2020 10:21 AM)corona_tweets_40.csv: 2,212,216 tweets (April 27, 2020 10:33 AM - April 28, 2020 10:09 AM)corona_tweets_41.csv: 2,118,853 tweets (April 28, 2020 10:20 AM - April 29, 2020 08:48 AM)corona_tweets_42.csv: 2,390,703 tweets (April 29, 2020 09:09 AM - April 30, 2020 10:33 AM)corona_tweets_43.csv: 2,184,439 tweets (April 30, 2020 10:53 AM - May 01, 2020 10:18 AM)corona_tweets_44.csv: 2,223,013 tweets (May 01, 2020 10:23 AM - May 02, 2020 09:54 AM)corona_tweets_45.csv: 2,216,553 tweets (May 02, 2020 10:18 AM - May 03, 2020 09:57 AM)corona_tweets_46.csv: 2,266,373 tweets (May 03, 2020 10:09 AM - May 04, 2020 10:17 AM)corona_tweets_47.csv: 2,227,489 tweets (May 04, 2020 10:32 AM - May 05, 2020 10:17 AM)corona_tweets_48.csv: 2,218,774 tweets (May 05, 2020 10:38 AM - May 06, 2020 10:26 AM)corona_tweets_49.csv: 2,164,251 tweets (May 06, 2020 10:35 AM - May 07, 2020 09:33 AM)corona_tweets_50.csv: 2,203,686 tweets (May 07, 2020 09:55 AM - May 08, 2020 09:35 AM)corona_tweets_51.csv: 2,250,019 tweets (May 08, 2020 09:39 AM - May 09, 2020 09:49 AM)corona_tweets_52.csv: 2,273,705 tweets (May 09, 2020 09:55 AM - May 10, 2020 10:11 AM)corona_tweets_53.csv: 2,208,264 tweets (May 10, 2020 10:23 AM - May 11, 2020 09:57 AM)corona_tweets_54.csv: 2,216,845 tweets (May 11, 2020 10:08 AM - May 12, 2020 09:52 AM)corona_tweets_55.csv: 2,264,472 tweets (May 12, 2020 09:59 AM - May 13, 2020 10:14 AM)corona_tweets_56.csv: 2,339,709 tweets (May 13, 2020 10:24 AM - May 14, 2020 11:21 AM)corona_tweets_57.csv: 2,096,878 tweets (May 14, 2020 11:38 AM - May 15, 2020 09:58 AM)corona_tweets_58.csv: 2,214,205 tweets (May 15, 2020 10:13 AM - May 16, 2020 09:43 AM)> The server and the databases have been optimized; therefore, there is a significant rise in the number of tweets captured per day.corona_tweets_59.csv: 3,389,090 tweets (May 16, 2020 09:58 AM - May 17, 2020 10:34 AM)corona_tweets_60.csv: 3,530,933 tweets (May 17, 2020 10:36 AM - May 18, 2020 10:07 AM)corona_tweets_61.csv: 3,899,631 tweets (May 18, 2020 10:08 AM - May 19, 2020 10:07 AM)corona_tweets_62.csv: 3,767,009 tweets (May 19, 2020 10:08 AM - May 20, 2020 10:06 AM)corona_tweets_63.csv: 3,790,455 tweets (May 20, 2020 10:06 AM - May 21, 2020 10:15 AM)corona_tweets_64.csv: 3,582,020 tweets (May 21, 2020 10:16 AM - May 22, 2020 10:13 AM)corona_tweets_65.csv: 3,461,470 tweets (May 22, 2020 10:14 AM - May 23, 2020 10:08 AM)corona_tweets_66.csv: 3,477,564 tweets (May 23, 2020 10:08 AM - May 24, 2020 10:02 AM)corona_tweets_67.csv: 3,656,446 tweets (May 24, 2020 10:02 AM - May 25, 2020 10:10 AM)corona_tweets_68.csv: 3,474,952 tweets (May 25, 2020 10:11 AM - May 26, 2020 10:22 AM)corona_tweets_69.csv: 3,422,960 tweets (May 26, 2020 10:22 AM - May 27, 2020 10:16 AM)corona_tweets_70.csv: 3,480,999 tweets (May 27, 2020 10:17 AM - May 28, 2020 10:35 AM)corona_tweets_71.csv: 3,446,008 tweets (May 28, 2020 10:36 AM - May 29, 2020 10:07 AM)corona_tweets_72.csv: 3,492,841 tweets (May 29, 2020 10:07 AM - May 30, 2020 10:14 AM)corona_tweets_73.csv: 3,098,817 tweets (May 30, 2020 10:15 AM - May 31, 2020 10:13 AM)corona_tweets_74.csv: 3,234,848 tweets (May 31, 2020 10:13 AM - June 01, 2020 10:14 AM)corona_tweets_75.csv: 3,206,132 tweets (June 01, 2020 10:15 AM - June 02, 2020 10:07 AM)corona_tweets_76.csv: 3,206,417 tweets (June 02, 2020 10:08 AM - June 03, 2020 10:26 AM)corona_tweets_77.csv: 3,256,225 tweets (June 03, 2020 10:27 AM - June 04, 2020 10:23 AM)corona_tweets_78.csv: 2,205,123 tweets (June 04, 2020 10:26 AM - June 05, 2020 10:03 AM) (tweet IDs were extracted from the backup server for this session)corona_tweets_79.csv: 3,381,184 tweets (June 05, 2020 10:11 AM - June 06, 2020 10:16 AM)corona_tweets_80.csv: 3,194,500 tweets (June 06, 2020 10:17 AM - June 07, 2020 10:24 AM)corona_tweets_81.csv: 2,768,780 tweets (June 07, 2020 10:25 AM - June 08, 2020 10:13 AM)corona_tweets_82.csv: 3,032,227 tweets (June 08, 2020 10:13 AM - June 09, 2020 10:12

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.

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.