Find the causes/type of deaths

[paulroujansky]

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.