Print

Type 2 Diabetes

Evangelos Kontopantelis, David A Springate, David Reeves, Darren M. Aschroff, Martin Rutter, Iain Buchan, Tim Doran, Matthias Pierce, Darren M. Ashcroft

ID
PH569
Version ID
1138
Type
Drug
Data Sources
Valid event data range
01/04/2006 - 31/03/2012
Sex
♀  Female ♂  Male
Agreement Date
2014-12-16
Coding system
Read codes v2
Collections
ClinicalCodes Repository Phenotype Library
Tags
No tags

Definition

Data source:

We used the Clinical Practice Research Datalink (CPRD), a large primary care database that holds complete electronic patient records (including diagnoses, prescriptions and referrals) from participating family practices across the UK. A hierarchical clinical coding system (Read) is used to record the data. In July 2012, data were available for 644 practices and 13,772,992 patients. Full details of the database have been provided elsewhere.

Diabetes cohort:

We extracted data from 1 April 2006 to 31 March 2012 and, for ease of reporting and analysing, aggregated information into six financial years. Within each year, practice inclusion eligibility was determined by a CPRD assessment algorithm, which informs on practices considered to be of research standard; therefore, our cohort of practices varied over time. For each research standard practice and year, we defined as eligible patients those who were registered with the practice for the full year and were aged 18 years or over in that year. From these patients, using relevant Read codes for type 2 diabetes (e.g. C10F.00: Type 2 diabetes mellitus) and excluding those treated with insulin within 2 years of diagnosis, we identified 246,544 patients over the study period. Diagnoses were not constrained to the study period and a relevant code prior to the study as well as during the study period would flag a patient from the respective year onwards. Data on sex, age and removal from the database due to deaths were available and complete for all patients.We extracted data on diabetes-related macrovascular (myocardial infarction, stroke, peripheral vascular disease or amputation) and microvascular (retinopathy, neuropathy, nephropathy [chronic kidney disease stages 4–5] or foot ulcer) complications as well as comorbidities (asthma, coronary heart disease, chronic kidney disease [excluded from microvascular analysis], chronic obstructive pulmonary disease, depression, dementia, severe mental illness, heart failure, hypertension, stroke [excluded from macrovascular analysis], cancer, epilepsy, osteoarthritis, osteoporosis and hypothyroidism). Although we aimed to include all conditions associated with diabetes, the choice was partially determined by the domains incentivised under the Quality and Outcomes Framework (QOF), for which accuracy of diagnosis is considered high. Information was also extracted on smoking (never smoked, current, exsmoker and missing data),BMI, HbA1c levels (%), cholesterol levels (mmol/l) and systolic/diastolic BP (mmHg). Biometric measurement data were cleaned and we calculated patient means for each year when more than one relevant record was available. Using product lists we determined prescription prevalence (at least one) for relevant medications: ACE inhibitors, acarbose, α-blockers, anticoagulants, antiplatelet agents, β-blockers, calcium-channel blockers, thiazide diuretics, loop diuretics, dipeptidyl peptidase-4 inhibitors, glucagon-like peptide- 1 agonists, statins and other lipid-lowering drugs, meglitinides , metformin, sulfonylureas and thiazolidinediones. For approximately 60% of the practices, records were linked to Office of National Statistics (ONS) mortality data and we had access to death dates for all their patients. For these, using ICD-10 codes (www.who.int/classifications/icd/en/) we were able to estimate deathslinked to specific causes (underlying or in the top three): diabetes (E10–E16), ischaemic heart disease (I21–I22), stroke (I60–I64) or stroke excluding bleeds (excluding I63).

Publications

  • Evangelos Kontopantelis, David A Springate, David Reeves, Darren M. Aschroff, Martin Rutter, Iain Buchan, Tim Doran, Glucose, blood pressure and cholesterol levels and their relationships to clinical outcomes in type 2 diabetes: a retrospective cohort study. Diabetologia, 58:505-518, 2015.

Clinical Code List

Rows: 102
Code Description Entity type Category Coding System (Read)
66Ao.00 Diabetes type 2 review Type 2 Diabetes diagnostic Read
66At100 Type II diabetic dietary review Type 2 Diabetes diagnostic Read
66At111 Type 2 diabetic dietary review Type 2 Diabetes diagnostic Read
C100112 Non-insulin dependent diabetes mellitus Type 2 Diabetes diagnostic Read
C109.00 Non-insulin dependent diabetes mellitus Type 2 Diabetes diagnostic Read
C109.11 NIDDM - Non-insulin dependent diabetes mellitus Type 2 Diabetes diagnostic Read
C109.12 Type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C109.13 Type II diabetes mellitus Type 2 Diabetes diagnostic Read
C109000 Non-insulin-dependent diabetes mellitus with renal comps Type 2 Diabetes diagnostic Read
C109011 Type II diabetes mellitus with renal complications Type 2 Diabetes diagnostic Read
C109012 Type 2 diabetes mellitus with renal complications Type 2 Diabetes diagnostic Read
C109100 Non-insulin-dependent diabetes mellitus with ophthalm comps Type 2 Diabetes diagnostic Read
C109111 Type II diabetes mellitus with ophthalmic complications Type 2 Diabetes diagnostic Read
C109112 Type 2 diabetes mellitus with ophthalmic complications Type 2 Diabetes diagnostic Read
C109200 Non-insulin-dependent diabetes mellitus with neuro comps Type 2 Diabetes diagnostic Read
C109211 Type II diabetes mellitus with neurological complications Type 2 Diabetes diagnostic Read
C109212 Type 2 diabetes mellitus with neurological complications Type 2 Diabetes diagnostic Read
C109300 Non-insulin-dependent diabetes mellitus with multiple comps Type 2 Diabetes diagnostic Read
C109400 Non-insulin dependent diabetes mellitus with ulcer Type 2 Diabetes diagnostic Read
C109411 Type II diabetes mellitus with ulcer Type 2 Diabetes diagnostic Read
C109412 Type 2 diabetes mellitus with ulcer Type 2 Diabetes diagnostic Read
C109500 Non-insulin dependent diabetes mellitus with gangrene Type 2 Diabetes diagnostic Read
C109511 Type II diabetes mellitus with gangrene Type 2 Diabetes diagnostic Read
C109512 Type 2 diabetes mellitus with gangrene Type 2 Diabetes diagnostic Read
C109600 Non-insulin-dependent diabetes mellitus with retinopathy Type 2 Diabetes diagnostic Read
C109611 Type II diabetes mellitus with retinopathy Type 2 Diabetes diagnostic Read
C109612 Type 2 diabetes mellitus with retinopathy Type 2 Diabetes diagnostic Read
C109700 Non-insulin dependent diabetes mellitus - poor control Type 2 Diabetes diagnostic Read
C109711 Type II diabetes mellitus - poor control Type 2 Diabetes diagnostic Read
C109712 Type 2 diabetes mellitus - poor control Type 2 Diabetes diagnostic Read
C109900 Non-insulin-dependent diabetes mellitus without complication Type 2 Diabetes diagnostic Read
C109A00 Non-insulin dependent diabetes mellitus with mononeuropathy Type 2 Diabetes diagnostic Read
C109A11 Type II diabetes mellitus with mononeuropathy Type 2 Diabetes diagnostic Read
C109B00 Non-insulin dependent diabetes mellitus with polyneuropathy Type 2 Diabetes diagnostic Read
C109B11 Type II diabetes mellitus with polyneuropathy Type 2 Diabetes diagnostic Read
C109C00 Non-insulin dependent diabetes mellitus with nephropathy Type 2 Diabetes diagnostic Read
C109C11 Type II diabetes mellitus with nephropathy Type 2 Diabetes diagnostic Read
C109C12 Type 2 diabetes mellitus with nephropathy Type 2 Diabetes diagnostic Read
C109D00 Non-insulin dependent diabetes mellitus with hypoglyca coma Type 2 Diabetes diagnostic Read
C109D11 Type II diabetes mellitus with hypoglycaemic coma Type 2 Diabetes diagnostic Read
C109D12 Type 2 diabetes mellitus with hypoglycaemic coma Type 2 Diabetes diagnostic Read
C109E00 Non-insulin depend diabetes mellitus with diabetic cataract Type 2 Diabetes diagnostic Read
C109E11 Type II diabetes mellitus with diabetic cataract Type 2 Diabetes diagnostic Read
C109E12 Type 2 diabetes mellitus with diabetic cataract Type 2 Diabetes diagnostic Read
C109F11 Type II diabetes mellitus with peripheral angiopathy Type 2 Diabetes diagnostic Read
C109F12 Type 2 diabetes mellitus with peripheral angiopathy Type 2 Diabetes diagnostic Read
C109G00 Non-insulin dependent diabetes mellitus with arthropathy Type 2 Diabetes diagnostic Read
C109G11 Type II diabetes mellitus with arthropathy Type 2 Diabetes diagnostic Read
C109G12 Type 2 diabetes mellitus with arthropathy Type 2 Diabetes diagnostic Read
C109H11 Type II diabetes mellitus with neuropathic arthropathy Type 2 Diabetes diagnostic Read
C109H12 Type 2 diabetes mellitus with neuropathic arthropathy Type 2 Diabetes diagnostic Read
C109J00 Insulin treated Type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C109J11 Insulin treated non-insulin dependent diabetes mellitus Type 2 Diabetes diagnostic Read
C109J12 Insulin treated Type II diabetes mellitus Type 2 Diabetes diagnostic Read
C109K00 Hyperosmolar non-ketotic state in type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C10D.00 Diabetes mellitus autosomal dominant type 2 Type 2 Diabetes diagnostic Read
C10F.00 Type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C10F.11 Type II diabetes mellitus Type 2 Diabetes diagnostic Read
C10F000 Type 2 diabetes mellitus with renal complications Type 2 Diabetes diagnostic Read
C10F011 Type II diabetes mellitus with renal complications Type 2 Diabetes diagnostic Read
C10F100 Type 2 diabetes mellitus with ophthalmic complications Type 2 Diabetes diagnostic Read
C10F111 Type II diabetes mellitus with ophthalmic complications Type 2 Diabetes diagnostic Read
C10F200 Type 2 diabetes mellitus with neurological complications Type 2 Diabetes diagnostic Read
C10F211 Type II diabetes mellitus with neurological complications Type 2 Diabetes diagnostic Read
C10F300 Type 2 diabetes mellitus with multiple complications Type 2 Diabetes diagnostic Read
C10F311 Type II diabetes mellitus with multiple complications Type 2 Diabetes diagnostic Read
C10F400 Type 2 diabetes mellitus with ulcer Type 2 Diabetes diagnostic Read
C10F411 Type II diabetes mellitus with ulcer Type 2 Diabetes diagnostic Read
C10F500 Type 2 diabetes mellitus with gangrene Type 2 Diabetes diagnostic Read
C10F511 Type II diabetes mellitus with gangrene Type 2 Diabetes diagnostic Read
C10F600 Type 2 diabetes mellitus with retinopathy Type 2 Diabetes diagnostic Read
C10F611 Type II diabetes mellitus with retinopathy Type 2 Diabetes diagnostic Read
C10F700 Type 2 diabetes mellitus - poor control Type 2 Diabetes diagnostic Read
C10F711 Type II diabetes mellitus - poor control Type 2 Diabetes diagnostic Read
C10F900 Type 2 diabetes mellitus without complication Type 2 Diabetes diagnostic Read
C10F911 Type II diabetes mellitus without complication Type 2 Diabetes diagnostic Read
C10FA00 Type 2 diabetes mellitus with mononeuropathy Type 2 Diabetes diagnostic Read
C10FA11 Type II diabetes mellitus with mononeuropathy Type 2 Diabetes diagnostic Read
C10FB00 Type 2 diabetes mellitus with polyneuropathy Type 2 Diabetes diagnostic Read
C10FB11 Type II diabetes mellitus with polyneuropathy Type 2 Diabetes diagnostic Read
C10FC00 Type 2 diabetes mellitus with nephropathy Type 2 Diabetes diagnostic Read
C10FC11 Type II diabetes mellitus with nephropathy Type 2 Diabetes diagnostic Read
C10FD00 Type 2 diabetes mellitus with hypoglycaemic coma Type 2 Diabetes diagnostic Read
C10FD11 Type II diabetes mellitus with hypoglycaemic coma Type 2 Diabetes diagnostic Read
C10FE00 Type 2 diabetes mellitus with diabetic cataract Type 2 Diabetes diagnostic Read
C10FE11 Type II diabetes mellitus with diabetic cataract Type 2 Diabetes diagnostic Read
C10FF00 Type 2 diabetes mellitus with peripheral angiopathy Type 2 Diabetes diagnostic Read
C10FG00 Type 2 diabetes mellitus with arthropathy Type 2 Diabetes diagnostic Read
C10FG11 Type II diabetes mellitus with arthropathy Type 2 Diabetes diagnostic Read
C10FH00 Type 2 diabetes mellitus with neuropathic arthropathy Type 2 Diabetes diagnostic Read
C10FJ00 Insulin treated Type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C10FJ11 Insulin treated Type II diabetes mellitus Type 2 Diabetes diagnostic Read
C10FK00 Hyperosmolar non-ketotic state in type 2 diabetes mellitus Type 2 Diabetes diagnostic Read
C10FL00 Type 2 diabetes mellitus with persistent proteinuria Type 2 Diabetes diagnostic Read
C10FL11 Type II diabetes mellitus with persistent proteinuria Type 2 Diabetes diagnostic Read
C10FM00 Type 2 diabetes mellitus with persistent microalbuminuria Type 2 Diabetes diagnostic Read
C10FM11 Type II diabetes mellitus with persistent microalbuminuria Type 2 Diabetes diagnostic Read
C10FN00 Type 2 diabetes mellitus with ketoacidosis Type 2 Diabetes diagnostic Read
C10FP00 Type 2 diabetes mellitus with ketoacidotic coma Type 2 Diabetes diagnostic Read
C10FQ00 Type 2 diabetes mellitus with exudative maculopathy Type 2 Diabetes diagnostic Read
C10FR00 Type 2 diabetes mellitus with gastroparesis Type 2 Diabetes diagnostic Read
ZC2CA00 Dietary advice for type II diabetes Type 2 Diabetes diagnostic Read

API

To Export Phenotype Details:

Format API
XML site_root/api/v1/public/phenotypes/PH569/version/1138/detail/?format=xml
JSON site_root/api/v1/public/phenotypes/PH569/version/1138/detail/?format=json
R Package

# Download here

library(ConceptLibraryClient)


# Connect to API

client = connect_to_API(public=TRUE)


# Get details of phenotype

details = get_phenotype_detail_by_version('PH569', '1138', api_client=client)

To Export Phenotype Code List:

Format API
XML site_root/api/v1/public/phenotypes/PH569/version/1138/export/codes/?format=xml
JSON site_root/api/v1/public/phenotypes/PH569/version/1138/export/codes/?format=json
CSV site_root/phenotypes/PH569/version/1138/export/codes/
R Package

# Download here

library(ConceptLibraryClient)


# Connect to API

client = connect_to_API(public=TRUE)


# Get codelists of phenotype

codelists = get_phenotype_code_list('PH569', '1138', api_client=client)

Version History

Version
ID
Name Owner Publish date
1138 Type 2 Diabetes ieuan.scanlon 2021-10-06 currently shown

Export - export all codes into a csv file/JSON/XML for the current phenotype version.

Print - Print page.