Skip to main content

Publication, Part of

NICE Technology Appraisals in the NHS in England (Innovation Scorecard), To June 2022

Official statistics

Publication Date:
27 Oct 2022
Geographic Coverage:
England
Geographical Granularity:
Country, Regions, Integrated Care Boards, Sub-Integrated Care Boards, NHS Trusts
Date Range:
01 Jul 2017 to 30 Jun 2022

Previous Chapter

Frequently Asked Questions

Current Chapter

A Guide to the Underlying Data (csv)

View all
Page contents

A Guide to the Underlying Data (csv)

Presentation of the data

NHS Digital makes available the underlying data of the Innovation Scorecard publication in a series of comma-separated variable (csv) files.  NHS Digital is leading the way in health open data and, wherever possible, releasing the data underpinning all of our publications and encouraging their innovative use.

The data has been released in csv files as these are simply tabulated data expressed in plain text, which are ideal for computer applications due to the lack of formatting.  csv files are widely recognised by computer applications and software packages, and their structure enables automatic import with minimal effort on behalf of the user. 

 

File structure

10 .csv files are released, grouped into two .zip files:

Output-Utilisation.csv

5 files, one each for National, Regional, STP, CCG and Trust level data for medicine utilisation for all medicines not included in a grouping

 

Output-Groupings.csv

5 files, one each for National, Regional, STP, CCG and Trusts level data for medicine utilisation for all medicines included in a grouping

 

 

Structure of the data

All files share a common structure, with the exception of data for grouped DOAC medicines used in Secondary Care.  Definitions of these variables are found below.

Variables for all files

No. Variable name Description Values

1

Year

Financial Year

e.g. 2013_14
2

Quarter

Financial Quarter
  • 1 = 1st April to 30th June
  • 2 = 1st July to 30th September
  • 3 = 1st October to 31st December
  • 4 = 1st January to 31st March
3

Year_Quarter

Financial Year and Quarter

e.g. 2013/14 Q1 = 1st April 2013 to 30th June 2013
4

data_type

This indicates the data type

National utilisation 

Regional utilisation 

CCG utilisation 

Trust utilisation

STP utilisation
5

data_source

This indicates the source of the data; this can be from an existing data set

 

Primary care = data from EPD

Secondary care = data from SCMD

 
6

treatment_type

This indicates the type of treatment

Medicine

MedTech = Medical Technology
7

treatment_name

The name of the treatment or the treatment group

 
8

provider_code

This is the code of the provider, where the provider is the level of geographical breakdown

Region Code

CCG Code

Trust Code
9

provider_name

This is the name of the provider, where the provider is the level of geographical breakdown

Region Name

CCG Name

Trust Name
10

numerator

This figure will indicate the volume used or the amount purchased

 
11

numerator_unit

This is the unit of the numerator

Defined Daily Dose (DDD)

Actual Daily Dose (ADD)

mgs

units

vials

intervention

pads

tablets

etc.
12

high_level_condition

This indicates the high level condition that the medicine is used to treat
  • Alcohol dependence
  • Allergy
  • Anaemia
  • Asthma
  • Atrial fibrillation
  • Auto-immune conditions
  • Cancer
  • Chronic migraine
  • Constipation
  • Cystic fibrosis
  • Diabetes
  • Eye conditions
  • Heart disease
  • Hepatitis C
  • Idiopathic pulmonary fibrosis
  • Kidney disease
  • Overactive bladder
  • Platelet Disorders

etc.

 

Variables for all files with the exception of data for grouped medicines DOACs in Secondary Care

No. Variable name Description Values
13

denominator

This is the figure that is used to standardise the numerator

 
14

denominator_unit

This is the unit of the denominator
  • Population
  • FCE days of hospital care

etc.
15

value

This is the standardised figure for use

e.g. value = numerator / denominator
16

value_unit

This is the unit of the standardised figure for use

e.g. numerator unit per 100,000 denominator unit

  • Tablets per 100,000 population
  • DDD per 100,000 population
  • Vials per 100,000 population
  • mgs per 100,000 FCE days hospital care

etc.

 

Variables for grouped medicine DOACs medicines in Secondary Care only

No. Variable name Description
13

expected_days_of_treatment

Days of treatment with DOACs calculated from the number of hip and knee replacements undertaken and the average days of treatment as specified in the NICE guidance
14

expected_upper_range

Upper range of expected days of treatment with DOACs calculated from the number of hip and knee replacements undertaken and the maximum days of treatment as specified in the NICE guidance
15

expected_lower_range

Lower range of expected days of treatment with DOACs calculated from the number of hip and knee replacements undertaken and the minimum days of treatment as specified in the NICE guidance
16

ratio_observed:expected

Ratio of observed ADDs to calculated expected days of treatment
17

upper_ratio_observed:expected

Ratio of observed ADDs to calculated upper range expected days of treatment
18

lower_ratio_observed:expected

Ratio of observed ADDs to calculated lower range expected days of treatment

 

 

Administrative Sources

• English Prescribing Dataset (EPD) published by the NHS Business Services Authority • Secondary Care Medicines Data (SCMD) published by the NHS Business Services Authority • Hospital Episode Statistics (HES) data from NHS England • Population data from Office for National Statistics

Last edited: 29 September 2023 2:31 pm