2

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

Franck Dernoncourt
  • 7,780
  • 9
  • 39
  • 86

0 Answers0