Article Text

P20 A database approach to DOSE score calculation as a tool to identify ‘at risk’ Chronic Obstructive Pulmonary Disease patients through clinical records
  1. LA Rigge1,
  2. M Johnson2,
  3. D Culliford2,
  4. N Williams3,
  5. L Josephs4,
  6. M Thomas4,
  7. T Wilkinson1
  1. 1NIHR CLAHRC Wessex, University of Southampton, Clinical and Experimental Sciences & University Hospital Southampton NHS Foundation Trust, Southampton, UK
  2. 2NIHR CLAHRC Wessex, Methodological Hub, Southampton, UK
  3. 3University of Southampton, Clinical and Experimental Sciences & University Hospital Southampton NHS Foundation Trust, Southampton, UK
  4. 4NIHR CLAHRC Wessex, University of Southampton, Primary Care and Population Sciences, Southampton, UK


Establishing how best to target resources remains a challenge within COPD as this is a heterogeneous patient group with complex needs often poorly reflected by routinely collected clinical measurements such as FEV1.

Jones et al. created The DOSE score (dyspnoea (MRC score), obstruction (FEV1 percentage predicted), smoking status and exacerbation number in a year) (Table 1) a validated, clinically useful measure of risk stratification in COPD which utilises data already routinely collected in Primary Care for QOF review.

Abstract P20 Table 1

DOSE INDEX SCORING SYSTEM (Jones et al. AJRCCM 2009;180(12):1189–95): The DOSE Index points associated with every category of all four variables are added to build the DOSE Index score

By using a collaborative approach with informatics, statistical and clinical input we developed a database approach to calculating a DOSE score using routinely collected and coded Primary and Secondary Care data. A local NHS database holding anonymised clinical records for over one million patients was used to identify a cohort of over 13,000 patients with codes diagnostic of COPD.

Microsoft Structured Query Language Server was used to identify, cleanse and standardise the required clinical information and calculate the DOSE score, creating a series of functions that can be replicated across other database management systems.

Date of FEV1 percentage predicted was taken as the index date for DOSE score calculation. Where only FEV1 was recorded, a percentage of predicted FEV1 was calculated using available height and age data.

Read codes (the routine coding system used in primary care) and ICD-10 codes were used to compile lists identifying those symptoms, diagnoses and prescriptions indicative of COPD exacerbations. These lists were applied in the year prior to the chosen FEV1 value and, functions were written to cluster those events felt to be reflective of a single exacerbation.

Read codes reflecting MRC score and smoking status closest in time to the index FEV1 measurement were combined with the above measurements, generating a complete score in approximately 10,000 patients. Partial scores were created for a further 1500 patients with incomplete data for the individual score components.

This approach provides a simple way for clinicians to risk stratify their COPD population without increasing their clinical workload. This gives an opportunity to identify those at highest risk of hospital admission and death and proactively allocate resources accordingly.

Statistics from

Request Permissions

If you wish to reuse any or all of this article please use the link below which will take you to the Copyright Clearance Center’s RightsLink service. You will be able to get a quick price and instant permission to reuse the content in many different ways.