HES Outpatients (HESOP) Dataset

HES Outpatients (HESOP) Dataset#

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
Cell In[1], line 5
      3 sys.path.append(os.path.abspath('../../../../scripts/'))
      4 from data_doc_helper import NHSEDataSet as DS, last_modified
----> 5 ds = DS("HESOP")
      6 last_modified()

File /opt/build/repo/ukllc_book/docs/scripts/data_doc_helper.py:1048, in NHSEDataSet.__init__(self, dataset)
   1046 # define std input variables
   1047 self.dataset = dataset
-> 1048 self.df_ds = get_nhse_ds(self.dataset)
   1049 self.doi = ds_doi(self.df_ds.iloc[0]["table"])
   1050 self.ed = get_ed(self.dataset)

File /opt/build/repo/ukllc_book/docs/scripts/data_doc_helper.py:879, in NHSEDataSet.__init__.<locals>.get_nhse_ds(x)
    869 """Returns DF of dataset info/metrics
    870 
    871 Args:
   (...)    875     DF: dataframe of dataset info/metrics
    876 """
    878 ds = md.get_md_api_dss()
--> 879 df_ds = ds[(ds["source"] == "NHSE") & (ds["table"] == x)]
    880 df_ds["source_table"] = df_ds["source"] + "_" + df_ds["table"]
    881 # ss = md.get_md_api_ss()[["source", "Owner"]]
    882 # df_ds = df_ds.merge(ss, on="source")

TypeError: string indices must be integers, not 'str'
Outpatient appointments at NHS hospitals in England.

1. Summary#

Data are collected about all outpatient appointments at NHS hospitals in England. Data collected include demographics, date and type of consultation, treatment specialty, referral source and waiting time, clinical diagnosis and procedures performed.

Dataset Descriptor Dataset-specific Information
Name of Dataset in TRE NHSE_HESOP
Citation (APA) Data Services, NHS England (NHSE) . (2024). NHS England: Hospital Episode Statistics (HES) Outpatients Dataset. UK Longitudinal Linkage Collaboration (UK LLC). https://doi.org/10.83126/ukllc-dataset-00038-03
Download Citation Citeproc JSON     BibTeX     RIS
Series NHS England
Owner NHS England, Office for National Statistics and Department of Health and Social Care
Temporal Coverage in the TRE 04/2003 - ongoing
Geographical Coverage England
Participant Count 202907
Number of Variables 149
Number of Observations 8575150
Key Link https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics
Keywords Outpatients, NHS hospitals
Latest Extract Date 2024-04-26
Specific Restrictions to Data Use None
Build a Data Request https://explore.ukllc.ac.uk/

2. Metrics#

Cohort counts for the HESOP dataset will be issued in due course.

3. Version History#

Version Number 1 2 3
Name in TRE NHSE_HESOP NHSE_HESOP NHSE_HESOP
Version Date 21 Dec 2022 13 Apr 2023 26 Apr 2024
Number of Variables 149 149 149
Number of Rows 6418599 8013593 8575150
DOI 10.83126/ukllc-dataset-00038-01 10.83126/ukllc-dataset-00038-02 10.83126/ukllc-dataset-00038-03

4. Documentation#

We are currently building a documentation storage system, which will host relevant and useful documents related to datasets, groupings, and studies themselves. Relevant documentation for this particular dataset will go here.

5. Useful 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

Contents