Top 10 reactions for Tozinameran

The number one substance we found earlier was Tozinameran. To find the top 10 reactions with their outcome for the Tozinameran substance, we first lookup the substance_id:

SELECT * from import.substances where name ilike '%TOZINAMERAN%';
substance_idname
42325700COVID-19 MRNA VACCINE PFIZER-BIONTECH (TOZINAMERAN)
60123556COVID-19 MRNA VACCINE PFIZER-BIONTECH ORIGINAL/OMICRON BA.1 (TOZINAMERAN, RILTOZINAMERAN)
60141237COVID-19 MRNA VACCINE PFIZER-BIONTECH ORIGINAL/OMICRON BA.4-5 (TOZINAMERAN, FAMTOZINAMERAN)

Let's select substance_id 42325700 and see in the reaction table for substances which reactions are related to this substance_id, we will group them by reaction and outcome to get an general idea and limit the result to 10.

select reaction, outcome, count(*) from import.substance_reaction where substance_id = 42325700 GROUP BY substance_id, reaction, outcome order by count(*) desc limit 10;
reactionoutcomecount
COVID-1998917
Vaccination failure88821
HeadacheRecovered/Resolved71871
PyrexiaRecovered/Resolved69366
FatigueNot Recovered/Not Resolved49876
HeadacheNot Recovered/Not Resolved49474
FatigueRecovered/Resolved47029
MyalgiaRecovered/Resolved43603
ChillsRecovered/Resolved40605
HeadacheRecovering/Resolving34880

In 98917 reports, the reaction was COVID-19. In 88821cases the vaccination failed.