Tagged: diabetes statistics

How many people have diabetes in the UK? 2013-2014 figures

Here’s a table I wrote in Word, with footnote references, and I’ve copied and pasted it here and hope it all works… this just includes people over the age of 17 and those who are diagnosed and registered.

Nation Numbers of people >17 with diabetes
England 2,814,004[1]
Northern Ireland 81,867[2]
Scotland 259,986[3]
Wales 177,212[4]
TOTAL 3,333,069

[1] England: Cell M21 in tab ‘DM’ in QOF 2013-14: Prevalence, achievements and exceptions at region and nation level for England from Quality and Outcomes Framework (QOF) – 2013-14 (published 28 October 2014).

[2] Northern Ireland: Cell F14 in “Diabetes Indicator (MS Excel 77KB)”, from Achievement Data at Local Commissioning Group (LCG) Level 2013/14 (30 September 2014) . Previous QOF info.

[3] Scotland: Cell i20 in tab ‘by QOF register’ in file Prevalence reported from QOF registers (practices with any contract type) [xls] from Register and prevalence data at Scotland, NHS Board and CHP level, via Quality & Outcomes Framework (QOF), data for 2013-2014.

[4] Wales: Cell E15 in QOF data summary for Wales and local health boards, 2013-14 from StatsWales’ GMS Contract page.

More on the individual stats

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

There appear to be 177,212 people with diabetes in Wales and there were 173,299 last year.

How I got that number
To find this figure I looked at StatsWales’ GMS Contract page, which has a long bullet-pointed list of options. I chose the QOF data summary for Wales and local health boards, 2013-14 spreadsheet which gave me, in cell E15, the number I was after (hopefully!).

Picking the right number
What about all the other numbers? There are many of them in that Excel file, however the intersection of ‘Wales’ (ie ‘all’) and ‘patients on register’ seems right, and it tallies closely with last year’s published figure, as well as being reasonably similar to earlier published figures. I was briefly confused by StatsWales’ Quality and Outcomes Framework (QOF) points by local health board and register which suggested a much lower figure of 47,058 but I realise now this is referring to points not people. Also cross-referencing this to a reference, in 2006, of there being 150,000 people with diabetes in Wales at that time made me realise I was barking up the wrong tree. But it’s easy to pick the wrong number from a range of numbers when you don’t know for certain which is the correct one, so always worth double-checking I think!

More in this series

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