Medicare Hospital SQL Analysis
A 28-query PostgreSQL analysis of 6,000+ Medicare-registered U.S. hospitals — exploring quality ratings, emergency service coverage, and geographic disparities, translated into a 5-dashboard Tableau story.
Federal healthcare data is publicly available but rarely made accessible. The CMS Hospital General Information dataset covers every Medicare-registered hospital in the U.S. — but in its raw form it's just a flat file. No stakeholder can act on a CSV with 6,000 rows.
The goal was to use SQL to ask the questions a healthcare analyst, policy researcher, or hospital administrator would actually care about: Which states are underserved? Where are emergency services lacking? How does ownership structure shape what types of hospitals exist — and where? Then make those answers interactive.
This project demonstrates the full analyst workflow: raw federal data → structured SQL questions → visual story for decision-makers. The 28 queries aren't just analysis — they're a reusable template for any healthcare stakeholder asking the same questions about access, quality, and coverage.
For a policy team or hospital network, the geographic deviation analysis alone could inform where to prioritize infrastructure investment, which states need emergency capacity, and how ownership type shapes care availability — all derived from a single public dataset with SQL.