# define freeze number
freeze_num = 12
# import packages
import pandas as pd, sys
from IPython.display import HTML, display, Markdown
# create instance of freeze class
fp = 'S:/UKLLC - UKLLC Databank/UKLLC Systems/programs/quarterly'
sys.path.insert(0, fp)
import freeze_helper as fh
frehelp = fh.FreezeHelper(freeze_num) 

Freeze number 12 dated May 2025#

Due to the UK LLC pooled sample being dynamic and the denominator changing over time, the UK LLC establishes a ‘data freeze’ of the pooled sample each quarter. Approved users are provisioned data against a set freeze which fixes their denominator at the start of their project and this remains fixed throughout the course of the project.

Table 1: Participants enrolled in LPS and included in the UK LLC resource#

Variation in contribution rates between LPS is mostly due to differences in fair processing. UK LLC continues to work with LPS to establish the governance permissions necessary to maximise the number of enrolled participants in the UK LLC resource.

display(frehelp.style_table(frehelp.get_table('table1')))
LPS N participants enrolled in LPS N (%) participants sent to UK LLC N participants not sent to UK LLC
AIRWAVE 53244 52914 (99.4%) 330
ALSPAC 32144 6383 (19.9%) 25761
BCS70 18888 9341 (49.5%) 9547
BIB 29664 28590 (96.4%) 1074
ELSA 18807 9080 (48.3%) 9727
EPICN 30445 15755 (51.7%) 14690
EXCEED 11782 11141 (94.6%) 641
FENLAND 12435 12071 (97.1%) 364
GENSCOT 25152 22379 (89.0%) 2773
GLAD 83880 82950 (98.9%) 930
MCS 40207 28150 (70.0%) 12057
NCDS58 18563 9090 (49.0%) 9473
NEXTSTEP 15629 7451 (47.7%) 8178
NICOLA 8739 5247 (60.0%) 3492
NIHRBIO_COPING 17183 17158 (99.9%) 25
NSHD46 5362 4289 (80.0%) 1073
SABRE 5251 4719 (89.9%) 532
TEDS 27890 11101 (39.8%) 16789
TRACKC19 20630 19633 (95.2%) 997
TWINSUK 17178 16562 (96.4%) 616
UKHLS 8938 8775 (98.2%) 163
UKREACH 24968 21581 (86.4%) 3387
Total 526979 404360 (76.7%) 122619

Table 1 exclusions: The total number of participants not sent to UK LLC with reason for exclusion#

display(frehelp.style_table(frehelp.get_exclusions()))
Exclusion reason N participants
(i) Excluded because they died <2020 16541
(ii) Excluded because they died >=2020 1139
(iii) Excluded because they withdrew from LPS 20483
(iv) Excluded because they dissented from UK LLC 2986
(v) Excluded because they dissented from record linkage 32466
(vi) Excluded because governance not established 30894
(vii) Excluded for other reasons 18110

Footnotes with further details about exclusion criteria

(i) & (ii) UK LLC does not prohibit LPS from sending data for participants who have died. However, some LPS have policies which preclude these participants from inclusion in the resource. Data for participants who died on or after January 1, 2020 are particularly important for COVID-19 research, and so LPS were requested to send these data where possible.

(v) Participants who have dissented from linkage can still be included in the UK LLC resource, with permission flags set accordingly. However, some LPS policies preclude participants from inclusion.

Where a participant was excluded for more than one reason, LPS were asked to count participants once using the exclusion hierarchy (i-vii).

Information presented in Table1 was provided by the LPS at the latest quarterly File1 update corresponding with the freeze name printed at the top of this notebook.