READMISSION RATE ANALYSIS USING SQL

The readmission rate is an important KPI to measure the percentage of patients who are admitted to hospitals again after a specific time duration such as 30 days. This metrics helps to assess the quality of care, patient outcomes and the effectiveness of post-discharge follow-up.

I use the simulated hospital data tables from Synthea to do the analysis.

-

pasted-movie.png

SQL codes for calculating readmission rate as follow

-pasted-movie.png

-pasted-movie.png

The output report with the readmission rate equal 1.55% as follow

:pasted-movie.png

-

- List of patients who are admitted again within 30 days from their discharges.

There is a patient who has been readmitted to hospital for 45 times from 2019 t0 2024.

-

- pasted-movie.png