Select the top 10 of drugs reported on for substances for the suspect drug list table. This table is accidentally named subject instead of suspect.
select drugs, COUNT(DISTINCT local_number) from import.substance_subject_drug_list GROUP BY drugs order by COUNT(DISTINCT local_number) desc limit 10;
|COVID-19 VACCINE ASTRAZENECA||337828|
|SPIKEVAX [COVID-19 MRNA VACCINE MODERNA||316281|
|VAXZEVRIA [COVID-19 VACCINE ASTRAZENECA||204072|
Links have been added to the entries in the EPAR information from the EMA website.
"COMIRNATY contains tozinameran, a messenger RNA" as stated here and we find TOZINAMERAN as a substance in the substances list too.
It is interesting to see that most reports are related to a COVID-19 drug, namely the first four entries plus the sixth. From the top-10, the sum of all reports related a COVID-19 drug totals
1880025 if we relate this to the total number of unique reports:
10210452, about 20% of all reports are COVID-19 medicine related.
Another interesting medicine in the top ten list of most reported drugs, is REVLIMID which is a medicine used for the treatment of certain cancers and serious conditions affecting blood cells and bone marrow, namely multiple myeloma, myelodysplastic syndromes and mantle cell and follicular lymphoma.