AIR·MS Data Modalities

The AIR·MS platform proudly features the following Mount Sinai and public datasets. Our team is dedicated to continuously expanding our database with additional data modalities, striving to build a comprehensive, multi-modal research resource. To help you get started with the data, we offer Quick Start guides available here.   Available Datasets (PHI = Protected Health Information, De-ID = De-Identified Information):

Public Datasets:

Mount Sinai Data Warehouse (MSDW) OMOP De-Identified (De-ID) and Protected Health Information (PHI)


The MSDW dataset leverages the OMOP Common Data Model. The data is comprised of clinical data extracted from Mount Sinai’s Epic Caboodle database and other ancillary systems. ​​​​​​​We offer both the identified (PHI) and de-identified (De-ID) versions of this data.

We offer both an identifiable and a de-identified version of the MSDW dataset in AIR·MS

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

MSDW OMOP identifiable (PHI) with extended attributes ​​​​​​​Current Status

Schema: CDMPHI
Data snapshot from 09/10/2025
Unique patients: 12,521,239
Table Record Count
ATTRIBUTE_DEFINITION 0
CARE_SITE 108,613
CDC_RACE_ETHNICITY_XTN 967
CDM_SOURCE 1
COHORT 6,100,000
COHORT_DEFINITION 3
CONCEPT 11,357,728
CONCEPT_ANCESTOR 101,072,304
CONCEPT_CLASS 453
CONCEPT_RELATIONSHIP 178,331,994
CONCEPT_SYNONYM 5,190,521
CONDITION_ERA 0
CONDITION_OCCURRENCE 224,124,347
COST 0
DATABASECHANGELOG 64
DATABASECHANGELOGLOCK 1
DEATH 49,797
DEVICE_EXPOSURE 0
DOMAIN 50
DOSE_ERA 0
DRUG_ERA 0
DRUG_EXPOSURE 241,235,148
DRUG_STRENGTH 3,003,619
FACT_RELATIONSHIP 169,049,038
LOCATION 13,822,023
MEASUREMENT 1,963,710,364
METADATA 0
NOTE 251,559,257
NOTE_NLP 0
OBSERVATION 538,781,648
OBSERVATION_PERIOD 12,561,446
PAYER_PLAN_PERIOD 0
PERSON 12,521,239
PROCEDURE_OCCURRENCE 355,906,745
PROVIDER 1,372,277
PROVIDER_ATTRIBUTE_XTN 788,610
RELATIONSHIP 730
SOURCE_TO_CONCEPT_MAP 0
SPECIMEN 0
VISIT_DETAIL 0
VISIT_OCCURRENCE 230,899,469
VOCABULARY 254

Note: Some of the standard OMOP tables contain extension fields (starting with the prefix ‘XTN’) which contain data outside of the OMOP standard data model. Many of these XTN attributes are based on data derived directly from EPIC (i.e. codes used in EPIC rather than the standardized OMOP codes), or attributes not currently contained in the OMOP standard. 

MSDW OMOP de-identified (de-id) ​​​​​​​Current Status

Schema: CDMDEID
Data snapshot from 10/20/2025
Unique patients: 12,008,581
Table Record Count
ATTRIBUTE_DEFINITION 0
CARE_SITE 109,310
CDC_RACE_ETHNICITY_XTN 967
CDM_SOURCE 1
COHORT 3,739,597
COHORT_ATTRIBUTE 0
COHORT_DEFINITION 11
CONCEPT 11,382,893
CONCEPT_ANCESTOR 84,020,373
CONCEPT_CLASS 449
CONCEPT_RELATIONSHIP 175,957,371
CONCEPT_SYNONYM 5,190,383
CONDITION_ERA 0
CONDITION_OCCURRENCE 207,689,269
COST 0
DATABASECHANGELOG 60
DATABASECHANGELOGLOCK 1
DEATH 57,522
DEVICE_EXPOSURE 0
DOMAIN 50
DOSE_ERA 0
DRUG_ERA 0
DRUG_EXPOSURE 223,692,656
DRUG_STRENGTH 2,981,765
FACT_RELATIONSHIP 158,497,299
LOCATION 138,7824
MEASUREMENT 2,018,330,339
METADATA 0
NOTE 216,623,789
NOTE_NLP 0
OBSERVATION 398,593,907
OBSERVATION_PERIOD 12,091,204
OMOP.TRACE 0
PAYER_PLAN_PERIOD 0
PERSON 12,008,581
PROCEDURE_OCCURRENCE 331,740,865
PROVIDER 1,373,456
PROVIDER_ATTRIBUTE_XTN 787,290
RELATIONSHIP 730
SCHEMA.METADATA 0
SLIDE_XTN 2,397,874
SOURCE_TO_CONCEPT_MAP 0
SPECIMEN 0
SURVEY_CONDUCT 0
VISIT_DETAIL 0
VISIT_OCCURRENCE 208,717,628
VOCABULARY 237

 

Pathology Metadata (PHI)

The Pathology metadata aids researchers in the field of Computational Pathology. Researchers are able to query the metadata in combination with other linked data modalities to build a patient cohort, subsequently apply quantitative methods for the analysis of digital microscopy slides and relating the resulting statistical descriptors to patient outcomes. We are also working on making the digital slides available to researchers on Minerva HPC.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

Current Status

Data Source: Powerpath
Schema: CDMPATHOLOGY
Data snapshot from 01/08/2025
Unique patients: 3,528,719

Note: Pathology reports are now available in ​​​​​​​​​​​​​​​​​​​​​AIR·MS and can be found in table ACC_RESULTS. The reports are broken up into sections (clinical history, final diagnosis, SNOMED coding, etc.) that can be identified by column PATH_RPT_HEADING_NAME. If you are looking for the full report, you can combine all records for with the same ACCESSION_2_ID into a single output. The column containing the free-text (ACC_RESULTS_FINDING) has been enabled with SAP HANA full-text search capabilities. Examples of how to use HANA full-text search are available in this tutorial notebook.

The following tables and attributes are available in AIR·MS:

ACCESSION

Number of records: 7,107,464
Column Name Comments
ACC_CATG Case category
ACC_PROCESS_STEP_COMPLETED_DATE Case finalize date / status update datetime
ACCESSION_2_ID PowerPath unique case ID
ACCESSION_NO Case number
BIRTH_DATE Patient date of birth
CREATED_DATE Case creation date
CURRENT_STATUS_ID PowerPath unique identifier for a case status
FACILITY_CODE Facility code
FACILITY_ID PowerPath ID for the facility associated with the accession
FACILITY_NAME Facility name
IMPORTED_CASE One-character \”Y\” or \”N\” code indicating if the case was imported into PowerPath
LAST_UPDATE_DATETIME Case finalize date / status update datetime
MED_REC_NO Medical record number  (EPIC MRN)
MRN_FACILITY_CODE PowerPath ID for the facility that assigned the MRN
MRN_FACILITY_DESCRIPTION Name of the facility that assigned the MRN
ORDER_NUMBER Order number from the ordering system
PATIENT_AGE The patient’s age on the case creation date
PATIENT_ID PowerPath patient ID
PERSONNEL_2_FULL_NAME Name of the pathologist who finalized the accession
PERSONNEL_2_ID PowerPath ID for the pathologist who finalized the accession
PROCESS_STEP_DESCRIPTION Case status name / description
VISIT_NUMBER Encounter identifier

ACC_ICD

Number of records: 3,548,815
Column Name Comments
ACC_ICD9_ID PowerPath surrogate unique identifier for an ICD-10 code assigned to a case
ACCESSION_2_ID PowerPath unique case ID
LAST_UPDATE_DATETIME Case finalize date / status update datetime
MEDICAL_CODE ICD-10 code assigned for billing
MEDICAL_CODE_ID PowerPath surrogate unique identifier for an ICD-10 code

ACC_SLIDE

Number of records: 14,241,494
Column Name Comments
ACC_BLOCK_ID PowerPath unique block ID
ACC_BLOCK_LABEL Specimen block identifier
ACC_PROCESS_STEP_COMPLETED_DATE Case finalize date / status update datetime
ACC_SLIDE_ID PowerPath unique slide ID
ACC_SPECIMEN_DESCRIPTION Specimen source description
ACC_SPECIMEN_ID PowerPath unique specimen ID
ACCESSION_2_ID PowerPath unique case ID
BIOPSY Boolean flag for 1 = biopsy,  0 = non-biopsy
COLLECTION_DATE Specimen collection date
CONSULT_LABEL Optional free text for slides of type \”consult\”
LAB_PROCEDURE_CODE The procedure code
LAB_PROCEDURE_DESCRIPTION The procedure description
LAB_PROCEDURE_ID PowerPath unique procedure identifier
LAST_UPDATE_DATETIME Case finalize date / status update datetime
RECV_DATE Specimen received date
SLIDE_LABEL Derived unique (business key) identifier for each slide
SLIDE_NO Ordinal number of the slide from the specimen & block
SLIDE_TYPE Whether the slide is stained,  unstained  or antibody/IHC
SOURCE_MATERIAL_LABEL Derived unique (business key) identifier for each slide’s source specimen and block
SOURCE_REC_TYPE Where the slide came from, either specimen or block
SPECIMEN_CATEGORY_ID PowerPath specimen category ID
SPECIMEN_CATEGORY_NAME The specimen category name
SPECIMEN_GROUPS_CODE Specimen specialty code
SPECIMEN_GROUPS_ID PowerPath specimen specialty ID
SPECIMEN_LABEL Specimen identifier
TYPE Whether the slide is consult or not consult

ACC_RESULTS

Number of records: 31,193,765
Column Name Comments
ACC_RESULTS_FINDING The text of the report section
ACC_RESULTS_ID PowerPath unique identifier for each report section
ACC_RESULTS_REC_ID sort order of result section on RTF
ACCESSION_2_ID PowerPath unique case ID
LAST_UPDATE_DATETIME Case finalize date / status update datetime
PATH_RPT_HEADING_ID PowerPath result section heading on RTF
PATH_RPT_HEADING_NAME PowerPath result section heading name

ACC_SLIDE_IMAGESERVER

Number of records: 2,564,239
Column Name Comments
ACC_SLIDE_ID PowerPath unique slide ID
ACC_SLIDE_IMAGESERVER_DESCRIPTION The name of the Philips iSyntax slide image file
ACC_SLIDE_IMAGESERVER_ID PowerPath unique identifier for a slide image
INTERNAL_SLIDE_ID Identifier for the slide,  also known as the \”barcode\” ID
LAST_UPDATE_DATETIME Case finalize date / status update datetime
SCAN_DATE The date on which the slide image was digitized

 

Mount Sinai Million Health Discoveries Program

The current lack of diversity in genomic research data is hindering what we can learn about health and potential treatments in our global population. By enhancing the diversity of people participating in genomic research, we can advance our knowledge and discovery of human genetics for all populations. To that end, The Charles Bronfman Institute for Personalized Medicine is spearheading the effort to carry out the genetic sequencing of one million Mount Sinai patients within the next five years. This initiative, one of the largest such sequencing projects of its kind, will integrate health and research data at Mount Sinai to promote discoveries that will directly benefit our patient population. Access to the BioMe Biobank and Mount Sinai Million Biobank on HPC can be requested via the CBIPM Data and Specimen Inquiry Form. AIR·MS now features radiology metadata extracted from the Mount Sinai IRW 2.0 XNAT system (via an MSDW data pipeline). This data set is comprised of detailed DICOM (Digital Imaging and Communications in Medicine) tags associated with the medical images. These tags provide essential metadata, including patient information, imaging parameters, equipment details, and procedural context, ensuring a comprehensive understanding of each radiological study. By integrating this metadata, we enable researchers to gain deeper insights into the imaging data, facilitating advanced analyses and fostering innovations in medical imaging research.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

The following tables and attributes are available in AIR·MS:

Mount Sinai Million / BioMe identifiable (PHI)

​​​​​​​Current Status

Schema: CDMMSM
Data snapshot from 06/09/2025
Unique patients: 279,885
PATIENT Comments
ID Internal ID for linking to other tables within the dataset
MRN Medical Record Number (EPIC MRN – only accessible under regulatory approval)
MASKED_MRN De-Identifier for combined BioMe Biobank set with Regeneron and Sema4 data
RGN_ID De-identifier for first Regeneron batch regarding BioMe Biobank
SEMA4_ID De-identifier for Sema4, a subset of Masked MRN ID
MSM_ID De-identifier for Mount Sinai Million Biobank, a combined setoff RGN_ID and new MSM ID
MILLION_ID Indicator for all consented patients with and without genomic data
AIR_CREATED_AT Record creation in AIR·MS
AIR_UPDATED_AT Record updated in AIR·MS

Mount Sinai Million / BioMe de-identified (de-id)

​​​​​​​Current Status

Schema: CDMMSMDEID
Data snapshot from 06/09/2025
Unique patients: 279,885
PATIENT Comments
ID Internal ID for linking to other tables within the dataset
MASKED_MRN De-Identifier for combined BioMe Biobank set with Regeneron and Sema4 data
RGN_ID De-identifier for first Regeneron batch regarding BioMe Biobank
SEMA4_ID De-identifier for Sema4, a subset of Masked MRN ID
MSM_ID De-identifier for Mount Sinai Million Biobank, a combined setoff RGN_ID and new MSM ID
MILLION_ID Indicator for all consented patients with and without genomic data
AIR_CREATED_AT Record creation in AIR·MS
AIR_UPDATED_AT Record updated in AIR·MS

 

Electrocardiogram (ECG) Data (PHI)​

Electrocardiogram data, derived from Mount Sinai’s Cardiology Information System, is now available in AIR·MS.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

Current Status

Data Source: GE HealthCare MUSE Cardiology Information System
Schema: CDMECG
Data snapshot from: 04/10/2021
Unique patients: 1,961,254

The following tables and attributes are available in AIR·MS:

Number of records: 9,275,130
PATIENT_DEMOGRAPHICS
PATIENT_DEMOGRAPHICS_ID (X)
FILE_ENTRY_ID
PATIENT_ID
PATIENTAGE
AGEUNITS
DATEOFBIRTH
GENDER
RACE
PATIENTLASTNAME
PATIENTFIRSTNAME
Number of records: 9,168,266
DIAGNOSIS
DIAGNOSIS_ID (X)
FILE_ENTRY_ID
MODALITY
DIAGNOSISSTATEMENT
Number of records: 73,631,055
LEAD_DATA
LEAD_DATA_ID (X)
FILE_ENTRY_ID
LEADBYTECOUNTTOTAL
LEADTIMEOFFSET
LEADSAMPLECOUNTTOTAL
LEADAMPLITUDEUNITSPERBIT
LEADAMPLITUDEUNITS
LEADHIGHLIMIT
LEADLOWLIMIT
LEADID
LEADOFFSETFIRSTSAMPLE
FIRSTSAMPLEBASELINE
LEADSAMPLESIZE
LEADOFF
BASELINESWAY
LEADDATACRC32
WAVEFORMDATA
Number of records: 9,610,935
ECG_FILES
FILE_ENTRY_ID (X)
FILE_NAME
FILE_PATH
FILE_HASH
FILE_SIZE_BYTES
ACQUISITION_DATE
ACQUISITION_TIME
PROCESSING_STATUS
STATUS_CODE
NOTES_AND_COMMENTS
FILE_TIMESTAMP
AIR_CREATED_AT
AIR_UPDATED_AT
JSON_STATUS
Number of records: 9,168,230
MUSE_INFO
MUSEVERSION
FILE_ENTRY_ID
Number of records: 7,757,472
ORDER_INFO
ORDER_INFO_ID (X)
FILE_ENTRY_ID
HISACCOUNTNUMBER
ORDERTIME
ADMITTIME
ADMITDATE
HISLOCATION
BED
ATTENDINGMDHISID
ATTENDINGMDLASTNAME
ATTENDINGMDFIRSTNAME
ALTERNATEVISITID
HISDISPOSITION
ADMITSOURCE
PRIMARYDIAGNOSTICCODE
SERVICINGFACILITY
ADMITTINGMDHISID
ADMITTINGMDLASTNAME
ADMITTINGMDFIRSTNAME
CONSULTINGMDID
REFERRINGMDHISID
HOSPITALSERVICE
ADMISSIONTYPE
Number of records: 9,164,220
ORIGINAL_DIAGNOSIS
ORIGINAL_DIAGNOSIS_ID (X)
FILE_ENTRY_ID
MODALITY
DIAGNOSISSTATEMENT
Number of records: 9,168,044
ORIGINAL_RESTING_ECG_MEASUREMENTS
ORIGINAL_RESTING_ECG_MEASUREMENTS_ID (X)
VENTRICULARRATE
ATRIALRATE
PRINTERVAL
QRSDURATION
QTINTERVAL
QTCORRECTED
PAXIS
RAXIS
TAXIS
QRSCOUNT
QONSET
QOFFSET
PONSET
POFFSET
TOFFSET
ECGSAMPLEBASE
ECGSAMPLEEXPONENT
QTCFREDERICA
Number of records: 3,613,372
PHARMA_DATA
PHARMA_DATA_ID (X)
PHARMARRINTERVAL
PHARMAUNIQUEECGID
PHARMAPPINTERVAL
PHARMACARTID
FILE_ENTRY_ID
Number of records: 9,649,712
QRS_TIMES_TYPES
GLOBALRR
QTRGGR
FILE_ENTRY_ID
Number of records: 9,657,368
RESTING_ECG
RESTING_ECG_ID (X)
FILE_ENTRY_ID
PATIENT_ID
ACQUISITIONDATE
ACQUISITIONTIME
STATUS
Number of records: 9,167,778
RESTING_ECG_MEASUREMENTS
RESTING_ECG_MEASUREMENTS_ID (X)
FILE_ENTRY_ID
VENTRICULARRATE
ATRIALRATE
PRINTERVAL
QRSDURATION
QTINTERVAL
QTCORRECTED
PAXIS
RAXIS
TAXIS
QRSCOUNT
QONSET
QOFFSET
PONSET
POFFSET
TOFFSET
ECGSAMPLEBASE
ECGSAMPLEEXPONENT
QTCFREDERICA
Number of records: 9,654,325
TEST_DEMOGRAPHICS
TEST_DEMOGRAPHICS_ID (X)
FILE_ENTRY_ID
DATATYPE
SITE
SITENAME
ACQUISITIONDEVICE
STATUS
EDITLISTSTATUS
PRIORITY
LOCATION
LOCATIONNAME
ROOMID
ACQUISITIONTIME
ACQUISITIONDATE
CARTNUMBER
ACQUISITIONSOFTWAREVERSION
ANALYSISSOFTWAREVERSION
EDITTIME
EDITDATE
EDITORID
REFERRINGMDLASTNAME
REFERRINGMDFIRSTNAME
ACQUISITIONTECHLASTNAME
EDITORLASTNAME
EDITORFIRSTNAME
SECONDARYID
HISSTATUS

 

Intensive Care Unit (ICU) Data (PHI)

The Mount Sinai ICU Datamart is the world’s first ICU data platform designed to simultaneously support research, quality improvement, and operational initiatives. It is built on a common data model that standardizes critical care medical concepts, enabling consistent interpretation and integration of data across diverse ICU settings.The Mount Sinai ICU Datamart harmonizes and delivers high-fidelity information from all Mount Sinai adult ICUs with highly granular data available from 2011 onward and refreshed weekly. Beyond serving as a comprehensive data resource, it also tracks the evolution of the health system’s critical care landscape, capturing changes in unit specialties, geographic distribution, and the addition of new ICUs. By transforming the ICU’s inherently rich data environment into a standardized, dynamic, and accessible platform, the Mount Sinai ICU Datamart empowers clinicians, researchers, and administrators to advance data-driven care, operational excellence, and clinical discovery.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

​​​​​​​Current Status

Schema: CDMICU
Number of patients: 103,974
Number of hospital admissions: 128,599
Number of ICU stays: 152,154
Number of clinical events and observations: 553,095,763

The following tables and attributes are available in AIR·MS:

Number of records: 128,600
HOSP_ADMISSIONS
ADMISSION_LOCATION
ADMISSION_TYPE
ADMIT_PROVIDER_ID
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
DEATH_TIME
DISCHARGE_LOCATION
DISCH_TIME
ED_IN_TIME
ED_OUT_TIME
ETHNICITY
HADM_ID
HOSPITAL_EXPIRE_FLAG
INPATIENT_ADMIT_TIME
INSURANCE
LANGUAGE
MARITAL_STATUS
MODIFIED_INSTANT
RACE
SUBJECT_ID
Number of records: 289,789,014
HOSP_CHART_EVENTS
AIR_CREATED_AT
AIR_UPDATED_AT
CAREGIVER_ID
CHART_TIME
CREATED_INSTANT
HADM_ID
ITEM_ID
MODIFIED_INSTANT
STORE_TIME
SUBJECT_ID
VALUE
VALUE_NUM
VALUE_UOM
WARNING
Number of records: 17
HOSP_D_ITEMS
AIR_CREATED_AT
AIR_UPDATED_AT
CAREGIVER_ID
CHART_TIME
CREATED_INSTANT
HADM_ID
ITEM_ID
MODIFIED_INSTANT
STORE_TIME
SUBJECT_ID
VALUE
VALUE_NUM
VALUE_UOM
WARNING
Number of records: 18,030
HOSP_D_LAB_ITEMS
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
ITEM_ID
LABEL
MODIFIED_INSTANT
Number of records: 263,306,749
HOSP_LAB_EVENTS
AIR_CREATED_AT
AIR_UPDATED_AT
COLLECTION_INSTANT
CREATED_INSTANT
FLAG
HADM_ID
ITEM_ID
LAB_EVENT_ID
LAB_ORDER_ID
MODIFIED_INSTANT
ORDER_PROVIDER_ID
PRIORITY
REF_RANGE_LOWER
REF_RANGE_UPPER
RESULT_INSTANT
SPECIMEN_TYPE
SUBJECT_ID
VALUE
VALUE_NUM
VALUE_UOM
Number of records: 1,858,853
HOSP_LDA_EVENTS
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
FIRST_RECORDED_INSTANT
ITEM_ID
LDA_ID
LENGTH_LDA
MODIFIED_INSTANT
PLACEMENT_INSTANT
REMOVAL_INSTANT
SUBJECT_ID
Number of records: 63
HOSP_LDA_ITEMS
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
ITEM_ID
LABEL
LDA_CATEGORY
LDA_SUB_CATEGORY
MODIFIED_INSTANT
Number of records: 104,046
HOSP_PATIENTS
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
DOB
DOD
EPIC_ID
ETHNICITY_COMBO_ID
GENDER
MODIFIED_INSTANT
PRIMARY_MRN
RACE_COMBO_ID
SUBJECT_ID
Number of records: 525,267
HOSP_PATIENT_SERVICES
AIR_CREATED_AT
AIR_UPDATED_AT
ASSIGNMENT_END
ASSIGNMENT_START
CARE_UNIT
CARE_UNIT_ID
CREATED_INSTANT
HADM_ID
MODIFIED_INSTANT
PATIENT_SERVICE_ID
SUBJECT_ID
Number of records: 839,542
HOSP_TRANSFERS
AIR_CREATED_AT
AIR_UPDATED_AT
BED_ID
CARE_UNIT
CARE_UNIT_ID
CREATED_INSTANT
EVENT_TYPE
HADM_ID
IN_TIME
MODIFIED_INSTANT
OUT_TIME
SUBJECT_ID
TRANSFER_ID
Number of records: 152,154
ICU_ICU_STAYS
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_ID
CREATED_INSTANT
HADM_ID
IN_TIME
LOS
MODIFIED_INSTANT
OUT_TIME
STAY_ID
SUBJECT_ID
Number of records: 289,789,014
ICU_ICU_STAYS
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_ID
CREATED_INSTANT
HADM_ID
IN_TIME
LOS
MODIFIED_INSTANT
OUT_TIME
STAY_ID
SUBJECT_ID
Number of records: 30
MAPPING_CARE_UNIT
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_END_DATE
CARE_UNIT_ID
CARE_UNIT_NAME
CARE_UNIT_START_DATE
CATEGORY_ID
CREATED_INSTANT
HOSPITAL_ID
MODIFIED_INSTANT
Number of records: 29
MAPPING_CARE_UNIT_SERVICE_TAG
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_ID
CREATED_INSTANT
MODIFIED_INSTANT
SERVICE_TAG_END_DATE
SERVICE_TAG_ID
SERVICE_TAG_START_DATE
Number of records: 5
MAPPING_CATEGORY      
AIR_CREATED_AT
AIR_UPDATED_AT
CATEGORY
CATEGORY_ID
CREATED_INSTANT
MODIFIED_INSTANT
Number of records: 47
MAPPING_EPIC_DEPARTMENT
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_ID
CREATED_INSTANT
DEPARTMENT_ID
DEPARTMENT_NAME
EPIC_DEPARTMENT_END_DATE
EPIC_DEPARTMENT_START_DATE
MODIFIED_INSTANT
Number of records: 336
MAPPING_ETHNICITY
AIR_CREATED_AT
AIR_UPDATED_AT
CONCEPT_LEVEL_1
CONCEPT_LEVEL_2
CREATED_INSTANT
ETHNICITY_COMBO_ID
MODIFIED_INSTANT
RACE_ETHNICITY_TERMINOLOGY_KEY
Number of records: 189
MAPPING_ETHNICITY_BRIDGE
AIR_CREATED_AT
AIR_UPDATED_AT
CATEGORY_NAME
CREATED_INSTANT
ETHNICITY_COMBO_ID
MODIFIED_INSTANT
Number of records: 38
MAPPING_GEOGRAPHIC_LOCATION
AIR_CREATED_AT
AIR_UPDATED_AT
CARE_UNIT_ID
CREATED_INSTANT
GEOGRAPHIC_LOCATION
GEOGRAPHIC_LOCATION_END_DATE
GEOGRAPHIC_LOCATION_START_DATE
MODIFIED_INSTANT
Number of records: 8
MAPPING_HOSPITAL
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
HOSPITAL
HOSPITAL_ID
MODIFIED_INSTANT
Number of records: 85
MAPPING_PATIENT_SERVICE
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
MODIFIED_INSTANT
PATIENT_SERVICE
PATIENT_SERVICE_ID
Number of records: 298
MAPPING_RACE
AIR_CREATED_AT
AIR_UPDATED_AT
CONCEPT_LEVEL_1
CONCEPT_LEVEL_2
CREATED_INSTANT
MODIFIED_INSTANT
RACE_COMBO_ID
RACE_ETHNICITY_TERMINOLOGY_KEY
Number of records: 176
MAPPING_RACE_BRIDGE
AIR_CREATED_AT
AIR_UPDATED_AT
CATEGORY_NAME
CREATED_INSTANT
MODIFIED_INSTANT
RACE_COMBO_ID
Number of records: 11
MAPPING_SERVICE_TAG
AIR_CREATED_AT
AIR_UPDATED_AT
CREATED_INSTANT
MODIFIED_INSTANT
SERVICE_TAG
SERVICE_TAG_ID

 

 

Radiology Image Data (PHI and De-ID)

AIR·MS provides a new radiology dataset organized in a ground-up, OMOP-aligned medical imaging common data model. The currently implemented model represents DICOM studies and series and links those records to OMOP patients and concepts. The identifiable schema also stores study- and series-level DICOM attributes that are not promoted to dedicated columns while preserving nested sequence structure, repeated tags, arrays, coded values, units, and typed values.

The identifiable model contains source identifiers and other protected health information (PHI). The de-identified model removes direct identifiers, converts linked identifiers to de-identified keys, shifts patient dates and datetimes, and transforms free-text values to remove PHI.

To access the data, follow the AIR·MS “Getting Started” guide.

Current Status

Identifiable schema: CDMRADIOLOGY
De-identified schema: CDMRADIOLOGYDEID
Distinct persons with a populated study access URI: 546,136 in CDMRADIOLOGY; 541,243 in CDMRADIOLOGYDEID
Model definition: September 4, 2026

Record Counts

Schema Table Required populated field Record count Distinct persons
CDMRADIOLOGY IMAGING_STUDY IMAGING_STUDY_ACCESS_URI 1,528,206 546,136
CDMRADIOLOGY IMAGING_SERIES IMAGING_SERIES_ACCESS_URI 15,741,502 545,991
CDMRADIOLOGYDEID IMAGING_STUDY IMAGING_STUDY_ACCESS_URI 1,510,900 541,243
CDMRADIOLOGYDEID IMAGING_SERIES IMAGING_SERIES_ACCESS_URI 15,607,158 541,101

Model Structure

The model follows the native DICOM hierarchy:

IMAGING_STUDY
├── IMAGING_STUDY_ATTRIBUTE (PHI only)
└── IMAGING_SERIES
    └── IMAGING_SERIES_ATTRIBUTE (PHI only)

Tables

Table Purpose
IMAGING_STUDY One record per imaging study, linked to the patient.
IMAGING_SERIES One record per DICOM series within a study, with modality, anatomy, acquisition, equipment, and aggregate image information.
IMAGING_STUDY_ATTRIBUTE Study-level DICOM attributes that are not represented as dedicated columns in IMAGING_STUDY.
IMAGING_SERIES_ATTRIBUTE Series-level DICOM attributes that are not represented as dedicated columns in IMAGING_SERIES.

Key Relationships

  • IMAGING_STUDY.PERSON_ID links an imaging study to the OMOP person record.
  • IMAGING_SERIES.IMAGING_STUDY_ID links each series to its parent study.
  • In CDMRADIOLOGY, each attribute table links to its owning study or series and uses a self-referencing parent attribute ID to represent nested DICOM sequences.
  • OMOP concept fields provide standardized mappings where available; a value of 0 indicates that no mapping is available.

De-Identification Behavior

The implemented CDMRADIOLOGYDEID schema contains IMAGING_STUDY and IMAGING_SERIES. Attribute tables are available only in the identifiable CDMRADIOLOGY schema. The De-ID model applies the following rules to its implemented tables:

  • Patient, study, and series identifiers are de-identified and stored as char(64) values.
  • Study, series, acquisition, content, and instance-creation date/datetime values are shifted on a patient-specific basis.
  • Free-text study descriptions, series descriptions, institution names, and department names are algorithmically transformed rather than retaining verbatim PHI-bearing text.
  • Direct patient identifiers and source DICOM identifiers are excluded, including accession number, Study Instance UID, Series Instance UID, DICOM patient ID, patient name components, birth date, sex, and address.
  • Source-system ETL keys and ETL audit fields are excluded from the De-ID model.
  • Study- and series-level attribute tables, including their nested DICOM values, are not currently implemented in the De-ID schema.

Nested DICOM Tags, Sequences, and Arrays

The two PHI attribute tables use the same structural pattern. A sequence tag has its own row. Child tags reference that sequence row through PARENT_IMAGING_STUDY_ATTRIBUTE_ID or PARENT_IMAGING_SERIES_ATTRIBUTE_ID. PARENT_DICOM_TAG_PATH in the study-attribute definition and PARENT_DICOM_TAG_SOURCE_VALUE in the series-attribute definition record the human-readable path to the parent sequence, including zero-based sequence indexes. PARENT_SEQUENCE_INDEX identifies the item within the immediate parent sequence.

Arrays are distinct from sequences. IS_ARRAY = 1 indicates that a tag contains multiple scalar values, and ARRAY_INDEX records the zero-based position of each value. TAG_OCCURRENCE_NUMBER distinguishes repeated occurrences of the same tag under one parent; DICOM-compliant data normally uses the default value 1.

Values are stored in the column matching their type:

Value column Use
VALUE_AS_NUMBER Integer or decimal values
VALUE_AS_CONCEPT_ID Standard OMOP concept derived from a source concept
VALUE_AS_SOURCE_CONCEPT_ID Custom OMOP concept representing the source value
VALUE_AS_CODE DICOM coded value such as CodeValue
SOURCE_VOCABULARY_NAME Coding scheme for the coded value, such as DCM, SRT, or UCUM
VALUE_AS_STRING Text and other string values
VALUE_AS_DATETIME Date or datetime values
UNIT_CONCEPT_ID / UNIT_SOURCE_VALUE Standardized and source unit of measure

Tables and Attributes

The implemented table definitions are listed below. IMAGING_STUDY and IMAGING_SERIES are available in both schemas. The two attribute tables are implemented only in CDMRADIOLOGY. Required status is the same in both variants for retained columns.

IMAGING_STUDY

One record per imaging study, linked to the patient.

Identifiable model: 35 columns. De-identified model: 15 columns.

Column Key Required PHI type De-ID type De-ID handling Description
IMAGING_STUDY_ID PK Yes bigint char(64) De-identified identifier; stored as char(64) OMOP unique ID for each patient imaging study
PERSON_ID FK No bigint char(64) De-identified identifier; stored as char(64) OMOP unique ID for the patient undergoing the imaging study
PROCEDURE_OCCURRENCE_ID FK No bigint char(64) De-identified identifier; stored as char(64) Reserved for a future link to the corresponding OMOP procedure occurrence; this linkage is not currently implemented
ACCESSION_NUMBER — No varchar(128) — Excluded from the De-ID model DICOM tag (0008,0050) AccessionNumber: Unique identifier for the imaging study in the RIS/EHR system
IMAGING_STUDY_INSTANCE_UID — Yes varchar(128) — Excluded from the De-ID model DICOM tag (0020,000D) StudyInstanceUID: Unique identifier for the imaging study assigned by the imaging equipment
DICOM_STUDY_ID — No varchar(128) — Excluded from the De-ID model DICOM tag (0020,0010) StudyID: An identifier for the imaging study included in the DICOM header
IMAGING_STUDY_DATE — No date date Patient-specific date/datetime shift DICOM tag (0008,0020) StudyDate: The date on which the imaging study was performed
IMAGING_STUDY_TIME — No time(6) time(6) Retained DICOM tag (0008,0030) StudyTime: The time of day at which the imaging study was performed
IMAGING_STUDY_DESCRIPTION — No nvarchar(300) nvarchar(300) Algorithmically transformed to remove PHI DICOM tag (0008,1030) StudyDescription: The description of the imaging study
IMAGING_STUDY_CONCEPT_ID FK Yes int int Retained Foreign-key reference to an OMOP concept in ATHENA representing the imaging study performed, derived entirely or in part from the value in DICOM tag (0008,1030) StudyDescription; Will be zero if the value is unmapped to an OMOP concept from ATHENA
IMAGING_STUDY_ACCESS_URI — No varchar(2000) varchar(2000) Retained Uniform Resource Identifier (URI) describing the location from which the DICOM file can be retrieved, either on a web DICOM server (e.g., via the use of the WADO-RS DICOMweb REST API) or other repository
MODALITIES_IN_STUDY — No varchar(100) varchar(100) Retained DICOM tag (0008,0061) ModalitiesInStudy: A comma-separated list of DICOM modality codes for the imaging modalities used to acquire this study’s imaging series
NUMBER_OF_SERIES — Yes int int Retained The total number of imaging series within the imaging study, computed from the records in the imaging_series table. Note: The DICOM tag (0020,1000) SeriesInStudy was retired in 2004.
NUMBER_OF_INSTANCES — Yes int int Retained The total number of instances (of all SOP classes) across all the series within the imaging study, computed from the number_of_instances column in the imaging_series table.
NUMBER_OF_IMAGES — Yes int int Retained The total number of image instances across all the series within the imaging study, computed from the number_of_images column in the imaging_series table.
DICOM_PATIENT_ID — No varchar(128) — Excluded from the De-ID model DICOM tag (0010,0020) PatientID: An identifier for the patient passed to the RIS from the procedure ordering system, usually a Medical Record Number (MRN)
DICOM_PATIENT_ID_TYPE — No varchar(64) — Excluded from the De-ID model DICOM tag (0010,0022) TypeOfPatientID: A short code indicating the type of identifier used for the patient in DICOM tag (0010,0020) PatientID
ISSUER_OF_PATIENT_ID — No nvarchar(200) — Excluded from the De-ID model DICOM tag (0010,0021) IssuerOfPatientID: An identifier for the organization that assigned the patient identifier in DICOM tag (0010,0020) PatientID
DICOM_PATIENT_NAME — No nvarchar(1000) — Excluded from the De-ID model DICOM tag (0010,0010) PatientName: The verbatim text string of the patient’s full name as included in the imaging study’s DICOM header, formatted according to the DICOM standard with caret delimiters
DICOM_PATIENT_LAST_NAME — No nvarchar(300) — Excluded from the De-ID model The patient’s surname or family name(s) extracted from the first caret-delimited component of DICOM tag (0010,0010) PatientName
DICOM_PATIENT_GIVEN_NAME — No nvarchar(200) — Excluded from the De-ID model The patient’s given name(s) extracted from the second caret-delimited component of DICOM tag (0010,0010) PatientName
DICOM_PATIENT_MIDDLE_NAME — No nvarchar(200) — Excluded from the De-ID model The patient’s middle name(s), if any, extracted from the third caret-delimited component of DICOM tag (0010,0010) PatientName
DICOM_PATIENT_BIRTH_DATE — No date — Excluded from the De-ID model DICOM tag (0010,0030) PatientBirthDate: The patient’s date of birth as included in the imaging study’s DICOM header
DICOM_PATIENT_SEX — No varchar(32) — Excluded from the De-ID model DICOM tag (0010,0040) PatientSex: A short code for the patient’s sex as included in the imaging study’s DICOM header
DICOM_PATIENT_ADDRESS — No nvarchar(500) — Excluded from the De-ID model DICOM tag (0010,1040) PatientAddress: An address for the patient as included in the imaging study’s DICOM header
INSTITUTION_NAME — No nvarchar(200) nvarchar(200) Algorithmically transformed to remove PHI DICOM tag (0008,0080) InstitutionName: The name of the organization, facility, or legal entity where the imaging study was performed
DEPARTMENT_NAME — No nvarchar(200) nvarchar(200) Algorithmically transformed to remove PHI DICOM tag (0008,1040) InstitutionalDepartmentName: The name of the organizational unit within the institution where the imaging study was performed
IS_EXTERNAL_STUDY — No tinyint tinyint Retained Boolean value of 1 (one) if the imaging study was performed outside of Mount Sinai Health System; Boolean value of 0 (zero) if the imaging study was performed at a Mount Sinai Health System facility; a value of NULL if the imaging study’s provenance is undetermined
ETL_RECORD_SOURCE_BUSINESS_KEY — Yes nvarchar(300) — Excluded from the De-ID model The unique identifier for this record in its source system; Equal to imaging_study_instance_uid in this table
ETL_CREATE_LOG_ID FK Yes bigint — Excluded from the De-ID model The unique integer identifier for the ETL execution that first inserted this record into this database table
ETL_RECORD_CREATE_DATETIME — Yes datetime2(0) — Excluded from the De-ID model The date and time at which this record was first inserted into this database table
ETL_UPDATE_LOG_ID FK Yes bigint — Excluded from the De-ID model The unique integer identifier for the ETL execution that most recently updated this record in this database table
ETL_RECORD_UPDATE_DATETIME — Yes datetime2(0) — Excluded from the De-ID model The date and time at which this record was most recently updated in this database table
ETL_RECORD_VERSION_HASH_CODE — Yes binary(32) — Excluded from the De-ID model The output of the SHA2-256 cryptographic hash function for all the non-ETL columns of this record
ETL_RECORD_IS_DELETED — Yes tinyint — Excluded from the De-ID model Boolean value of 1 (one) if the record is logically deleted; 0 (zero) otherwise

IMAGING_SERIES

One record per DICOM series within a study, with modality, anatomy, acquisition, equipment, and aggregate image information.

Identifiable model: 44 columns. De-identified model: 35 columns.

Column Key Required PHI type De-ID type De-ID handling Description
IMAGING_SERIES_ID PK Yes bigint char(64) De-identified identifier; stored as char(64) OMOP unique ID for each imaging series within the imaging study
PERSON_ID FK No bigint char(64) De-identified identifier; stored as char(64) OMOP unique ID for the patient undergoing the imaging study
IMAGING_STUDY_ID FK Yes bigint char(64) De-identified identifier; stored as char(64) OMOP unique ID for each patient imaging study
IMAGING_SERIES_INSTANCE_UID — Yes varchar(128) — Excluded from the De-ID model DICOM tag (0020,000E) SeriesInstanceUID: Unique identifier for the imaging series assigned by the imaging equipment
SERIES_NUMBER — No int int Retained DICOM tag (0020,0011) SeriesNumber: An integer representing the temporal order of the series within all series of the imaging study
IMAGING_SERIES_DATE — No date date Patient-specific date/datetime shift DICOM tag (0008,0021) SeriesDate: The date on which the images in this series were acquired
IMAGING_SERIES_TIME — No time(6) time(6) Retained DICOM tag (0008,0031) SeriesTime: The time of day at which the images in this series were acquired
IMAGING_SERIES_DESCRIPTION — No nvarchar(300) nvarchar(300) Algorithmically transformed to remove PHI DICOM tag (0008,103E) SeriesDescription: The description of the imaging series
IMAGING_SERIES_CONCEPT_ID FK Yes int int Retained Foreign-key reference to an OMOP concept in ATHENA representing the imaging series performed, derived entirely or in part from the value in DICOM tag (0008,103E) SeriesDescription; Will be zero if the value is unmapped to an OMOP concept from ATHENA
IMAGING_SERIES_ACCESS_URI — No varchar(2000) varchar(2000) Retained Uniform Resource Identifier (URI) describing the location from which the DICOM file can be retrieved, either on a web DICOM server (e.g., via the use of the WADO-RS DICOMweb REST API) or other repository
IMAGING_MODALITY_CONCEPT_ID FK Yes int int Retained Foreign-key reference to an OMOP concept in ATHENA (such as a LOINC code) representing the value in DICOM tag (0008,0060) Modality; Will be zero if the value is unmapped to an OMOP concept from ATHENA
IMAGING_MODALITY_SOURCE_CONCEPT_ID FK Yes int int Retained Foreign-key reference to a custom OMOP concept in vocabulary_id = ‘DICOM Modality’ representing the DICOM code in DICOM tag (0008,0060) Modality; Will be zero if the value is unmapped to a custom OMOP concept
IMAGING_MODALITY_SOURCE_VALUE — No varchar(20) varchar(20) Retained DICOM tag (0008,0060) Modality: The short DICOM code for the imaging modality used to acquire the images in this series; For example, MR = Magnetic Resonance Imaging, CT = Computed Tomography
LATERALITY_CONCEPT_ID FK Yes int int Retained Foreign-key reference to the OMOP concept representing the DICOM code in DICOM tag (0020,0060) Laterality, such as the concept for LOINC code LA4585-1 “Left” or LA4306-2 “Right”; Will be zero if the value is unmapped to a custom OMOP concept
LATERALITY_SOURCE_VALUE — No varchar(128) varchar(128) Retained DICOM tag (0020,0060) Laterality: The short DICOM code indicating which side of the body was imaged, if applicable, often used in conjunction with DICOM tag (0018,0015) BodyPartExamined; For example, R = Right, L = Left
BODY_PART_CONCEPT_ID FK Yes int int Retained Foreign-key reference to the OMOP concept representing the DICOM code or short text value in DICOM tag (0018,0015) BodyPartExamined, for which the DICOM standard provides a list of SNOMED-CT codes (http://dicom.nema.org/medical/dicom/current/output/chtml/part16/chapter_L.html); Will be zero if the value is unmapped to a custom OMOP concept
BODY_PART_SOURCE_CONCEPT_ID FK Yes int int Retained Foreign-key reference to a custom OMOP concept in vocabulary_id = ‘DICOM Body Part’ representing the short DICOM code in DICOM tag (0018,0015) BodyPartExamined; Will be zero if the value is unmapped to a custom OMOP concept; This source concept allows values that do not align with the standard SNOMED-CT codes specified by the DICOM standard
BODY_PART_SOURCE_VALUE — No varchar(128) varchar(128) Retained DICOM tag (0018,0015) BodyPartExamined: A short text description of the patient’s body part being imaged in this series
PATIENT_POSITION_CONCEPT_ID FK Yes int int Retained Foreign-key reference to a custom OMOP concept in vocabulary_id = ‘DICOM Pt Position’ representing the DICOM code in DICOM tag (0018,5100) PatientPosition; Will be zero if the value is unmapped to a custom OMOP concept
PATIENT_POSITION_SOURCE_VALUE — No varchar(128) varchar(128) Retained DICOM tag (0018,5100) PatientPosition: A short DICOM code indicating the position of the patient’s body when the imaging series was performed
PATIENT_ORIENTATION_CONCEPT_ID FK Yes int int Retained Foreign-key reference to a custom OMOP concept in vocabulary_id = ‘DICOM Pt Orientation’ representing the DICOM code(s) in DICOM tag (0020,0020) PatientOrientation; Will be zero if the value is unmapped to a custom OMOP concept
PATIENT_ORIENTATION_SOURCE_VALUE — No varchar(128) varchar(128) Retained DICOM tag (0020,0020) PatientOrientation: An array of two short DICOM codes indicating the patient’s orientation during the acquisition of the images in this series; For example, A= Anterior, P = Posterior, L = Left, R = Right, H = Head, F = Foot
NUMBER_OF_INSTANCES — Yes int int Retained The total number of instances (of all SOP classes) within this series of the imaging study, computed from the records in the imaging_instance table.
NUMBER_OF_IMAGES — Yes int int Retained The total number of image instances within this series of the imaging study, computed from DICOM tag (0008,0016) SOPClassUID, to determine which instances are images, and the records in the imaging_instance table. Note: The DICOM tag (0020,1005) ImagesInStudy was retired in 2006.
IMAGES_IN_ACQUISITION — No int int Retained DICOM tag (0020,1002) ImagesInAcquisition: Number of images that resulted from a single continuous acquisition of data
MANUFACTURER_NAME — No nvarchar(200) nvarchar(200) Retained DICOM tag (0008,0070) Manufacturer: The trade name of the imaging equipment’s manufacturer; Technically this DICOM tag pertains to the Equipment information entity, which is used to produce one or more imaging series within a given study
MANUFACTURER_MODEL — No nvarchar(200) nvarchar(200) Retained DICOM tag (0008,1090) ManufacturerModelName: The manufacturer’s designation of their imaging equipment model; Technically this DICOM tag pertains to the Equipment information entity, which is used to produce one or more imaging series within a given study
FIRST_SOP_CLASS_UID — No varchar(128) — Excluded from the De-ID model The value of DICOM tag (0008,0016) SOPClassUID for the first image in this imaging series; image SOP classes have concept_class_id = ‘DICOM Image Class’ in vocabulary_id = ‘DICOM SOP Class’
MIN_ACQUISITION_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically earliest image acquisition date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0022) AcquisitionDate and (0008,0032) AcquisitionTime, or from DICOM tag (0008,002A) AcquisitionDateTime
MAX_ACQUISITION_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically latest image acquisition date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0022) AcquisitionDate and (0008,0032) AcquisitionTime, or from DICOM tag (0008,002A) AcquisitionDateTime
MIN_CONTENT_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically earliest image content date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0023) ContentDate and (0008,0033) ContentTime
MAX_CONTENT_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically latest image content date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0023) ContentDate and (0008,0033) ContentTime
MIN_INSTANCE_CREATION_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically earliest instance creation date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0012) InstanceCreationDate and (0008,0013) InstanceCreationTime
MAX_INSTANCE_CREATION_DATETIME — No datetime2(6) datetime2(6) Patient-specific date/datetime shift The chronologically latest instance creation date and time (if available) across all images in this imaging series, derived from DICOM tags (0008,0012) InstanceCreationDate and (0008,0013) InstanceCreationTime
TOTAL_DOSE_AREA_PRODUCT — No float(53) float(53) Retained The sum of DICOM tag (0018,115E) ImageandFluoroscopyAreaDoseProduct across all images in the series
SCAN_LENGTH — No int int Retained (0018,1302) ScanLength: The physical length of the scanned region along the patient axis, measured in millimeters
HAS_CONTRAST_AGENT — Yes tinyint tinyint Retained Boolean value of 1 (one) if this imaging series has a value in DICOM tag (0018,0010) ContrastBolusAgent; otherwise 0 (zero)
ETL_RECORD_SOURCE_BUSINESS_KEY — Yes nvarchar(300) — Excluded from the De-ID model The unique identifier for this record in its source system; Equal to imaging_series_instance_uid in this table
ETL_CREATE_LOG_ID FK Yes bigint — Excluded from the De-ID model The unique integer identifier for the ETL execution that first inserted this record into this database table
ETL_RECORD_CREATE_DATETIME — Yes datetime2(0) — Excluded from the De-ID model The date and time at which this record was first inserted into this database table
ETL_UPDATE_LOG_ID FK Yes bigint — Excluded from the De-ID model The unique integer identifier for the ETL execution that most recently updated this record in this database table
ETL_RECORD_UPDATE_DATETIME — Yes datetime2(0) — Excluded from the De-ID model The date and time at which this record was most recently updated in this database table
ETL_RECORD_VERSION_HASH_CODE — Yes binary(32) — Excluded from the De-ID model The output of the SHA2-256 cryptographic hash function for all the non-ETL columns of this record
ETL_RECORD_IS_DELETED — Yes tinyint — Excluded from the De-ID model Boolean value of 1 (one) if the record is logically deleted; 0 (zero) otherwise

IMAGING_STUDY_ATTRIBUTE

Study-level DICOM attributes that are not represented as dedicated columns in IMAGING_STUDY.

Identifiable model: 29 columns. De-identified model: 0 columns.

Column Key Required PHI type De-ID type De-ID handling Description
IMAGING_STUDY_ATTRIBUTE_ID PK Yes bigint — PHI only; table not implemented in De-ID OMOP unique ID for a single DICOM tag associated with an imaging study at the study level (not at the series or image level)
IMAGING_STUDY_ID FK Yes bigint — PHI only; table not implemented in De-ID OMOP unique ID for each patient imaging study
IMAGING_STUDY_INSTANCE_UID — Yes varchar(128) — PHI only; table not implemented in De-ID DICOM tag (0020,000D) StudyInstanceUID: Unique identifier for the imaging study assigned by the imaging equipment
PARENT_IMAGING_STUDY_ATTRIBUTE_ID FK Yes bigint — PHI only; table not implemented in De-ID Foreign-key reference to the DICOM tag in this table of data type SQ = Sequence that encapsulates the DICOM tag in column dicom_tag_source_value in nested fashion; Has value of zero if the DICOM tag has no parent
PARENT_DICOM_TAG_PATH — No varchar(7500) — PHI only; table not implemented in De-ID A text string describing the location of the DICOM tag within the DICOM header’s structure of nested sequence(s); This path consists of human-readable DICOM tag keywords including sequence element indexes, delimited by forward slashes, but NOT including the DICOM tag itself from dicom_tag_source_value; Example: ContentSequence[1]/ConceptNameCodeSequence[0]
PARENT_SEQUENCE_INDEX — No int — PHI only; table not implemented in De-ID The ordinal position of the DICOM object (or item) within the parent sequence specified by parent_imaging_study_attribute_id that contains the DICOM tag, starting from zero as if the sequence were an array of DICOM objects
DICOM_TAG_CONCEPT_ID FK Yes int — PHI only; table not implemented in De-ID Foreign-key reference to a custom OMOP concept representing the DICOM tag (i.e., data element or attribute); Will be zero if the value is unmapped to a custom OMOP concept
DICOM_TAG_SOURCE_VALUE — Yes varchar(128) — PHI only; table not implemented in De-ID The short text string that uniquely identifies the DICOM tag (i.e., data element or attribute), used to look up the custom OMOP concept in dicom_tag_concept_id
DICOM_DATA_TYPE_CONCEPT_ID FK Yes int — PHI only; table not implemented in De-ID Foreign-key reference to a custom OMOP concept representing the data type (or “value representation”) of the DICOM tag; Will be zero if the value is unmapped to a custom OMOP concept
DICOM_DATA_TYPE_SOURCE_VALUE — Yes varchar(20) — PHI only; table not implemented in De-ID The short DICOM code that uniquely identifies the data type (or “value representation”) of the DICOM tag, used to look up the custom OMOP concept in dicom_data_type_concept_id
IS_ARRAY — Yes tinyint — PHI only; table not implemented in De-ID A Boolean value of 1 (one) if the DICOM tag holds an array of more than one value; otherwise, a Boolean value of 0 (zero). Note: DICOM tags that are sequences are not arrays; they are composite objects that contain other DICOM tags.
ARRAY_INDEX — Yes int — PHI only; table not implemented in De-ID If is_array = 1, then this column stores the ordinal position of this record’s value in the DICOM tag’s array of values, starting at zero; Scalar values always have an array_index = 0 (zero)
TAG_OCCURRENCE_NUMBER — Yes int — PHI only; table not implemented in De-ID An integer indicating the ordinal position of each occurrence of this DICOM tag, if it appears more than once within its parent DICOM tag (usually an element of a DICOM sequence); The default value is 1; Note: According to the DICOM standard, a DICOM tag should not appear more than once within its parent DICOM object, so this column accommodates any deviations from the standard
VALUE_AS_NUMBER — No float(53) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is an integer or decimal
VALUE_AS_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it corresponds to an OMOP concept from ATHENA, typically via a semantic mapping from value_as_source_concept_id
VALUE_AS_SOURCE_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it corresponds to a custom OMOP concept
VALUE_AS_CODE — No varchar(128) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it has Value Representation of CS = Code String, such as DICOM tag (0008,0100) CodeValue, (0008,0101) ExtendedCodeValue, (0008,0119) LongCodeValue, (0008,0120) URNCodeValue.
SOURCE_VOCABULARY_NAME — No varchar(128) — PHI only; table not implemented in De-ID The value of DICOM tag (0008,0102) CodingSchemeDesignator when it occurs within the same information object or sequence item as a DICOM CodeValue that is loaded to value_as_code.
VALUE_AS_STRING — No nvarchar(max) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is a string of any length, including a time-of-day value without a date. If a DICOM CodeValue is loaded to value_as_code, then this column should include the value of DICOM tag (0008,0104) CodeMeaning or (0008,0108) ExtendedCodeMeaning from the same information object or sequence item, if any.
VALUE_AS_DATETIME — No datetime2(6) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is a date with or without a time of day
UNIT_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID Foreign-key reference to a standard OMOP unit of measure concept, if any, associated with the value of the DICOM tag (data element)
UNIT_SOURCE_VALUE — No varchar(128) — PHI only; table not implemented in De-ID The short text string that uniquely identifies the unit of measure associated with the value of the DICOM tag, used to look up the standard OMOP unit of measure concept in unit_concept_id
ETL_RECORD_SOURCE_BUSINESS_KEY — Yes varchar(8000) — PHI only; table not implemented in De-ID The unique identifier for this record in its source system; Equal to the concatenation of the following columns in this table: imaging_study_instance_uid + ‘/’ + parent_dicom_tag_path + ‘/’ + dicom_tag_source_value + ‘[‘ + array_index + ‘]:’ + tag_occurrence_number
ETL_CREATE_LOG_ID FK Yes bigint — PHI only; table not implemented in De-ID The unique integer identifier for the ETL execution that first inserted this record into this database table
ETL_RECORD_CREATE_DATETIME — Yes datetime2(0) — PHI only; table not implemented in De-ID The date and time at which this record was first inserted into this database table
ETL_UPDATE_LOG_ID FK Yes bigint — PHI only; table not implemented in De-ID The unique integer identifier for the ETL execution that most recently updated this record in this database table
ETL_RECORD_UPDATE_DATETIME — Yes datetime2(0) — PHI only; table not implemented in De-ID The date and time at which this record was most recently updated in this database table
ETL_RECORD_VERSION_HASH_CODE — Yes binary(32) — PHI only; table not implemented in De-ID The output of the SHA2-256 cryptographic hash function for all the non-ETL columns of this record
ETL_RECORD_IS_DELETED — Yes tinyint — PHI only; table not implemented in De-ID Boolean value of 1 (one) if the record is logically deleted; 0 (zero) otherwise

IMAGING_SERIES_ATTRIBUTE

Series-level DICOM attributes that are not represented as dedicated columns in IMAGING_SERIES.

Identifiable model: 29 columns. De-identified model: 0 columns.

Column Key Required PHI type De-ID type De-ID handling Description
IMAGING_SERIES_ATTRIBUTE_ID PK Yes bigint — PHI only; table not implemented in De-ID OMOP unique ID for a single DICOM tag associated with a particular series within the imaging study (not at the study level or SOP instance level)
IMAGING_SERIES_ID FK Yes bigint — PHI only; table not implemented in De-ID OMOP unique ID for each imaging series within the imaging study
IMAGING_SERIES_INSTANCE_UID — Yes varchar(128) — PHI only; table not implemented in De-ID DICOM tag (0020,000E) SeriesInstanceUID: Unique identifier for the imaging series assigned by the imaging equipment
PARENT_IMAGING_SERIES_ATTRIBUTE_ID FK Yes bigint — PHI only; table not implemented in De-ID Foreign-key reference to the DICOM tag in this table of data type SQ = Sequence that encapsulates the DICOM tag in column dicom_tag_source_value in nested fashion; Has value of zero if the DICOM tag has no parent
PARENT_DICOM_TAG_SOURCE_VALUE — No varchar(7500) — PHI only; table not implemented in De-ID A text string describing the location of the DICOM tag within the DICOM header’s structure of nested sequence(s); This path consists of human-readable DICOM tag keywords including sequence element indexes, delimited by forward slashes, but NOT including the DICOM tag itself from dicom_tag_source_value; Example: ContentSequence[1]/ConceptNameCodeSequence[0]
PARENT_SEQUENCE_INDEX — No int — PHI only; table not implemented in De-ID The ordinal position of the DICOM object (or item) within the parent sequence specified by parent_imaging_series_attribute_id that contains the DICOM tag, starting from zero as if the sequence were an array of DICOM objects
DICOM_TAG_CONCEPT_ID FK Yes int — PHI only; table not implemented in De-ID Foreign-key reference to a custom OMOP concept representing the DICOM tag (i.e., data element or attribute); Will be zero if the value is unmapped to a custom OMOP concept
DICOM_TAG_SOURCE_VALUE — Yes varchar(128) — PHI only; table not implemented in De-ID The short text string that uniquely identifies the DICOM tag (or data element or attribute), used to look up the custom OMOP concept in dicom_tag_concept_id
DICOM_DATA_TYPE_CONCEPT_ID FK Yes int — PHI only; table not implemented in De-ID Foreign-key reference to a custom OMOP concept representing the data type (or “value representation”) of the DICOM tag; Will be zero if the value is unmapped to a custom OMOP concept
DICOM_DATA_TYPE_SOURCE_VALUE — Yes varchar(20) — PHI only; table not implemented in De-ID The short DICOM code that uniquely identifies the data type (or “value representation”) of the DICOM tag, used to look up the custom OMOP concept in dicom_data_type_concept_id
IS_ARRAY — Yes tinyint — PHI only; table not implemented in De-ID A Boolean value of 1 (one) if the DICOM tag holds an array of more than one value; otherwise, a Boolean value of 0 (zero). Note: DICOM tags that are sequences are not arrays; they are composite objects that contain other DICOM tags.
ARRAY_INDEX — Yes int — PHI only; table not implemented in De-ID If is_array = 1, then this column stores the ordinal position of this record’s value in the DICOM tag’s array of values, starting at zero; Scalar values always have an array_index = 0 (zero)
TAG_OCCURRENCE_NUMBER — Yes int — PHI only; table not implemented in De-ID An integer indicating the ordinal position of each occurrence of this DICOM tag, if it appears more than once within its parent DICOM tag (usually an element of a DICOM sequence); The default value is 1; Note: According to the DICOM standard, a DICOM tag should not appear more than once within its parent DICOM object, so this column accommodates any deviations from the standard
VALUE_AS_NUMBER — No float(53) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is an integer or decimal
VALUE_AS_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it corresponds to an OMOP concept from ATHENA, typically via a semantic mapping from value_as_source_concept_id
VALUE_AS_SOURCE_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it corresponds to a custom OMOP concept
VALUE_AS_CODE — No varchar(128) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it has Value Representation of CS = Code String, such as DICOM tag (0008,0100) CodeValue, (0008,0101) ExtendedCodeValue, (0008,0119) LongCodeValue, (0008,0120) URNCodeValue.
SOURCE_VOCABULARY_NAME — No varchar(128) — PHI only; table not implemented in De-ID The value of DICOM tag (0008,0102) CodingSchemeDesignator when it occurs within the same information object or sequence item as a DICOM CodeValue that is loaded to value_as_code.
VALUE_AS_STRING — No nvarchar(max) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is a string of any length, including a time-of-day value without a date. If a DICOM CodeValue is loaded to value_as_code, then this column should include the value of DICOM tag (0008,0104) CodeMeaning or (0008,0108) ExtendedCodeMeaning from the same information object or sequence item, if any.
VALUE_AS_DATETIME — No datetime2(6) — PHI only; table not implemented in De-ID The value of the DICOM tag (data element) if it is a date with or without a time of day
UNIT_CONCEPT_ID FK No int — PHI only; table not implemented in De-ID Foreign-key reference to a standard OMOP unit of measure concept, if any, associated with the value of the DICOM tag (data element)
UNIT_SOURCE_VALUE — No varchar(128) — PHI only; table not implemented in De-ID The short text string that uniquely identifies the unit of measure associated with the value of the DICOM tag, used to look up the standard OMOP unit of measure concept in unit_concept_id
ETL_RECORD_SOURCE_BUSINESS_KEY — Yes varchar(8000) — PHI only; table not implemented in De-ID The unique identifier for this record in its source system; Equal to the concatenation of the following columns in this table: imaging_series_instance_uid + ‘/’ + parent_dicom_tag_path + ‘/’ + dicom_tag_source_value + ‘[‘ + array_index + ‘]:’ + tag_occurrence_number
ETL_CREATE_LOG_ID FK Yes bigint — PHI only; table not implemented in De-ID The unique integer identifier for the ETL execution that first inserted this record into this database table
ETL_RECORD_CREATE_DATETIME — Yes datetime2(0) — PHI only; table not implemented in De-ID The date and time at which this record was first inserted into this database table
ETL_UPDATE_LOG_ID FK Yes bigint — PHI only; table not implemented in De-ID The unique integer identifier for the ETL execution that most recently updated this record in this database table
ETL_RECORD_UPDATE_DATETIME — Yes datetime2(0) — PHI only; table not implemented in De-ID The date and time at which this record was most recently updated in this database table
ETL_RECORD_VERSION_HASH_CODE — Yes binary(32) — PHI only; table not implemented in De-ID The output of the SHA2-256 cryptographic hash function for all the non-ETL columns of this record
ETL_RECORD_IS_DELETED — Yes tinyint — PHI only; table not implemented in De-ID Boolean value of 1 (one) if the record is logically deleted; 0 (zero) otherwise

Limitations

  • Linkage from IMAGING_STUDY.PROCEDURE_OCCURRENCE_ID to the corresponding OMOP procedure occurrence is not currently implemented. Do not use this field to join imaging studies to PROCEDURE_OCCURRENCE until the linkage is released and validated.

Radiology Notes (De-ID)

The Windreich Department of AI and Human Health, together with Scientific Computing and Data and the BioMedical Engineering and Imaging Institute (BMEII), is pleased to announce the release of approximately 27 million de-identified radiology notes in AI Ready Mount Sinai (AIR·MS), further expanding the platform’s multimodal clinical data resources. This new dataset provides researchers with access to de-identified radiology reports that capture rich clinical interpretations of imaging studies. 

To protect patient privacy, a robust AI-assisted de-identification pipeline combining natural language processing (NLP) and large language model (LLM) technologies was developed to remove protected health information while preserving the clinical and research value of the reports.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

 1. About the Dataset 

This dataset is one of the largest de-identified free-text datasets in the United States: by leveraging the extensive computing resources of Minerva together with the most current LLMs, we were able to process millions of radiology notes over the course of ~ 12 weeks. Data is stored in AIR·MS, together with other radiology data, and can be accessed using the CDMDEID.NOTE_IMAGING_XTN table in AIR·MS. The table schema can be described as follows:  

NOTE_IMAGING_XTN Column  Type  Description 
DEID_IMAGING_TEXT_KEY  NVARCHAR(64)  De-identified identifier for the report. Primary key for a report. One report has multiple rows, one per section. 
DEID_IMAGING_KEY  NVARCHAR(64)  De-identified identifier for the imaging exam the report describes. Multiple reports can share one exam. 
PERSON_ID  NVARCHAR(64)  De-identified patient identifier. Joins to CDMDEID.PERSON and every other CDMDEID table. 
REPORT_SECTION  NVARCHAR(32)  Which part of the report this row holds: NARRATIVE, IMPRESSION, or ADDENDA. 
NOTE_TEXT  TEXT  The de-identified report text for that section. Fulltext-indexed. 
PIPELINE_VERSION  NVARCHAR(16)  Version of the de-identification pipeline that produced the text. 
QC_PIPELINE_VERSION  NVARCHAR(16)  Version of the quality-assurance pipeline that validated it. 
SOURCE_LAST_UPDATED  NVARCHAR(16)  When the source system last updated the report. 
AIR_CREATED_AT  TIMESTAMP  When the row was loaded into AIR·MS. 
AIR_UPDATED_AT  TIMESTAMP  When the row was last updated in AIR·MS. 

  

2. Compliance-Related Considerations

 2.1 IRB (Institutional Review Board) Approval – Not Required 

Since these notes have been de-identified using a number of computational approaches, IRB approval is not required to access or use this data. This means you can quickly and easily begin incorporating this data into your investigations. 

 2.2 Terms of Use/Disclaimer 

Please note that all disclaimers and terms of use that apply to AIR·MS data apply here. Additionally, ensuring the safety of de-identified data is a shared responsibility between the de-identification team and end users. De-identification of clinical notes is still a topic of active research, and methods that are 100% accurate still do not exist in peer-reviewed literature. While we have done our best to ensure our methods are best-in-class and that no PHI has escaped the masking process, some information may still be present in the de-identified data. If you do find PHI in the de-identified data, please contact us as soon as possible by submitting a ticket, so we can investigate and modify/correct/update our pipelines and tools to account for possible masking errors and issues. Additionally, data usage is subject to the AIR·MS Data Use Agreement.

3. Radiology Notes De-Identification Process 

The de-identification of radiology notes was completed through a multi-stage workflow combining traditional NLP techniques with LLMs to maximize the detection and removal of protected health information (PHI). The de-identification process included using different NLP algorithms to do an initial pass de-identifying information, and then a LLM to do a final pass. Once the note was de-identified, it was then validated using a combination of NLP and LLM methods.  

Please note: some information has been over-redacted (such as key clinical findings, medical eponyms, other results). This is a commonly occurring artifact with many de-identification pipelines (which are highly sensitive but less specific), and we will be updating the pipeline to un-redact this information in subsequent versions.  

More details and links to pre-print manuscripts will appear here shortly, so please check back soon! 

4. Human Validation and Quality Assurance

As a final quality assurance step, a representative sample of 3,000 radiology notes underwent manual review by clinical experts to verify the accuracy and completeness of the de-identification process. Overall, this AI-assisted de-identification pipeline enables secure, compliant use of radiology data for secondary research, AI model development, and multimodal analyses. 

 

Radiology Notes (PHI)

The Windreich Department of AI and Human Health, together with Scientific Computing and Data and the BioMedical Engineering and Imaging Institute, are pleased to announce the release of over 11 million Protected Health Information (PHI) radiology notes from 1.95 million individuals on the AIR·MS (AI Ready Mount Sinai) platform, further expanding the platform’s multimodal clinical data resources. 

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

This new dataset provides researchers with access to radiology reports that capture rich clinical interpretations of imaging studies. 

To protect patient privacy, IRB approval and a signed data use agreement are required to access and use this data. This enables secure, compliant use of radiology data for secondary research, AI model development, and multimodal analyses. 

Radiology Metadata (PHI)

​
AIR·MS now features radiology metadata extracted from the Mount Sinai IRW 2.0 XNAT system (via an MSDW data pipeline). This data set is comprised of detailed DICOM (Digital Imaging and Communications in Medicine) tags associated with the medical images. These tags provide essential metadata, including patient information, imaging parameters, equipment details, and procedural context, ensuring a comprehensive understanding of each radiological study. By integrating this metadata, we enable researchers to gain deeper insights into the imaging data, facilitating advanced analyses and fostering innovations in medical imaging research.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

Current Status

Schema: CDMRADIOLOGY
Data snapshot from 8/16/2024
Unique patients: 2,057,482

The following tables and attributes are available in AIR·MS:

Number of records: 66,993,826
RADIOLOGY_METADATA
ID
PATIENT_ID
SERIES_INSTANCE_UID
STUDY_INSTANCE_UID
ETL_RECORD_UPDATE_DATETIME
Number of records: 7,745,407,087
RADIOLOGY_DICOM_DATA
ID
RADIOLOGY_METADATA_ID
DICOM_TAGS
TAG_VALUE_REPRESENTATION
TAG_VALUE” NCLOB MEMORY
TAG_XTN_PATIENT_EPIC_MRN
TAG_PATIENT_NAME
SERIES_INSTANCE_UID
STUDY_INSTANCE_UID
ETL_RECORD_UPDATE_DATETIME

Electroencephalography Metadata (PHI)

The CDMEEG schema contains identifiable electroencephalography (EEG) study metadata, EDF files, channel metadata, annotations, and EEG report notes. The study/file portion of the model follows a study-to-file hierarchy. Reports are loaded separately and may be associated with studies through source order identifiers when those identifiers agree.

This schema contains protected health information (PHI), including patient identifiers, names, birth dates, clinician names, clinical text, report text, and storage locations. Use it only in approved AIR·MS environments and do not export row-level data to an unapproved location.

To access the data, follow the AIR·MS “Getting Started” guide.

Schema Summary

HANA schema: CDMEEG
Tables: 5 column-store tables

Record Counts

Table Record count Coverage note
EEG_STUDY 314,628 314,628 distinct STUDY_UUID values
EEG_FILES 359,067 EDF files belonging to 63,120 studies
EEG_SIGNAL_METADATA 15,819,896 Channel metadata for 344,117 files
EEG_ANNOTATIONS 16,484,254 Annotations for 344,052 files
EEG_REPORT 34,385 Reports for 12,827 distinct OMOP persons

Study start dates range from May 24, 2000 through May 26, 2026. File recording start dates range from August 29, 2005 through May 2, 2026. Report service dates range from January 1, 2024 through August 31, 2026.

Model Structure

EEG_STUDY
└── EEG_FILES
    ├── EEG_SIGNAL_METADATA
    └── EEG_ANNOTATIONS

EEG_REPORT
└── separate clinical-note feed; ORDER_ID is a possible, non-enforced study link
Parent Child Logical join Relationship
EEG_STUDY EEG_FILES EEG_STUDY.EEG_STUDY_ID = EEG_FILES.EEG_STUDY_ID One study to zero or more EDF files
EEG_FILES EEG_SIGNAL_METADATA EEG_FILES.EEG_FILE_ID = EEG_SIGNAL_METADATA.EEG_FILE_ID One file to zero or more signal/channel definitions
EEG_FILES EEG_ANNOTATIONS EEG_FILES.EEG_FILE_ID = EEG_ANNOTATIONS.EEG_FILE_ID One file to zero or more annotations
EEG_STUDY EEG_REPORT EEG_STUDY.ORDER_ID = EEG_REPORT.ORDER_ID Possible source-order association; not complete or enforced

Of the 34,385 report rows, 20,767 have ORDER_ID populated and 16,380 match at least one EEG_STUDY.ORDER_ID. No declared foreign key or unique constraint makes this a guaranteed one-to-one link.

Keys

Table Primary key Other unique key
EEG_STUDY EEG_STUDY_ID STUDY_UUID
EEG_FILES EEG_FILE_ID (STORAGE_VAULT, FILE_PATH)
EEG_SIGNAL_METADATA EEG_SIGNAL_METADATA_ID —
EEG_ANNOTATIONS EEG_ANNOTATION_ID —
EEG_REPORT CLINICAL_NOTE_EPIC_ID —

Tables and Columns

Required reflects HANA nullability, not whether the source value is clinically expected. HANA TIMESTAMP values do not carry a time-zone offset.

EEG_STUDY

One row per EEG study known to the source inventory. This table combines patient and encounter identifiers, acquisition metadata, clinical or review fields, source availability flags, and pipeline status.

Column Type Required Description
EEG_STUDY_ID BIGINT Yes Internal numeric identifier for the EEG study.
STUDY_UUID NVARCHAR(64) Yes Unique study identifier used across the EEG ingestion tables.
MRN NVARCHAR(200) No Patient medical record number from the source data.
LAST_NAME NVARCHAR(100) No Patient family or last name from the source data.
FIRST_NAME NVARCHAR(100) No Patient given or first name from the source data.
BIRTH_DATE DATE No Patient date of birth from the source data.
STUDY_NAME NVARCHAR(200) No Source display name or title for the EEG study.
STUDY_TYPE NVARCHAR(50) No Broad source study category. Current values are EEG, Sleep, and Unknown after preserving source whitespace.
STUDY_TYPE_ORDER NVARCHAR(100) No Source order subtype or acquisition class, with values such as VEEG ICU, REEG INP, REEG OUTP, and VEEG EMU.
FACILITY NVARCHAR(100) No Source facility associated with the study.
HEADBOX_TYPE NVARCHAR(100) No Model or category of the EEG acquisition headbox.
ACQUIRED_ON NVARCHAR(50) No Name or code of the acquisition workstation/system.
START_TIME TIMESTAMP(7) No Start timestamp of the EEG study or recording.
END_TIME_RECORD TIMESTAMP(7) No End timestamp recorded for the EEG study.
DURATION_HMS NVARCHAR(20) No Source-formatted study duration, apparently expressed as hours, minutes, and seconds.
VISIT_ID NVARCHAR(200) No Source visit or encounter identifier.
ORDER_ID NVARCHAR(200) No Source procedure/order identifier. It can match EEG_REPORT.ORDER_ID for a subset of reports.
ORDER_NAME NVARCHAR(200) No Source name or description of the EEG order.
VISIT_NAME NVARCHAR(200) No Source label for the visit or encounter.
PROCEDURE_NAME NVARCHAR(200) No Source procedure name associated with the study.
PROCEDURE_CODE NVARCHAR(200) No Source procedure code associated with the study.
CPT_CODE NVARCHAR(200) No CPT code as supplied by the source.
REFERRING_MD NVARCHAR(200) No Referring clinician name or source-formatted identifier.
ORDERING_MD NVARCHAR(200) No Ordering clinician name or source-formatted identifier.
READING_PHYSICIAN NVARCHAR(200) No Clinician recorded as interpreting the study.
REVIEWER NVARCHAR(200) No Person recorded as reviewing the study.
REVIEWER_SIGNED NVARCHAR(200) No Source value related to reviewer sign-off.
CREATOR NVARCHAR(200) No Source value identifying the creator of the study record.
TECHNOLOGIST NVARCHAR(200) No EEG technologist name or source-formatted identifier.
INDICATIONS NVARCHAR(2000) No Clinical indication or reason for the EEG.
IMPRESSION NCLOB No Clinical impression associated with the EEG.
EEG_FINDINGS NVARCHAR(500) No Structured or short source summary of EEG findings.
EEG_FREE_TEXT NCLOB No Additional free-text EEG findings or narrative.
DIAGNOSIS NVARCHAR(1000) No Diagnosis text associated with the study.
DIAGNOSIS_CODE NVARCHAR(200) No Diagnosis code associated with the study.
ETIOLOGY NVARCHAR(500) No Source-recorded or curated etiology.
BACKGROUND_DESC NVARCHAR(500) No Description or classification of EEG background activity.
EPILEPTIFORM_ABNORMALITIES NVARCHAR(500) No Source-recorded or curated epileptiform abnormality findings.
MRI_FINDINGS NVARCHAR(1000) No MRI findings associated with the EEG study.
MEDICATION NVARCHAR(1000) No Medication information associated with the EEG study.
OTHER NVARCHAR(1000) No Additional source information not assigned to another field.
FINDINGS_NORMAL NVARCHAR(50) No Source field intended to indicate whether findings are normal.
WEIGHT_KG DECIMAL(6,2) No Patient weight in kilograms.
WEIGHT_LB DECIMAL(6,2) No Patient weight in pounds.
HEIGHT_CM DECIMAL(6,2) No Patient height in centimeters.
HEIGHT_FT DECIMAL(6,2) No Patient height represented in feet.
BMI DECIMAL(6,2) No Body mass index associated with the study.
PHOTIC NVARCHAR(50) No Source flag apparently indicating photic stimulation; observed encodings are 0, 0.0, 1, and 1.0.
IS_AVAILABLE SMALLINT No Source availability flag; observed values are 1 and null.
REVIEWED SMALLINT No Source flag indicating whether the study has been reviewed; observed values are 0 and 1.
REPORTED SMALLINT No Source flag indicating whether the study has been reported; observed values are 0 and 1.
ARCHIVED SMALLINT No Source flag indicating whether the study has been archived; observed values are 0 and 1.
RAW_DATA_ON_SYSTEM SMALLINT No Source flag indicating whether raw EEG data are present on the source system; observed values are 0 and 1.
VIDEO_RECORDED SMALLINT No Source code indicating video recording status. Most values are 0 or 1, but 3 also occurs; do not treat as Boolean without clarification.
STUDY_CONTENTS INTEGER No Undocumented source enumeration describing study contents; observed values are 0, 1, 2, 3, 5, and 6.
EEG_NUMBER NVARCHAR(200) No Source EEG accession, study, or tracking number.
SOURCE_SHEET NVARCHAR(64) Yes Name or identifier of the source sheet/file partition from which the study metadata was loaded.
AIR_CREATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS created the row; defaults to CURRENT_UTCTIMESTAMP.
AIR_UPDATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS last updated the row.
PROCESSING_STATUS NVARCHAR(32) No Study-level ingestion state. Observed values are INDEXED, PROCESSED, PARTIAL, and FAILED.
PROCESSED_AT TIMESTAMP(7) No Timestamp at which study processing completed or last reached a processed state.

EEG_FILES

One row per EDF file or EDF chunk associated with an EEG study. All 359,067 deployed file names have an .edf suffix.

Column Type Required Description
EEG_FILE_ID BIGINT Yes Internal numeric identifier for the EEG file.
EEG_STUDY_ID BIGINT Yes Parent study identifier; joins to EEG_STUDY.EEG_STUDY_ID.
STUDY_UUID NVARCHAR(64) Yes Denormalized study UUID used for tracing and reconciliation.
STORAGE_VAULT NVARCHAR(256) No Logical storage vault or storage tier containing the file.
FILE_PATH NVARCHAR(1000) Yes Path to the EDF file within its storage vault. Infrastructure-sensitive. The pair (STORAGE_VAULT, FILE_PATH) is unique.
FILE_NAME NVARCHAR(255) Yes EDF file name, including the .edf suffix.
CHUNK_INDEX INTEGER Yes Zero-based sequence number for a file chunk within the study or source recording. Observed values range from 0 to 995.
FILE_SIZE_BYTES BIGINT No File size in bytes.
FILE_HASH NVARCHAR(128) No File-content hash used for integrity or deduplication.
RECORDING_START_DATE TIMESTAMP(7) No Recording start timestamp read from or derived from the EDF file.
DURATION_SEC DOUBLE No Recording duration in seconds for this EDF file or chunk.
N_SIGNALS INTEGER No Number of signals/channels declared by the EDF file.
PATIENT_CODE NVARCHAR(100) No Patient code extracted from the EDF header.
PATIENT_NAME NVARCHAR(200) No Patient name extracted from the EDF header.
EQUIPMENT NVARCHAR(200) No Recording equipment information extracted from the EDF header or source metadata.
PROCESSING_STATUS NVARCHAR(32) No File-level pipeline state; currently PROCESSED or FAILED.
STATUS_CODE NVARCHAR(16) No Pipeline result code; observed values are 200 and 415.
JSON_STATUS NCLOB No JSON-formatted diagnostic or processing result payload.
PROCESSING_ATTEMPTS INTEGER Yes Number of processing attempts for the file; defaults to 0.
LAST_ATTEMPT_AT TIMESTAMP(7) No Timestamp of the most recent processing attempt.
PROCESSED_AT TIMESTAMP(7) No Timestamp at which file processing completed successfully.
AIR_CREATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS created the row; defaults to CURRENT_UTCTIMESTAMP.
AIR_UPDATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS last updated the row.
ENCRYPTION_STATUS NVARCHAR(32) No File encryption/lifecycle state; defaults to PENDING. Observed values are PENDING and VAULT_ONLY.
ENCRYPTION_JSON_STATUS NCLOB No JSON-formatted diagnostic or result payload for encryption/lifecycle processing.
ENCRYPTED_AT TIMESTAMP(7) No Timestamp at which an encrypted copy of the file was produced or registered.
PLAINTEXT_DELETED_AT TIMESTAMP(7) No Timestamp at which the plaintext file was deleted after encryption or transfer.

EEG_SIGNAL_METADATA

One row per signal/channel definition in an EDF file. These fields correspond to common EDF per-signal header attributes.

Column Type Required Description
EEG_SIGNAL_METADATA_ID BIGINT Yes Internal numeric identifier for the signal-metadata row.
EEG_FILE_ID BIGINT Yes Parent file identifier; joins to EEG_FILES.EEG_FILE_ID.
STUDY_UUID NVARCHAR(64) Yes Denormalized parent study UUID used for tracing and reconciliation.
SIGNAL_INDEX INTEGER Yes Zero-based ordinal position of the signal/channel in the EDF file.
LABEL NVARCHAR(50) No Signal/channel label from the EDF header, such as an electrode or auxiliary-channel name.
DIMENSION NVARCHAR(20) No Physical dimension or unit text from the EDF signal header, such as uV.
SAMPLE_FREQUENCY DOUBLE No Number of samples per second for this signal/channel.
PHYSICAL_MAX DOUBLE No Maximum physical value used to scale digital samples for this signal.
PHYSICAL_MIN DOUBLE No Minimum physical value used to scale digital samples for this signal.
DIGITAL_MAX INTEGER No Maximum digital sample value declared for this signal.
DIGITAL_MIN INTEGER No Minimum digital sample value declared for this signal.
PREFILTER NVARCHAR(200) No Prefiltering information from the EDF signal header.
TRANSDUCER NVARCHAR(200) No Transducer type or sensor description from the EDF signal header.
AIR_CREATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS created the row; defaults to CURRENT_UTCTIMESTAMP.
AIR_UPDATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS last updated the row.

EEG_ANNOTATIONS

One row per annotation extracted from an EDF file. Annotations are positioned relative to the recording timeline.

Column Type Required Description
EEG_ANNOTATION_ID BIGINT Yes Internal numeric identifier for the annotation.
EEG_FILE_ID BIGINT Yes Parent file identifier; joins to EEG_FILES.EEG_FILE_ID.
STUDY_UUID NVARCHAR(64) Yes Denormalized parent study UUID used for tracing and reconciliation.
ANNOT_INDEX INTEGER Yes Ordinal position of the annotation within the EDF file.
ONSET_SEC DOUBLE No Annotation onset in seconds relative to the file recording start.
DURATION_SEC DOUBLE No Annotation duration in seconds, when supplied.
DESCRIPTION NVARCHAR(2000) No Annotation text from the EDF file.
AIR_CREATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS created the row; defaults to CURRENT_UTCTIMESTAMP.
AIR_UPDATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS last updated the row.

EEG_REPORT

One row per loaded EEG-related clinical note. This table is keyed by an Epic clinical-note identifier and includes OMOP linkage fields when available. It is not structurally attached to the study/file hierarchy by a declared foreign key.

Column Type Required Description
CLINICAL_NOTE_EPIC_ID NVARCHAR(64) Yes Unique Epic clinical-note identifier.
ORDER_ID NVARCHAR(200) No Source order identifier. It matches EEG_STUDY.ORDER_ID for a subset of report rows, but the relationship is not enforced.
PERSON_ID BIGINT No OMOP person identifier for the patient associated with the report.
VISIT_OCCURRENCE_ID BIGINT No OMOP visit-occurrence identifier associated with the report.
PROCEDURE_OCCURRENCE_ID BIGINT No OMOP procedure-occurrence identifier associated with the report.
XTN_EPIC_PATIENT_ID NVARCHAR(50) No Epic patient identifier from the report source/extract.
XTN_EPIC_ENCOUNTER_NUMBER BIGINT No Epic encounter number from the report source/extract.
XTN_EPIC_PROCEDURE_ORDER_ID NVARCHAR(50) No Epic procedure-order identifier from the report source/extract. It does not currently match EEG_STUDY.ORDER_ID in the deployed data.
REPORT_TEXT TEXT Yes Full clinical EEG report text. Full-text indexed in HANA.
SERVICE_DATETIME TIMESTAMP(7) Yes Clinical service date and time associated with the report.
CREATION_DATETIME TIMESTAMP(7) No Timestamp at which the clinical note was created in the source.
LAST_EDITED_DATETIME TIMESTAMP(7) No Timestamp of the most recent source edit to the clinical note.
NOTE_STATUS NVARCHAR(64) Yes Source note status; currently Signed or Addendum.
NOTE_TYPE NVARCHAR(64) Yes Source note type; currently Procedures.
NOTE_SERVICE NVARCHAR(128) Yes Source clinical service associated with the note.
AIR_CREATED_AT TIMESTAMP(7) Yes Timestamp at which AIR·MS created the row; defaults to CURRENT_TIMESTAMP.
AIR_UPDATED_AT TIMESTAMP(7) No Timestamp at which AIR·MS last updated the row.

Echocardiography Metadata (PHI)

AIR·MS contains DICOM metadata tags for cardiovascular imaging studies performed in the Mount Sinai Health System that are contained within the Softlink cardiovascular PACS system. This does not include radiology data contained within the radiology PACS systems. The following common modalities include US, CT, XA, NM, MR, IVUS. These modalities include, among others, echocardiographic ultrasound, vascular ultrasound, and angiographic data. These tags are linked to DICOM files by ECHO_METADATA.IMAGE_FILE_PATH in a repository on the Minerva cluster. Note that the schema name CDMECHO is a misnomer – this catalog contains much more than echocardiogram data.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

The catalog contains every public DICOM metadata tag (dictionaries are publicly available, see https://dicom.innolitics.com/ciods for instance). The Tag is under ECHO_TAGS_DATA.TAGS and is labeled by its Name not its hexadecimal number for ease of readability (see https://www.dicomlibrary.com/dicom/dicom-tags/ for dictionary of public tags and name). The value of the tag is under ECHO_TAGS_DATA.TAG_VALUE.

Notes:

  • As of late August 2025, there are known significant gaps in data availability around year 2019 and starting in mid 2023 and onward. The catalog ends in late 2023. Mechanisms for capturing missing data and updating the catalog moving forward are underway.
  • There will be some duplicated data within the archive (i.e. 2 identical studies may be in 2 separate paths)
  • There is a known bug in the way the value representation of “Person Name” is stored. It is stored as a list of single characters rather than a string (i.e. the name Smith is stored as [S,m,i,t,h])

Current Status

 

Schema: CDMECHO
Data snapshot from: 10/17/2023
Unique patients: 885,957

The following tables and attributes are available in AIR·MS:

Number of records: 268,682,931
ECHO_METADATA
ID
FILE_ENTRY_ID
PATIENT_ID
SERIES_INSTANCE_UID
STUDY_INSTANCE_UID
SOP_INSTANCE_UID
IMAGE_FILE_PATH
AIR_CREATED_AT
AIR_UPDATED_AT
Number of records: 21,089,507,788
ECHO_TAGS_DATA
ID
FILE_ENTRY_ID
SERIES_INSTANCE_UID
STUDY_INSTANCE_UID
SOP_INSTANCE_UID
TAGS
TAG_VALUE
AIR_CREATED_AT
AIR_UPDATED_AT

 

Endoscopy Reports (PHI)

AIR·MS contains a catalog of gastroenterology endoscopy reports stored in PDF format on Minerva. The reports are for a subset of these procedures wherein the reporting system (Provation MD, Endoworks) transmits the reports as PDF files to Epic. Provation Apex and gGastro reports, including those from the Ansonia and ECNY sites are not currently included.

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

These are intended to be linked to the OMOP CDM via the latter’s person table. We do not currently link it to procedure records in procedure_occurrence. Various date fields related to the document and its transmission to the Epic system are available, but their validity can’t be guaranteed and filtering on those columns should be done with caution.

Number of records: 428,430

REPORTS
FILE_ENTRY_ID: surrogate primary key; one row = one
report
FILE_PATH: absolute path on Arion filesystem. Will be
updated to be relative to gocryptfs mountpoint in a
future release.
FILE_NAME: file name of report in PDF format
DOC_PT_ID: Epic ID; join to
CDMPHI.PATIENT.XTN_EPIC_PATIENT_ID
EPIC_MRN: MSMRN; Epic ID; join to
CDMPHI.PATIENT.XTN_PATIENT_EPIC_MRN
ORDER_PROC_ID: Epic Order ID
DOC_RECV_TIME: The date and time the document was
received by Epic*.
SCAN_TIME: The date and time the document was
scanned*.
DOC_SRVC_DTTM: The date and time the service
described in the document was rendered*.

* These columns are loaded from Epic, but their accuracy may vary based on a
variety of circumstances and cannot be guaranteed

 

Synthetic Public Use File (DE-SynPUF)

The SYNPUF (Synthetic Public Use Files) dataset, provided by the Centers for Medicare & Medicaid Services (CMS), offers a synthetic version of Medicare claims data from the years 2008 to 2010. This dataset is meticulously designed to maintain the statistical properties and relationships present in the original data while ensuring that no actual patient information is disclosed, thereby safeguarding privacy. SYNPUF includes a comprehensive array of variables such as beneficiary demographics, chronic conditions, hospital and outpatient claims, and prescription drug events, making it an invaluable resource for researchers and data scientists. It serves as an exemplary tool for developing and testing healthcare models, algorithms, and applications without the constraints associated with sensitive real-world data. The SYNPUF dataset in AIR·MS utilizes the OMOP Common Data Model, aligned with other clinical data sets available on the platform. Since SYNPUF data does not require an approved IRB, you can easily get onboarded and start building ML models!

To access the data, follow our “Getting Started” guide here: https://labs.icahn.mssm.edu/minervalab/air%E2%80%A7ms-getting-started/ 

Current Status

Schema: CDMSYNPUF
Number of patients: 2,326,856
Number of observations: 37,531,051
Number of measurements: 72,387,791