Find the causes/type of deaths #1
Description
In OMOP current representation, the causes/type of death of each dead patient is not known (see death table https://github.com/MIT-LCP/mimic-omop/tree/master/etl/StandardizedClinicalDataTables/DEATH).
Below are the first four entries of the death table:
| person_id | death_date | death_datetime | death_type_concept_id | cause_concept_id | cause_source_value | cause_source_concept_id |
|---|---|---|---|---|---|---|
| 0 | 62063368 | 2188-11-22 | 2188-11-22 12:00:00 | 38003569 | None | None |
| 1 | 62063384 | 2198-02-18 | 2198-02-18 03:55:00 | 38003569 | None | None |
| 2 | 62063393 | 2182-07-31 | 2182-07-31 06:45:00 | 38003569 | None | None |
| 3 | 62063403 | 2145-03-19 | 2145-03-19 07:00:00 | 38003569 | None | None |
While the reason might simply be that people die in general for multiple reasons, it is nonetheless possible to extract the principal causes of death out of the condition_occurrence table.
For the moment, this table associate a series of "conditions" to each patient (each one associated with a visit occurrence from visit_occurrence table). This conditions are obviously not all fatal though. Extracting only the final fatal conditions (for instance "Cardiac arrest" or "Cardiogenic shock") for each patient could be a first step to determine the principal causes of death of each patient and derive better descriptive statistics out of it.