Skip to main content

Publication, Part of

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

Official statistics

Publication Date:
26 Oct 2023
Geographic Coverage:
England
Geographical Granularity:
Country, Regions, Integrated Care Boards, Sub-Integrated Care Boards, NHS Trusts

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 England makes available the underlying data of the Innovation Scorecard publication in a series of comma-separated variable (csv) files.  NHS England 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-Groupings.csv

5 files, one each for National, Regional, ICB, sub ICB location and Trust level data for medicine utilisation for all medicines included in a grouping

Output-Utilisation.csv

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

Structure of the data

All files have a similar structure.

Each file for medicines in a grouping (apart from at sub ICB location level) includes additional variables that are populated only for the data rows for the DOAC Secondary grouping and its medicines.

Variables for all files

No. Variable name Description Example values
1

year

Financial Year

2022_23
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

2022/23 Q1 = 1st April 2022 to 30th June 2022
4

data_type

Geography level and type of data
  • National Grouping
  • Trust Utilisation
5

data_source

Source of the data
  • Primary care
  • Secondary care
6

treatment_type

Type of treatment

medicine

MedTech = Medical Technology
7

treatment_name

The name of the treatment or the treatment group

 
8

provider_code

The ODS code for the reported NHS geography or trust
  • E = England
  • 3 or 5 character ODS code
9

provider_name

The name of the reported NHS geography or trust

 
10

numerator

The volume used or the amount purchased

 
11

numerator_unit

The unit of the numerator
  • Assumed Daily Dose (ADD)
  • Defined Daily Dose (DDD)
  • tablets
  • mgs
  • units
  • vials
12

high_level_condition

The high level condition that the medicine is used to treat, or for some groupings the included group of medicines
  • Allergies
  • Arthritis
  • Chronic kidney disease
  • Cystic fibrosis
  • Hepatitis C
  • SGLT-2 inhibitors
13 denominator The figure that is used to standardise the numerator  
14 denominator_unit The unit of the denominator
  • Population
  • FCE days of hospital care
15 value

The standardised figure for use

(value = numerator *100,000/ denominator)

 
16 value_unit The unit of the standardised figure for use
  • Tablets per 100,000 population
  • DDD per 100,000 population
  • Vials per 100,000 population
  • mgs per 100,000 FCE days hospital care
17/23* provider_ons_code The ONS statistical health geography code for the reported organisation. 

E followed by 8 digits

*In the files for medicines not included in a grouping, and for medicines included in a grouping at sub ICB location level, provider_ons_code is the 17th variable. In the other files for medicines included in a grouping, provider_ons_code is the 23rd variable, after the additional variables listed below.

Empty values:

  • In the files for medicines included in a grouping, the variables denominator, denominator_unit, value and value_unit are empty for data rows for the DOAC Secondary grouping and its medicines.
  • In the Trust level files, the variable provider_ons_code is empty

Additional variables for National, Regional, ICB and Trust grouping files

The following variables in the medicine grouping files are only populated for the data rows for the DOAC Secondary grouping and its medicines.

No. Variable name Description
17

expected_days_of_treatment

Days of treatment with DOACs calculated from the number of hip and knee replacements recorded in HES data and the average days of treatment as specified in the NICE guidance
18

expected_upper_range

Upper range of expected days of treatment with DOACs calculated from the number of hip and knee replacements recorded in HES data and the maximum days of treatment as specified in the NICE guidance
19

expected_lower_range

Lower range of expected days of treatment with DOACs calculated from the number of hip and knee replacements recorded in HES data and the minimum days of treatment as specified in the NICE guidance
20

ratio_observed:expected

Ratio of observed ADDs to calculated expected days of treatment
21

upper_ratio_observed:expected

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

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: 27 October 2023 4:46 pm