SPARCS Healthcare SQL Insights
Use the right tool for the size of the question.
SQL and DuckDB analysis of over two million inpatient discharge records, focused on aggregate hospital, cost, and demographic patterns.
Millions of records. Interpretable questions.
The question
The SPARCS study examines hospital activity, efficiency, treatment costs, and demographic patterns across more than two million inpatient discharge records.
The approach
SQL queries clean, filter, group, and summarize inpatient records. DuckDB and Google Colab support the analytical workflow. Aggregation turns the raw records into hospital, cost, and demographic comparisons.
What it demonstrates
The project emphasizes scalable query-based analysis and careful grouping. Its outputs help describe patterns across populations and institutions, rather than focusing on individual patients.
Scope
This case study describes aggregate analysis, not clinical advice or patient-level decision making. No public interactive deployment is supplied, and individual discharge records are not reproduced in this portfolio.