Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2016

Open Access 01-12-2016 | Research article

Utility of linking primary care electronic medical records with Canadian census data to study the determinants of chronic disease: an example based on socioeconomic status and obesity

Authors: Suzanne Biro, Tyler Williamson, Jannet Ann Leggett, David Barber, Rachael Morkem, Kieran Moore, Paul Belanger, Brian Mosley, Ian Janssen

Published in: BMC Medical Informatics and Decision Making | Issue 1/2016

Login to get access

Abstract

Background

Electronic medical records (EMRs) used in primary care contain a breadth of data that can be used in public health research. Patient data from EMRs could be linked with other data sources, such as a postal code linkage with Census data, to obtain additional information on environmental determinants of health. While promising, successful linkages between primary care EMRs with geographic measures is limited due to ethics review board concerns. This study tested the feasibility of extracting full postal code from primary care EMRs and linking this with area-level measures of the environment to demonstrate how such a linkage could be used to examine the determinants of disease. The association between obesity and area-level deprivation was used as an example to illustrate inequalities of obesity in adults.

Methods

The analysis included EMRs of 7153 patients aged 20 years and older who visited a single, primary care site in 2011. Extracted patient information included demographics (date of birth, sex, postal code) and weight status (height, weight). Information extraction and management procedures were designed to mitigate the risk of individual re-identification when extracting full postal code from source EMRs. Based on patients’ postal codes, area-based deprivation indexes were created using the smallest area unit used in Canadian censuses. Descriptive statistics and socioeconomic disparity summary measures of linked census and adult patients were calculated.

Results

The data extraction of full postal code met technological requirements for rendering health information extracted from local EMRs into anonymized data. The prevalence of obesity was 31.6 %. There was variation of obesity between deprivation quintiles; adults in the most deprived areas were 35 % more likely to be obese compared with adults in the least deprived areas (Chi-Square = 20.24(1), p < 0.0001). Maps depicting spatial representation of regional deprivation and obesity were created to highlight high risk areas.

Conclusions

An area based socio-economic measure was linked with EMR-derived objective measures of height and weight to show a positive association between area-level deprivation and obesity. The linked dataset demonstrates a promising model for assessing health disparities and ecological factors associated with the development of chronic diseases with far reaching implications for informing public health and primary health care interventions and services.
Literature
2.
go back to reference Birtwhistle R, Keshavjee K, Lambert-Lanning A, Godwin M, Greiver M, Manca D, Lagace C. Building a pan-Canadian primary care sentinel surveillance network: initial development and moving forward. J Am Board Fam Med. 2009;22:412–22.CrossRefPubMed Birtwhistle R, Keshavjee K, Lambert-Lanning A, Godwin M, Greiver M, Manca D, Lagace C. Building a pan-Canadian primary care sentinel surveillance network: initial development and moving forward. J Am Board Fam Med. 2009;22:412–22.CrossRefPubMed
3.
go back to reference Greiver M, Barnsley J, Glazier R, Harvey B, Moineddin R. Measuring data reliability for preventive services in electronic medical records. BMC Health Serv Res. 2012;12:116.CrossRefPubMedPubMedCentral Greiver M, Barnsley J, Glazier R, Harvey B, Moineddin R. Measuring data reliability for preventive services in electronic medical records. BMC Health Serv Res. 2012;12:116.CrossRefPubMedPubMedCentral
4.
go back to reference Birtwhistle R. Canadian primary care sentinel surveillance network: a developing resource for family medicine and public health. Can Fam Physician. 2011;57:1219–20.PubMedPubMedCentral Birtwhistle R. Canadian primary care sentinel surveillance network: a developing resource for family medicine and public health. Can Fam Physician. 2011;57:1219–20.PubMedPubMedCentral
5.
go back to reference Birtwhistle R, Williamson T. Primary care electronic medical records: a new data source for research in Canada. Can Med Assoc J. 2014;187:239–40.CrossRef Birtwhistle R, Williamson T. Primary care electronic medical records: a new data source for research in Canada. Can Med Assoc J. 2014;187:239–40.CrossRef
6.
go back to reference Klompas M, McVetta J, Lazarus R, Eggleston E, Haney G, Kruskal B, Yih W, Daly P, Oppedisano P, Beagan B, Lee M, Kirby C, Heisey-Grove D, DeMaria A, Platt R. Integrating clinical practice and public health surveillance using electronic medical record systems. Am J Public Health. 2012;102:S325–32.CrossRefPubMedPubMedCentral Klompas M, McVetta J, Lazarus R, Eggleston E, Haney G, Kruskal B, Yih W, Daly P, Oppedisano P, Beagan B, Lee M, Kirby C, Heisey-Grove D, DeMaria A, Platt R. Integrating clinical practice and public health surveillance using electronic medical record systems. Am J Public Health. 2012;102:S325–32.CrossRefPubMedPubMedCentral
7.
go back to reference Stewart M, Thind A, Terry A, Chevendra V, Marshall J. Implementing and maintaining a researchable database from electronic medical records: a perspective from an academic family medicine department. Healthc Policy. 2009;5:26–39.PubMedPubMedCentral Stewart M, Thind A, Terry A, Chevendra V, Marshall J. Implementing and maintaining a researchable database from electronic medical records: a perspective from an academic family medicine department. Healthc Policy. 2009;5:26–39.PubMedPubMedCentral
8.
go back to reference White E, Hunt J, Casso D. Exposure measurement in cohort studies: the challenges of prospective data collection. Epidemiol Rev. 1998;20:43–56.CrossRefPubMed White E, Hunt J, Casso D. Exposure measurement in cohort studies: the challenges of prospective data collection. Epidemiol Rev. 1998;20:43–56.CrossRefPubMed
9.
go back to reference Gavrielov-Yusim N, Friger M. Use of administrative medical databases in population-based research. J Epidemiol Commun Health. 2013;68:283–7.CrossRef Gavrielov-Yusim N, Friger M. Use of administrative medical databases in population-based research. J Epidemiol Commun Health. 2013;68:283–7.CrossRef
10.
go back to reference Harrington D, Elliott S. Weighing the importance of neighbourhood: a multilevel exploration of the determinants of overweight and obesity. Soc Sci Med. 2009;68:593–600.CrossRefPubMed Harrington D, Elliott S. Weighing the importance of neighbourhood: a multilevel exploration of the determinants of overweight and obesity. Soc Sci Med. 2009;68:593–600.CrossRefPubMed
11.
go back to reference Jutte D, Roos L, Brownell M. Administrative record linkage as a tool for public health research. Annu Rev Public Health. 2011;32:91–108.CrossRefPubMed Jutte D, Roos L, Brownell M. Administrative record linkage as a tool for public health research. Annu Rev Public Health. 2011;32:91–108.CrossRefPubMed
12.
go back to reference Ajetunmobi O, Whyte B, Chalmers J, Fleming M, Stockton D, Wood R. Informing the 'early years' agenda in Scotland: understanding infant feeding patterns using linked datasets. J Epidemiol Commun Health. 2013;68:83–92.CrossRef Ajetunmobi O, Whyte B, Chalmers J, Fleming M, Stockton D, Wood R. Informing the 'early years' agenda in Scotland: understanding infant feeding patterns using linked datasets. J Epidemiol Commun Health. 2013;68:83–92.CrossRef
13.
go back to reference Aliarzadeh B, Greiver M, Moineddin R, Meaney C, White D, Moazzam A, Moore K, Belanger P. Association between socio-economic status and hemoglobin A1c levels in a Canadian primary care adult population without diabetes. BMC Fam Pract. 2014;15:7.CrossRefPubMedPubMedCentral Aliarzadeh B, Greiver M, Moineddin R, Meaney C, White D, Moazzam A, Moore K, Belanger P. Association between socio-economic status and hemoglobin A1c levels in a Canadian primary care adult population without diabetes. BMC Fam Pract. 2014;15:7.CrossRefPubMedPubMedCentral
14.
go back to reference El Emam K, Buckeridge D, Tamblyn R, Neisa A, Jonker E, Verma A. The re-identification risk of Canadians from longitudinal demographics. BMC Med Inform Decis Mak. 2011;11:46.CrossRefPubMedPubMedCentral El Emam K, Buckeridge D, Tamblyn R, Neisa A, Jonker E, Verma A. The re-identification risk of Canadians from longitudinal demographics. BMC Med Inform Decis Mak. 2011;11:46.CrossRefPubMedPubMedCentral
15.
go back to reference El Emam K, Brown A, AbdelMalik P, Neisa A, Walker M, Bottomley J, Roffey T. A method for managing re-identification risk from small geographic areas in Canada. BMC Med Inform Decis Mak. 2010;10:18.CrossRefPubMedPubMedCentral El Emam K, Brown A, AbdelMalik P, Neisa A, Walker M, Bottomley J, Roffey T. A method for managing re-identification risk from small geographic areas in Canada. BMC Med Inform Decis Mak. 2010;10:18.CrossRefPubMedPubMedCentral
16.
go back to reference McGuire S, Shields M, Carroll MD, Ogden CL. Shields M., Carroll M.D., Ogden C.L. adult obesity prevalence in Canada and the United States. NCHS data brief no. 56, Hyattsville, MD: National Center for Health Statistics, 2011. Adv Nutr. 2011;2:368–9.CrossRefPubMedPubMedCentral McGuire S, Shields M, Carroll MD, Ogden CL. Shields M., Carroll M.D., Ogden C.L. adult obesity prevalence in Canada and the United States. NCHS data brief no. 56, Hyattsville, MD: National Center for Health Statistics, 2011. Adv Nutr. 2011;2:368–9.CrossRefPubMedPubMedCentral
17.
go back to reference Field A, Coakley E, Must A, Spadano J, Laird N, Dietz W, Rimm E, Colditz G. Impact of overweight on the risk of developing common chronic diseases during a 10-year period. Arch Intern Med. 2001;161:1581.CrossRefPubMed Field A, Coakley E, Must A, Spadano J, Laird N, Dietz W, Rimm E, Colditz G. Impact of overweight on the risk of developing common chronic diseases during a 10-year period. Arch Intern Med. 2001;161:1581.CrossRefPubMed
18.
19.
go back to reference Kendall P. Investing in prevention: improving health and creating sustainability. British Columbia; 2010. The Provincial Health Officer's Special Report. Kendall P. Investing in prevention: improving health and creating sustainability. British Columbia; 2010. The Provincial Health Officer's Special Report.
21.
go back to reference Lebel A, Pampalon R, Hamel D, Theriault M. The geography of overweight in Quebec: a multilevel perspective. Can J Public Health. 2009;100:18–23.PubMed Lebel A, Pampalon R, Hamel D, Theriault M. The geography of overweight in Quebec: a multilevel perspective. Can J Public Health. 2009;100:18–23.PubMed
22.
go back to reference Kotecha J, Manca D, Lambert-lanning A, Keshavjee K, Drummond N, Godwin M, Greiver M, Putnam W, Birtwhistle R. Ethics and privacy issues of a practice-based surveillance. Can Fam Phys. 2011;57:1165–73. Kotecha J, Manca D, Lambert-lanning A, Keshavjee K, Drummond N, Godwin M, Greiver M, Putnam W, Birtwhistle R. Ethics and privacy issues of a practice-based surveillance. Can Fam Phys. 2011;57:1165–73.
25.
go back to reference Leggett J, Greiver M, Manca D, Williamson T, Martin K, Queenan J. Facilitating Informatics for Research using Health Data Aggregated from Electronic Health Records across Multiple Jurisdictions through the Implementation of a Privacy by Design Privacy and Information Security Architecture. In International Symposium on Health Information Management Research; 2015. Leggett J, Greiver M, Manca D, Williamson T, Martin K, Queenan J. Facilitating Informatics for Research using Health Data Aggregated from Electronic Health Records across Multiple Jurisdictions through the Implementation of a Privacy by Design Privacy and Information Security Architecture. In International Symposium on Health Information Management Research; 2015.
27.
go back to reference Pampalon R, Hamel D, Gamache P, Philibert M, Raymond G, Simpson A. An area-based material and social deprivation index for public health in Québec and Canada. Can J Public Health. 2012;103:S17–22.PubMed Pampalon R, Hamel D, Gamache P, Philibert M, Raymond G, Simpson A. An area-based material and social deprivation index for public health in Québec and Canada. Can J Public Health. 2012;103:S17–22.PubMed
28.
go back to reference Chateau D, Metge C, Prior H, Soodeen R. Learning from the census: the Socio-economic Factor Index (SEFI) and health outcomes in Manitoba. Can J Public Health. 2012;103:S23–7.PubMed Chateau D, Metge C, Prior H, Soodeen R. Learning from the census: the Socio-economic Factor Index (SEFI) and health outcomes in Manitoba. Can J Public Health. 2012;103:S23–7.PubMed
29.
go back to reference Mikkonen J, Raphael D. Social determinants of health: the Canadian facts. Toronto: York University School of Health Policy and Management; 2010. Mikkonen J, Raphael D. Social determinants of health: the Canadian facts. Toronto: York University School of Health Policy and Management; 2010.
32.
go back to reference Janssen I, Boyce W, Simpson K, Pickett W. Influence of individual- and area-level measures of socioeconomic status on obesity, unhealthy eating, and physical inactivity in Canadian adolescents. Am J Clin Nutr. 2006;83:139–45.PubMed Janssen I, Boyce W, Simpson K, Pickett W. Influence of individual- and area-level measures of socioeconomic status on obesity, unhealthy eating, and physical inactivity in Canadian adolescents. Am J Clin Nutr. 2006;83:139–45.PubMed
33.
go back to reference Berry T, Spence J, Blanchard C, Cutumisu N, Edwards J, Nykiforuk C. Changes in BMI over 6 years: the role of demographic and neighborhood characteristics. Int J Obes Relat Metab Disord. 2010;34:1275–83.CrossRef Berry T, Spence J, Blanchard C, Cutumisu N, Edwards J, Nykiforuk C. Changes in BMI over 6 years: the role of demographic and neighborhood characteristics. Int J Obes Relat Metab Disord. 2010;34:1275–83.CrossRef
34.
go back to reference Sallis J, Floyd M, Rodriguez D, Saelens B. Role of built environments in physical activity, obesity, and cardiovascular disease. Circulation. 2012;125:729–37.CrossRefPubMedPubMedCentral Sallis J, Floyd M, Rodriguez D, Saelens B. Role of built environments in physical activity, obesity, and cardiovascular disease. Circulation. 2012;125:729–37.CrossRefPubMedPubMedCentral
35.
go back to reference Coleman N, Halas G, Peeler W, Casaclang N, Williamson T, Katz A. From patient care to research: a validation study examining the factors contributing to data quality in a primary care electronic medical record database. BMC Fam Pract. 2015;16:11.CrossRefPubMedPubMedCentral Coleman N, Halas G, Peeler W, Casaclang N, Williamson T, Katz A. From patient care to research: a validation study examining the factors contributing to data quality in a primary care electronic medical record database. BMC Fam Pract. 2015;16:11.CrossRefPubMedPubMedCentral
Metadata
Title
Utility of linking primary care electronic medical records with Canadian census data to study the determinants of chronic disease: an example based on socioeconomic status and obesity
Authors
Suzanne Biro
Tyler Williamson
Jannet Ann Leggett
David Barber
Rachael Morkem
Kieran Moore
Paul Belanger
Brian Mosley
Ian Janssen
Publication date
01-12-2016
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2016
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/s12911-016-0272-9

Other articles of this Issue 1/2016

BMC Medical Informatics and Decision Making 1/2016 Go to the issue