{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,7]],"date-time":"2026-02-07T18:55:25Z","timestamp":1770490525178,"version":"3.49.0"},"reference-count":51,"publisher":"Oxford University Press (OUP)","issue":"4","license":[{"start":{"date-parts":[[2019,1,31]],"date-time":"2019-01-31T00:00:00Z","timestamp":1548892800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/academic.oup.com\/journals\/pages\/open_access\/funder_policies\/chorus\/standard_publication_model"}],"funder":[{"name":"Patient-Centered Outcomes Research Institute Program","award":["CDRN-1306-04631"],"award-info":[{"award-number":["CDRN-1306-04631"]}]},{"DOI":"10.13039\/100000057","name":"National Institute of General Medical Sciences","doi-asserted-by":"publisher","award":["1U54GM115458-01"],"award-info":[{"award-number":["1U54GM115458-01"]}],"id":[{"id":"10.13039\/100000057","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,4,1]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:sec>\n                  <jats:title>Objective<\/jats:title>\n                  <jats:p>Clinical research data warehouses are largely populated from information extracted from electronic health records (EHRs). While these data provide information about a patient\u2019s medications, laboratory results, diagnoses, and history, her social, economic, and environmental determinants of health are also major contributing factors in readmission, morbidity, and mortality and are often absent or unstructured in the EHR. Details about a patient\u2019s socioeconomic status may be found in the U.S. census. To facilitate researching the impacts of socioeconomic status on health outcomes, clinical and socioeconomic data must be linked in a repository in a fashion that supports seamless interrogation of these diverse data elements. This study demonstrates a method for linking clinical and location-based data and querying these data in a de-identified data warehouse using Informatics for Integrating Biology and the Bedside.<\/jats:p>\n               <\/jats:sec>\n               <jats:sec>\n                  <jats:title>Materials and Methods<\/jats:title>\n                  <jats:p>Patient data were extracted from the EHR at Nebraska Medicine. Socioeconomic variables originated from the 2011-2015 five-year block group estimates from the American Community Survey. Data querying was performed using Informatics for Integrating Biology and the Bedside. All location-based data were truncated to prevent identification of a location with a population &amp;lt;20\u00a0000 individuals.<\/jats:p>\n               <\/jats:sec>\n               <jats:sec>\n                  <jats:title>Results<\/jats:title>\n                  <jats:p>We successfully linked location-based and clinical data in a de-identified data warehouse and demonstrated its utility with a sample use case.<\/jats:p>\n               <\/jats:sec>\n               <jats:sec>\n                  <jats:title>Discussion<\/jats:title>\n                  <jats:p>With location-based data available for querying, research investigating the impact of socioeconomic context on health outcomes is possible. Efforts to improve geocoding can readily be incorporated into this model.<\/jats:p>\n               <\/jats:sec>\n               <jats:sec>\n                  <jats:title>Conclusion<\/jats:title>\n                  <jats:p>This study demonstrates a means for incorporating and querying census data in a de-identified clinical data warehouse.<\/jats:p>\n               <\/jats:sec>","DOI":"10.1093\/jamia\/ocy172","type":"journal-article","created":{"date-parts":[[2018,11,27]],"date-time":"2018-11-27T20:12:24Z","timestamp":1543349544000},"page":"286-293","source":"Crossref","is-referenced-by-count":16,"title":["Incorporating a location-based socioeconomic index into a de-identified i2b2 clinical data warehouse"],"prefix":"10.1093","volume":"26","author":[{"given":"Bret J","family":"Gardner","sequence":"first","affiliation":[{"name":"Department of Emergency Medicine, University of Nebraska Medical Center, Omaha, Nebraska, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jay G","family":"Pedersen","sequence":"additional","affiliation":[{"name":"Department of Pathology and Microbiology, University of Nebraska Medical Center, Omaha, Nebraska, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Mary E","family":"Campbell","sequence":"additional","affiliation":[{"name":"Department of Sociology, Texas A&M University, College Station, Texas, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"James C","family":"McClay","sequence":"additional","affiliation":[{"name":"Department of Emergency Medicine, University of Nebraska Medical Center, Omaha, Nebraska, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"286","published-online":{"date-parts":[[2019,1,31]]},"reference":[{"key":"2020110613061835900_ocy172-B1","first-page":"1","article-title":"Use and characteristics of electronic health record systems among office-based physician practices: United States, 2001-2013","volume":"143","author":"Hsiao","year":"2014","journal-title":"NCHS Data Brief"},{"key":"2020110613061835900_ocy172-B2","doi-asserted-by":"crossref","first-page":"35","DOI":"10.7205\/MILMED-D-03-9708","article-title":"National electronic health record interoperability chronology","volume":"174 (Suppl 5)","author":"Hufnagel","year":"2009","journal-title":"Mil Med"},{"key":"2020110613061835900_ocy172-B3","author":"Charles","year":":\/\/..\/\/\/\/\/16."},{"issue":"12","key":"2020110613061835900_ocy172-B4","doi-asserted-by":"crossref","first-page":"2174","DOI":"10.1377\/hlthaff.2015.0992","article-title":"Electronic health record adoption in US hospitals: progress continues, but challenges persist","volume":"34","author":"Adler-Milstein","year":"2015","journal-title":"Health Aff"},{"issue":"10","key":"2020110613061835900_ocy172-B5","doi-asserted-by":"crossref","first-page":"860","DOI":"10.1136\/jech.2008.084814","article-title":"Neighbourhood socioeconomic status and biological \u2018wear and tear\u2019 in a nationally representative sample of US adults","volume":"64","author":"Bird","year":"2010","journal-title":"J Epidemiol Community Health"},{"issue":"1","key":"2020110613061835900_ocy172-B6","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1093\/jamiaopen\/ooy025","article-title":"Informatics can help providers incorporate context into care","volume":"1","author":"Estiri","year":"2018","journal-title":"JAMIA Open"},{"issue":"3","key":"2020110613061835900_ocy172-B7","doi-asserted-by":"crossref","first-page":"430","DOI":"10.1016\/j.amepre.2017.10.004","article-title":"Measures of SES for electronic health record-based research","volume":"54","author":"Casey","year":"2018","journal-title":"Am J Prev Med"},{"key":"2020110613061835900_ocy172-B8","doi-asserted-by":"crossref","DOI":"10.1542\/hpeds.2017-0032","article-title":"Neighborhood deprivation and childhood asthma outcomes, accounting for insurance coverage","author":"Nkoy","year":"2018","journal-title":"Hosp Pediatr"},{"issue":"10","key":"2020110613061835900_ocy172-B9","doi-asserted-by":"crossref","first-page":"1880","DOI":"10.1377\/hlthaff.2011.0640","article-title":"Place, not race: disparities dissipate in southwest Baltimore when blacks and whites live under similar conditions","volume":"30","author":"LaVeist","year":"2011","journal-title":"Health Aff"},{"issue":"11","key":"2020110613061835900_ocy172-B10","doi-asserted-by":"crossref","first-page":"2147","DOI":"10.2105\/AJPH.2013.301420","article-title":"Disparities in diabetes: the nexus of race, poverty, and place","volume":"104","author":"Gaskin","year":"2014","journal-title":"Am J Public Health"},{"issue":"1","key":"2020110613061835900_ocy172-B11","doi-asserted-by":"crossref","first-page":"48","DOI":"10.1093\/oxfordjournals.aje.a009191","article-title":"Neighborhood environments and coronary heart disease: a multilevel analysis","volume":"146","author":"Diez-Roux","year":"1997","journal-title":"Am J Epidemiol"},{"issue":"2","key":"2020110613061835900_ocy172-B12","doi-asserted-by":"crossref","first-page":"91","DOI":"10.2307\/2676393","article-title":"Neighborhood social context and racial differences in women\u2019s heart disease mortality","volume":"39","author":"LeClere","year":"1998","journal-title":"J Health Soc Behav"},{"key":"2020110613061835900_ocy172-B13","doi-asserted-by":"crossref","first-page":"178","DOI":"10.1093\/epirev\/mxp001","article-title":"Is segregation bad for your health?","volume":"31","author":"Kramer","year":"2009","journal-title":"Epidemiol Rev"},{"key":"2020110613061835900_ocy172-B14","doi-asserted-by":"crossref","first-page":"885","DOI":"10.2105\/AJPH.2007.131854","article-title":"Association between neighborhood context and smoking prevalence among Asian Americans","volume":"99","author":"Kandula","year":"2009","journal-title":"Am J Public Health"},{"issue":"5","key":"2020110613061835900_ocy172-B15","doi-asserted-by":"crossref","first-page":"1145","DOI":"10.1111\/j.1540-6237.2009.00651.x","article-title":"Acculturation in context: gender, age at migration, neighborhood ethnicity, and health behaviors","volume":"90","author":"Kimbro","year":"2009","journal-title":"Soc Sci Q"},{"key":"2020110613061835900_ocy172-B16","first-page":"900","article-title":"Racial\/ethnic neighborhood concentration and self-reported health in New York City","volume":"16","author":"White","year":"2006","journal-title":"Ethn Dis"},{"issue":"10","key":"2020110613061835900_ocy172-B17","doi-asserted-by":"crossref","first-page":"1127","DOI":"10.1001\/jama.295.10.1127","article-title":"Fine particulate air pollution and hospital admission for cardiovascular and respiratory diseases","volume":"295","author":"Dominici","year":"2006","journal-title":"JAMA"},{"issue":"2","key":"2020110613061835900_ocy172-B18","doi-asserted-by":"crossref","first-page":"407","DOI":"10.1093\/jamia\/ocv088","article-title":"Community vital signs\u201d: incorporating geocoded social determinants into electronic records to promote patient and population health","volume":"23","author":"Bazemore","year":"2016","journal-title":"J Am Med Inform Assoc"},{"key":"2020110613061835900_ocy172-B19","article-title":"Decentralized and reproducible geocoding and characterization of community and environmental exposures for multisite studies","author":"Brokamp","year":"2017","journal-title":"J Am Med Inform Assoc"},{"issue":"4","key":"2020110613061835900_ocy172-B20","doi-asserted-by":"crossref","first-page":"637","DOI":"10.1136\/amiajnl-2014-002756","article-title":"The Greater Plains Collaborative: a PCORnet clinical research data network","volume":"21","author":"Waitman","year":"2014","journal-title":"J Am Med Inform Assoc"},{"issue":"4","key":"2020110613061835900_ocy172-B21","doi-asserted-by":"crossref","first-page":"576","DOI":"10.1136\/amiajnl-2014-002864","article-title":"PCORnet: turning a dream into reality","volume":"21","author":"Collins","year":"2014","journal-title":"J Am Med Inform Assoc"},{"issue":"4","key":"2020110613061835900_ocy172-B22","doi-asserted-by":"crossref","first-page":"578","DOI":"10.1136\/amiajnl-2014-002747","article-title":"Launching PCORnet, a national patient-centered clinical research network","volume":"21","author":"Fleurence","year":"2014","journal-title":"J Am Med Inform Assoc"},{"issue":"1","key":"2020110613061835900_ocy172-B23","doi-asserted-by":"crossref","first-page":"7","DOI":"10.1016\/j.sste.2012.02.002","article-title":"A research agenda: does geocoding positional error matter in health GIS studies?","volume":"3","author":"Jacquez","year":"2012","journal-title":"Spat Spatiotemporal Epidemiol"},{"issue":"3","key":"2020110613061835900_ocy172-B24","doi-asserted-by":"crossref","first-page":"214","DOI":"10.1016\/j.compenvurbsys.2007.11.006","article-title":"A comparison of address point, parcel and street geocoding techniques","volume":"32","author":"Zandbergen","year":"2008","journal-title":"Comput Environ Urban Syst"},{"key":"2020110613061835900_ocy172-B25","first-page":"e160","article-title":"Who hits the mark? A comparative study of the free geocoding services of google and openstreetmap","volume":"77","author":"Lemke","year":"2015","journal-title":"Gesundheitswesen"},{"issue":"9","key":"2020110613061835900_ocy172-B26","doi-asserted-by":"crossref","first-page":"1054","DOI":"10.1289\/ehp.1206016","article-title":"Impact of geocoding methods on associations between long-term exposure to urban air pollution and lung function","volume":"121","author":"Jacquemin","year":"2013","journal-title":"Environ Health Perspect"},{"issue":"6","key":"2020110613061835900_ocy172-B27","doi-asserted-by":"crossref","first-page":"664","DOI":"10.1001\/jama.2010.1112","article-title":"Trends and characteristics of US emergency department visits, 1997-2007","volume":"304","author":"Tang","year":"2010","journal-title":"JAMA"},{"issue":"5","key":"2020110613061835900_ocy172-B28","doi-asserted-by":"crossref","first-page":"624","DOI":"10.1197\/jamia.M3191","article-title":"The Shared Health Research Information Network (SHRINE): a prototype federated query tool for clinical data repositories","volume":"16","author":"Weber","year":"2009","journal-title":"J Am Med Inform Assoc"},{"key":"2020110613061835900_ocy172-B29","year":":\/\/..\/\/\/\/2016-----508."},{"issue":"2","key":"2020110613061835900_ocy172-B30","doi-asserted-by":"crossref","first-page":"124","DOI":"10.1136\/jamia.2009.000893","article-title":"Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2)","volume":"17","author":"Murphy","year":"2010","journal-title":"J Am Med Inform Assoc"},{"key":"2020110613061835900_ocy172-B31","first-page":"34","article-title":"PostGIS","volume":"3","author":"Holl","year":"2009","journal-title":"GeoInformatics"},{"key":"2020110613061835900_ocy172-B32","author":"Hart"},{"key":"2020110613061835900_ocy172-B33","author":"Cromartie"},{"issue":"6","key":"2020110613061835900_ocy172-B34","doi-asserted-by":"crossref","first-page":"1041","DOI":"10.1007\/s11524-006-9094-x","article-title":"The development of a standardized neighborhood deprivation index","volume":"83","author":"Messer","year":"2006","journal-title":"J Urban Health"},{"issue":"3","key":"2020110613061835900_ocy172-B35","doi-asserted-by":"crossref","first-page":"186","DOI":"10.1136\/jech.57.3.186","article-title":"Choosing area based socioeconomic measures to monitor social inequalities in low birth weight and childhood lead poisoning: the Public Health Disparities Geocoding Project (US)","volume":"57","author":"Krieger","year":"2003","journal-title":"J Epidemiol Community Health"},{"issue":"1","key":"2020110613061835900_ocy172-B36","doi-asserted-by":"crossref","first-page":"10.","DOI":"10.1186\/1476-072X-2-10","article-title":"Positional error in automated geocoding of residential addresses","volume":"2","author":"Cayo","year":"2003","journal-title":"Int J Health Geogr"},{"key":"2020110613061835900_ocy172-B37","volume-title":"Geocoding Health Data: The Use of Geographic Codes in Cancer Prevention and Control, Research and Practice","author":"Zimmerman","year":"2007"},{"issue":"2","key":"2020110613061835900_ocy172-B38","doi-asserted-by":"crossref","first-page":"173","DOI":"10.1016\/S1353-8292(99)00004-0","article-title":"Subject loss in spatial analysis of breast cancer","volume":"5","author":"Gregorio","year":"1999","journal-title":"Health Place"},{"issue":"1","key":"2020110613061835900_ocy172-B39","doi-asserted-by":"crossref","first-page":"29.","DOI":"10.1186\/1476-072X-4-29","article-title":"Geographic bias related to geocoding in epidemiologic studies","volume":"4","author":"Oliver","year":"2005","journal-title":"Int J Health Geogr"},{"issue":"7","key":"2020110613061835900_ocy172-B40","doi-asserted-by":"crossref","first-page":"1114","DOI":"10.2105\/AJPH.91.7.1114","article-title":"On the wrong side of the tracts? Evaluating the accuracy of geocoding in public health research","volume":"91","author":"Krieger","year":"2001","journal-title":"Am J Public Health"},{"issue":"4","key":"2020110613061835900_ocy172-B41","doi-asserted-by":"crossref","first-page":"329\u201334.","DOI":"10.1038\/sj.jea.7500173","article-title":"Locational uncertainty in georeferencing public health datasets","volume":"11","author":"Dearwent","year":"2001","journal-title":"J Expo Sci Environ Epidemiol"},{"issue":"4","key":"2020110613061835900_ocy172-B42","doi-asserted-by":"crossref","first-page":"408","DOI":"10.1097\/01.EDE.0000073121.63254.c5","article-title":"Positional accuracy of geocoded addresses in epidemiologic research","volume":"14","author":"Bonner","year":"2003","journal-title":"Epidemiology"},{"issue":"1","key":"2020110613061835900_ocy172-B43","doi-asserted-by":"crossref","first-page":"293","DOI":"10.1016\/j.healthplace.2005.08.006","article-title":"The accuracy of address coding and the effects of coding errors","volume":"13","author":"Kravets","year":"2007","journal-title":"Health Place"},{"issue":"6","key":"2020110613061835900_ocy172-B44","doi-asserted-by":"crossref","first-page":"1883","DOI":"10.1093\/ajcn\/87.6.1883","article-title":"Neighborhood socioeconomic status and fruit and vegetable intake among whites, blacks, and Mexican Americans in the United States","volume":"87","author":"Dubowitz","year":"2008","journal-title":"Am J Clin Nutr"},{"key":"2020110613061835900_ocy172-B45","first-page":"1238","article-title":"Introduction of an area deprivation index measuring patient socioeconomic status in an integrated health system: implications for population health","volume":"4","author":"Knighton","year":"2016","journal-title":"EGEMS (Wash DC)"},{"issue":"1","key":"2020110613061835900_ocy172-B46","doi-asserted-by":"crossref","first-page":"62","DOI":"10.1089\/heq.2017.0005","article-title":"Is a patient\u2019s current address of record a reasonable measure of neighborhood deprivation exposure? A case for the use of point in time measures of residence in clinical care","volume":"2","author":"Knighton","year":"2018","journal-title":"Health Equity"},{"key":"2020110613061835900_ocy172-B47","doi-asserted-by":"crossref","first-page":"381","DOI":"10.1146\/annurev-publhealth-031210-101218","article-title":"The social determinants of health: coming of age","volume":"32","author":"Braveman","year":"2011","journal-title":"Annu Rev Public Health"},{"issue":"3","key":"2020110613061835900_ocy172-B48","doi-asserted-by":"crossref","first-page":"e55811","DOI":"10.1371\/journal.pone.0055811","article-title":"SHRINE: enabling nationally scalable multi-site disease studies","volume":"8","author":"McMurry","year":"2013","journal-title":"PLoS One"},{"key":"2020110613061835900_ocy172-B49"},{"issue":"7","key":"2020110613061835900_ocy172-B50","doi-asserted-by":"crossref","first-page":"1137","DOI":"10.2105\/AJPH.93.7.1137","article-title":"Area deprivation and widening inequalities in US mortality, 1969-1998","volume":"93","author":"Singh","year":"2003","journal-title":"Am J Public Health"},{"issue":"2 Pt 1","key":"2020110613061835900_ocy172-B51","doi-asserted-by":"crossref","first-page":"539","DOI":"10.1111\/j.1475-6773.2012.01449.x","article-title":"Measures of social deprivation that predict health care access and need within a rational area of primary care service delivery","volume":"48","author":"Butler","year":"2013","journal-title":"Health Serv Res"}],"container-title":["Journal of the American Medical Informatics Association"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/26\/4\/286\/34151347\/ocy172.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/26\/4\/286\/34151347\/ocy172.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,11,6]],"date-time":"2020-11-06T19:06:59Z","timestamp":1604689619000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/jamia\/article\/26\/4\/286\/5304768"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,1,31]]},"references-count":51,"journal-issue":{"issue":"4","published-online":{"date-parts":[[2019,1,31]]},"published-print":{"date-parts":[[2019,4,1]]}},"URL":"https:\/\/doi.org\/10.1093\/jamia\/ocy172","relation":{},"ISSN":["1527-974X"],"issn-type":[{"value":"1527-974X","type":"electronic"}],"subject":[],"published-other":{"date-parts":[[2019,4]]},"published":{"date-parts":[[2019,1,31]]}}}