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.
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.
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 |
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 |
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 |
|
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 |
|
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.