{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,9]],"date-time":"2026-03-09T18:41:03Z","timestamp":1773081663771,"version":"3.50.1"},"reference-count":27,"publisher":"Frontiers Media SA","license":[{"start":{"date-parts":[[2025,1,28]],"date-time":"2025-01-28T00:00:00Z","timestamp":1738022400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["frontiersin.org"],"crossmark-restriction":true},"short-container-title":["Front. Digit. Health"],"abstract":"<jats:sec><jats:title>Background<\/jats:title><jats:p>Observational health data are collected in different formats and structures, making it challenging to analyze with common tools. The Observational Medical Outcome Partnership (OMOP) Common Data Model (CDM) is a standardized data model that can harmonize observational health data.<\/jats:p><\/jats:sec><jats:sec><jats:title>Objective<\/jats:title><jats:p>This paper demonstrates the use of the OMOP CDM to harmonize COVID-19 sero-surveillance data from the Nairobi Urban Health and Demographic Surveillance System (HDSS).<\/jats:p><\/jats:sec><jats:sec><jats:title>Methods<\/jats:title><jats:p>In this study, we extracted data from the Nairobi Urban HDSS COVID-19 sero-surveillance database and mapped it to the OMOP CDM. We used open-source Observational Health Data Sciences and Informatics (OHDSI) tools like WhiteRabbit, RabbitInAHat, and USAGI. The steps included data profiling (scanning), mapping the vocabularies using the offline USAGI and online ATHENA, and designing the extract, transform, and load (ETL) process using RabbitInAHat. The ETL process was implemented using Pentaho Data Integration community edition software and structured query language (SQL). The target OMOP CDM can now be used to analyze the prevalence of COVID-19 antibodies in the Nairobi Urban HDSS population.<\/jats:p><\/jats:sec><jats:sec><jats:title>Results<\/jats:title><jats:p>We successfully mapped the Nairobi Urban HDSS COVID-19 sero-surveillance data to the OMOP CDM. The standardized dataset included information on demographics, COVID-19 symptoms, vaccination, and COVID-19 antibody test results.<\/jats:p><\/jats:sec><jats:sec><jats:title>Conclusions<\/jats:title><jats:p>The OMOP CDM is a valuable tool for harmonizing observational health data. Using the OMOP CDM facilitates the sharing and analysis of observational health data, leading to a better understanding of disease conditions and trends and improving evidence-based population health strategies.<\/jats:p><\/jats:sec>","DOI":"10.3389\/fdgth.2025.1423621","type":"journal-article","created":{"date-parts":[[2025,1,28]],"date-time":"2025-01-28T13:52:33Z","timestamp":1738072353000},"update-policy":"https:\/\/doi.org\/10.3389\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["Harmonizing population health data into OMOP common data model: a demonstration using COVID-19 sero-surveillance data from Nairobi Urban Health and Demographic Surveillance System"],"prefix":"10.3389","volume":"7","author":[{"given":"Michael","family":"Ochola","sequence":"first","affiliation":[]},{"given":"Sylvia","family":"Kiwuwa-Muyingo","sequence":"additional","affiliation":[]},{"given":"Tathagata","family":"Bhattacharjee","sequence":"additional","affiliation":[]},{"given":"David","family":"Amadi","sequence":"additional","affiliation":[]},{"given":"Maureen","family":"Ng\u2019etich","sequence":"additional","affiliation":[]},{"given":"Damazo","family":"Kadengye","sequence":"additional","affiliation":[]},{"given":"Henry","family":"Owoko","sequence":"additional","affiliation":[]},{"given":"Boniface","family":"Igumba","sequence":"additional","affiliation":[]},{"given":"Jay","family":"Greenfield","sequence":"additional","affiliation":[]},{"given":"Jim","family":"Todd","sequence":"additional","affiliation":[]},{"given":"Agnes","family":"Kiragga","sequence":"additional","affiliation":[]}],"member":"1965","published-online":{"date-parts":[[2025,1,28]]},"reference":[{"key":"B1","doi-asserted-by":"publisher","first-page":"40","DOI":"10.1016\/j.ijmedinf.2016.03.006","article-title":"Data quality assessment framework to assess electronic medical record data for use in research","volume":"90","author":"Reimer","year":"2016","journal-title":"Int J Med Inform"},{"key":"B2","doi-asserted-by":"publisher","first-page":"156","DOI":"10.1016\/j.healthpol.2013.03.020","article-title":"Assessing quality in cross-country comparisons of health systems and policies: towards a set of generic quality criteria","volume":"112","author":"Cacace","year":"2013","journal-title":"Health Policy"},{"key":"B3","doi-asserted-by":"publisher","first-page":"2","DOI":"10.1016\/j.jbi.2019.103253","article-title":"Facilitating phenotype transfer using a common data model","volume":"96","author":"Hripcsak","year":"2019","journal-title":"J Biomed Inform"},{"key":"B4","volume-title":"Observational Health Data Sciences and Informatics (OHDSI)","year":""},{"key":"B5","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1186\/s12911-017-0532-3","article-title":"Dynamic-ETL: a hybrid approach for health data extraction, transformation and loading","volume":"17","author":"Lynch","year":"2017","journal-title":"Appl Clin Inform"},{"key":"B6","doi-asserted-by":"publisher","first-page":"e057977","DOI":"10.1136\/bmjopen-2021-057977","article-title":"Large-scale evidence generation and evaluation across a network of databases for type 2 diabetes mellitus (LEGEND-T2DM): a protocol for a series of multinational, real-world comparative cardiovascular effectiveness and safety studies","volume":"12","author":"Khera","year":"2022","journal-title":"BMJ Open"},{"key":"B7","volume-title":"The Book of OHDSI","year":""},{"key":"B8","volume-title":"APHRC Online Microdata Library","year":""},{"key":"B9","doi-asserted-by":"publisher","first-page":"6","DOI":"10.1101\/2022.10.10.22280824","article-title":"SARS-CoV-2 seroprevalence and implications for population immunity: evidence from two health and demographic surveillance system sites in Kenya, February\u2013June 2022","author":"Kagucia","year":"2022"},{"key":"B10","doi-asserted-by":"publisher","first-page":"e0000883","DOI":"10.1371\/journal.pgph.0000883","article-title":"SARS-CoV-2 seroprevalence in three Kenyan health and demographic surveillance sites, December 2020\u2013May 2021","volume":"2","author":"Etyang","year":"2022","journal-title":"PLOS Global Public Health"},{"key":"B11","volume-title":"WhiteRabbit for ETL Design","year":""},{"key":"B12","volume-title":"Athena","year":""},{"key":"B13","volume-title":"Usagi","year":""},{"key":"B14","volume-title":"Rabbit in a Hat","year":""},{"key":"B15","volume-title":"OMOP CDM v6.0","year":""},{"key":"B16","volume-title":"OHDSI\/CommonDataModel","year":""},{"key":"B17","doi-asserted-by":"publisher","first-page":"2","DOI":"10.3389\/fpubh.2023.1116682","article-title":"Enabling data sharing and utilization for African population health data using OHDSI tools with an OMOP-common data model","volume":"11","author":"Kiwuwa-Muyingo","year":"2023","journal-title":"Front Public Health"},{"key":"B18","doi-asserted-by":"publisher","first-page":"104002","DOI":"10.1016\/j.jbi.2022.104002","article-title":"Developing an ETL tool for converting the PCORnet CDM into the OMOP CDM to facilitate the COVID-19 data integration","volume":"127","author":"Yu","year":"2022","journal-title":"J Biomed Inform"},{"key":"B19","doi-asserted-by":"publisher","first-page":"2","DOI":"10.1186\/s12911-022-01965-9","article-title":"Leveraging artificial intelligence and data science techniques in harmonizing, sharing, accessing and analyzing SARS-COV-2\/COVID-19 data in Rwanda (LAISDAR project): study design and rationale","volume":"22","author":"Nishimwe","year":"2022","journal-title":"BMC Med Inform Decis Mak"},{"key":"B20","volume-title":"Pentaho Data Integration","year":""},{"key":"B21","volume-title":"OHDSI\/CommonDataModel","year":""},{"key":"B22","volume-title":"Standardized Data: The OMOP Common Data Model","year":""},{"key":"B23","doi-asserted-by":"publisher","first-page":"3","DOI":"10.1186\/s12874-021-01434-3","article-title":"Standardizing registry data to the OMOP common data model: experience from three pulmonary hypertension databases","volume":"21","author":"Biedermann","year":"2021","journal-title":"BMC Med Res Methodol"},{"key":"B24","doi-asserted-by":"publisher","first-page":"6","DOI":"10.3390\/app112411920","article-title":"Using the data quality dashboard to improve the ehden network","volume":"11","author":"Blacketer","year":"2021","journal-title":"Appl Sci"},{"key":"B25","doi-asserted-by":"publisher","first-page":"18","DOI":"10.13063\/2327-9214.1244","article-title":"A harmonized data quality assessment terminology and framework for the secondary use of electronic health record data","volume":"4","author":"Kahn","year":"2017","journal-title":"eGEMs"},{"key":"B26","doi-asserted-by":"publisher","first-page":"288","DOI":"10.1093\/cid\/ciab346","article-title":"Seroprevalence of antibodies to severe acute respiratory syndrome coronavirus 2 among healthcare workers in Kenya","volume":"74","author":"Etyang","year":"2022","journal-title":"Clin Infect Dis"},{"key":"B27","doi-asserted-by":"publisher","first-page":"54","DOI":"10.1055\/s-0037-1617452","article-title":"Towards implementation of OMOP in a German university hospital consortium","volume":"9","author":"Maier","year":"2018","journal-title":"Appl Clin Inform"}],"container-title":["Frontiers in Digital Health"],"original-title":[],"link":[{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdgth.2025.1423621\/full","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,1,30]],"date-time":"2025-01-30T14:30:16Z","timestamp":1738247416000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdgth.2025.1423621\/full"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,1,28]]},"references-count":27,"alternative-id":["10.3389\/fdgth.2025.1423621"],"URL":"https:\/\/doi.org\/10.3389\/fdgth.2025.1423621","relation":{},"ISSN":["2673-253X"],"issn-type":[{"value":"2673-253X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,1,28]]},"article-number":"1423621"}}