HelenCEBM commented 7 years ago

Page	Embed Link
`openprescribing.net/pca`	<div class='tableauPlaceholder' id='viz1506442689570' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrendsmulti-functionforOP/TRENDSDETAIL' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506442689570'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1243px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/antipsychotics`	<div class='tableauPlaceholder' id='viz1506443311761' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-Anti-Psychotics/Anti-Psychotics/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-Anti-Psychotics/Anti-Psychotics' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-Anti-Psychotics/Anti-Psychotics/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443311761'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/antidepressants`	<div class='tableauPlaceholder' id='viz1506443384483' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-Antidepressants/Antidepressants/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-Antidepressants/Antidepressants' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-Antidepressants/Antidepressants/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443384483'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/thyroid`	<div class='tableauPlaceholder' id='viz1506443224018' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-ThyroidHormones/ThyroidHormones/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-ThyroidHormones/ThyroidHormones' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-ThyroidHormones/ThyroidHormones/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443224018'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/testosterone`	<div class='tableauPlaceholder' id='viz1506443188995' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-Testosterones/Testosterone/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-Testosterones/Testosterone' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-Testosterones/Testosterone/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443188995'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/quinine`	<div class='tableauPlaceholder' id='viz1506443265722' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-Quinine/Quinine/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-Quinine/Quinine' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-Quinine/Quinine/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443265722'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
`/pca/nicotine`	<div class='tableauPlaceholder' id='viz1506443346786' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrends-NicotineDependence/Antidepressants/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrends-NicotineDependence/Antidepressants' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrends-NicotineDependence/Antidepressants/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506443346786'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1220px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>

HelenCEBM commented 7 years ago

Testing options for Thyroid hormones using main dashboard: view: https://public.tableau.com/shared/S2JJKJJ3F?:display_count=yes original: https://public.tableau.com/views/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL?:embed=y&:display_count=yes

embed view: <div class='tableauPlaceholder' id='viz1506506169146' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/S2/S2JJKJJ3F/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='path' value='shared/S2JJKJJ3F' /> <param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/S2/S2JJKJJ3F/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506506169146'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1243px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>

Embed original: <div class='tableauPlaceholder' id='viz1506506246298' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='path' value='views/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL?:embed=y&:display_count=y' /> <param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrendsmulti-functionforOP/TRENDSDETAIL/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1506506246298'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1243px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>

HelenCEBM commented 7 years ago

Final plan: embed on a single page only. The subject-specific dashboards will be available via Tableau directly instead. <div class='tableauPlaceholder' id='viz1507036021896' style='position: relative'><noscript><a href='#'><img alt=' ' src='https://public.tableau.com/static/images/Pr/PrescribingTrendsfnalforOP/TRENDSDETAIL/1_rss.png' style='border: none' /></a></noscript><object class='tableauViz' style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='2' /> <param name='site_root' value='' /><param name='name' value='PrescribingTrendsfnalforOP/TRENDSDETAIL' /><param name='tabs' value='yes' /><param name='toolbar' value='yes' /><param name='static_image' value='https://public.tableau.com/static/images/Pr/PrescribingTrendsfnalforOP/TRENDSDETAIL/1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /></object></div> <script type='text/javascript'> var divElement = document.getElementById('viz1507036021896'); var vizElement = divElement.getElementsByTagName('object')[0]; vizElement.style.width='1120px';vizElement.style.height='1243px'; var scriptElement = document.createElement('script'); scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js'; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>

Explanatory text

This is an interactive tool for exploring the national Prescribing Cost Analysis (PCA) data. It shows annual data, going back to 1998, on all drugs dispensed in the community in England (note this makes it slightly different to the monthly dataset used elsewhere on OpenPrescribing). Here we have ensured that most drugs have a consistent classification over time, based on their current position in the latest BNF dictionary, so that time trends are not disrupted by drugs being reclassified, for example moving between Chapters. All figures are adjusted for England's population size and costs are corrected for inflation.

HelenCEBM commented 7 years ago

add: "Our paper describing this tool and the normalisation of the data is currently under review at BMJ Open"

HelenCEBM commented 7 years ago

FAQ section

How is this different to the data on the rest of the site?

This tool uses Prescription Cost Analysis (PCA) data back to 1998, which includes all items dispensed in the community (or personally administered by doctors) in England, whereas the data used elsewhere on the site shows what was prescribed. This means that, in this dataset:

generic codes do not appear until the generic product is available to be dispensed, even if doctors are prescribing generically.
items may have been prescribed by doctors in other parts of the UK provided they were dispensed in England.
any items prescribed in England but dispensed in other parts of the UK are excluded.

This data cannot be split down to individual months or practices.

How was the data normalised?

All figures are shown per 1000 population (adjusted for England's mid-year population size each year) and costs are corrected for inflation (using consumer price index), both obtained from the ONS.
We also normalised the data by drug name and classification, where possible, such that drugs moving around Chapters, or changing name, do not disrupt the trends. We did this by mapping all drug names to their current position in the BNF. Drug names not matched exactly to a currently available item were assigned appropriate classifications via approximate matching, ensuring that drugs were not inappropriately moved across categories, e.g. those with multiple uses. Some chemicals which are no longer available will not have been assigned an up-to-date chemical code, but will have a chemical name (as supplied in the original dataset) and a product name (derived from the drug name). Efforts were concentrated on Chapters 1-6 and 10 so other Chapters may have more inconsistencies, particularly Chapters 9 (Nutrition) and 13 (Skin). The details are explained further in our paper, currently under review with BMJ Open, and in the code in GitHub.

How can I share the view I created?

Scroll to the bottom right, then:

To share the dashboard as a link for someone else to access, or to save for later, select Share. If you have made changes then "Current View" will be selected. Copy the link:
To share the view as an image or PDF, select Download and select your preferred option.

Can I download the data?

You can download the entire dataset, either the compiled original data or our normalised data, from FigShare.

When will it be updated?

The annual data is released in March each year; however, ONS figures for population size are not available until June.

HelenCEBM commented 7 years ago

Video walkthrough

sebbacon commented 6 years ago

@HelenCEBM is there anything else to do on this? If not, please feel free to close!

ebmdatalab / openprescribing

Implement Trends tool on OP #588

Explanatory text

FAQ section

How is this different to the data on the rest of the site?

How was the data normalised?

How can I share the view I created?

Can I download the data?

When will it be updated?