Print

Osteoporosis

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
PH552
Version ID
1104
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: 39
Code Description Entity type Category Coding System (Read)
585O.00 Quantitative ultrasound scan of heel - result osteoporotic Osteoporosis diagnostic Read
58E4.00 Forearm DXA scan result osteoporotic Osteoporosis diagnostic Read
58EA.00 Heel DXA scan result osteoporotic Osteoporosis diagnostic Read
58EG.00 Hip DXA scan result osteoporotic Osteoporosis diagnostic Read
58EM.00 Lumbar DXA scan result osteoporotic Osteoporosis diagnostic Read
7230A OSTEOPOROSIS Osteoporosis diagnostic Read
7230B OSTEOPOROSIS SENILIS Osteoporosis diagnostic Read
7230D VERTEBRAL OSTEOPOROSIS Osteoporosis diagnostic Read
7230PM OSTEOPOROSIS POSTMENOPAUSAL Osteoporosis diagnostic Read
7230PT OSTEOPOROSIS POST-TRAUMATIC Osteoporosis diagnostic Read
N330.00 Osteoporosis Osteoporosis diagnostic Read
N330000 Osteoporosis; unspecified Osteoporosis diagnostic Read
N330100 Senile osteoporosis Osteoporosis diagnostic Read
N330200 Postmenopausal osteoporosis Osteoporosis diagnostic Read
N330300 Idiopathic osteoporosis Osteoporosis diagnostic Read
N330400 Dissuse osteoporosis Osteoporosis diagnostic Read
N330500 Drug-induced osteoporosis Osteoporosis diagnostic Read
N330600 Postoophorectomy osteoporosis Osteoporosis diagnostic Read
N330700 Postsurgical malabsorption osteoporosis Osteoporosis diagnostic Read
N330800 Localized osteoporosis - Lequesne Osteoporosis diagnostic Read
N330900 Osteoporosis in multiple myelomatosis Osteoporosis diagnostic Read
N330A00 Osteoporosis in endocrine disorders Osteoporosis diagnostic Read
N330B00 Vertebral osteoporosis Osteoporosis diagnostic Read
N330C00 Osteoporosis localized to spine Osteoporosis diagnostic Read
N330D00 Osteoporosis due to corticosteroids Osteoporosis diagnostic Read
N330z00 Osteoporosis NOS Osteoporosis diagnostic Read
N331200 Postoophorectomy osteoporosis with pathological fracture Osteoporosis diagnostic Read
N331300 Osteoporosis of disuse with pathological fracture Osteoporosis diagnostic Read
N331400 Postsurgical malabsorption osteoporosis with path fracture Osteoporosis diagnostic Read
N331500 Drug-induced osteoporosis with pathological fracture Osteoporosis diagnostic Read
N331600 Idiopathic osteoporosis with pathological fracture Osteoporosis diagnostic Read
N331800 Osteoporosis + pathological fracture lumbar vertebrae Osteoporosis diagnostic Read
N331900 Osteoporosis + pathological fracture thoracic vertebrae Osteoporosis diagnostic Read
N331A00 Osteoporosis + pathological fracture cervical vertebrae Osteoporosis diagnostic Read
N331B00 Postmenopausal osteoporosis with pathological fracture Osteoporosis diagnostic Read
NyuB000 [X]Other osteoporosis with pathological fracture Osteoporosis diagnostic Read
NyuB100 [X]Other osteoporosis Osteoporosis diagnostic Read
NyuB200 [X]Osteoporosis in other disorders classified elsewhere Osteoporosis diagnostic Read
NyuB800 [X]Unspecified osteoporosis with pathological fracture Osteoporosis diagnostic Read

API

To Export Phenotype Details:

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

To Export Phenotype Code List:

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

Version History

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