Rochester Epidemiology Project data exploration portal

Jennifer St. Sauver, Brandon R. Grossardt, Lila J Rutten, Veronique Lee Roger, Michelle Majerus, Daniel W. Jensen, Scott M. Brue, Cynthia M. Bock-Goodner, Walter A Rocca

Research output: Contribution to journalArticle

3 Citations (Scopus)

Abstract

Introduction The goal of this project was to develop an interactive, web-based tool to explore patterns of prevalence and co-occurrence of diseases using data from the expanded Rochester Epidemiology Project (E-REP) medical records-linkage system. Methods We designed the REP Data Exploration Portal (REP DEP) to include summary information for people who lived in a 27-county region of southern Minnesota and western Wisconsin on January 1, 2014 (n = 694,506; 61% of the entire population). We obtained diagnostic codes of the International Classification of Diseases, 9th edition, from the medical records-linkage system in 2009 through 2013 (5 years) and grouped them into 717 disease categories. For each condition or combination of 2 conditions (dyad), we calculated prevalence by dividing the number of persons with a specified condition (numerator) by the total number of persons in the population (denominator). We calculated observed-to-expected ratios (OERs) to test whether 2 conditions co-occur more frequently than would co-occur as a result of chance alone. Results We launched the first version of the REP DEP in May 2017. The REP DEP can be accessed at http://rochesterproject.org/portal/. Users can select 2 conditions of interest, and the REP DEP displays the overall prevalence, age-specific prevalence, and sex-specific prevalence for each condition and dyad. Also displayed are OERs overall and by age and sex and maps of county-specific prevalence of each condition and OER. Conclusion The REP DEP draws upon a medical records-linkage system to provide an innovative, rapid, interactive, free-of-charge method to examine the prevalence and co-occurrence of 717 diseases and conditions in a geographically defined population.

Original languageEnglish (US)
Article number170242
JournalPreventing chronic disease
Volume15
Issue number4
DOIs
StatePublished - Apr 1 2018

Fingerprint

Epidemiology
Medical Record Linkage
Population
International Classification of Diseases

ASJC Scopus subject areas

  • Health Policy
  • Public Health, Environmental and Occupational Health

Cite this

Rochester Epidemiology Project data exploration portal. / St. Sauver, Jennifer; Grossardt, Brandon R.; Rutten, Lila J; Roger, Veronique Lee; Majerus, Michelle; Jensen, Daniel W.; Brue, Scott M.; Bock-Goodner, Cynthia M.; Rocca, Walter A.

In: Preventing chronic disease, Vol. 15, No. 4, 170242, 01.04.2018.

Research output: Contribution to journalArticle

St. Sauver, Jennifer ; Grossardt, Brandon R. ; Rutten, Lila J ; Roger, Veronique Lee ; Majerus, Michelle ; Jensen, Daniel W. ; Brue, Scott M. ; Bock-Goodner, Cynthia M. ; Rocca, Walter A. / Rochester Epidemiology Project data exploration portal. In: Preventing chronic disease. 2018 ; Vol. 15, No. 4.
@article{3a5f2cf1c4bf494e9abd8c420fdc21ef,
title = "Rochester Epidemiology Project data exploration portal",
abstract = "Introduction The goal of this project was to develop an interactive, web-based tool to explore patterns of prevalence and co-occurrence of diseases using data from the expanded Rochester Epidemiology Project (E-REP) medical records-linkage system. Methods We designed the REP Data Exploration Portal (REP DEP) to include summary information for people who lived in a 27-county region of southern Minnesota and western Wisconsin on January 1, 2014 (n = 694,506; 61{\%} of the entire population). We obtained diagnostic codes of the International Classification of Diseases, 9th edition, from the medical records-linkage system in 2009 through 2013 (5 years) and grouped them into 717 disease categories. For each condition or combination of 2 conditions (dyad), we calculated prevalence by dividing the number of persons with a specified condition (numerator) by the total number of persons in the population (denominator). We calculated observed-to-expected ratios (OERs) to test whether 2 conditions co-occur more frequently than would co-occur as a result of chance alone. Results We launched the first version of the REP DEP in May 2017. The REP DEP can be accessed at http://rochesterproject.org/portal/. Users can select 2 conditions of interest, and the REP DEP displays the overall prevalence, age-specific prevalence, and sex-specific prevalence for each condition and dyad. Also displayed are OERs overall and by age and sex and maps of county-specific prevalence of each condition and OER. Conclusion The REP DEP draws upon a medical records-linkage system to provide an innovative, rapid, interactive, free-of-charge method to examine the prevalence and co-occurrence of 717 diseases and conditions in a geographically defined population.",
author = "{St. Sauver}, Jennifer and Grossardt, {Brandon R.} and Rutten, {Lila J} and Roger, {Veronique Lee} and Michelle Majerus and Jensen, {Daniel W.} and Brue, {Scott M.} and Bock-Goodner, {Cynthia M.} and Rocca, {Walter A}",
year = "2018",
month = "4",
day = "1",
doi = "10.5888/pcd15.170242",
language = "English (US)",
volume = "15",
journal = "Preventing chronic disease",
issn = "1545-1151",
publisher = "U.S. Department of Health and Human Services",
number = "4",

}

TY - JOUR

T1 - Rochester Epidemiology Project data exploration portal

AU - St. Sauver, Jennifer

AU - Grossardt, Brandon R.

AU - Rutten, Lila J

AU - Roger, Veronique Lee

AU - Majerus, Michelle

AU - Jensen, Daniel W.

AU - Brue, Scott M.

AU - Bock-Goodner, Cynthia M.

AU - Rocca, Walter A

PY - 2018/4/1

Y1 - 2018/4/1

N2 - Introduction The goal of this project was to develop an interactive, web-based tool to explore patterns of prevalence and co-occurrence of diseases using data from the expanded Rochester Epidemiology Project (E-REP) medical records-linkage system. Methods We designed the REP Data Exploration Portal (REP DEP) to include summary information for people who lived in a 27-county region of southern Minnesota and western Wisconsin on January 1, 2014 (n = 694,506; 61% of the entire population). We obtained diagnostic codes of the International Classification of Diseases, 9th edition, from the medical records-linkage system in 2009 through 2013 (5 years) and grouped them into 717 disease categories. For each condition or combination of 2 conditions (dyad), we calculated prevalence by dividing the number of persons with a specified condition (numerator) by the total number of persons in the population (denominator). We calculated observed-to-expected ratios (OERs) to test whether 2 conditions co-occur more frequently than would co-occur as a result of chance alone. Results We launched the first version of the REP DEP in May 2017. The REP DEP can be accessed at http://rochesterproject.org/portal/. Users can select 2 conditions of interest, and the REP DEP displays the overall prevalence, age-specific prevalence, and sex-specific prevalence for each condition and dyad. Also displayed are OERs overall and by age and sex and maps of county-specific prevalence of each condition and OER. Conclusion The REP DEP draws upon a medical records-linkage system to provide an innovative, rapid, interactive, free-of-charge method to examine the prevalence and co-occurrence of 717 diseases and conditions in a geographically defined population.

AB - Introduction The goal of this project was to develop an interactive, web-based tool to explore patterns of prevalence and co-occurrence of diseases using data from the expanded Rochester Epidemiology Project (E-REP) medical records-linkage system. Methods We designed the REP Data Exploration Portal (REP DEP) to include summary information for people who lived in a 27-county region of southern Minnesota and western Wisconsin on January 1, 2014 (n = 694,506; 61% of the entire population). We obtained diagnostic codes of the International Classification of Diseases, 9th edition, from the medical records-linkage system in 2009 through 2013 (5 years) and grouped them into 717 disease categories. For each condition or combination of 2 conditions (dyad), we calculated prevalence by dividing the number of persons with a specified condition (numerator) by the total number of persons in the population (denominator). We calculated observed-to-expected ratios (OERs) to test whether 2 conditions co-occur more frequently than would co-occur as a result of chance alone. Results We launched the first version of the REP DEP in May 2017. The REP DEP can be accessed at http://rochesterproject.org/portal/. Users can select 2 conditions of interest, and the REP DEP displays the overall prevalence, age-specific prevalence, and sex-specific prevalence for each condition and dyad. Also displayed are OERs overall and by age and sex and maps of county-specific prevalence of each condition and OER. Conclusion The REP DEP draws upon a medical records-linkage system to provide an innovative, rapid, interactive, free-of-charge method to examine the prevalence and co-occurrence of 717 diseases and conditions in a geographically defined population.

UR - http://www.scopus.com/inward/record.url?scp=85046088311&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85046088311&partnerID=8YFLogxK

U2 - 10.5888/pcd15.170242

DO - 10.5888/pcd15.170242

M3 - Article

VL - 15

JO - Preventing chronic disease

JF - Preventing chronic disease

SN - 1545-1151

IS - 4

M1 - 170242

ER -