Skip to contents

SEM Emergency Department Patient Registry Dataset (2017-2018)

patientligg_sem.Rd

This dataset contains information about emergency department visits during 2017-2018 from the Patientliggaren (Patient Registry) system. It includes patient demographics, visit timings, triage information, and outcomes.

Usage

patientligg_sem()

Format

A data frame with 632,785 observations and 16 variables:

contact_id

Character. Unique identifier for each healthcare contact/encounter, serves as a foreign key to link with other datasets. 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

hospital_id

Character. Healthcare facility identifier code. Original field name: AktuellSjukhusId

hospital_name

Character. Name of the hospital where the visit occurred. Original field name: Sjukhus_Namn

chief_complaint

Character. Code representing the patient's chief complaint. Original field name: BesokOrsak_Kod

chief_complaint_description

Character. Detailed description of the chief complaint, including RETTS (Rapid Emergency Triage and Treatment System) ESS (Emergency Signs and Symptoms) number references. Original field name: BesokOrsak_Beskrivning

arrival_time

POSIXct. Date and time when the patient arrived at the emergency department. Original field name: Vardkontakt_InskrivningDatum

discharge_time

POSIXct. Date and time when the patient was discharged from the emergency department. Original field name: Vardkontakt_UtskrivningDatum

age_at_arrival

Integer. Patient's age in years at the time of arrival. Original field name: Vardkontakt_PatientAlderVidInskrivning

gender

Character. Patient's gender ("M" = Male, "F" = Female). Original field name: Patient_Kon

discharged_to

Character. Destination or outcome at discharge (e.g., "Hemmet" = Home, "Avdelning" = Ward, "Avlidit" = Deceased). Original field name: Utskriven till

admission_ward

Character. Ward to which the patient was admitted if hospitalized. Contains NA values for patients not admitted to a ward. Original field name: Inläggningsavdelning

ed_care_time_mins

Numeric. Total time spent in the emergency department in minutes, from arrival to discharge. Original field name: Vårddtid på akuten i minuter

time_to_physician_mins

Numeric. Time in minutes from arrival until first physician contact. Original field name: Tid till läkare på akuten i minuter

first_physician_contact_time

POSIXct. Timestamp of the first physician contact. Original field name: Första läkarkontakten på akuten

left_without_recommendation

Logical. Whether the patient left against medical advice (1 = Yes, 0 = No). Original field name: Avvikit mot rekommendation

admitted_to_hospital

Logical. Whether the patient was admitted to inpatient care (1 = Yes, 0 = No). Original field name: Inlagd

process_text

Character. Text snippet describing the care process. Original field name: Process_text

follow_up_parameter_text

Character. Text describing follow-up parameters, often incomplete. Original field name: UppföljningParameter_text

triage_priority

Character. Triage priority category assigned to the patient (Red, Orange, Yellow, Green, Blue from highest to lowest urgency). Original field name: Triagekategori

triage_priority_num

Integer. Numeric representation of triage priority: 1 = Red (highest urgency), 2 = Orange, 3 = Yellow, 4 = Green, 5 = Blue (lowest urgency). Derived from Triagekategori

triage_time

POSIXct. Date and time when the patient was triaged. Original field name: Handelse_HandelseDatum

Source

Patientliggaren, Skåne Region

Details

This dataset contains emergency department visits recorded in the Patientliggaren (Patient Registry) system during 2017-2018. The Patientliggaren is a logistic system used by healthcare staff to track patient location and processes, and serves as a source for the SVAR (Svenska Akutvårdsregistret) system.

The dataset includes information about patient demographics, chief complaints (often with RETTS ESS codes), triage priorities, timestamps for key events during the emergency department stay, and outcomes including discharge destination and hospital admission.

Triage categories follow the standard color coding system:

  • Red: Immediately life-threatening conditions requiring immediate attention

  • Orange: Potentially life-threatening conditions requiring urgent attention

  • Yellow: Serious but stable conditions requiring prompt attention

  • Green: Less urgent conditions

  • Blue: Non-urgent conditions

This dataset includes both the triage category information and the timestamp when triage occurred, merged from two separate source files.

Note

  • Several fields from the original dataset have been omitted for efficiency:

    • BesokOrsakId (chief_complaint_id): Numeric identifier for the chief complaint that adds little analytical value beyond the chief_complaint field

    • PrioritetId: Numeric identifier related to triage priority that is redundant with the more informative triage_priority field

  • For patients admitted to hospital wards, the admission_ward field contains the name of the ward

  • Time measurements (ed_care_time_mins, time_to_physician_mins) are in minutes

  • Some records may have missing values for triage_priority if triage data was not recorded

  • The discharged_to field contains various destinations including "Hemmet" (Home), "Avdelning" (Ward), "Avlidit" (Deceased), and others

  • The chief_complaint_description often includes references to RETTS ESS numbers which are standardized emergency signs and symptoms codes used in triage

  • Some process_text and follow_up_parameter_text fields may contain incomplete information