Hospital prescribing dispensed in community - February 2023

Report an issue

This resource view is not available at the moment. Click here for more information.

Download resource


Additional Info

Field Value
Data last updated unknown
Metadata last updated unknown
Created unknown
Format CSV
License Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column Title Type Description
PERIOD Year and Month as YYYYMM date

Example: 201401

BNF_NAME British National Formulary (BNF) Name string

The name given to the specific type, strength, and formulation of a drug or the specific type of an appliance. For example, Amoxicillin 500mg capsules

BNF_CODE British National Formulary (BNF) Name string

The unique code used to refer to a BNF Presentation. For example, 0501013B0AAABAB.

HOSPITAL_TRUST_CODE The Hospital Trust's Organisation Data Service Code (ODS) string

The Hospital Trust's Organisation Data Service Code (ODS), for example R1A. Look up files are provided and maintained by NHS Digital, for example see: Trusts under

HOSPITAL_TRUST The Hospital Trust's Organisation Name string

An NHS Trust is a legal entity, set up by order of the Secretary of State under section 25 of, and Schedule 4 to, the National Health Service Act 2006, to provide goods and services for the purposes of the health service.

QUANTITY Quantity number

The quantity of a medicine, dressing or appliance for which an individual item was prescribed and dispensed, for each BNF Presentation. This represents a pseudo pack size, to illustrate the typical range of prescribed quantities of a given presentation. For example, a quantity of 28 for Amoxicillin 500mg capsules means that the pack size dispensed was 28 capsules.

TOTAL_QUANTITY Total Quantity number

The total quantity of a drug or appliance that was prescribed. This is calculated by multiplying the prescribed Quantity by Items. For example, if 2 items of Amoxicillin 500mg capsules with a quantity of 28 were prescribed, Total Quantity will be 56.

TOTAL_ITEMS Total Items number

The number of times a product appears on a prescription form. Prescription forms include both paper prescriptions and electronic messages.

TOTAL_ACTUAL_COST Total Actual Cost number

The basic cost after adjustment for the national average discount and some payments to the dispenser. The calculation is: Net Ingredient Cost - National Average Discount Percentage + (payment for consumables + out of pocket expenses + payment for containers)

TOTAL_NIC Total Net Ingredient Cost (NIC) number

In British Pounds Sterling (GBP). The amount paid using the basic price of the drug, appliance or medical device as stated in Part II Clause 8 of the Drug Tariff