Skip to main content

Publication, Part of

NICE Technology Appraisals in the NHS in England (Innovation Scorecard) to March 2019

Official statistics

Publication Date:
10 Oct 2019
Geographic Coverage:
England
Geographical Granularity:
Country, Regions, Integrated Care Boards, Sub-Integrated Care Boards, NHS Trusts
Date Range:
01 Apr 2014 to 31 Mar 2019

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

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

Medical technologies, use and purchase of medicines data files (… MedtechUtilisationPurchaseCSV)

  • Trust level data for medicine purchase data of medicines extracted from the Pharmex database held by the Commercial Medicines Unit (CMU) in the Department of Health (DH)
  • National level data for medicine use – national level prescribing data for medicines
  • Regional level data for medicine use – regional level prescribing data for medicines
  • CCG level data for medicine use – Clinical Commissioning Group (CCG) level prescribing data for medicines
  • Regional level data for medical technologies use:
    • The Debrisoft monofilament debridement pad for use in acute or chronic wounds
    • Spinal cord stimulation for chronic pain of neuropathic or ischaemic origin

Medicine groupings data files (… MedicineGroupingsCSV)

  • National level data for grouped medicines use – national prescribing data for medicines used to treat the following conditions:
    • Acute coronary syndrome
    • Diabetes
    • Hepatitis C
    • Multiple sclerosis
    • NOAC medicines used in Primary Care
  • Regional level data for grouped medicines use – regional prescribing data for medicines used to treat the following conditions:
    • Acute coronary syndrome
    • Diabetes
    • Hepatitis C
    • Multiple sclerosis
    • NOAC medicines used in Primary Care
  • CCG level data for grouped medicines use – CCG prescribing data for medicines used to treat the following conditions:
    • Acute coronary syndrome
    • Diabetes
    • Hepatitis C
    • Multiple sclerosis
    • NOAC medicines used in Primary Care
  • National level data for grouped NOAC medicines used in Secondary Care – national prescribing data for NOAC medicines used in Secondary Care
  • Regional level data for grouped NOAC medicines used in Secondary Care – regional prescribing data for NOAC medicines used in Secondary Care

 

Structure of the data

All files share a common structure, with the exception of data for grouped NOAC 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 – national level prescribing data

Regional utilisation – Regional level prescribing data

CCG utilisation – clinical commissioning group level prescribing data

Trust Purchase data

Regional medtech
5

data_source

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

FP10 = ePACT Primary Care data

FP10HP = ePACT data prescribed in hospitals, dispensed in the community

HPAI = Hospital prescribing data

Pharmex data

HES = Hospital Episode Statistics

Primary care = data from ePACT

Secondary care = data from HPAI

 
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 NOACs 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 NOACs medicines in Secondary Care only

No. Variable name Description
13

expected_days_of_treatment

Days of treatment with NOACs 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 NOACs 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 NOACs 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: 5 July 2021 6:00 pm