Codelists for: “Identifying and quantifying confounding from health-seeking behaviour and healthcare access in observational research using UK electronic healthcare records” – User Guide

Persistent identifier

10.17037/DATA.00003684

Description

A set of code lists were used in the Clinical Practice Research Datalink (CPRD) Aurum or Hospital Episode Statistics (HES) Admitted Patient Care (APC) to identify markers of health-seeking behaviour and healthcare access. These markers were then adjusted for in a vaccine effectiveness study to quantify and account for potential confounding.

Data collection methods

Code lists are publicly available and openly licensed on the respective websites.

Data analysis and preparation

All markers were identified in relevant lookback periods in a time period prior to defined index dates. These were identified as binary measures.

Key dates

CPRD Aurum data dates back to 1 January 1995 and HES APC data dates back to 1987. All available lookback data was used for patients, where required to identify markers of interest. The latest collection of the data at the time of data extraction was 31 March 2021 for HES APC and 31 May 2022 for CPRD Aurum. However, to ensure follow-up was consistent across datasets, we ended follow-up on 31 March 2021.

Ethics

Organisation Ethics ID Other information
CPRD’s research data governance committee 22_002202  

Keywords

confounding, health-seeking behaviour, healthcare access, vaccine effectiveness, UK electronic health records

Project information

Project name Funder/sponsor Grant number
Advancing methods to account for biases in vaccine effectiveness research National Institute for Health and Care Research Health Protection Research Unit in Vaccines and Immunisation NIHR200929

Creators

Forename Surname Faculty / Dept Institution Role
Sophie Graham Epidemiology and Population Health London School of Hygiene & Tropical Medicine, London, United Kingdom Data Creator, contact person, data manager, project leader
Helen McDonald Faculty of Science University of Bath, Bath, United Kingdom Project member, supervisor
Edward Parker Epidemiology and Population Health London School of Hygiene & Tropical Medicine, London, United Kingdom Project member, supervisor

File description

Filename Description Access status Licence
3684-codelists.xlsx Excel spreadsheet containing 21 code lists used to identify markers of health-seeking behaviour and healthcare access Open Creative Commons Attribution (CCBY)
3684-codelists-tsv Zip file containing 21 codelists in tab-delimited text format Open Creative Commons Attribution (CCBY)

Zip File listing

The table lists the code lists contained in each of the 21 files/worksheets and their source.

  File / worksheet name prod snomed icd10 OPCS Published list used
Exposures            
COVID vaccination Aurum_covid_vacc_prod x       https://cprd.com/sites/default/files/2022-05/SARS-CoV-2%20counts%20May2022.pdf
Flu vaccination Aurum_flu_vacc_prod x       https://doi.org/10.17037/DATA.00002228
Flu vaccination Aurum_flu_vacc_med   x      
Outcomes            
COVID-19 primary care Aurum_covid   x      
COVID-19 hospitalisation/death HES_covid     x   https://doi.org/10.17037/DATA.00002800
Influenza primary care Aurum_flu   x     https://doi.org/10.17037/DATA.00002191
Influenza hospitalisation/death HES_flu     x   https://doi.org/10.17037/DATA.00002193
Markers            
Abdominal aortic screening Aurum_AAA_screen   x      
Breast cancer screening Aurum_breast_screen   x      
Bowel cancer screening Aurum_bowel_screen   x      
Cervical cancer screening Aurum_cervical_screen   x     https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-collections/quality-and-outcomes-framework-qof
Pneunococcal vaccination Aurum_pneu_vacc_prod x       https://doi.org/10.17037/DATA.00002233/
Pneunococcal vaccination Aurum_pneu_vacc_med   x     Jennifer Davison's list
PSA test Aurum_PSA_test   x      
Bone density scan Aurum_bone_scan   x      
NHS health checks Aurum_NHS_health_checks   x     https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-collections/quality-and-outcomes-framework-qof
Primary care DNA Aurum_primary_DNA   x      
Ambulatory sensitive conditions HES_ambulatory_care_sens     x   https://www.ncbi.nlm.nih.gov/books/NBK453408/
Low value procedures HES_low_value_proc       x https://eaststaffsccg.nhs.uk/publications/policies/clinical/procedures-of-low-clinical-value/1477-polcv-policy-v7-1-final-july-2020/file
Low value prescriptions Aurum_low_value_presc x        
Blood pressure measurements Aurum_BP   x     https://digital.nhs.uk/data-and-information/data-collections-and-data-sets/data-collections/quality-and-outcomes-framework-qof