Analytics & dashboardsHealth
Diabetes readmissions
Which diabetic patients keep coming back to the hospital within 30 days, and why
101,766hospital visits analyzed
Proof you can check:Public data
Analytics & dashboards
Patients on 16+ medications come back 67% more often
- 7.48%5 or fewer5,066 visits
- 9.45%6 to 1020,795 visits
- 10.91%11 to 1529,384 visits
- 12.48%16 or more46,521 visits
Lubo Bali · lubobali.com
The problem
Hospitals pay for patients who come back within 30 days, and Medicare ties payment to these outcomes. Which diabetic patients keep coming back, and what could a hospital change before they go home?
What I built
Six SQL questions over real, anonymized records from 130 US hospitals: how many medications, insulin vs metformin, treatment changes during the stay, the doctor's specialty, and lab tests skipped before discharge.
Tech & why
Plain SQL group-by questions, so a hospital analyst can rerun the same checks on their own database every month.
- SQL
- MySQL
The result
More medications, more returns: 12.48% came back at 16+ medications vs 7.48% at 5 or fewer. Patients sent home without an A1C or glucose test came back more often (11.42% vs as low as 8.87%).
Data: Diabetes 130-US Hospitals, UCI Machine Learning Repository (public dataset).
Similar projects
- Analytics & dashboardsContractor performance (modeled on CVS)Which maintenance contractors cost the most and miss their deadlines18% of work orders overdue, on average
- Analytics & dashboardsCosta Rica's highway loanA $10.7 million road loan: half the road built, most of the money paid back$28,409 repaid per kilometer actually built
- Analytics & dashboardsArizona job marketWho's hiring, when, and how much experience they really ask for, from live job data35,000+ live job postings analyzed
Have a problem like this? Get your free AI blueprint in about a minute.
