{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,8,17]],"date-time":"2026-08-17T23:24:15Z","timestamp":1787009055635,"version":"build-2736575974"},"reference-count":31,"publisher":"Oxford University Press (OUP)","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2016,5,1]]},"abstract":"<jats:p>Objective Electronic medical records (EMRs) are being increasingly utilized to conduct clinical and epidemiologic research in numerous fields. To monitor and improve care of HIV-infected patients in Washington, DC, one of the most severely affected urban areas in the United States, we developed a city-wide database across 13 clinical sites using electronic data abstraction and manual data entry from EMRs.<\/jats:p>\n                  <jats:p>Materials and Methods To develop this unique longitudinal cohort, a web-based electronic data capture system (Discovere\u00ae) was used. An Agile software development methodology was implemented across multiple EMR platforms. Clinical informatics staff worked with information technology specialists from each site to abstract data electronically from each respective site\u2019s EMR through an extract, transform, and load process.<\/jats:p>\n                  <jats:p>Results Since enrollment began in 2011, more than 7000 patients have been enrolled, with longitudinal clinical data available on all patients. Data sets are produced for scientific analyses on a quarterly basis, and benchmarking reports are generated semi-annually enabling each site to compare their participants\u2019 clinical status, treatments, and outcomes to the aggregated summaries from all other sites.<\/jats:p>\n                  <jats:p>Discussion Numerous technical challenges were identified and innovative solutions developed to ensure the successful implementation of the DC Cohort. Central to the success of this project was the broad collaboration established between government, academia, clinics, community, information technology staff, and the patients themselves.<\/jats:p>\n                  <jats:p>Conclusions Our experiences may have practical implications for researchers who seek to merge data from diverse clinical databases, and are applicable to the study of health-related issues beyond HIV.<\/jats:p>","DOI":"10.1093\/jamia\/ocv176","type":"journal-article","created":{"date-parts":[[2015,12,31]],"date-time":"2015-12-31T22:23:55Z","timestamp":1451600635000},"page":"635-643","source":"Crossref","is-referenced-by-count":78,"title":["Development of a large urban longitudinal HIV clinical cohort using a web-based platform to merge electronically and manually abstracted data from disparate medical record systems: technical challenges and innovative solutions"],"prefix":"10.1093","volume":"23","author":[{"given":"Alan E","family":"Greenberg","sequence":"first","affiliation":[{"name":"Department of Epidemiology and Biostatistics, Milken Institute School of Public Health, The George Washington University, Washington, DC, USA."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Harlen","family":"Hays","sequence":"additional","affiliation":[{"name":"Cerner Corporation, Kansas City, Missouri, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Amanda D","family":"Castel","sequence":"additional","affiliation":[{"name":"Department of Epidemiology and Biostatistics, Milken Institute School of Public Health, The George Washington University, Washington, DC, USA."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Thilakavathy","family":"Subramanian","sequence":"additional","affiliation":[{"name":"Cerner Corporation, Kansas City, Missouri, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Lindsey Powers","family":"Happ","sequence":"additional","affiliation":[{"name":"Department of Epidemiology and Biostatistics, Milken Institute School of Public Health, The George Washington University, Washington, DC, USA."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Maria","family":"Jaurretche","sequence":"additional","affiliation":[{"name":"Department of Epidemiology and Biostatistics, Milken Institute School of Public Health, The George Washington University, Washington, DC, USA."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jeff","family":"Binkley","sequence":"additional","affiliation":[{"name":"Cerner Corporation, Kansas City, Missouri, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mariah M","family":"Kalmin","sequence":"additional","affiliation":[{"name":"Department of Epidemiology and Biostatistics, Milken Institute School of Public Health, The George Washington University, Washington, DC, USA."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Kathy","family":"Wood","sequence":"additional","affiliation":[{"name":"Cerner Corporation, Kansas City, Missouri, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rachel","family":"Hart","sequence":"additional","affiliation":[{"name":"Cerner Corporation, Kansas City, Missouri, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"name":"on behalf of the DC Cohort Executive Committee","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"286","published-online":{"date-parts":[[2015,12,31]]},"reference":[{"issue":"1","key":"2020110613021840300_ocv176-B1","doi-asserted-by":"crossref","first-page":"103","DOI":"10.1002\/cncr.28395","article-title":"Breast cancer treatment across health care systems: Linking electronic medical records and state registry data to enable outcomes research","volume":"120","author":"Kurian","year":"2014","journal-title":"Cancer."},{"issue":"2","key":"2020110613021840300_ocv176-B2","doi-asserted-by":"crossref","first-page":"59","DOI":"10.12954\/PI.12015","article-title":"Development of prostate cancer research database with the clinical data warehouse technology for direct linkage with electronic medical record system","volume":"1","author":"Choi","year":"2013","journal-title":"Prostate Int."},{"issue":"2","key":"2020110613021840300_ocv176-B3","doi-asserted-by":"crossref","first-page":"466","DOI":"10.1016\/j.jss.2013.10.036","article-title":"Electronic medical record: research tool for pancreatic cancer?","volume":"187","author":"Arous","year":"2014","journal-title":"J Surg Res"},{"key":"2020110613021840300_ocv176-B4","article-title":"Secondary use of EHR: data quality issues and informatics opportunities","author":"Botsis","year":"2010","journal-title":"AMIA Joint Summits on Translational Science proceedings AMIA Summit on Translational Science."},{"issue":"1","key":"2020110613021840300_ocv176-B5","first-page":"259","article-title":"Use of electronic medical records (EMR) for oncology outcomes research: assessing the comparability of EMR information to patient registry and health claims data","volume":"3","author":"Lau","year":"2011","journal-title":"Clin Epidemiol."},{"issue":"6","key":"2020110613021840300_ocv176-B6","doi-asserted-by":"crossref","first-page":"1625","DOI":"10.1093\/ije\/dys188","article-title":"Data resource profile: Cardiovascular disease research using linked bespoke studies and electronic health records (CALIBER)","volume":"41","author":"Denaxas","year":"2012","journal-title":"Int J Epidemiol."},{"key":"2020110613021840300_ocv176-B7","doi-asserted-by":"crossref","first-page":"37","DOI":"10.1159\/000345179","article-title":"The MONitoring dialysis outcomes (MONDO) initiative","volume":"35","author":"Usvyat","year":"2013","journal-title":"Blood Purif."},{"issue":"1","key":"2020110613021840300_ocv176-B8","doi-asserted-by":"crossref","first-page":"13","DOI":"10.1186\/1755-8794-4-13","article-title":"The eMERGE network: a consortium of biorepositories linked to electronic medical records data for conducting genomic studies","volume":"4","author":"McCarty","year":"2011","journal-title":"BMC Medical Genomics."},{"issue":"2","key":"2020110613021840300_ocv176-B9","first-page":"26","article-title":"Implementing and maintaining a researchable database from electronic medical records: a perspective from an academic family medicine department","volume":"5","author":"Stewart","year":"2009","journal-title":"Health Policy."},{"issue":"5","key":"2020110613021840300_ocv176-B10","doi-asserted-by":"crossref","first-page":"719","DOI":"10.1016\/j.jpeds.2012.01.039","article-title":"Comparative effectiveness research using the electronic medical record: An emerging area of investigation in pediatric primary care","volume":"160","author":"Fiks","year":"2012","journal-title":"J Pediatr."},{"issue":"3","key":"2020110613021840300_ocv176-B11","first-page":"448","article-title":"Implementation of an innovative, integrated electronic medical record (EMR) and public health information exchange for HIV\/AIDS","volume":"19","author":"Herwehe","year":"2012","journal-title":"JAMIA."},{"issue":"6","key":"2020110613021840300_ocv176-B12","doi-asserted-by":"crossref","first-page":"611","DOI":"10.1177\/1077558709332440","article-title":"Review: use of electronic medical records for health outcomes research: a literature review","volume":"66","author":"Dean","year":"2009","journal-title":"Med Care Res Rev."},{"issue":"4","key":"2020110613021840300_ocv176-B13","doi-asserted-by":"crossref","first-page":"280","DOI":"10.1016\/j.acap.2011.02.007","article-title":"Electronic medical records (EMRs), epidemiology, and epistemology: reflections on EMRs and future pediatric clinical research","volume":"11","author":"Wasserman","year":"2011","journal-title":"Academic Pediatrics."},{"issue":"1","key":"2020110613021840300_ocv176-B14","doi-asserted-by":"crossref","first-page":"121","DOI":"10.1093\/fampra\/cmp068","article-title":"Using your electronic medical record for research: a primer for avoiding pitfalls","volume":"27","author":"Terry","year":"2010","journal-title":"Fam Pract."},{"issue":"2","key":"2020110613021840300_ocv176-B15","doi-asserted-by":"crossref","first-page":"310","DOI":"10.1093\/aje\/126.2.310","article-title":"The multicenter AIDS cohort study: rationale, organization, and selected characteristics of the participants","volume":"126","author":"Kaslow","year":"1987","journal-title":"Am J Epidemiol."},{"issue":"2","key":"2020110613021840300_ocv176-B16","doi-asserted-by":"crossref","first-page":"117","DOI":"10.1097\/00001648-199803000-00004","article-title":"The women's interagency HIV study","volume":"9","author":"Barkan","year":"1998","journal-title":"Epidemiology."},{"issue":"8","key":"2020110613021840300_ocv176-B17","doi-asserted-by":"crossref","first-page":"S13","DOI":"10.1097\/01.mlr.0000223741.02074.66","article-title":"Veterans aging cohort study (VACS): overview and description","volume":"44","author":"Justice","year":"2006","journal-title":"Med Care."},{"issue":"5","key":"2020110613021840300_ocv176-B18","doi-asserted-by":"crossref","first-page":"471","DOI":"10.1097\/00126334-200208150-00002","article-title":"Do protease inhibitors increase the risk for coronary heart disease in patients with HIV-1 infection?","volume":"30","author":"Klein","year":"2002","journal-title":"J Acquired Immune Defic Syndromes"},{"issue":"5","key":"2020110613021840300_ocv176-B19","doi-asserted-by":"crossref","first-page":"948","DOI":"10.1093\/ije\/dym231","article-title":"Cohort profile: the centers for AIDS research network of integrated clinical systems","volume":"37","author":"Kitahata","year":"2008","journal-title":"Int J Epidemiol."},{"issue":"4","key":"2020110613021840300_ocv176-B20","doi-asserted-by":"crossref","first-page":"269","DOI":"10.1310\/hct0904-269","article-title":"AIDS clinical trials group longitudinal linked randomized trials (ALLRT): Rationale, design, and baseline characteristics","volume":"9","author":"Smurzynski","year":"2008","journal-title":"HIV Clinical Trials."},{"issue":"6","key":"2020110613021840300_ocv176-B21","doi-asserted-by":"crossref","first-page":"349","DOI":"10.1016\/S1047-2797(99)00005-8","article-title":"Changing conditions and treatments in a dynamic cohort of ambulatory HIV patients","volume":"9","author":"Moorman","year":"1999","journal-title":"Ann Epidemiol."},{"issue":"2","key":"2020110613021840300_ocv176-B22","doi-asserted-by":"crossref","first-page":"294","DOI":"10.1093\/ije\/dyl286","article-title":"Cohort profile: the North American AIDS cohort collaboration on research and design (NA-ACCORD)","volume":"36","author":"Gange","year":"2007","journal-title":"Int J Epidemiol."},{"key":"2020110613021840300_ocv176-B23"},{"key":"2020110613021840300_ocv176-B24"},{"issue":"2","key":"2020110613021840300_ocv176-B25","doi-asserted-by":"crossref","first-page":"217","DOI":"10.1111\/j.1553-2712.2011.01275.x","article-title":"Electronic versus manual data processing: evaluating the use of electronic health records in out-of-hospital clinical research","volume":"19","author":"Newgard","year":"2012","journal-title":"Acad Emerg Med."},{"key":"2020110613021840300_ocv176-B26","article-title":"EHR and EDC integration in reality","author":"Zahlmann","year":"2009","journal-title":"Appl Clin Trials Online"},{"key":"2020110613021840300_ocv176-B27"},{"key":"2020110613021840300_ocv176-B28","doi-asserted-by":"crossref","first-page":"f288","DOI":"10.1136\/bmj.f288","article-title":"QT interval and antidepressant use: a cross sectional study of electronic health records","volume":"346","author":"Castro Victor","year":"2013","journal-title":"BMJ."},{"key":"2020110613021840300_ocv176-B29","author":"Castel"},{"key":"2020110613021840300_ocv176-B30","author":"Castel"},{"key":"2020110613021840300_ocv176-B31","author":"Castel"}],"container-title":["Journal of the American Medical Informatics Association"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/23\/3\/635\/34148192\/ocv176.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/23\/3\/635\/34148192\/ocv176.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,11,6]],"date-time":"2020-11-06T13:54:00Z","timestamp":1604670840000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/jamia\/article\/23\/3\/635\/2909008"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015,12,31]]},"references-count":31,"journal-issue":{"issue":"3","published-online":{"date-parts":[[2015,12,31]]},"published-print":{"date-parts":[[2016,5,1]]}},"URL":"https:\/\/doi.org\/10.1093\/jamia\/ocv176","relation":{},"ISSN":["1067-5027","1527-974X"],"issn-type":[{"value":"1067-5027","type":"print"},{"value":"1527-974X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2015,12,31]]}}}