Skip to contents

Post-SEM Inpatient Hospital Stay Dataset (After Discharge through Dec 31, 2019)

melior_post_sem_inpatient_stays.Rd

This dataset contains information about inpatient hospital stays for patients in the SEM cohort from the Melior journal system, including duration metrics in both minutes and days. The data represents hospital stays with discharge dates up to December 31, 2019 that occurred after patients' enrollment in the SEM cohort.

Usage

melior_post_sem_inpatient_stays()

Format

A data frame with 396,245 observations and 4 variables:

contact_id

Character. Unique identifier for each healthcare contact/encounter, serves as a foreign key to link with other datasets. 396,245 unique values. Original field name: KontaktId

patient_id

Integer. Patient pseudonym identifier, serves as a foreign key to link with other patient-level data. Original field name: Alias

duration_minutes

Integer. Duration of hospital stay in minutes. Range: 0 to 6,159,473 minutes (approximately 0 to 11.7 years). Median: 3,974 minutes (approximately 2.8 days). Mean: 22,104 minutes (approximately 15.4 days). Original field name: AntalMinuter

duration_days

Numeric. Duration of hospital stay in days. Converted from character with comma as decimal separator to numeric with period. Original field name: AntalDagar

Source

Melior

Details

This file was extracted from the Melior electronic health record system. The original filename indicates it contains information about inpatient hospital stays (SlutenVårddagar) with discharge dates (UtskrivningDatum) up to December 31, 2019 (Till_20191231) that occurred after patients' enrollment in the SEM cohort (Efter_Vardkontakt).

The dataset provides hospital stay duration information in both minutes and days, allowing for precise temporal analysis of inpatient resource utilization after the initial SEM cohort contact.

Note

  • The original AntalDagar field uses comma as decimal separator and is stored as character, this is normalized in the data cleaning.

  • Duration is provided in both minutes (duration_minutes) and days (duration_days)

  • The dataset should be used in conjunction with post_sem_inpatient_hours.csv for a comprehensive view of post-discharge inpatient care utilization

  • The data includes some very long stays (up to 6,159,473 minutes or approximately 11.7 years), which undoubtfully represents errounous data.

  • This dataset contains fewer records than post_sem_inpatient_hours.csv (396,245 vs. 632,785), suggesting it may be capturing a different subset of inpatient stays

Examples