Secondary Care Medicines Data



Hospital & Provider Medicines

Datasets on the supply of medicines from NHS provider organisations. read more


UK Open Government Licence (OGL) [Open Data]

Secondary Care Medicines Data

Data Set Description

Secondary care medicines data (SCMD) contains processed pharmacy stock control data in Dictionary of Medicines and Devices (dm+d) standardised format from all NHS Acute, Teaching, Specialist, Mental Health and Community Trusts in England.

The NHS Business Services Authority (NHSBSA) hosts and publishes Secondary Care Medicines Data on behalf NHS England and Improvement (NHSE&I).

Guidance documents:

Read more about this dataset

OpenDocument Text Document file (ODT): 44KB

Portable Document Format (PDF):139KB

Data and Resources

Additional Info

Field Value
Source NHS England & Improvement
Contact NHS England and NHS Improvement
Version v001
State active
Last Updated November 16, 2020, 05:42 (UTC)
Created August 28, 2020, 07:43 (UTC)

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

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.