Background: Real-world data on the benefit/risk profile of medicines is needed, particularly in patients who are ineligible for randomised controlled trials conducted for registration purposes. This paper describes the methodology and source data verification which enables the conduct of pre-licensing clinical trials of COPD and asthma in the community using the electronic medical record (EMR), NorthWest EHealth linked database (NWEH-LDB) and alert systems.
Methods: Dual verification of extracts into NWEH-LDB was performed using two independent data sources (Salford Integrated Record [SIR] and Apollo database) from one primary care practice in Salford (N = 3504). A feasibility study was conducted to test the reliability of the NWEH-LDB to support longitudinal data analysis and pragmatic clinical trials in asthma and COPD. This involved a retrospective extraction of data from all registered practices in Salford to identify a cohort of patients with a diagnosis of asthma (aged ≥18) and/or COPD (aged ≥40) and ≥2 prescriptions for inhaled bronchodilators during 2008. Health care resource utilisation (HRU) outcomes during 2009 were assessed. Exacerbations were defined as: prescription for oral corticosteroids (OCS) in asthma and prescription of OCS or antibiotics in COPD; and/or hospitalisation for a respiratory cause.
Results: Dual verification demonstrated consistency between SIR and Apollo data sources: 3453 (98.6%) patients were common to both systems; 99.9% of prescription records were matched and of 29,830 diagnosis records, one record was missing from Apollo and 272 (0.9%) from SIR. Identified COPD patients were also highly concordant (Kappa coefficient = 0.98). A total of 7981 asthma patients and 4478 COPD patients were identified within the NWEH-LDB. Cohort analyses enumerated the most commonly prescribed respiratory medication classes to be: inhaled corticosteroids (ICS) (42%) and ICS plus long-acting β2-agonist (LABA) (40%) in asthma; ICS plus LABA (55%) and long-acting muscarinic antagonists (36%) in COPD. During 2009 HRU was greater in the COPD versus asthma cohorts, and exacerbation rates in 2009 were higher in patients who had ≥2 exacerbations versus ≤1 exacerbation in 2008 for both asthma (137.5 vs. 20.3 per 100 person-years, respectively) and COPD (144.6 vs. 41.0, respectively).
Conclusion: Apollo and SIR data extracts into NWEH-LDB showed a high level of concordance for asthma and COPD patients. Longitudinal data analysis characterized the COPD and asthma populations in Salford including medications prescribed and health care utilisation outcomes suitable for clinical trial planning.