Datasets

The NHS Covid-19 Reference Library describes the datasets being used in the NHS Covid-19 datastore, and the sources of those datasets..

111 online screening data NHS England

Aggregated view of how and where the NHS 111 online service is being used, broken down by clinical commissioning group (CCG) and disposition code to allow for geographical and outcomes analysis.



111 telephony service activity records NHS England

Aggregated view of calls to the NHS 111 service broken down by clinical commissioning group (CCG) and disposition code to allow for geographical and outcomes analysis.



999 telephony activity records NHS England

Gives aggregate view of calls to the 999 service broken down by clinical commissioning group (CCG) and disposition code to allow for geographical and outcomes analysis.



A&E sitrep NHS Improvement
New

Daily situation report submitted by all providers with a type 1 A&E department (consultant led 24 hour service with full resuscitation facilities and designated accommodation for the reception of accident and emergency patients), collecting information such as number of A&E attendances in previous 24 hours, long stay patients and bed occupancy.



Aggregated 111 call (NHSI) NHS Improvement
New

Number of daily triaged calls per clinical commissioning group (CCG) and among triaged calls number of A&E, ambulance and primary care calls. Includes disposal of call. Contains information on all 111 calls, not just those specifically related to COVID-19.



Allocate absence reports Allocate system
New

Absence reports as recorded in the Allocate system which is widely used across care providers.



Bridges to Health Population Segmentation NHS England
New

The Bridges to Health Population Segmentation dataset is an existing data asset that has been developed by NHSEI, Outcomes Based Healthcare and NHS AGCSU. This contains detail on patient comorbidity flags to support the understanding of disease prevalence, multimorbidity and modelling of patient characteristics.



Care home beds NE CSU (NHSE)

Capacity information for bed availability in care homes - received via LogicApp. Partial coverage of England care homes.



Code description mappings for SUS data items Open source
New

Mapping tables that convert codes used throughout the SUS datasets into human readable descriptions, e.g. SNOMED codes for diagnoses and outcomes.



Consultation rates for influenza-like illness (ILI) WHO & ECDC
New

Consultation rates for influenza-like illness (ILI) by week for England published by WHO & ECDC (https://flunewseurope.org/CountryData?country=UKG13182).



Country information - Lat Longs and population. Open source
New

A list of countries, their location and population.



COVID-19 Cases and Deaths in Scotland Public Health Scotland
New

This dataset captures open source data from Public Health Scotland, as published on their online dashboard: https://www.arcgis.com/home/item.html?id=5a93583e03cb4e74a1c8ff2bd8a3e89f. It contains cumulative cases by Health Board and by Council Area, as well as a time series for the cases at the national level.



COVID-19 Cases and Deaths in Wales Public Health Wales
New

This dataset captures open source data from Public Health Wales, as published on their online dashboard: https://public.tableau.com/profile/public.health.wales.health.protection#!/vizhome/RapidCOVID-19virology-Public/Summary

It contains cumulative cases by Health Board and by Local Authority, as well as a time series for the cases at the national level.



Covid-19 Hospitalisation in England Surveillance System (CHESS) Public Health England

Contains epidemiological data (demographics, risk factors and clinical information on severity and outcome) on COVID-19 infection in persons requiring hospitalisation and intensive care unit (ICU)/high dependency unit (HDU).



COVID Critical Care data Directory of Services (DoS)
New

From DOS (Directory of Services). More detail provided in the adult critical care bed state definitions document.



COVID related death information NHS England
New

Patients who have died in hospitals in England who had tested positive for COVID-19 at time of death. Includes all deaths reported up to 5pm on the previous day.



CQC care home data (reference data) Open source
New

List of care homes including: care home name, address, postcode, provider, local authority, region and id Datasource found here: https://www.cqc.org.uk/files/cqc-care-directory-csv-format



Daventry DHL Inventory DHSC
New

This data source includes the inventory at Daventry DHL for PPE supplies specifically used at testing sites. The dataset includes the item name, item description, and quantity count at end of day.



Deloitte Digital System Deloitte
New

The outputs form the Deloitte Digital System: the booking data for all tests - regional and satellite test centres, and mobile testing units.



Discharge SITREP Open source
New

This is a situation report of all discharges from hospitals and where they have been discharged to (e.g. care home, home, hospice etc.).



End of Day Report at STCs DHSC
New

This is the end of day report from Satellite Test centres for number of tests completed that day by type.



English Prescribing Dataset (EPD) NHS BSA (open source)
New

The English prescribing dataset contains detailed information on prescriptions issued in England that have been dispensed in England, Wales, Scotland, Guernsey, Alderney, Jersey, and the Isle of Man.



ESR data with age risk NHS England
New

This dataset contains data for modelling potential sickness among NHS staff.



ESR sickness NHS Electronic staff record (ESR) system
New

All absences of NHS staff specifically marked as related to COVID-19, including sickness, self-isolation and special leave (e.g. carer’s leave). Contains details of where the person works, their staff group and duration of absence.



ESR workforce NHS Improvement
New

Includes number of hospital staff employed by trust, including specialty and staff group, and a count of ambulance staff. Includes some information on training to understand volumes of staff trained in ventilation.



Health and Justice SITREP NHS England
New

This dataset captures the spread of COVID in the prison setting. It includes details about cases among the prison population, impact on prison staffing levels due to COVID absences and PPE information.



Historical testing sites SITREPs Deloitte

This data includes historical sitrep response data from testing sites including their personal protective equipment (PPE) inventory, testing kit inventory, and personnel. This helps to form a complete picture of testing site demand. Covers inventory of testing items, number of personnel on site, PPE and consumable inventory.



Hospital COVID SITREP v2 NHS England
New

Daily situation report to collect information on the current burden on hospitals, including: bed capacity and availability for COVID-19 and non-COVID-19 patients, oxygen, non-invasive ventilation and ventilator demand and capacity, and staff absences. Includes snapshot data for number of patients in beds at 08:00 each day, COVID-19 admissions and discharges for the previous 24 hours and staff absences.



ICNARC NHS England
New

What support is being given to a patient and clinical information about that patient. Reporting completed; (i) after COVID-19 case enters a unit (ii) after 24 hours (iii) after patient leaves critical care (iv) after patient discharge.



International data daily dump of cases (infected, recovered, fatalities) European Centre for Disease Prevention and Control (ECDC)
New

Geographic distribution of COVID-19 cases worldwide, including infections, recoveries and fatalities which is reported on a daily basis.



Inventory, orders and deliveries of PPE NHS Supply Chain
New

Data received from national distribution centes including Haydock, Daventry and Clipper.



ISP SITREP NHS England
New

Daily situation report to collect information on the current burden on hospitals, including: bed capacity and availability for COVID-19 and non-COVID-19 patients, oxygen, non-invasive ventilation and ventilator demand and capacity, and staff absences. Includes snapshot data for number of patients in beds at 08:00 each day, COVID-19 admissions and discharges for the previous 24 hours and staff absences. Replication of the COVID-19 sitrep for independent service providers (ISPs).



Key worker testing programme (pillar 2) NPEX/Randox
New

This dataset provides information about all key worker testing data which runs through the Randox system.



Lab inventory & Throughput Deloitte
New

Describes the entire testing supply chain.



Location data for CCGs, STPs, Trusts, Hospitals, Independent Providers, Regions, GP practices and Care home HQs. Various
New

Location data for the following organisations: CCGs, STPs, Trusts, Independent providers, Regions and GP Practices.



Location mapping data Open source
New

Data to allow mapping between geographies, including: LSOA to UTLA, LAD to Region, LSOA to CCG to LAD, LSOA to CCG to STP and CCG to NHSER.



Master Patient Index (MPI) NHS England
New

De-identified demographics with middle layer super output area (MSOA), lower layer super output area (LSOA) and flags such as frailty which provide healthcare markers.



Mental Health COVID SITREP NHS England
New

Daily situation report to collection information on the current burden on mental health trusts, including bed capacity and availability for COVIDand non-COVID patients, oxygen, non-invasive ventilation and ventilator demand and capacity, and staff absences. Includes snapshot data for number of patients in beds at 8am each day, COVID-19 admissions and discharges for the previous 24 hours and staff absences.



Mortuary Capacity SITREP NHS Estates Division
New

This dataset captures mortuary capacity information at trust level.



MTU Location Bookings DHSC
New

This is a dataset for the historic locations of Mobile Test Units (MTUs).



National Inventory & Deliveries from NHS Supply Chain NHS Supply Chain
New

NHS Supply Chain Inventory and delivery of ICU Consumables.



National Orders for Consumables NHS Supply Chain
New

This is the details of products requests by trusts from the suspended product lists – this includes the details of a delivery point of contact at the trust and their phone number (this is the same as the process for oxygen and ventilator equipment).



NHS Status Tracker NHS England
New

This dataset helps us understand how and where coronavirus (COVID-19) is affecting people now.



NOMIS Census Data NOMIS
New

Open source data detailing estimated and projected populations for England locations based on census data.



Number of outbreaks in care homes PHE
New

This dataset includes management information describing the number of care homes reporting a suspected or confirmed outbreak of COVID-19 to PHE, together with the cumulative proportion of all care homes that have reported an outbreak. Figures are included for each week starting from 2 March 2020 by local authority, government office region and PHE centre.



Open Source - PHE Testing Centres and Boundaries Open source
New

This file contains the digital vector boundaries for Public Health England Centres in England as at December 2016.



Open source international testing data Open source
New

This data is the volume of testing results from other countries. It is an open source dataset taken from https://ourworldindata.org/covid-testing



Organization and Region Situation Reports Regional EPRR teams
New

Situation reports from trusts and regions, including RAG ratings (red, amber or green) of patient services, business continuity plans in place or suspended capabilities, as well as a forward look of the situation.



Oxford Coronavirus Government Response Tracker Oxford University
New

Systematic information on which governments have taken which measures, and when, can help decision-makers and citizens understand the robustness of governmental responses in a consistent way, aiding efforts to fight the pandemic. The Oxford COVID-19 Government Response Tracker (OxCGRT) systematically collects information on several different common policy responses governments have taken, scores the stringency of such measures, and aggregates these scores into a common Stringency Index. Data is collected from public sources by a team of over one hundred Oxford University students and staff from every part of the world: https://www.bsg.ox.ac.uk/research/research-projects/coronavirus- government-response-tracker



Oxygen and ventilator survey NHS England
New

Holds data from a survey conducted to gather information on ventilator equipment across the NHS. This was completed by Trust representatives on a per hospital basis and captures data about ventilator type, make, model, ownership and quantity



Oxygen gas supply and capacity NHS England

Details the is the oxygen supply, delivery capacity, gas pipeline system and ventilation system capacity. Broken down by trust and hospital.



PHE Lab Test Data - Aggregate Public Health England
New

Positive test results from PHE SGSS (Second Generation Surveillance System). Includes Pillar 1 testing only (swab testing in PHE labs and NHS hospitals for those with a medical need and the most critical workers and their families).



PHE Lab Test Data - Record Level Public Health England
New

Anonymised positive test results from PHE SGSS (Second Generation Surveillance System). Includes Pillar 1 testing only (swab testing in PHE labs and NHS hospitals for those with a medical need and the most critical workers and their families).



PHE negative test results PHE
New

Anonymised negative test results from PHE SGSS (Second Generation Surveillance System). Contains Pillar 1 tests only (swab testing in PHE labs and NHS hospitals for those with a medical need and the most critical workers and their families).



Population data by Region, STP, CCG. Open source
New

Population data by administrative area broken down by age group and sex



PPE SITREP NHS Improvement
New

This dataset captures PPE information at hospital level. The information captured is on stock quantity, used quantity and RAG rating of each set of PPE items (aprons, body bags, clinical waste bags, coveralls, detergent, eye protection, visors, gloves, hand hygiene, masks, swabs).



PPE supply chain (approved suppliers and orders) NHS Supply Chain
New

This dataset is a list of potential PPE orders and an assessment around whether this product should be ordered or rejected.



PPE supply chain (suppliers, products) Mendex
New

This is a list of potential PPE products, each unique to a specific supplier.



Product Mappings for consumables alternatives NHS Supply Chain
New

This is a list of NCP codes for consumables, and their groupings into ‘alternatives’ of similar products.



Record level 111 data (NHSI) NHS England
New

Information regarding each NHS 111 call (connect timestamp, triage timestamp, clinical advisor transfer timestamp, is ambulance called, symptom group, disposition, etc).



Referral To Treatment Time data NHS England
New

Referral To Treatment data reported to NHSE/I (treatment types and wait times).



Satellite testing sites DHSC
New

This is a list of satellite testing sites.



Segmentation NHS England

Record level registry containing condition flags for comorbidities for all patients in the master patient index. Developed using the Bridges to Health population segmentation approach.



Shielded Patient List NHS Digital

Dataset provided by NHS Digital, containing record level information for patients that are part of the shielding programme.



SPI-M forecast DHSC
New

SPI-M is producing forecasting numbers, on a regional level around metrics ranging from new and newly confirmed patients in hospitals, bed occupancies, ICU occupancies



Splunk 111 - Vodafone NHS England

Raw NHS 111 call data (1 day lag). Not linkable to other record level sources, broken down by area code.



Supply Chain - PPE - SCCL Distribution Centre data NHS England
New

Contains details on the supply chain of personal protective equipment (PPE) covering inventory, orders and deliveries from national distribution centres.



Supply Chain -China freight NHS England
New

Holds information on upcoming shipments of personal protective equipment (PPE) from China to the UK.



SUS+ ECDS NHS England
New

Contains details on emergency care attendances, including to A&E and urgent care/walk-in centres. Includes details such as presenting complaint, investigations, arrival mode, attendance duration and outcome to understand reasons for attendance, severity and emergency admissions.



SUS+ Inpatient (Admitted Patient Care Episodes - APCE - and Admitted Patient Care Spells - APCS) NHS England
New

Inpatient admissions, includes detail such as length of stay, admission type (emergency/elective), diagnosis, procedures and discharge destination.



SUS+ Outpatient (OPA) NHS England
New

Attendances at outpatient clinics with data held at record level. Contains detail such as specialty, source of referral, attendance date and appointment outcome.



Testing: Stock Levels at RTCs DHSC
New

This dataset is part of the daily reporting from RTCs. It includes PPE, associated items and test kits.



Testing PPE inventory Deloitte
New

Testing personal protective equipment (PPE) inventory, burn rates, and demand forecasts. The data included contains: the inventory of PPE stock in each testing location, the utilisation rate of PPE at each location, forecast demand and opening and closing stock projections for each day. This data is used to support the PPE dashboard



Testing Site Predicted Capacity Deloitte

This dataset includes details of the predicted capacity of all testing sites at specific dates, based on inventory of the number of testing kits available and predicted demand.



Testing Site Predicted Demand Deloitte

This dataset includes details about the predicted demand for testing at each site.



UKHF NHS England
New

Contains publicly available health-related datasets such as those published on Public Health England, NHS England Statistics and NHS Digital websites.



Ventilator Orders NHS England

From each supplier, country, price how many delivered each week.



Workforce - Social Care, The Adult Social Care Workforce Data Set https://www.skillsforcare.org.uk/
New

This dataset is a list of the number of staff in social care broken down by staff type.



Workforce - Temporary/Bank Staff NHS England
New

This is an anonymised datasource for all temporary and bank staff employed in the NHS.