can cause of death code be added into the generated csv files?

[tanksgt]

hi! i confirmed that the cause of death is mentioned in the generated patient fhir json file but i cannot seem to find it in the csv files. if it is already included in the other csv files, can someone point me to the general direction? if not already included, can the cause of death be added as a new column to the patients.csv file?

[jawalonoski]

You should be able to find cause of death in two places within the CSV files...

First, encounters, where the code is "SNOMED-CT", "308646001", "Death Certification". Then, look at the encounter reason for the actual cause of death.

Second, observations, where the code is "LOINC", "69453-9", "Cause of Death [US Standard Certificate of Death]". The cause of death should be the observation value.