Additional Info

Field Value
Data last updated 29 January 2026
Metadata last updated 29 January 2026
Created 29 January 2026
Format text/csv
Licence Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column Title Type Description
FINANCIAL_YEAR Financial Year string The financial year for which the claim for dispensed items has been submitted to NHSBSA, from April to March in any given year.
FINANCIAL_QUARTER Financial Quarter string The financial quarter for which the claim for dispensed items has been submitted to NHSBSA, where Q1= April to June, Q2 = July to September, Q3 = October to December, and Q4 = January to March.
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).
SICBL_CODE SICBL Code string SICBL code is the unique identifying code attributed to a Sub-ICB Location (SICBL).
SICBL_NAME SICBL Name string The name of the Sub-ICB Location (SICBL)
BNF_SECTION_CODE BNF Section Code string The first four digits of the 15-digit BNF Code, which indicate the chapter and section of the BNF where the drug is categorised.
BNF_SECTION_NAME BNF Section string The name of the BNF section where the drug is categorised
BNF_PARAGRAPH_CODE BNF Paragraph Code string The first six digits of the 15-digit BNF Code, which indicate the chemical substance under which the drug or appliance is categorised.
BNF_PARAGRAPH_NAME BNF Paragraph Name string The name of the BNF paragraph where the drug is categorised.
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.
CHEMICAL_SUBSTANCE_NAME 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.
TOTAL_PATIENTS Total Patient Count number A total count of patients, whether identified or unidentified by means of recording an NHS Number during prescription processing.
ITEM_COUNT 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.