| Field | Value |
|---|---|
| Data last updated | April 18, 2023 |
| Metadata last updated | April 18, 2023 |
| Created | April 18, 2023 |
| Format | CSV |
| License | Open Government Licence 3.0 (United Kingdom) |
| 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 https://digital.nhs.uk/services/organisation-data-service/data-downloads/other-nhs-organisations. |
| 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 |