MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases
https://mimic.mit.edu
MIT License
2.51k stars 1.5k forks source link

Is there a way to access to procedural ICD codes ? #1451

Closed snowgato closed 1 year ago

snowgato commented 1 year ago

Prerequisites

Description

Hi, I'd like to determine wether patients had or not cerebral aneurysm coiling. For ICD9, the code would be 39.75 or 39.76 and for ICD10 it would be 03VG3DZ. Actually, these codes don't belong to mimic IV. Is there some way to establish if someone had cerebral aneurysm coiling ? Thanks !

sting the titles and ICD codes held within Description of the issue, including:

marymlucas commented 1 year ago

@snowgato try the procedures_icd table in the mimiciv_hosp module? For example on BigQuery:

select * from physionet-data.mimiciv_hosp.procedures_icd where icd_version = 9 and icd_code like '%3975%' limit 100;

snowgato commented 1 year ago

That works perfect, Thanks very much for your help ! RTFM :-)