Skip to content
ALL Metrics
-
Views
13
Downloads
Get PDF
Get XML
Cite
Export
Track
Research Article

Examining the feasibility of using general practice records to determine excess mortality among people with diabetes

[version 1; peer review: awaiting peer review]
PUBLISHED 04 Aug 2025
Author details Author details
OPEN PEER REVIEW
REVIEWER STATUS AWAITING PEER REVIEW

Abstract

Background

Routinely collected data in general practice can be used to monitor and drive quality improvement at a local level.

Aim

We examined whether general practice audit data could be used to determine excess mortality among people with diabetes, and whether practice records are a reliable source of mortality data as compared to national death certificates.

Design and setting

Routine data were collected from GP records on adults with Type 1 and Type 2 diabetes (≥18 years) enrolled in a diabetes programme since 1999.

Method

Practice data were collected as part of routine audit when the programme was first initiated in 1999 and 2016. Cause and date of death were extracted from national death certificates and matched to GP records. Standardised Mortality Ratios (SMR) were calculated.

Results

Of 328 people with type 2 diabetes enrolled in 1999, 165 (50.3%) had died by 2016. Mortality was higher than in the general population: overall SMR=1.17 (95% CI: 1.00-1.38). Less than half of total decedents among the full cohort in 2016 (n=103/226, 46%) had diabetes recorded somewhere on their death certificate. Of the 60 GP records with cause of death recorded, none recorded diabetes as a cause of death.

Conclusion

Linkage of general practice data from a fixed cohort to national death certificates was a feasible way to calculate excess diabetes mortality. GP records currently do not appear to be a reliable source of death data.

Keywords

mortality, structured care, cause of death, diabetes, death certification

Introduction

Data routinely collected in general practice has been referred to as an ‘untapped resource’1, which could be used for monitoring, and to drive quality improvement. Data from general practice Electronic Health Records (EHR) has the advantage of being systematicallya collected, and potentially less affected by issues inherent in other data collection methods; i.e., selective response, non-response, and recall bias2. Mortality data in general practice, in particular, has been underutilised2.

Reducing the risk of all-cause mortality from diabetes is a goal of health systems worldwide3. However, the extent of excess mortality from diabetes is highly variable4; recent studies report a reduction in excess mortality but suggest the magnitude of this decline differs between countries5. Studies using “fixed” cohorts with diagnosed diabetes, for example, general practice populations, more reliably assess mortality risk4,6. Efforts to establish mortality estimates among people with diabetes are hampered by the fact diabetes is often underreported on death certificates7; meaning national statistics may underestimate mortality as a result of diabetes.

In Ireland, there is no national diabetes register. Data on people with diabetes are routinely collected by GP practices participating in primary care initiatives to improve diabetes care8. To understand the potential of this ‘untapped resource’, we examined 1) whether data from a long-running structured diabetes initiative (“fixed” cohort) could be used to determine excess mortality and 2) whether general practice records are a reliable source of mortality data as compared to national death certificates.

Methods

Data sources

We used data extracted from records of people with diabetes (type 1 and type 2) aged 18 years and older enrolled in practices participating in the Midland Diabetes Structured Care Programme. Data were collected as part of routine audit when the programme was first initiated in 19999, and 2016. As patients are enrolled on the programme they provide written informed consent. In 2016 the original cohort were audited together with a systematic sample of the population enrolled at this time, specifically alphabetical order followed by sampling every third person10. Data were collected on demographics, lifestyle factors, clinical parameters, and complications (Table 1).

Table 1. Data collected 1999 and 2016.

Variable19992016
Demographics
   Age
   Sex
   Diabetes type
Lifestyle
   BMI
   Smoking status
Clinical
   HbA1c
   Cholesterol
   Blood pressure
   Serum creatinine
   eGFR (calculated using
CKD-EPI equation11 *)
Complications
   Retinopathy
   Foot ulcer
   Macrovascular complication
    (new in past 12 months)
-
   Attendance at renal clinic
   Minor amputation
Death-

*Females: eGFR = 141 X min(creatinine/0.7, 1)-0.329 X max(creatinine/0.7, 1)-1.209 X 0.993ageX 1.018; Males: eGFR = 141 X min(creatinine/0.9, 1)-0.411 X max(creatinine/0.9, 1)-1.209 X 0.993age

in the 12-month period before the audit

in the 12-month period before first data collection in 1999 (4th March – 21st October)

Vital status for the cohort was also collected in 2016, and people were classified as survivors or decedents. Name, date of birth, date, and cause of death (if available) and GP practice location (town and county) of decedents were obtained from GP records. National death certificates were accessed by FR from the General Registrar Office (GRO) database. The database was searched initially using decedent name and date of death if available. Following this, date of birth and GP location were used to verify the correct match. Data matching was conducted in 2017. Once the record was identified, cause of death, underlying cause of death and date of death were extracted from the death certificate. Primary cause was the condition directly leading to death, underlying cause of death was coded as the last listed antecedent cause on the death certificate. Cause of death was manually coded according to the International Classification of Diseases 10th revision (ICD-10). Mortality data from the national population and four counties in the Midlands of Ireland covered by the structured programme (Offaly, Longford, Westmeath and Laois) for corresponding age groups and calendar years 1999–2013 were obtained from the Central Statistics Office (CSO)5. Cause of death extracted from GP records were compared with that extracted from national death certificates.

Data from the whole sample (original cohort and systematic sample) was used to examine the reliability of mortality data from GP records (Figure 1). Data from the original cohort was used to determine standardised mortality ratios. Previous work using these data was undertaken as part of a doctoral thesis (Chapter 5)12. Specifically, a survival analysis was undertaken using the full of cohort of people with type 1 and type 2 diabetes.

51befc9d-e7ae-43e7-b802-a56b245fc3b9_figure1.gif

Figure 1. Sample used for main analysis and comparison of GP records vs. national certificates.

Analysis

Only people with type 2 diabetes were included the analysis. Current age rather than baseline age (age at cohort entry in 1999) was used for the assignment to 5-year age groups. Lexis expansion12, or ‘episode splitting’ was performed to split the data by calendar year periods, effectively into a series of ‘snapshots’ changing the dataset from one observation per individual to one observation for each time interval (i.e., calendar years) per individual. That is, in each calendar year, the participant contributed to one of the corresponding age groups. Sex-stratified standardised mortality ratios (SMRs) were used to compare mortality rates among people with diabetes, between 1999 and 2013 (when national data on deaths were available from the CSO), with the national population. SMRs were also calculated using the Midland counties as a comparator. All analysis was carried out in Stata v12 for windows (StataCorp, College Station, TX, USA).

Results

Comparison of GP records with national certificates

Among the full cohort sampled in 2016 (n = 1475) there were 226 decedents. National death certificates were located for 198 individuals. Table 2 shows cause of death recorded in national death certificates. In death certificates, diabetes was recorded as the underlying cause of death for 16% (n=31) of decedents. None of the certificates had diabetes recorded as the first cause. Less than half of decedents (n= 103, 46%) had diabetes (unspecified, type 1, type 2, or maturity onset diabetes of the young) recorded somewhere on their death certificate.

Table 2. Cause of death in the whole population (n = 226).

Deaths (n)198
Primary cause of death
CVD91 (45.9)
Respiratory disease (inc. pneumonia)45 (22.7)
Neoplasms36 (18.2)
Kidney disease (including renal failure)6 (3.0)
Underlying cause of death
None recorded65 (32.8)
Diabetes Mellitus31 (15.7)
Ischaemic Heart Disease22 (11.1)
Other forms of heart disease14 (7.1)
Neoplasms4 (5.9)
Diseases of respiratory system17 (8.6)

†Cardiovascular disease: ICD-10 codes 100-179

In GP records, cause of death was recorded for less than one-third of decedents (n = 60, 27%). These 60 records listed only one cause of death and none recorded diabetes as a cause of death.

Of the 55 GP records which could be compared to national certificates (5/60 did not have corresponding national certificates), 75% (n=41) had recorded a cause of death which was also present somewhere on the national certificate, either the direct cause of death present on the certificate (n=24, 59%), the only cause listed on the certificate (n=7, 17%) or an underlying cause on the certificate (n=10, 24%).

Mortality rates among original cohort

Among the original cohort of 328 people with type 2 diabetes enrolled at baseline (1999), 165 (50.3%) had died in the period from 1999 to 2016 (Table 3). Of those who died, date of death could be established for 150 (91%) and cause of death for 146 (88.5%) national death certificates. Of the 165 (50.3%) who died over the 16-year period, the crude mortality rate was 38.94 (95% Confidence Interval (CI): 33.14 - 45.74) deaths per 1000 person-years; 36.75 (29.07 – 46.45) among men and 41.13 (32.95 – 51.35) among women.

Table 3. Baseline characteristics and clinical profile of survivors and decedents (2016) overall and by sex*.

Overall (N = 328)Men (N = 163)Women (N = 165)
Survivors
N = 63
N (%)/mean (SD)
Decedents
N = 165
N (%)/mean (SD)
Survivors
N = 100
N (%)/mean (SD))
Decedents
N = 90
N (%)/mean (SD)
Survivors
N = 92
N (%)/mean (SD)
Decedents
N = 94
N (%)/mean (SD)
Age58.1 (10.9)70.9 (9.7)57.4 (10.2)69.1 (9.7)58.7 (11.7)72.7 (9.4)
Smoker30 (25.4)26 (23.8)15 (25.4)12 (22.1)15 (25.4)14 (25.5)
BMI (kg/m2)30.3 (5.0)28.2 (4.0)29.5 (5.2)28.1 (3.3)31.0 (4.8)28.2 (4.6)
Treatment
Diet28 (17.5)29 (17.7)11 (13.8)18 (22.2)17 (21.3)11 (13.3)
Diet and tablets125 (78.1)132 (80.4)66 (82.5)61 (75.3)59 (73.8)71 (85.5)
Diet and insulin7 (4.3)3 (1.8)3 (3.82 (2.3)4 (5.0)1 (1.2)
Complications
Macrovascular complication (last 12
months)
6 (3.7)18 (10.9)4 (4.9)12 (14.8)2 (2.5)6 (7.1)
Attending renal clinic0 (0)2 (1.2)0 (0.0)2 (2.5)0 (0)0 (0)
Retinopathy8 (10.1)14 (17.3)5 (13.5)5 (14.7)3 (7.1)9 (19.2)
Foot ulcer1 (1.0)4 (3.7)1 (1.9)2 (3.8)0 (0)2 (3.6)
Amputations (minor)0 (0)1 (0.6)0 (0.0)0 (0)0 (0)1 (1.2)
Clinical
HbA1c (mmol/mol [%]) 7.3 (0.9)
[56 (10.2)]
7.0 (1.4)]
[53 (15.6)]
7.5 (2.1)
[58 (22.8)]
7.1 (1.6)
[54 (17.0)]
7.1 (1.6)
[54 (17.3)]
7.1 (1.3)
[54 (14.1)]
Systolic BP (mmHg)143.2 (20.3)145.5 (19.7)142.4 (18.8)142.3 (16.4)144.2 (21.8)148.5 (21.9)
Diastolic BP (mmHg)83.5 (11.6)82.7 (10.2)83.8 (9.6)82.5 (10.0)83.2 (13.6)82.9 (10.5)
Cholesterol (mmol/l)5.4 (1.2)5.2 (1.2)5.1 (1.1)4.9 (1.1)5.6 (1.1)5.6 (1.2)
Triglycerides (mmol/l), median (IQR)2.5 (1.6)2.3 (1.3)2.5 (1.6)2.3 (1.3)2.5 (1.6)2.3 (1.3)
eGFR (mL/min/1·73 m²), median (IQR)82.3 (15.0)68.3 (21.3)83.5 (14.1)73.0 (20.5)81.2 (15.9)63.6 (21.1)

*Based on available data

†significant difference between survivors and decedents (overall) p < 0.01

Rates in the Midland counties (12.00 (11.85 - 12.14) deaths per 1000 person-years) were similar to the national population (11.80 (11.76 - 11.83)). SMRs, which allowed for differences in the age structure of the populations, indicated that mortality among people with type 2 diabetes was greater than in the general population (Overall SMR = 1.17 (95% CI: 1.00-1.38)), significant among women (1.30 (1.04-1.63)) but not men (1.05 (0.82-1.34)).

Discussion

Summary

This study examined whether the ‘untapped resource’ of routinely collected general practice data from a structured diabetes programme could be used to determine excess mortality among people with type 2 diabetes. GP records currently do not appear to be a reliable source of death data. Cause of death was recorded in less than one-third of records. Linking clinical data from a fixed cohort in general practice to national records to establish excess mortality was feasible, albeit labour-intensive. Only half of national death certificates recorded diabetes as a cause.

Though mortality was greater than the national population, the excess mortality was considerably lower than a number of recent international studies reporting excess mortality among people with type 2 diabetes two to threefold that observed in the national population6,1317. One reason for the low excess mortality may be the fact that cardiovascular risk factors were well-managed as part of this programme9,18,19

Strengths and limitations

A strength of the study is the long duration of follow up of ‘fixed’ cohort, with date of death (91%) and cause of death (89%), established for most of the 165 who died over the 16-year period. However, our data is limited to a single region within Ireland and to general practices participating in a structured care initiative. As such it may not be generalisable to other regions or practices. Though we have set our estimates of excess mortality in the international context, caution should be taken when comparing excess mortality between countries. Differences may reflect the age structures of the study populations and differences in background mortality rates. The age structure of people with diabetes can be different between countries. Limited sample size, few individuals in younger age groups, require larger sample for greater precision estimates. A final limitation is that we cannot account for errors in the recording of individual death certificates.

Comparison with existing literature

Previous studies have shown that practices are not routinely informed following a patient’s death20,21, and highlight the challenges GPs experience when trying to obtain information on their patients who die22. Importantly our findings suggest this is an issue even within a structured care programme dedicated to monitoring quality of care and outcomes, and which has demonstrated improvements in recording of important clinical indicators over time9. We identified discrepancies between GP records and certificates with respect to the cause recorded, in line with previous studies using primary care databases. For example, a study utilising The Health Improvement Network (THIN) found that while death and dates were reliably recorded (correct in 99% of cases), cause of death recording was unreliable23.

Implications for research and practice

Date and cause of death were available from national records for most people enrolled in the programme. We illustrated that linking clinical data from a fixed cohort in general practice to national records to establish excess mortality is feasible in Ireland, albeit labour-intensive. A data linkage exercise involving death registrations and longitudinal survey data, also highlighted the requirement for largely manual matching and ICD-10 coding24. In contrast, countries like the UK and Sweden the existence of more robust infrastructure and national identifiers has facilitated electronic linkage of general practice data (e.g., UK Clinical Practice Research Datalink) with mortality data (e.g. Hospital Episode Statistics)25,26. However, electronic linkage still demands time and resources, and does not circumvent an number of continuing challenges, including limitations in the completeness of general practice data, discrepancies between general practice and secondary care data sources, and reduced sample sizes and follow-up25. Since these data were collected, the General Data Protection Regulations (GDPR) have been introduced. While these new regulations present additional challenges in terms of accessing routinely collected data from GP records for research purposes, they do not apply to data concerning deceased persons27,28.

Only half of national death certificates recorded diabetes as a cause (antecedent, underlying), similar to previous studies of death certification among people with diabetes29, including an Irish study highlighting issues with reporting of co-morbidities30. The latter may prove challenging for certifying physicians given that people with diabetes often have several coexisting micro- or macrovascular conditions31. These issues further reinforce how relying solely on national certificates, may underestimate the impact of diabetes. Where the certificates are completed in hospital, the certifying physician may not have been aware that the patient had diabetes. Existing research indicates recording of diabetes may be more likely where the certifying physician is the primary care physician32. GPs have ongoing contact with their patients, knowledge, and potentially more complete records of patient comorbidities and underlying conditions25. Within general practice, death registers have been used to drive research and QI and to understand the healthcare needs of the practice population20,33,34. However, improving the quality of mortality data in general practice would require changes to how practices are notified about deaths to make this process more systematic. Previous studies have suggested the need for national statistics centres to provide death certification information to practices, facilitated via a GP identifier on the certificate35. Providing incentives or creating specific functionality within the EHR (i.e. dedicated data entry for ICD-10 codes) may also be required to support death recording. Further work is needed to ascertain the reasons for the discrepancies between the cause of death recorded in GP and national certificates.

Other countries, for example, Scotland, have successfully linked diabetes registers to death records36. This approach may also be viable in Ireland given work is underway to establish a national diabetes register37,38 and there have been recent efforts to make data more accessible for health research; in 2024, the Central Statistics Office (CSO) in Ireland launched the Health Research Data Centre (RDC), providing a safe space through which researchers can access the data collected by the CSO. This includes mortality data linked by ethnicity, age, gender and cause of death. A diabetes register is further justification for supporting improvements in the quality and usability of general practice data as some register data could be derived from general practice39. However, potential sources of bias would be important to consider here, specifically; the quality of the data extraction tool, use of free text (the quality of which depends on resources or guidance on EHR software), the availability of coding systems in primary care software, frequency of measurements as stipulated in clinical guidelines, the presence of incentives for recording, including awareness of the possibility of future sharing2.

Overall, our study reinforces the potential need for a national infrastructure to facilitate linkage between data sources, including national death records and general practice data. Currently there is limited capacity to fully examine the relationship between quality of diabetes management and outcomes.

Ethical approval

Ethical approval for this study was granted by the Clinical Research Ethics Committee of the Cork University Teaching Hospitals. Reference: ECM 4 (g) 11/08/15.

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 04 Aug 2025
Comment
Author details Author details
Competing interests
Grant information
Copyright
Download
 
Export To
metrics
VIEWS
249
 
downloads
13
Citations
CITE
how to cite this article
Riordan F, McHugh S, O'Neill K et al. Examining the feasibility of using general practice records to determine excess mortality among people with diabetes [version 1; peer review: awaiting peer review]. HRB Open Res 2025, 8:86 (https://doi.org/10.12688/hrbopenres.14176.1)
NOTE: If applicable, it is important to ensure the information in square brackets after the title is included in all citations of this article.
track
receive updates on this article
Track an article to receive email alerts on any updates to this article.

Open Peer Review

Current Reviewer Status:
AWAITING PEER REVIEW
AWAITING PEER REVIEW
?
Key to Reviewer Statuses VIEW
ApprovedThe paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approvedFundamental flaws in the paper seriously undermine the findings and conclusions

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 04 Aug 2025
Comment
Alongside their report, reviewers assign a status to the article:
Approved - the paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations - A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approved - fundamental flaws in the paper seriously undermine the findings and conclusions

Are you a HRB-funded researcher?

Submission to HRB Open Research is open to all HRB grantholders or people working on a HRB-funded/co-funded grant on or since 1 January 2017. Sign up for information about developments, publishing and publications from HRB Open Research.

You must provide your first name
You must provide your last name
You must provide a valid email address
You must provide an institution.

Thank you!

We'll keep you updated on any major new updates to HRB Open Research

Sign In
If you've forgotten your password, please enter your email address below and we'll send you instructions on how to reset your password.

The email address should be the one you originally registered with F1000.

Email address not valid, please try again

You registered with F1000 via Google, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Google account password, please click here.

You registered with F1000 via Facebook, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Facebook account password, please click here.

Code not correct, please try again
Email us for further assistance.
Server error, please try again.