Tagged: UK stats

Quality and Outcomes Framework – how many people have #diabetes? (in Scotland)

tl;dr – 259,986 according to 2013-2014 QOF figures for Scotland. Last year it was 252,599.


I’m foraging for figures from the QOF (Quality and Outcomes Framework) from the four UK nations and I’m very grateful to previous me for having left instructions on how to do this. Staring at a list of Excel files is fairly bewildering at the best of times. Here’s what I wrote in a note to myself, around this time last year…

“Data from 2012/13 QOF Prevalence Data, look for Prevalence reported from QOF registers (practices with any contract type) [180KB], file is called QOF_Scot_201213_Boards_all_prevalence.xls and in Cell I21 the number is given as 252,599.”

I’ve found that a better location to start is the landing page for all of Scotland’s QOF data which presents links to the latest figures at the bottom of the page with info on how to find previous ‘editions’ in the archive.

I chose the fifth link,”Register and prevalence data at Scotland, NHS Board and CHP level“, in the list and then “Prevalence reported from QOF registers (practices with any contract type) [180KB]” which opens up a spreadsheet with three tabs. Look at the third tab, “by QOF register” and the relevant info is in cell i21 – it’s 259,986 people registered with diabetes.

As always I tend to find that the figures listed in the annual Scottish Diabetes Survey differ slightly. Its landing page has the full listing of SDSes going back to 2002.

The latest SDS is 2013 data (I think it was published in July, but difficult to be certain without asking someone) and it reported that 268,154 people had diabetes in Scotland at the end of 2013. Clearly the numbers don’t match and the obvious thing would be that the SDS includes children whereas QOF is people over the age of 17. However that doesn’t quite work because there seem to be around 3,000 children with diabetes in Scotland. Hmm.

So the numbers don’t match… but I’ve decided to make my peace with that 😉

But if you can shed light on this… let me (@JoBrodie) know, thanks 🙂

More in this series

Quality and Outcomes Framework – how many people have #diabetes? (in England)


tl;dr – 2,814,004 people.


Every year the new ‘QOF’ figures are released in October. The figures have purpose A (used to pay GPs according to the number of patients registered at their practice and who receive certain care targets) but I use them for purpose B (how many people are registered as having diabetes?).

Generally it’s people over the age of 17 who are registered and it doesn’t tell you how many have type 1 or type 2 diabetes (but there are sensible guesstimates of around 10-15% have type 1).

Last year the figures, for England, gave 2,703,044 people with diabetes.

The new QOF figures were released on 28 October 2014 (for 2013-2014 data) and you can find all the files here http://www.hscic.gov.uk/catalogue/PUB15751 – there are 23 files. I’ll save you the search, the relevant one is: QOF 2013-14: Prevalence, achievements and exceptions at region and nation level for England [.xlsx] ie the filename is qof-1314-prev-ach-exc-region-nation.

Once opened look for tab DM and you can see (in cell M21) that there are now 2,814,004 people with diabetes in England. If you disagree with me, do let me (@JoBrodie) know!

And now for the other nations… 🙂

More in this series