Skip to main content

Advertisement

Table 3 Comparability Measures

From: A basic model for assessing primary health care electronic medical record data quality

  Results  
Measure   Dataset A Dataset B Dataset C  
Comparison of Database Population with Standard Population Chi Square by patient age and sex to the 2006 Canadian Censusa p = < 0.001 p = < 0.001 p = < 0.001  
  Canadian Census Mean (median) age
Mean (median) age 39.4 (41.0) 48.7 (53.0) 38.4 (38.0) (39.5)b
  Prevalence, Crude % (Age Standardized %; 95% confidence intervalc) Published Prevalence %
Concordance of TestConditions Diabetes 13.8 (11.3; 11.0–11.7) 12.4 (9.0; 7.9–10.1) d 6.8e
Hypertension 42.0 (35.5; 35.0–36.0) 23.9 (14.9; 13.5–16.3) 29.8 (20.8; 20.1–21.5) 19.1f
Hypothyroidism 7.5 (6.5; 6.2–6.8) 7.3 (5.9; 5.0–6.8) 5.5 (4.1; 3.8–4.4) 7.1g
Asthmah 5.6 * 5.0 21.1i
Obesity 35.2 (36.2; 35.7–36.7) 20.9 (18.7; 17.2–20.2) 24.2 (23.5; 22.8–24.2) 24.1j
Urinary Tract Infection 6.9 (6.6; 6.3–6.9) * 0.9 (0.8; 0.7–1.0) k
  1. *cell sizes less than 5 are suppressed
  2. aThe 2006 Canadian Census was selected because age was measured at the start of each dataset. Two of the three datasets began in 2006
  3. bMean age for Canadian Census is not reported
  4. cThe 1991 Canadian Census of Population is used as the standard population by Statistics Canada
  5. dDiabetes was not measured in Dataset C
  6. eSource: Public Health Agency of Canada. 2011. Diabetes in Canada: Facts and Figures from a public health perspective. (https://www.canada.ca/en/public-health/services/chronic-diseases/reports-publications/diabetes/diabetes-canada-facts-figures-a-public-health-perspective.html)
  7. fPublic Health Agency of Canada Report. 2010. Report from the Canadian Chronic Disease Surveillance System: Hypertension in Canada, 2010. (https://www.canada.ca/en/public-health/services/chronic-diseases/cardiovascular-disease/report-canadian-chronic-disease-surveillance-system-hypertension-canada-2010.html)
  8. gGagnon F, Langlois MF, Michaud I, Gingras S, Duchesen JF, Levesque B. 2006. Spatio-temporal distribution of hypothyroidism in Quebec. Chronic Diseases in Canada; 27 [1]
  9. hAsthma prevalence was not age standardized because the definition was limited to patients less than 18 years old
  10. iGershon A.S., Guan J, Wang C, To T. 2010. Trends in Asthma Prevalence and Incidence in Ontario, 1996–2005: A Population Study. Am J Epidemiol 172;728–736
  11. jStatistics Canada. 2011. Adult obesity prevalence in Canada and the United States. (http://www.statcan.gc.ca/pub/82-625-x/2011001/article/11411-eng.htm)
  12. kUrinary Tract Infections are an acute condition, and do not have a population prevalence for comparison