{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "fc8dc366",
"metadata": {
"tags": [
"remove-input"
]
},
"outputs": [],
"source": [
"# define freeze number\n",
"freeze_num = 14\n",
"# import packages\n",
"import pandas as pd, sys\n",
"from IPython.display import HTML, display, Markdown\n",
"# create instance of freeze class\n",
"fp = 'S:/UKLLC - UKLLC Databank/UKLLC Systems/programs/quarterly'\n",
"sys.path.insert(0, fp)\n",
"import freeze_helper as fh\n",
"frehelp = fh.FreezeHelper(freeze_num)\n",
"# retrive freeze name\n",
"freeze_name = frehelp.get_freeze_info()['freeze_name'][0]\n",
"\n",
"# \"ignores this method is deprecated in favour of `Styler.hide(axis='index')` \" warning\n",
"import warnings\n",
"warnings.filterwarnings('ignore')"
]
},
{
"cell_type": "markdown",
"id": "d40091d6",
"metadata": {
"scrolled": true
},
"source": [
"# Freeze number 14 dated November 2025"
]
},
{
"cell_type": "markdown",
"id": "f4a24f7d",
"metadata": {},
"source": [
"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. "
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "ac446b12",
"metadata": {
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/markdown": [
"**To cite this freeze:** UK Longitudinal Linkage Collaboration (UK LLC). (2025) *Freeze number 14 dated November 2025.* UK Longitudinal Linkage Collaboration (UKLLC). https://10.71760/ukllc-freeze-00014"
],
"text/plain": [
"<IPython.core.display.Markdown object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"display(Markdown(frehelp.style_citation(freeze_name)))"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "d343aaa5",
"metadata": {
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/markdown": [
"Download Citation: [Citeproc JSON](https://api.datacite.org/application/vnd.citationstyles.csl+json/10.71760/ukllc-freeze-00014) [BibTeX](https://api.datacite.org/application/x-bibtex/10.71760/ukllc-freeze-00014) [RIS](https://api.datacite.org/application/x-research-info-systems/10.71760/ukllc-freeze-00014)"
],
"text/plain": [
"<IPython.core.display.Markdown object>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"display(Markdown(frehelp.style_dl_cites()))"
]
},
{
"cell_type": "markdown",
"id": "89b8805d",
"metadata": {},
"source": [
"### Table 1: Participants enrolled in LPS and included in the UK LLC resource \n",
"\n",
"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."
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "3fef0190",
"metadata": {
"scrolled": true,
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/html": [
"<style type=\"text/css\">\n",
"#T_7fb2a th {\n",
" text-align: left;\n",
"}\n",
"#T_7fb2a_row0_col0, #T_7fb2a_row1_col0, #T_7fb2a_row2_col0, #T_7fb2a_row3_col0, #T_7fb2a_row4_col0, #T_7fb2a_row5_col0, #T_7fb2a_row6_col0, #T_7fb2a_row7_col0, #T_7fb2a_row8_col0, #T_7fb2a_row9_col0, #T_7fb2a_row10_col0, #T_7fb2a_row11_col0, #T_7fb2a_row12_col0, #T_7fb2a_row13_col0, #T_7fb2a_row14_col0, #T_7fb2a_row15_col0, #T_7fb2a_row16_col0, #T_7fb2a_row17_col0, #T_7fb2a_row18_col0, #T_7fb2a_row19_col0, #T_7fb2a_row20_col0, #T_7fb2a_row21_col0, #T_7fb2a_row22_col1, #T_7fb2a_row22_col2, #T_7fb2a_row22_col3 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
"}\n",
"#T_7fb2a_row0_col1, #T_7fb2a_row0_col2, #T_7fb2a_row0_col3, #T_7fb2a_row1_col1, #T_7fb2a_row1_col2, #T_7fb2a_row1_col3, #T_7fb2a_row2_col1, #T_7fb2a_row2_col2, #T_7fb2a_row2_col3, #T_7fb2a_row3_col1, #T_7fb2a_row3_col2, #T_7fb2a_row3_col3, #T_7fb2a_row4_col1, #T_7fb2a_row4_col2, #T_7fb2a_row4_col3, #T_7fb2a_row5_col1, #T_7fb2a_row5_col2, #T_7fb2a_row5_col3, #T_7fb2a_row6_col1, #T_7fb2a_row6_col2, #T_7fb2a_row6_col3, #T_7fb2a_row7_col1, #T_7fb2a_row7_col2, #T_7fb2a_row7_col3, #T_7fb2a_row8_col1, #T_7fb2a_row8_col2, #T_7fb2a_row8_col3, #T_7fb2a_row9_col1, #T_7fb2a_row9_col2, #T_7fb2a_row9_col3, #T_7fb2a_row10_col1, #T_7fb2a_row10_col2, #T_7fb2a_row10_col3, #T_7fb2a_row11_col1, #T_7fb2a_row11_col2, #T_7fb2a_row11_col3, #T_7fb2a_row12_col1, #T_7fb2a_row12_col2, #T_7fb2a_row12_col3, #T_7fb2a_row13_col1, #T_7fb2a_row13_col2, #T_7fb2a_row13_col3, #T_7fb2a_row14_col1, #T_7fb2a_row14_col2, #T_7fb2a_row14_col3, #T_7fb2a_row15_col1, #T_7fb2a_row15_col2, #T_7fb2a_row15_col3, #T_7fb2a_row16_col1, #T_7fb2a_row16_col2, #T_7fb2a_row16_col3, #T_7fb2a_row17_col1, #T_7fb2a_row17_col2, #T_7fb2a_row17_col3, #T_7fb2a_row18_col1, #T_7fb2a_row18_col2, #T_7fb2a_row18_col3, #T_7fb2a_row19_col1, #T_7fb2a_row19_col2, #T_7fb2a_row19_col3, #T_7fb2a_row20_col1, #T_7fb2a_row20_col2, #T_7fb2a_row20_col3, #T_7fb2a_row21_col1, #T_7fb2a_row21_col2, #T_7fb2a_row21_col3 {\n",
" text-align: left;\n",
"}\n",
"#T_7fb2a_row22_col0 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
" font-weight: bold;\n",
"}\n",
"</style>\n",
"<table id=\"T_7fb2a\" style=\"font-size: 14px\">\n",
" <thead>\n",
" <tr>\n",
" <th id=\"T_7fb2a_level0_col0\" class=\"col_heading level0 col0\" >LPS</th>\n",
" <th id=\"T_7fb2a_level0_col1\" class=\"col_heading level0 col1\" >N participants enrolled in LPS</th>\n",
" <th id=\"T_7fb2a_level0_col2\" class=\"col_heading level0 col2\" >N (%) participants sent to UK LLC</th>\n",
" <th id=\"T_7fb2a_level0_col3\" class=\"col_heading level0 col3\" >N participants not sent to UK LLC</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row0_col0\" class=\"data row0 col0\" >AIRWAVE</td>\n",
" <td id=\"T_7fb2a_row0_col1\" class=\"data row0 col1\" >53244</td>\n",
" <td id=\"T_7fb2a_row0_col2\" class=\"data row0 col2\" >52914 (99.4%)</td>\n",
" <td id=\"T_7fb2a_row0_col3\" class=\"data row0 col3\" >330</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row1_col0\" class=\"data row1 col0\" >ALSPAC</td>\n",
" <td id=\"T_7fb2a_row1_col1\" class=\"data row1 col1\" >32144</td>\n",
" <td id=\"T_7fb2a_row1_col2\" class=\"data row1 col2\" >6383 (19.9%)</td>\n",
" <td id=\"T_7fb2a_row1_col3\" class=\"data row1 col3\" >25761</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row2_col0\" class=\"data row2 col0\" >BCS70</td>\n",
" <td id=\"T_7fb2a_row2_col1\" class=\"data row2 col1\" >18888</td>\n",
" <td id=\"T_7fb2a_row2_col2\" class=\"data row2 col2\" >9337 (49.4%)</td>\n",
" <td id=\"T_7fb2a_row2_col3\" class=\"data row2 col3\" >9551</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row3_col0\" class=\"data row3 col0\" >BIB</td>\n",
" <td id=\"T_7fb2a_row3_col1\" class=\"data row3 col1\" >29664</td>\n",
" <td id=\"T_7fb2a_row3_col2\" class=\"data row3 col2\" >28590 (96.4%)</td>\n",
" <td id=\"T_7fb2a_row3_col3\" class=\"data row3 col3\" >1074</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row4_col0\" class=\"data row4 col0\" >ELSA</td>\n",
" <td id=\"T_7fb2a_row4_col1\" class=\"data row4 col1\" >18807</td>\n",
" <td id=\"T_7fb2a_row4_col2\" class=\"data row4 col2\" >9080 (48.3%)</td>\n",
" <td id=\"T_7fb2a_row4_col3\" class=\"data row4 col3\" >9727</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row5_col0\" class=\"data row5 col0\" >EPICN</td>\n",
" <td id=\"T_7fb2a_row5_col1\" class=\"data row5 col1\" >30445</td>\n",
" <td id=\"T_7fb2a_row5_col2\" class=\"data row5 col2\" >15755 (51.7%)</td>\n",
" <td id=\"T_7fb2a_row5_col3\" class=\"data row5 col3\" >14690</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row6_col0\" class=\"data row6 col0\" >EXCEED</td>\n",
" <td id=\"T_7fb2a_row6_col1\" class=\"data row6 col1\" >11807</td>\n",
" <td id=\"T_7fb2a_row6_col2\" class=\"data row6 col2\" >11149 (94.4%)</td>\n",
" <td id=\"T_7fb2a_row6_col3\" class=\"data row6 col3\" >658</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row7_col0\" class=\"data row7 col0\" >FENLAND</td>\n",
" <td id=\"T_7fb2a_row7_col1\" class=\"data row7 col1\" >12435</td>\n",
" <td id=\"T_7fb2a_row7_col2\" class=\"data row7 col2\" >12071 (97.1%)</td>\n",
" <td id=\"T_7fb2a_row7_col3\" class=\"data row7 col3\" >364</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row8_col0\" class=\"data row8 col0\" >GENSCOT</td>\n",
" <td id=\"T_7fb2a_row8_col1\" class=\"data row8 col1\" >25152</td>\n",
" <td id=\"T_7fb2a_row8_col2\" class=\"data row8 col2\" >22378 (89.0%)</td>\n",
" <td id=\"T_7fb2a_row8_col3\" class=\"data row8 col3\" >2774</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row9_col0\" class=\"data row9 col0\" >GLAD</td>\n",
" <td id=\"T_7fb2a_row9_col1\" class=\"data row9 col1\" >83880</td>\n",
" <td id=\"T_7fb2a_row9_col2\" class=\"data row9 col2\" >82950 (98.9%)</td>\n",
" <td id=\"T_7fb2a_row9_col3\" class=\"data row9 col3\" >930</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row10_col0\" class=\"data row10 col0\" >MCS</td>\n",
" <td id=\"T_7fb2a_row10_col1\" class=\"data row10 col1\" >40207</td>\n",
" <td id=\"T_7fb2a_row10_col2\" class=\"data row10 col2\" >35091 (87.3%)</td>\n",
" <td id=\"T_7fb2a_row10_col3\" class=\"data row10 col3\" >5116</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row11_col0\" class=\"data row11 col0\" >NCDS58</td>\n",
" <td id=\"T_7fb2a_row11_col1\" class=\"data row11 col1\" >18563</td>\n",
" <td id=\"T_7fb2a_row11_col2\" class=\"data row11 col2\" >9670 (52.1%)</td>\n",
" <td id=\"T_7fb2a_row11_col3\" class=\"data row11 col3\" >8893</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row12_col0\" class=\"data row12 col0\" >NEXTSTEP</td>\n",
" <td id=\"T_7fb2a_row12_col1\" class=\"data row12 col1\" >15629</td>\n",
" <td id=\"T_7fb2a_row12_col2\" class=\"data row12 col2\" >7451 (47.7%)</td>\n",
" <td id=\"T_7fb2a_row12_col3\" class=\"data row12 col3\" >8178</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row13_col0\" class=\"data row13 col0\" >NICOLA</td>\n",
" <td id=\"T_7fb2a_row13_col1\" class=\"data row13 col1\" >8739</td>\n",
" <td id=\"T_7fb2a_row13_col2\" class=\"data row13 col2\" >5247 (60.0%)</td>\n",
" <td id=\"T_7fb2a_row13_col3\" class=\"data row13 col3\" >3492</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row14_col0\" class=\"data row14 col0\" >NIHRBIO_COPING</td>\n",
" <td id=\"T_7fb2a_row14_col1\" class=\"data row14 col1\" >17183</td>\n",
" <td id=\"T_7fb2a_row14_col2\" class=\"data row14 col2\" >17150 (99.8%)</td>\n",
" <td id=\"T_7fb2a_row14_col3\" class=\"data row14 col3\" >33</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row15_col0\" class=\"data row15 col0\" >NSHD46</td>\n",
" <td id=\"T_7fb2a_row15_col1\" class=\"data row15 col1\" >5362</td>\n",
" <td id=\"T_7fb2a_row15_col2\" class=\"data row15 col2\" >4289 (80.0%)</td>\n",
" <td id=\"T_7fb2a_row15_col3\" class=\"data row15 col3\" >1073</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row16_col0\" class=\"data row16 col0\" >SABRE</td>\n",
" <td id=\"T_7fb2a_row16_col1\" class=\"data row16 col1\" >5251</td>\n",
" <td id=\"T_7fb2a_row16_col2\" class=\"data row16 col2\" >4719 (89.9%)</td>\n",
" <td id=\"T_7fb2a_row16_col3\" class=\"data row16 col3\" >532</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row17_col0\" class=\"data row17 col0\" >TEDS</td>\n",
" <td id=\"T_7fb2a_row17_col1\" class=\"data row17 col1\" >27890</td>\n",
" <td id=\"T_7fb2a_row17_col2\" class=\"data row17 col2\" >11186 (40.1%)</td>\n",
" <td id=\"T_7fb2a_row17_col3\" class=\"data row17 col3\" >16704</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row18_col0\" class=\"data row18 col0\" >TRACKC19</td>\n",
" <td id=\"T_7fb2a_row18_col1\" class=\"data row18 col1\" >20630</td>\n",
" <td id=\"T_7fb2a_row18_col2\" class=\"data row18 col2\" >19633 (95.2%)</td>\n",
" <td id=\"T_7fb2a_row18_col3\" class=\"data row18 col3\" >997</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row19_col0\" class=\"data row19 col0\" >TWINSUK</td>\n",
" <td id=\"T_7fb2a_row19_col1\" class=\"data row19 col1\" >17189</td>\n",
" <td id=\"T_7fb2a_row19_col2\" class=\"data row19 col2\" >16618 (96.7%)</td>\n",
" <td id=\"T_7fb2a_row19_col3\" class=\"data row19 col3\" >571</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row20_col0\" class=\"data row20 col0\" >UKHLS</td>\n",
" <td id=\"T_7fb2a_row20_col1\" class=\"data row20 col1\" >166979</td>\n",
" <td id=\"T_7fb2a_row20_col2\" class=\"data row20 col2\" >166816 (99.9%)</td>\n",
" <td id=\"T_7fb2a_row20_col3\" class=\"data row20 col3\" >163</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row21_col0\" class=\"data row21 col0\" >UKREACH</td>\n",
" <td id=\"T_7fb2a_row21_col1\" class=\"data row21 col1\" >24972</td>\n",
" <td id=\"T_7fb2a_row21_col2\" class=\"data row21 col2\" >21583 (86.4%)</td>\n",
" <td id=\"T_7fb2a_row21_col3\" class=\"data row21 col3\" >3389</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_7fb2a_row22_col0\" class=\"data row22 col0\" >Total</td>\n",
" <td id=\"T_7fb2a_row22_col1\" class=\"data row22 col1\" >685060</td>\n",
" <td id=\"T_7fb2a_row22_col2\" class=\"data row22 col2\" >570060 (83.2%)</td>\n",
" <td id=\"T_7fb2a_row22_col3\" class=\"data row22 col3\" >115000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n"
],
"text/plain": [
"<pandas.io.formats.style.Styler at 0x174a0305130>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"display(frehelp.style_table(frehelp.get_table('table1')))"
]
},
{
"cell_type": "markdown",
"id": "543c66e5",
"metadata": {},
"source": [
"***Footnotes:***\n",
"Figures for **N participants enrolled in LPS** were originally provided by the respective studies, and we are working to improve the accuracy and completness of these figures."
]
},
{
"cell_type": "markdown",
"id": "d8bfad6e",
"metadata": {},
"source": [
"### Table 1 exclusions: The total number of participants not sent to UK LLC with reason for exclusion "
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "96f1cd0a",
"metadata": {
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/html": [
"<style type=\"text/css\">\n",
"#T_e69c2 th {\n",
" text-align: left;\n",
"}\n",
"#T_e69c2_row0_col0, #T_e69c2_row0_col1, #T_e69c2_row1_col0, #T_e69c2_row1_col1, #T_e69c2_row2_col0, #T_e69c2_row2_col1, #T_e69c2_row3_col0, #T_e69c2_row3_col1, #T_e69c2_row4_col0, #T_e69c2_row4_col1, #T_e69c2_row5_col0, #T_e69c2_row5_col1, #T_e69c2_row6_col0, #T_e69c2_row6_col1 {\n",
" text-align: left;\n",
"}\n",
"</style>\n",
"<table id=\"T_e69c2\" style=\"font-size: 14px\">\n",
" <thead>\n",
" <tr>\n",
" <th id=\"T_e69c2_level0_col0\" class=\"col_heading level0 col0\" >Exclusion reason</th>\n",
" <th id=\"T_e69c2_level0_col1\" class=\"col_heading level0 col1\" >N participants</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td id=\"T_e69c2_row0_col0\" class=\"data row0 col0\" >(i) Excluded because they died <2020</td>\n",
" <td id=\"T_e69c2_row0_col1\" class=\"data row0 col1\" >16541</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row1_col0\" class=\"data row1 col0\" >(ii) Excluded because they died >=2020</td>\n",
" <td id=\"T_e69c2_row1_col1\" class=\"data row1 col1\" >1139</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row2_col0\" class=\"data row2 col0\" >(iii) Excluded because they withdrew from LPS</td>\n",
" <td id=\"T_e69c2_row2_col1\" class=\"data row2 col1\" >20490</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row3_col0\" class=\"data row3 col0\" >(iv) Excluded because they dissented from UK LLC</td>\n",
" <td id=\"T_e69c2_row3_col1\" class=\"data row3 col1\" >2991</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row4_col0\" class=\"data row4 col0\" >(v) Excluded because they dissented from record linkage</td>\n",
" <td id=\"T_e69c2_row4_col1\" class=\"data row4 col1\" >32463</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row5_col0\" class=\"data row5 col0\" >(vi) Excluded because governance not established</td>\n",
" <td id=\"T_e69c2_row5_col1\" class=\"data row5 col1\" >30829</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_e69c2_row6_col0\" class=\"data row6 col0\" >(vii) Excluded for other reasons</td>\n",
" <td id=\"T_e69c2_row6_col1\" class=\"data row6 col1\" >10547</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n"
],
"text/plain": [
"<pandas.io.formats.style.Styler at 0x174a37ebbb0>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"display(frehelp.style_table(frehelp.get_exclusions()))"
]
},
{
"cell_type": "markdown",
"id": "1c0d8f3b",
"metadata": {},
"source": [
"***Footnotes with further details about exclusion criteria***\n",
"\n",
"(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.\n",
"\n",
"(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.\n",
"\n",
"Where a participant was excluded for more than one reason, LPS were asked to count participants once using the exclusion hierarchy (i-vii).\n",
"\n",
"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. "
]
},
{
"cell_type": "markdown",
"id": "58ebc4c0",
"metadata": {},
"source": [
"### Table 2: Participants in the UK LLC with permission to link to NHS England and their legal basis \n",
"\n",
"Permission flags are set at a participant level or at an LPS level giving participants or LPS control over which linkages are established or removed. NHS England operates the National Opt Out (NOO) scheme, where individuals can request that their health record is not shared for research purposes. Where explicit and informed consent is in place, the NOO is overwritten. Where opt-out consent approaches are used in conjunction with Section 251 (s251) of the NHS Act 2006, then NOO is fully respected and no records will be accessed. The current NOO rate is 5.4% of the population; information on NOO rates can be found on the NHS England website<sup>1</sup>. For this reason, the UK LLC anticipates lower linkage rates where s251 is used. \n",
"\n",
"<p style='font-size: 12px;'><sup>1</sup>digital.nhs.uk/services/national-data-opt-out</p>"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "51f3cc9f",
"metadata": {
"scrolled": true,
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/html": [
"<style type=\"text/css\">\n",
"#T_00214 th {\n",
" text-align: left;\n",
"}\n",
"#T_00214_row0_col0, #T_00214_row1_col0, #T_00214_row2_col0, #T_00214_row3_col0, #T_00214_row4_col0, #T_00214_row5_col0, #T_00214_row6_col0, #T_00214_row7_col0, #T_00214_row8_col0, #T_00214_row9_col0, #T_00214_row10_col0, #T_00214_row11_col0, #T_00214_row12_col0, #T_00214_row13_col0, #T_00214_row14_col0, #T_00214_row15_col0, #T_00214_row16_col0, #T_00214_row17_col0, #T_00214_row18_col0, #T_00214_row19_col1, #T_00214_row19_col2, #T_00214_row19_col3, #T_00214_row19_col4, #T_00214_row19_col5 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
"}\n",
"#T_00214_row0_col1, #T_00214_row0_col2, #T_00214_row0_col3, #T_00214_row0_col4, #T_00214_row0_col5, #T_00214_row1_col1, #T_00214_row1_col2, #T_00214_row1_col3, #T_00214_row1_col4, #T_00214_row1_col5, #T_00214_row2_col1, #T_00214_row2_col2, #T_00214_row2_col3, #T_00214_row2_col4, #T_00214_row2_col5, #T_00214_row3_col1, #T_00214_row3_col2, #T_00214_row3_col3, #T_00214_row3_col4, #T_00214_row3_col5, #T_00214_row4_col1, #T_00214_row4_col2, #T_00214_row4_col3, #T_00214_row4_col4, #T_00214_row4_col5, #T_00214_row5_col1, #T_00214_row5_col2, #T_00214_row5_col3, #T_00214_row5_col4, #T_00214_row5_col5, #T_00214_row6_col1, #T_00214_row6_col2, #T_00214_row6_col3, #T_00214_row6_col4, #T_00214_row6_col5, #T_00214_row7_col1, #T_00214_row7_col2, #T_00214_row7_col3, #T_00214_row7_col4, #T_00214_row7_col5, #T_00214_row8_col1, #T_00214_row8_col2, #T_00214_row8_col3, #T_00214_row8_col4, #T_00214_row8_col5, #T_00214_row9_col1, #T_00214_row9_col2, #T_00214_row9_col3, #T_00214_row9_col4, #T_00214_row9_col5, #T_00214_row10_col1, #T_00214_row10_col2, #T_00214_row10_col3, #T_00214_row10_col4, #T_00214_row10_col5, #T_00214_row11_col1, #T_00214_row11_col2, #T_00214_row11_col3, #T_00214_row11_col4, #T_00214_row11_col5, #T_00214_row12_col1, #T_00214_row12_col2, #T_00214_row12_col3, #T_00214_row12_col4, #T_00214_row12_col5, #T_00214_row13_col1, #T_00214_row13_col2, #T_00214_row13_col3, #T_00214_row13_col4, #T_00214_row13_col5, #T_00214_row14_col1, #T_00214_row14_col2, #T_00214_row14_col3, #T_00214_row14_col4, #T_00214_row14_col5, #T_00214_row15_col1, #T_00214_row15_col2, #T_00214_row15_col3, #T_00214_row15_col4, #T_00214_row15_col5, #T_00214_row16_col1, #T_00214_row16_col2, #T_00214_row16_col3, #T_00214_row16_col4, #T_00214_row16_col5, #T_00214_row17_col1, #T_00214_row17_col2, #T_00214_row17_col3, #T_00214_row17_col4, #T_00214_row17_col5, #T_00214_row18_col1, #T_00214_row18_col2, #T_00214_row18_col3, #T_00214_row18_col4, #T_00214_row18_col5 {\n",
" text-align: left;\n",
"}\n",
"#T_00214_row19_col0 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
" font-weight: bold;\n",
"}\n",
"</style>\n",
"<table id=\"T_00214\" style=\"font-size: 14px\">\n",
" <thead>\n",
" <tr>\n",
" <th id=\"T_00214_level0_col0\" class=\"col_heading level0 col0\" >LPS</th>\n",
" <th id=\"T_00214_level0_col1\" class=\"col_heading level0 col1\" >N participants sent to UK LLC</th>\n",
" <th id=\"T_00214_level0_col2\" class=\"col_heading level0 col2\" >N with permission to link to NHS E</th>\n",
" <th id=\"T_00214_level0_col3\" class=\"col_heading level0 col3\" >N linked s251</th>\n",
" <th id=\"T_00214_level0_col4\" class=\"col_heading level0 col4\" >N linked consent</th>\n",
" <th id=\"T_00214_level0_col5\" class=\"col_heading level0 col5\" >N linked total</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td id=\"T_00214_row0_col0\" class=\"data row0 col0\" >AIRWAVE</td>\n",
" <td id=\"T_00214_row0_col1\" class=\"data row0 col1\" >52914</td>\n",
" <td id=\"T_00214_row0_col2\" class=\"data row0 col2\" >52912 (100.0%)</td>\n",
" <td id=\"T_00214_row0_col3\" class=\"data row0 col3\" ></td>\n",
" <td id=\"T_00214_row0_col4\" class=\"data row0 col4\" ></td>\n",
" <td id=\"T_00214_row0_col5\" class=\"data row0 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row1_col0\" class=\"data row1 col0\" >ALSPAC</td>\n",
" <td id=\"T_00214_row1_col1\" class=\"data row1 col1\" >6383</td>\n",
" <td id=\"T_00214_row1_col2\" class=\"data row1 col2\" >6383 (100.0%)</td>\n",
" <td id=\"T_00214_row1_col3\" class=\"data row1 col3\" >1306 (91.4%)</td>\n",
" <td id=\"T_00214_row1_col4\" class=\"data row1 col4\" >4945 (99.8%)</td>\n",
" <td id=\"T_00214_row1_col5\" class=\"data row1 col5\" >6251 (97.9%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row2_col0\" class=\"data row2 col0\" >BCS70</td>\n",
" <td id=\"T_00214_row2_col1\" class=\"data row2 col1\" >9337</td>\n",
" <td id=\"T_00214_row2_col2\" class=\"data row2 col2\" >8419 (90.2%)</td>\n",
" <td id=\"T_00214_row2_col3\" class=\"data row2 col3\" ></td>\n",
" <td id=\"T_00214_row2_col4\" class=\"data row2 col4\" >6480 (77.0%)</td>\n",
" <td id=\"T_00214_row2_col5\" class=\"data row2 col5\" >6480 (77.0%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row3_col0\" class=\"data row3 col0\" >BIB</td>\n",
" <td id=\"T_00214_row3_col1\" class=\"data row3 col1\" >28590</td>\n",
" <td id=\"T_00214_row3_col2\" class=\"data row3 col2\" >28590 (100.0%)</td>\n",
" <td id=\"T_00214_row3_col3\" class=\"data row3 col3\" ></td>\n",
" <td id=\"T_00214_row3_col4\" class=\"data row3 col4\" >28427 (99.4%)</td>\n",
" <td id=\"T_00214_row3_col5\" class=\"data row3 col5\" >28427 (99.4%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row4_col0\" class=\"data row4 col0\" >ELSA</td>\n",
" <td id=\"T_00214_row4_col1\" class=\"data row4 col1\" >9080</td>\n",
" <td id=\"T_00214_row4_col2\" class=\"data row4 col2\" >7426 (81.8%)</td>\n",
" <td id=\"T_00214_row4_col3\" class=\"data row4 col3\" ></td>\n",
" <td id=\"T_00214_row4_col4\" class=\"data row4 col4\" >7097 (95.6%)</td>\n",
" <td id=\"T_00214_row4_col5\" class=\"data row4 col5\" >7097 (95.6%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row5_col0\" class=\"data row5 col0\" >EPICN</td>\n",
" <td id=\"T_00214_row5_col1\" class=\"data row5 col1\" >15755</td>\n",
" <td id=\"T_00214_row5_col2\" class=\"data row5 col2\" >15755 (100.0%)</td>\n",
" <td id=\"T_00214_row5_col3\" class=\"data row5 col3\" >15117 (96.0%)</td>\n",
" <td id=\"T_00214_row5_col4\" class=\"data row5 col4\" ></td>\n",
" <td id=\"T_00214_row5_col5\" class=\"data row5 col5\" >15117 (96.0%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row6_col0\" class=\"data row6 col0\" >EXCEED</td>\n",
" <td id=\"T_00214_row6_col1\" class=\"data row6 col1\" >11149</td>\n",
" <td id=\"T_00214_row6_col2\" class=\"data row6 col2\" >11132 (99.8%)</td>\n",
" <td id=\"T_00214_row6_col3\" class=\"data row6 col3\" ></td>\n",
" <td id=\"T_00214_row6_col4\" class=\"data row6 col4\" >9493 (85.3%)</td>\n",
" <td id=\"T_00214_row6_col5\" class=\"data row6 col5\" >9493 (85.3%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row7_col0\" class=\"data row7 col0\" >FENLAND</td>\n",
" <td id=\"T_00214_row7_col1\" class=\"data row7 col1\" >12071</td>\n",
" <td id=\"T_00214_row7_col2\" class=\"data row7 col2\" >12071 (100.0%)</td>\n",
" <td id=\"T_00214_row7_col3\" class=\"data row7 col3\" ></td>\n",
" <td id=\"T_00214_row7_col4\" class=\"data row7 col4\" >10595 (87.8%)</td>\n",
" <td id=\"T_00214_row7_col5\" class=\"data row7 col5\" >10595 (87.8%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row8_col0\" class=\"data row8 col0\" >GLAD</td>\n",
" <td id=\"T_00214_row8_col1\" class=\"data row8 col1\" >82950</td>\n",
" <td id=\"T_00214_row8_col2\" class=\"data row8 col2\" >76442 (92.2%)</td>\n",
" <td id=\"T_00214_row8_col3\" class=\"data row8 col3\" ></td>\n",
" <td id=\"T_00214_row8_col4\" class=\"data row8 col4\" >67128 (87.8%)</td>\n",
" <td id=\"T_00214_row8_col5\" class=\"data row8 col5\" >67128 (87.8%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row9_col0\" class=\"data row9 col0\" >MCS</td>\n",
" <td id=\"T_00214_row9_col1\" class=\"data row9 col1\" >35091</td>\n",
" <td id=\"T_00214_row9_col2\" class=\"data row9 col2\" >30111 (85.8%)</td>\n",
" <td id=\"T_00214_row9_col3\" class=\"data row9 col3\" ></td>\n",
" <td id=\"T_00214_row9_col4\" class=\"data row9 col4\" >21900 (72.7%)</td>\n",
" <td id=\"T_00214_row9_col5\" class=\"data row9 col5\" >21900 (72.7%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row10_col0\" class=\"data row10 col0\" >NCDS58</td>\n",
" <td id=\"T_00214_row10_col1\" class=\"data row10 col1\" >9670</td>\n",
" <td id=\"T_00214_row10_col2\" class=\"data row10 col2\" >8902 (92.1%)</td>\n",
" <td id=\"T_00214_row10_col3\" class=\"data row10 col3\" ></td>\n",
" <td id=\"T_00214_row10_col4\" class=\"data row10 col4\" >7507 (84.3%)</td>\n",
" <td id=\"T_00214_row10_col5\" class=\"data row10 col5\" >7507 (84.3%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row11_col0\" class=\"data row11 col0\" >NEXTSTEP</td>\n",
" <td id=\"T_00214_row11_col1\" class=\"data row11 col1\" >7451</td>\n",
" <td id=\"T_00214_row11_col2\" class=\"data row11 col2\" >6401 (85.9%)</td>\n",
" <td id=\"T_00214_row11_col3\" class=\"data row11 col3\" ></td>\n",
" <td id=\"T_00214_row11_col4\" class=\"data row11 col4\" >5337 (83.4%)</td>\n",
" <td id=\"T_00214_row11_col5\" class=\"data row11 col5\" >5337 (83.4%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row12_col0\" class=\"data row12 col0\" >NIHRBIO_COPING</td>\n",
" <td id=\"T_00214_row12_col1\" class=\"data row12 col1\" >17150</td>\n",
" <td id=\"T_00214_row12_col2\" class=\"data row12 col2\" >17150 (100.0%)</td>\n",
" <td id=\"T_00214_row12_col3\" class=\"data row12 col3\" ></td>\n",
" <td id=\"T_00214_row12_col4\" class=\"data row12 col4\" >16775 (97.8%)</td>\n",
" <td id=\"T_00214_row12_col5\" class=\"data row12 col5\" >16775 (97.8%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row13_col0\" class=\"data row13 col0\" >NSHD46</td>\n",
" <td id=\"T_00214_row13_col1\" class=\"data row13 col1\" >4289</td>\n",
" <td id=\"T_00214_row13_col2\" class=\"data row13 col2\" >4289 (100.0%)</td>\n",
" <td id=\"T_00214_row13_col3\" class=\"data row13 col3\" >1417 (98.8%)</td>\n",
" <td id=\"T_00214_row13_col4\" class=\"data row13 col4\" >2819 (98.7%)</td>\n",
" <td id=\"T_00214_row13_col5\" class=\"data row13 col5\" >4236 (98.8%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row14_col0\" class=\"data row14 col0\" >TEDS</td>\n",
" <td id=\"T_00214_row14_col1\" class=\"data row14 col1\" >11186</td>\n",
" <td id=\"T_00214_row14_col2\" class=\"data row14 col2\" >11186 (100.0%)</td>\n",
" <td id=\"T_00214_row14_col3\" class=\"data row14 col3\" >8240 (77.7%)</td>\n",
" <td id=\"T_00214_row14_col4\" class=\"data row14 col4\" >398 (69.1%)</td>\n",
" <td id=\"T_00214_row14_col5\" class=\"data row14 col5\" >8638 (77.2%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row15_col0\" class=\"data row15 col0\" >TRACKC19</td>\n",
" <td id=\"T_00214_row15_col1\" class=\"data row15 col1\" >19633</td>\n",
" <td id=\"T_00214_row15_col2\" class=\"data row15 col2\" >19633 (100.0%)</td>\n",
" <td id=\"T_00214_row15_col3\" class=\"data row15 col3\" ></td>\n",
" <td id=\"T_00214_row15_col4\" class=\"data row15 col4\" >14188 (72.3%)</td>\n",
" <td id=\"T_00214_row15_col5\" class=\"data row15 col5\" >14188 (72.3%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row16_col0\" class=\"data row16 col0\" >TWINSUK</td>\n",
" <td id=\"T_00214_row16_col1\" class=\"data row16 col1\" >16618</td>\n",
" <td id=\"T_00214_row16_col2\" class=\"data row16 col2\" >16451 (99.0%)</td>\n",
" <td id=\"T_00214_row16_col3\" class=\"data row16 col3\" >13918 (84.6%)</td>\n",
" <td id=\"T_00214_row16_col4\" class=\"data row16 col4\" ></td>\n",
" <td id=\"T_00214_row16_col5\" class=\"data row16 col5\" >13918 (84.6%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row17_col0\" class=\"data row17 col0\" >UKHLS</td>\n",
" <td id=\"T_00214_row17_col1\" class=\"data row17 col1\" >166816</td>\n",
" <td id=\"T_00214_row17_col2\" class=\"data row17 col2\" >39945 (23.9%)</td>\n",
" <td id=\"T_00214_row17_col3\" class=\"data row17 col3\" ></td>\n",
" <td id=\"T_00214_row17_col4\" class=\"data row17 col4\" >7207 (18.0%)</td>\n",
" <td id=\"T_00214_row17_col5\" class=\"data row17 col5\" >7207 (18.0%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row18_col0\" class=\"data row18 col0\" >UKREACH</td>\n",
" <td id=\"T_00214_row18_col1\" class=\"data row18 col1\" >21583</td>\n",
" <td id=\"T_00214_row18_col2\" class=\"data row18 col2\" >21583 (100.0%)</td>\n",
" <td id=\"T_00214_row18_col3\" class=\"data row18 col3\" ></td>\n",
" <td id=\"T_00214_row18_col4\" class=\"data row18 col4\" ></td>\n",
" <td id=\"T_00214_row18_col5\" class=\"data row18 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_00214_row19_col0\" class=\"data row19 col0\" >Total</td>\n",
" <td id=\"T_00214_row19_col1\" class=\"data row19 col1\" >570060</td>\n",
" <td id=\"T_00214_row19_col2\" class=\"data row19 col2\" >417159 (73.2%)</td>\n",
" <td id=\"T_00214_row19_col3\" class=\"data row19 col3\" >39998 (87.6%)</td>\n",
" <td id=\"T_00214_row19_col4\" class=\"data row19 col4\" >210296 (56.6%)</td>\n",
" <td id=\"T_00214_row19_col5\" class=\"data row19 col5\" >250294 (60.0%)</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n"
],
"text/plain": [
"<pandas.io.formats.style.Styler at 0x174a37eba30>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"table2 = display(frehelp.style_table(frehelp.get_table('table2')))"
]
},
{
"cell_type": "markdown",
"id": "4069fa53",
"metadata": {},
"source": [
"***Footnotes***\n",
"\n",
"Participants in SABRE do not currently permit linkage to NHS England and therefore do not feature in Table 2.\n",
"\n",
"Participants in GENSCOT and NICOLA do not currently have permission to link to NHS England due to governance issues and geographical limitations and therefore also do not feature in Table 2.\n",
"\n",
"AIRWAVE and UKREACH have recently joined UK LLC and NHS England linkage updates are now annual. Therefore their linkage will appear missing and will be infilled at a later freeze."
]
},
{
"cell_type": "markdown",
"id": "e44816ae",
"metadata": {},
"source": [
"### Table 3: Participants in the UK LLC with permission to link to place-based datasets\n",
"\n",
"Permission flags are set at a participant level or at an LPS level giving participants or LPS control over which linkages are established or removed. UK LLC has four different place-based permission flags that fall into the two categories reported in the table below: (i) Neighbourhood geographies - geographies used to produce official statistics, e.g. census geographies such as Lower Super Output Area (LSOA); and (ii) Address geographies - household level using Unique Property Reference Number (UPRN) or postcode level.\n"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "cee3498c",
"metadata": {
"tags": [
"remove-input"
]
},
"outputs": [
{
"data": {
"text/html": [
"<style type=\"text/css\">\n",
"#T_0003e th {\n",
" text-align: left;\n",
"}\n",
"#T_0003e_row0_col0, #T_0003e_row1_col0, #T_0003e_row2_col0, #T_0003e_row3_col0, #T_0003e_row4_col0, #T_0003e_row5_col0, #T_0003e_row6_col0, #T_0003e_row7_col0, #T_0003e_row8_col0, #T_0003e_row9_col0, #T_0003e_row10_col0, #T_0003e_row11_col0, #T_0003e_row12_col0, #T_0003e_row13_col0, #T_0003e_row14_col0, #T_0003e_row15_col0, #T_0003e_row16_col0, #T_0003e_row17_col0, #T_0003e_row18_col0, #T_0003e_row19_col0, #T_0003e_row20_col0, #T_0003e_row21_col0, #T_0003e_row22_col1, #T_0003e_row22_col2, #T_0003e_row22_col3, #T_0003e_row22_col4, #T_0003e_row22_col5 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
"}\n",
"#T_0003e_row0_col1, #T_0003e_row0_col2, #T_0003e_row0_col3, #T_0003e_row0_col4, #T_0003e_row0_col5, #T_0003e_row1_col1, #T_0003e_row1_col2, #T_0003e_row1_col3, #T_0003e_row1_col4, #T_0003e_row1_col5, #T_0003e_row2_col1, #T_0003e_row2_col2, #T_0003e_row2_col3, #T_0003e_row2_col4, #T_0003e_row2_col5, #T_0003e_row3_col1, #T_0003e_row3_col2, #T_0003e_row3_col3, #T_0003e_row3_col4, #T_0003e_row3_col5, #T_0003e_row4_col1, #T_0003e_row4_col2, #T_0003e_row4_col3, #T_0003e_row4_col4, #T_0003e_row4_col5, #T_0003e_row5_col1, #T_0003e_row5_col2, #T_0003e_row5_col3, #T_0003e_row5_col4, #T_0003e_row5_col5, #T_0003e_row6_col1, #T_0003e_row6_col2, #T_0003e_row6_col3, #T_0003e_row6_col4, #T_0003e_row6_col5, #T_0003e_row7_col1, #T_0003e_row7_col2, #T_0003e_row7_col3, #T_0003e_row7_col4, #T_0003e_row7_col5, #T_0003e_row8_col1, #T_0003e_row8_col2, #T_0003e_row8_col3, #T_0003e_row8_col4, #T_0003e_row8_col5, #T_0003e_row9_col1, #T_0003e_row9_col2, #T_0003e_row9_col3, #T_0003e_row9_col4, #T_0003e_row9_col5, #T_0003e_row10_col1, #T_0003e_row10_col2, #T_0003e_row10_col3, #T_0003e_row10_col4, #T_0003e_row10_col5, #T_0003e_row11_col1, #T_0003e_row11_col2, #T_0003e_row11_col3, #T_0003e_row11_col4, #T_0003e_row11_col5, #T_0003e_row12_col1, #T_0003e_row12_col2, #T_0003e_row12_col3, #T_0003e_row12_col4, #T_0003e_row12_col5, #T_0003e_row13_col1, #T_0003e_row13_col2, #T_0003e_row13_col3, #T_0003e_row13_col4, #T_0003e_row13_col5, #T_0003e_row14_col1, #T_0003e_row14_col2, #T_0003e_row14_col3, #T_0003e_row14_col4, #T_0003e_row14_col5, #T_0003e_row15_col1, #T_0003e_row15_col2, #T_0003e_row15_col3, #T_0003e_row15_col4, #T_0003e_row15_col5, #T_0003e_row16_col1, #T_0003e_row16_col2, #T_0003e_row16_col3, #T_0003e_row16_col4, #T_0003e_row16_col5, #T_0003e_row17_col1, #T_0003e_row17_col2, #T_0003e_row17_col3, #T_0003e_row17_col4, #T_0003e_row17_col5, #T_0003e_row18_col1, #T_0003e_row18_col2, #T_0003e_row18_col3, #T_0003e_row18_col4, #T_0003e_row18_col5, #T_0003e_row19_col1, #T_0003e_row19_col2, #T_0003e_row19_col3, #T_0003e_row19_col4, #T_0003e_row19_col5, #T_0003e_row20_col1, #T_0003e_row20_col2, #T_0003e_row20_col3, #T_0003e_row20_col4, #T_0003e_row20_col5, #T_0003e_row21_col1, #T_0003e_row21_col2, #T_0003e_row21_col3, #T_0003e_row21_col4, #T_0003e_row21_col5 {\n",
" text-align: left;\n",
"}\n",
"#T_0003e_row22_col0 {\n",
" text-align: left;\n",
" font-weight: bold;\n",
" font-weight: bold;\n",
"}\n",
"</style>\n",
"<table id=\"T_0003e\" style=\"font-size: 14px\">\n",
" <thead>\n",
" <tr>\n",
" <th id=\"T_0003e_level0_col0\" class=\"col_heading level0 col0\" >LPS</th>\n",
" <th id=\"T_0003e_level0_col1\" class=\"col_heading level0 col1\" >N participants sent to UK LLC</th>\n",
" <th id=\"T_0003e_level0_col2\" class=\"col_heading level0 col2\" >N with permission to link to neighbourhood</th>\n",
" <th id=\"T_0003e_level0_col3\" class=\"col_heading level0 col3\" >N linked to neighbourhood</th>\n",
" <th id=\"T_0003e_level0_col4\" class=\"col_heading level0 col4\" >N with permission to link to address or postcode</th>\n",
" <th id=\"T_0003e_level0_col5\" class=\"col_heading level0 col5\" >N linked to address or postcode</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td id=\"T_0003e_row0_col0\" class=\"data row0 col0\" >AIRWAVE</td>\n",
" <td id=\"T_0003e_row0_col1\" class=\"data row0 col1\" >52914</td>\n",
" <td id=\"T_0003e_row0_col2\" class=\"data row0 col2\" >52914 (100.0%)</td>\n",
" <td id=\"T_0003e_row0_col3\" class=\"data row0 col3\" ></td>\n",
" <td id=\"T_0003e_row0_col4\" class=\"data row0 col4\" >52914 (100.0%)</td>\n",
" <td id=\"T_0003e_row0_col5\" class=\"data row0 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row1_col0\" class=\"data row1 col0\" >ALSPAC</td>\n",
" <td id=\"T_0003e_row1_col1\" class=\"data row1 col1\" >6383</td>\n",
" <td id=\"T_0003e_row1_col2\" class=\"data row1 col2\" >6383 (100.0%)</td>\n",
" <td id=\"T_0003e_row1_col3\" class=\"data row1 col3\" >6260 (98.1%)</td>\n",
" <td id=\"T_0003e_row1_col4\" class=\"data row1 col4\" >6383 (100.0%)</td>\n",
" <td id=\"T_0003e_row1_col5\" class=\"data row1 col5\" >2619 (41.0%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row2_col0\" class=\"data row2 col0\" >BCS70</td>\n",
" <td id=\"T_0003e_row2_col1\" class=\"data row2 col1\" >9337</td>\n",
" <td id=\"T_0003e_row2_col2\" class=\"data row2 col2\" ></td>\n",
" <td id=\"T_0003e_row2_col3\" class=\"data row2 col3\" ></td>\n",
" <td id=\"T_0003e_row2_col4\" class=\"data row2 col4\" ></td>\n",
" <td id=\"T_0003e_row2_col5\" class=\"data row2 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row3_col0\" class=\"data row3 col0\" >BIB</td>\n",
" <td id=\"T_0003e_row3_col1\" class=\"data row3 col1\" >28590</td>\n",
" <td id=\"T_0003e_row3_col2\" class=\"data row3 col2\" >28590 (100.0%)</td>\n",
" <td id=\"T_0003e_row3_col3\" class=\"data row3 col3\" >28441 (99.5%)</td>\n",
" <td id=\"T_0003e_row3_col4\" class=\"data row3 col4\" >28590 (100.0%)</td>\n",
" <td id=\"T_0003e_row3_col5\" class=\"data row3 col5\" >28515 (99.7%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row4_col0\" class=\"data row4 col0\" >ELSA</td>\n",
" <td id=\"T_0003e_row4_col1\" class=\"data row4 col1\" >9080</td>\n",
" <td id=\"T_0003e_row4_col2\" class=\"data row4 col2\" ></td>\n",
" <td id=\"T_0003e_row4_col3\" class=\"data row4 col3\" ></td>\n",
" <td id=\"T_0003e_row4_col4\" class=\"data row4 col4\" ></td>\n",
" <td id=\"T_0003e_row4_col5\" class=\"data row4 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row5_col0\" class=\"data row5 col0\" >EPICN</td>\n",
" <td id=\"T_0003e_row5_col1\" class=\"data row5 col1\" >15755</td>\n",
" <td id=\"T_0003e_row5_col2\" class=\"data row5 col2\" ></td>\n",
" <td id=\"T_0003e_row5_col3\" class=\"data row5 col3\" ></td>\n",
" <td id=\"T_0003e_row5_col4\" class=\"data row5 col4\" ></td>\n",
" <td id=\"T_0003e_row5_col5\" class=\"data row5 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row6_col0\" class=\"data row6 col0\" >EXCEED</td>\n",
" <td id=\"T_0003e_row6_col1\" class=\"data row6 col1\" >11149</td>\n",
" <td id=\"T_0003e_row6_col2\" class=\"data row6 col2\" >11132 (99.8%)</td>\n",
" <td id=\"T_0003e_row6_col3\" class=\"data row6 col3\" >9501 (85.3%)</td>\n",
" <td id=\"T_0003e_row6_col4\" class=\"data row6 col4\" >11132 (99.8%)</td>\n",
" <td id=\"T_0003e_row6_col5\" class=\"data row6 col5\" >5748 (51.6%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row7_col0\" class=\"data row7 col0\" >FENLAND</td>\n",
" <td id=\"T_0003e_row7_col1\" class=\"data row7 col1\" >12071</td>\n",
" <td id=\"T_0003e_row7_col2\" class=\"data row7 col2\" ></td>\n",
" <td id=\"T_0003e_row7_col3\" class=\"data row7 col3\" ></td>\n",
" <td id=\"T_0003e_row7_col4\" class=\"data row7 col4\" ></td>\n",
" <td id=\"T_0003e_row7_col5\" class=\"data row7 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row8_col0\" class=\"data row8 col0\" >GENSCOT</td>\n",
" <td id=\"T_0003e_row8_col1\" class=\"data row8 col1\" >22378</td>\n",
" <td id=\"T_0003e_row8_col2\" class=\"data row8 col2\" ></td>\n",
" <td id=\"T_0003e_row8_col3\" class=\"data row8 col3\" ></td>\n",
" <td id=\"T_0003e_row8_col4\" class=\"data row8 col4\" ></td>\n",
" <td id=\"T_0003e_row8_col5\" class=\"data row8 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row9_col0\" class=\"data row9 col0\" >GLAD</td>\n",
" <td id=\"T_0003e_row9_col1\" class=\"data row9 col1\" >82950</td>\n",
" <td id=\"T_0003e_row9_col2\" class=\"data row9 col2\" >82880 (99.9%)</td>\n",
" <td id=\"T_0003e_row9_col3\" class=\"data row9 col3\" >69004 (83.3%)</td>\n",
" <td id=\"T_0003e_row9_col4\" class=\"data row9 col4\" >82880 (99.9%)</td>\n",
" <td id=\"T_0003e_row9_col5\" class=\"data row9 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row10_col0\" class=\"data row10 col0\" >MCS</td>\n",
" <td id=\"T_0003e_row10_col1\" class=\"data row10 col1\" >35091</td>\n",
" <td id=\"T_0003e_row10_col2\" class=\"data row10 col2\" ></td>\n",
" <td id=\"T_0003e_row10_col3\" class=\"data row10 col3\" ></td>\n",
" <td id=\"T_0003e_row10_col4\" class=\"data row10 col4\" ></td>\n",
" <td id=\"T_0003e_row10_col5\" class=\"data row10 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row11_col0\" class=\"data row11 col0\" >NCDS58</td>\n",
" <td id=\"T_0003e_row11_col1\" class=\"data row11 col1\" >9670</td>\n",
" <td id=\"T_0003e_row11_col2\" class=\"data row11 col2\" ></td>\n",
" <td id=\"T_0003e_row11_col3\" class=\"data row11 col3\" ></td>\n",
" <td id=\"T_0003e_row11_col4\" class=\"data row11 col4\" ></td>\n",
" <td id=\"T_0003e_row11_col5\" class=\"data row11 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row12_col0\" class=\"data row12 col0\" >NEXTSTEP</td>\n",
" <td id=\"T_0003e_row12_col1\" class=\"data row12 col1\" >7451</td>\n",
" <td id=\"T_0003e_row12_col2\" class=\"data row12 col2\" ></td>\n",
" <td id=\"T_0003e_row12_col3\" class=\"data row12 col3\" ></td>\n",
" <td id=\"T_0003e_row12_col4\" class=\"data row12 col4\" ></td>\n",
" <td id=\"T_0003e_row12_col5\" class=\"data row12 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row13_col0\" class=\"data row13 col0\" >NICOLA</td>\n",
" <td id=\"T_0003e_row13_col1\" class=\"data row13 col1\" >5247</td>\n",
" <td id=\"T_0003e_row13_col2\" class=\"data row13 col2\" ></td>\n",
" <td id=\"T_0003e_row13_col3\" class=\"data row13 col3\" ></td>\n",
" <td id=\"T_0003e_row13_col4\" class=\"data row13 col4\" ></td>\n",
" <td id=\"T_0003e_row13_col5\" class=\"data row13 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row14_col0\" class=\"data row14 col0\" >NIHRBIO_COPING</td>\n",
" <td id=\"T_0003e_row14_col1\" class=\"data row14 col1\" >17150</td>\n",
" <td id=\"T_0003e_row14_col2\" class=\"data row14 col2\" >17150 (100.0%)</td>\n",
" <td id=\"T_0003e_row14_col3\" class=\"data row14 col3\" >16778 (97.8%)</td>\n",
" <td id=\"T_0003e_row14_col4\" class=\"data row14 col4\" >17150 (100.0%)</td>\n",
" <td id=\"T_0003e_row14_col5\" class=\"data row14 col5\" >7939 (46.3%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row15_col0\" class=\"data row15 col0\" >NSHD46</td>\n",
" <td id=\"T_0003e_row15_col1\" class=\"data row15 col1\" >4289</td>\n",
" <td id=\"T_0003e_row15_col2\" class=\"data row15 col2\" >2213 (51.6%)</td>\n",
" <td id=\"T_0003e_row15_col3\" class=\"data row15 col3\" >2180 (98.5%)</td>\n",
" <td id=\"T_0003e_row15_col4\" class=\"data row15 col4\" >2213 (51.6%)</td>\n",
" <td id=\"T_0003e_row15_col5\" class=\"data row15 col5\" >2105 (95.1%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row16_col0\" class=\"data row16 col0\" >SABRE</td>\n",
" <td id=\"T_0003e_row16_col1\" class=\"data row16 col1\" >4719</td>\n",
" <td id=\"T_0003e_row16_col2\" class=\"data row16 col2\" >1009 (21.4%)</td>\n",
" <td id=\"T_0003e_row16_col3\" class=\"data row16 col3\" ></td>\n",
" <td id=\"T_0003e_row16_col4\" class=\"data row16 col4\" >1009 (21.4%)</td>\n",
" <td id=\"T_0003e_row16_col5\" class=\"data row16 col5\" >998 (98.9%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row17_col0\" class=\"data row17 col0\" >TEDS</td>\n",
" <td id=\"T_0003e_row17_col1\" class=\"data row17 col1\" >11186</td>\n",
" <td id=\"T_0003e_row17_col2\" class=\"data row17 col2\" >563 (5.0%)</td>\n",
" <td id=\"T_0003e_row17_col3\" class=\"data row17 col3\" >374 (66.4%)</td>\n",
" <td id=\"T_0003e_row17_col4\" class=\"data row17 col4\" >563 (5.0%)</td>\n",
" <td id=\"T_0003e_row17_col5\" class=\"data row17 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row18_col0\" class=\"data row18 col0\" >TRACKC19</td>\n",
" <td id=\"T_0003e_row18_col1\" class=\"data row18 col1\" >19633</td>\n",
" <td id=\"T_0003e_row18_col2\" class=\"data row18 col2\" ></td>\n",
" <td id=\"T_0003e_row18_col3\" class=\"data row18 col3\" ></td>\n",
" <td id=\"T_0003e_row18_col4\" class=\"data row18 col4\" ></td>\n",
" <td id=\"T_0003e_row18_col5\" class=\"data row18 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row19_col0\" class=\"data row19 col0\" >TWINSUK</td>\n",
" <td id=\"T_0003e_row19_col1\" class=\"data row19 col1\" >16618</td>\n",
" <td id=\"T_0003e_row19_col2\" class=\"data row19 col2\" >16618 (100.0%)</td>\n",
" <td id=\"T_0003e_row19_col3\" class=\"data row19 col3\" >14094 (84.8%)</td>\n",
" <td id=\"T_0003e_row19_col4\" class=\"data row19 col4\" >16326 (98.2%)</td>\n",
" <td id=\"T_0003e_row19_col5\" class=\"data row19 col5\" >8188 (50.2%)</td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row20_col0\" class=\"data row20 col0\" >UKHLS</td>\n",
" <td id=\"T_0003e_row20_col1\" class=\"data row20 col1\" >166816</td>\n",
" <td id=\"T_0003e_row20_col2\" class=\"data row20 col2\" ></td>\n",
" <td id=\"T_0003e_row20_col3\" class=\"data row20 col3\" ></td>\n",
" <td id=\"T_0003e_row20_col4\" class=\"data row20 col4\" ></td>\n",
" <td id=\"T_0003e_row20_col5\" class=\"data row20 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row21_col0\" class=\"data row21 col0\" >UKREACH</td>\n",
" <td id=\"T_0003e_row21_col1\" class=\"data row21 col1\" >21583</td>\n",
" <td id=\"T_0003e_row21_col2\" class=\"data row21 col2\" >21583 (100.0%)</td>\n",
" <td id=\"T_0003e_row21_col3\" class=\"data row21 col3\" ></td>\n",
" <td id=\"T_0003e_row21_col4\" class=\"data row21 col4\" ></td>\n",
" <td id=\"T_0003e_row21_col5\" class=\"data row21 col5\" ></td>\n",
" </tr>\n",
" <tr>\n",
" <td id=\"T_0003e_row22_col0\" class=\"data row22 col0\" >Total</td>\n",
" <td id=\"T_0003e_row22_col1\" class=\"data row22 col1\" >570060</td>\n",
" <td id=\"T_0003e_row22_col2\" class=\"data row22 col2\" >241035 (42.3%)</td>\n",
" <td id=\"T_0003e_row22_col3\" class=\"data row22 col3\" >146632 (60.8%)</td>\n",
" <td id=\"T_0003e_row22_col4\" class=\"data row22 col4\" >219160 (38.4%)</td>\n",
" <td id=\"T_0003e_row22_col5\" class=\"data row22 col5\" >56112 (25.6%)</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n"
],
"text/plain": [
"<pandas.io.formats.style.Styler at 0x174a03051f0>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"table3 = display(frehelp.style_table(frehelp.get_table('table3')))"
]
},
{
"cell_type": "markdown",
"id": "4ea4c0e0",
"metadata": {},
"source": [
"***Footnotes***\n",
"\n",
"Linkage to neighbourhood is reliant and calculated from linkage to NHS England where LSOA is available. Therefore studies and participants who do not have permission or have not yet been linked to NHS England data will have no linkage to neighbourhood geographies.\n",
"\n",
"Postcode and address level linkage updates are annual, so there may be a lag between participants being provided to the UK LLC and linkage being established. Where a study has recently set permissions to enable linkage or have just joined UK LLC the linkage rate will appear missing and will be filled at a later freeze date."
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.9.15"
}
},
"nbformat": 4,
"nbformat_minor": 5
}