Effect of suicide rates on life expectancy dataset

Abstract
In 2015, approximately 55 million people died worldwide, of which 8 million committed suicide. In the USA, one of the main causes of death is the aforementioned suicide, therefore, this experiment is dealing with the question of how much suicide rates affects the statistics of average life expectancy.
The experiment takes two datasets, one with the number of suicides and life expectancy in the second one and combine data into one dataset. Subsequently, I try to find any patterns and correlations among the variables and perform statistical test using simple regression to confirm my assumptions.

Data

The experiment uses two datasets - WHO Suicide Statistics[1] and WHO Life Expectancy[2], which were firstly appropriately preprocessed. The final merged dataset to the experiment has 13 variables, where country and year are used as index: Country, Year, Suicides number, Life expectancy, Adult Mortality, which is probability of dying between 15 and 60 years per 1000 population, Infant deaths, which is number of Infant Deaths per 1000 population, Alcohol, which is alcohol, recorded per capita (15+) consumption, Under-five deaths, which is number of under-five deaths per 1000 population, HIV/AIDS, which is deaths per 1 000 live births HIV/AIDS, GDP, which is Gross Domestic Product per capita, Population, Income composition of resources, which is Human Development Index in terms of income composition of resources, and Schooling, which is number of years of schooling.

LICENSE

THE EXPERIMENT USES TWO DATASET - WHO SUICIDE STATISTICS AND WHO LIFE EXPECTANCY, WHICH WERE COLLEECTED FROM WHO AND UNITED NATIONS WEBSITE. THEREFORE, ALL DATASETS ARE UNDER THE LICENSE ATTRIBUTION-NONCOMMERCIAL-SHAREALIKE 3.0 IGO (https://creativecommons.org/licenses/by-nc-sa/3.0/igo/).

[1] https://www.kaggle.com/szamil/who-suicide-statistics

[2] https://www.kaggle.com/kumarajarshi/life-expectancy-who

This table contains the number of victims of suicide arranged by marital status, method, motives, age and sex. They represent the number deaths by suicide in the resident population of the Netherlands. The figures in this table are equal to the suicide figures in the causes of death statistics, because they are based on the same files. The causes of death statistics do not contain information on the motive of suicide. For the years 1950-1995, this information is obtained from a historical data file on suicides. For the years 1996-now the motive is taken from the external causes of death (Niet-Natuurlijke dood) file. Before the 9th revision of the International Statistical Classification of Diseases and Related Health Problems (ICD), i.e. for the years 1950-1978, it was not possible to code "jumping in front of train/metro". For these years 1950-1978 "jumping in front of train/metro" has been left empty, and it has been counted in the group "other method". Relative figures have been calculated per 100 000 of the corresponding population group. The figures are calculated based on the average population of the corresponding year. Data available from: 1950 Status of the figures: The figures up to and including 2023 are final. Changes as of January 23rd 2025: The figures for 2023 are made final. When will new figures be published: In the third quarter of 2025 the provisional figures for 2024 will be published.

Number of suicides and suicide rates, by sex and age, in England and Wales. Information on conclusion type is provided, along with the proportion of suicides by method and the median registration delay.

Data on death rates for suicide, by selected population characteristics. Please refer to the PDF or Excel version of this table in the HUS 2019 Data Finder (https://www.cdc.gov/nchs/hus/contents2019.htm) for critical information about measures, definitions, and changes over time. SOURCE: NCHS, National Vital Statistics System (NVSS); Grove RD, Hetzel AM. Vital statistics rates in the United States, 1940–1960. National Center for Health Statistics. 1968; numerator data from NVSS annual public-use Mortality Files; denominator data from U.S. Census Bureau national population estimates; and Murphy SL, Xu JQ, Kochanek KD, Arias E, Tejada-Vera B. Deaths: Final data for 2018. National Vital Statistics Reports; vol 69 no 13. Hyattsville, MD: National Center for Health Statistics. 2021. Available from: https://www.cdc.gov/nchs/products/nvsr.htm. For more information on the National Vital Statistics System, see the corresponding Appendix entry at https://www.cdc.gov/nchs/data/hus/hus19-appendix-508.pdf.

The number of deaths recorded as 'suicide' or 'event of undetermined intent' in Northern Ireland, by broad occupation group. In the UK it is standard procedure to include both causes under the heading of suicide.

Context

This dataset contains information on suicides which happened in India during 2015.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F4208638%2Ffab2e99b439f9780daf358511060f514%2FWorld-Suicide-Prevention-Day.jpg?generation=1598114750200382&alt=media" alt="">

The singular age-old social precept of 'Lok Kya Kahenge?' (loosely translated: "What will people say?") suppresses the much-needed psychological care in India. It's high time that we understand why suicides happen and what are the reasons behind it. This dataset aims to spread awareness about suicides in India.

Content

I acquired this dataset from here. Have a look at the website.

This dataset contains 9 files in .csv format. You can find a description for each column. Let me summarize it here as well.

1. Cause-wise distribution of suicides in Central Armed Police Force (CAPF) during 2015.
2. Economic Status-wise distribution of suicides during 2015.
3. Educational Status-wise distribution of suicides during 2015.
4. Farmer or Cultivators distribution of suicides during 2015.
5. Profession-wise distribution of suicides during 2015.
6. Social status-wise distribution of suicides during 2015.
7. Cause-wise distribution of suicides during 2015.
8. Suicides by Agricultural labourers during 2015.
9. Suicides by means adopted during 2015.

Inspiration

We now have plenty of data to explore to draw some conclusions about suicides which happened in India during 2015. Let's start by answering these questions: - What are the top 5 states where Farmers' suicides occurred the most? - What's the top reason that agricultural labourers committed suicide? - Which Profession has the most suicides? What could be the reason? - How many Transgender suicides have occurred in different categories?

I hope these questions interest you in starting to explore this dataset.

Acknowledgements

I thank the Indian Government for making it public under their Open Government Data (OGD) Platform India. Please use this dataset strictly for educational purposes. Thank you.

This data shows deaths (of people age 10 and over) from Suicide and Undetermined Injury, numbers and rates by gender, as 3-year moving-averages. Suicide is a significant cause of premature deaths occurring generally at younger ages than other common causes of premature mortality. It may also be seen as an indicator of underlying rates of mental ill-health. Directly Age-Standardised Rates (DASR) are shown in the data, where numbers are sufficient, so that death rates can be directly compared between areas. The DASR calculation applies Age-specific rates to a Standard (European) population to cancel out possible effects on crude rates due to different age structures among populations, thus enabling direct comparisons of rates. The figures in this dataset include deaths recorded as suicide (people age 10 and over) and undetermined injury (age 15 and over) as those are mostly likely also to have been caused by self-harm rather than unverifiable accident, neglect or abuse. The population denominators for rates are age 10 and over. Low numbers may result in zero values or missing data. Data source: Office for Health Improvement and Disparities (OHID), Public Health Outcomes Framework (PHOF) indicator 41001 (E10). This data is updated annually.

Deaths due to suicide in England and the rate per 100,000 people by days since diagnosis, comparing patients with selected health conditions with matched controls. Includes Hospital Episode Statistics (HES) diagnosis and deaths that occurred between 1 January 2017 and 31 March 2020.

Age-adjusted rate of suicide deaths by sex, race/ethnicity, age; trends if available. Source: Santa Clara County Public Health Department, VRBIS, 2007-2016. Data as of 05/26/2017; U.S. Census Bureau; 2010 Census, Tables PCT12, PCT12H, PCT12I, PCT12J, PCT12K, PCT12L, PCT12M; generated by Baath M.; using American FactFinder; Accessed June 20, 2017. METADATA:Notes (String): Lists table title, notes and sourcesYear (String): Year of data; presented as pooled years (2007 to 2016)Category (String): Lists the category representing the data: Santa Clara County is for total population, age categories as follows: <18, 18 to 44, 45 to 64, 65+; 10 to 19, 20 to 24; 10 to 24; <1, 1 to 4, 5 to 14, 15 to 24, 25 to 34, 35 to 44, 45 to 54, 55 to 64, 65 to 74, 75 to 84, 85+; United States and Healthy People 2020 targetRate per 100,000 people (Numeric): Suicide rate. Rates for age groups are reported as age-specific rates per 100,000 people. All other rates are age-adjusted rates per 100,000 people.

Estimates of suicides among higher education students by sex, age and ethnicity. Based on mortality records linked to Higher Education Statistics Agency (HESA) student records, Experimental Statistics.

Over *** thousand deaths due to suicides were recorded in India in 2022. Furthermore, majority of suicides were reported in the state of Tamil Nadu, followed by Rajasthan. The number of suicides that year had increased from the previous year. Some of the causes for suicides in the country were due to professional problems, abuse, violence, family problems, financial loss, sense of isolation and mental disorders. Depressive disorders and suicide As of 2015, over ****** million people worldwide suffered from some kind of depressive disorder. Furthermore, over ** percent of the total population in India suffer from different forms of mental disorders as of 2017. There exists a positive correlation between the number of suicide mortality rates and people with select mental disorders as opposed to those without. Risk factors for mental disorders Every ******* person in India suffers from some form of mental disorder. Today, depressive disorders are regarded as the leading contributor not only to disease burden and morbidity worldwide, but even suicide if not addressed. In 2022, the leading cause for suicide deaths in India was due to family problems. The second leading cause was due to illness. Some of the risk factors, relative to developing mental disorders including depressive and anxiety disorders, include bullying victimization, poverty, unemployment, childhood sexual abuse and intimate partner violence.

THIS DATASET WAS LAST UPDATED AT 8:11 PM EASTERN ON JULY 16

OVERVIEW

2019 had the most mass killings since at least the 1970s, according to the Associated Press/USA TODAY/Northeastern University Mass Killings Database.

In all, there were 45 mass killings, defined as when four or more people are killed excluding the perpetrator. Of those, 33 were mass shootings . This summer was especially violent, with three high-profile public mass shootings occurring in the span of just four weeks, leaving 38 killed and 66 injured.

A total of 229 people died in mass killings in 2019.

The AP's analysis found that more than 50% of the incidents were family annihilations, which is similar to prior years. Although they are far less common, the 9 public mass shootings during the year were the most deadly type of mass murder, resulting in 73 people's deaths, not including the assailants.

One-third of the offenders died at the scene of the killing or soon after, half from suicides.

About this Dataset

The Associated Press/USA TODAY/Northeastern University Mass Killings database tracks all U.S. homicides since 2006 involving four or more people killed (not including the offender) over a short period of time (24 hours) regardless of weapon, location, victim-offender relationship or motive. The database includes information on these and other characteristics concerning the incidents, offenders, and victims.

The AP/USA TODAY/Northeastern database represents the most complete tracking of mass murders by the above definition currently available. Other efforts, such as the Gun Violence Archive or Everytown for Gun Safety may include events that do not meet our criteria, but a review of these sites and others indicates that this database contains every event that matches the definition, including some not tracked by other organizations.

This data will be updated periodically and can be used as an ongoing resource to help cover these events.

Using this Dataset

To get basic counts of incidents of mass killings and mass shootings by year nationwide, use these queries:

Mass killings by year

Mass shootings by year

To get these counts just for your state:

Filter killings by state

Definition of "mass murder"

Mass murder is defined as the intentional killing of four or more victims by any means within a 24-hour period, excluding the deaths of unborn children and the offender(s). The standard of four or more dead was initially set by the FBI.

This definition does not exclude cases based on method (e.g., shootings only), type or motivation (e.g., public only), victim-offender relationship (e.g., strangers only), or number of locations (e.g., one). The time frame of 24 hours was chosen to eliminate conflation with spree killers, who kill multiple victims in quick succession in different locations or incidents, and to satisfy the traditional requirement of occurring in a “single incident.”

Offenders who commit mass murder during a spree (before or after committing additional homicides) are included in the database, and all victims within seven days of the mass murder are included in the victim count. Negligent homicides related to driving under the influence or accidental fires are excluded due to the lack of offender intent. Only incidents occurring within the 50 states and Washington D.C. are considered.

Methodology

Project researchers first identified potential incidents using the Federal Bureau of Investigation’s Supplementary Homicide Reports (SHR). Homicide incidents in the SHR were flagged as potential mass murder cases if four or more victims were reported on the same record, and the type of death was murder or non-negligent manslaughter.

Cases were subsequently verified utilizing media accounts, court documents, academic journal articles, books, and local law enforcement records obtained through Freedom of Information Act (FOIA) requests. Each data point was corroborated by multiple sources, which were compiled into a single document to assess the quality of information.

In case(s) of contradiction among sources, official law enforcement or court records were used, when available, followed by the most recent media or academic source.

Case information was subsequently compared with every other known mass murder database to ensure reliability and validity. Incidents listed in the SHR that could not be independently verified were excluded from the database.

Project researchers also conducted extensive searches for incidents not reported in the SHR during the time period, utilizing internet search engines, Lexis-Nexis, and Newspapers.com. Search terms include: [number] dead, [number] killed, [number] slain, [number] murdered, [number] homicide, mass murder, mass shooting, massacre, rampage, family killing, familicide, and arson murder. Offender, victim, and location names were also directly searched when available.

This project started at USA TODAY in 2012.

Contacts

Contact AP Data Editor Justin Myers with questions, suggestions or comments about this dataset at jmyers@ap.org. The Northeastern University researcher working with AP and USA TODAY is Professor James Alan Fox, who can be reached at j.fox@northeastern.edu or 617-416-4400.

Note: This Dataset is updated nightly and contains all downloadable Medical Examiner-Coroner records, January 1, 2018 to current, related to deaths that occurred in the County of Santa Clara under the Medical Examiner-Coroner’s jurisdiction and those deaths reportable to the Medical Examiner-Coroner (non-jurisdictional cases/NJA) but in which the office did not assume jurisdiction.

The Santa Clara County Medical Examiner- Coroner’s Office determines cause and manner of death for those deaths that fall under the jurisdiction of the Medical Examiner-Coroner, as defined by California Government code 27491.

The Medical Examiner-Coroner will not be responsible for data verification, interpretation or misinformation once data has been downloaded and manipulated from the dashboard.

Refer to the following document to know more of which deaths are reportable: https://medicalexaminer.sccgov.org/sites/g/files/exjcpb986/files/Reportable%20Death%20Chart%202018.pdf.

This dataset contains the cumulative number of deaths, average number of deaths annually, average annual crude and adjusted death rates with corresponding 95% confidence intervals, and average annual years of potential life lost per 100,000 residents aged 75 and younger due to selected causes of death, by Chicago community area, for the years 2004 – 2008. A ranking for each measure is also provided, with the highest value indicated with a ranking of 1. See the full description at https://data.cityofchicago.org/api/assets/AEE362B2-8986-41D1-847E-B5A3ACAC5B76.

Provisional rate and number of suicide deaths registered in England per quarter. Includes 2001 to 2023 registrations and provisional data for Quarter 1 (Jan to Mar) to Quarter 4 (Oct to Dec) 2024. These are official statistics in development.

This data shows deaths (of people age 10 and over) from Suicide and Undetermined Injury, numbers and rates by gender, as 3-year moving-averages.

Suicide is a significant cause of premature deaths occurring generally at younger ages than other common causes of premature mortality. It may also be seen as an indicator of underlying rates of mental ill-health.

Directly Age-Standardised Rates (DASR) are shown in the data, where numbers are sufficient, so that death rates can be directly compared between areas. The DASR calculation applies Age-specific rates to a Standard (European) population to cancel out possible effects on crude rates due to different age structures among populations, thus enabling direct comparisons of rates.

The figures in this dataset include deaths recorded as suicide (people age 10 and over) and undetermined injury (age 15 and over) as those are mostly likely also to have been caused by self-harm rather than unverifiable accident, neglect or abuse. The population denominators for rates are age 10 and over. Low numbers may result in zero values or missing data.

Data source: Office for Health Improvement and Disparities (OHID), Public Health Outcomes Framework (PHOF) indicator 41001 (E10). This data is updated annually.

Dataset replaced by: http://data.europa.eu/euodp/data/dataset/CAJrcG2qBzdgHFsUWHFw This indicator is defined as the crude death rate from suicide and intentional self-harm per 100 000 people, by age group. Figures should be interpreted with care as suicide registration methods vary between countries and over time. Moreover, the figures do not include deaths from events of undetermined intent (part of which should be considered as suicides) and attempted suicides which did not result in death.

No. of Deaths: Caused by: Intentional Self-Inflicted Injuries (Suicides) & Consequences data was reported at 780.000 Person in Sep 2024. This records an increase from the previous number of 693.000 Person for Jun 2024. No. of Deaths: Caused by: Intentional Self-Inflicted Injuries (Suicides) & Consequences data is updated quarterly, averaging 680.500 Person from Mar 2017 (Median) to Sep 2024, with 30 observations. The data reached an all-time high of 826.000 Person in Jun 2023 and a record low of 128.000 Person in Mar 2017. No. of Deaths: Caused by: Intentional Self-Inflicted Injuries (Suicides) & Consequences data remains active status in CEIC and is reported by National Administrative Department of Statistics. The data is categorized under Global Database’s Colombia – Table CO.G012: Number of Deaths: Cause of Death.

Deaths by suicide in the city of Austin are reported to annually to Austin Public Health trough the Office of Vital Statistics. The data represents deaths by suicide within the city limits.

View more details and insights related to this data set on the story page: https://data.austintexas.gov/stories/s/HE-B-4a-Number-of-Deaths-by-Suicide/mqa2-tm7r/

This group of datasets describe the suicides in Scotland for the period 1982-2009. There are 4 separate datasets: All Suicides/Male Suicides/Female Suicides/All Suicide Rate (expressed per 100,000 people). The data is broken down into Local Authority Areas making it easier to investigate any spatial disparity in the suicide figures. A couple of points are worth noting are that it is unclear if the suicide data shows all suicides or just those of Adults. A recent Scottish Government report(http://www.scotland.gov.uk/Publications/2007/03/01145422/20) used deaths of people over 15 years old. Differences in the rates between this data and the results presented in the Scottish Government report may also be due to different population datasets being used. Suicide data sources form the Scottish Public Health Observatory (http://www.scotpho.org.uk/home/Healthwell-beinganddisease/suicide/suicide_data/suicide_la.asp) and the population data used to calculate the rates was sourced from ShareGeo Open (http://hdl.handle.net/10672/95) which uses mid-year estimates downloaded from Nomis (www.nomisweb.co.uk/. Datasets were joined to Local Authority (district, unitary authority and borough) boundaries downloaded from Ordnance Survey OpenData Boundary Line dataset. All spatial analysis was carried out in ArcGIS. GIS vector data. This dataset was first accessioned in the EDINA ShareGeo Open repository on 2011-01-13 and migrated to Edinburgh DataShare on 2017-02-21.