{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,9,11]],"date-time":"2026-09-11T13:36:37Z","timestamp":1789133797109,"version":"build-2803163510"},"reference-count":50,"publisher":"JMIR Publications Inc.","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["J Med Internet Res"],"abstract":"<jats:sec>\n                    <jats:title>Background<\/jats:title>\n                    <jats:p>General 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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Objective<\/jats:title>\n                    <jats:p>This 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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Methods<\/jats:title>\n                    <jats:p>A 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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Results<\/jats:title>\n                    <jats:p>There were minimal incomplete and implausible data fields for age and sex (&lt;1%), geographic location (&lt;5%), and commonly cooccurring comorbidities (&lt;10%) in both datasets. However, weight, height, BMI, and Canadian Index of Multiple Deprivation contained &gt;50% missing data. The recording of osteoarthritis by age and sex in both datasets were similar to national estimates, except for patients aged &gt;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).<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Conclusions<\/jats:title>\n                    <jats:p>Age, 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.<\/jats:p>\n                  <\/jats:sec>","DOI":"10.2196\/69631","type":"journal-article","created":{"date-parts":[[2025,4,12]],"date-time":"2025-04-12T05:15:08Z","timestamp":1744434908000},"page":"e69631","source":"Crossref","is-referenced-by-count":2,"title":["Comparing the Quality of Primary Care Electronic Health Record Data in Australia and Canada: Case Study in Osteoarthritis"],"prefix":"10.2196","volume":"27","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-9450-1302","authenticated-orcid":false,"given":"Sharmala","family":"Thuraisingam","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1139-284X","authenticated-orcid":false,"given":"D Himasara","family":"Marasinghe","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0008-6295-6071","authenticated-orcid":false,"given":"Kendra","family":"Barrick","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2229-2054","authenticated-orcid":false,"given":"Fariba","family":"Aghajafari","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2153-3482","authenticated-orcid":false,"given":"Jo-Anne","family":"Manski-Nankervis","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-9708-5308","authenticated-orcid":false,"given":"Michelle M","family":"Dowsey","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-7848-7256","authenticated-orcid":false,"given":"Hude","family":"Quan","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5029-2345","authenticated-orcid":false,"given":"Tyler","family":"Williamson","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8795-9553","authenticated-orcid":false,"given":"Stephanie","family":"Garies","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1010","published-online":{"date-parts":[[2025,7,3]]},"reference":[{"key":"ref1","doi-asserted-by":"publisher","DOI":"10.13063\/2327-9214.1035"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1503\/cmaj.140473"},{"key":"ref3","unstructured":"Frequent GP attenders and their use of health services in 2012\u201313Australian Institute of Health and Welfare20152024-05-29https:\/\/www.aihw.gov.au\/reports\/primary-health-care\/frequent-gp-attenders-use-health-services-2012-13\/contents\/summary"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.14236\/jhi.v14i3.632"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1093\/fampra\/cmi106"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.2196\/jmir.9134"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2014.07.016"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1002\/14651858.CD008451.pub2"},{"key":"ref9","doi-asserted-by":"publisher","DOI":"10.1056\/NEJMp1006114"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.3390\/ijerph191912525"},{"key":"ref11","unstructured":"Review of the quality and outcomes framework in EnglandPolicy Research Unit in the Commissioning and Healthcare System2024-05-29https:\/\/pru.hssc.ac.uk\/assets\/uploads\/files\/review-of-qof-21st-december-2016.pdf"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.2217\/cer-2015-0022"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1186\/s12911-019-0740-0"},{"key":"ref14","doi-asserted-by":"publisher","DOI":"10.1136\/amiajnl-2011-000681"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.13063\/2327-9214.1244"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1016\/j.pcd.2016.02.002"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1186\/s12911-021-01669-6"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.1016\/j.jbi.2023.104509"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1007\/s10916-022-01892-2"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.1093\/jamia\/ocad120"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1016\/j.ocarto.2022.100281"},{"key":"ref22","unstructured":"Osteoarthritis in CanadaGovernment of Canada2024-05-29https:\/\/www.canada.ca\/en\/public-health\/services\/publications\/diseases-conditions\/osteoarthritis.html"},{"key":"ref23","unstructured":"Chronic musculoskeletal conditions: osteoarthritisAustralian Institute of Health and Welfare2024-05-29https:\/\/www.aihw.gov.au\/reports\/chronic-musculoskeletal-conditions\/osteoarthritis"},{"key":"ref24","unstructured":"Global health estimates: leading causes of DALYsWorld Health Organisation2024-05-29https:\/\/www.who.int\/data\/gho\/data\/themes\/mortality-and-global-health-estimates\/global-health-estimates-leading-causes-of-dalys"},{"key":"ref25","unstructured":"About usNPS MedicineWise2024-05-29https:\/\/www.nps.org.au\/about-us"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.1093\/ije\/dyz147"},{"key":"ref27","unstructured":"MedicineInsight data bookMedicineWise20182024-05-29https:\/\/www.nps.org.au\/assets\/NPS\/pdf\/MedicineInsight-databook-2020.pdf"},{"key":"ref28","unstructured":"Best practice software?: an evolution in practice managementBest Practice Software Pty2024-05-29https:\/\/bpsoftware.net\/"},{"key":"ref29","unstructured":"Software solutions for medical practitionersMedicalDirector: Health Communication Network2024-05-29https:\/\/www.medicaldirector.com\/"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.23889\/ijpds.v7i1.1713"},{"key":"ref31","unstructured":"CPCSSN\u2019s mission is to improve primary healthcare delivery outcomes across the country, while also facilitating innovation and excellence in primary healthcare researchCanadian Primary Care Sentinel Surveillance Network (CPCSSN)2024-05-29http:\/\/cpcssn.ca\/"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1093\/ije\/dyw248"},{"key":"ref33","unstructured":"International statistical classification of diseases and related health problems (ICD)World Health Organization20182018-06-07http:\/\/www.who.int\/classifications\/icd\/en\/"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1370\/afm.1644"},{"key":"ref35","doi-asserted-by":"publisher","DOI":"10.1007\/s10916-017-0694-7"},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.1097\/01.mlr.0000182534.19832.83"},{"key":"ref37","unstructured":"Australian statistical geography standard (ASGS)Australian Bureau of Statistics2024-05-29https:\/\/www.abs.gov.au\/websitedbs\/D3310114.nsf\/home\/Australian+Statistical+Geography+Standard+(ASGS)"},{"key":"ref38","doi-asserted-by":"publisher","DOI":"10.1016\/0021-9681(87)90171-8"},{"key":"ref39","unstructured":"How postal codes map to geographic areas: discussionStatistics Canada2024-05-29https:\/\/www150.statcan.gc.ca\/n1\/en\/pub\/92f0138m\/92f0138m2007001-eng.pdf?st=tMxUmokM"},{"key":"ref40","unstructured":"Postal Code OM conversion file plus (PCCF+)Statistics Canada2024-05-29https:\/\/www150.statcan.gc.ca\/n1\/en\/catalogue\/82F0086X"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1016\/j.ocarto.2020.100126"},{"key":"ref42","unstructured":"Canadian Chronic Disease Surveillance System (CCDSS)Government of Canada2024-05-29https:\/\/health-infobase.canada.ca\/ccdss\/data-tool\/"},{"key":"ref43","unstructured":"Data tables, 2021 census of populationStatistics Canada2024-05-29https:\/\/www12.statcan.gc.ca\/census-recensement\/2021\/dp-pd\/dt-td\/index-eng.cfm"},{"key":"ref44","unstructured":"National health survey: first resultsAustralian Bureau of Statistics2024-05-29https:\/\/www.abs.gov.au\/statistics\/health\/health-conditions-and-risks\/national-health-survey\/2017-18"},{"key":"ref45","doi-asserted-by":"publisher","DOI":"10.1111\/j.1467-842x.2005.tb00252.x"},{"key":"ref46","unstructured":"Hip and knee replacements in Canada: CJRR annual statistics summary, 2019-2020Canadian Institute for Health Information2024-05-29https:\/\/www.cihi.ca\/en\/hip-and-knee-replacements-in-canada-cjrr-annual-statistics-summary-2019-2020"},{"key":"ref47","doi-asserted-by":"publisher","DOI":"10.1080\/13645579.2015.1126486"},{"key":"ref48","doi-asserted-by":"publisher","DOI":"10.1136\/bmj.b2393"},{"key":"ref49","unstructured":"Guidelines for preventive activities in general practice. 9th editionRoyal Australian College of General Practitioners2024-05-29https:\/\/www.racgp.org.au\/clinical-resources\/clinical-guidelines\/key-racgp-guidelines\/view-all-racgp-guidelines\/preventive-activities-in-general-practice\/about-the-red-book"},{"key":"ref50","doi-asserted-by":"publisher","DOI":"10.23889\/ijpds.v4i2.1132"}],"container-title":["Journal of Medical Internet Research"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.jmir.org\/2025\/1\/e69631","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,6,30]],"date-time":"2026-06-30T17:57:38Z","timestamp":1782842258000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.jmir.org\/2025\/1\/e69631"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,7,3]]},"references-count":50,"URL":"https:\/\/doi.org\/10.2196\/69631","relation":{"has-preprint":[{"id-type":"doi","id":"10.2196\/preprints.69631","asserted-by":"object"}]},"ISSN":["1438-8871"],"issn-type":[{"value":"1438-8871","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,7,3]]}}}