Civil Registrations of Death (MORTALITY) Dataset

Civil Registrations of Death (MORTALITY) 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("MORTALITY")
      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'
Registered deaths in England and Wales.

1. Summary#

The Civil Registrations of Death dataset is collected by the Office for National Statistics (ONS). It includes demographic details about the deceased, including occupation, sex, address, date and place of birth, marital status, date of death and place of death. If applicable, it also includes details about the deceased’s spouse.

Dataset Descriptor Dataset-specific Information
Name of Dataset in TRE NHSE_MORTALITY
Citation (APA) Data Services, NHS England (NHSE). (2024). NHS England: Civil Registration of Deaths Dataset - Dated 23 May 2024. UK Longitudinal Linkage Collaboration (UK LLC). https://doi.org/10.83126/ukllc-dataset-00041-02
Download Citation Citeproc JSON     BibTeX     RIS
Series NHS England
Owner Office for National Statistics
Temporal Coverage in the TRE 01/1993 - ongoing
Geographical Coverage England and Wales
Participant Count 7841
Number of Variables 102
Number of Observations 9926
Key Link https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths
Keywords Deaths
Latest Extract Date 2024-05-23
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 MORTALITY 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 2 1 1 1 2 2 2
Name in TRE NHSE_MORTALITY_20220106 NHSE_MORTALITY_20220106 NHSE_MORTALITY_20220302 NHSE_MORTALITY_20220302 NHSE_MORTALITY_20220715 NHSE_MORTALITY_20220716 NHSE_MORTALITY_20230302 NHSE_MORTALITY_20240424 NHSE_MORTALITY_20240523
Version Date 06 Jan 2022 06 Jan 2022 02 Mar 2022 02 Mar 2022 15 Jul 2022 16 Jul 2022 02 Mar 2023 24 Apr 2024 23 May 2024
Number of Variables 102 102 102 102 102 102 102 102 102
Number of Rows 5414 5414 5673 5673 216 5889 7841 9797 9926
DOI 10.83126/ukllc-dataset-00043-01 10.83126/ukllc-dataset-00043-02 10.83126/ukllc-dataset-00044-02 10.83126/ukllc-dataset-00044-01 10.83126/ukllc-dataset-00045-01 10.83126/ukllc-dataset-00046-01 10.83126/ukllc-dataset-00047-02 10.83126/ukllc-dataset-00042-02 10.83126/ukllc-dataset-00041-02

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.

Contents