Local - city level, PCT
Birmingham
How many people in Selly Oak have diabetes? Possibly 584, not convinced, see worked example.
Bristol
How many people in Bristol have diabetes (2010 figures)?
Total: APHO prevalence model
Number of people with diabetes (includes diagnosed and undiagnosed) in 2010 = 22,246 people (APHO) – note the variance in predicted prevalence (see below) [Source APHO 1]
Recorded (‘actual’): QOF figures
Bristol PCT = 16,462 people on the records in 2009/2010 [Source QOF 1]
Undiagnosed: the difference
Estimate of undiagnosed is therefore 22,246 – 16,462 = 5,784 undiagnosed.
Cheshire
11,429 people with diabetes in Western Cheshire PCT. 21,508 people with diabetes in Eastern and Central Cheshire PCT.
QOF data.
Coventry (source Coventry, 2011)
How many people have diabetes in Coventry (in 2011)?
15,802 - diagnosed - QOF data
London
prevalence - about 350,000
http://www.diabetes.nhs.uk/in_your_area/london/
http://www.yhpho.org.uk/default.aspx?RID=81090
Sources
APHO 1
http://www.yhpho.org.uk/default.aspx?RID=81090
File: http://www.yhpho.org.uk/resource/view.aspx?RID=81123 (choose 2010 tab)
NHS IC - QOF 1 2010
QOF0910_Pracs_Prevalence_Aug_2011 (4th file listed on that page, linked under "Practice level QOF tables 2009/10 - prevalence") via Prevalence data tables 2009/10
Open file, column N is for diabetes, search for Bristol PCT and count up all instances.
NHS IC - QOF 2011 landing page
Coventry
filename: QOF1011_PCTs_Prevalence, cell M75 for Coventry
Source: third file in the landing page, listed as PCT level QOF tables 2010/11 - prevalence (xls 276KB)
Landing page: QOF prevalence data tables 2010/11
APHO
Health Profile Areas - all | eg, Manchester (2006 - 2011) |