Skip to main content
Open Access Publications from the University of California


UC San Francisco Previously Published Works bannerUCSF

PatientExploreR: an extensible application for dynamic visualization of patient clinical history from electronic health records in the OMOP common data model.

  • Author(s): Glicksberg, Benjamin S
  • Oskotsky, Boris
  • Thangaraj, Phyllis M
  • Giangreco, Nicholas
  • Badgeley, Marcus A
  • Johnson, Kipp W
  • Datta, Debajyoti
  • Rudrapatna, Vivek A
  • Rappoport, Nadav
  • Shervey, Mark M
  • Miotto, Riccardo
  • Goldstein, Theodore C
  • Rutenberg, Eugenia
  • Frazier, Remi
  • Lee, Nelson
  • Israni, Sharat
  • Larsen, Rick
  • Percha, Bethany
  • Li, Li
  • Dudley, Joel T
  • Tatonetti, Nicholas P
  • Butte, Atul J
  • et al.


Electronic health records (EHRs) are quickly becoming omnipresent in healthcare, but interoperability issues and technical demands limit their use for biomedical and clinical research. Interactive and flexible software that interfaces directly with EHR data structured around a common data model (CDM) could accelerate more EHR-based research by making the data more accessible to researchers who lack computational expertise and/or domain knowledge.


We present PatientExploreR, an extensible application built on the R/Shiny framework that interfaces with a relational database of EHR data in the Observational Medical Outcomes Partnership CDM format. PatientExploreR produces patient-level interactive and dynamic reports and facilitates visualization of clinical data without any programming required. It allows researchers to easily construct and export patient cohorts from the EHR for analysis with other software. This application could enable easier exploration of patient-level data for physicians and researchers. PatientExploreR can incorporate EHR data from any institution that employs the CDM for users with approved access. The software code is free and open source under the MIT license, enabling institutions to install and users to expand and modify the application for their own purposes.

Availability and implementation

PatientExploreR can be freely obtained from GitHub: We provide instructions for how researchers with approved access to their institutional EHR can use this package. We also release an open sandbox server of synthesized patient data for users without EHR access to explore:

Supplementary information

Supplementary data are available at Bioinformatics online.

Many UC-authored scholarly publications are freely available on this site because of the UC's open access policies. Let us know how this access is important for you.

Main Content
Current View