Hospital Readmission Prediction Dataset

This dataset provides comprehensive, visit-level hospital data for predicting patient readmission risk, including demographics, diagnoses, treatments, medications, and outcomes. It enables advanced analytics and machine learning for care management, resource allocation, and quality improvement in healthcare settings. The dataset is ideal for developing predictive models, benchmarking hospital performance, and supporting population health initiatives.

  • opened 18 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Building machine learning models to predict hospital readmission risk

Sample rows

preview · 8 of 200 rows · all 24 columns
patient_idstringdischarge_dispositionstringnum_medicationsintegerreadmitted_within_30_daysbooleansecondary_diagnosis_codestringvisit_idstringadmission_datedatedischarge_datedateageintegergenderstringracestringprimary_diagnosis_codestringcomorbiditiesstringprocedure_codestringlength_of_stay_daysintegerinsurance_typestringnum_prior_admissionsintegerattending_physician_idstringhospital_idstringadmission_typestringadmission_sourcestringvital_signs_on_admissionstringlab_results_on_admissionstringmedication_liststring
P0001skilled nursing facility9falseblankV1000012023-01-072023-01-1074femalewhiteI10hypertension,diabetes992133Medicare4DR101H001emergencyemergency roomBP:144/82,HR:92,O2:96%WBC:9.2,HGB:13.1,CRE:1.1lisinopril,metformin,atorvastatin,aspirin,insulin,amlodipine,omeprazole,metoprolol,simvastatin
P0002home1falseblankV1000022023-01-082023-01-092maleblackJ21.9blankblank1Medicaid0DR102H002newbornphysician referralBP:94/58,HR:108,O2:99%WBC:7.5,HGB:11.7,CRE:0.3albuterol
P0003rehab13trueI25.10V1000032023-01-122023-01-1781femaleotherE11.9hypertension,diabetes,hyperlipidemia,osteoporosis992145Medicare8DR103H003emergencyemergency roomBP:156/90,HR:88,O2:94%WBC:7.9,HGB:12.8,CRE:1.5metformin,atorvastatin,aspirin,insulin,omeprazole,amlodipine,simvastatin,losartan,levothyroxine,clopidogrel,hydrochlorothiazide,alprazolam,glipizide
P0004home2falseblankV1000042023-01-202023-01-215femaleasianJ45.909blank940101Medicaid0DR104H002emergencyemergency roomBP:98/54,HR:116,O2:97%WBC:6.8,HGB:12.1,CRE:0.4albuterol,fluticasone
P0005home3falseblankV1000052023-02-012023-02-0854malehispanicM54.5hypertension205527Private2DR105H004electivephysician referralBP:129/76,HR:84,O2:99%WBC:7.2,HGB:14.2,CRE:1.0acetaminophen,ibuprofen,lisinopril
P0006home2falseblankV1000062023-02-022023-02-0542maleasianS06.0X0Ablank992853Private1blankH005traumatransferBP:122/72,HR:102,O2:97%WBC:8.3,HGB:15.0,CRE:0.9acetaminophen,ondansetron
P0007home2falseblankV1000072023-02-062023-02-0833femalewhiteF32.1depression908342Private0DR106H003electivephysician referralBP:124/78,HR:76,O2:100%WBC:6.5,HGB:13.6,CRE:0.9sertraline,lorazepam
P0008home1falseblankV1000082023-02-102023-02-1324malepacific islanderS82.101Ablank277863Self-pay0blankH006traumaemergency roomBP:120/72,HR:98,O2:99%WBC:8.7,HGB:14.8,CRE:1.0acetaminophen

What the 200 rows show

from the 200-row sample

Skilled nursing facility (discharge disposition) stands out: mean num_medications is 11.9, against 3.5 for the rest.

  • 5%readmitted_within_30_days = true
  • 2median num_medications
  • 3genders
  • 3admission sources
  • 5insurance types
  • 5admission types
Mean num_medications by discharge_disposition200 rows
010202.3home145 rows11.9skilled …25 rows10.3rehab22 rows6.1home hea…8 rows
num_medications200 rows, in bands of 2
04080487223911141760816num_medications →

Median 2, from 1 to 16.

secondary_diagnosis_code23 rows with a value · 177 left blank
  1. I109
  2. E78.57
  3. E11.96
  4. I25.101
24 columns by typefrom the column list below
  • string 17
  • integer 4
  • date 2
  • boolean 1

Columns

24 columns in four groups
blueprint · 24 columns
columntypedescriptionexample
Text 17 columns
patient_idstringUnique identifier for each patient in the datasetP0001
visit_idstringUnique identifier for each hospital visit or admissionuniqueV100001
genderstringGender of the patientmale · female · other · unknownfemale
racestringRace or ethnicity of the patientoptionalwhite
primary_diagnosis_codestringPrimary diagnosis code (e.g., ICD-10) for the visitI10
secondary_diagnosis_codestringSecondary diagnosis code (if any) for the visit4 codes · optionalI25.10
comorbiditiesstringComma-separated list of comorbid conditions present during the visitoptionalhypertension,diabetes
procedure_codestringPrimary procedure code performed during the visit (e.g., CPT, ICD-10-PCS)optional99213
discharge_dispositionstringDisposition at discharge (e.g., home, skilled nursing facility, deceased, rehab, etc.)4 dispositionsskilled nursing facility
insurance_typestringType of insurance coverage (e.g., Medicare, Medicaid, Private, Self-pay, Other)5 types · optionalMedicare
medication_liststringComma-separated list of medications prescribed during the visitoptionalalbuterol
attending_physician_idstringIdentifier for the attending physician during the visitoptionalDR101
hospital_idstringIdentifier for the hospital where the visit occurredH001
admission_typestringType of admission (e.g., emergency, elective, urgent, newborn, trauma)5 typesemergency
admission_sourcestringSource of admission (e.g., physician referral, transfer, emergency room)3 sources · optionalemergency room
vital_signs_on_admissionstringComma-separated key:value pairs of vital signs (e.g., BP:120/80, HR:72) on admissionoptionalBP:144/82,HR:92,O2:96%
lab_results_on_admissionstringComma-separated key:value pairs of key lab results on admission (e.g., WBC:7.2, HGB:13.5)optionalWBC:9.2,HGB:13.1,CRE:1.1
Numbers 4 columns
ageintegerAge of the patient at the time of admission0 to 12074
length_of_stay_daysintegerNumber of days between admission and discharge1 or more3
num_prior_admissionsintegerNumber of prior hospital admissions for the patient0 or more · optional4
num_medicationsintegerNumber of medications prescribed during the visit0 or more · optional9
Dates and times 2 columns
admission_datedateDate when the patient was admitted to the hospital2023-01-07
discharge_datedateDate when the patient was discharged from the hospital2023-01-10
True or false 1 column
readmitted_within_30_daysbooleanIndicates if the patient was readmitted within 30 days of discharge (true/false)false

15 SQL practice questions for the Hospital Readmission Prediction Dataset

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Long emergency stays

    Return visit_id, patient_id and length_of_stay_days for emergency admissions (admission_type = 'emergency') with a length_of_stay_days of at least 10. Order the results by length_of_stay_days descending, then by visit_id ascending.

    Tables: hospital_readmission_prediction_dataset · your result: 3 columns, 12 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct discharge dispositions

    Return each distinct value of discharge_disposition once, as a single column named discharge_disposition, sorted alphabetically.

    Tables: hospital_readmission_prediction_dataset · your result: 1 columns, 4 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Visits per admission type

    Return admission_type and the number of visits for each type as visit_count. Order by visit_count descending, then by admission_type ascending.

    Tables: hospital_readmission_prediction_dataset · your result: 2 columns, 5 rows
  1. 04Average stay by insuranceBeginner
  2. 05Readmissions by hospital visualPower BI
  3. 06Diagnoses with high readmissionIntermediate
  4. 07Age band readmissionsIntermediate
  5. 08Hospitals above average stayIntermediate
  6. 09Monthly admissionsIntermediate
  7. 10Readmission rate card by genderPower BI
  8. 11Rank hospitals by readmission rateAdvanced
  9. 12Days since previous visitAdvanced
  10. 13Running total of monthly admissionsAdvanced
  11. 14Share of readmissions by dispositionAdvanced
  12. 15Stay length anomalies per hospitalPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • readmitted wit…5%9 of 200 rowsmean num medications …2.3home11.9skil…10.3rehab6.1home…

    A healthcare dashboard

    The readmitted_within_30_days rate, num_medications by discharge_disposition and a breakdown of secondary_diagnosis_code. Excel, Power BI or Tableau.

  • Why do the 25 skilled nursing facility rows have a mean num_medications of 11.9?

    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 patients with visit_id, admission_date and discharge_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 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 rows24 columns
Yours1,000 rows24 columns

blueprint · hospital-readmission-prediction-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 24 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
  • Readmission within 30 days flagged
  • Patients under 18 excluded
  • Diagnosis codes mapped to ICD-10
  • Only completed discharges included
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-readmission-prediction-dataset

What should your data show?

Preview 20 rows free
No signup. No card.