Skip to main content

Publication, Part of

NICE Technology Appraisals in the NHS in England (Innovation Scorecard) To December 2020

Official statistics

Current Chapter

A Guide to the Underlying Data (csv)


Improvements for this publication:

  • Introduction of Secondary Care Medicines Data (SCMD) as supplied by Rx-Info and published by the NHS BSA.
  • All medicines are reported at organisation, regional and national level.
  • Addition of 3 new groupings and revision of existing medicine groupings to align with the 5 High Health Gain policy areas for NHS England and NHS Improvement.
  • Latest data is available up to December 2020. 5 full calendar years of Primary Care data, 4 full calendar years of Secondary Care data.

10 June 2021 00:00 AM

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

 

 



Last edited: 23 June 2021 1:03 pm