SNUH CDM Deceased Subset contains comprehensive clinical data organized according to the OMOP (Observational Medical Outcomes Partnership) Common Data Model, covering patients with confirmed in-hospital death treated at Seoul National University Hospital between October 2004 and December 2024.

1. Overview

Population: 25,253 patients with confirmed in-hospital death, extracted from the SNUH CDM cohort
Data period: October 2004 – December 2024
Inclusion criterion: death_datetime recorded within an inpatient visit_occurrence period (in-hospital death only; deaths outside the hospital are not included)
Standard terminology mappings — Condition: SNOMED-CT, Drug: RxNorm, Measurement: LOINC, Procedure: SNOMED-CT

2. Major Domains

2.1 Person

person_id: Unique patient identifier
year_of_birth / month_of_birth : Date of birth
gender_concept_id: Gender information
race_concept_id: Race information
ethnicity_concept_id: Ethnicity information
location_id: Residence information

2.2 Death

person_id: Patient identifier
death_date / death_datetime: Date and time of in-hospital death
death_type_concept_id: Source/type of death information (limited to in-hospital death records)
visit_occurrence_id: The inpatient visit during which death occurred

2.3 Visit_Occurrence

visit_occurrence_id: Unique visit identifier
person_id: Patient identifier
visit_concept_id: Visit type (outpatient/inpatient/emergency)
visit_start_date: Visit start date
visit_end_date: Visit end date (equal to date of death for the terminal inpatient visit)

2.4 Condition_Occurrence

condition_occurrence_id: Unique diagnosis identifier
person_id: Patient identifier
condition_concept_id: OMOP concept ID for SNOMED CT
condition_start_date: Diagnosis start date
condition_end_date: Diagnosis end date
visit_occurrence_id: Related visit information

2.5 Drug_Exposure

drug_exposure_id: Unique medication identifier
person_id: Patient identifier
drug_concept_id: OMOP concept ID for RxNorm
drug_exposure_start_date: Medication start date
drug_exposure_end_date: Medication end date
quantity: Total prescribed quantity
visit_occurrence_id: Related visit information

2.6 Procedure_Occurrence

procedure_occurrence_id: Unique procedure identifier
person_id: Patient identifier
procedure_concept_id: OMOP concept ID for SNOMED CT
procedure_date: Procedure date
visit_occurrence_id: Related visit information

2.7 Measurement

measurement_id: Unique test identifier
person_id: Patient identifier
measurement_concept_id: OMOP concept ID for LOINC
measurement_date: Measurement date
value_as_number: Numeric result value
value_as_concept_id: Categorical result value
unit_concept_id: Unit information
visit_occurrence_id: Related visit information