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/

Provisional counts of the number of deaths and age-standardised mortality rates involving the coronavirus (COVID-19) in England and Wales. Figures are provided by age, sex, geographies down to local authority level and deprivation indices.

A weekly survey carried out in the United Kingdom (UK) in May 2020 revealed the regional origin of sources being used for coronavirus news. Nearly a quarter of respondents said they had used local media organizations in the past week more than they did before the coronavirus outbreak. ** percent of respondents said the same about news organizations from abroad. For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Provisional age-standardised mortality rates for deaths due to COVID-19 by sex, local authority and deprivation indices, and numbers of deaths by middle-layer super output area.

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!

Coronavirus (COVID-19) vaccination rates for people aged 18 years and over in England. Estimates by socio-demographic characteristic, region and local authority.

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.

Local authorities have received and distributed funding to support small and medium businesses in England during coronavirus. The datasets cover schemes managed by local authorities: Additional Restrictions Support Grant (ARG) Restart Grant - closed June 2021 Local Restrictions Support Grants (LRSG) and Christmas support payments - closed 2021 Small Business Grants Fund (SBGF) - closed August 2020 Retail, Hospitality and Leisure Business Grants Fund (RHLGF) - closed August 2020 Local Authority Discretionary Grants Fund (LADGF) - closed August 2020 The spreadsheets show the total amount of money that each local authority in England: received from central government distributed to SMEs 20 December 2021 update We have published the latest estimates by local authorities for payments made under this grant programme: Additional Restrictions Grants (up to and including 28 November 2021) The number of grants paid out is not necessarily the same as the number of businesses paid. The data has not received full verification.

A survey in the UK revealed that during the COVID-19 lockdown in 2020, ** percent of UK consumers already purchased more from local shops in comparison to before lockdown. That number rose slightly to ** percent of consumers who want to buy more local products in the future. Only *** percent of UK consumers want to buy locally less often in the future.

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.

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

Data on the number and value of grants to small and medium sized businesses (SMEs) in response to the coronavirus pandemic. The spreadsheet shows the total amount of money that each local authority and parliamentary constituency in England has: received from central government distributed to SMEs as at 5 July 2020 31 July 2021: coronavirus grant schemes Local Restrictions Support Grant (LRSG): (Open) Local Restrictions Support Grant (LRSG): (Closed) Additional Restrictions Grant (ARG) - scheme open until 31 March 2022. A final update will be released afterwards Christmas Support Payment (CSP) Restart 5 July 2020: coronavirus grant schemes: Small Business Grants Fund (SBGF) scheme Retail, Hospitality and Leisure Business Grants Fund (RHLGF) Local Authority Discretionary Grant Fund (LADGF)

Identifying changes in the reproduction number, rate of spread, and doubling time during the course of the COVID-19 outbreak whilst accounting for potential biases due to delays in case reporting at the local authority level in the United Kingdom.

Identifying changes in the reproduction number, rate of spread, and doubling time during the course of the COVID-19 outbreak whilst accounting for potential biases due to delays in case reporting at the local authority level in the United Kingdom.

This mapping tool enables you to see how COVID-19 deaths in your area may relate to factors in the local population, which research has shown are associated with COVID-19 mortality. It maps COVID-19 deaths rates for small areas of London (known as MSOAs) and enables you to compare these to a number of other factors including the Index of Multiple Deprivation, the age and ethnicity of the local population, extent of pre-existing health conditions in the local population, and occupational data. Research has shown that the mortality risk from COVID-19 is higher for people of older age groups, for men, for people with pre-existing health conditions, and for people from BAME backgrounds. London boroughs had some of the highest mortality rates from COVID-19 based on data to April 17th 2020, based on data from the Office for National Statistics (ONS). Analysis from the ONS has also shown how mortality is also related to socio-economic issues such as occupations classified ‘at risk’ and area deprivation. There is much about COVID-19-related mortality that is still not fully understood, including the intersection between the different factors e.g. relationship between BAME groups and occupation. On their own, none of these individual factors correlate strongly with deaths for these small areas. This is most likely because the most relevant factors will vary from area to area. In some cases it may relate to the age of the population, in others it may relate to the prevalence of underlying health conditions, area deprivation or the proportion of the population working in ‘at risk occupations’, and in some cases a combination of these or none of them. Further descriptive analysis of the factors in this tool can be found here: https://data.london.gov.uk/dataset/covid-19--socio-economic-risk-factors-briefing

From April 2020 participants from our main Understanding Society sample have been asked to complete a short web-survey. This survey covers the changing impact of the pandemic on the welfare of UK individuals, families and wider communities. Participants complete a regular survey, which includes core content designed to track changes, alongside variable content adapted as the coronavirus situation develops. Researchers will be able to link the data from this web survey to answers respondents have given in previous (and future) waves of the annual Understanding Society survey.

This dataset shows the provisional COVID-19 Death registrations and occurrences by local authority and health board in England and Wales. This dataset has been prepared by Office for National Statistics.

This file contains weekly attendance data at local authority level for state-funded education settings for each Thursday excluding half term and Easter dates. The data is shown for each local authority and is further split by the following school phases:state-funded secondary schoolsstate-funded primary schoolsstate-funded special schoolsall state-funded schools.Data is in this file has not been scaled to account for non-response so it is not nationally representative.

A lookup file between 2020 Covid Infection Survey Geography to 2020 Local Authority Districts to 2019 Regions in the United Kingdom, as at 1 October 2020. (File size - 56KB) Field Names - CIS20CD, LAD20CDS, RGN19CD, RGN19NM, FIDField Types - Text, Text, Text, Text, NumericField Lengths - 9, 255, 9, 255FID = The FID, or Feature ID is created by the publication process when the names and codes / lookup products are published to the Open Geography portal. REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/CIS20_to_RGN19_Lookup_b5eba17b771a43d7a6b956376b274c8f/FeatureServer