Diabetes
Table of Contents
Metadata
| Name | Diabetes |
| Type | Disease or Syndrome |
| Group | Endocrine |
| Data Sources | Clinical Practice Research DatallinkHospital Episode StatisticsOffice of National Statistics mortality |
| Clinical Terminologies | Read, ICD-10, ICD-9, OPCS-4 |
| Validation | cross-source, prognosis |
| Valid Event Data Range | 01/01/1999 - 01/07/2016 |
| Sex | Female/Male |
| Authors | Kuan, V; Denaxas, S; Gonzalez-Izquierdo, A; Direk, K; Bhatti, O; Husain, S; Sutaria, S; Hingorani, M; Nitsch, D; Parisinos, C; Lumbers, T; Mathur, R; Sofat, R; Casas, J; Wong, I; Hemingway, H; Hingorani, A; |
| Agreement Date | 20 May 2019 |
| Modified Date | 20 May 2019 |
| Version | Revision 1 |
Primary Care
In the Clinical Practice Research Datalink (CPRD, primary care data) we ascertained Diabetes cases by searching for Read terms related to an Diabetes diagnosis or evidence of endovascular/transluminal procedures related to the emergency repair of an aneurysmal segment of the aorta.
| Readcode | Medcode | ReadcodeDescr | Category |
|---|---|---|---|
| C108.12 | 17858 | Type 1 diabetes mellitus | Type I diabetes mellitus (3) |
| C108.13 | 24423 | Type I diabetes mellitus | Type I diabetes mellitus (3) |
| C108011 | 61344 | Type I diabetes mellitus with renal complications | Type I diabetes mellitus (3) |
| C108012 | 21983 | Type 1 diabetes mellitus with renal complications | Type I diabetes mellitus (3) |
| C108211 | 49146 | Type I diabetes mellitus with neurological complications | Type I diabetes mellitus (3) |
| C108212 | 61829 | Type 1 diabetes mellitus with neurological complications | Type I diabetes mellitus (3) |
| C108411 | 60107 | Unstable type I diabetes mellitus | Type I diabetes mellitus (3) |
| C108412 | 97474 | Unstable type 1 diabetes mellitus | Type I diabetes mellitus (3) |
| C108511 | 51957 | Type I diabetes mellitus with ulcer | Type I diabetes mellitus (3) |
| C108512 | 68390 | Type 1 diabetes mellitus with ulcer | Type I diabetes mellitus (3) |
| C108711 | 38161 | Type I diabetes mellitus with retinopathy | Type I diabetes mellitus (3) |
| C108712 | 41049 | Type 1 diabetes mellitus with retinopathy | Type I diabetes mellitus (3) |
| C108811 | 46850 | Type I diabetes mellitus - poor control | Type I diabetes mellitus (3) |
| C108812 | 45914 | Type 1 diabetes mellitus - poor control | Type I diabetes mellitus (3) |
| C108911 | 63017 | Type I diabetes mellitus maturity onset | Type I diabetes mellitus (3) |
| C108912 | 97446 | Type 1 diabetes mellitus maturity onset | Type I diabetes mellitus (3) |
| C108A11 | 95992 | Type I diabetes mellitus without complication | Type I diabetes mellitus (3) |
| C108D11 | 66872 | Type I diabetes mellitus with nephropathy | Type I diabetes mellitus (3) |
| C108E11 | 42729 | Type I diabetes mellitus with hypoglycaemic coma | Type I diabetes mellitus (3) |
| C108E12 | 70766 | Type 1 diabetes mellitus with hypoglycaemic coma | Type I diabetes mellitus (3) |
| C108F11 | 17545 | Type I diabetes mellitus with diabetic cataract | Type I diabetes mellitus (3) |
| C108H11 | 62352 | Type I diabetes mellitus with arthropathy | Type I diabetes mellitus (3) |
| C108J11 | 60208 | Type I diabetes mellitus with neuropathic arthropathy | Type I diabetes mellitus (3) |
| C108J12 | 18230 | Type 1 diabetes mellitus with neuropathic arthropathy | Type I diabetes mellitus (3) |
| C10E.00 | 1549 | Type 1 diabetes mellitus | Type I diabetes mellitus (3) |
| C10E.11 | 12455 | Type I diabetes mellitus | Type I diabetes mellitus (3) |
| C10E000 | 47582 | Type 1 diabetes mellitus with renal complications | Type I diabetes mellitus (3) |
| C10E100 | 47649 | Type 1 diabetes mellitus with ophthalmic complications | Type I diabetes mellitus (3) |
| C10E200 | 42831 | Type 1 diabetes mellitus with neurological complications | Type I diabetes mellitus (3) |
| C10E300 | 47650 | Type 1 diabetes mellitus with multiple complications | Type I diabetes mellitus (3) |
| C10E311 | 91942 | Type I diabetes mellitus with multiple complications | Type I diabetes mellitus (3) |
| C10E400 | 43921 | Unstable type 1 diabetes mellitus | Type I diabetes mellitus (3) |
| C10E411 | 49949 | Unstable type I diabetes mellitus | Type I diabetes mellitus (3) |
| C10E500 | 18683 | Type 1 diabetes mellitus with ulcer | Type I diabetes mellitus (3) |
| C10E511 | 93878 | Type I diabetes mellitus with ulcer | Type I diabetes mellitus (3) |
| C10E600 | 69993 | Type 1 diabetes mellitus with gangrene | Type I diabetes mellitus (3) |
| C10E700 | 18387 | Type 1 diabetes mellitus with retinopathy | Type I diabetes mellitus (3) |
| C10E711 | 95343 | Type I diabetes mellitus with retinopathy | Type I diabetes mellitus (3) |
| C10E800 | 35288 | Type 1 diabetes mellitus - poor control | Type I diabetes mellitus (3) |
| C10E900 | 40682 | Type 1 diabetes mellitus maturity onset | Type I diabetes mellitus (3) |
| C10E911 | 96235 | Type I diabetes mellitus maturity onset | Type I diabetes mellitus (3) |
| C10EA00 | 69676 | Type 1 diabetes mellitus without complication | Type I diabetes mellitus (3) |
| C10EA11 | 62613 | Type I diabetes mellitus without complication | Type I diabetes mellitus (3) |
| C10EB00 | 68105 | Type 1 diabetes mellitus with mononeuropathy | Type I diabetes mellitus (3) |
| C10EC00 | 46301 | Type 1 diabetes mellitus with polyneuropathy | Type I diabetes mellitus (3) |
| C10EC11 | 91943 | Type I diabetes mellitus with polyneuropathy | Type I diabetes mellitus (3) |
| C10ED00 | 10418 | Type 1 diabetes mellitus with nephropathy | Type I diabetes mellitus (3) |
| C10EE00 | 39070 | Type 1 diabetes mellitus with hypoglycaemic coma | Type I diabetes mellitus (3) |
| C10EF00 | 49554 | Type 1 diabetes mellitus with diabetic cataract | Type I diabetes mellitus (3) |
| C10EG00 | 93468 | Type 1 diabetes mellitus with peripheral angiopathy | Type I diabetes mellitus (3) |
| C10EH00 | 18642 | Type 1 diabetes mellitus with arthropathy | Type I diabetes mellitus (3) |
| C10EJ00 | 54008 | Type 1 diabetes mellitus with neuropathic arthropathy | Type I diabetes mellitus (3) |
| C10EK00 | 30323 | Type 1 diabetes mellitus with persistent proteinuria | Type I diabetes mellitus (3) |
| C10EL00 | 30294 | Type 1 diabetes mellitus with persistent microalbuminuria | Type I diabetes mellitus (3) |
| C10EM00 | 10692 | Type 1 diabetes mellitus with ketoacidosis | Type I diabetes mellitus (3) |
| C10EM11 | 62209 | Type I diabetes mellitus with ketoacidosis | Type I diabetes mellitus (3) |
| C10EN00 | 40837 | Type 1 diabetes mellitus with ketoacidotic coma | Type I diabetes mellitus (3) |
| C10EN11 | 66145 | Type I diabetes mellitus with ketoacidotic coma | Type I diabetes mellitus (3) |
| C10EP00 | 22871 | Type 1 diabetes mellitus with exudative maculopathy | Type I diabetes mellitus (3) |
| C10EP11 | 97894 | Type I diabetes mellitus with exudative maculopathy | Type I diabetes mellitus (3) |
| C10EQ00 | 55239 | Type 1 diabetes mellitus with gastroparesis | Type I diabetes mellitus (3) |
| C109.12 | 17859 | Type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C109.13 | 18219 | Type II diabetes mellitus | Type II diabetes mellitus (4) |
| C109011 | 50225 | Type II diabetes mellitus with renal complications | Type II diabetes mellitus (4) |
| C109012 | 18209 | Type 2 diabetes mellitus with renal complications | Type II diabetes mellitus (4) |
| C109111 | 59725 | Type II diabetes mellitus with ophthalmic complications | Type II diabetes mellitus (4) |
| C109112 | 70316 | Type 2 diabetes mellitus with ophthalmic complications | Type II diabetes mellitus (4) |
| C109211 | 67905 | Type II diabetes mellitus with neurological complications | Type II diabetes mellitus (4) |
| C109212 | 45919 | Type 2 diabetes mellitus with neurological complications | Type II diabetes mellitus (4) |
| C109411 | 55075 | Type II diabetes mellitus with ulcer | Type II diabetes mellitus (4) |
| C109412 | 65704 | Type 2 diabetes mellitus with ulcer | Type II diabetes mellitus (4) |
| C109511 | 62107 | Type II diabetes mellitus with gangrene | Type II diabetes mellitus (4) |
| C109512 | 46150 | Type 2 diabetes mellitus with gangrene | Type II diabetes mellitus (4) |
| C109611 | 58604 | Type II diabetes mellitus with retinopathy | Type II diabetes mellitus (4) |
| C109612 | 42762 | Type 2 diabetes mellitus with retinopathy | Type II diabetes mellitus (4) |
| C109711 | 24458 | Type II diabetes mellitus - poor control | Type II diabetes mellitus (4) |
| C109712 | 45913 | Type 2 diabetes mellitus - poor control | Type II diabetes mellitus (4) |
| C109A11 | 50813 | Type II diabetes mellitus with mononeuropathy | Type II diabetes mellitus (4) |
| C109B11 | 47409 | Type II diabetes mellitus with polyneuropathy | Type II diabetes mellitus (4) |
| C109C11 | 64571 | Type II diabetes mellitus with nephropathy | Type II diabetes mellitus (4) |
| C109C12 | 24836 | Type 2 diabetes mellitus with nephropathy | Type II diabetes mellitus (4) |
| C109D11 | 56268 | Type II diabetes mellitus with hypoglycaemic coma | Type II diabetes mellitus (4) |
| C109D12 | 61071 | Type 2 diabetes mellitus with hypoglycaemic coma | Type II diabetes mellitus (4) |
| C109E11 | 48192 | Type II diabetes mellitus with diabetic cataract | Type II diabetes mellitus (4) |
| C109E12 | 44779 | Type 2 diabetes mellitus with diabetic cataract | Type II diabetes mellitus (4) |
| C109F11 | 54899 | Type II diabetes mellitus with peripheral angiopathy | Type II diabetes mellitus (4) |
| C109F12 | 60699 | Type 2 diabetes mellitus with peripheral angiopathy | Type II diabetes mellitus (4) |
| C109G11 | 18143 | Type II diabetes mellitus with arthropathy | Type II diabetes mellitus (4) |
| C109G12 | 49869 | Type 2 diabetes mellitus with arthropathy | Type II diabetes mellitus (4) |
| C109H11 | 47816 | Type II diabetes mellitus with neuropathic arthropathy | Type II diabetes mellitus (4) |
| C109H12 | 66965 | Type 2 diabetes mellitus with neuropathic arthropathy | Type II diabetes mellitus (4) |
| C109J00 | 18278 | Insulin treated Type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C109J12 | 18264 | Insulin treated Type II diabetes mellitus | Type II diabetes mellitus (4) |
| C109K00 | 36633 | Hyperosmolar non-ketotic state in type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C10F.00 | 758 | Type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C10F.11 | 22884 | Type II diabetes mellitus | Type II diabetes mellitus (4) |
| C10F000 | 18777 | Type 2 diabetes mellitus with renal complications | Type II diabetes mellitus (4) |
| C10F011 | 57278 | Type II diabetes mellitus with renal complications | Type II diabetes mellitus (4) |
| C10F100 | 47321 | Type 2 diabetes mellitus with ophthalmic complications | Type II diabetes mellitus (4) |
| C10F200 | 34268 | Type 2 diabetes mellitus with neurological complications | Type II diabetes mellitus (4) |
| C10F211 | 98616 | Type II diabetes mellitus with neurological complications | Type II diabetes mellitus (4) |
| C10F300 | 65267 | Type 2 diabetes mellitus with multiple complications | Type II diabetes mellitus (4) |
| C10F311 | 43227 | Type II diabetes mellitus with multiple complications | Type II diabetes mellitus (4) |
| C10F400 | 49074 | Type 2 diabetes mellitus with ulcer | Type II diabetes mellitus (4) |
| C10F411 | 91646 | Type II diabetes mellitus with ulcer | Type II diabetes mellitus (4) |
| C10F500 | 12736 | Type 2 diabetes mellitus with gangrene | Type II diabetes mellitus (4) |
| C10F600 | 18496 | Type 2 diabetes mellitus with retinopathy | Type II diabetes mellitus (4) |
| C10F611 | 49655 | Type II diabetes mellitus with retinopathy | Type II diabetes mellitus (4) |
| C10F700 | 25627 | Type 2 diabetes mellitus - poor control | Type II diabetes mellitus (4) |
| C10F711 | 47315 | Type II diabetes mellitus - poor control | Type II diabetes mellitus (4) |
| C10F900 | 47954 | Type 2 diabetes mellitus without complication | Type II diabetes mellitus (4) |
| C10F911 | 53392 | Type II diabetes mellitus without complication | Type II diabetes mellitus (4) |
| C10FA00 | 62674 | Type 2 diabetes mellitus with mononeuropathy | Type II diabetes mellitus (4) |
| C10FA11 | 95351 | Type II diabetes mellitus with mononeuropathy | Type II diabetes mellitus (4) |
| C10FB00 | 18425 | Type 2 diabetes mellitus with polyneuropathy | Type II diabetes mellitus (4) |
| C10FB11 | 50527 | Type II diabetes mellitus with polyneuropathy | Type II diabetes mellitus (4) |
| C10FC00 | 12640 | Type 2 diabetes mellitus with nephropathy | Type II diabetes mellitus (4) |
| C10FD00 | 46917 | Type 2 diabetes mellitus with hypoglycaemic coma | Type II diabetes mellitus (4) |
| C10FD11 | 98723 | Type II diabetes mellitus with hypoglycaemic coma | Type II diabetes mellitus (4) |
| C10FE00 | 44982 | Type 2 diabetes mellitus with diabetic cataract | Type II diabetes mellitus (4) |
| C10FE11 | 93727 | Type II diabetes mellitus with diabetic cataract | Type II diabetes mellitus (4) |
| C10FF00 | 37806 | Type 2 diabetes mellitus with peripheral angiopathy | Type II diabetes mellitus (4) |
| C10FG00 | 59253 | Type 2 diabetes mellitus with arthropathy | Type II diabetes mellitus (4) |
| C10FH00 | 35385 | Type 2 diabetes mellitus with neuropathic arthropathy | Type II diabetes mellitus (4) |
| C10FJ00 | 1407 | Insulin treated Type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C10FJ11 | 64668 | Insulin treated Type II diabetes mellitus | Type II diabetes mellitus (4) |
| C10FK00 | 34450 | Hyperosmolar non-ketotic state in type 2 diabetes mellitus | Type II diabetes mellitus (4) |
| C10FL00 | 26054 | Type 2 diabetes mellitus with persistent proteinuria | Type II diabetes mellitus (4) |
| C10FL11 | 60796 | Type II diabetes mellitus with persistent proteinuria | Type II diabetes mellitus (4) |
| C10FM00 | 18390 | Type 2 diabetes mellitus with persistent microalbuminuria | Type II diabetes mellitus (4) |
| C10FM11 | 85991 | Type II diabetes mellitus with persistent microalbuminuria | Type II diabetes mellitus (4) |
| C10FN00 | 32627 | Type 2 diabetes mellitus with ketoacidosis | Type II diabetes mellitus (4) |
| C10FP00 | 51756 | Type 2 diabetes mellitus with ketoacidotic coma | Type II diabetes mellitus (4) |
| C10FQ00 | 25591 | Type 2 diabetes mellitus with exudative maculopathy | Type II diabetes mellitus (4) |
| C10FR00 | 63690 | Type 2 diabetes mellitus with gastroparesis | Type II diabetes mellitus (4) |
Read terms are hierarhically organized in top-level chapters i.e. chapter G….00 is related to Circulatory System Diseases and sub-headings i.e. heading G2…00 is related to Hypertensive Heart Disease while G3…00 is related to Ischaemic Heart Disease.
Secondary Care
In Hospital Episode Statistics (HES, hospital admission data) we used ICD-10 terms (see below) for Diabetes diagnosis when marked as the primary diagnosis i.e. the main condition treated or investigated during the relevant episode of healthcare. We used the date of admission to hospital as the date of the event. We additionally searched for OPCS-4 terms indicating the emergency repair of an aneurysmal segment of the aorta.
| ICD10code | ICD10codeDescr | Category |
|---|---|---|
| E10 | Insulin-dependent diabetes mellitus | Insulin dependent diabetes (3) |
| E11 | Non-insulin-dependent diabetes mellitus | Non insulin dependent diabetes (4) |
| E12 | Malnutrition-related diabetes mellitus | Secondary diabetes (5) |
| O242 | Diabetes mellitus in pregnancy: Pre-existing malnutrition-related diabetes mellitus | Secondary diabetes (5) |
| E13 | Other specified diabetes mellitus | Diabetes not otherwise specified (6) |
| E14 | Unspecified diabetes mellitus | Diabetes not otherwise specified (6) |
| G590 | Diabetic mononeuropathy | Diabetes not otherwise specified (6) |
| G632 | Diabetic polyneuropathy | Diabetes not otherwise specified (6) |
| H280 | Diabetic cataract | Diabetes not otherwise specified (6) |
| H360 | Diabetic retinopathy | Diabetes not otherwise specified (6) |
| M142 | Diabetic arthropathy | Diabetes not otherwise specified (6) |
| N083 | Glomerular disorders in diabetes mellitus | Diabetes not otherwise specified (6) |
| O240 | Diabetes mellitus in pregnancy: Pre-existing diabetes mellitus, insulin-dependent | Diabetes not otherwise specified (6) |
| O241 | Diabetes mellitus in pregnancy: Pre-existing diabetes mellitus, non-insulin-dependent | Diabetes not otherwise specified (6) |
| O243 | Diabetes mellitus in pregnancy: Pre-existing diabetes mellitus, unspecified | Diabetes not otherwise specified (6) |
Implementation
Use MODIFIED CALIBER 'Diabetes' phenotyping algorithm for
1. T1DM,
2. T2DM,
3. 'Diabetes' other or uncertain type:
IF there is at least one record for code for type 2 'Diabetes' (diabdiag_gprd = 4)
and no record for type 1 'Diabetes' (no record with diabdiag_gprd = 3)
then classify the patient as type 2 'Diabetes'
ELSE if there is at least one record for code for type I 'Diabetes' (diabdiag_gprd = 3)
and no record for type 2 'Diabetes' (no record with diabdiag_gprd = 4)
then classify the patient as type 1 'Diabetes'
ELSE if there is at least one record of type 1 'Diabetes' (diabdiag_gprd = 3)
and type 2 'Diabetes' (diabdiag_gprd = 4)
then classify as 'Diabetes' other or uncertain type
ELSE if there are no diabdiag_gprd records for this patient:
If there is at least one record for Non-insulin-dependent 'Diabetes' mellitus (NIDDM) (dm_gprd = 4 or dm_hes = 4)
and no record for IDDM (no record with dm_gprd = 3 or dm_hes = 3)
then classify the patient as type 2 'Diabetes'
ELSE if there is at least one record for Insulin-dependent 'Diabetes' mellitus (IDDM) (dm_gprd = 3 or dm_hes = 3)
and no record for NIDDM (no record with dm_gprd = 4 or dm_hes = 4)
then classify the patient as type 1 'Diabetes'
ELSE if there is at least one record of 'Diabetes' (dm_gprd or dm_hes category 3, 4, 5 or 6)
then classify as 'Diabetes' other or uncertain type
ELSE classify as no 'Diabetes'
Publications
- Kuan V., Denaxas S., Gonzalez-Izquierdo A. et al. A chronological map of 308 physical and mental health conditions from 4 million individuals in the National Health Service published in the Lancet Digital Health - DOI 10.1016/S2589-7500(19)30012-3