Top 10 reactions

Reactions

Let's look at the reaction that are present to find the reactions with most reports.

select
  reaction,
  count(*)
from
  import.substance_reaction
GROUP BY reaction   
order by count(*) desc limit 10;

Let's do another check and find the reactions with most reports and segregate by outcome

select
  reaction,
  outcome,
  count(*)
from
  import.substance_reaction
GROUP BY reaction, outcome
order by count(*) desc limit 10;

It is interesting to see that Death which has the outcome Fatal enters the top 10.

Fatal outcome

Let's find a top 10 with Fatal outcome.

select
 reaction,
 outcome,
 count(*)
from
 import.substance_reaction
where
 outcome ilike '%fatal%'
GROUP BY reaction, outcome
order by count(*) desc limit 10;

Death is not always fatal

As extra analyses, we group the reports where the reaction contains the word death we assume not all reporting has been entered correct as it seems possible to have death as a reaction where the outcome is not equal to "Fatal". An interesting combination of reaction and outcome is "Recovered/Resolved" from "Foetal death". Foetal death is a synonym for "still birth", the death of a foetus needs not be fatal for the mother, whilst it is for the unborn child.

select
  reaction,
  outcome,
  count(*)
from
  import.substance_reaction
where
  reaction ilike '%death%'
GROUP BY reaction, outcome
order by count(*) desc limit 25;

(25 rows)