4.2.1 Patient population age statistics

The first example is simple. Query 4.1 simply counts the number of unique subject ids in the database.

$\parbox{0.9\textwidth }{ \begin{center} \lstinputlisting[caption=S... ...subject_ids,firstline=21,lastline=25]{code/patient_profile.sql} \end{center} }$

We have developed a database table which contains a large number of columns and provides lots of summary data. This table is called `` $icustay\_detail$'' and contains information relating to patient stays in the ICU, their hospital admissions and various other paramters. This data can be obtained by running query 4.2

$\parbox{0.9\textwidth }{ \begin{center} \lstinputlisting[caption=I... ...stay_detail,firstline=26,lastline=28]{code/patient_profile.sql} \end{center} }$

The result of the above query contains many details about patients and their ICU stays. There are columns which provide the number of admissions and ICU stays for each patient, DOB, admission and discharge dates, flags indicating whether or not the patient died, gender, and finally, basic statistics including weight, height and SAPS score.