Print

Low Back Diagnosis

Romi Haas, Ljoudmila Busija, Alexandra Gorelik, Denise A O'Connor, Christopher Pierce, Danielle Mazza, Rochelle Buchbinder

Type
Disease or Syndrome
ID
PH846
Version ID
1771
Data Sources
POpulation Level Analysis and Reporting (POLAR) Database Australia
Valid event data range
01/01/2014 - 31/12/2018
Sex
Female, Male
Agreement Date
2021-09-24
Coding system
SNOMED CT codes
Tags /Collections
ClinicalCodes Repository Phenotype Library

Definition

Introduction:

General practice is integral to the Australian healthcare system. Outcome Health’s POpulation Level Analysis and Reporting (POLAR) database uses de-identified electronic health records to analyse general practice data in Australia. Previous studies using routinely collected health data for research have not consistently reported the codes and algorithms used to describe the population, exposures, interventions and outcomes in sufficient detail to allow replication. This paper reports a study protocol investigating patterns of care for people presenting with musculoskeletal conditions to general practice in Victoria, Australia. Its focus is on the systematic approach used to classify and select eligible records from the POLAR database to facilitate replication. This will be useful for other researchers using routinely collected health data for research.

Methods and analysis:

This is a retrospective cohort study. Patient-related data will be obtained through electronic health records from a subset of general practices across three primary health networks (PHN) in southeastern Victoria. Data for patients with a low back, neck, shoulder and/or knee condition and who received at least one general practitioner (GP) face-to-face consultation between 1 January 2014 and 31 December 2018 will be included. Data quality checks will be conducted to exclude patients with poor data recording and/or non-continuous follow-up. Relational data files with eligible and valid records will be merged to select the study cohort and the GP care received (consultations, imaging requests, prescriptions and referrals) between diagnosis and 31 December 2018. Number and characteristics of patients and GPs, and number, type and timing of imaging requests, prescriptions for pain relief and referrals to other health providers will be investigated.

Ethics and dissemination:

Ethics approval was obtained from the Cabrini and Monash University Human Research Ethics Committees (Reference Numbers 02-21-01-19 and 16975, respectively). Study findings will be reported to Outcome Health, participating PHNs, disseminated in academic journals and presented in conferences.

Publications

  • Romi Haas, Ljoudmila Busija, Alexandra Gorelik, Denise A O'Connor, Christopher Pierce, Danielle Mazza, Rochelle Buchbinder, Patterns of care for people presenting to Australian general practice with musculoskeletal complaints based on routinely collected data: protocol for an observational cohort study using the Population Level Analysis and Reporting (POLAR) database. BMJ Open, 11(e055528), 2021.

Clinical Code List

Rows: 96
Code Description Entity type Coding System (SNOMED) Category
123798002.0 Lumbosacral spondylosis res174: low back diagnoses SNOMED diagnostic
125608002.0 Fracture of lumbar spine res174: low back diagnoses SNOMED diagnostic
125872003.0 Fracture of sacrum res174: low back diagnoses SNOMED diagnostic
128196005.0 Lumbar radiculopathy res174: low back diagnoses SNOMED diagnostic
134407002.0 Chronic back pain res174: low back diagnoses SNOMED diagnostic
161891005.0 Backache res174: low back diagnoses SNOMED diagnostic
178771000.0 Exploration of spine res174: low back diagnoses SNOMED diagnostic
18347007.0 Spinal stenosis of lumbar region res174: low back diagnoses SNOMED diagnostic
202487003.0 Sacroiliac joint pain res174: low back diagnoses SNOMED diagnostic
202708005.0 Prolapsed lumbar intervertebral disc res174: low back diagnoses SNOMED diagnostic
203095000.0 Spasm of back muscles res174: low back diagnoses SNOMED diagnostic
203438009.0 Vertebral osteoporosis res174: low back diagnoses SNOMED diagnostic
209548004.0 Sprain, lumbosacral ligament res174: low back diagnoses SNOMED diagnostic
209565008.0 Lumbar sprain res174: low back diagnoses SNOMED diagnostic
22791004.0 X-ray of lumbosacral spine res174: low back diagnoses SNOMED diagnostic
2304001.0 Discitis res174: low back diagnoses SNOMED diagnostic
239542002.0 Lumbar discectomy res174: low back diagnoses SNOMED diagnostic
239880009.0 Osteoarthritis of lumbar spine res174: low back diagnoses SNOMED diagnostic
240219003.0 Spinal claudication res174: low back diagnoses SNOMED diagnostic
240221008.0 Spondylolysis res174: low back diagnoses SNOMED diagnostic
2415007.0 Lumbosacral radiculopathy res174: low back diagnoses SNOMED diagnostic
241577003.0 CT of spine res174: low back diagnoses SNOMED diagnostic
241580002.0 CT of lumbar spine res174: low back diagnoses SNOMED diagnostic
241645008.0 Magnetic resonance imaging of spine res174: low back diagnoses SNOMED diagnostic
241648005.0 MRI of lumbar spine res174: low back diagnoses SNOMED diagnostic
243338005.0 Nerve root compression syndrome res174: low back diagnoses SNOMED diagnostic
247369005.0 Facet joint pain res174: low back diagnoses SNOMED diagnostic
24856003.0 Diagnostic radiography of coccyx res174: low back diagnoses SNOMED diagnostic
249921008.0 Stiff back res174: low back diagnoses SNOMED diagnostic
260649000.0 Lumbar microdiscectomy res174: low back diagnoses SNOMED diagnostic
262521009.0 Spinal injury res174: low back diagnoses SNOMED diagnostic
264082005.0 Lumbar res174: low back diagnoses SNOMED diagnostic
26538006.0 Degeneration of lumbar intervertebral disc res174: low back diagnoses SNOMED diagnostic
267982002.0 Pain in lumbar spine res174: low back diagnoses SNOMED diagnostic
274152003.0 Spondylolisthesis res174: low back diagnoses SNOMED diagnostic
275249009.0 Correction of scoliosis res174: low back diagnoses SNOMED diagnostic
278860009.0 Chronic lower back pain res174: low back diagnoses SNOMED diagnostic
279039007.0 Low back pain res174: low back diagnoses SNOMED diagnostic
281598004.0 Sprain of spinal ligament res174: low back diagnoses SNOMED diagnostic
281933002.0 Crush fracture of lumbar vertebra res174: low back diagnoses SNOMED diagnostic
282764008.0 Injury of coccyx res174: low back diagnoses SNOMED diagnostic
282766005.0 Lower back injury res174: low back diagnoses SNOMED diagnostic
283165009.0 Decompression laminectomy res174: low back diagnoses SNOMED diagnostic
298382003.0 Scoliosis deformity of spine res174: low back diagnoses SNOMED diagnostic
298591003.0 Scoliosis of lumbar spine res174: low back diagnoses SNOMED diagnostic
299966003.0 Compression of lumbar nerve root res174: low back diagnoses SNOMED diagnostic
300956001.0 Low back strain res174: low back diagnoses SNOMED diagnostic
302129007.0 Decompression of lumbar spine res174: low back diagnoses SNOMED diagnostic
302258001.0 Back problem res174: low back diagnoses SNOMED diagnostic
303697006.0 CT of lumbar region res174: low back diagnoses SNOMED diagnostic
307138004.0 Spondylolisthesis L5/S1 level res174: low back diagnoses SNOMED diagnostic
309710005.0 Lumbosacral strain res174: low back diagnoses SNOMED diagnostic
314668006.0 Wedge fracture of vertebra res174: low back diagnoses SNOMED diagnostic
3418002.0 Chondrectomy of spine res174: low back diagnoses SNOMED diagnostic
34789001.0 Pain in the coccyx res174: low back diagnoses SNOMED diagnostic
356139006.0 Lumbosacral spine res174: low back diagnoses SNOMED diagnostic
371000000000.0 Stenosis of intervertebral foramina res174: low back diagnoses SNOMED diagnostic
371082009.0 Arthritis of spine res174: low back diagnoses SNOMED diagnostic
372109003.0 Disorder of joint of spine res174: low back diagnoses SNOMED diagnostic
37822005.0 Lower back structure res174: low back diagnoses SNOMED diagnostic
387731002.0 Laminectomy res174: low back diagnoses SNOMED diagnostic
392236004.0 Operative procedure on spinal structure res174: low back diagnoses SNOMED diagnostic
401226007.0 Vertebroplasty res174: low back diagnoses SNOMED diagnostic
425585009.0 L5/S1 disc res174: low back diagnoses SNOMED diagnostic
427094005.0 L4/5 disc res174: low back diagnoses SNOMED diagnostic
429350001.0 Arthropathy of spinal facet joint res174: low back diagnoses SNOMED diagnostic
429377005.0 Lumbar laminectomy res174: low back diagnoses SNOMED diagnostic
42942008.0 Compression fracture of vertebral column res174: low back diagnoses SNOMED diagnostic
430886005.0 Disorder of vertebra res174: low back diagnoses SNOMED diagnostic
44275008.0 Manipulation of spine res174: low back diagnoses SNOMED diagnostic
443395009.0 Compression fracture res174: low back diagnoses SNOMED diagnostic
445734009.0 Fracture of body of vertebra res174: low back diagnoses SNOMED diagnostic
48210000.0 Lumbosacral spondylosis without myelopathy res174: low back diagnoses SNOMED diagnostic
49668003.0 Bone structure of L5 res174: low back diagnoses SNOMED diagnostic
50172003.0 Lumbar spinal fusion res174: low back diagnoses SNOMED diagnostic
50448004.0 Fracture of vertebral column res174: low back diagnoses SNOMED diagnostic
52612000.0 Lumbar region back structure res174: low back diagnoses SNOMED diagnostic
53332000.0 Spinal arthritis deformans res174: low back diagnoses SNOMED diagnostic
54735007.0 Bone structure of sacrum res174: low back diagnoses SNOMED diagnostic
55146009.0 Sacroiliac joint inflamed res174: low back diagnoses SNOMED diagnostic
55705006.0 Spinal arthrodesis res174: low back diagnoses SNOMED diagnostic
608830002.0 Discogenic pain res174: low back diagnoses SNOMED diagnostic
61486003.0 Sacral back pain res174: low back diagnoses SNOMED diagnostic
61960001.0 Lordosis deformity of spine res174: low back diagnoses SNOMED diagnostic
64217002.0 Curvature of spine res174: low back diagnoses SNOMED diagnostic
64688005.0 Bone structure of coccyx res174: low back diagnoses SNOMED diagnostic
67721000.0 Sacroiliac arthrodesis res174: low back diagnoses SNOMED diagnostic
68859000.0 Spondylosis without myelopathy res174: low back diagnoses SNOMED diagnostic
72274001.0 Nerve root disorder res174: low back diagnoses SNOMED diagnostic
73589001.0 Intervertebral disc prolapse res174: low back diagnoses SNOMED diagnostic
76107001.0 Spinal stenosis res174: low back diagnoses SNOMED diagnostic
77547008.0 Degeneration of intervertebral disc res174: low back diagnoses SNOMED diagnostic
79760008.0 Radiography of spine res174: low back diagnoses SNOMED diagnostic
81102000.0 Injury of back res174: low back diagnoses SNOMED diagnostic
84172003.0 Spondylitis res174: low back diagnoses SNOMED diagnostic
8847002.0 Spondylosis res174: low back diagnoses SNOMED diagnostic

API

To Export Phenotype Details:

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

To Export Phenotype Code List:

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

Version History

Version
ID
Name Owner Publish date
1771 Low Back Diagnosis ieuan.scanlon 2022-04-04 currently shown

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

Print - Print page.