HES Critical Care (HESCC) Dataset#
1. Summary#
The information below is retrieved from the Health Data Gateway API developed by NHS England, with additional fields added by UK LLC (indicated by italics).
# define target dataset to document
schema = 'nhsd'
table = 'HESCC'
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
# get api data
dataset = document.get_api_data()
display(Markdown("**NHS England title of dataset:** "+dataset['datasetfields']['datautility']['title']))
display(Markdown("***Dataset name in UK LLC TRE***: *nhsd.HESCC*"))
display(Markdown("***Parent dataset***: *HESAPC*"))
display(Markdown("**Short abstract:** "+dataset['datasetfields']['abstract']))
display(Markdown("***Extended abstract:*** [*https://web.www.healthdatagateway.org/dataset/d0eeba22-bc3f-4c40-be69-a99f916897a2*](https://web.www.healthdatagateway.org/dataset/d0eeba22-bc3f-4c40-be69-a99f916897a2)"))
display(Markdown("**Geographical coverage:** "+dataset['datasetfields']['geographicCoverage'][0]))
display(Markdown("**Temporal coverage:** "+dataset['datasetfields']['datasetStartDate']))
display(Markdown("***Data available in UK LLC TRE from***: *01/04/2008 onwards from adult units; 01/04/2017 onwards from neonatal and paediatric units*"))
display(Markdown("**Typical age range:** "+dataset['datasetfields']['ageBand']))
display(Markdown("**Collection situation:** "+dataset['datasetv2']['provenance']['origin']['collectionSituation'][0]))
display(Markdown("**Purpose:** "+dataset['datasetv2']['provenance']['origin']['purpose'][0]))
display(Markdown("**Source:** "+dataset['datasetv2']['provenance']['origin']['source'][0]))
display(Markdown("**Pathway:** "+dataset['datasetv2']['coverage']['pathway']))
display(Markdown("***Information collected***: *Patient demographics, date and source of admission, waiting time, reason for admission, clinical diagnosis and procedures performed, and date and destination of discharge.*"))
display(Markdown("***Structure of dataset***: *See HESAPC dataset guide*"))
display(Markdown("***Update frequency in UK LLC TRE***: *Quarterly*"))
display(Markdown("***Dataset versions in UK LLC TRE***: *TBC*"))
display(Markdown("***Data quality issues***: *Data quality notes that highlight specific known issues are published alongside the finalised HES datasets: [https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/the-processing-cycle-and-hes-data-quality](https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/the-processing-cycle-and-hes-data-quality)*"))
display(Markdown("***Restrictions to data usage***: *Medical purposes only (medical research) as defined in the NHS Act 2006: [https://www.legislation.gov.uk/ukpga/2006/41/part/13/crossheading/patient-information](https://www.legislation.gov.uk/ukpga/2006/41/part/13/crossheading/patient-information)*"))
display(Markdown("***Further information***: [*https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics*](https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics)"))
NHS England title of dataset: Hospital Episode Statistics Critical Care
Dataset name in UK LLC TRE: nhsd.HESCC
Parent dataset: HESAPC
Short abstract: Record-level patient data set of patients admitted for treatment and receiving Critical Care (intensive care or high dependency care) at NHS hospitals in England. A record represents one episode of Critical Care.
Extended abstract: https://web.www.healthdatagateway.org/dataset/d0eeba22-bc3f-4c40-be69-a99f916897a2
Geographical coverage: United Kingdom,England
Temporal coverage: 2007-04-01
Data available in UK LLC TRE from: 01/04/2008 onwards from adult units; 01/04/2017 onwards from neonatal and paediatric units
Typical age range: 0-120
Collection situation: IN-PATIENTS
Purpose: CARE
Source: EPR
Pathway: Secondary Care pathway. This dataset covers critical care periods for inpatient admissions to hospitals in England. It includes information on the treatment and outcome of the critical care period and can be linked to the HES APC dataset to get further information on the admission relating to the critical care period.
Information collected: Patient demographics, date and source of admission, waiting time, reason for admission, clinical diagnosis and procedures performed, and date and destination of discharge.
Structure of dataset: See HESAPC dataset guide
Update frequency in UK LLC TRE: Quarterly
Dataset versions in UK LLC TRE: TBC
Data quality issues: Data quality notes that highlight specific known issues are published alongside the finalised HES datasets: https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics/the-processing-cycle-and-hes-data-quality
Restrictions to data usage: Medical purposes only (medical research) as defined in the NHS Act 2006: https://www.legislation.gov.uk/ukpga/2006/41/part/13/crossheading/patient-information
Further information: https://digital.nhs.uk/data-and-information/data-tools-and-services/data-services/hospital-episode-statistics
2. Metrics#
The tables below summarise the HESCC dataset in the UK LLC TRE.
Table 1 The number of participants from each LPS that are represented in the HESCC dataset in the UK LLC TRE
(Note: numbers relate to the most recent extract of NHS England data)
gb_cohort = document.get_cohort_count()
print(gb_cohort.to_markdown(index=False, tablefmt="fancy_grid"))
╒════════════════╤═════════╕
│ cohort │ count │
╞════════════════╪═════════╡
│ ALSPAC │ 83 │
├────────────────┼─────────┤
│ BCS70 │ 142 │
├────────────────┼─────────┤
│ BIB │ 314 │
├────────────────┼─────────┤
│ ELSA │ 549 │
├────────────────┼─────────┤
│ EPICN │ 992 │
├────────────────┼─────────┤
│ EXCEED │ 725 │
├────────────────┼─────────┤
│ FENLAND │ 321 │
├────────────────┼─────────┤
│ GLAD │ 2290 │
├────────────────┼─────────┤
│ MCS │ 452 │
├────────────────┼─────────┤
│ NCDS58 │ 367 │
├────────────────┼─────────┤
│ NEXTSTEP │ 83 │
├────────────────┼─────────┤
│ NIHRBIO_COPING │ 715 │
├────────────────┼─────────┤
│ NSHD46 │ 297 │
├────────────────┼─────────┤
│ TEDS │ 80 │
├────────────────┼─────────┤
│ TRACKC19 │ 236 │
├────────────────┼─────────┤
│ TWINSUK │ 686 │
├────────────────┼─────────┤
│ UKHLS │ 248 │
├────────────────┼─────────┤
│ total │ 8580 │
╘════════════════╧═════════╛
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.