Skip to main content

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