Skip to main content

Table 1 An overview and summary of some potential electronic databases for resource-use information; please note that the list is not exhaustive

From: Self-reported and routinely collected electronic healthcare resource-use data for trial-based economic evaluations: the current state of play in England and considerations for the future

Name of database/ service software

Service category

Comments about the data

Data dictionary

(Yes/No)

Primary care databases

Clinical Practice Research Datalink (CPRD)

Primary care

Collects data from Vision (historically), EMIS (more recently), and potentially SystmOne (being piloted at time of writing) GP practice software systems. Reportedly covers over 11.3 million patients (4.4 million active patients) from 674 practices in the UK b – this was the figure reported for just Vision practices.

Yes (Read code based)

The Health Improvement Network (THIN) database

Primary care

Collects data from Vision GP practice software systems. Reportedly covers 11.1 million patients (3.7 million active patients) from 562 general practices in the UK b

Yes (Read code based)

ResearchOne

Primary care (and other contributing organisations – see ‘comments’)

Collects data from SystmOne GP practice software systems. Also reportedly collects data from other services using SystmOne. As of 2013, ResearchOne reportedly includes 5 million health records from 400 contributing organisations across 10 organisation types (ranging from hospitals to end-of-life organisations)b

Yes (Read code based)

QResearch

Primary care

Collects data from EMIS GP practice software systems. Based on current publications associated with this dataset, unsure what resource-use data is available as not used for economic studies. As of 2015, the database reportedly obtains data from a sample of approximately 1000 practices covering a population of 18 million peopleb

Yes (Read code based)

NHS Digital databases

Secondary Uses Service (SUS)

Healthcare data

Designed to provide anonymous patient-based data for purposes other than direct clinical care, such as healthcare planning, commissioning, public health, clinical audit and governance, benchmarking, performance improvement, medical research and national policy development. SUS will only provide data for the region of interest to the commissioners if obtained through NHS commissioners. SUS is updated once a month.

Yes (note, includes a variety of commissioning data)d

Hospital Episode Statistics (HES)

Secondary care

Hospital care data (inpatient, outpatient, A&E, and critical care). Once a month and at pre-arranged dates during the year, SUS takes an extract from their database and sends it to HES – it is this data which populates the HES database.

Yes (online)e

General Practice Extraction Service (GPES)

Primary care

GPES is part of the GP collection service alongside the Calculating Quality Reporting Service (CQRS) used to record practice participation and to process and display information. GPES collects primary care information from GP IT systems and then presents it at a National level. Used to inform GP payments. Collects both anonymised and person-identifiable data (PID; when permitted). Main focus is clinical data (i.e. Quality Outcomes Framework [QOF] data), not resource-use data.

General overview of data that can be viewed in GPES is listed onlinef

Diagnostic Imaging Dataset (DIDS)

Diagnostic

NHS-funded diagnostic imaging tests

Yes (online)g

Improving Access to Psychological Therapies (IAPT)

Mental health

Adults in receipt of NHS-funded IAPT services (see data dictionary).

Yes (online)h

Mental Health Services Data Set (MHSDSb

Mental health

Record-level data on care of children, young people and adults who are in contact with mental health, learning disability or autism spectrum disorder services.

Yes (online)i

Raw data extraction based on study by M Franklin, V Berdunov, et al (2014)a

Patient Administration System (PAS)

Hospital

Hospitals collect data into PAS (in Sheffield this is the Lorenzo system, which is a well-established system in England). This dataset includes basic hospital activity (i.e. inpatient, outpatient, and A&E); other detailed clinical information may be held on other hospital systems.

See HES data dictionary for a general overview

SystmOne, EMIS, Vision

Primary care

SystmOne, EMIS and Vision currently dominant primary care software systems in England. Each collects and records data slightly differently, but underlying data are coded based on Read Codes (most if not all should be using SNOMED CT by April 2018). Note, the methods used by Franklin et al (2014) did not rely on the use of Read Codes, rather front-end report outputs which were processed using visual basic for application (VBA) scripts.

See ‘Read Codes and SNOMED CT’

Intermediate care, mental health trust, ambulance services, and social care systems

Various services

The study by M Franklin, V Berdunov et al (2014) collected raw electronic data from all these systems. It is possible to collect these data after discussion with the service and consent agreements from the patients of interest.

No – data based on discussion with services

Technology for future consideration

Read Codes and SNOMED CT

Primary care

Read codes can be obtained from the Technology Reference data Update Distribution (TRUD) website. SNOMED CT is a more unified coding base than current Read codes. Software systems have been developed to export information from primary care systems in a more usable manner, such as the Apollo software system.

Yes – a Read Browser and Read codes are required j

GP Connect and Data Commissioning Flows

Primary care (initially)

GP Connect and Data Commissioning Flows works are in their early stages; it is difficult to gauge the possible benefits these plans will bring from a researcher perspective.

N/A

Bespoke linked dataset examples

NorthWest EHealth linked database

Linked datasets

Information on medications, symptoms and use of healthcare facilities.

Contact provider

CALIBER dataset

Linked datasets

Linked data for primary care (CPRD), coded hospital records (HES), social deprivation information and cause-specific mortality data (ONS).

Contact provider

  1. Footnote. Website references for all of the aforementioned databases and software systems are provided in Box 2. Links to online data dictionaries, if available, are listed at the end of this footnote
  2. aThese figures were reported on the databases own website and were still present on the website as of 10th April 2017
  3. bResource-use data could be a part of any database in theory because some of these aspects are coded in the services; however, they are only useful if the data are then included in the larger databases at the person-level (rather than national level, such as for GPES)
  4. cNote, based on comments from the NHS Digital Standardisation Committee for Care Information (SCCI) in 2015(https://nhs-digital.citizenspace.com/scci/mhsds/), MHSDS is a change to the Mental Health and Learning Disabilities Data Set (MHLDDS) that supersedes and replaces this standard, as well as the following: Child and Adolescent Mental Health Services (CAMHS) data set; Mental Health Care Cluster; Mental Health Clustering Tool; Learning Disabilities Census (LDC), included in Assuring Transformation standard. MHSDS will also incorporate the requirements of Children and Young People’s Improving Access to Psychological Therapies (CYP IAPT)
  5. dSUS data dictionary (includes a variety of Commissioning Data Sets [CDS]): http://www.datadictionary.nhs.uk/data_dictionary/nhs_business_definitions/s/secondary_uses_service_wu.asp?shownav=1
  6. e HES data dictionary: https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/hospital-episode-statistics-data-dictionary
  7. f CQRS services and data that can be viewed in GPES: https://digital.nhs.uk/services/general-practice-extraction-service#types-of-data
  8. g DIDS data dictionary: http://www.datadictionary.nhs.uk/data_dictionary/messages/clinical_data_sets/data_sets/diagnostic_imaging_data_set_fr.asp?shownav=1
  9. h IAPT data dictionary: http://www.datadictionary.nhs.uk/data_dictionary/messages/clinical_data_sets/data_sets/improving_access_to_psychological_therapies_data_set_fr.asp?shownav=1
  10. i MHSDS data dictionary: http://www.datadictionary.nhs.uk/data_dictionary/messages/clinical_data_sets/data_sets/mental_health_services_data_set_fr.asp?shownav=1
  11. j Read codes (https://isd.digital.nhs.uk/trud3/user/guest/group/2/pack/9) and SNOMED CT UK edition (https://isd.digital.nhs.uk/trud3/user/guest/group/2/pack/26)