Datasets

The NHS COVID‑19 Reference Library describes the datasets being used in the NHS COVID‑19 Data Store, and the sources of those datasets.

Please note: the below list is not exhaustive and all planned datasets may not be included.

As more data is added to support the COVID‑19 response the list will be updated.

111 Evening SITREP

NHS

This SITREP is to be used as part of the monitoring and evaluation for the 111 First project.



111 First sitrep

NHS

Used to fill in gaps in other 111 collections.



111 Online Daily Sitrep

NHS

Data covering 111 online contacts and outcomes.



111 online screening data

NHS England and NHS Improvement

Aggregated view of how and where the NHS 111 online service is being used, by clinical commissioning group (CCG).



111 telephony service activity records

NHS England and NHS Improvement

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. These are calls to the NHS 111 service which are specific to COVID-19.



52ww RTTPTL

NHS

This is a data set to derive 52 week waiters for Referral to Treatment (RTT) Patient Treatment List (PTL).



999 telephony activity records

NHS England and NHS Improvement

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 England and NHS Improvement

Daily situation report submitted by all providers with a type 1 A&E department.



Aggregated 111 call (NHSI)

NHS England and NHS Improvement

Number of daily triaged calls per clinical commissioning group (CCG). Contains information on all NHS 111 calls.



Allocate absence reports

Allocate system

Absence reports as recorded in the Allocate system.



Ambulance collections data

NHS

Data related to ambulance collections including number of incidences and how incidents were responded to.



Apple mobility trends (open data)

Open source

Mobility time series for driving, walking, and public transport calculated by a relative volume of directions requests per country/region, sub-region or city compared to a baseline volume on 13 January 2020.



Average Length of Stay dataset

NHS

Data on average length of stay for non-COVID-19 patients, to support recovery of services.



Bridges to Health Population Segmentation

NHS England and NHS Improvement

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



Cancer equity data pack

Public Health England

Monthly activity data, including 2 week urgent referrals and first definitive treatment data, by tumour type.



Cancer Waiting Times data

NHS

Aggregate and non-aggregate cancer waiting times data, including the faster diagnosis standard and treatment data.



Care home beds

NE CSU (NHSE)

Capacity information for bed availability in care homes, partial coverage of England care homes.



Care Quality Commission (CQC) Deaths data

CQC

COVID-19 and non-COVID-19 deaths at the individual care home level by date.



CCG to 111 area mapping table (reference data)

Open source

A dataset for mapping CCGs to NHS111 area and then to STP.



Code description mappings for SUS data items

Open source

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



Community Discharge Data

NHS

Use to derive community discharge metric (Number of patients who were discharged by 17:00 as a proportion of all patients who met the criteria to be discharged).



Community services data

NHS Digital

Data regarding NHS-funded community services.



Consultation rates for influenza-like illness (ILI)

WHO & ECDC

Consultation rates for influenza-like illness (ILI) by week for England published by WHO & ECDC (flunewseurope.org/).



Country information – Lats, Longs and population

Open source

A list of countries, their location and population.



COVID-19 Cases and Deaths in Scotland

Public Health Scotland

This dataset captures open source data from Public Health Scotland, as published on their online dashboard: www.gov.scot/publications/coronavirus-covid-19-daily-data-for-scotland/ 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 Cases and Deaths in Wales

Public Health Wales

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 Critical Care data

Directory of Services (DoS)

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



COVID-19 Hospitalisation in England Surveillance System (CHESS)

Public Health England

Contains epidemiological data on COVID-19 infection in persons requiring hospitalisation and intensive care unit (ICU) / high dependency unit (HDU).



COVID-19 related death information

NHS England and NHS Improvement

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.



COVID Variant sitrep

NHS

Data regarding new emerging variants, to help give early warning of the potential impact and the protection offered by different vaccinations.



CQC care home data (reference data)

Open source

List of care homes including: care home name, address, postcode, provider, local authority, region and identifier.



Critical care/intensive care units (ICU) consumables and demand

NHS Supply Chain

Forecast of demand for critical care/intensive care units (ICU) consumables and equipment purchases.



Current Providers

NHS

This is a data set to map historic NHS providers to current providers, in particular used where providers have merged.



Daily MDI spells

NHS

Spell attendance data by provider.



Daventry DHL Inventory

DHSC

This data includes the inventory at Daventry DHL for personal protective equipment (PPE) supplies specifically used at testing sites. The data set includes the item name, item description, and quantity count at end of day.



Deloitte Digital System

Deloitte

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



Deprivation index data

ONS

Indices of Multiple Deprivation (IMD)/deprivation index data, split by lower layer super output area (LSOA).



Derived SUS tables with activity for Planning

NHS England and NHS Improvement

Contains adjusted and unadjusted summarised SUS data used for business planning model inputs.



Details of products requested by Trusts from the suspended product lists

NHS Supply Chain

This contains details of product requests by trusts from the suspended product lists including the details of a delivery point of contact at the trust.



Diabetes data

NHS Digital

Data regarding diabetes, includes the National Diabetes Audit (NDA) and Diabetes Prevention Programme (DPP).



Diagnostic imaging data

NHS Digital

Data regarding diagnostic imaging tests carried out on NHS patients, extracted from local Radiology Information Systems (RISs).



Diagnostic Waiting List

NHS

Data regarding diagnostic waiting lists (including endoscopy, physiological measures and imaging).



Discharge SITREP

NHS England and NHS Improvement

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



DM01 - Monthly Diagnostic Waiting Times and Activity

NHS England and NHS Improvement

The monthly diagnostics collection collects data on waiting times and activity for 15 key diagnostic tests and procedures.



E-rostering system feed

NHS

Workforce data from e-rostering systems to enhance workforce availability analysis.



Electronic Referral Service (eRS) data

NHS

Aggregate and non-aggregate Electronic Referral Service data.



End of Day Report at Satellite Test centres (STCs)

DHSC

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)

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.



Enterprise Resource Planning (ERP) system

Deloitte

The Enterprise Resource Planning (ERP) system includes inventory levels for the testing distribution centre (Daventry DHL) as well as the testing labs.



ESR data with age risk

NHS England and NHS Improvement

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



ESR sickness

NHS Electronic staff record (ESR) system

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 Staff Monthly Headcount

NHS

Data regarding monthly headcount from the electronic staff record (ESR).



ESR workforce

NHS England and NHS Improvement

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.



Four Seasons Care Homes (FSCH) reference data

External

Reference data on Four Seasons Care Homes (FSCH).



Google mobility reports (open data)

Open source

These Community Mobility Reports chart aggregated, anonymised movement trends over time by geography, across different categories of places. The most granular level of detail available is the city level.



GP Appointment and Contract Data

NHS

Includes both GP contract services data and GP appointment data. GP appointment data is used to surface GP appointment metrics, including both face to face and virtual. GP contract data is used for learning disability registers and health checks.



Health and Justice SITREP

NHS England and NHS Improvement

This data set captures the number of COVID-19 cases in the prison setting.



Healthcare associated infections (HCAI) collection

HCAI

The Healthcare associated infections (HCAI) collection provides grouped numbers of confirmed nosocomial COVID-19 ingestions per trust on a weekly basis.



Historical testing sites SITREPs

Deloitte

This data provides a summary of historical SITREP response data including their personal protective equipment (PPE) inventory, testing kit inventory, and personnel. This helps to form a complete picture of testing site demand.



Home Care Capacity Tracker

NHS

The capacity tracker captures information related to COVID-19 from care homes and home care settings.



Hospital COVID-19 SITREP v2

NHS England and NHS Improvement

Daily situation report on the current situation with COVID-19 patients in NHS hospitals and NHS funded hospitals.



Hospitalisation metrics for Devolved Administrations

Open source

Data from the daily press briefing pack, capturing critical care bed usage and the active cases in hospital in the devolved administrations.



Independent Service Providers - SITREP

NHS England and NHS Improvement

COVID-19 SITREP for independent service providers (ISPs).



Integrated Urgent Care Aggregate Data Collection (IUCADC) data

NHS

Data regarding integrated urgent care, used to monitor the effectiveness of fully integrated urgent care services through the NHS 111 single entry point. Acts as a replacement to previous 111 data flows.



Intensive Care National Audit & Research Centre (ICNARC)

NHS England and NHS Improvement

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.



Intensive care units (ICU) Consumables Stocktake

NHS Providers

This is a stocktake of intensive care units (ICU) consumable items filled in twice weekly by trusts.



International data daily dump of cases (infected, recovered, fatalities)

European Centre for Disease Prevention and Control (ECDC)

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



Inventory, orders and deliveries of personal protective equipment (PPE)

NHS Supply Chain

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



IPSOS Care Home Survey

IPSOS

This is a survey that is being completed by IPSOS where they phone different care homes and ask various questions about the numbers of residents, amount of potential personal protective equipment (PPE), COVID-19 burden, etc.



Key worker testing programme (pillar 2)

NPEX/Randox

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



Lab inventory & Throughput

Deloitte

Describes the entire testing supply chain.



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

Various

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



Location mapping data

Open source

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.



Lookup file between NHS Trust ID and Clipper Customer ID (for PPE, personal protective equipment, deliveries)

NHS

Lookup table between NHS trust IDs and Clipper customer IDs.



Master Patient Index (MPI)

NHS England and NHS Improvement

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



Maternity services data

NHS Digital

Data regarding NHS-funded maternity services, relating to the mother and baby/babies.



Mental Health and Learning Disabilities (MHLD) data

NHS

Aggregate and non-aggregate mental health and learning disability data used for the recovery of services.



Mental Health COVID-19 SITREP

NHS England and NHS Improvement

COVID-19 SITREP for mental health providers.



Mental Health, Learning Disability and Autism (MHLDA) Independent Service Providers (ISP) SITREP

Independent service providers (ISPs)

Mental Health, Learning Disability and Autism SITREP collected from Independent Service Providers.



Mobile testing unit (MTU) Location Point of Contact Information

DHSC

Contact information for the owner or local authority which runs a Mobile testing unit (MTU) testing location.



Modelling assumptions from NHSEI

NHS England and NHS Improvement

Data containing age-specific assumptions including infection/hospitalisation distributions, population estimates, amongst others.



Modelling data from DHSC testing team

DHSC

A model of testing figures and requirements going forward designed to inform testing policy.



Monthly Activity Return (MAR)

NHS England and NHS Improvement

The monthly activity return collects data relating to elective and non-elective inpatient admissions (FCEs), outpatient referrals and attendances for first consultant outpatient appointments.



Mortuary Capacity SITREP

NHS Estates Division

This dataset captures mortuary capacity information at trust level.



MTU Location Bookings

DHSC

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



National Booking System Data - COVID Vaccinations

NHS

Booking data from the COVID-19 national booking system for vaccinations.



National Inventory & Deliveries from NHS Supply Chain

NHS Supply Chain

Personal protective equipment (PPE) data collected on behalf of DHSC for stock management processes.



National Orders for Consumables

NHS Supply Chain

Details of products requests by trusts from the suspended product lists – this includes the details of a delivery point of contact at the trust.



National Reporting and Learning System (NRLS) clinical incident data

NHS England and NHS Improvement

Clinical incident data from the National Reporting and Learning System (NRLS).



NHS Business Services Authority (BSA) Data

NHS

This is the volumetric data from NHS Business Services Authority (BSA) that states how many people have been notified of their test results. It represents the end of the chain of the testing pipeline.



NHS Status Tracker

NHS England and NHS Improvement

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



NHS Workforce

NHS England and NHS Improvement

This is aggregate/anonymised workforce data, including temporary and bank staff employed in the NHS.



NOMIS Census Data

NOMIS

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



Northern Ireland COVID-19 Tests, Cases and Deaths

Public Health England

Contains aggregated daily COVID-19 cases by age bands split into pillar 1, 2 and total; all at national level. Also contains aggregated daily COVID-19 tests by gender and age bands, provided at local government district level. Finally, aggregated daily COVID-19 deaths by gender and age bands at local government district level.



Number of outbreaks in care homes

Public Health England

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 broken down by local authority, government office region and PHE centre.



Office for National Statistics (ONS) Deaths Data

ONS

Aggregate and non-aggregate death/mortality data, from the office for National Statistics (ONS).



One off aggregate weekly 111 calls extract

NHS England and NHS Improvement

Aggregated data extract detailing NHS 111 calls.



Online Consultations / Video Consultations

NHS

This is data set contains the counts of online and video consultations.



Open Source - PHE Testing Centres and Boundaries

Open source

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

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

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 predicted future view of the situation.



Oxford Coronavirus Government Response Tracker

Oxford University

Systematic information which details the government’s decision and measures taken and when those measures were taken. This data 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.



Oximetry at home

NHS Digital

Data regarding pulse oximeter use by patients as part of the NHS response to COVID-19.



Oxygen and ventilator survey

NHS England and NHS Improvement

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 and NHS Improvement

Details the oxygen and ventilation system capacity.



Personal protective equipment (PPE) purchase order data

NHS

This is personal protective equipment (PPE) purchase order data.



Personal protective equipment (PPE) SITREP

NHS England and NHS Improvement

This data set captures personal protective equipment (PPE) information at hospital level, covering 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).



Personal protective equipment (PPE) supply chain (approved suppliers and orders)

NHS Supply Chain

This data set is a list of potential personal protective equipment (PPE) orders and an assessment around whether this product should be ordered or rejected.



Personal protective equipment (PPE) supply chain (suppliers, products)

Suppliers

This is a list of potential personal protective equipment (PPE) products, each unique to a specific supplier.



PHE care home outbreak data

Public Health England

PHE recorded care home outbreaks at the individual care home level. Records when each care home had outbreaks and how many cases.



PHE combined deaths

Public Health England

Death data from PHE, which is different from COVID-19 Patient Notification System (CPNS) and Office for National Statistics (ONS) death data.



PHE Lab Test Data - Aggregate

Public Health England

Test results from PHE SGSS (Second Generation Surveillance System). Includes Pillar 1 testing only.



PHE Lab Test Data - Record Level

Public Health England

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

Public Health England

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



Pillar 3 antibody testing results

External

Antibody tests results used to support the Vivaldi care home study.



Population data by Region, STP, CCG.

Open source

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



Post-COVID assessment clinic data

NHS

Patient level data collection, from providers of post-COVID assessment clinics.



Pre-deduplicated Second Generation Surveillance System (SGSS) Test Results

Public Health England

Full feed of COVID-19 tests reported into Second Generation Surveillance System (SGSS), prior to deduplication logic being applied by PHE containing all unique tests.



Product Mappings for consumables alternatives

NHS Supply Chain

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



QFlow ACF Booking System

DHSC

This system is used to schedule test sites to power the backend of the gov.uk portal. This is to power testing operations.



Record level 111 data (NHSI)

NHS England and NHS Improvement

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 and NHS Improvement

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



Satellite testing sites

DHSC

This is a list of satellite testing sites.



Screening data

NHS

Eligible population and uptake data regarding screening, including bowel and breast screening.



Secondary Use Services Data (SUS) Plus Emergency Care Data Sets

NHS Digital

Contains details on emergency care attendances, including A&E and urgent care/walk-in centres.



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

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



Splunk 111 - Vodafone

NHS England and NHS Improvement

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



Supply Chain SCCL Distribution Centre data

NHS Supply Chain

Contains supply chain data covering inventory, orders and deliveries from national distribution centres.



SUS+ inpatient/admitted patient care data (Admitted Patient Care Episodes - APCE, Admitted Patient Care Spells - APCS and Critical Care - CC)

NHS Digital

Admitted patient data, including details of admissions, episodes and critical care activity. Includes a daily and monthly flow of the data.



SUS+ Outpatient (OPA)

NHS Digital

Appointments at outpatient clinics, includes a daily and monthly flow of the data.



Test Centre Modelling data

Placers

This data is modelling the demand for each test centre.



Testing: Stock Levels at reginal testing centres (RTCs)

DHSC

This data set is part of the daily reporting from regional testing centres (RTCs). It includes personal protective equipment (PPE), associated items and test kits.



Testing Kit Data

DHL/Deloitte/NHS

This data includes invites, orders and distribution of testing kits, including lateral flow tests.



Testing personal protective equipment (PPE) inventory

Deloitte

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.



Testing Site Predicted Capacity

DHSC

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

DHSC

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



UKHF

NHS England and NHS Improvement

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



Vaccination Data

NHS

Data on Flu and COVID-19 immunisations/vaccinations, including data on metrics, stock transfer, consumables, inventory, healthcare workers, ethnicity and different cohorts.



Vaccine Demand Model

NHS

Data on the weekly forecasted number of vaccines needed in different regions, split up by cohort type.



Ventilator Orders

DHSC

From each supplier and country.



Volunteering data

Royal Voluntary Service & St John Ambulance

Data regarding the volunteer register, and deployment, for vaccination roles. Includes Royal Voluntary Service (RVS) and St John Ambulance.



Waiting list data

NHS

The waiting list of patients expecting to receive treatment.



Weekly Activity Reporting - Inequalities

NHS

Aggregate weekly data, supplied by NHS trusts, with inequalities data added. Includes cancer activity, total activity for imaging and endoscopy, elective admissions and outpatient data.



Weekly NHS activity submissions

NHS Providers

Aggregate data from a new NHS Weekly SITREP from all NHS Providers (Elective activity, Outpatients, Cancer and Diagnostic tests).



Workforce - Social Care, The Adult Social Care Workforce Data Set

https://www.skillsforcare.org.uk/

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



Zoe symptom tracking app data

Swansea University

The COVID-19 Symptom Tracker was designed by doctors and scientists at King’s College London, Guys and St Thomas’ Hospitals working in partnership with ZOE Global Ltd – a health science company. This de-identified dataset is currently hosted by the SAIL Databank at Swansea University here: https://data.ukserp.ac.uk/Asset/View/39.