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