i2b2-etl

i2b2-etl imports ontology and patient data from simplified input file schemas into the i2b2 clinical research data warehouse to enable EHR-based research, population health management, and epidemiological analyses.


Key Features:

  • Simplified data loading: Maps simplified input file schemas for ontology and patient data to the i2b2 schema for ingestion.
  • Import and deletion operations: Supports creation and removal of i2b2 concepts, facts, and encounter records.
  • Record-number de-identification: Performs record-number de-identification to remove direct patient identifiers prior to loading.
  • Data validation: Executes validation checks on input data to ensure integrity of imported records.
  • Implementation: Implemented in Python.

Scientific Applications:

  • EHR-based research: Enables loading of electronic health record data into i2b2 for cohort discovery and clinical studies.
  • Population health management: Supports population-management initiatives such as the deployment reported at MassGeneral Brigham.
  • Clinical decision support and epidemiology: Facilitates construction of datasets for clinical decision support systems and epidemiological analyses.

Methodology:

Implemented in Python, i2b2-etl parses simplified input file schemas to generate i2b2 ontology and fact records and applies record-number de-identification and data validation.

Topics

Details

License:
Other
Cost:
Free of charge
Tool Type:
command-line tool
Operating Systems:
Mac, Linux, Windows
Programming Languages:
Python, Shell
Added:
11/7/2022
Last Updated:
11/7/2022

Operations

Data Inputs & Outputs

Publications

Wagholikar KB, Ainsworth L, Zelle D, Chaney K, Mendis M, Klann J, Blood AJ, Miller A, Chulyadyo R, Oates M, Gordon WJ, Aronson SJ, Scirica BM, Murphy SN. I2b2-etl: Python application for importing electronic health data into the informatics for integrating biology and the bedside platform. Bioinformatics. 2022;38(20):4833-4836. doi:10.1093/bioinformatics/btac595. PMID:36053173. PMCID:PMC9563689.

PMID: 36053173
Funding: - MassGeneral Brigham and National Institutes of Health: R00-LM011575, R01-HG009174, R01HL151643

Links