search

ebmdatalab / price-per-dose

2 stars 1 forks source link

Why such variation in Dalteparin cost per pill? #28

Closed sebbacon closed 7 years ago

sebbacon commented 7 years ago

See #27 for Sara's original query. Assuming we're actually talking about Dalteparin sodium 18,000units/0.72ml solution then Sara's right that the DT price is the Fragmin price of £50.82 for 5. And only one brand is available.

Looking at the data for 10Q with this query:

SELECT
  *, net_cost/quantity as ppq
FROM
  ebmdatalab.tmp_eu.prescribing_2016_09_01
WHERE
  bnf_code like '0208010L0____AI%' AND pct='10Q'
  ORDER BY ppq

We can see a couple of over-priced items for 10Q (this is sorted by ppq):

image

If we look at all CCGs we can see there is a pattern here - these are not one-off transcription errors. It also doesn't appear to be related to quantity-recording errors (i.e a pack of 5 being recorded as 5 rather than 1)

image

How can a product which is in the DT be prescribed at costs consistently higher than the DT rate, when there appears to be no quantity-definition errors?

richiecroker commented 7 years ago

It wasn't in the dt at the time of the data. It was identified by dh to close np8 loophole.

On Thu, 2 Feb 2017, 11:52 Seb Bacon, notifications@github.com wrote:

See #27 https://github.com/ebmdatalab/price-per-dose/issues/27 for Sara's original query. Assuming we're actually talking about Dalteparin sodium 18,000units/0.72ml solution then Sara's right that the DT price is the Fragmin price of £50.82 for 5. And only one brand is available.

Looking at the data for 10Q with this query:

SELECT *, net_cost/quantity as ppqFROM ebmdatalab.tmp_eu.prescribing_2016_09_01WHERE bnf_code like '0208010L0____AI%' AND pct='10Q' ORDER BY ppq

We can see a couple of over-priced items for 10Q (this is sorted by ppq):

[image: image] https://cloud.githubusercontent.com/assets/211271/22547422/6fb00bf6-e939-11e6-9862-73e82e0e881b.png

If we look at all CCGs we can see there is a pattern here - these are not one-off transcription errors. It also doesn't appear to be related to quantity-recording errors (i.e a pack of 5 being recorded as 5 rather than 1)

[image: image] https://cloud.githubusercontent.com/assets/211271/22548011/50756f76-e93c-11e6-9048-a6ff078708a2.png

How can a product which is in the DT be prescribed at costs consistently higher than the DT rate, when there appears to be no quantity-definition errors?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ebmdatalab/price-per-dose/issues/28, or mute the thread https://github.com/notifications/unsubscribe-auth/AR0VZ3spU44ecLJY02h8sgD1DuSeTSNxks5rYcOJgaJpZM4L1BIq .