FOI 24438



Freedom of Information Disclosure Log

The NHSBSA's responses to Freedom of Information requests. read more


Open Government Licence 2.0 (United Kingdom) [Open Data]

FOI 24438


Last year you provided me with a response to a Freedom of Information request [Ref: 12819] in relation to the prescribing of drugs for erectile dysfunction (BNF 7.4.5).

Could you provide me with a similar response this year? Specifically, could you state:

Q1. For the 2021 calendar year please state how many prescriptions were issued for drugs of BNF 7.4.5 for erectile dysfunction? Please break these prescriptions down into age groups for the people they were prescribed to in the following age brackets

(i) 0-9

(ii) 10-19

(iii) 20-29

(iv) 30-39

(v) 40-49

(vi) 50-59

(vii) 60-69

(viii) 70-79

(ix) 80-89

(x) 90 and above.

Also please state the age of the oldest person prescribed a medication from that category (BNF 7.4.5) in 2021?

Q2. In relation to the drugs prescribed in 2021 could you please state how many prescriptions, and the cost was for each of the chemicals within section 7.4.5.?

Q3. In relation to the 2021 calendar year please state for each CCG:

(i) how many prescriptions under 7.4.5 were made

(ii) the cost of these prescriptions

(iii) the total number of patients in that CCG that were provided with a prescription for this type of drug at any time during the year

(iv) the total number of male patients in this CCG.


A copy of the information is attached.

Within the data, E is being interpreted in Text as Scientific notation, for example 01E00 shown as 1.00E+00

You can fix this as follows: If you open a new Excel then - go to Data – From Text

  • select the csv file you want

– leave format as delimited

– next

– Comma – next

– highlight the CCG column

  • change to text

  • highlight column with the odd formatting

– change to text

– finish,

ok when the little import box pops up.

This should let you open it without the formatting issues.

NHS Prescription Services process prescriptions for Pharmacy Contractors, Appliance Contractors, Dispensing Doctors and Personal Administration with information then used to make payments to pharmacists and appliance contractors in England for prescriptions dispensed in primary care settings (other arrangements are in place for making payments to Dispensing Doctors and Personal Administration). This involves processing over 1 billion prescription items and payments totalling over £9 billion each year. The information gathered from this process is then used to provide information on costs and trends in prescribing in England and Wales to over 25,000 registered NHS and Department of Health and Social Care users.

Time Period - Monthly files from January 2021 to December 2021

Drugs - Limited to drugs prescribed in the BNF Paragraph 070405 - Drugs for erectile dysfunction. Please note that the BNF paragraph does not guarantee the clinical indication.

Organisation Data - Prescribing has been split by Clinical Commissioning Groups (CCGs) Prescribing is limited to prescribing in GP practices in English CCGs only.

Identified patients/patient counts - Patients have been counted only if their NHS number was captured during NHSBSA processing. The patient's NHS number may not be captured if, for example, it was not known at the time of writing the prescription, or it was hand-written on a paper prescription and the OCR scanners were unable to read it.

A patient may appear in multiple than one CCG if the have prescribing in multiple CCGs.

BNF Paragraph Code - The six digits at the beginning of a BNF code which specify the BNF Paragraph.

BNF Chemical Substance - The name of the Chemical substance, a subdivision within a sub-paragraph.

BNF Chemical Substance Code - The nine characters at the beginning of a BNF code which specify the Chemical substance of a drug.

Items - Items shows the number of times a product appears on a prescription form not the quantity prescribed.

Net Ingredient Cost (NIC(£)) - Net Ingredient cost (NIC) is the basic price of a drug as stated in Part II Clause 8 of the Drug Tariff but please note that where a price concession for items listed in Part VIII of the Drug Tariff has been agreed between the Department of Health and Social Care (DHSC) and the Pharmaceutical Services Negotiating Committee the NIC will reflect the concession price rather than the Drug Tariff price.

Male List Size for the year is calculated as the average of the 12 monthly male list sizes. A list size for a CCG is based on sum of the list sizes of the GP practices within that CCG.


The Data excludes:

•           Items not dispensed, disallowed and those returned to the contractor for further clarification.

•           Prescriptions prescribed and dispensed in Prisons, Hospitals and Private prescriptions.

•           Items prescribed but not presented for dispensing or not submitted to NHS Prescription Services by the dispenser.

Please note that this request and our response is published on our Freedom of Information disclosure log at:

If you have any queries regarding the data provided, or if you plan on publishing the data, please contact ensuring you quote the above reference. This is important to ensure that the figures are not misunderstood or misrepresented.

If you plan on producing a press or broadcast story based upon the data please contact This is important to ensure that the figures are not misunderstood or misrepresented.

The information supplied to you continues to be protected by the Copyright, Designs and Patents Act 1988 and is subject to NHSBSA copyright. This information is licenced under the terms of the Open Government Licence detailed at:

Should you wish to re-use the information you must include the following statement: “NHSBSA Information Services Data warehouse, NHSBSA Copyright 2022” This information is licenced under the terms of the Open Government Licence:

Failure to do so is a breach of the terms of the licence.

Information you receive which is not subject to NHSBSA Copyright continues to be protected by the copyright of the person, or organisation, from which the information originated.

Please obtain their permission before reproducing any third party (non NHSBSA Copyright) information.

Data and Resources

Additional Info

Field Value
Contact Information Governance
Version 1.0
State active
Last Updated May 16, 2022, 14:21 (UTC)
Created May 16, 2022, 14:19 (UTC)