The NHS now releases hospital usage data, which enables us to look at monthly data by Trust for all products used.
From Autumn 2020 NHS Digital is publishing secondary care medicines data under the government Open Licence. The data provides processed pharmacy stock control data for all NHS Trusts in England (Acute, Teaching, Specialist, Mental Health and Community Trusts).
This is a monthly dataset with data available, at molecule form and strength level, approximately 6 weeks after the end of the month. Back data has been made available from January 2019.
The data has been launched with a single metric – the total quantity in the Virtual Medicinal Product Unit. For the vast majority of pharmaceuticals this is equivalent to the quantity metric found in the primary care Rx data.
We now also have cash value data available, helping our clients understand how much products cost, as well as volume sales. Indicative cost data is used as NHS hospital pricing contracts are confidential as are NICE Patient Access Scheme prices. This new information on the indicative cost of medicines supplied is included within the SCMD dataset.
Opposite is an extract with a look at biologic prescribing for the main Trusts in London. You will notice the lack of co-ordination at present.
The data is published with the normal Open Licence terms, and importantly is permitted for commercial use. The data currently includes 94.6% of hospital pharmacy issued medicines. It does not include medicines prescribed in secondary care which have been dispensed in the community, but these data are published separately.
Value data is expected to be provided soon. Early documentation implies that this is a limited time dataset, however the NHS has expressed a desire to use this for monitoring going forward so it is likely that it will be extended, especially if significant usage is demonstrated, as per previous datasets.
The data are freely available and can be downloaded directly from the NHS Digital website each month.
Alternatively, CSL can provide these data on a subscription basis. In return for a processing fee, CSL will provide the following added value to the data:
Example for the novel oral anticoagulants (NOACs) market
One-off extracts of data can also be provided, along with bespoke consultancy, for example:
NHS Digital will be publishing data monthly, but 45% of the data sources from which the extract is based are subject to revision when a full year refresh is published in the May of each year (for the financial year just finished). Up to that point data is provisional. At the current time, two NHS Trusts are not providing data:
• UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST (RRV)
• GREAT ORMOND STREET HOSPITAL FOR CHILDREN NHS FOUNDATION TRUST (RP4)
CSL understands that these Trusts are also missing from other industry standard datasets.
Over 8,000 products are provided, but no structure is provided to group these. Structure files are available from TRUD, but these are subject to an additional usage licence from SNOMED, and as such cannot be used for commercial purposes.
Award-winning data analytics across health, pharma and related industries
Fully compliant with global data security processes - ISO 27001 certified
Expertise across numerous award-winning software platforms
Bespoke health data insights delivered at speed – we listen and we get results
Agile, responsive approach built on personal relationships with talented consultants