Electronic Health Record Data

Observational Medical Outcomes Partnership (OMOP) Common Data Model

​Due to the disparity in available data sets in healthcare, the open-community Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM), maintained by the Observational Health Data Sciences and Informatics (OHDSI) program, emerged as a pillar for healthcare research. As a standardization model, OMOP provides a harmonized data set that allows large-scale analytics across different organizations.  ​ 

​The OMOP CDM contains 37 tables with approximately 394 fields, ranging from clinical data to health economics. You can find more details on the specifics of the data model and support by following this website: Data Standardization – OHDSI ​ 

​While OMOP as a standard brings incredible analytical power, each implementation has a slight variation in the available fields. For more information, please submit a feasibility request to verify if our implementation fits your data requirements.  

This is a selection of tables and commonly used fields and is not all inclusive of available data to request. 

Table NameDescriptionExample Fields
PersonPatient identifiers: highest sensitivity — directly identifies individuals and links all records year of birth, month of birth, day of birth, birth datetime, gender source value, race source value, ethnicity source value, person source value 
LocationPatient geographic data; enables re-identification by address, zip, and coordinates address 1, address 2, city, state, zip, county, country, latitude, longitude, source file name
NoteFree-text clinical notes; highest unstructured risk — may contain names, diagnoses, social history, and other identifiers in narrative form note text, note title, note date, note datetime
DeathPatient mortality records; sensitive for outcomes research and family notification contextsdeath date, death datetime, cause source value, source file name
Condition OccurrenceDiagnosed conditions per patient; reveals sensitive health status including mental health, chronic illness, and stigmatized diagnosescondition concept id, condition start date, condition end date, condition type concept id, condition source value
Drug ExposureMedication and substance records per patient; can reveal sensitive conditions through prescribed drugs (e.g. HIV, psychiatric, oncology)drug concept id, drug exposure start date, drug exposure end date, drug type concept id, quantity, sig, route source value