RETIRED - Secondary Care Medicines Data (SCMD) - SCMD_201909 - Open Data Portal

Skip to content

NEW You can now access exciting new features by logging in to the Open Data Portal, find out more.

Alert We’ve recently deployed a new update to the Open Data Portal. You can read more about the changes in our latest news article here .

As of 16 June 2025, 16:30 – The previously reported issue with data files displaying in reverse order (oldest first) has now been resolved. Files should now appear with the most recent listed first.

If you encounter any other issues, please contact us at DataServiceSupport@nhsbsa.nhs.uk .

Additional Info

Field	Value
Data last updated	16 November 2020
Metadata last updated	16 November 2020
Created	16 November 2020
Format	CSV
Licence	Open Government Licence 2.0 (United Kingdom)

Data Dictionary

Column	Title	Type	Description
YEAR_MONTH	Year and Month as YYYY-MM	string	The year followed by the month of when the medicines were issued. For example: 2019-01
ODS_CODE	Organisation Data Service Code	string	The Trust's Organisation Data Service Code (ODS), for example R1A. Look up files are provided and maintained by NHS Digital, for example see: Trusts under https://digital.nhs.uk/services/organisation-data-service/data-downloads/other-nhs-organisations.
VMP_SNOMED_CODE	Virtual Medicinal Product (VMP) SNOMED Code	integer	The Dictionary of Medicines and Devices (dm+d) Virtual Medicinal Product's (VMP) SNOMED code. For example: 322236009
VMP_PRODUCT_NAME	Virtual Medicinal Product (VMP) Product Name	string	The Dictionary of Medicines and Devices (dm+d) Virtual Medicinal Product's Name. For example: Paracetamol 500mg tablets.
UNIT_OF_MEASURE_IDENTIFIER	Unit of Measure Identifier	integer	The unit of measure for the VMP quantity's SNOMED code, or the value 3314211000001106 if there is no value. For example: 428673006.
UNIT_OF_MEASURE_NAME	Unit of Measure name	string	The Dictionary of Medicines and Devices (dm+d) unit of measure name for unit of measure identifier, unit dose form unit, or 'no value' if unknown. For example: tablet.
TOTAL_QUANITY_IN_VMP_UNIT	Total Quantity in the Virtual Medicinal Product (VMP) Unit	float	The total quantity of medicines issued in Dictionary of Medicines and Devices (dm+d) unit dose form unit that the Virtual Medicinal Product (VMP) is defined, rounded to 2 decimal places. For example: 20.