Data-Resource Profile: United Kingdom Optimum Patient Care Research Database

Figures & data

Figure 1 OPCRD patient population by region. The population in the OPCRD consists of patients based across the UK, with approximately 25% of the UK population included.

Table 1 Demographic characteristics of patients with valid data and at least 6 months’ follow-up in OPCRD, 1 July 1 2022

	All patients	Actively registered patients
n	12,008,218	7,766,604
Age (years)	44 (27–64)	43 (25–62)
Follow-up since 1995 (years)	13.1 (9.5–18.1)	7.4 (3.1–14.1)
Sex, n (%)
Male	5,818,978 (48.5)	3,834,724 (49.4)
Female	6,136,145 (51.1)	3,931,571 (50.6)
Intersex	834 (<0.01)	251 (<0.01)
Ethnicity, n (%)
White	6,709,297 (55.9)	4,776,423 (61.5)
Black or Black British	241,618 (2.0)	171,119 (2.2)
Asian or Asian British	749,872 (6.2)	518,989 (6.7)
Chinese or other	291,071 (2.4)	197,257 (2.5)
Mixed	159,680 (1.3)	110,899 (1.4)
Not stated^a	244,391 (2.0)	163,043 (2.1)
Missing	3,612,289 (30.1)	1,828,874 (23.5)
Deprivation quintile, n (%)^b
1	1,937,293 (16.1)	1,108,672 (14.3)
2	2,450,954 (20.4)	1,505,419 (19.4)
3	1,579,345 (13.2)	1,031,634 (13.3)
4	1,675,996 (14.0)	1,122,462 (14.5)
5	1,747,048 (14.5)	1,167,357 (15.0)
Missing	2,617,582 (21.8)	1,831,060 (23.6)

Notes: ^aPatient chose not to state ethnicity. ^bDeprivation quintile derived using the practice postcode. Data are medians Inter Quartile Range (IQR) unless stated.

Table 2 Prevalence of major Quality Outcomes Framework (QOF) specified chronic conditions and major respiratory conditions in adults in the active cohort

	Active Adult Population (n=6,189,113)
QOF conditions
Depression	1,192,997 (19.3)
Hypertension	1,132,542 (18.3)
Hyperlipidaemia	585,616 (9.5)
Type 2 diabetes	430,163 (7.0)
Chronic kidney disease stage 3–5	262,526 (4.2)
Myocardial infarction	110,104 (1.8)
Ischaemic heart disease	325,227 (5.3)
Atrial fibrillation	182,853 (3.0)
Angina	152,387 (2.5)
Revascularisation	70,751 (1.1)
Stroke	146,399 (2.4)
Transient ischaemic attack	70,551 (1.1)
Peripheral vascular disease	50,130 (0.8)
Deep vein thrombosis	57,508 (0.9)
Pulmonary embolism	53,397 (0.9)
Respiratory conditions
Asthma	1,084,711 (17.5)
Chronic obstructive pulmonary disorder	203,465 (3.3)
Idiopathic pulmonary fibrosis	2878 (<0.1)
Cystic fibrosis	1744 (<0.1)
Interstitial lung disease	87,247 (1.4)
Allergic rhinitis	910,237 (14.7)
α1 Antitrypsin deficiency	2092 (<0.1)

Notes: Only individuals with ≥1 year of follow-up in the primary care record (to ensure major conditions are likely to be accurately recorded). Data are n (%).

Figure 2 Population pyramid for OPCRD and ONS data. Based on July 2022 OPCRD data (colored bars) and mid-2020 Office for National Statistics (ONS) data (black bars).

Table 3 Patient-reported information data collected via questionnaire and available for secondary research

Questionnaire title	Condition	Number of patient responses
COVID-19	COVID-19	41,486
Adult asthma	Asthma	19,403
COPD	COPD	9636
MAGNIFY	COPD	3364
Open Clinica	Asthma	756
British Lung Foundation, adult	COPD	730
British Lung Foundation, child	COPD	243
IMP^2ART	Asthma	202
Admin adult asthma	Asthma	59
Admin child asthma	Asthma	14
Admin COPD	COPD	7