Skip to main content

Table 1 NHS prescription dataset with description for each column

From: PrAna: an R package to calculate and visualize England NHS primary care prescribing data

SHA PCT PRACTICE BNF CODE BNF NAME ITEMS NIC ACT COST QUANTITY PERIOD
Q44 RTV Y04937 0304010W0BBABAL Phenergan_Tab 25 mg 3 8.15 7.89 98 201801
Q44 RTV Y04937 0401010Z0AAAAAA Zopiclone_Tab 7.5 mg 7 2.88 3.35 98 201801
Q44 RTV Y04937 0401020K0AAAHAH Diazepam_Tab 2 mg 5 3.76 3.94 191 201801
Q44 RTV Y04937 0402010ADAAAAAA Aripiprazole_Tab 10 mg 3 13.64 12.88 63 201801
Q44 RTV Y04937 0402010ADAAADAD Aripiprazole_Tab 5 mg 1 1.36 1.37 7 201801
Column Description
SHA From April 2013 onwards, this code refers to Area Team
PCT From April 2013 onwards, this code refers to Clinical Commissioning Group (CCG) code
PRACTICE GP Practice code
BNF CODE Unique identifier to show what is prescribed
BNF NAME Describes the formulation and strength as well as the drug’s brand or generic (product) name
ITEMS Number of prescription items dispensed
NIC The drug tariff price in pounds and pence, which may be subject to further charges and/or discounts
ACT COST Actual cost—pounds and pence
QUANTITY Quantity represents the quantity of a drug dispensed, with units of measurement (units/tablets/grams/millilitres, etc.) dependent on its formulation
PERIOD Prescribed year and month