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

Information from a new module of questions included in the Telephone-operated Crime Survey for England and Wales (TCSEW) around perceptions of crime, the police and anti-social behaviour during the coronavirus (COVID-19) pandemic, feelings of safety and experiences of harassment. Data on children’s online activity are also presented. These tables are no longer produced.

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/

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

Counts of coronavirus (COVID-19) related deaths by ethnic group in Wales.

The Chief Medical Officer (CMO) for England, working with the CMOs of the devolved nations and other senior clinicians, commissioned NHS Digital to produce a list of people at “high risk” of complications from COVID-19, who should be shielded for at least 12 weeks. The CMO for Wales commissioned a collaboration of national bodies in Wales (NWIS, DU, NWSSP, PHW) to identify “high risk” people for the Welsh population, based largely on the NHS Digital methodology. This list is referred to as the Shielded Patient List (SPL).

The “high risk” list was defined as a subset of a wider group of people who may be “at risk”. Specific advice applies to these groups, currently this advice is: • “At Risk” – large group normally at risk from the flu - should practice strict social distancing • “At high risk” – a smaller sub-group (circa 70k), defined by CMO – should practice complete social “shielding” NHS Digital have described the methodology that has been used to identify patients who meet the high risk criteria due to their inclusion in one or more of the disease groups.

As there are differences in some of the systems used across the devolved nations, nuanced differences in application and interpretation of CMO guidance, this document describes the Welsh methodology.

https://nwis.nhs.wales/coronavirus/coronavirus-content/coronavirus-documents/covid-19-high-risk-shielded-patient-list-identification-methodology/

Dataset received it's final update in March 2022

Test results for COVID-19 tests. Details tests, outcomes, and some clinically relevant patient information about COVID-19 Tests in Wales.

The Chief Medical Officer (CMO) for England, working with the CMOs of the devolved nations and other senior clinicians, commissioned NHS Digital to produce a list of people at “high risk” of complications from COVID-19, who should be shielded for at least 12 weeks. The CMO for Wales commissioned a collaboration of national bodies in Wales (NWIS, DU, NWSSP, PHW) to identify “high risk” people for the Welsh population, based largely on the NHS Digital methodology. This list is referred to as the Shielded Patient List (SPL).

The “high risk” list was defined as a subset of a wider group of people who may be “at risk”. Specific advice applies to these groups, currently this advice is: • “At Risk” – large group normally at risk from the flu - should practice strict social distancing • “At high risk” – a smaller sub-group (circa 70k), defined by CMO – should practice complete social “shielding” NHS Digital have described the methodology that has been used to identify patients who meet the high risk criteria due to their inclusion in one or more of the disease groups.

As there are differences in some of the systems used across the devolved nations, nuanced differences in application and interpretation of CMO guidance, this document describes the Welsh methodology.

https://nwis.nhs.wales/coronavirus/coronavirus-content/coronavirus-documents/covid-19-high-risk-shielded-patient-list-identification-methodology/

The dataset time coverage ends in August 2022.

Number of deaths registered each month in England and Wales, including deaths involving the coronavirus (COVID-19), by age, sex and country.

Virus Watch will provide data relevant to a wide range of audiences involved in pandemic response. Virus Watch has collected personal and special category data.

Baseline survey – the baseline survey collects basic demographic information including sex, date of birth, age in years, ethnicity. It also includes details of the household structure, socioeconomic status including household income. The survey also collects health data used for the study including existing medical conditions (general and COVID-related) and access to health during the pandemic.

Weekly survey – the weekly survey collects data about any illnesses within the household during each week and the results of any COVID tests performed. The survey collects information on behaviours during illness of the household. Since Jan 2021, the weekly survey has also collected data on vaccination status of household members.

Monthly surveys – the monthly surveys collect regular data on contact patterns of household throughout the pandemic, regardless of symptoms or illnesses in the household. Each month additional bespoke questions have been asked in the monthly surveys in order to inform important policy questions at the time.

Laboratory data – the laboratory data includes information on the results of antibody tests for a subset of participants including nucleocapsid and spike antibody levels. It also includes PCR results for participants that took part in home COVID testing for Virus Watch.

Following a trial run and official release on the 24th of September 2020, the NHS COVID-19 app has been downloaded more than 29 million times in England and Wales, as of December 2021. Developed to complement the NHS Test & Trace in England and the Test, Trace and Protect program in Wales, the app is aimed at increasing the speed and accuracy of contact tracing, and includes features such as local area alerts and venue check-in.

NHS COVID-19 app usage Between the beginning of June 2021 and the end of July 2021, the number of COVID-19 cases in the United Kingdom started rising again, reaching the peak of 54,674 on the 21st of July. In the previous week, it was reported that more than 600 thousand users of the NHS COVID-19 app in England and Wales had received a self-isolation alert or “ping,” causing what has been since renamed by the media as a “pingdemic.” The NHS COVID-19 app, which works using Bluetooth technology, registers the devices that the users have been in proximity of, and is programmed to send alerts to all the traced contacts in case the app users test positive for coronavirus. While the app’s tracing measurements are currently being reviewed to decrease the number of alerts sent, two in 10 users have reported switching off the app’s contact tracing function. Moreover, according to a survey of online users in Great Britain, only 22 percent of the online users who have the app are using it correctly, while one in ten reported deleting the app altogether.

Travel health pass and COVID-19 apps In 2021, the rolling out of vaccination plans worldwide prompted health institutions and travel companies to start releasing new apps or updating their current ones to function as health passports. With close to 5,7 million downloads in the first half of 2021, the NHS app was the most downloaded app used to show digital certifications. The CovPass app, which is available to residents in Germany, followed with more than 5.56 million downloads as of the second quarter of 2021. According to a February survey of travelers worldwide, the main concerns over the use of digital health passports related to security risks over personal data being hacked and privacy protection.

CVD-COVID-UK, co-ordinated by the British Heart Foundation (BHF) Data Science Centre (https://bhfdatasciencecentre.org/), is one of the NIHR-BHF Cardiovascular Partnership’s National Flagship Projects.

CVD-COVID-UK aims to understand the relationship between COVID-19 and cardiovascular diseases through analyses of de-identified, pseudonymised, linked, nationally collated health datasets across the four nations of the UK. The consortium has over 400 members across more than 50 institutions including data custodians, data scientists and clinicians, all of whom have signed up to an agreed set of principles with an inclusive, open and transparent ethos.

Approved researchers access data within secure trusted/secure research environments (TREs/SDEs) provided by NHS England (England), the National Safe Haven (Scotland), the Secure Anonymised Information Linkage (SAIL) Databank (Wales) and the Honest Broker Service (Northern Ireland). A dashboard of datasets available in each nation’s TRE can be found here: https://bhfdatasciencecentre.org/areas/cvd-covid-uk-covid-impact/

This dataset represents the linked datasets in SAIL Databank’s TRE for Wales and contains the following datasets: • Welsh Longitudinal GP Dataset - Welsh Primary Care (Daily COVID codes only) (GPCD) • Welsh Longitudinal General Practice Dataset (WLGP) - Welsh Primary Care • Critical Care Dataset (CCDS) • Emergency Department Dataset Daily (EDDD) • Emergency Department Dataset (EDDS) • Outpatient Database for Wales (OPDW) • Outpatient Referral (OPRD) • Patient Episode Dataset for Wales (PEDW) • COVID-19 Test Results (PATD) • COVID-19 Test Trace and Protect (CTTP) - Legacy • COVID-19 Shielded People List (CVSP) • SARS-CoV-2 viral sequencing data (COG-UK data)-Lineage/Variant Data-Wales (CVSD) • Covid Vaccination Dataset (CVVD) • Annual District Death Daily (ADDD) • Annual District Death Extract (ADDE) • COVID-19 Consolidated Deaths (CDDS) • Intensive Care National Audit and Research Centre (ICCD) - Legacy - COVID only • Intensive Care National Audit and Research Centre (ICNC) • Welsh Dispensing Dataset (WDDS) - Legacy • Annual District Birth Extract (ADBE) • Maternity Indicators Dataset (MIDS) • National Community Child Health Database (NCCHD) • Care Home Dataset (CARE) • Congenital Anomaly Register and Information Service (CARS) • Referral to Treatment Times (RTTD) • SAIL Dementia e-Cohort (SDEC) • Welsh Ambulance Services NHS Trust (WASD) • Welsh Demographic Service Dataset (WDSD) • Welsh Results Reports Service (WRRS) • ONS 2011 Census Wales (CENW)

Dataset used for the paper "Modelling COVID-19 pandemic control strategies in metropolitan and rural health districts in New South Wales, Australia" published in the journal 'Scientific Reports'.

Administrative information about individuals in Wales that use NHS services; such as address and practice registration history. It replaced the NHS Wales Administrative Register (NHSAR) in 2009.

Data drawn from GP practices via Exeter System.

This dataset provides linkage from anonymous individual to anonymous residences, thus enable to group households of individuals.

A single-view version of WDS (called PER_RESIDENCE_GPREG) provided by Digital Health and Care Wales (DHCW) superseded the previous three-view version WDS in September 2022. SAIL produces cleaned versions of these views. The cleaned versions of the new single-view WDS are called WDSD_CLEAN_AR_PERS and WDSD_CLEAN_GEO_RALF.

Associated Media

https://saildatabank.com/about-us/overview/ , https://popdatasci.swan.ac.uk/centres-of-excellence/sail/ , https://saildatabank.com/

Between January and August 2020, there has been approximately 48.2 thousand deaths in England and Wales with COVID-19 as an underlying cause. As illustrated in the table, the number of deaths as a result of COVID-19 are much higher than from either pneumonia or influenza. There has been over three times the number of deaths from COVID-19 than pneumonia and influenza so far in 2020. The overall number of confirmed COVID-19 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.

This data is from a survey (Stakeholder survey), undertaken as part of the work of the Wales COVID-19 Evidence Centre, during the COVID-19 pandemic (2021-2023).The survey was sent to key stakeholders (health and social care decision makers e.g. from Social Care Wales, Welsh Government, National Health Service), who had a rapid synthesis of research evidence completed by the Wales Covid-19 Evidence Centre. Questions included those asking about the Centre processes, use of the findings and other feedback in this area. 22 stakeholders completed the survey.The data is from a survey designed and managed in On-line surveys (https://www.onlinesurveys.ac.uk). The data was downloaded in Excel and is presented in this format. The questions are presented as the top line of each column.Some data and identifiers were removed (i.e. names. job title, place of work, any comments that may identify them, and feedback where participants did not give permission to quote this (as indicated in the file)) in order to anonymise the data, as respondents had not consented to have their data shared without anonymisation.

COVID-19 UK Non-hospital Antigen Testing Results (Pillar 2) data is required by NHS Digital to support COVID-19 requests for linkage, analysis and dissemination.

The Coronavirus (COVID-19) Press Briefings Corpus is a work in progress to collect and present in a machine readable text dataset of the daily briefings from around the world by government authorities. During the peak of the pandemic, most countries around the world informed their citizens of the status of the pandemic (usually involving an update on the number of infection cases, number of deaths) and other policy-oriented decisions about dealing with the health crisis, such as advice about what to do to reduce the spread of the epidemic.

Usually daily briefings did not occur on a Sunday.

At the moment the dataset includes:

UK/England: Daily Press Briefings by UK Government between 12 March 2020 - 01 June 2020 (70 briefings in total)

Scotland: Daily Press Briefings by Scottish Government between 3 March 2020 - 01 June 2020 (76 briefings in total)

Wales: Daily Press Briefings by Welsh Government between 23 March 2020 - 01 June 2020 (56 briefings in total)

Northern Ireland: Daily Press Briefings by N. Ireland Assembly between 23 March 2020 - 01 June 2020 (56 briefings in total)

World Health Organisation: Press Briefings occuring usually every 2 days between 22 January 2020 - 01 June 2020 (63 briefings in total)

More countries will be added in due course, and we will be keeping this updated to cover the latest daily briefings available.

The corpus is compiled to allow for further automated political discourse analysis (classification).

NHS Wales hospital admissions (Inpatients and daycases) dataset comprising of attendance and clinical information for all hospital admissions: includes diagnoses and operations performed. Includes spell and episode level data.

The data are collected and coded at each hospital. Administrative information is collected from the central PAS (Patient Administrative System), such as specialty of care, admission and discharge dates. After the patient is discharged the handwritten patient notes are transcribed by clinical coder into medical coding terminology (ICD10 and OPCS).

The data held in PEDW is of interest to public health services since it can provide information regarding both health service utilisation and also the incidence and prevalence of disease. However, since PEDW was created to track hospital activity from the point of view of payments for services, rather than epidemiological analysis, the use of PEDW for public health work is not straightforward. For example:

Counts will vary depending on the number of diagnosis fields used e.g. primary only, all fields; There are a number of different things that can be counted in PEDW e.g. individual episodes of care, admissions, discharges, periods of continuous care (group of episodes), patients or procedures. When looking at diagnosis or procedures the number will vary depending on whether you look at only in the primary diagnosis / procedure field or if the secondary fields are also included. Coding practices vary. In particular, coding practices for recording secondary diagnoses is likely to vary for different hospitals. This makes regional variations more difficult to interpret. The validation process led by the Corporate Health Improvement Programme and implemented by Digital Health and Care Wales (DHCW) is aiming to address some of these inconsistencies.

Due to the complexity and pitfalls of PEDW it is recommended that any PEDW requests for public health purposes are discussed with a member of the SAIL team. In turn the SAIL will seek advice from DHCW if required.

This dataset requires additional governance approvals from the data provider before data can be provisioned to a SAIL project.