Hospital Emergency Visit Records

This dataset provides detailed, de-identified records of emergency department visits, including patient demographics, triage assessments, vital signs, diagnoses, procedures, and outcomes. It enables robust analysis of triage algorithms, patient flow, and clinical outcomes, supporting research and quality improvement in emergency medicine.

  • opened 7 times
  • last updated 22 Jul 2025
  • by GoMask
The brief that made it

Development and validation of emergency department triage algorithms

Sample rows

preview · 8 of 200 rows · all 21 columns
visit_idstringdispositionstringlength_of_stay_minutesintegervital_signs_recordedbooleanprocedure_codestringpatient_idstringvisit_datetimedatetimeageintegersexstringtriage_levelstringchief_complaintstringheart_rateintegerblood_pressure_systolicintegerblood_pressure_diastolicintegerrespiratory_rateintegertemperature_celsiusfloatoxygen_saturationfloatdiagnosis_code_primarystringdiagnosis_code_secondarystringdisposition_datetimedatetimehospital_idstring
EDV00001discharged155trueblankPAT100012024-01-04T07:43:12Z4female3Fever and rash for two days13284483138.297.5B08.4blank2024-01-04T10:18:12ZHSP001
EDV00002admitted182true92950PAT100022024-01-13T18:32:45Z68male2Chest pain radiating to left arm96132832336.891.1I20.9R07.22024-01-13T21:34:45ZHSP002
EDV00003discharged70trueblankPAT100032024-01-12T22:15:10Z33other4Mild abdominal pain after dinner77112721537.198.2R10.9blank2024-01-12T23:25:10ZHSP003
EDV00004admitted240trueblankPAT100042024-01-02T05:08:44Z2male3Cough and wheezing14676523637.795.3J21.9blank2024-01-02T09:08:44ZHSP001
EDV00005admitted197true31500PAT100052024-01-10T14:59:32Z57female2Difficulty breathing and dizziness103107602736.388.7J44.1R422024-01-10T18:16:32ZHSP004
EDV00006deceased50true92950PAT100062024-01-14T01:12:03Z88female1Unresponsive, found at home415832933.268.4R40.20I95.92024-01-14T02:02:03ZHSP003
EDV00007discharged21falseblankPAT100072024-01-08T11:17:51Z27male5Medication refill requestblankblankblankblankblankblankZ76.0blank2024-01-08T11:38:51ZHSP002
EDV00008discharged65trueblankPAT100082024-01-03T16:13:17Z44female4Migraine headache81116681436.799G43.9blank2024-01-03T17:18:17ZHSP005

What the 200 rows show

from the 200-row sample

Admitted disposition stands out: mean length_of_stay_minutes is 229.6, against 85.5 for the rest.

  • 86%vital_signs_recorded = true
  • 112.5median length_of_stay_minutes
  • 4sexes
  • 6triage levels
  • 32hospitals
  • 40.5median age
Mean length_of_stay_minutes by disposition200 rows
0200400229.6admitted59 rows86.7discharg…123 rows139.7transfer…7 rows38.0deceased11 rows
length_of_stay_minutes200 rows, in bands of 50
0306038563631188101110250500length_of_stay_minutes →

Median 112.5, from 10 to 480.

procedure_code81 rows with a value · 119 left blank
  1. 9295013
  2. 940026
  3. 120016
  4. 315005
  5. 291255
  6. 371875
  7. 963655
  8. 295154
  9. 992913
  10. 704502
21 columns by typefrom the column list below
  • string 10
  • integer 6
  • float 2
  • datetime 2
  • boolean 1

Columns

21 columns in four groups
blueprint · 21 columns
columntypedescriptionexample
Text 10 columns
visit_idstringUnique identifier for each emergency department visit.uniqueEDV00001
patient_idstringUnique identifier for the patient (de-identified).PAT10001
sexstringSex of the patient.male · female · other · unknownfemale
triage_levelstringTriage level assigned at arrival (e.g., Emergency Severity Index or local scale).6 values3
chief_complaintstringPrimary reason for the emergency visit as reported by the patient.Cough and wheezing
diagnosis_code_primarystringPrimary diagnosis code assigned (e.g., ICD-10).B08.4
diagnosis_code_secondarystringSecondary diagnosis code, if applicable.optionalR07.2
procedure_codestringProcedure code for major interventions performed during the visit.optional92950
dispositionstringOutcome of the visit (e.g., admitted, discharged, transferred, deceased, left against medical advice).6 valuesdischarged
hospital_idstringIdentifier for the hospital or emergency department location.HSP001
Numbers 8 columns
ageintegerAge of the patient at the time of visit (in years).0 to 1204
heart_rateintegerHeart rate measured at triage (beats per minute).0 to 300 · optional132
blood_pressure_systolicintegerSystolic blood pressure measured at triage (mmHg).40 to 300 · optional84
blood_pressure_diastolicintegerDiastolic blood pressure measured at triage (mmHg).20 to 200 · optional48
respiratory_rateintegerRespiratory rate measured at triage (breaths per minute).0 to 100 · optional31
temperature_celsiusfloatBody temperature measured at triage (Celsius).25 to 45 · optional38.2
oxygen_saturationfloatOxygen saturation measured at triage (%).0 to 100 · optional97.5
length_of_stay_minutesintegerTotal length of stay in the emergency department (in minutes).0 or more · optional155
Dates and times 2 columns
visit_datetimedatetimeDate and time when the patient arrived at the emergency department.2024-01-04T07:43:12Z
disposition_datetimedatetimeDate and time of patient disposition from the emergency department.optional2024-01-04T10:18:12Z
True or false 1 column
vital_signs_recordedbooleanIndicates whether vital signs were recorded at triage.true

Use it for

  • vital signs re…86%171 of 200 rowsmean length of stay m…229.6admi…86.7disc…139.7tran…38.0dece…

    A healthcare dashboard

    The vital_signs_recorded rate, length_of_stay_minutes by disposition and a breakdown of procedure_code. Excel, Power BI or Tableau.

  • Why do the 59 admitted rows have a mean length_of_stay_minutes of 229.6?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable visits with patient_id, visit_datetime and age to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows21 columns
Yours1,000 rows21 columns

blueprint · hospital-emergency-visit-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each record logs visit, timestamp, and chief complaint.
  • Diagnosis, treatment, and outcome fields included.
  • Severity score assigned at triage.
  • Patient demographics anonymized.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
hospital-emergency-visit-records

What should your data show?

Preview 20 rows free
No signup. No card.