{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,27]],"date-time":"2026-07-27T21:00:55Z","timestamp":1785186055430,"version":"3.55.0"},"reference-count":42,"publisher":"JMIR Publications Inc.","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["JMIR Form Res"],"abstract":"<jats:p>The HIV epidemic remains a national priority in the United States, and the Ending the HIV Epidemic initiative has renewed the call for expanded prevention and treatment strategies capable of reducing new HIV infections by 90% by 2030. Achieving this goal requires robust, integrated data for understanding HIV-related needs, barriers to care, and the effectiveness of interventions. However, despite the existence of numerous publicly available datasets, few integrate multiple domains such as HIV outcomes, social determinants of health, and community-level factors. The lack of unified data and difficulty linking datasets hampers efforts for meaningful cross-domain analyses to tailor HIV management and treatment strategies. The resulting fragmentation constitutes a methodological gap: implementation teams lack replicable guidance for constructing unified HIV and contextual databases from public sources. In this viewpoint, we describe our experience building a unified compilation of publicly available HIV and community data to identify factors influencing HIV outcomes and interventions. The completed database comprises 242 variables drawn from 8 public sources mapped across clinic, zip code, county, and state levels of geography. Rather than simply reporting what we built, we position four core decisions as transferable methodological advances: (1) treating source identification as a bounded phase before construction begins, (2) adopting automated data engineering tools from the outset rather than manual entry, (3) establishing a shared data dictionary before the first variable is entered, and (4) integrating quality control throughout the workflow rather than as a final phase. The build required approximately 350 total project hours and revealed an initial spot-check error rate of approximately 33%, which we attribute primarily to manual data entry. By sharing the approach used to develop this database and making the final resource publicly accessible through the Yale Center for Methods in Implementation and Prevention Science, we aim to reduce barriers to data access and encourage similar data integration efforts. The methodological framework described in this paper is intentionally designed to be replicable with modest resources, and we present it as a practical model for research teams operating without specialized infrastructure. Consolidating HIV, social determinants of health, and contextual variables into a unified data source is a critical step toward enabling deeper, more comprehensive analysis and supporting ongoing efforts to end the HIV epidemic in the US.<\/jats:p>","DOI":"10.2196\/72088","type":"journal-article","created":{"date-parts":[[2026,5,15]],"date-time":"2026-05-15T00:15:07Z","timestamp":1778804107000},"page":"e72088","source":"Crossref","is-referenced-by-count":0,"title":["Lessons From Building a Large, Public HIV-Related Database in Support of the Ending the HIV Epidemic in the US Initiative"],"prefix":"10.2196","volume":"10","author":[{"ORCID":"https:\/\/orcid.org\/0009-0001-9079-4697","authenticated-orcid":false,"given":"Victor","family":"Wang","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0369-3650","authenticated-orcid":false,"given":"Nikita","family":"Rao","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6090-2880","authenticated-orcid":false,"given":"Sheree R","family":"Schwartz","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-7289-8698","authenticated-orcid":false,"given":"Sten H","family":"Vermund","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8623-4881","authenticated-orcid":false,"given":"Lien","family":"Quach","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2275-0753","authenticated-orcid":false,"given":"Rafael","family":"Perello Carbonell","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6350-1908","authenticated-orcid":false,"given":"Artur","family":"Queiroz","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3957-8339","authenticated-orcid":false,"given":"Kush","family":"Shanker","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-7924-7430","authenticated-orcid":false,"given":"Sung-Jae","family":"Lee","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-5882-0907","authenticated-orcid":false,"given":"Joyce L","family":"Jones","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-5979-3717","authenticated-orcid":false,"given":"Debbie","family":"Humphries","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4006-4650","authenticated-orcid":false,"given":"Donna","family":"Spiegelman","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1010","published-online":{"date-parts":[[2026,7,27]]},"reference":[{"key":"ref1","unstructured":"About ending the HIV epidemic in the USCenters for Disease Control and Prevention2023-06-11https:\/\/www.cdc.gov\/ehe\/php\/about\/?CDC_AAref_Val=https:\/\/www.cdc.gov\/endhiv\/about.html"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1001\/jama.2019.1343"},{"key":"ref3","doi-asserted-by":"publisher","DOI":"10.1016\/S0140-6736(21)00395-0"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1093\/cid\/cit420"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pone.0017502"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.1001\/archinte.168.11.1181"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1097\/QAI.0b013e3181684c51"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1007\/s12325-020-01295-0"},{"key":"ref9","doi-asserted-by":"publisher","DOI":"10.1016\/S0140-6736(15)00321-9"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1097\/QAI.0000000000003632"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1097\/QAI.0000000000003627"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1097\/QAI.0000000000003619"},{"key":"ref13","unstructured":"Data reports and slide decksHealth Resources & Services Administration2026-05-22https:\/\/ryanwhite.hrsa.gov\/data\/reports"},{"key":"ref14","unstructured":"ArcGIS Living Atlas of the World2026-05-22https:\/\/livingatlas.arcgis.com\/en\/home\/"},{"key":"ref15","unstructured":"Advancing implementation science, ending the HIV epidemicHIV Implementation Science Coordination Initiative2024-02-06https:\/\/hivimpsci.northwestern.edu\/"},{"key":"ref16","unstructured":"United States Census Bureau2026-06-01https:\/\/data.census.gov\/"},{"key":"ref17","unstructured":"QuickFacts: United StatesUnited States Census Bureau2026-06-01https:\/\/www.census.gov\/quickfacts\/"},{"key":"ref18","unstructured":"Data on HIV\/AIDSKFF2026-06-01https:\/\/www.kff.org\/state-category\/hivaids\/"},{"key":"ref19","unstructured":"Mapping HIV criminalization laws in the U.S., CHLP (2025)CHLP2026-06-01https:\/\/www.hivlawandpolicy.org\/maps"},{"key":"ref20","unstructured":"Understanding the current HIV epidemic in the United StatesAIDSVu2026-06-01https:\/\/map.aidsvu.org\/profiles\/nation\/usa\/overview#\/counties"},{"key":"ref21","unstructured":"County Health Rankings & Roadmaps2026-06-01https:\/\/www.countyhealthrankings.org\/"},{"key":"ref22","unstructured":"AtlasPlus - overviewCenters for Disease Control and Prevention2026-06-01https:\/\/gis.cdc.gov\/grasp\/nchhstpatlas\/main.html"},{"key":"ref23","unstructured":"Health Center Program Uniform Data System (UDS) data overviewHRSA2026-06-01https:\/\/data.hrsa.gov\/topics\/healthcenters\/uds\/overview"},{"key":"ref24","unstructured":"Walk Score2026-06-01https:\/\/www.walkscore.com\/"},{"key":"ref25","unstructured":"DatabasesYale School of Public Health2023-07-07https:\/\/ysph.yale.edu\/cmips\/research\/databases\/"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.2196\/21929"},{"key":"ref27","unstructured":"The Trusted Exchange Framework (TEF): principles for trusted exchangeOffice of the National Coordinator for Health Information Technology20222026-06-01https:\/\/healthit.gov\/wp-content\/uploads\/2022\/01\/Trusted_Exchange_Framework_0122.pdf"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.1377\/hlthaff.2024.01010"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.5888\/pcd20.230120"},{"key":"ref30","unstructured":"rvest: easily harvest (Scrape) web pagesThe Comprehensive R Archive Network20252026-05-22https:\/\/cran.r-project.org\/web\/packages\/rvest\/index.html"},{"key":"ref31","doi-asserted-by":"publisher","DOI":"10.25080\/majora-92bf1922-00a"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1097\/QAI.0b013e31827f578a"},{"key":"ref33","doi-asserted-by":"publisher","DOI":"10.1089\/apc.2010.0224"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1097\/QAD.0000000000000797"},{"key":"ref35","doi-asserted-by":"publisher","DOI":"10.1007\/s10461-007-9274-z"},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.2105\/AJPH.2009.170241"},{"key":"ref37","doi-asserted-by":"publisher","DOI":"10.1097\/MD.0000000000003171"},{"key":"ref38","unstructured":"HRPP policy and standard operating procedure manualYale University20252026-06-01https:\/\/research-support.yale.edu\/research-compliance-regulatory-affairs\/human-research-protection-program\/policies-procedures\/hrpp"},{"key":"ref39","doi-asserted-by":"publisher","DOI":"10.1007\/s10900-017-0325-8"},{"key":"ref40","doi-asserted-by":"publisher","DOI":"10.1007\/s10461-023-04150-9"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1007\/s11904-024-00702-3"},{"key":"ref42","unstructured":"DatabasesYale School of Public Health2026-06-01https:\/\/ysph.yale.edu\/cmips\/research\/databases\/"}],"container-title":["JMIR Formative Research"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/formative.jmir.org\/2026\/1\/e72088","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,7,27]],"date-time":"2026-07-27T20:45:09Z","timestamp":1785185109000},"score":1,"resource":{"primary":{"URL":"https:\/\/formative.jmir.org\/2026\/1\/e72088"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,7,27]]},"references-count":42,"URL":"https:\/\/doi.org\/10.2196\/72088","relation":{"has-preprint":[{"id-type":"doi","id":"10.2196\/preprints.72088","asserted-by":"object"}]},"ISSN":["2561-326X"],"issn-type":[{"value":"2561-326X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,7,27]]}}}