FOI-02937 - FOI02937_PART_1_ICB - 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 We’ve recently deployed a new update to the Open Data Portal. You can read more about the changes in our latest news article here .

As of 16 June 2025, 16:30 – The previously reported issue with data files displaying in reverse order (oldest first) has now been resolved. Files should now appear with the most recent listed first.

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

Additional Info

Field	Value
Data last updated	15 July 2025
Metadata last updated	15 July 2025
Created	15 July 2025
Format	text/csv
Licence	No Licence Provided

Data Dictionary

Column	Title	Type	Description
YEAR_MONTH	Year and Month	number	The year and month for which the claim for dispensed items has been submitted to NHSBSA in the format YYYYMM.
ICB_CODE	ICB Code	string	ICB code is the unique identifying code attributed to an Integrated Care Board (ICB).
ICB_NAME	ICB Name	string	The name of the Integrated Care Board (ICB)
BNF_PRESENTATION_CODE	BNF Code	string	strength and the link to the generic equivalent product. NHS Prescription Services has created pseudo BNF chapters, which are not published, for items not included in BNF
BNF_PRESENTATION	BNF Presentation Description	string	The individual preparation name of the drug, which may be proprietary or generic, followed by strength and form.
ITEMS	Items	number	Items shows the number of times a product appears on a prescription form not the quantity prescribed.
NIC_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.
TOTAL_QUANTITY	Total Quantity	number	Total quantity is the number of items multiplied by the quantity prescribed. e.g. 2 items prescribed, one with a quantity of 2 and one with a quantity of 3, the total quantity would show as 5 (1 item x quantity of 2) + (1 item x quantity of 3)