@Christian_Reich, what plurality do you have? Do you have plural deaths, or plural death dates, or plural death types? As I understand, no. You have multiple causes. And it’s, of course, OK to have multiple records for multiple causes. But it’s not OK to duplicate all other data just because of multiple causes. All other data remains the same. Why not to duplicate? Because of https://en.wikipedia.org/wiki/Database_normalization
What I propose is to have a separate table for death causes with following columns:
- id
- death_id
- cause_concept_id
- cause_source_value
- cause_source_concept_id