Print

Osteoarthritis

Evangelos Kontopantelis, Ivan Olier, Claire Planner, David Reeves, Darren M Ashcroft, Linda Gask, Tim Doran, Sioban Reilly

Type
Disease or Syndrome
ID
PH550
Version ID
1100
Data Sources
Valid event data range
01/04/2000 - 31/03/2012
Sex
Female, Male
Agreement Date
2015-12-16
Coding system
Read codes v2 OXMIS codes
Tags /Collections
ClinicalCodes Repository Phenotype Library

Definition

The database:

The CPRD is a large computerised database of anonymised primary care medical records. It contains complete patient information for participating practices, with the healthcare events (diagnoses, treatments, referrals, tests and prescriptions) recorded using coding systems (Read coding for diagnoses). Practice characteristics are described in detail elsewhere. The database is broadly representative of the UK population, although larger practices are over-represented. Practices need to meet prespecified data entry quality criteria to be defined as ‘up to research standard’, and for each study year, our main sample included all CPRD practices that were classed as such for the whole year. We also generated two data sets to test the sensitivity of our findings. First, we included all practices contributing data across the entire study period. Second, we included a subsample of 50 practices, representative of UK practices in terms of area deprivation, and practice list size.

Defining people with SMI and controls:

Information was extracted for the period 1 April 2000 to 31 March 2012 and aggregated into 12 yearly ‘bins’, to correspond with financial years 2000/2001–2011/2012. We used Read codes to identify the presence of SMI. First, we identified relevant keywords (or key-stubs) and codes, for example ‘paranoi’ and ‘E100.00’ (simple schizophrenia). Next, the CPRD was searched for codes that matched the list in either the code or the description field. Finally, the matched code list was reviewed by clinical experts and a final conservative list of codes was agreed. A similar process was used to define comorbidities (hypertension, asthma, hypothyroidism, osteoarthritis, chronic kidney disease, coronary heart disease, epilepsy, chronic obstructive pulmonary disease, cancer, stroke, heart failure, rheumatoid arthritis, dementia and psoriasis). All code lists we used are available from http://www.clinicalcodes.org. All conditions, bar asthma, were treated as unresolvable (ie, permanent). Within each year, all patients registered with a CPRD practice for the whole year and aged 18 or over were eligible for inclusion. The final SMI Read code list was used to identify cases of SMI, which were then grouped into three broad subcategories, in line with the diagnoses used when compiling primary care QOF SMI registers: schizophrenia; affective psychoses (bipolar disorder or other unspecified affective psychosis); other types of psychosis. In the event that an individual received more than one SMI diagnosis over the study period, we used the last available diagnosis to retrospectively ‘correct’ the original diagnosis (ie, we assumed that the latest diagnosis was the correct one). Within each year, each SMI case was then matched on age, sex and practice to five randomly selected patients not associated with SMI up until that time point. More details on the extraction of the cohort have been provided elsewhere,21 and a flow chart of the data extraction process is available in the online appendix figure A2.

Defining consultation type:

We defined a ‘consultation’ as involving direct contact between a patient and a healthcare professional within the primary care setting. We divided consultations into two main categories: face-to-face (our primary outcome), and by telephone (see online appendix table A1). We also constructed a third ‘other’ grouping of all other activities that are captured by the ‘consultation type’ codes within the CPRD. This includes mail/email contact, third party consultations (including referrals), secondary care episodes, other administrative tasks and consultations of unknown content. This group is highly heterogeneous and includes many activities that cannot be classed as consultations. However, we decided to use this grouping as an aggregate secondary outcome since it can potentially provide insight into the overall workload associated with patient care in the primary care context. We decided against breaking down the ‘other’ group in more subcategories as we are very doubtful regarding the reliability and across practice consistency of the coding within these ‘other’ categories. In instances where a patient had two or more consultations within a day, we conservatively assumed a single consultation took place, to reduce the likelihood of including duplicate records.

Publications

  • Evangelos Kontopantelis, Ivan Olier, Claire Panner, David Reeves, Darren M Ashcroft, Linda Gask, Tim Doran, Siobhan Reilly, Primary care consultation rates among people with and without severe mental illness a UK cohort study using the Clinical Practice Research Datalink. BMJ Open, 5 (e008650), 2015.

Clinical Code List

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

API

To Export Phenotype Details:

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

To Export Phenotype Code List:

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

Version History

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