1. Summary#

The NHS England patient demo mortality dataset, formerly known as the indicator dataset contains the most recent and reliable record for certain key demographic variables sourced from NHS England datasets for each participant. Each project in the TRE is automatically provisioned a file named ‘UKLLC_nhse_patient_demo_mortality_v0000_YYYYMMDD’ (formerly known as ‘CORE_derived_indicator_v0000_YYYYMMDD’).

The dataset includes all NHS England linked participants who have permissions from the LPS selected and approved as part of your project. Sex, ethnicity (ethnic: NHS England ethncity coding system - see values table for coding lookup) and date of birth (dob_year_month: year and month of birth) are obtained from the following five datasets in the order presented (i.e. if the information isn’t available in the Demographics dataset, the GDPPR dataset is then searched etc.):

1. Demographics.

2. General Practice Extraction Service (GPES) Data for Pandemic Planning and Research (GDPPR).

3. HES Admitted Patient Care (HESAPC).

4. HES Outpatients (HESOP).

5. HES Accident & Emergency (HESAE).

The following variables are then added:

• Deceased: from the Mortality dataset

• Date of death: from the Mortality dataset

• last_seen_date: last date recorded in any NHS England dataset (patient_service_usage).

The dataset enables researchers to:

• ascertain whether a participant is alive or dead and, if applicable, see their recorded date of death

• quickly retrieve basic demographic information such as sex, ethnicity and age (via date of birth)

• see the date when a participant last used an NHS England service

• easily filter/group demographic data to be integrated into analytical pipelines.

2. Variables#

3. Version History#

4. Useful Syntax#