HES Outpatients (HESOP) Dataset

HES Outpatients (HESOP) Dataset#

# define target dataset to document
schema = 'nhsd'
table = 'HESOP'
version = 'v0003'
# import functions from script helper
import sys
script_fp = "../../../../scripts/"
sys.path.insert(0, script_fp)
from data_doc_helper import DocHelper
# create instance
document = DocHelper(schema, table, version, script_fp)
# markdown/code hybrid cell module requirement
from IPython.display import display, Markdown

1. Summary#

display(document.style_table(document.get_dataset_info()))
Dataset descriptor Dataset-specific information
Name of dataset in TRE HESOP
Other name None
Keywords Outpatients, NHS hospitals
Short description Dataset of outpatient appointments in English NHS hospitals and NHS England commissioned outpatient appointments in the independent sector. Each appointment is represented by a distinct row of data.
Owner NHS England
Geographical coverage England
Temporal coverage 01/04/2003 onwards
TRE temporal coverage 01/04/2003 onwards
Frequency of update Quarterly
Date of last extract None
DOI None
Data resolution Outpatient appointment
Number of variables None
Number of participants None
Number of observations None
Version None
Key link https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics
Specific restrictions to data use None

2. Metrics#

The tables below summarise the HESOP dataset in the UK LLC TRE.

Table 1 The number of participants from each LPS that are represented in the HESOP dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)

display(document.style_table(document.get_cohort_count()))
LPS Participant count
ALSPAC 5692
BCS70 5710
BIB 26135
ELSA 6962
EPICN 14697
EXCEED 9159
FENLAND 10058
GLAD 50833
MCS 17107
NCDS58 6184
NEXTSTEP 4615
NIHRBIO_COPING 16081
NSHD46 2870
TEDS 2276
TRACKC19 13284
TWINSUK 12607
UKHLS 6624
TOTAL 210894

3. Helpful syntax#

Below we will include syntax that may be helpful to other researchers in the UK LLC TRE. For longer scripts, we will include a snippet of the code plus a link to Git where you can find the full script.