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