The column diagnoses_icd.sequence, according to the documentation:

provides the order in which the ICD diagnoses relate to the patient. ICD diagnoses are ordered by priority.

Does the order really matter aside from the primary diagnosis (i.e. does the diagnoses_icd.sequence matter when diagnoses_icd.sequence > 1)?

I see diagnoses_icd.sequence has values that range from 1 to 39:

SELECT distinct(sequence),  COUNT(*)  
FROM  mimiciii.diagnoses_icd 
GROUP BY sequence
ORDER BY   sequence ASC  ;

enter image description here

  • This questions looks like it may be a duplicate of opendata.stackexchange.com/questions/6303/…
    – tomp
    Commented Jan 3, 2016 at 1:13
  • 1
    @tomp They are pretty close indeed: to paraphrase, this question -> "does the order matter after 2"; the other question -> "how was the order decided?". I guess this question is a subset of the other one. Commented Jan 3, 2016 at 2:42
  • Thanks Franck, I'll update you on both points when we have a clear answer from the coders.
    – tomp
    Commented Jan 3, 2016 at 2:50
  • i wonder the answer too, could you share with me? Thanks Commented Jan 3, 2017 at 2:44
  • Hi Jeanine, you should add this to the comments area. Commented Jan 3, 2017 at 3:21


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.