2

With noteevents how can we match the icd9 code for a given clinical note from the diagnosis table. It seems that the subject_id, HADM_id are not unique.

  • It seems that the subject_id, HADM_id are not unique Some data to backup up that statement would help distinguish if it is actually so or that you are overlooking something. Please edit your question. If you indent text by 4 spaces it will have a data/code layout. – Jan Doggen Mar 28 '17 at 20:23
1

You cannot link the ICD9 code to a specific note. ICD9 codes are linked to each hospital admission (HADM_ID), for which each person (SUBJECT_ID) will have one or more. Each hospital admission will likely have multiple notes, but these notes themselves are associated with a HADM_ID, and not directly to a diagnosis code. If you want specific diagnoses by day based on notes, you will have to mine the text directly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.