FOI-03378

**Request**

*I would like to request total items, total quantity and total Net Ingredient cost for each BNFID reimbursed by NHSBSA for each month from July 2025 to the items dispensed in England, whether prescribed in the community (FP10) or in secondary care (FP10H). I am requesting prescribing data at SICBL level please.*

*The response should include the following columns:*  
*YEAR_MONTH*  
*SICBL_NAME*  
*SICBL_CODE*  
*BNF_CODE*  
*AGE_BAND*  
*GENDER*  
*ITEMS*  
*TOTAL_QUANTITY*  
*NIC_GBP*  

On the 19 November you clarified the following: 

*I would like to request total items, total quantity and total Net Ingredient cost for each BNFID reimbursed by NHSBSA for each month from July 2025 to the latest available data month. I require the totals to be presented at BNFID level, divided into the standard 5 year age bandings and further separated by patient gender. Ideally this will include include all items dispensed in England, whether prescribed in the community (FP10) or in secondary care (FP10H). I am requesting prescribing data at SICBL level please.*

*The response should include the following columns:*  
*YEAR_MONTH*  
*SICBL_NAME*  
*SICBL_CODE*  
*BNF_CODE*  
*AGE_BAND*  
*GENDER*  
*ITEMS*  
*TOTAL_QUANTITY*  
*NIC_GBP*  

On the 3 December 2025 you further clarified:  

*We want the same inclusions/exclusions as previously:*  

*The data provided is for prescriptions dispensed and prescribed in England.*

*Prescribing has been split by Sub ICB Locations (SICBLs) and limited to prescribing within SICBLs.*
 
*So if the prescribing has been limited to SICBLs so far in your responses, then we want this to be the same in this case, even if it excludes secondary care prescribing. We want the data to cover prescriptions that have been dispensed and prescribed in England.*  

*These are the age bands you have provided in previous responses:*  

*AGE_BAND*  
*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 and notes explaining it 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 as part of a Pharmacy First consultation or service.


**Time Period** 
 
Based on July, August and September 2025 processing data.

**Drugs**  

No limitations on drugs or appliances prescribed.

**Organisational Data**  

Only items prescribed and dispensed in England have been included.

**Files**  

This FOI comprises of 41 data files:  

* FOI3378_202507_001.csv - 500,000 rows of data
* FOI3378_202507_002.csv - 500,000 rows of data
* FOI3378_202507_004.csv - 500,000 rows of data
* FOI3378_202507_005.csv - 500,000 rows of data
* FOI3378_202507_006.csv - 500,000 rows of data
* FOI3378_202507_007.csv - 500,000 rows of data
* FOI3378_202507_008.csv - 500,000 rows of data
* FOI3378_202507_009.csv - 500,000 rows of data
* FOI3378_202507_010.csv - 500,000 rows of data
* FOI3378_202507_011.csv - 500,000 rows of data
* FOI3378_202507_012.csv - 500,000 rows of data
* FOI3378_202507_013.csv - 500,000 rows of data
* FOI3378_202507_014.csv - 157,987 rows of data
* FOI3378_202508_001.csv - 500,000 rows of data
* FOI3378_202508_002.csv - 500,000 rows of data
* FOI3378_202508_003.csv - 500,000 rows of data
* FOI3378_202508_004.csv - 500,000 rows of data
* FOI3378_202508_005.csv - 500,000 rows of data
* FOI3378_202508_006.csv - 500,000 rows of data
* FOI3378_202508_007.csv - 500,000 rows of data
* FOI3378_202508_008.csv - 500,000 rows of data
* FOI3378_202508_009.csv - 500,000 rows of data
* FOI3378_202508_010.csv - 500,000 rows of data
* FOI3378_202508_011.csv - 500,000 rows of data
* FOI3378_202508_012.csv - 500,000 rows of data
* FOI3378_202508_013.csv - 429,518 rows of data
* FOI3378_202509_001.csv - 500,000 rows of data
* FOI3378_202509_002.csv - 500,000 rows of data
* FOI3378_202509_003.csv - 500,000 rows of data
* FOI3378_202509_004.csv - 500,000 rows of data
* FOI3378_202509_005.csv - 500,000 rows of data
* FOI3378_202509_006.csv - 500,000 rows of data
* FOI3378_202509_007.csv - 500,000 rows of data
* FOI3378_202509_008.csv - 500,000 rows of data
* FOI3378_202509_009.csv - 500,000 rows of data
* FOI3378_202509_010.csv - 500,000 rows of data
* FOI3378_202509_011.csv - 500,000 rows of data
* FOI3378_202509_012.csv - 500,000 rows of data
* FOI3378_202509_013.csv - 500,000 rows of data
* FOI3378_202509_014.csv - 148,827 rows of data

**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 licensed under the terms of the Open Government Licence detailed at:  
http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/ http://www.nationalarchives.gov.uk/doction you must include the following statement:  
“NHSBSA Information Services Data Warehouse, NHSBSA Copyright 2025”. 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.


Tags: NHS Prescription Services
Organization: Freedom of Information Disclosure Log