1. ENGLAND
1.1 Engand Adults
The latest England QOF (Quality and Outcomes Framework) data was published on 29 October 2013 and covers the period of April 2012 to March 2013: Quality and Outcomes Framework - 2012-13 (QOF 2012-2013) - on that page is a series of files and zipped folders in the first section, called Resources.
When unzipped the 6th item in the list, called "Quality and Outcomes Framework - 2012-13: England level [.zip]" will produce several subfolders including a 'Prevalence' one which houses a single file (qof-12-13-data-tab-eng-prev.xlsx) that contains the England prevalence data for each of the 'clinical indicators' (ie diseases or conditions).
The relevant figure for diabetes is in cell C39 - there are 2,703,044 people over age of 17, in England, with diabetes ("However it should be noted that the diabetes register was expanded from April 2012 to include all types of diabetes (except gestational diabetes), having previously only included patients with type 1 or type 2 diabetes." page p24 of 38 of Quality and Outcomes Framework - 2012-13: Report [.pdf], which is the first Resources file in the (QOF 2012-2013) page linked above). Data below comes from cells M15-N18.
Geographic location: England
Age coverage: 17+
Source: QOF data
Reference: Quality and Outcomes Framework - 2012-13
1.2 English regions - adults
The 7th item in the QOF 2012-2013 list is Quality and Outcomes Framework - 2012-13: Region level [.zip] and when unzipped it produces several folders including a Prevalence one. That has a single file in it, called qof-12-13-data-tab-reg-prev.xlsx - there are two tabs in this spreadsheet, make sure you look in the second one (Region_AgeSpecificPrevalence) which has age-specific data (diabetes is only counted for people aged 17 and over).
A B C
NORTH OF ENGLAND COMMISSIONING REGION 793,817 6.3
MIDLANDS AND EAST OF ENGLAND COMMISSIONING REGION 850,280 6.3
LONDON COMMISSIONING REGION 418,346 5.8
SOUTH OF ENGLAND COMMISSIONING REGION 640,601 5.5
A: Region Name
B: Sum of Diabetes Mellitus (Diabetes) Register (ages 17+)
C: Diabetes Mellitus (Diabetes) Prevalence
Geographic location: England
Age coverage: 17+
Source: QOF data
Reference: Quality and Outcomes Framework - 2012-13
1.3 England children
2010/2011 data - as of 25 November 2013 this seems to be the most recent
(A) “Audit data from England and Wales were returned on 23,676 infants, children and young people under the age of 25 years with diabetes.”
Geographic location: England and Wales
Age group: Under 25 years
Source: National Paediatric Diabetes Audit
Reference: National Paediatric Diabetes Audit Report 2010-11 (September 2012)
(B) "The National Paediatric Diabetes Audit (NPDA) 2010-11 identified 23,516 infants, children and young people (to age 25) in England and Wales as registered with diabetes. The vast majority of infants, children and young people have type 1 diabetes, although there is considerable variability across regions in England."
Geographic location: England and Wales
Age group: Under 25 years
Source: National Paediatric Diabetes Audit via TheyWorkForYou.com
Reference: Diabetes: Children - Health (4 March 2013)
2 WALES
2.1 Wales adults
2.2 Welsh regions adults
2.3 Wales children
- see England children data above which includes both regions
3 SCOTLAND
3.1 Scotland adults
3.2 Scottish regions adults
3.3 Scotland children
4 NORTHERN IRELAND
4.1 Northern Ireland adults
4.2 Northern Ireland regions adults
4.3 Northern Ireland children