FOI-03041 - FOI-03041- QUESTION 2 COMPLETE DATA - 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 29 August 2025

Deployment completed.

The follow-up deployment on the NHSBSA Open Data Portal has now been completed. This release addresses outstanding actions from the previous update and delivers improvements as detailed in this news article.

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

Additional Info

Field	Value
Data last updated	4 September 2025
Metadata last updated	4 September 2025
Created	4 September 2025
Format	text/csv
Licence	Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column	Title	Type	Description
CALENDAR_YEAR	Calendar Year	number	Indicates the relevant calendar year for each row of data.
BNF_CHEMICAL_SUBSTANCE_CODE	BNF Chemical Substance Code	string	The first nine digits of the 15-digit BNF Code, which indicate the chemical substance under which the drug or appliance is categorised.
BNF_CHEMICAL_SUBSTANCE	BNF Chemical Substance	string	This is the International Non-proprietary Name (INN) and is the standard registered name for the active constituent of that medicine, for example omeprazole. For compounds the name may be more complex, such as co-magaldrox magnesium/aluminium hydrox). In some cases the name is a collective one for a range of medicines, such as alginic acid compound preparations. For prescriptions in BNF chapters 19 to 23, there is no "chemical" name, as these are dressings and appliances. Therefore, these items are reported under the BNF section name, for example, night drainage bags.
ITEMS	Items	number	Items shows the number of times a product appears on a prescription form not the quantity prescribed.
NET_INGREDIENT_COST_GBP	Net Ingredient Cost (NIC (£))	number	Net Ingredient cost (NIC) is the basic price of a drug as stated in Part II Clause 8 of the Drug Tariff but please note that where a price concession for items listed in Part VIII of the Drug Tariff has been agreed between the Department of Health and Social Care (DHSC) and the Pharmaceutical Services Negotiating Committee the NIC will reflect the concession price rather than the Drug Tariff price. NIC is given in Pounds Sterling.