Cause of death data from National Records Scotland (NRS, formerly General Registrar Office (GRO) and contains data relating to the causes of death of patients.

All registrations to the National Records of Scotland of deaths

Cause of death data from National Records Scotland (NRS, formerly General Registrar Office (GRO) including ICD-9/ICD-10 codes. Cause of death records are subject to change potentially long after the date of death.

This data can be used to identify causes of death. As this data does not originate from the health service, it is not originally CHI seeded. From approx. 2015 onwards, the data was supplied with CHI number, though only covering around 95% of the data. Prior to 2015, and for those records supplied with no CHI an automated mechanism which identifies over 90% of the records is used to CHI seed. This is further augmented by manual data entry.

Due to these procedures, this dataset does not necessarily represent all deceased persons.

Nationally curated data for Scotland showing the date and cause(s) of death.

National Records of Scotland Guidance;What is ‘period’ life expectancyAll of the estimates presented in this report are ‘period’ life expectancy. They are calculated assuming that mortality rates for each age group in the time period (here 2021-2023) are constant throughout a person’s life. Period life expectancy is often described as how long a baby born now could expect to live if they experienced today’s mortality rates throughout their lifetime. It is very unlikely that this would be the case as it means that future changes in things such as medicine and legislation are not taken into consideration.Period life expectancy is not an accurate prediction of how long a person born today will actually live, but it is a useful measure of population health at a point in time and is most useful for comparing trends over time, between areas of a country and with other countries.How national life expectancy is calculatedThe latest life expectancy figures are calculated from the mid-year population estimates for Scotland and the number of deaths registered in Scotland during 2021, 2022, and 2023. Life expectancy for Scotland is calculated for each year of age and represents the average number of years that someone of that age could expect to live if death rates for each age group remained constant over their lifetime. Life expectancy in Scotland is calculated as a three-year average, produced by combining deaths and population data for the three-year period. Three years of data are needed to provide large enough numbers to make these figures accurate and lessen the effect of very ‘good’ or ‘bad’ years. Throughout this publication, the latest life expectancy figures refer to 2021-2023 period. How sub-national life expectancy is calculatedWe calculate life expectancy for areas within Scotland using a very similar method to the national figures but with a few key differences. Firstly, we use age groups rather than single year of age. This is to increase the population size of each age group to reduce fluctuations and ensure accurate calculation of mortality rates. Secondly, we use a maximum age group of 90+ whereas the national figures are calculated up to age 100. These are known as ‘abridged life tables.’ Because these methods produce slightly different figures, we also calculate a Scotland figure using the abridged method to allow for accurate comparisons between local areas for example. This Scotland figure is only for comparison and does not replace the headline national figure. You can read more information about the methods in this publication in our methodology guide on the NRS website. Uses of life expectancyLife expectancy at birth is a very useful indicator of mortality conditions across a population at a particular point in time. It also provides an objective means of comparing trends in mortality over time, between areas of a country and with other countries. This is used to monitor and investigate health inequalities and to set public health targets. Life expectancy is also used to inform pensions policy, research and teaching.

This is a subset of National Records of Scotland (NRS) - Deaths dataset for use in the Brain Health Data Pilot (BHDP) project.

The Brain Health Data Pilot (BHDP) project aims to be a shared database (like a library) of information for scientists studying brain health, especially for diseases like dementia, which affects about 900,000 people in the UK. Its main feature is a huge collection of brain images linked to routinely collected health records, both from NHS Scotland, which will help scientists learn more about dementia and other brain diseases. What is special about this database is that it will get better over time – as scientists use it and add their discoveries, it becomes more valuable.

Background information and/or commentary, tables and/or charts for each of the following: Accidental deaths, Alcohol-related deaths, Clostridium Difficile deaths, Hypothermia deaths, MRSA deaths, Probable suicides, and Age-Standardised death rates (calculated using the European Standard Population) overall and from a number of specific causes

Source agency: National Records of Scotland

Designation: National Statistics

Language: English

Alternative title: Deaths - various causes

Provisional weekly births and deaths registration data for Scotland.

Source agency: National Records of Scotland

Designation: National Statistics

Language: English

Alternative title: Weekly Births and Deaths

Note on the data sets: 1) There will be initial issues with encoding so I used Chardet to fix this. Please use the below code in your notebooks:

import chardet # to help with encoding import numpy as np # linear algebra import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import os for dirname, _, filenames in os.walk('/kaggle/input'): for filename in filenames: print(os.path.join(dirname, filename))

with open('../input/drugrelated-deaths-in-scotland/drug-related-deaths-20-tabs-figs_1 - summary.csv', 'rb') as f: enc = chardet.detect(f.read()) opioid_data = pd.read_csv('../input/drugrelated-deaths-in-scotland/drug-related-deaths-20-tabs-figs_1 - summary.csv', encoding = enc['encoding'])

opioid_data.head(20)

2) There will need to be data cleaning due to the empty spaces in the data file. Running .head(20) will show this

The opioid epidemic is an international phenomenon. It began in the United States but has spread to other countries with similarly devastating effect. Here we have the drug-related deaths in Scotland, from the National Records of Scotland.

Here is the main data source https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/vital-events/deaths/drug-related-deaths-in-scotland/2020

Here is the news release on the drug-related deaths in 2020 with a 5% increase from 2019. Several key findings: - The number of drug-related deaths has increased substantially over the last 20 years – there were 4½ times as many deaths in 2020 compared with 2000. - Men were 2.7 times as likely to have a drug-related death than women, after adjusting for age. - After adjusting for age, people in the most deprived parts of the country were 18 times as likely to die from a drug-related death as those in the least deprived. - Scotland’s drug-death rate continues to be over 3½ times that for the UK as a whole, and higher than that of any European country. https://www.nrscotland.gov.uk/news/2021/drug-related-deaths-rise

These are similar patterns to what we see in the United States, with a rapid increase in the death rate over the past several decades, and hitting already struggling communities particularly hard.

Here are the key reports and analyses put out by the National Records of Scotland: - https://www.nrscotland.gov.uk/files//statistics/drug-related-deaths/20/drug-related-deaths-20-additional-analyses.pdf I'll highlight here: "one or more opiates or opioids (including heroin/morphine, methadone, codeine and dihydrocodeine) were implicated in 1, 192 drug-related deaths (89%)". So although Scotland's data set groups together all drug-related deaths, it is opioids in particular that are driving it. - and with graphs: https://www.nrscotland.gov.uk/files//statistics/drug-related-deaths/20/drug-related-deaths-20-pub.pdf

I previously published data sets on Opioids in the United States and Canada: https://www.kaggle.com/datasets/craigchilvers/opioids-vssr-provisional-drug-overdose-statistics https://www.kaggle.com/datasets/craigchilvers/opioids-in-the-us-cdc-drug-overdose-deaths https://www.kaggle.com/datasets/craigchilvers/opioids-in-the-us-cdc-nonfatal-overdoses https://www.kaggle.com/datasets/craigchilvers/opioids-in-canada

Monthly analysis of deaths registered in Scotland, including breakdowns by cause of death, age group, sex, location and SIMD. Includes number of deaths, age-standardised rates and excess deaths. Tables

The difference between the number of deaths in the four-month 'winter' period and the average of the previous and subsequent four-month periods.

Source agency: National Records of Scotland

Designation: National Statistics

Language: English

Alternative title: Winter Mortality in Scotland

Provisional data on deaths by month and NHS Board area. Source agency: National Records of Scotland Designation: National Statistics Language: English Alternative title: Monthly Deaths

This publication was previously named “Deaths involving coronavirus (COVID-19) in Scotland”. It has been renamed to better reflect the fact that it includes data on all deaths, plus breakdowns for some key causes. A breakdown of deaths involving coronavirus is still included in this publication. Key points in this week’s update The provisional total number of deaths registered in Scotland in week 47 of 2023 (20th November to 26th November) was 1,232 (28 or 2% above the 5-year average). There were 36 deaths mentioning COVID-19. By underlying cause, this number can be broken down as: Archive

This section provides information on the surnames that occur most often in Scotland’s registers of Births, Marriages and Deaths for various years back to 1975. Available via the "List of Data Tables" link are a separate list for each of the years concerned, and a Comma Separated Value (CSV) file which contains summary records which cover all the years for which those lists have been produced. Some other information about surnames in Scotland is available from an Occasional Paper which was published in 2003.

The difference between the number of deaths in the four-month 'winter' period and the average of the previous and subsequent four-month periods.

Source agency: National Records of Scotland

Designation: National Statistics

Language: English

Alternative title: Increased Winter Mortality

This section presents information on the numbers of deaths for which Meticillin-Resistant Staphylococcus Aureus (MRSA) was mentioned on the death certificate.

Numbers of deaths registered by cause.

Tables containing the number of vital events for the calendar year in eight sections: Summary; Adoptions and re-registrations; Births; Stillbirths and infant deaths; Deaths; Deaths by cause; Marriages; and Divorces, Civil Partnerships and Dissolutions of Civil Partnerships.

Source agency: National Records of Scotland

Designation: National Statistics

Language: English

Alternative title: Vital Events