Print

Osteoarthritis

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

Type
Disease or Syndrome
ID
PH551
Version ID
1102
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
Tags /Collections
ClinicalCodes Repository Phenotype Library

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: 128
Code Description Entity type Category Coding System (Read)
7130A OSTEOARTHRITIS Osteoarthritis diagnostic Read
7130AA OSTEOARTHROSIS ANKLE Osteoarthritis diagnostic Read
7130AB OSTEOARTHROSIS Osteoarthritis diagnostic Read
7130AC OSTEOARTHROSIS ACROMIO CLAVICULAR JOINT Osteoarthritis diagnostic Read
7130AG OSTEOARTHROSIS GENERAL Osteoarthritis diagnostic Read
7130AW OSTEOARTHROSIS WRIST Osteoarthritis diagnostic Read
7130B OSTEOARTHROSIS KNEE(S) Osteoarthritis diagnostic Read
7130C OSTEOARTHROSIS FINGERS Osteoarthritis diagnostic Read
7130CT THUMB OSTEOARTHROSIS Osteoarthritis diagnostic Read
7130D OSTEOARTHROSIS HIP Osteoarthritis diagnostic Read
7130DA OSTEOARTHRITIS HIP Osteoarthritis diagnostic Read
7130E OSTEOARTHROSIS SHOULDER Osteoarthritis diagnostic Read
7130EA STERNOCLAVICULAR JOINT OSTEOARTHROSIS Osteoarthritis diagnostic Read
7130EL OSTEOARTHROSIS ELBOW Osteoarthritis diagnostic Read
7130FT OSTEOARTHROSIS FOOT Osteoarthritis diagnostic Read
7130H OSTEOARTHROSIS TOE Osteoarthritis diagnostic Read
7130MD TEMPOROMANDIBULAR OSTEOARTHROSIS Osteoarthritis diagnostic Read
7130N OSTEOARTHROSIS HANDS Osteoarthritis diagnostic Read
7130PA OSTEOARTHRITIC PROTRUSION ACETABULUM Osteoarthritis diagnostic Read
7131A OSTEOARTHROSIS NECK Osteoarthritis diagnostic Read
7131BR SPONDYLITIS OSTEOARTHRITIC Osteoarthritis diagnostic Read
7131C OSTEOARTHROSIS SPINE Osteoarthritis diagnostic Read
7131DL LUMBAR OSTEOARTHRITIS Osteoarthritis diagnostic Read
N05..00 Osteoarthritis and allied disorders Osteoarthritis diagnostic Read
N05..11 Osteoarthritis Osteoarthritis diagnostic Read
N050.00 Generalised osteoarthritis - OA Osteoarthritis diagnostic Read
N050000 Generalised osteoarthritis of unspecified site Osteoarthritis diagnostic Read
N050100 Generalised osteoarthritis of the hand Osteoarthritis diagnostic Read
N050200 Generalised osteoarthritis of multiple sites Osteoarthritis diagnostic Read
N050400 Primary generalized osteoarthrosis Osteoarthritis diagnostic Read
N050600 Erosive osteoarthrosis Osteoarthritis diagnostic Read
N050z00 Generalised osteoarthritis NOS Osteoarthritis diagnostic Read
N051.00 Localised; primary osteoarthritis Osteoarthritis diagnostic Read
N051000 Localised; primary osteoarthritis of unspecified site Osteoarthritis diagnostic Read
N051100 Localised; primary osteoarthritis of the shoulder region Osteoarthritis diagnostic Read
N051200 Localised; primary osteoarthritis of the upper arm Osteoarthritis diagnostic Read
N051300 Localised; primary osteoarthritis of the forearm Osteoarthritis diagnostic Read
N051400 Localised; primary osteoarthritis of the hand Osteoarthritis diagnostic Read
N051500 Localised; primary osteoarthritis of the pelvic region/thigh Osteoarthritis diagnostic Read
N051600 Localised; primary osteoarthritis of the lower leg Osteoarthritis diagnostic Read
N051700 Localised; primary osteoarthritis of the ankle and foot Osteoarthritis diagnostic Read
N051800 Localised; primary osteoarthritis of other specified site Osteoarthritis diagnostic Read
N051D00 Localised; primary osteoarthritis of the wrist Osteoarthritis diagnostic Read
N051E00 Localised; primary osteoarthritis of toe Osteoarthritis diagnostic Read
N051F00 Localised; primary osteoarthritis of elbow Osteoarthritis diagnostic Read
N051z00 Localised; primary osteoarthritis NOS Osteoarthritis diagnostic Read
N052.00 Localised; secondary osteoarthritis Osteoarthritis diagnostic Read
N052000 Localised; secondary osteoarthritis of unspecified site Osteoarthritis diagnostic Read
N052100 Localised; secondary osteoarthritis of the shoulder region Osteoarthritis diagnostic Read
N052200 Localised; secondary osteoarthritis of the upper arm Osteoarthritis diagnostic Read
N052300 Localised; secondary osteoarthritis of the forearm Osteoarthritis diagnostic Read
N052400 Localised; secondary osteoarthritis of the hand Osteoarthritis diagnostic Read
N052500 Localised; secondary osteoarthritis of pelvic region/thigh Osteoarthritis diagnostic Read
N052600 Localised; secondary osteoarthritis of the lower leg Osteoarthritis diagnostic Read
N052700 Localised; secondary osteoarthritis of the ankle and foot Osteoarthritis diagnostic Read
N052800 Localised; secondary osteoarthritis of other specified site Osteoarthritis diagnostic Read
N052z00 Localised; secondary osteoarthritis NOS Osteoarthritis diagnostic Read
N053.00 Localised osteoarthritis; unspecified Osteoarthritis diagnostic Read
N053000 Localised osteoarthritis; unspecified; of unspecified site Osteoarthritis diagnostic Read
N053100 Localised osteoarthritis; unspecified; of shoulder region Osteoarthritis diagnostic Read
N053200 Localised osteoarthritis; unspecified; of the upper arm Osteoarthritis diagnostic Read
N053300 Localised osteoarthritis; unspecified; of the forearm Osteoarthritis diagnostic Read
N053400 Localised osteoarthritis; unspecified; of the hand Osteoarthritis diagnostic Read
N053500 Localised osteoarthritis; unspecified; pelvic region/thigh Osteoarthritis diagnostic Read
N053600 Localised osteoarthritis; unspecified; of the lower leg Osteoarthritis diagnostic Read
N053611 Patellofemoral osteoarthritis Osteoarthritis diagnostic Read
N053700 Localised osteoarthritis; unspecified; of the ankle and foot Osteoarthritis diagnostic Read
N053800 Localised osteoarthritis; unspecified; of other spec site Osteoarthritis diagnostic Read
N053z00 Localised osteoarthritis; unspecified; NOS Osteoarthritis diagnostic Read
N054.00 Oligoarticular osteoarthritis; unspecified Osteoarthritis diagnostic Read
N054000 Oligoarticular osteoarthritis; unspec; of unspecified sites Osteoarthritis diagnostic Read
N054100 Oligoarticular osteoarthritis; unspecified; of shoulder Osteoarthritis diagnostic Read
N054200 Oligoarticular osteoarthritis; unspecified; of upper arm Osteoarthritis diagnostic Read
N054400 Oligoarticular osteoarthritis; unspecified; of hand Osteoarthritis diagnostic Read
N054500 Oligoarticular osteoarthritis; unspecified; of pelvis/thigh Osteoarthritis diagnostic Read
N054600 Oligoarticular osteoarthritis; unspecified; of lower leg Osteoarthritis diagnostic Read
N054700 Oligoarticular osteoarthritis; unspecified; of ankle/foot Osteoarthritis diagnostic Read
N054800 Oligoarticular osteoarthritis; unspecified; other spec sites Osteoarthritis diagnostic Read
N054900 Oligoarticular osteoarthritis; unspecified; multiple sites Osteoarthritis diagnostic Read
N054z00 Osteoarthritis of more than one site; unspecified; NOS Osteoarthritis diagnostic Read
N05z.00 Osteoarthritis NOS Osteoarthritis diagnostic Read
N05z000 Osteoarthritis NOS; of unspecified site Osteoarthritis diagnostic Read
N05z100 Osteoarthritis NOS; of shoulder region Osteoarthritis diagnostic Read
N05z200 Osteoarthritis NOS; of the upper arm Osteoarthritis diagnostic Read
N05z211 Elbow osteoarthritis NOS Osteoarthritis diagnostic Read
N05z300 Osteoarthritis NOS; of the forearm Osteoarthritis diagnostic Read
N05z311 Wrist osteoarthritis NOS Osteoarthritis diagnostic Read
N05z400 Osteoarthritis NOS; of the hand Osteoarthritis diagnostic Read
N05z411 Finger osteoarthritis NOS Osteoarthritis diagnostic Read
N05z412 Thumb osteoarthritis NOS Osteoarthritis diagnostic Read
N05z500 Osteoarthritis NOS; pelvic region/thigh Osteoarthritis diagnostic Read
N05z511 Hip osteoarthritis NOS Osteoarthritis diagnostic Read
N05z600 Osteoarthritis NOS; of the lower leg Osteoarthritis diagnostic Read
N05z611 Knee osteoarthritis NOS Osteoarthritis diagnostic Read
N05z700 Osteoarthritis NOS; of ankle and foot Osteoarthritis diagnostic Read
N05z711 Ankle osteoarthritis NOS Osteoarthritis diagnostic Read
N05z712 Foot osteoarthritis NOS Osteoarthritis diagnostic Read
N05z713 Toe osteoarthritis NOS Osteoarthritis diagnostic Read
N05z800 Osteoarthritis NOS; other specified site Osteoarthritis diagnostic Read
N05z900 Osteoarthritis NOS; of shoulder Osteoarthritis diagnostic Read
N05zA00 Osteoarthritis NOS; of sternoclavicular joint Osteoarthritis diagnostic Read
N05zB00 Osteoarthritis NOS; of acromioclavicular joint Osteoarthritis diagnostic Read
N05zC00 Osteoarthritis NOS; of elbow Osteoarthritis diagnostic Read
N05zD00 Osteoarthritis NOS; of distal radio-ulnar joint Osteoarthritis diagnostic Read
N05zE00 Osteoarthritis NOS; of wrist Osteoarthritis diagnostic Read
N05zF00 Osteoarthritis NOS; of MCP joint Osteoarthritis diagnostic Read
N05zG00 Osteoarthritis NOS; of PIP joint of finger Osteoarthritis diagnostic Read
N05zH00 Osteoarthritis NOS; of DIP joint of finger Osteoarthritis diagnostic Read
N05zJ00 Osteoarthritis NOS; of hip Osteoarthritis diagnostic Read
N05zK00 Osteoarthritis NOS; of sacro-iliac joint Osteoarthritis diagnostic Read
N05zL00 Osteoarthritis NOS; of knee Osteoarthritis diagnostic Read
N05zM00 Osteoarthritis NOS; of tibio-fibular joint Osteoarthritis diagnostic Read
N05zN00 Osteoarthritis NOS; of ankle Osteoarthritis diagnostic Read
N05zP00 Osteoarthritis NOS; of subtalar joint Osteoarthritis diagnostic Read
N05zQ00 Osteoarthritis NOS; of talonavicular joint Osteoarthritis diagnostic Read
N05zR00 Osteoarthritis NOS; of other tarsal joint Osteoarthritis diagnostic Read
N05zS00 Osteoarthritis NOS; of 1st MTP joint Osteoarthritis diagnostic Read
N05zT00 Osteoarthritis NOS; of lesser MTP joint Osteoarthritis diagnostic Read
N05zU00 Osteoarthritis NOS; of IP joint of toe Osteoarthritis diagnostic Read
N05zz00 Osteoarthritis NOS Osteoarthritis diagnostic Read
N11..12 Osteoarthritis of spine Osteoarthritis diagnostic Read
N110.12 Osteoarthritis cervical spine Osteoarthritis diagnostic Read
N11D.00 Osteoarthritis of spine Osteoarthritis diagnostic Read
N11D000 Osteoarthritis of cervical spine Osteoarthritis diagnostic Read
N11D100 Osteoarthritis of thoracic spine Osteoarthritis diagnostic Read
N11D200 Osteoarthritis of lumbar spine Osteoarthritis diagnostic Read
N11D300 Osteoarthritis of spine NOS Osteoarthritis diagnostic Read
N11z.11 Osteoarthritis spine Osteoarthritis diagnostic Read

API

To Export Phenotype Details:

Format API
XML site_root/api/v1/public/phenotypes/PH551/version/1102/detail/?format=xml
JSON site_root/api/v1/public/phenotypes/PH551/version/1102/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('PH551', '1102', api_client=client)

To Export Phenotype Code List:

Format API
XML site_root/api/v1/public/phenotypes/PH551/version/1102/export/codes/?format=xml
JSON site_root/api/v1/public/phenotypes/PH551/version/1102/export/codes/?format=json
CSV site_root/phenotypes/PH551/version/1102/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('PH551', '1102', api_client=client)

Version History

Version
ID
Name Owner Publish date
1102 Osteoarthritis 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.