HES Admitted Patient Care (HESAPC) Dataset

HES Admitted Patient Care (HESAPC) 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("HESAPC")
      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'
People admitted for treatment at NHS hospitals in England.
More information about this dataset is available here.

1. Summary#

Data are collected about all inpatient admissions to hospitals in England. The dataset includes information on the treatment and outcome of the hospital admission. Data collected include demographics, date and source of admission, waiting time, reason for admission, clinical diagnosis and procedures performed, and date and destination of discharge. HESAPC encompasses the Maternity dataset (HESAPC_MAT), the Critical Care minimum dataset (HESCC) and the retired Augmented Care Periods dataset (HESAPC_ACP).

Dataset Descriptor Dataset-specific Information
Name of Dataset in TRE NHSE_HESAPC
Citation (APA) Data Services, NHS England (NHSE). (2024). NHS England: Hospital Episode Statistics (HES) Admitted Patient Care (APC) Dataset. UK Longitudinal Linkage Collaboration (UK LLC). https://doi.org/10.83126/ukllc-dataset-00036-03
Download Citation Citeproc JSON     BibTeX     RIS
Series NHS England
Owner NHS England
Temporal Coverage in the TRE 04/1998 - ongoing
Geographical Coverage England
Participant Count 209624
Number of Variables 170
Number of Observations 1827017
Key Link https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics
Keywords Inpatients, 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#

Click on the plus sign to see the number of participants represented in each dataset.

Table 2: Participants from each LPS represented in the HESAPC dataset in the UK LLC TRE. Note: Individual cohort counts of less than 10 are suppressed to 0 and are therefore excluded from total participant counts for datasets

3. Version History#

Version Number 1 2 3
Name in TRE NHSE_HESAPC NHSE_HESAPC NHSE_HESAPC
Version Date 21 Dec 2022 13 Apr 2023 26 Apr 2024
Number of Variables 170 170 170
Number of Rows 1270336 1543419 1827017
DOI 10.83126/ukllc-dataset-00036-01 10.83126/ukllc-dataset-00036-02 10.83126/ukllc-dataset-00036-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.

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 the UK LLC GitHub repository where you can find the full scripts.