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.

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

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/

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

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.

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.

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

This dashboard shows the number of people in either a Local Authority or Neighbourhood who have had their symptoms assessed over the phone by NHS 111 and 999, where coronavirus (COVID-19) was suspected.

Context

COVID-19 is a Pandemic which was spread worldwide in the early months of 2020, Which has had a major impact on the United Kingdom. As the UK has recently carried out wide spread vaccination and ended Lockdown I am providing the recent COVID-19 figures.

Content

Several Datasets are provided, focusing on Deaths, Cases, Hospitalisation and Vaccination. Files often protray the same information but from a different reference point. For example for Deaths there is one displaying figures from people who died using there positive date as a reference point, whereas the other is using the date of death.

Acknowledgements

These datasets was scrapped off the UK Gov website in regards to COVID-19. For those looking to build a more complex project using a constant data flow, they do provide an API which may assist.

Inspiration

Possible area to explore are: What was the Impact of Vaccines on the COVID-19 Pandemic? What was the Impact of a Lockdown on the COVID-19 Pandemic? Which Nation managed the spread of COVID-19 the best?

Licence

Open Government Licence V3.0

Technical and methodological data from the Coronavirus (COVID-19) Infection Survey, England, Wales, Northern Ireland and Scotland.

Context

Complete COVID-19 dataset is a collection of the COVID-19 data maintained by Our World in Data. It is updated daily and includes data on confirmed cases, deaths, hospitalizations, testing, and vaccinations as well as other variables of potential interest.

Content

The variables represent all data related to confirmed cases, deaths, hospitalizations, and testing, as well as other variables of potential interest.
the columns are: iso_code, continent, location, date, total_cases, new_cases, new_cases_smoothed, total_deaths, new_deaths, new_deaths_smoothed, total_cases_per_million, new_cases_per_million, new_cases_smoothed_per_million, total_deaths_per_million, new_deaths_per_million, new_deaths_smoothed_per_million, reproduction_rate, icu_patients, icu_patients_per_million, hosp_patients, hosp_patients_per_million, weekly_icu_admissions, weekly_icu_admissions_per_million, weekly_hosp_admissions, weekly_hosp_admissions_per_million, total_tests, new_tests, total_tests_per_thousand, new_tests_per_thousand, new_tests_smoothed, new_tests_smoothed_per_thousand, positive_rate, tests_per_case, tests_units, total_vaccinations, people_vaccinated, people_fully_vaccinated, new_vaccinations, new_vaccinations_smoothed, total_vaccinations_per_hundred, people_vaccinated_per_hundred, people_fully_vaccinated_per_hundred, new_vaccinations_smoothed_per_million, stringency_index, population, population_density, median_age, aged_65_older, aged_70_older, gdp_per_capita, extreme_poverty, cardiovasc_death_rate, diabetes_prevalence, female_smokers, male_smokers, handwashing_facilities, hospital_beds_per_thousand, life_expectancy, human_development_index

Acknowledgements/ Data Source

https://systems.jhu.edu/research/public-health/ncov/ https://www.ecdc.europa.eu/en/publications-data/download-data-hospital-and-icu-admission-rates-and-current-occupancy-covid-19 https://coronavirus.data.gov.uk/details/healthcare https://covid19tracker.ca/ https://healthdata.gov/dataset/covid-19-reported-patient-impact-and-hospital-capacity-state-timeseries https://ourworldindata.org/coronavirus-testing#our-checklist-for-covid-19-testing-data

This is a subset of data taken from https://coronavirus.data.gov.uk / https://coronavirus-staging.data.gov.uk. Please follow this link for more information: https://coronavirus-staging.data.gov.uk/about-data

A data set which shows the service requests that have been made by Leeds residents for assistance during the Covid-19 Pandemic to the Covid-19 helpline.

The Opinion Research team set up an online diary to capture the views, behaviours and experiences of a sample of Londoners during the coronavirus outbreak. Commencing in late May, this online diary ran for 8 weeks. Fortnightly summary reports can be found accessed below, and included: Week 1 and 2 – reflected on experiences during lockdown to date and explored views on easing lockdown. Week 3 and 4 – explored priorities for London’s recovery, both short and long-term, and views on the Test and Trace system. Week 5 and 6 – explored growing disengagement with the coronavirus outbreak and reflected on some of the positive impacts of lockdown.​ Week 7 and 8 – explored the idea of a 15-minute city and aspirations for the future of London. 

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

Due to changes in the collection and availability of data on COVID-19, this website 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 and the UKHSA GLA Covid-19 Mobility Report Since March 2020, London has seen many different levels of restrictions - including three separate lockdowns and many other tiers/levels of restrictions, as well as easing of restrictions and even measures to actively encourage people to go to work, their high streets and local restaurants. This reports gathers data from a number of sources, including google, apple, citymapper, purple wifi and opentable to assess the extent to which these levels of restrictions have translated to a reductions in Londoners' movements. The data behind the charts below come from different sources. None of these data represent a direct measure of how well people are adhering to the lockdown rules - nor do they provide an exhaustive data set. Rather, they are measures of different aspects of mobility, which together, offer an overall impression of how people Londoners are moving around the capital. The information is broken down by use of public transport, pedestrian activity, retail and leisure, and homeworking. Public Transport For the transport measures, we have included data from google, Apple, CityMapper and Transport for London. They measure different aspects of public transport usage - depending on the data source. Each of the lines in the chart below represents a percentage of a pre-pandemic baseline. activity Source Latest Baseline Min value in Lockdown 1 Min value in Lockdown 2 Min value in Lockdown 3 Citymapper Citymapper mobility index 2021-09-05 Compares trips planned and trips taken within its app to a baseline of the four weeks from 6 Jan 2020 7.9% 28% 19% Google Google Mobility Report 2022-10-15 Location data shared by users of Android smartphones, compared time and duration of visits to locations to the median values on the same day of the week in the five weeks from 3 Jan 2020 20.4% 40% 27% TfL Bus Transport for London 2022-10-30 Bus journey ‘taps' on the TfL network compared to same day of the week in four weeks starting 13 Jan 2020 - 34% 24% TfL Tube Transport for London 2022-10-30 Tube journey ‘taps' on the TfL network compared to same day of the week in four weeks starting 13 Jan 2020 - 30% 21% Pedestrian activity With the data we currently have it's harder to estimate pedestrian activity and high street busyness. A few indicators can give us information on how people are making trips out of the house: activity Source Latest Baseline Min value in Lockdown 1 Min value in Lockdown 2 Min value in Lockdown 3 Walking Apple Mobility Index 2021-11-09 estimates the frequency of trips made on foot compared to baselie of 13 Jan '20 22% 47% 36% Parks Google Mobility Report 2022-10-15 Frequency of trips to parks. Changes in the weather mean this varies a lot. Compared to baseline of 5 weeks from 3 Jan '20 30% 55% 41% Retail & Rec Google Mobility Report 2022-10-15 Estimates frequency of trips to shops/leisure locations. Compared to baseline of 5 weeks from 3 Jan '20 30% 55% 41% Retail and recreation In this section, we focus on estimated footfall to shops, restaurants, cafes, shopping centres and so on. activity Source Latest Baseline Min value in Lockdown 1 Min value in Lockdown 2 Min value in Lockdown 3 Grocery/pharmacy Google Mobility Report 2022-10-15 Estimates frequency of trips to grovery shops and pharmacies. Compared to baseline of 5 weeks from 3 Jan '20 32% 55.00% 45.000% Retail/rec Google Mobility Report 2022-10-15 Estimates frequency of trips to shops/leisure locations. Compared to baseline of 5 weeks from 3 Jan '20 32% 55.00% 45.000% Restaurants OpenTable State of the Industry 2022-02-19 London restaurant bookings made through OpenTable 0% 0.17% 0.024% Home Working The Google Mobility Report estimates changes in how many people are staying at home and going to places of work compared to normal. It's difficult to translate this into exact percentages of the population, but changes back towards ‘normal' can be seen to start before any lockdown restrictions were lifted. This value gives a seven day rolling (mean) average to avoid it being distorted by weekends and bank holidays. name Source Latest Baseline Min/max value in Lockdown 1 Min/max value in Lockdown 2 Min/max value in Lockdown 3 Residential Google Mobility Report 2022-10-15 Estimates changes in how many people are staying at home for work. Compared to baseline of 5 weeks from 3 Jan '20 131% 119% 125% Workplaces Google Mobility Report 2022-10-15 Estimates changes in how many people are going to places of work. Compared to baseline of 5 weeks from 3 Jan '20 24% 54% 40% Restriction Date end_date Average Citymapper Average homeworking Work from home advised 17 Mar '20 21 Mar '20 57% 118% Schools, pubs closed 21 Mar '20 24 Mar '20 34% 119% UK enters first lockdown 24 Mar '20 10 May '20 10% 130% Some workers encouraged to return to work 10 May '20 01 Jun '20 15% 125% Schools open, small groups outside 01 Jun '20 15 Jun '20 19% 122% Non-essential businesses re-open 15 Jun '20 04 Jul '20 24% 120% Hospitality reopens 04 Jul '20 03 Aug '20 34% 115% Eat out to help out scheme begins 03 Aug '20 08 Sep '20 44% 113% Rule of 6 08 Sep '20 24 Sep '20 53% 111% 10pm Curfew 24 Sep '20 15 Oct '20 51% 112% Tier 2 (High alert) 15 Oct '20 05 Nov '20 49% 113% Second Lockdown 05 Nov '20 02 Dec '20 31% 118% Tier 2 (High alert) 02 Dec '20 19 Dec '20 45% 115% Tier 4 (Stay at home advised) 19 Dec '20 05 Jan '21 22% 124% Third Lockdown 05 Jan '21 08 Mar '21 22% 122% Roadmap 1 08 Mar '21 29 Mar '21 29% 118% Roadmap 2 29 Mar '21 12 Apr '21 36% 117% Roadmap 3 12 Apr '21 17 May '21 51% 113% Roadmap out of lockdown: Step 3 17 May '21 19 Jul '21 65% 109% Roadmap out of lockdown: Step 4 19 Jul '21 07 Nov '22 68% 107%