Substance suspect drug list

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;
drugscount
COMIRNATY [TOZINAMERAN]904812
COVID-19 VACCINE ASTRAZENECA337828
SPIKEVAX [COVID-19 MRNA VACCINE MODERNA316281
VAXZEVRIA [COVID-19 VACCINE ASTRAZENECA204072
REVLIMID [LENALIDOMIDE]155625
TOZINAMERAN [TOZINAMERAN]117032
ENBREL [ETANERCEPT]101998
[CLOZAPINE]88094
[LEVONORGESTREL]82590
REMICADE [INFLIXIMAB]73876

(10 rows)

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.