How many deaths have been caused by drugs in each of the last five years for which figures are available, broken down by drug.

The National Records of Scotland report Drug Related Deaths in Scotland in 2018 was published on 16 th July 2019. It states there were a total of 1,187 drug related deaths in 2018.
The report provides extensive information on the drugs implicated in or probable cause of death. Most drug related deaths were people who took more than one substance. Of the 1,187 drug-related deaths in 2018, there were just 68 for which only one drug (and, perhaps alcohol) was found to be present in the body.
Table 3 of the report provides details of drug related deaths by selected drugs reported for the years 2008 – 2018.
Table Y of the report provides information about a larger range of drugs on the basis of the Office for National Statistics "wide" definition (this includes deaths caused by drugs which were not controlled under the Misuse of Drugs Act).
Additional data tables on the NRS website Tables SUB1 and SUB2 show how often the name of each drug (or other substance) was reported to NRS as being involved in deaths which were counted in NRS's standard definition of drug-related deaths and in the ONS "wide" definition, respectively.
The full report and supplementary tables can be accessed from the following link. https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/vital-events/deaths/drug-related-deaths-in-scotland/2018 )