Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis

BackgroundGeneral practice electronic health records (EHRs) contain a wealth of patient information. However, these data are collected for clinical purposes. Hence, questions remain around the suitability of using these data for other purposes, including epidemiological resea...

Full description

Saved in:
Bibliographic Details
Main Authors: Sharmala Thuraisingam, D Himasara Marasinghe, Kendra Barrick, Fariba Aghajafari, Jo-Anne Manski-Nankervis, Michelle M Dowsey, Hude Quan, Tyler Williamson, Stephanie Garies
Format: Article
Language:English
Published: JMIR Publications 2025-07-01
Series:Journal of Medical Internet Research
Online Access:https://www.jmir.org/2025/1/e69631
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1849427713018822656
author Sharmala Thuraisingam
D Himasara Marasinghe
Kendra Barrick
Fariba Aghajafari
Jo-Anne Manski-Nankervis
Michelle M Dowsey
Hude Quan
Tyler Williamson
Stephanie Garies
author_facet Sharmala Thuraisingam
D Himasara Marasinghe
Kendra Barrick
Fariba Aghajafari
Jo-Anne Manski-Nankervis
Michelle M Dowsey
Hude Quan
Tyler Williamson
Stephanie Garies
author_sort Sharmala Thuraisingam
collection DOAJ
description BackgroundGeneral practice electronic health records (EHRs) contain a wealth of patient information. However, these data are collected for clinical purposes. Hence, questions remain around the suitability of using these data for other purposes, including epidemiological research, developing and validating clinical prediction models, conducting audits, and informing policy. ObjectiveThis study aimed to compare the quality of osteoarthritis-related data in Australian and Canadian general practice EHRs for externally validating a clinical prediction model for total knee replacement surgery. MethodsA data quality assessment was conducted on 201,462 patient general practice EHRs from Australia provided by National Prescribing Service MedicineWise, and 92,425 from Canada provided by the Canadian Primary Care Sentinel Surveillance Network. Completeness, plausibility, and external validity of data elements relevant to osteoarthritis were assessed. Completeness and plausibility were evaluated using counts and proportions. For external validity, prevalence was estimated using proportions, and knee replacement summarized as a rate per 100,000 population. ResultsThere were minimal incomplete and implausible data fields for age and sex (<1%), geographic location (<5%), and commonly cooccurring comorbidities (<10%) in both datasets. However, weight, height, BMI, and Canadian Index of Multiple Deprivation contained >50% missing data. The recording of osteoarthritis by age and sex in both datasets were similar to national estimates, except for patients aged >80 years (Australia: 16.6%, 95% CI 16%-17.3% vs 13.1%, 95% CI 11.2%-15.4%; Canada: 36.7%, 95% CI 36.1%-37.2% vs 50.8%, 95% CI 50.7%-50.9%). Total knee replacement rates were substantially lower in both EHR datasets compared with national estimates (Australia: 72 vs 218 per 100,000; Canada: 0.84 vs 200 per 100,000). ConclusionsAge, sex, geographic location, commonly cooccurring comorbidities, and prescribing of osteoarthritis medications in Australian and Canadian general practice EHRs are suitable for use in clinical prediction model validation studies. However, BMI and the Canadian Index of Multiple Deprivation are unfit for such use due to large proportions of missing data. Rates of total knee replacement surgery were substantially underreported and should not be used for prediction model validation. Better harmonization of patient data across primary and tertiary care is required to improve the suitability of these data. In the meantime, data linkage with national registries and other health datasets may overcome some of the data quality challenges in general practice EHRs.
format Article
id doaj-art-00c6aefa41974a6eb3fcf3fbd4551302
institution Kabale University
issn 1438-8871
language English
publishDate 2025-07-01
publisher JMIR Publications
record_format Article
series Journal of Medical Internet Research
spelling doaj-art-00c6aefa41974a6eb3fcf3fbd45513022025-08-20T03:28:56ZengJMIR PublicationsJournal of Medical Internet Research1438-88712025-07-0127e6963110.2196/69631Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in OsteoarthritisSharmala Thuraisingamhttps://orcid.org/0000-0002-9450-1302D Himasara Marasinghehttps://orcid.org/0000-0003-1139-284XKendra Barrickhttps://orcid.org/0009-0008-6295-6071Fariba Aghajafarihttps://orcid.org/0000-0002-2229-2054Jo-Anne Manski-Nankervishttps://orcid.org/0000-0003-2153-3482Michelle M Dowseyhttps://orcid.org/0000-0002-9708-5308Hude Quanhttps://orcid.org/0000-0002-7848-7256Tyler Williamsonhttps://orcid.org/0000-0001-5029-2345Stephanie Garieshttps://orcid.org/0000-0001-8795-9553 BackgroundGeneral practice electronic health records (EHRs) contain a wealth of patient information. However, these data are collected for clinical purposes. Hence, questions remain around the suitability of using these data for other purposes, including epidemiological research, developing and validating clinical prediction models, conducting audits, and informing policy. ObjectiveThis study aimed to compare the quality of osteoarthritis-related data in Australian and Canadian general practice EHRs for externally validating a clinical prediction model for total knee replacement surgery. MethodsA data quality assessment was conducted on 201,462 patient general practice EHRs from Australia provided by National Prescribing Service MedicineWise, and 92,425 from Canada provided by the Canadian Primary Care Sentinel Surveillance Network. Completeness, plausibility, and external validity of data elements relevant to osteoarthritis were assessed. Completeness and plausibility were evaluated using counts and proportions. For external validity, prevalence was estimated using proportions, and knee replacement summarized as a rate per 100,000 population. ResultsThere were minimal incomplete and implausible data fields for age and sex (<1%), geographic location (<5%), and commonly cooccurring comorbidities (<10%) in both datasets. However, weight, height, BMI, and Canadian Index of Multiple Deprivation contained >50% missing data. The recording of osteoarthritis by age and sex in both datasets were similar to national estimates, except for patients aged >80 years (Australia: 16.6%, 95% CI 16%-17.3% vs 13.1%, 95% CI 11.2%-15.4%; Canada: 36.7%, 95% CI 36.1%-37.2% vs 50.8%, 95% CI 50.7%-50.9%). Total knee replacement rates were substantially lower in both EHR datasets compared with national estimates (Australia: 72 vs 218 per 100,000; Canada: 0.84 vs 200 per 100,000). ConclusionsAge, sex, geographic location, commonly cooccurring comorbidities, and prescribing of osteoarthritis medications in Australian and Canadian general practice EHRs are suitable for use in clinical prediction model validation studies. However, BMI and the Canadian Index of Multiple Deprivation are unfit for such use due to large proportions of missing data. Rates of total knee replacement surgery were substantially underreported and should not be used for prediction model validation. Better harmonization of patient data across primary and tertiary care is required to improve the suitability of these data. In the meantime, data linkage with national registries and other health datasets may overcome some of the data quality challenges in general practice EHRs.https://www.jmir.org/2025/1/e69631
spellingShingle Sharmala Thuraisingam
D Himasara Marasinghe
Kendra Barrick
Fariba Aghajafari
Jo-Anne Manski-Nankervis
Michelle M Dowsey
Hude Quan
Tyler Williamson
Stephanie Garies
Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
Journal of Medical Internet Research
title Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
title_full Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
title_fullStr Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
title_full_unstemmed Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
title_short Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis
title_sort comparing the quality of primary care electronic health record data in australia and canada case study in osteoarthritis
url https://www.jmir.org/2025/1/e69631
work_keys_str_mv AT sharmalathuraisingam comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT dhimasaramarasinghe comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT kendrabarrick comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT faribaaghajafari comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT joannemanskinankervis comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT michellemdowsey comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT hudequan comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT tylerwilliamson comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis
AT stephaniegaries comparingthequalityofprimarycareelectronichealthrecorddatainaustraliaandcanadacasestudyinosteoarthritis