Identifying populations with chronic pain in primary care: developing an algorithm and logic rules applied to coded primary care diagnostic and medication data

BACKGROUND: Estimates of chronic pain prevalence using coded primary care data are likely to be substantially lower than estimates derived from community surveys. Most primary care studies have estimated chronic pain prevalence using data searches confined to analgesic medication prescriptions. Increasingly, following recent NICE guideline recommendations, patients and doctors opt for non-drug treatment of chronic pain thus excluding these patients from prevalence estimates based on medication codes. We aimed to develop and test an algorithm combining medication codes with selected diagnostic codes to estimate chronic pain prevalence using coded primary care data. METHODS: Following a scoping review 4 criteria were developed to identify cohorts of people with chronic pain. These were (1) people with one of 12 (‘tier 1’) conditions that almost always results in the individual having chronic pain (2) people with one of 20 (‘tier 2’) conditions included when there are also 3 or more prescription-only analgesics issued in the last 12 months (3) chronic neuropathic pain, or (4) 4 or more prescription-only analgesics issued in the last 12 months. These were translated into 8 logic rules which included 1,932 SNOMED CT codes. RESULTS: The algorithm was run on primary care data from 41 GP Practices in Lambeth. The total population consisted of 386,238 GP registered adults ≥ 18 years as of the 31st March 2021. 64,135 (16.6%) were identified as people with chronic pain. This definition demonstrated notably high rates in Black ethnicity females, and higher rates in the most deprived, and older population. CONCLUSIONS: Estimates of chronic pain prevalence using structured healthcare data have previously shown lower prevalence estimates for chronic pain than reported in community surveys. This has limited the ability of researchers and clinicians to fully understand and address the complex multifactorial nature of chronic pain. Our study demonstrates that it may be possible to establish more representative prevalence estimates using structured data than previously possible. Use of logic rules offers the potential to move systematic identification and population-based management of chronic pain into mainstream clinical practice at scale and support improved management of symptom burden for people experiencing chronic pain. SUPPLEMENTARY INFORMATION: The online version contains supplementary material available at 10.1186/s12875-023-02134-1.