Version 2.4

Bug #5: Fix problems with icustay generation
Bug #13: Fix in "Unknown" service type in icustay_detail
Bug #21: Rename ORDER column in PARAMETER_MAPPING table
Bug #26: Make event date fields consistent
Bug #27: Rename d_labitems.lab_category to category for consistency with other item tables
Bug #40: Modify SAPS I calculation to correctly account for ventilated patients
Feature #11: Delete the materialized view VITAL_SIGNS_RAW, because this was just a temporal data to be used by some statistics calculations.
Feature #12: Add indices on cgid, itemid to chartevents
Feature #14: Add AKI materialized view
Feature #15: Add organ system failure materialized view
Feature #16: Restore the Physionet 2009 challenge patients
Feature #34: Re-generate SAPS scores after fixing Icustay problems
Change request #36: Make the "Length Of Stay" columns consistent in minutes
Change request #37: Replace ICUSTAY materialized view with ICUSTAYEVENTS table
Change request #38: Make consistent some column names in ICUSTAY_DETAIL

MIMIC II Adult records summary ( Download the full report [PDF] and the SQL source code )
	N*	#cases (%unit)**	mean ±std	median	IQR (Q1,Q3)
Hospital admissions	22,870
ICU Stays	25,328
Age (years)	25,328		63.3 ±17.7	65.20	26.1 (51.3,77.4)
Gender (male)	25,328	14,259 (56.3%)
ICU Los (days)	25,328		4.7 ±11	2.20	3.3 (1.1,4.4)
Hospital Los (days)	22,870		10.7 ±13	7.00	9 (4,13)
SAPS I - day 1 ***	20,142		13.4 ±5.3	13.00	7 (10,17)
SAPS I - day 2 ***	13,495		11.8 ±4.6	11.00	6 (9,15)
SAPS I - day 3 ***	9,070		12.2 ±4.5	12.00	6 (9,15)
Mechanical ventilation	25,328	11,969 (47.3%)
Invasive Swan-Ganz hemodynamic monitoring	25,328	5,637 (22.3%)
Invasive arterial blood pressure monitoring	25,328	14,054 (55.5%)
Use of vaso-active medications	25,328	8,693 (34.3%)
Hospital mortality	22,870	2,666 (11.7%)

* N = The number of ICUStays or Hospitalizations. that were included in the calculation for the given ICU Unit. #cases = The number of ICUStays orHospitalizations that match the category criteria. For example: In Gender, #cases will be the number of male ICUStays in a unit. * Only ICUStays where they have all 14 SAPS parameters were included. 2nd and 3rd day data comes from version 2.5 of the database.