Related Experiment Video
Updated: May 28, 2025

Swabbing the Urban Environment - A Pipeline for Sampling and Detection of SARS-CoV-2 From Environmental Reservoirs
Published on: April 9, 2021
Harmonizing population health data into OMOP common data model: a demonstration using COVID-19 sero-surveillance data
Michael Ochola1, Sylvia Kiwuwa-Muyingo1, Tathagata Bhattacharjee2
1Data Science Program, African Population and Health Research Center (APHRC), Nairobi, Kenya.
Background:
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.
Objective:
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).
Methods:
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.
Results:
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.
Conclusions:
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.
More Related Videos
08:48Dynamic Monitoring of Seroconversion using a Multianalyte Immunobead Assay for Covid-19
Published on: February 16, 2022
09:33Visualizing Field Data Collection Procedures of Exposure and Biomarker Assessments for the Household Air Pollution Intervention Network Trial in India
Published on: December 23, 2022
Related Concept Videos
Principles of Disease Surveillance
Statistical Methods for Analyzing Epidemiological Data
Introduction to Epidemiology
Steps in Outbreak Investigation
Analysis of Population Pharmacokinetic Data
Overview of Biostatistics in Health Sciences