Understanding MIMIC II Clinical Database Logs

This page presents a commented, greatly condensed, MIMIC II log that contains a few entries of each of the ten major types. In this sample, the HTML log has been altered by the addition of interspersed text log entries in grey and comments in red.

Unannotated versions of this sample log are also available, as text (sample.txt), as HTML (sample.html), and as a (binary) annotation file (sample.log) with its accompanying (text) header file (sample.hea).

• ICD9
  Simultaneous log entries of the same type are grouped together under a bullet point. This subgroup (of ICD9 diagnosis codes) contains all five of the entries that share this time stamp. In the text log, the first entry looks like this:

  [00:00:00 05/09/2016]	ic	dd=0388	ds=3	ld=SEPTICEMIA NEC
  

  The ic is the source code that indicates what type of log entry this is (an ICD9 diagnosis in this case). In the HTML log, the same entry appears as:

  dd: 0388
  ds: 3
  ld: SEPTICEMIA NEC
  

  Name-value pairs define the clinical data contained within each entry. For the entry above, the value associated with dd specifies the ICD-9 code. In these logs, most ICD-9 codes are represented as 3- to 5-digit numerals. In the ICD-9 standard, these codes are represented as 3-digit numerals that may have 1 or 2 additional digits appended after a decimal point. Thus the dd value here, 0388, represents the ICD-9 code 038.8.

  The few exceptions are codes beginning with the letter E followed by 3 digits, or V followed by two digits. Such codes may also include a decimal point followed by one or two additional digits.

  The ds value indicates a diagnosis sequence code, and the ld value is an abbreviated translation of the ICD9 code. For a definitive translation, see the official ICD9-CM web site of the CDC.

  [00:00:00 05/09/2016]	ic	dd=1120	ds=9	ld=THRUSH
  
  dd: 1120
  ds: 9
  ld: THRUSH
  
  [00:00:00 05/09/2016]	ic	dd=39891	ds=6	ld=RHEUMATIC HEART FAILURE
  
  dd: 39891
  ds: 6
  ld: RHEUMATIC HEART FAILURE
  
  [00:00:00 05/09/2016]	ic	dd=4210	ds=2	ld=AC/SUBAC BACT ENDOCARD
  
  dd: 4210
  ds: 2
  ld: AC/SUBAC BACT ENDOCARD
  
  [00:00:00 05/09/2016]	ic	dd=4820	ds=7	ld=K. PNEUMONIAE PNEUMONIA
  
  dd: 4820
  ds: 7
  ld: K. PNEUMONIAE PNEUMONIA
  

  Most logs begin as this sample does, with a group of ICD9 diagnosis codes that represent the major problems of the patient at or before admission to the ICU. In some cases, groups of ICD9 codes dating from previous visits (which may have been days or weeks before the ICU admission) can be useful in assessing the development of the problems that have led to the ICU.

• Physician Order
  As in the first group, five simultaneous log entries, all of the same type, are grouped together in the HTML log. The source code po indicates that these entries document a physician's order (usually an order for medication to be administered); in this group, five different medications and their dosages are to be given to the patient. This group contains five entries.

  [02:00:00 06/09/2016]	po	tf=[12:00:00 06/09/2016]	pt=Unit Dose	rt=IH	fr=Q6H:PRN	m1=Albuterol Neb Soln	v1=1	u1=NEB
  

  tf: [12:00:00 06/09/2016]
  pt: Unit Dose
  rt: IH
  fr: Q6H:PRN
  m1: Albuterol Neb Soln
  v1: 1
  u1: NEB
  

  [02:00:00 06/09/2016]	po	tf=[12:00:00 06/09/2016]	pt=Unit Dose	rt=IH	fr=Q6H:PRN	m1=Ipratropium Bromide Neb	v1=1	u1=NEB
  

  tf: [12:00:00 06/09/2016]
  pt: Unit Dose
  rt: IH
  fr: Q6H:PRN
  m1: Ipratropium Bromide Neb
  v1: 1
  u1: NEB
  

  [02:00:00 06/09/2016]	po	tf=[19:00:00 06/09/2016]	pt=IV Piggyback	rt=IV	fr=Q24H	fs=2	dn=1	m1=Ceftriaxone	v1=1	u1=gm	m2=Iso-Osmotic Dextrose	v2=50	u2=ml
  

  tf: [19:00:00 06/09/2016]
  pt: IV Piggyback
  rt: IV
  fr: Q24H
  fs: 2
  dn: 1
  m1: Ceftriaxone
  v1: 1
  u1: gm
  m2: Iso-Osmotic Dextrose
  v2: 50
  u2: ml
  

  [02:00:00 06/09/2016]	po	tf=[19:00:00 06/09/2016]	pt=IV Piggyback	rt=IV	fr=Q4H	fs=2, 6, 10, 14, 18, 22	dn=6	m1=Ampicillin Sodium	v1=2	u1=gm	m2=NS	v2=100	u2=ml
  

  tf: [19:00:00 06/09/2016]
  pt: IV Piggyback
  rt: IV
  fr: Q4H
  fs: 2, 6, 10, 14, 18, 22
  dn: 6
  m1: Ampicillin Sodium
  v1: 2
  u1: gm
  m2: NS
  v2: 100
  u2: ml
  

  [02:00:00 06/09/2016]	po	tf=[19:00:00 06/09/2016]	pt=Unit Dose	rt=PO	fr=Q12H	fs=2, 14	dn=2	m1=Ciprofloxacin HCl	v1=500	u1=mg
  

  tf: [19:00:00 06/09/2016]
  pt: Unit Dose
  rt: PO
  fr: Q12H
  fs: 2, 14
  dn: 2
  m1: Ciprofloxacin HCl
  v1: 500
  u1: mg
  

  The first name-value pair in each of these entries is tf, a secondary timestamp that indicates the (anticipated) end of the event described in the rest of the entry. In this case, the medications are prescribed for the period beginning immediately (i.e., at 2 am on 6 September, as in the primary timestamp) and ending at tf (10 hours later for the first two medications, and 17 hours later for the other three).

  pt indicates the procedure type, rt is the route for the medication (IV: intravenous; PO: "per os", by mouth), and fr is the frequency of doses to be given (Q6H: "once per 6 hours"; PRN: "pro re nata", as needed). The schedule is sometimes further specified using fs, a list of the times of day (hours only) at which the medication is to be given, and dn, the total number of doses to be given. m1, v1, and u1 indicate the name of the medication, the quantity of medication per dose, and the units of measure. In the third and fourth entries above, the medication is to be given intravenously, and m2, v2, and u2 specify the type of solution in which the medication is to be dissolved.

• Census Event

  [15:01:00 06/09/2016]	ce	tf=[15:58:00 24/10/2016]	dt=69177	cu=69	di=No Disch Status
  

  tf: [15:58:00 24/10/2016]
  dt: 69177
  cu: MICU
  di: No Disch Status
  

  Census events (source code ce) include patient admissions and transfers. The interval from the entry to tf (the discharge time) is given in minutes in dt. The numeric value associated with cu (69, as shown in the text log) has been replaced by its definition (MICU) in the HTML log, determined by dictionary lookup in cu-dict.

• Solution

  [15:01:00 06/09/2016]	so	id=13	el=1	cu=69	cg=-1	io=104	vo=100	du=ml	rt=Intravenous Push
  

  id: D5W
  el: 1
  cu: MICU
  cg: -1
  io: D5W 100.0ml	IV Infusions
  vo: 100
  du: ml
  rt: Intravenous Push
  

  Solution entries (source code so) record fluids given to the patient. The numeric value associated with io (104, as shown in the text log) has been replaced by its definition (D5W, 5% dextrose) in the HTML log, determined by dictionary lookup in io-id-dict; the vo and du values indicate that the amount given was 100 ml.

  [15:01:00 06/09/2016]	so	id=56	el=1	cu=69	cg=-1	io=102	du=ml	rt=Oral
  

  id: Po Intake
  el: 1
  cu: MICU
  cg: -1
  io: Po Intake	PO/Gastric
  du: ml
  rt: Oral
  

  This solution entry indicates that the patient received an unspecified amount of fluid by mouth (Po Intake).

• Chart Event
  Chart events (source code ch) are by far the most common log entries. Those in this event group list a set of observations entered semi-automatically. Typically, raw measurements come from ICU monitors and other instruments, and representative measurements are chosen by a nurse for inclusion in the log.

  [15:48:00 06/09/2016]	ch	t0=[15:00:00 06/09/2016]	id=211	el=0	cu=69	cg=2393	v1=98	u1=BPM	st=NotStopd
  

  t0: [15:00:00 06/09/2016]
  id: Heart Rate
  el: 0
  cu: MICU
  cg: RN
  v1: 98
  u1: BPM
  st: NotStopd
  

  The id value is defined in ch-id-dict, and cu and cg values in cu-dict and cg-dict as above; the el and st values are not significant. From this entry, we see that the patient's heart rate was 98 beats per minute.

  [15:48:00 06/09/2016]	ch	t0=[15:00:00 06/09/2016]	id=212	el=0	cu=69	cg=2393	v1=Normal Sinus	st=NotStopd
  

  t0: [15:00:00 06/09/2016]
  id: Heart Rhythm
  el: 0
  cu: MICU
  cg: RN
  v1: Normal Sinus
  st: NotStopd
  

  [15:48:00 06/09/2016]	ch	t0=[15:00:00 06/09/2016]	id=455	el=0	cu=69	cg=2393	v1=135	u1=mmHg	v2=53	u2=mmHg	st=NotStopd
  

  t0: [15:00:00 06/09/2016]
  id: NBP
  el: 0
  cu: MICU
  cg: RN
  v1: 135
  u1: mmHg
  v2: 53
  u2: mmHg
  st: NotStopd
  

  Above, a non-invasive blood pressure (NBP) measurement: 135 mmHg systolic, 53 mmHg diastolic. Below, the mean NBP is recorded as 80.3333 mmHg.

  [15:48:00 06/09/2016]	ch	t0=[15:00:00 06/09/2016]	id=456	el=0	cu=69	cg=2393	v1=80.3333	u1=mmHg	st=NotStopd
  

  t0: [15:00:00 06/09/2016]
  id: NBP Mean
  el: 0
  cu: MICU
  cg: RN
  v1: 80.3333
  u1: mmHg
  st: NotStopd
  

  [15:48:00 06/09/2016]	ch	t0=[15:00:00 06/09/2016]	id=646	el=0	cu=69	cg=2393	v1=97	u1=%	st=NotStopd
  

  t0: [15:00:00 06/09/2016]
  id: SpO2
  el: 0
  cu: MICU
  cg: RN
  v1: 97
  u1: %
  st: NotStopd
  

• Solution

  [17:00:00 06/09/2016]	so	id=13	el=2	cu=69	cg=2393	io=104	vo=100	du=ml	rt=Intravenous Push
  

  id: D5W
  el: 2
  cu: MICU
  cg: RN
  io: D5W 100.0ml	IV Infusions
  vo: 100
  du: ml
  rt: Intravenous Push
  

  [17:00:00 06/09/2016]	so	id=18	el=1	cu=69	cg=2393	io=134	vo=1000	du=ml	rt=Intravenous Push
  

  id: .9% Normal Saline
  el: 1
  cu: MICU
  cg: RN
  io: .9% Normal Saline 1000.0ml	IV Infusions
  vo: 1000
  du: ml
  rt: Intravenous Push
  

  More fluid intake (see above for details).

• I/O Event

  [17:10:00 06/09/2016]	io	t0=[16:00:00 06/09/2016]	tf=[00:00:00 08/09/2016]	dt=1920	id=55	el=1	cu=69	cg=2393	vo=400	vu=ml
  

  t0: [16:00:00 06/09/2016]
  tf: [00:00:00 08/09/2016]
  dt: 1920
  id: Urine Out Foley
  el: 1
  cu: MICU
  cg: RN
  vo: 400
  vu: ml
  

  [17:10:00 06/09/2016]	io	t0=[16:00:00 06/09/2016]	tf=[10:00:00 18/09/2016]	dt=16920	id=104	el=1	cu=69	cg=2393	ai=105	vo=100	vu=ml
  

  t0: [16:00:00 06/09/2016]
  tf: [10:00:00 18/09/2016]
  dt: 16920
  id: D5W 100.0ml	IV Infusions
  el: 1
  cu: MICU
  cg: RN
  ai: 105
  vo: 100
  vu: ml
  

  [17:10:00 06/09/2016]	io	t0=[17:00:00 06/09/2016]	id=55	el=1	cu=69	cg=2393	vo=60	vu=ml
  

  t0: [17:00:00 06/09/2016]
  id: Urine Out Foley
  el: 1
  cu: MICU
  cg: RN
  vo: 60
  vu: ml
  

• I/O Event

  [18:55:00 06/09/2016]	io	t0=[19:00:00 06/09/2016]	id=55	el=1	cu=69	cg=2393	vo=300	vu=ml
  

  t0: [19:00:00 06/09/2016]
  id: Urine Out Foley
  el: 1
  cu: MICU
  cg: RN
  vo: 300
  vu: ml
  

• I/O Event

  [19:36:00 06/09/2016]	io	t0=[19:30:00 06/09/2016]	tf=[08:00:00 18/09/2016]	dt=16590	id=102	el=1	cu=69	cg=2610	ai=103	vo=50	vu=ml
  

  t0: [19:30:00 06/09/2016]
  tf: [08:00:00 18/09/2016]
  dt: 16590
  id: Po Intake	PO/Gastric
  el: 1
  cu: MICU
  cg: RN
  ai: 103
  vo: 50
  vu: ml
  

• Total I/O Event

  [19:36:00 06/09/2016]	to	t0=[23:00:00 06/09/2016]	dt=24	id=20	el=2	cu=69	cg=2610	cv=50	ap=none
  

  t0: [23:00:00 06/09/2016]
  dt: 24
  id: PO/Gastric In Total
  el: 2
  cu: MICU
  cg: RN
  cv: 50
  ap: none
  

• Total I/O Event

  [22:00:00 06/09/2016]	to	t0=[23:00:00 06/09/2016]	dt=24	id=18	el=2	cu=69	cg=2610	cv=250	ap=none
  

  t0: [23:00:00 06/09/2016]
  dt: 24
  id: IV Infusion In Total
  el: 2
  cu: MICU
  cg: RN
  cv: 250
  ap: none
  

  [22:00:00 06/09/2016]	to	t0=[23:00:00 06/09/2016]	dt=24	id=1	el=2	cu=69	cg=2610	cv=300	ap=none
  

  t0: [23:00:00 06/09/2016]
  dt: 24
  id: 24h Total In
  el: 2
  cu: MICU
  cg: RN
  cv: 300
  ap: none
  

• Total I/O Event

  [23:08:00 06/09/2016]	to	t0=[23:00:00 06/09/2016]	dt=1	id=23	el=2	cu=69	cg=2610	pv=50	cv=50	ap=none
  

  t0: [23:00:00 06/09/2016]
  dt: 1
  id: Total Hourly Output
  el: 2
  cu: MICU
  cg: RN
  pv: 50
  cv: 50
  ap: none
  

  [23:08:00 06/09/2016]	to	t0=[23:00:00 06/09/2016]	dt=1	id=29	el=2	cu=69	cg=2610	pv=-50	cv=-50	ap=none
  

  t0: [23:00:00 06/09/2016]
  dt: 1
  id: Net Hourly Balance
  el: 2
  cu: MICU
  cg: RN
  pv: -50
  cv: -50
  ap: none
  

• Additive

  [23:00:00 07/09/2016]	ad	id=131	el=100	cu=69	cg=2404	io=141	am=500	du=mcgkgmin	rt=IV Drip
  

  id: Propofol
  el: 100
  cu: MICU
  cg: RN
  io: N/A 50.0vl + 500mcgkgmin Propofol	IV Infusions
  am: 500
  du: mcgkgmin
  rt: IV Drip
  

• Solution

  [23:00:00 07/09/2016]	so	id=140	el=1	cu=69	cg=2404	io=141	vo=50	du=vl	rt=Intravenous Push
  

  id: N/A
  el: 1
  cu: MICU
  cg: RN
  io: N/A 50.0vl + 500mcgkgmin Propofol	IV Infusions
  vo: 50
  du: vl
  rt: Intravenous Push
  

• Med Event

  [23:42:00 07/09/2016]	me	t0=[23:15:00 07/09/2016]	tf=[15:58:00 24/10/2016]	dt=67243	id=131	el=1	cu=69	cg=2404	so=140	vo=0	v1=50	du=mcgkgmin	sv=50	su=vl	rt=IV Drip
  

  t0: [23:15:00 07/09/2016]
  tf: [15:58:00 24/10/2016]
  dt: 67243
  id: Propofol
  el: 1
  cu: MICU
  cg: RN
  so: N/A
  vo: 0
  v1: 50
  du: mcgkgmin
  sv: 50
  su: vl
  rt: IV Drip
  

• Med Event

  [00:00:00 08/09/2016]	me	t0=[00:00:00 08/09/2016]	id=131	el=1	cu=69	cg=2404	so=140	vo=0	v1=50	du=mcgkgmin	sv=50	su=vl	rt=IV Drip
  

  t0: [00:00:00 08/09/2016]
  id: Propofol
  el: 1
  cu: MICU
  cg: RN
  so: N/A
  vo: 0
  v1: 50
  du: mcgkgmin
  sv: 50
  su: vl
  rt: IV Drip
  

  [00:00:00 08/09/2016]	me	t0=[23:30:00 07/09/2016]	id=131	el=1	cu=69	cg=2404	so=140	vo=0	v1=50	du=mcgkgmin	sv=50	su=vl	rt=IV Drip
  

  t0: [23:30:00 07/09/2016]
  id: Propofol
  el: 1
  cu: MICU
  cg: RN
  so: N/A
  vo: 0
  v1: 50
  du: mcgkgmin
  sv: 50
  su: vl
  rt: IV Drip
  

• Med Event

  [01:01:00 08/09/2016]	me	t0=[00:30:00 08/09/2016]	id=131	el=1	cu=69	cg=2404	so=140	vo=0	v1=50	du=mcgkgmin	sv=50	su=vl	rt=IV Drip
  

  t0: [00:30:00 08/09/2016]
  id: Propofol
  el: 1
  cu: MICU
  cg: RN
  so: N/A
  vo: 0
  v1: 50
  du: mcgkgmin
  sv: 50
  su: vl
  rt: IV Drip
  

  [01:01:00 08/09/2016]	me	t0=[01:00:00 08/09/2016]	id=131	el=1	cu=69	cg=2404	so=140	vo=0	v1=30	du=mcgkgmin	sv=50	su=vl	rt=IV Drip
  

  t0: [01:00:00 08/09/2016]
  id: Propofol
  el: 1
  cu: MICU
  cg: RN
  so: N/A
  vo: 0
  v1: 30
  du: mcgkgmin
  sv: 50
  su: vl
  rt: IV Drip
  

• Delivery

  [14:00:00 10/09/2016]	de	io=481	el=1	cu=69	cg=1986	ra=10	ru=ml/hr
  

  io: Promote w/fiber	Tube Feeding
  el: 1
  cu: MICU
  cg: RN
  ra: 10
  ru: ml/hr
  

• Delivery

  [10:00:00 13/09/2016]	de	io=168	el=1	cu=69	cg=2291	ra=80	ru=ml/hr
  

  io: D5W	IV Infusions
  el: 1
  cu: MICU
  cg: RN
  ra: 80
  ru: ml/hr
  

• Additive

  [09:00:00 14/09/2016]	ad	id=131	el=103	cu=69	cg=2528	io=149	am=1000	du=mcgkgmin	rt=IV Drip
  

  id: Propofol
  el: 103
  cu: MICU
  cg: RN
  io: N/A 100.0vl + 1000mcgkgmin Propofol	IV Infusions
  am: 1000
  du: mcgkgmin
  rt: IV Drip
  

• Delivery

  [17:00:00 14/09/2016]	de	io=854	el=1	cu=69	cg=2528	ra=75	ru=ml/hr
  

  io: .45% Normal Saline 750.0ml	IV Infusions
  el: 1
  cu: MICU
  cg: RN
  ra: 75
  ru: ml/hr
  

• Delivery

  [16:00:00 19/09/2016]	de	io=370	el=1	cu=69	cg=2147	ra=20	ru=ml/hr
  

  io: Tube Feeding	PO/Gastric
  el: 1
  cu: MICU
  cg: RN
  ra: 20
  ru: ml/hr
  

• Additive

  [00:00:00 20/09/2016]	ad	id=26	el=100	cu=69	cg=2528	io=132	am=20	du=mEq	rt=Intravenous Push
  

  id: KCL
  el: 100
  cu: MICU
  cg: RN
  io: D5W 50.0ml	IV Infusions
  am: 20
  du: mEq
  rt: Intravenous Push
  

• Additive

  [18:00:00 21/09/2016]	ad	id=118	el=100	cu=69	cg=2147	io=418	am=2500	du=mcghr	rt=IV Drip
  

  id: Fentanyl
  el: 100
  cu: MICU
  cg: RN
  io: .9% Normal Saline 50.0ml + 2500mcghr Fentanyl	IV Infusions
  am: 2500
  du: mcghr
  rt: IV Drip
  

  [18:00:00 21/09/2016]	ad	id=141	el=100	cu=69	cg=2147	io=166	am=60	du=mghr	rt=IV Drip
  

  id: Ativan
  el: 100
  cu: MICU
  cg: RN
  io: D5W 60.0ml + 60mghr Ativan	IV Infusions
  am: 60
  du: mghr
  rt: IV Drip
  

• Delivery

  [18:00:00 21/09/2016]	de	io=168	el=2	cu=69	cg=2147	ra=100	ru=ml/hr
  

  io: D5W	IV Infusions
  el: 2
  cu: MICU
  cg: RN
  ra: 100
  ru: ml/hr
  

• Census Event

  [16:36:00 24/10/2016]	ce	tf=[16:40:00 24/10/2016]	dt=4	cu=69	di=Other Facility
  

  tf: [16:40:00 24/10/2016]
  dt: 4
  cu: MICU
  di: Other Facility
  

• Census Event

  [13:47:00 07/11/2016]	ce	tf=[15:18:00 28/11/2016]	dt=30331	cu=54	di=No Disch Status
  

  tf: [15:18:00 28/11/2016]
  dt: 30331
  cu: CSRU
  di: No Disch Status