Rochester Epidemiology Project Data Exploration Portal
ORIGINAL RESEARCH — Volume 15 — April 12, 2018
Jennifer L. St. Sauver, PhD, MPH1,2; Brandon R. Grossardt, MS3; Lila J. Finney Rutten, PhD, MPH1,2; Veronique L. Roger, MD, MPH1,2,4; Michelle Majerus, MBA5; Daniel W. Jensen, MPH6; Scott M. Brue, BS7; Cynthia M. Bock-Goodner, BS7; Walter A. Rocca, MD, MPH1,8 (View author affiliations)
Suggested citation for this article: St. Sauver JL, Grossardt BR, Finney Rutten LJ, Roger VL, Majerus M, Jensen DW, et al. Rochester Epidemiology Project Data Exploration Portal. Prev Chronic Dis 2018;15:170242. DOI: http://dx.doi.org/10.5888/pcd15.170242external icon.
PEER REVIEWED
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.
Introduction
Changes in health information technology during the last decade and an increasing demand for data sharing and transparency have increased public access to health-related data. In particular, several web-based tools have been developed to share local, state, and national health data with audiences ranging from the general public to public health agencies and epidemiologic researchers (1–10) (Table 1). These websites and interactive tools are intended to help communities throughout the United States understand the health of their county or state and to prioritize interventions. For example, County Health Rankings and America’s Health Rankings summarize and display data on factors important to health and health management (2,5). However, the data used by these sites are collected from cross-sectional surveys of various groups of people at single points in time (eg, the Behavioral Risk Factor Surveillance System [BRFSS]) (11,12). These sites have data that can be summarized individually, by demographic characteristics, and by geographic region, but exploration of associations between different conditions or across data sets is not possible because the data are rarely linked to identifiable individuals. In addition, survey data are self-reported, and the number and type of health conditions included are limited.
Other interfaces are available from the Centers for Medicare & Medicaid Services (CMS Data Navigator) (7), the Dartmouth Atlas of Health Care (8), and the Agency for Healthcare Research and Quality’s Healthcare Cost and Utilization Project website (HCUPnet) (9). These websites allow users to summarize Medicare and Medicaid claims information (7,8) as well as information from state and national inpatient and emergency department databases (13). The CMS Data Navigator provides access to published reports on various topics (7), and users can explore the prevalence and co-occurrence of 20 chronic conditions (through the Medicare Chronic Conditions Dashboard) (14,15). The Dartmouth Atlas website tools also aggregate and summarize Medicare data but allow for more customized queries focused on health care utilization and outcomes (8). However, these sites provide limited information on specific diseases and conditions, particularly those that are rare. In addition, Medicare predominantly serves the population aged 65 years or older. Therefore, these sites are of limited use for understanding the health of younger populations.
Finally, the HCUPnet website allows users to explore detailed data available from State and National Inpatient Databases, the State Ambulatory Surgery and Services Database, and State and National Emergency Department Databases (9). Information is available across all ages and both sexes, and on all conditions that occur during an inpatient or emergency department visit. However, these data sets lack information on outpatient visits, and the interactive tools do not allow users to explore associations across conditions.
Our objective was to develop an interactive, web-based tool, the Rochester Epidemiology Project (REP) Data Exploration Portal (DEP), to display data on the prevalence and co-occurrence of 717 conditions from the expanded REP medical records-linkage system, which collects data from participating health care providers in in a 27-county region of southern Minnesota and western Wisconsin (16–18).
Methods
Development of the REP DEP took place from May 2016 through May 2017. The Mayo Clinic and Olmsted Medical Center institutional review boards approved this project. We designed the tool to allow users to access summary information on the health conditions of people in a 27-county region of southern Minnesota and western Wisconsin. First, we coded information on 717 conditions. We then calculated 1) the prevalence of each selected condition, 2) the prevalence of combinations of 2 conditions (dyads), and 3) observed-to-expected ratios (OERs) to measure the excess co-occurrence of dyads.
Data source
From 1966 through 2010, the REP focused on the health of the Olmsted County, Minnesota, population (16,17). In 2010, the REP expanded to encompass people living in a 27-county region of southern Minnesota and western Wisconsin (18). The expanded REP (E-REP) captures data on all health conditions that come to medical attention at the participating health care providers in this region. The data are electronically available at the person-level for community members of all ages and are collected from all health care providers in the REP system, from inpatient records, outpatient records, and emergency departments (17,18).
We used REP DEP summary data for all people who lived in this region on January 1, 2014, and who were identified by using the E-REP infrastructure (18,19). The REP DEP includes data for nearly 700,000 persons (61% of the entire population in the region) (Table 2). Characteristics of the REP DEP population are similar to those of the entire 27-county region and of Minnesota and Wisconsin (Table 3). The age and sex distribution is also largely similar to that of the entire US population (20); however, people living in the 27 counties, compared with the entire US population, have a higher level of education and are less likely to be of a nonwhite race or Hispanic ethnicity (Table 3).
The REP DEP includes information only for persons who have given permission for their medical records to be used for research purposes (91% of the sample population) (18). All information is available in aggregate summary form only, and the REP DEP reports values only when an age, sex, and/or county stratum contains 11 or more people.
Medical conditions
We developed the REP DEP to offer information on 717 conditions. We obtained diagnosis codes of the International Classification of Diseases, 9th edition (ICD-9) from patient medical records between January 1, 2009 and December 31, 2013, and we grouped codes by using 2 coding systems. First, we grouped ICD-9 codes into categories defined by the Agency for Healthcare Research and Quality as part of the Hospital Cost and Utilization Project (21). We used the Clinical Classification Software (CCS) to define a total of 690 conditions: 283 main-level, 376 sub-level, and 31 sub-sub-level code groupings (22,23). Second, we created 20 additional groupings by using diagnosis code categories defined by the US Department of Health and Human Services for studying multiple chronic conditions (24); we also added anxiety disorders to this list for a total of 21 chronic condition groupings.
Finally, we identified a series of 6 mental and neurological conditions that were well characterized by a single ICD-9 code, and we created a REP-defined sublevel grouping (Alzheimer’s disease; dementia with Lewy bodies; Huntington’s chorea; restless legs syndrome; amyotrophic lateral sclerosis; and mild cognitive impairment). The complete list of ICD-9 codes defining each of the 717 conditions is available on the REP DEP website: http://rochesterproject.org/portal/.
Prevalence
We calculated the prevalence of each condition and the prevalence of dyads. A person was determined to have a condition if the medical record showed one or more diagnostic codes from the corresponding code grouping in the 5-year period before January 1, 2014. For each condition, we calculated prevalence by dividing the number of people with a specified condition (numerator) by the total number of people in the population (denominator). We calculated prevalence overall for a single condition and for dyads, and in strata by age, sex, and county.
Observed-to-expected ratios (OERs)
We calculated observed-to-expected ratios (OERs) to measure the excess co-occurrence of dyads (25,26). We divided the number of observed people with 2 conditions by the expected number of people with both conditions under the assumption of conditional independence. We computed the expected numbers of people at the single-year-of-age level. For example, the expected number of people with both conditions for the age stratum 0 to 20 years was calculated for single years of age from 0 to 20 and then summed. An OER of less than 1.0 indicates that fewer people were observed with co-occurring conditions than would be expected under the assumption of conditional independence. An OER greater than 1.0 indicates that more people with co-occurring conditions were observed than would be expected under the assumption of conditional independence.
We determined whether the OER differed significantly from 1.0 by calculating 95% confidence intervals directly from the Poisson distribution using Daly’s method (27). We used ColorBrewer version 2.0 to illustrate the range of OERs in color (28). Prevalence and OER values for each county were directly standardized by age and sex to the total 2010 US Decennial Census population (Appendix) to facilitate comparison across counties while accounting for differences in age and sex distributions (20).
Results
The first version of the REP DEP was launched in May 2017 and can be accessed at http://rochesterproject.org/portal/. To search for a condition, users can click on the box “Characteristic A selection” and start typing the text of the condition of interest. The selection list will narrow to include conditions matching the typed text. The second condition, Characteristic B, is selected in the same way. Users can display results by using the “Prevalence” tab and the “Geography” tab.
Prevalence tab
The prevalence tab for 2 selected conditions shows the prevalence of each condition as a line graph, by sex and overall, across 5 age groups (Figure 1). The tab also shows a graph of the prevalence of the 2 conditions co-occurring, by sex and overall, across 5 age groups. In addition, the tab shows a table of OERs by sex and age group. OERs are not calculated if fewer than 11 persons with both conditions are observed in a group. Similarly, for conditions affecting only one sex (eg, cancer of ovary), “NA [not applicable]” is reported in the table of OERs in the column for the unaffected sex and in the column for both sexes (“Total”). OER values that are significantly different from 1.0 are shaded with purple (OER < 1.0) and orange (OER > 1.0). OER values are not shaded if the OER is not significantly different from 1.0. For example, ovarian cancer and anxiety disorders can never co-occur in men, but they do co-occur more frequently than expected in women aged 40 to 64 years (Figure 1).
Figure 1.
Screenshot of the “Prevalence” tab for anxiety disorders, cancer of the ovary, and the dyad consisting of anxiety disorders and cancer of the ovary in the Rochester Epidemiology Project Data Exploration Portal. [A text description of this figure is also available.]
Geography tab
Users can also display the prevalence or OER for a selected condition by county and by sex (Figure 2). The standardized prevalence and OERs are displayed in a pop-up box when the cursor hovers over a selected county. The map in the sample screenshot indicates that the age-standardized prevalence of ovarian cancer varies across the 27-county region and is highest in Martin County.
Figure 2.
Screenshot of the “Geography” tab displaying the prevalence of cancer of the ovary (per 1,000 women) across the 27-county region in the Rochester Epidemiology Project Data Exploration Portal. [A text description of this figure is also available.]
Discussion
We developed the interactive, web-based REP DEP to display the prevalence and co-occurrence of 717 diseases and conditions recorded in the E-REP records-linkage system. We expect the REP DEP to be useful to local residents, health care practitioners, and local administrators in understanding patterns of disease in this Midwestern region. The data may also serve as a benchmark for other communities and may provide a cost-effective way for researchers to explore whether an association between 2 conditions exists before conducting a full epidemiologic study.
The REP DEP includes data on all conditions that come to medical attention, regardless of whether the care was delivered in the outpatient, inpatient, or emergency department setting. As such, it overcomes limitations of other websites that include only a limited number of conditions or only data from inpatient or emergency department settings (2–6,13), and it allows users to obtain prevalence estimates on both common and rare conditions and to include both inpatient and outpatient diagnoses. Second, the REP DEP includes data for all age groups, overcoming the limitations of websites that rely predominantly on Medicare data (7,8). We expect REP DEP prevalence estimates to be particularly useful for public health and care delivery organizations in this 27-county region in ranking their most urgent community health priorities. For example, tax-exempt hospitals must conduct a community health needs assessment every 3 years in compliance with the Patient Protection and Affordable Care Act, and they must develop a community health improvement plan to address the most urgent priorities (29). The REP DEP can identify the prevalence of a wide array of medical conditions, and, in the future, will provide a way to determine whether the prevalence of key conditions changes over time.
REP DEP data are also linked at the person-level, which allows users to explore associations between conditions. This type of data exploration is not possible on other websites that aggregate de-identified data from different sources and populations (2–6). In addition, the underlying data included in the REP DEP are linked to patient identifiers through the E-REP research infrastructure (18). With appropriate approvals, the E-REP can be leveraged for recruiting study participants, and these participants may be followed via their linked medical records to cost-effectively assess outcomes that come to medical attention. Therefore, the REP DEP offers a method for determining whether a given community includes a sufficient number of potential participants for a community-based clinical trial (30).
This study has limitations. Data are available for 61% of the population residing in the 27-county region. Participants may differ from nonparticipants, and prevalence estimates may be biased. Conditions that are diagnosed and treated at health care providers that do not participate in the E-REP may be missed, and the true prevalence of some conditions may be underestimated. The age and sex distribution of the population included in the REP DEP is similar to US Census estimates for the 27-county region, but participants may differ from nonparticipants in other factors that influence health (eg, socioeconomic status).
Second, we informally compared REP DEP prevalences for 5 common chronic conditions with 2015 prevalence estimates for the state of Minnesota from the BRFSS (31); however, we did not perform formal statistical testing for the differences. Prevalence estimates were similar for asthma (REP DEP, 8% vs BRFSS, 7%) and depression (REP DEP, 14% vs BRFSS, 19%). However, REP DEP estimates were higher for diabetes (REP DEP, 14% vs BRFSS, 8%), and lower for arthritis (REP DEP, 15% vs BRFSS, 22%) and hyperlipidemia (REP DEP, 24% vs BRFSS, 32%). These discrepancies highlight the fact that different data collection methods are likely to yield different prevalence estimates. Methodologic differences between the BRFSS and the REP DEP preclude a more formal comparison. The BRFSS estimates were obtained from adult participants reporting whether they had ever been told that they had the condition of interest. By contrast, the REP DEP prevalence estimates were obtained from data on participants of all ages whose medical record had at least one ICD-9 code of interest in a 5-year time frame. The underlying ICD-9 codes were obtained from billing data and were not validated. Therefore, the prevalences and OERs generated by the REP-DEP may deviate from the truth. This limitation is common to all publicly accessible databases. In addition, the sensitivity and specificity of a single ICD-9 code for a condition of interest varies (32,33). Therefore, further validation studies may be necessary, depending on the condition of interest. Finally, the BRFSS estimates were for the adult population of the entire state of Minnesota, whereas the REP DEP estimates were for persons of all ages residing in a region that includes southern Minnesota and western Wisconsin. Inclusion of children in the estimates will underestimate the prevalence of chronic diseases that predominantly affect adults. However, variability in prevalence estimates may also reflect true prevalence differences between the REP DEP and BRFSS populations.
Third, ICD-9 codes were grouped into larger categories. Specific diagnoses may have been overly aggregated, resulting in the inability to test for associations of interest. For example, the diagnostic codes for Alzheimer’s disease are part of the larger category of “delirium, dementia, and amnestic and other cognitive disorders.” However, Alzheimer’s disease is a major research focus for many investigators; therefore, we included Alzheimer’s disease as an option in our search tool. In the second release of the REP DEP (January 2018), we included a series of more specific conditions. Finally, once we have 3 full years of data accumulation (2014–2016), we will add trend graphs to explore increases or decreases in the prevalence of conditions across calendar years.
The REP DEP covers a geographically defined Midwestern population, and the prevalence of medical conditions will be different in other United States communities, depending on the characteristics of the underlying population. However, the REP DEP data may still serve as a useful benchmark for other communities. In particular, it is often difficult to obtain baseline prevalence data for rare conditions. The REP DEP provides prevalence estimates for all conditions in this population, and it offers a free, rapid way to obtain comparison data. The REP DEP also provides an example of how other communities might leverage and display their own data to inform local planning efforts.
Finally, the underlying biological processes that lead to the development and co-occurrence of diseases and conditions are less likely to vary from community to community. Therefore, the OERs that can be obtained through the REP DEP are likely generalizable to other populations. As such, these data provide an avenue for researchers to determine whether 2 conditions are associated before conducting a larger, resource-intensive epidemiologic study.
The REP DEP provides a rapid, interactive, free-of-charge method to examine the prevalence and co-occurrence of 717 diseases and conditions in a large, Midwestern population. The REP DEP will be useful to local communities for understanding the prevalence of virtually all conditions in this region. In addition, these data may serve as a benchmark for other communities, particularly for rare conditions. The REP DEP can provide preliminary data for investigators who are considering further studies of the co-occurrence of diseases or are assessing the feasibility of a community-based clinical trial.
In January 2018, we released a new version of the REP DEP. This updated version of the portal allows users to choose from among 1,376 characteristics, including diagnosis-based medical conditions, procedures and surgeries, prescription medications, and demographic characteristics (eg, race, ethnicity, smoking status, overweight and obesity categories). In addition, users may now choose to define a characteristic as occurring in either the 5-year period before prevalence date or in a 1-year period before prevalence date. These updates to the REP DEP give users more flexibility to explore the relationships between characteristics. Complete details can be found in the updated REP DEP User Manual on the portal Documentation tab (http://www.rochesterproject.org/portal/).
Acknowledgments
This study used the resources of the REP, which is supported by the National Institute on Aging of the National Institutes of Health (NIH) under award numbers R01 AG034676 and AG052425. The content of this article is solely the responsibility of the authors and does not necessarily represent the official views of NIH. This study was also supported by the Robert D. and Patricia E. Kern Mayo Clinic Center for the Science of Health Care Delivery, Population Health Research Program. We thank Melissa Hart, Elizabeth Zimmerman-Young, Lori Klein, and Christine Prissel for project management support, and Robin Adams for her assistance in typing and formatting the manuscript.
Author Information
Corresponding Author: Jennifer L. St. Sauver, PhD, Mayo Clinic, 200 First St SW, Rochester, MN 55905. Telephone: 507-538-1460. Email: stsauver.jennifer@mayo.edu.
Author Affiliations: 1Division of Epidemiology, Department of Health Sciences Research, Mayo Clinic, Rochester, Minnesota. 2Robert D. and Patricia E. Kern Center for the Science of Health Care Delivery, Mayo Clinic, Rochester, Minnesota. 3Division of Biomedical Statistics and Informatics, Department of Health Sciences Research, Mayo Clinic, Rochester, Minnesota. 4Department of Cardiology, Mayo Clinic, Rochester, Minnesota. 5Health Information Management, Information Privacy Office, Olmsted Medical Center, Rochester, Minnesota. 6Olmsted County Public Health Services, Rochester, Minnesota. 7Department of Information Technology, Mayo Clinic, Rochester, Minnesota. 8Department of Neurology, Mayo Clinic, Rochester, Minnesota.
References
- FastStats: statistics by topic. Atlanta (GA): Centers for Disease Control and Prevention, National Center for Health Statistics; 2016. https://www.cdc.gov/nchs/fastats. Accessed August 30, 2017.
- County Health Rankings & Roadmaps. Madison (WI): University of Wisconsin Population Health Institute; 2017. http://www.countyhealthrankings.org. Accessed August 30, 2017.
- Remington PL, Catlin BB, Gennuso KP. The County Health Rankings: rationale and methods. Popul Health Metr 2015;13(1):11. CrossRefexternal icon PubMedexternal icon
- FluView interactive. Atlanta (GA): Centers for Disease Control and Prevention, National Center for Immunization and Respiratory Diseases; 2017. https://www.cdc.gov/flu/weekly/fluviewinteractive.htm. Accessed August 30, 2017.
- America’s Health Rankings. Minneapolis (MN): United Health Group; 2017. https://www.americashealthrankings.org. Accessed August 30, 2017.
- US Centers for Disease Control and Prevention. Atlanta (GA): Centers for Disease Control and Prevention; 2017. https://data.cdc.gov. Accessed August 30, 2017.
- CMS Data Navigator. Baltimore (MD): Centers for Medicare & Medicaid Services; 2017. https://dnav.cms.gov. Accessed August 30, 2017.
- The Dartmouth atlas of health care. Lebanon (NH): Dartmouth Institute for Health Policy and Clinical Practice; 2017. http://www.dartmouthatlas.org. Accessed August 30, 2017.
- HCUPnet: Healthcare Cost and Utilization Project. Rockville (MD): Agency for Healthcare Research and Quality; 2017. https://hcupnet.ahrq.gov/#setup. Accessed August 30, 2017.
- Dartmouth Medical School. Center for the Evaluative Clinical Sciences. The Dartmouth atlas of health care 1998: http://www.dartmouthatlas.org/downloads/atlases/98atlas.pdf. Accessed March 15, 2018.
- Behavioral Risk Factor Surveillance System operational and user’s guide. Atlanta (GA): Centers for Disease Control and Prevention, US Department of Health and Human Services; 2005. https://www.cdc.gov/brfss/pdf/userguide.pdf. Accessed August 30, 2017.
- Behavioral Risk Factor Surveillance System. Atlanta (GA): Centers for Disease Control and Prevention, US Department of Health and Human Services; 2017. https://www.cdc.gov/brfss/. Accessed August 30, 2017.
- HCUP databases. Rockville (MD): Agency for Healthcare Research and Quality; 2017. https://www.hcup-us.ahrq.gov/databases.jsp. Accessed August 30, 2017.
- Interactive atlas of chronic conditions. Baltimore (MD): Centers for Medicare and Medicaid Services (CMS); 2017. https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/Chronic-Conditions/Interactive_Atlas.html. Accessed August 30, 2017.
- Multiple chronic conditions reports. Baltimore (MD): Centers for Medicare & Medicaid Services; 2017 https://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/Chronic-Conditions/MCC_Main.html. Accessed August 30, 2017.
- St Sauver JL, Grossardt BR, Yawn BP, Melton LJ 3d, Pankratz JJ, Brue SM, et al. Data resource profile: the Rochester Epidemiology Project (REP) medical records-linkage system. Int J Epidemiol 2012;41(6):1614–24. CrossRefexternal icon PubMedexternal icon
- Rocca WA, Yawn BP, St Sauver JL, Grossardt BR, Melton LJ 3d. History of the Rochester Epidemiology Project: half a century of medical records linkage in a US population. Mayo Clin Proc 2012;87(12):1202–13. CrossRefexternal icon PubMedexternal icon
- Rocca WA, Grossardt BR, Brue SM, Bock-Goodner CM, Chamberlain AM, Wilson PM, et al. Data resource profile: expansion of the Rochester Epidemiology Project medical records-linkage system (E-REP). Int J Epidemiol 2018. CrossRefexternal icon PubMedexternal icon
- St Sauver JL, Grossardt BR, Yawn BP, Melton LJ 3d, Rocca WA. Use of a medical records linkage system to enumerate a dynamic population over time: the Rochester epidemiology project. Am J Epidemiol 2011;173(9):1059–68. CrossRefexternal icon PubMedexternal icon
- Annual county resident population estimates by age, sex, race, and Hispanic origin: April 1, 2010 to July 1, 2015. US Census Bureau American Fact Finder; 2017. https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?pid=ACS_15_5YR_CP05&prodType=table. Accessed January 30, 2017.
- Clinical Classifications Software (CCS) for ICD-9-CM. Rockville (MD): Agency for Healthcare Research and Quality. Healthcare Cost and Utilization Project (HCUP); 2017. https://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp#overview. Accessed August 30, 2017.
- Clinical Classifications Software (CCS) category names (full labels). Single-level CCS and multi-level CCS. Rockville (MD): Agency for Healthcare Research and Quality. Healthcare Cost and Utilization Project (HCUP); 2017. https://www.hcup-us.ahrq.gov/toolssoftware/ccs/CCSCategoryNames_FullLabels.pdf. Accessed August 30, 2017.
- Medical Expenditure Panel Survey (MEPS) summary data tables: condition categories. Rockville (MD): Agency for Healthcare Research and Quality; 2017. https://meps.ahrq.gov/data_stats/conditions04.shtml. Accessed August 30, 2017.
- Goodman RA, Posner SF, Huang ES, Parekh AK, Koh HK. Defining and measuring chronic conditions: imperatives for research, policy, program, and practice. Prev Chronic Dis 2013;10:E66. CrossRefexternal icon PubMedexternal icon
- Toolkit for using the AHRQ quality indicators. Rockville (MD): Agency for Healthcare Research and Quality; 2017. https://www.ahrq.gov/sites/default/files/wysiwyg/professionals/systems/hospital/qitoolkit/b1-applyingqis.pdf. Accessed August 30, 2017.
- Appendix V: method of calculating observed to expected ratio as a measure of strength of association. Canberra, Australia; 2006. http://www.abs.gov.au/AUSSTATS/@.nsf/956c382b0b05ba7d4a2568010004e173/a576701f2eeeef76ca256d6b0004e3e4!OpenDocument. Accessed August 30, 2017.
- Daly L. Simple SAS macros for the calculation of exact binomial and Poisson confidence limits. Comput Biol Med 1992;22(5):351–61. CrossRefexternal icon PubMedexternal icon
- ColorBrewer 2.0. State College (PA): Brewer C, Harrower M, The Pennsylvania State University; 2009. http://colorbrewer2.org/. Accessed August 30, 2017.
- Rosenbaum S. The Patient Protection and Affordable Care Act: implications for public health policy and practice. Public Health Rep 2011;126(1):130–5. CrossRefexternal icon PubMedexternal icon
- Roehr B. The appeal of large simple trials. BMJ 2013;346:f1317. CrossRefexternal icon PubMedexternal icon
- Behavioral Risk Factor Surveillance System: prevalence data and data analysis tools. Atlanta (GA): Centers for Disease Control and Prevention; 2016. https://www.cdc.gov/brfss/data_tools.htm. Accessed August 30, 2017.
- Hebert PL, Geiss LS, Tierney EF, Engelgau MM, Yawn BP, McBean AM. Identifying persons with diabetes using Medicare claims data. Am J Med Qual 1999;14(6):270–7. CrossRefexternal icon PubMedexternal icon
- Quan H, Li B, Saunders LD, Parsons GA, Nilsson CI, Alibhai A, et al. Assessing validity of ICD-9-CM and ICD-10 administrative data in recording clinical conditions in a unique dually coded database. Health Serv Res 2008;43(4):1424–41. CrossRefexternal icon PubMedexternal icon
Tables
Abbreviations: AHRQ, Agency for Healthcare Research and Quality; BRFSS, Behavioral Risk Factor Surveillance System; CDC, Centers for Disease Control and Prevention; CMS, Centers for Medicare & Medicaid Services; HCUP, Healthcare Cost and Utilization Project; REP DEP, Rochester Epidemiology Project Data Exploration Portal; USDA, US Department of Agriculture.
a Is it possible to explore the co-occurrence of 2 diseases or conditions among people in the county?
b Can investigators contact people with a given disease or condition to invite them to participate in an observational study or a clinical trial?
c “Topics” refers to health-related, social, environmental, or economic areas of public health importance.
a Table includes data only for persons who gave permission for all or part of their medical record information to be used for research purposes. The complete population enumerated by the Rochester Epidemiology Project Census on January 1, 2014 comprised 763,695 persons (369,403 men and 394,292 women); therefore, the participation rates were 90.9% overall, 91.3% for men, and 90.6% for women.
a The estimates for 2014 are from the US Census (20).
b Other and mixed race includes persons who reported their race as “other” or “mixed” in the Expanded Rochester Epidemiology Project and persons who specified “Two or more races” in the US Census.
c Data on education were available for 46.1% of the Expanded REP DEP population aged ≥25 years.
Appendix. Total 2010 US Census Population Used for Direct Standardization
| Age, ya | Population, N | ||
|---|---|---|---|
| Men | Women | Total | |
| 0–1 | 2,014,276 | 1,929,877 | 3,944,153 |
| 1–2 | 2,030,853 | 1,947,217 | 3,978,070 |
| 2–3 | 2,092,198 | 2,004,731 | 4,096,929 |
| 3–4 | 2,104,550 | 2,014,490 | 4,119,040 |
| 4–5 | 2,077,550 | 1,985,620 | 4,063,170 |
| 5–6 | 2,072,094 | 1,984,764 | 4,056,858 |
| 6–7 | 2,075,319 | 1,991,062 | 4,066,381 |
| 7–8 | 2,057,076 | 1,973,503 | 4,030,579 |
| 8–9 | 2,065,453 | 1,981,033 | 4,046,486 |
| 9–10 | 2,119,696 | 2,028,657 | 4,148,353 |
| 10–11 | 2,135,996 | 2,036,545 | 4,172,541 |
| 11–12 | 2,103,264 | 2,011,151 | 4,114,415 |
| 12–13 | 2,100,145 | 2,006,098 | 4,106,243 |
| 13–14 | 2,104,914 | 2,013,099 | 4,118,013 |
| 14–15 | 2,135,543 | 2,030,439 | 4,165,982 |
| 15–16 | 2,177,022 | 2,065,798 | 4,242,820 |
| 16–17 | 2,216,034 | 2,100,105 | 4,316,139 |
| 17–18 | 2,263,153 | 2,132,142 | 4,395,295 |
| 18–19 | 2,305,473 | 2,195,382 | 4,500,855 |
| 19–20 | 2,341,984 | 2,243,250 | 4,585,234 |
| 20–21 | 2,308,319 | 2,210,810 | 4,519,129 |
| 21–22 | 2,223,198 | 2,131,096 | 4,354,294 |
| 22–23 | 2,177,797 | 2,086,845 | 4,264,642 |
| 23–24 | 2,140,799 | 2,057,772 | 4,198,571 |
| 24–25 | 2,164,063 | 2,085,300 | 4,249,363 |
| 25–26 | 2,161,308 | 2,101,042 | 4,262,350 |
| 26–27 | 2,097,088 | 2,055,217 | 4,152,305 |
| 27–28 | 2,140,651 | 2,108,218 | 4,248,869 |
| 28–29 | 2,118,605 | 2,096,644 | 4,215,249 |
| 29–30 | 2,117,939 | 2,105,137 | 4,223,076 |
| 30–31 | 2,160,802 | 2,124,866 | 4,285,668 |
| 31–32 | 1,988,155 | 1,982,063 | 3,970,218 |
| 32–33 | 1,994,476 | 1,992,371 | 3,986,847 |
| 33–34 | 1,936,863 | 1,943,287 | 3,880,150 |
| 34–35 | 1,916,204 | 1,923,012 | 3,839,216 |
| 35–36 | 1,980,916 | 1,975,518 | 3,956,434 |
| 36–37 | 1,890,595 | 1,911,492 | 3,802,087 |
| 37–38 | 1,953,386 | 1,981,059 | 3,934,445 |
| 38–39 | 2,049,720 | 2,072,160 | 4,121,880 |
| 39–40 | 2,167,405 | 2,197,391 | 4,364,796 |
| 40–41 | 2,191,249 | 2,192,025 | 4,383,274 |
| 41–42 | 2,047,818 | 2,067,167 | 4,114,985 |
| 42–43 | 2,028,653 | 2,047,451 | 4,076,104 |
| 43–44 | 2,035,990 | 2,069,115 | 4,105,105 |
| 44–45 | 2,090,267 | 2,121,229 | 4,211,496 |
| 45–46 | 2,237,450 | 2,271,418 | 4,508,868 |
| 46–47 | 2,230,982 | 2,288,779 | 4,519,761 |
| 47–48 | 2,238,248 | 2,297,017 | 4,535,265 |
| 48–49 | 2,237,734 | 2,301,062 | 4,538,796 |
| 49–50 | 2,264,671 | 2,341,230 | 4,605,901 |
| 50–51 | 2,300,354 | 2,359,941 | 4,660,295 |
| 51–52 | 2,190,766 | 2,273,865 | 4,464,631 |
| 52–53 | 2,207,246 | 2,293,600 | 4,500,846 |
| 53–54 | 2,141,354 | 2,239,000 | 4,380,354 |
| 54–55 | 2,093,554 | 2,198,445 | 4,291,999 |
| 55–56 | 2,073,473 | 2,181,236 | 4,254,709 |
| 56–57 | 1,956,141 | 2,081,372 | 4,037,513 |
| 57–58 | 1,905,355 | 2,031,031 | 3,936,386 |
| 58–59 | 1,834,808 | 1,960,120 | 3,794,928 |
| 59–60 | 1,753,871 | 1,887,398 | 3,641,269 |
| 60–61 | 1,745,507 | 1,875,624 | 3,621,131 |
| 61–62 | 1,679,077 | 1,813,519 | 3,492,596 |
| 62–63 | 1,712,692 | 1,850,490 | 3,563,182 |
| 63–64 | 1,672,329 | 1,811,555 | 3,483,884 |
| 64–65 | 1,267,895 | 1,389,236 | 2,657,131 |
| 65–66 | 1,273,310 | 1,407,451 | 2,680,761 |
| 66–67 | 1,248,276 | 1,390,865 | 2,639,141 |
| 67–68 | 1,248,906 | 1,400,459 | 2,649,365 |
| 68–69 | 1,087,296 | 1,236,376 | 2,323,672 |
| 69–70 | 994,759 | 1,147,565 | 2,142,324 |
| 70–71 | 945,611 | 1,097,510 | 2,043,121 |
| 71–72 | 900,148 | 1,049,175 | 1,949,323 |
| 72–73 | 853,726 | 1,010,549 | 1,864,275 |
| 73–74 | 787,863 | 949,097 | 1,736,960 |
| 74–75 | 756,624 | 927,863 | 1,684,487 |
| 75–76 | 721,008 | 899,069 | 1,620,077 |
| 76–77 | 647,804 | 823,266 | 1,471,070 |
| 77–78 | 631,884 | 823,446 | 1,455,330 |
| 78–79 | 602,458 | 797,665 | 1,400,123 |
| 79–80 | 579,234 | 791,961 | 1,371,195 |
| 80–81 | 543,559 | 764,952 | 1,308,511 |
| 81–82 | 494,870 | 717,995 | 1,212,865 |
| 82–83 | 462,983 | 698,438 | 1,161,421 |
| 83–84 | 419,831 | 654,978 | 1,074,809 |
| 84–85 | 373,131 | 612,590 | 985,721 |
| 85–86 | 336,819 | 577,904 | 914,723 |
| 86–87 | 293,120 | 521,091 | 814,211 |
| 87–88 | 249,803 | 463,105 | 712,908 |
| 88–89 | 217,436 | 423,183 | 640,619 |
| 89–90 | 176,689 | 361,309 | 537,998 |
| 90–91 | 136,948 | 298,615 | 435,563 |
| 91–92 | 103,799 | 241,188 | 344,987 |
| 92–93 | 81,072 | 200,317 | 281,389 |
| 93–94 | 59,037 | 157,941 | 216,978 |
| 94–95 | 43,531 | 125,918 | 169,449 |
| 95–96 | 30,951 | 98,766 | 129,717 |
| 96–97 | 21,424 | 73,799 | 95,223 |
| 97–98 | 14,556 | 53,582 | 68,138 |
| 98–99 | 9,259 | 36,641 | 45,900 |
| ≥99 | 15,235 | 70,395 | 85,630 |
| All ages | 151,781,326 | 156,964,212 | 308,745,538 |
a Age intervals include the lower value and exclude the upper value. For example, the interval 0–1 includes all persons of age birth through the day before the first birthday.
The opinions expressed by authors contributing to this journal do not necessarily reflect the opinions of the U.S. Department of Health and Human Services, the Public Health Service, the Centers for Disease Control and Prevention, or the authors’ affiliated institutions.