1. Home
  2. Themes
  3. Freedom of Information...
  4. FOI-03378

FOI-03378

Followers
0
freedom-of-information-disclosure-log

Freedom of Information Disclosure Log

The NHSBSA's responses to Freedom of Information requests.

read more

Licence

Open Government Licence 3.0 (United Kingdom) [Open Data]

Report an issue

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.

Data and Resources

Additional Info

Field Value
Source NHS Business Services Authority
Contact Information Governance
Version 1.0
State active
Last Updated December 29, 2026, 14:12 (UTC)
Created December 29, 2026, 10:57 (UTC)