A Harmonised Approach to Curating Research-Ready Datasets for Asthma, Chronic Obstructive Pulmonary Disease (COPD) and Interstitial Lung Disease (ILD) in England, Wales and Scotland Using Clinical Practice Research Datalink (CPRD), Secure Anonymised Information Linkage (SAIL) Databank and DataLoch
- PMID: 38595770
- PMCID: PMC11002787
- DOI: 10.2147/CLEP.S437937
A Harmonised Approach to Curating Research-Ready Datasets for Asthma, Chronic Obstructive Pulmonary Disease (COPD) and Interstitial Lung Disease (ILD) in England, Wales and Scotland Using Clinical Practice Research Datalink (CPRD), Secure Anonymised Information Linkage (SAIL) Databank and DataLoch
Abstract
Background: Electronic healthcare records (EHRs) are an important resource for health research that can be used to improve patient outcomes in chronic respiratory diseases. However, consistent approaches in the analysis of these datasets are needed for coherent messaging, and when undertaking comparative studies across different populations.
Methods and results: We developed a harmonised curation approach to generate comparable patient cohorts for asthma, chronic obstructive pulmonary disease (COPD) and interstitial lung disease (ILD) using datasets from within Clinical Practice Research Datalink (CPRD; for England), Secure Anonymised Information Linkage (SAIL; for Wales) and DataLoch (for Scotland) by defining commonly derived variables consistently between the datasets. By working in parallel on the curation methodology used for CPRD, SAIL and DataLoch for asthma, COPD and ILD, we were able to highlight key differences in coding and recording between the databases and identify solutions to enable valid comparisons.
Conclusion: Codelists and metadata generated have been made available to help re-create the asthma, COPD and ILD cohorts in CPRD, SAIL and DataLoch for different time periods, and provide a starting point for the curation of respiratory datasets in other EHR databases, expediting further comparable respiratory research.
Keywords: COPD; HER; ILD; asthma; data curation; harmonisation.
© 2024 Hatam et al.
Conflict of interest statement
AS has been supported by institutional research grants from the Industrial Strategy Challenge Fund, the Medical Research Council and Health Data Research, and from the UK and Scottish Governments for the Usher Data Driven Innovation Hub which manages DataLoch. JKQ has been supported by institutional research grants from the Industrial Strategy Challenge Fund, the Medical Research Council, Health Data Research, GSK, BI, asthma+lung UK, AZ and received personal fees for advisory board participation, consultancy or speaking fees from GlaxoSmithKline, Evidera, Chiesi, AstraZeneca, Insmed. SS reports grants from Industrial Strategy Challenge Fund, grants from Medical Research Council, grants from Health Data Research UK, during the conduct of the study; grants from Industrial Strategy Challenge Fund, grants from e Medical Research Council, grants from Health Data Research UK, outside the submitted work. CO reports grants from Medical Research Council, during the conduct of the study. The authors report no other conflicts of interest in this work.
Figures




Similar articles
-
Incidence and prevalence of asthma, chronic obstructive pulmonary disease and interstitial lung disease between 2004 and 2023: harmonised analyses of longitudinal cohorts across England, Wales, South-East Scotland and Northern Ireland.Thorax. 2025 Jun 16;80(7):466-477. doi: 10.1136/thorax-2024-222699. Thorax. 2025. PMID: 40199588 Free PMC article.
-
Patient pathways for four major chronic respiratory diseases in England between 2008 and 2021.BMJ Open Respir Res. 2024 Aug 28;11(1):e002273. doi: 10.1136/bmjresp-2023-002273. BMJ Open Respir Res. 2024. PMID: 39209353 Free PMC article.
-
UK Electronic Healthcare Records for Research: A Scientometric Analysis of Respiratory, Cardiovascular, and COVID-19 Publications.Pragmat Obs Res. 2024 Aug 15;15:151-164. doi: 10.2147/POR.S469973. eCollection 2024. Pragmat Obs Res. 2024. PMID: 39161588 Free PMC article. Review.
-
Harmonising electronic health records for reproducible research: challenges, solutions and recommendations from a UK-wide COVID-19 research collaboration.BMC Med Inform Decis Mak. 2023 Jan 16;23(1):8. doi: 10.1186/s12911-022-02093-0. BMC Med Inform Decis Mak. 2023. PMID: 36647111 Free PMC article.
-
Identifying Patients with Group 3 Pulmonary Hypertension Associated with COPD or ILD Using an Administrative Claims Database.Lung. 2022 Apr;200(2):187-203. doi: 10.1007/s00408-022-00521-6. Epub 2022 Mar 29. Lung. 2022. PMID: 35348836 Free PMC article. Review.
Cited by
-
Recording of Alcohol Use Disorder in Electronic Health Records: Developing a Recommended Codelist for Research.Clin Epidemiol. 2024 Oct 4;16:673-681. doi: 10.2147/CLEP.S477778. eCollection 2024. Clin Epidemiol. 2024. PMID: 39380579 Free PMC article.
-
Incidence and prevalence of asthma, chronic obstructive pulmonary disease and interstitial lung disease between 2004 and 2023: harmonised analyses of longitudinal cohorts across England, Wales, South-East Scotland and Northern Ireland.Thorax. 2025 Jun 16;80(7):466-477. doi: 10.1136/thorax-2024-222699. Thorax. 2025. PMID: 40199588 Free PMC article.
-
Is alcohol use disorder associated with higher rates of depression and anxiety among people with new onset type 2 diabetes? A cohort study using linked primary care data in England.BMC Prim Care. 2024 Oct 30;25(1):386. doi: 10.1186/s12875-024-02628-6. BMC Prim Care. 2024. PMID: 39478484 Free PMC article.
-
Mortality Outcomes in People with Lung Cancer with and without Type2 Diabetes: A Cohort Study in England.Clin Epidemiol. 2025 Jul 17;17:681-692. doi: 10.2147/CLEP.S498368. eCollection 2025. Clin Epidemiol. 2025. PMID: 40692755 Free PMC article.
-
An automation framework for clinical codelist development validated with UK data from patients with multiple long-term conditions.BMC Med Res Methodol. 2025 May 24;25(1):138. doi: 10.1186/s12874-025-02541-1. BMC Med Res Methodol. 2025. PMID: 40413381 Free PMC article.
References
-
- British Lung Foundation. Asthma Statistics; 2023.
-
- All Party Parliamentary Group on Respiratory Health. Report on inquiry into respiratory deaths. https://www.blf.org.uk/sites/default/files/APPG-Respiratory-deaths-2014-....Accessed March 27, 2024.
LinkOut - more resources
Full Text Sources