The purpose of this markdown file is to keep track of questions to ask that will drive what goes on the dashboard.
Patient Data (pat_tbl_combo.csv)
- What is the most common admission type (e.g., emergency, elective)?
- What is the most frequent discharge location for patients?
- What are the top diagnoses for admitted patients?
- How does insurance type vary across different patient demographics (age, gender, ethnicity)?
- What is the average age of patients admitted for different diagnoses?
Procedure Data (proced_tbl_combo.csv)
- What are the most common procedures performed in the hospital?
- How do procedure frequencies vary across different age groups?
ICU Stay Data (icustays.csv)
- What is the average length of stay (LOS) in the ICU?
- Which care units (MICU, CCU, etc.) have the longest/shortest stays?
- What percentage of ICU patients are transferred between different care units?