Harmonization and integration of data from prospective cohort studies across the Region of the Americas
Authors:
Open Access
- 27 May 2025
- journal article
- Published by Pan American Health Organization in Revista Panamericana de Salud Pública
- Vol. 49, e54
Abstract
Objectives. To develop a generalizable extraction, transform, and load (ETL) process and workflow for prospective harmonization of data from active cohort studies being conducted in different geographic locations across the Region of the Americas. Methods. This study harmonized and merged data from two active prospective cohort studies, the Living in Full Health (LIFE) project in Jamaica and the Cancer Prevention Project of Philadelphia (CAP3) in the United States. The RedCAP data collection platform was leveraged in harmonizing and pooling baseline prospective cohort data that was collected from June 2019 to December 2024. Results. The merged data from this harmonization methodology displayed good coverage on the mapped variables. Seventeen of 23 (74%) of the questionnaire forms harmonized greater than 50% of the variables. Statistical tests on the age-adjusted prevalence of health conditions demonstrated regional differences that could be used to investigate disease hypotheses in the Black Diaspora. Conclusion. This study developed a successful data harmonization process that can guide similar projects. Active data harmonization is a useful strategy that can reduce costs and leverage resources required to conduct multi-site cohort studies, while fostering data sharing and collaborative research across the Region of the Americas.Keywords
This publication has 18 references indexed in Scilit:
- Data harmonization and federated learning for multi-cohort dementia research using the OMOP common data model: A Netherlands consortium of dementia cohorts case studyJournal of Biomedical Informatics, 2024
- A General Primer for Data HarmonizationScientific Data, 2024
- Life course of retrospective harmonization initiatives: key elements to considerJournal of Developmental Origins of Health and Disease, 2022
- Cohort StudiesChest, 2020
- The Cancer Prevention Project of Philadelphia: preliminary findings examining diversity among the African diasporaEthnicity & Health, 2018
- Maelstrom Research guidelines for rigorous retrospective data harmonizationInternational Journal of Epidemiology, 2016
- Toward Rigorous Data Harmonization in Cancer Epidemiology Research: One ApproachAmerican Journal of Epidemiology, 2015
- Invited Commentary: Consolidating Data Harmonization--How to Obtain Quality and Applicability?American Journal of Epidemiology, 2011
- Thinking big: large-scale collaborative research in observational epidemiologyEuropean Journal of Epidemiology, 2009
- Research electronic data capture (REDCap)—A metadata-driven methodology and workflow process for providing translational research informatics supportJournal of Biomedical Informatics, 2009