Request
I would like to request total items, total quantity and total Net Ingredient cost for each BNF Code reimbursed by NHSBSA for October 2025 to December 2025 (each month separately please). I require the totals to be presented at BNF Code level, divided into the standard 5 year age bandings and further separated by patient gender.
I would like data for prescriptions dispensed and prescribed in England. Prescribing is to be split by Sub ICB (SICBL) and limited to prescribing within a SICBL.
I would like to receive the following fields:
•AGE_BAND
•BNF_CODE
•GENDER
•ITEMS
•NIC_GBP
•SICBL_CODE
•SICBL_NAME
•TOTAL_QUANTITY
•YEAR_MONTH
Age bands should be labelled up as follows:
• Aged 0-4
• Aged 10-14
• Aged 15-19
• Aged 20-24
• Aged 25-29
• Aged 30-34
• Aged 35-39
• Aged 40-44
• Aged 45-49
• Aged 50-54
• Aged 55-59
• Aged 5-9
• Aged 60-64
• Aged 65-69
• Aged 70-74
• Aged 75-79
• Aged 80-84
• Aged 85-89
• Aged 90-94
• Aged 95+
• UNKNOWN
Response
I can confirm that the NHSBSA holds the information you have requested and a copy of the information is attached.
Please read the below notes to ensure correct understanding of the data.
NHS Prescription Services process prescriptions for pharmacy contractors, appliance contractors, dispensing doctors and personal administration with information then used to make payments to pharmacists and appliance contractors in England for prescriptions dispensed in primary care settings (other arrangements are in place for making payments to dispensing doctors and personal administration). This involves processing over 1 billion prescription items and payments totalling over £9 billion each year. The information gathered from this process is then used to provide information on costs and trends in prescribing in England and Wales to over 25,000 registered NHS and Department of Health and Social Care users.
Data Source
The data source was the NHSBSA Information Services Data Warehouse.
Exclusions
The data excludes:
• items not dispensed, disallowed and those returned to the contractor for further clarification.
• prescriptions prescribed and dispensed in prisons, hospitals and private prescriptions.
• items prescribed but not presented for dispensing or not submitted to NHS prescription services by the dispenser.
• items supplied under NHS pharmacy advanced services.
Drugs
This dataset suppresses age band and gender for the prescribing of sensitive medicines based on the most recent data held in the NHSBSA Data Warehouse. As per the most recent guidelines, where suppression has been applied, the age band has been replaced with an asterisk (*) and the gender has been replaced with 'Not Known'.
Medicines in list A are considered sensitive regardless of the number of items. Medicines in list E are considered sensitive if they match a specified quantity. The full list of sensitive medicines relevant for this time period can be found in the document: SENSITIVE_MEDS.csv.
Please note, BNF code 190201000AABLBL with BNF name 'Exception Handler Unspecified Item' appears in the SENSITIVE_MEDS.csv.
A prescribed/paid drug may come out as "Unspecified" when:
a) Prescriptions are processed by NHSBSA data capture, prescriptions sometimes contain prescribing of medicines that were not populated on the NHSBSA drug database at the time. Any prescribing that falls into this category is captured as an ‘unspecified drug’.
b) There are cases when a drug is not classified under BNF structure, prescribing of those drugs will show as "Unspecified". (e.g. secondary care products).
Time Period
October 2025 - December 2025
Organisation Data
The data provided is for prescriptions prescribed and dispensed in England. The dataset is limited to items prescribed within an SICBL.
Data Queries
Please contact foirequests@nhsbsa.nhs.uk ensuring you quote the above reference if you have any specific questions regarding this response; or, if you feel you may be misunderstanding or misinterpreting the information; or, if you plan on publishing the data.
Reusing the data and copyright
If you plan on producing a press or broadcast story based upon the data please contact communicationsteam@nhsbsa.nhs.uk This is important to ensure that the figures are not misunderstood or misrepresented.
The information supplied to you continues to be protected by the Copyright, Designs and Patents Act 1988 and is subject to NHSBSA copyright. This information is licenced under the terms of the Open Government Licence detailed at:
http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Should you wish to re-use the information you must include the following statement: “NHSBSA Information Services Data Warehouse, NHSBSA Copyright 2026”. Failure to do so is a breach of the terms of the licence.
Information you receive which is not subject to NHSBSA Copyright continues to be protected by the copyright of the person, or organisation, from which the information originated. Please obtain their permission before reproducing any third party (non NHSBSA Copyright) information.
![[Open Data]](/base/images/od_80x15_blue.png)