Civil Registrations of Deaths (MORTALITY) 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 = 'MORTALITY'
version = 'v0002'
# 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.MORTALITY*"))
display(Markdown("**Short abstract:** "+dataset['datasetfields']['abstract']))
display(Markdown("***Extended abstract***: *The Civil Registrations of Death dataset is collected by the [Office for National Statistics](https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths). It is a legal requirement to report a death to a register office within five days. The informant provides demographic details to the registrar about the deceased, including occupation, sex, usual address, date and place of birth, marital status, date of death and place of death. If applicable, the informant also provides details about the deceased's spouse. If the deceased was a child, the full names and occupations of the parents are required. The informant usually also gives the Medical Certificate of Cause of Death (MCCD) to the registrar, which is a form completed by a medical practitioner when a death is certified. The MCCD includes information such as whether the body was seen after death, cause of death, when the deceased was last seen alive and whether a post-mortem was carried out. In instances where deaths are referred to and sometimes then investigated by a coroner, the coroner sends information to the registrar and this is used instead of the MCCD. The dataset includes details of all registered deaths in England and Wales since 1993. For further information see the [ONS Guide to Mortality Statistics.](https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/methodologies/userguidetomortalitystatisticsjuly2017#information-collected-at-death-registration)*"))
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/01/1993 onwards*"))
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***: *Demographic characteristics and details of deaths.*"))
display(Markdown("***Structure of dataset***: *Each death is represented by a distinct row of data.*"))
display(Markdown("***Update frequency in UK LLC TRE***: *Quarterly*"))
display(Markdown("***Dataset versions in UK LLC TRE***: *TBC*"))
display(Markdown("***Data quality issues***: *It is a legal requirement for all deaths to be registered and it is an offence for informants to provide knowingly false information. This means that civil registrations of death data provide the most complete information source for mortality statistics. The Registration Online System (RON) used by registrars conducts automatic checks. Most deaths (around 80%) have the underlying cause of death coded automatically; the remainder are coded manually by experienced coders. ICD-10 codes for cause of death replaced ICD-9 codes on 01/01/2001 and this may affect the interpretation of trends. For further details see section 12 of the [ONS Guide to Mortality Statistics,](https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/methodologies/userguidetomortalitystatisticsjuly2017#information-collected-at-death-registration) includes links to [Quality and Methodology Information Reports](https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/methodologies/mortalitystatisticsinenglandandwalesqmi).*"))
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://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths](https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths)*"))
NHS England title of dataset: Civil Registration - Deaths
Dataset name in UK LLC TRE: nhsd.MORTALITY
Short abstract: Deaths registration data (all deaths in England and Wales) collected from The Registrar General for England and Wales. Record-level person data set, where a record represents one death registration.
Extended abstract: The Civil Registrations of Death dataset is collected by the Office for National Statistics. It is a legal requirement to report a death to a register office within five days. The informant provides demographic details to the registrar about the deceased, including occupation, sex, usual address, date and place of birth, marital status, date of death and place of death. If applicable, the informant also provides details about the deceased’s spouse. If the deceased was a child, the full names and occupations of the parents are required. The informant usually also gives the Medical Certificate of Cause of Death (MCCD) to the registrar, which is a form completed by a medical practitioner when a death is certified. The MCCD includes information such as whether the body was seen after death, cause of death, when the deceased was last seen alive and whether a post-mortem was carried out. In instances where deaths are referred to and sometimes then investigated by a coroner, the coroner sends information to the registrar and this is used instead of the MCCD. The dataset includes details of all registered deaths in England and Wales since 1993. For further information see the ONS Guide to Mortality Statistics.
Geographical coverage: United Kingdom,England
Temporal coverage: 01/01/1993
Data available in UK LLC TRE from: 01/01/1993 onwards
Typical age range: 0-150
Collection situation: OTHER
Purpose: ADMINISTRATIVE
Source: OTHER
Pathway: NOT APPLICABLE
Information collected: Demographic characteristics and details of deaths.
Structure of dataset: Each death is represented by a distinct row of data.
Update frequency in UK LLC TRE: Quarterly
Dataset versions in UK LLC TRE: TBC
Data quality issues: It is a legal requirement for all deaths to be registered and it is an offence for informants to provide knowingly false information. This means that civil registrations of death data provide the most complete information source for mortality statistics. The Registration Online System (RON) used by registrars conducts automatic checks. Most deaths (around 80%) have the underlying cause of death coded automatically; the remainder are coded manually by experienced coders. ICD-10 codes for cause of death replaced ICD-9 codes on 01/01/2001 and this may affect the interpretation of trends. For further details see section 12 of the ONS Guide to Mortality Statistics, includes links to Quality and Methodology Information Reports.
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://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths
2. Metrics#
The tables below summarise the MORTALITY dataset in the UK LLC TRE.
Table 1 The number of participants from each LPS that are represented in the MORTALITY 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 │ 12 │
├────────────────┼─────────┤
│ BCS70 │ 122 │
├────────────────┼─────────┤
│ BIB │ 235 │
├────────────────┼─────────┤
│ ELSA │ 870 │
├────────────────┼─────────┤
│ EPICN │ 3618 │
├────────────────┼─────────┤
│ EXCEED │ 240 │
├────────────────┼─────────┤
│ FENLAND │ 183 │
├────────────────┼─────────┤
│ GLAD │ 549 │
├────────────────┼─────────┤
│ MCS │ 354 │
├────────────────┼─────────┤
│ NCDS58 │ 469 │
├────────────────┼─────────┤
│ NEXTSTEP │ 17 │
├────────────────┼─────────┤
│ NIHRBIO_COPING │ 199 │
├────────────────┼─────────┤
│ NSHD46 │ 990 │
├────────────────┼─────────┤
│ TEDS │ <10 │
├────────────────┼─────────┤
│ TRACKC19 │ 97 │
├────────────────┼─────────┤
│ TWINSUK │ 1821 │
├────────────────┼─────────┤
│ UKHLS │ 141 │
├────────────────┼─────────┤
│ total │ 9917 │
╘════════════════╧═════════╛
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.