Healthcare Quarterly

Healthcare Quarterly 14(3) July 2011 : 23-27.doi:10.12927/hcq.2011.22486
ICES Report

Using Linked Health Administrative Data to Assess the Clinical and Healthcare System Impact of Chronic Diseases in Ontario

Karey Iron, Hong Lu, Doug Manuel, David Henry and Andrea Gershon

The rising incidence and prevalence of chronic diseases is of major global concern (World Health Organization [WHO] 2002). Worldwide, the proportion of overall burden of disease from all causes attributable to non-communicable diseases (NCDs) and mental disorders is expected to increase from 36% in 1990 to 57% in 2020 (WHO 2002). The burden from NCDs, or chronic disease, exceeds that of communicable diseases in all of the six WHO regions except Africa (WHO 2003). This increasing trend has been credited to longer life expectancy due to advances in medical treatment, public health initiatives, social development, demographic shifts and changes in lifestyle and working environments. Thus, chronic disease is a significant burden to patients, families, healthcare providers and healthcare systems.

From clinical and healthcare system management perspectives, there is a growing recognition that many chronic diseases have similar risk factors and can be managed with similar medical and psychosocial strategies. The Ontario Chronic Disease Prevention and Management Framework (Ontario Ministry of Health and Long-Term Care 2007) calls for the integration of health system organizations, healthcare providers, community partners and family supports to improve patient outcomes and system impacts. This initiative is consistent with a WHO report suggesting that a paradigm shift is required so that "decision-makers can take actions that will reduce the threats chronic conditions pose to the health of their citizens, their healthcare systems, and their economies. Their actions regarding financing, resource allocation, and healthcare planning can significantly diminish negative effects. Armed with essential elements for improvement, informed decision-makers can make a difference" (WHO 2002: 4).

Because the Canadian healthcare system is managed publicly, Ontario's call to action can be planned, in part, by using comprehensive, population-based health administrative data collected at the point of care. With scientific input, these data can be linked and used to inform decision-makers and healthcare providers about the needs of people with chronic diseases and the extent and appropriateness of the healthcare system's response to these needs. In order to create such an effective information management system, however, we need to understand the extent to which routinely collected health administrative data accurately depict individuals with one or more chronic diseases.

Identification and Evaluation of Chronic Disease Cohorts Using Linked Administrative Data

The clinical and healthcare system impacts of a range of chronic diseases are being evaluated at the Institute for Clinical Evaluative Sciences (ICES) using its large repository of annually updated, de-identified, individual-level health administrative data. Disease-based cohorts are created using health administrative case definitions that link hospital in-patient and outpatient care, physician claims and drug benefits data over time using an anonymous, unique identifier. The benefits of using these linked data cohorts for health system planning and evaluation are many: they are population based, are comprehensive (they do not rely on a single database), capture real health system use, are longitudinal and are relatively inexpensive to construct and use. In addition, individual health administrative records can also be linked to other data (clinical registry, public health, socioeconomic etc.) to inform a large number of health system initiatives.

The validity of this approach is critically dependent on the accuracy of disease coding in the administrative records. Accordingly, scientists with clinical expertise at ICES have validated the relevant administrative data case definitions using data collected directly from reviews of medical charts in the community. For example, the positive predictive values (the likelihood that the case definition accurately reflects a true case) of the diabetes and hypertension case definitions are 80% (Hux et al. 2002) and 87% (Tu et al. 2007), respectively.

To date, these validated case definitions have been applied to the following disease cohorts: asthma (Gershon et al. 2009b), congestive heart failure (Schultz and Tu 2010), chronic obstructive pulmonary disease (COPD)(Gershon et al. 2009a), acute myocardial infarction (Austin et al. 2002), diabetes (Hux et al. 2002) and hypertension (Tu et al. 2007). Thus, validated annual cohorts are created at ICES that can be linked anonymously to additional information (e.g., death registry, cancer registry, immigrant status) in order to examine the outcomes of care in the entire cohort and, potentially, in subpopulations of interest.

The Effect of Having Multiple Chronic Diseases

Some chronic diseases share common etiologies (obesity, smoking, genetics); therefore, it is predictable that patients who have certain risk factors will suffer from more than one disease. These patients can be very sick and difficult to manage, and pose challenges to the health system. Most clinical evidence specifically addresses the management of a single disease, making its applicability to patients with two or more diseases unclear. More information about the patterns of multiple diseases and the effect of common treatments on their varied outcomes would help to inform strategies to provide more efficient, coordinated and cost-effective care, for instance, through the use of specialized multidisciplinary outreach programs that improve quality of life and reduce hospitalizations.

At ICES, we have anonymously cross-linked the validated chronic disease cohorts at the level of individual patients to examine the frequency of different multiple disease permutations and their clinical and health system impacts. To provide a more comprehensive picture, these multiple disease cohorts have been linked to primary care and specialist services, emergency department and hospital in-patient care and prescription drug use data.

What We Did and What We Found

We aggregated the data by year to illustrate the age- and sex-adjusted prevalence of people diagnosed with one, two or three or more of the conditions (Figure 1). A rising prevalence over time was found. The largest absolute increase was in the number of individuals identified as having one chronic disease. Proportionally greater increases were seen in the numbers of individuals with two and three or more of these diseases who, together, amounted to almost half the number of individuals with a single disease.

Click to Enlarge

For illustrative purposes, we focused on one year (2006–2007) and found that 3.7 million Ontarians aged 20 years and older had at least one of the defined conditions. Sixty-five percent of these people had one condition, 24% had two and 11% had three or more. In general, persons with one condition were younger than those who had more than one, with no gender differences. People with one condition were equally distributed across socio-economic strata (as determined by neighbourhood income quintiles from Canadian census data), but people with two or three or more conditions were more likely than those in the general population to live in lower-income neighbourhoods. Geographical variations across local health integration networks were noted but not analyzed in sufficient detail to draw actionable conclusions.

We then calculated the crude annual number of health service encounters over the subsequent two years for the cohorts and for the general population. Health system use across all sectors rose with increasing numbers of chronic conditions (Table 1). Some of the differences were quite marked. Although this analysis was preliminary and did not include the full measure of the resources that would have been provided to these patients in the course of their usual care, the data illustrate the potential value of this type of analysis.

Table 1. Annual average health services used by Ontarians (≥20 y) who were identified in 2006–2007 with one, two or three or more chronic conditions*
Types of Health Services Crude Annual Average Number of Health Services Used, 2007–2008 and 2008–2009
One Chronic Condition Two Chronic Conditions Three Chronic Conditions General Population
Primary care visits 4.94 6.61 7.71 3.36
Specialist visits 2.19 3.13 3.85 1.15
In-patient hospital stays 0.09 0.16 0.32 0.07
Emergency department visits 0.44 0.59 0.93 0.32
Prescriptions for distinct drugs used by people 65+ y 5.38 7.28 9.06 5.39
*Asthma, congestive heart failure, chronic obstructive pulmonary disease, acute myocardial infarction, type 2 diabetes and hypertension.
The entire population aged 20–105 years, including people with identified chronic conditions.


Clinical and Healthcare System Impacts of Specific Combinations of Chronic Conditions

Of the 3.7 million people in our chronic disease cohort, 36% were diagnosed with hypertension, 17% with asthma, 7% with diabetes and 5% with COPD. In addition, 10% had diabetes and hypertension, 4% had hypertension and COPD, 4% had hypertension and asthma, 2% had asthma and COPD and 2% had hypertension and congestive heart failure. Finally, 2% had a combination of these three chronic conditions: hypertension, asthma and COPD, or hypertension, diabetes and COPD. The rest of the cohort had various other combinations of the conditions. Tables 2 and 3 list the chronic diseases that either singly or in combination had the biggest impact on primary care as denoted by the number of primary care visits patients made. A shaded box indicates the presence of that particular chronic condition. Tables 2 ranks the disease combinations by average number of primary care visits per patient over two years, which likely reflects disease severity or clinical intensity. This table represents only 8% of the cohort, yet these were persons who had many of these conditions concurrently and were thus more likely to see a primary care provider frequently. Table 3 ranks the disease combinations by total annual average primary care person-visits, which likely reflects the degree of healthcare system impact. This table represents 91% of people in the ICES cohort with one or more diseases that affect many people. While these people have less severe disease, as a group they impose a high health system impact. Both of these metrics have implications for system responsiveness and availability of services.

Click to Enlarge

Click to Enlarge

We similarly analyzed the clinical and healthcare system impacts of single and multiple chronic conditions on specialty care, emergency department visits, in-patient hospitalizations and number of prescription drugs. These data are available from the authors.

Next Steps

Our intention is to continue our evaluation of the care provided to patients with these multiple chronic diseases. The present work provides some important baseline data. With more focused analyses and a broader range of validated conditions and outcomes, we will be better able to understand clinical and healthcare system impacts and to develop quality-of-care measures for patients with key combinations of disease.

About the Author(s)

Karey Iron, MHSc, is the health information officer at the Institute for Clinical Evaluative Sciences (ICES), in Toronto, Ontario. She is a public health epidemiologist who has used population-based administrative data to write about health services use and health outcomes in various populations, determinants of health, diagnostic testing and administrative data quality. Karey may be contacted by telephone at 416-480-4055, ext. 3422, or by e-mail at

Hong Lu, PhD, is an analyst in the Programming and Biostatistics Unit at ICES.

Doug Manuel, MD, MSc, FRCPC, holds a Canadian Institutes of Health Research/Public Health Agency of Canada chair in applied and public health. He is a senior scientist at the Ottawa Hospital Research Institute and associate professor in the departments of Family Medicine and of Epidemiology and Community Medicine at the University of Ottawa, in Ottawa, Ontario.

David Henry, MBChB, MRCP, FRCP (Edin), is president and chief executive officer of ICES. He is also a senior scientist, clinical epidemiology, in the Holland Musculoskeletal Research Program at Sunnybrook Research Institute; a professor in the Department of Medicine at the University jof Toronto; and an adjunct professor in the School of Medicine and Public Health at the University of Newcastle in Australia. Dr. Henry is a physician and clinical pharmacologist and has an interest in all aspects of medicine use by communities.

Andrea Gershon, MD, MSc, FRCPC, is a scientist at ICES and the Sunnybrook Research Institute. She is also a respirologist at Sunnybrook Health Sciences Centre and an assistant professor in the Department of Medicine, Faculty of Medicine, University of Toronto, in Toronto, Ontario.


Austin, P.C., P.A. Daly and J.V. Tu. 2002. "A Multicenter Study of the Coding Accuracy of Hospital Discharge Administrative Data for Patients Admitted to Cardiac Care Units in Ontario." American Heart Journal 144(2): 290–96.

Gershon, A.S., C. Wang, J. Guan, J. Vasilevska-Ristovska, L. Cicutto and T. To. 2009a. "Identifying Individuals with Physician-Diagnosed COPD in Health Administrative Databases." COPD 6(5): 388–94.

Gershon, A.S., C. Wang, J. Guan, J. Vasilevska-Ristovska, L. Cicutto and T. To. 2009b. "Identifying Patients with Physician-Diagnosed Asthma in Health Administrative Databases." Canadian Respiratory Journal 16(6): 183–88.

Hux, J., F. Ivis, V. Flintoft and A. Bica. 2002. "Diabetes in Ontario: Determination of Prevalence and Incidence Using a Validated Administrative Data Algorithm." Diabetes Care 25(3): 512–16.

Ontario Ministry of Health and Long-Term Care. 2007. Preventing and Managing Chronic Disease: Ontario's Framework. Toronto, ON: Author. Accessed April 29, 2011. <>.

Schultz, S. and K. Tu. 2010. Validation Study Using Primary Care Patient Records versus Administrative Databases in Ontario: Congestive Heart Failure. Unpublished report.

Tu, K., N.R. Campbell, Z.L. Chen, K.J. Cauch-Dudek and F.A. McAlister. 2007. "Accuracy of Administrative Databases in Identifying Patients with Hypertension." Open Medicine 1(1): e18–26.

World Health Organization. 2002. Innovative Care for Chronic Conditions: Building Blocks for Action. Global Report. Geneva, Switzerland: Author. Retrieved April 29, 2011. <>.

World Health Organization. 2003. Diet, Nutrition and the Prevention of Chronic Diseases: Report of a Joint WHO/FAO Expert Consultation, 28 January–1 February 2002. Geneva, Switzerland: Author. Retrieved April 2011. <>.


Be the first to comment on this!

Related Articles

Note: Please enter a display name. Your email address will not be publically displayed