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

Number of suicides, suicide rates and median registration delays, by local authority in England and Wales.

For a summary of the case study, please go to "Portfolio Project".

Context

This data analysis was meant to show that men have their own issues in society that are being ignored. The mental health has been declining especially for men. This decline worldwide maybe due to a multitude of other variables that may correlate such as: internet usage/social media usage, social belonging, work hours, dating apps, and physical health. This data analysis was meant to show that men have their own issues in society that are being ignored. This decline worldwide maybe due to a multitude of other variables that may correlate such as: internet usage/social media usage, social belonging, work hours, dating apps, and physical health. These variables may require a separate dataset going into more detail about them.

A space dedicated just for men and another just for women to speak about their problems with help and constructive criticism for growth and for social belonging maybe required to improve the mental health of society (among other variables). This does not mean that the struggles of women are nonexistent. There are already a multitude of datasets and articles dedicated to some of the possible struggles of women from MSNBC, CNN, NBC, BBC, Netflix movies, and even popular secular music like recent songs WAP from Megan Thee Stallion, God is a Women by Arianna Grande, etc. This dataset's objective was not made to continue to light a flame between the already hostile relationships that modern men and women have with each other. Awareness without bias is the goal.

For the results, please read the portfolio project and leave comments.

Content

Where the data were obtained:

1. The first excel file was obtained from https://data.world/vizzup/mental-health-depression-disorder-data/workspace/file?filename=Mental+health+Depression+disorder+Data.xlsx

2. The second excel file was obtained from https://ourworldindata.org/grapher/male-vs-female-suicide

3. The third excel file was obtained from https://ourworldindata.org/suicide

4. The fourth excel file was obtained from https://ourworldindata.org/drug-use

Inspiration

I want to be the best data analyst ever, so criticism (regardless of the harshness), it will be greatly appreciated. What would you have added/improved on? Was it easy to understand? What else do you want me to make a dataset on?

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.

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.

Download data on suicides in Massachusetts by demographics and year. This page also includes reporting on military & veteran suicide, and suicides during COVID-19.

Fire Incident data includes all fire incident responses. This includes emergency medical services (EMS) calls, fires, rescue incidents, and all other services handled by the Fire Department.

The source of this data is the City of Cincinnati's computer aided dispatch (CAD) database.

This data is updated daily.

DISCLAIMER: In compliance with privacy laws, all Public Safety datasets are anonymized and appropriately redacted prior to publication on the City of Cincinnati’s Open Data Portal. This means that for all public safety datasets: (1) the last two digits of all addresses have been replaced with “XX,” and in cases where there is a single digit street address, the entire address number is replaced with "X"; and (2) Latitude and Longitude have been randomly skewed to represent values within the same block area (but not the exact location) of the incident.

BackgroundIn Europe, men have lower rates of attempted suicide compared to women and at the same time a higher rate of completed suicides, indicating major gender differences in lethality of suicidal behaviour. The aim of this study was to analyse the extent to which these gender differences in lethality can be explained by factors such as choice of more lethal methods or lethality differences within the same suicide method or age. In addition, we explored gender differences in the intentionality of suicide attempts.Methods and FindingsMethods. Design: Epidemiological study using a combination of self-report and official data. Setting: Mental health care services in four European countries: Germany, Hungary, Ireland, and Portugal. Data basis: Completed suicides derived from official statistics for each country (767 acts, 74.4% male) and assessed suicide attempts excluding habitual intentional self-harm (8,175 acts, 43.2% male).Main Outcome Measures and Data Analysis. We collected data on suicidal acts in eight regions of four European countries participating in the EU-funded “OSPI-Europe”-project (www.ospi-europe.com). We calculated method-specific lethality using the number of completed suicides per method * 100 / (number of completed suicides per method + number of attempted suicides per method). We tested gender differences in the distribution of suicidal acts for significance by using the χ2-test for two-by-two tables. We assessed the effect sizes with phi coefficients (φ). We identified predictors of lethality with a binary logistic regression analysis. Poisson regression analysis examined the contribution of choice of methods and method-specific lethality to gender differences in the lethality of suicidal acts.Findings Main ResultsSuicidal acts (fatal and non-fatal) were 3.4 times more lethal in men than in women (lethality 13.91% (regarding 4106 suicidal acts) versus 4.05% (regarding 4836 suicidal acts)), the difference being significant for the methods hanging, jumping, moving objects, sharp objects and poisoning by substances other than drugs. Median age at time of suicidal behaviour (35–44 years) did not differ between males and females. The overall gender difference in lethality of suicidal behaviour was explained by males choosing more lethal suicide methods (odds ratio (OR) = 2.03; 95% CI = 1.65 to 2.50; p < 0.000001) and additionally, but to a lesser degree, by a higher lethality of suicidal acts for males even within the same method (OR = 1.64; 95% CI = 1.32 to 2.02; p = 0.000005). Results of a regression analysis revealed neither age nor country differences were significant predictors for gender differences in the lethality of suicidal acts. The proportion of serious suicide attempts among all non-fatal suicidal acts with known intentionality (NFSAi) was significantly higher in men (57.1%; 1,207 of 2,115 NFSAi) than in women (48.6%; 1,508 of 3,100 NFSAi) (χ2 = 35.74; p < 0.000001).Main limitations of the studyDue to restrictive data security regulations to ensure anonymity in Ireland, specific ages could not be provided because of the relatively low absolute numbers of suicide in the Irish intervention and control region. Therefore, analyses of the interaction between gender and age could only be conducted for three of the four countries. Attempted suicides were assessed for patients presenting to emergency departments or treated in hospitals. An unknown rate of attempted suicides remained undetected. This may have caused an overestimation of the lethality of certain methods. Moreover, the detection of attempted suicides and the registration of completed suicides might have differed across the four countries. Some suicides might be hidden and misclassified as undetermined deaths.ConclusionsMen more often used highly lethal methods in suicidal behaviour, but there was also a higher method-specific lethality which together explained the large gender differences in the lethality of suicidal acts. Gender differences in the lethality of suicidal acts were fairly consistent across all four European countries examined. Males and females did not differ in age at time of suicidal behaviour. Suicide attempts by males were rated as being more serious independent of the method used, with the exceptions of attempted hanging, suggesting gender differences in intentionality associated with suicidal behaviour. These findings contribute to understanding of the spectrum of reasons for gender differences in the lethality of suicidal behaviour and should inform the development of gender specific strategies for suicide prevention.

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.

Suicide Rate - This indicator shows the suicide rate per 100,000 population. Suicide is a serious public health problem that can have lasting effects on individuals, families, and communities. Mental disorders and/or substance abuse have been found in the great majority of people who have died by suicide. In Maryland, approximately 500 lives are lost each year to this preventable cause of death. Link to Data Details

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.

BackgroundSuicide underreporting undermines accurate public health assessments and resource allocation for suicide prevention. This study aims at synthesizing evidence on suicide underreporting and to estimate a global underreporting rate.MethodsWe conducted a PRISMA-compliant systematic review on suicide underreporting, following a pre-registered protocol. A meta-analytical synthesis was also conducted. Quantitative data from individual studies was extracted to provide an overall global estimate of suicide underreporting (42 studies covering 71 countries out of the initial 770 unique studies, spanning 1900–2021). Most studies used retrospective institutional datasets to estimate underreporting through reclassification of undetermined deaths or comparisons across databases. Demographic and geographic disparities were also examined.ResultsThe 42 studies selected provided some quantitative data on suicide underreporting for general or specific populations. 14 of these studies provided data to be meta-analyzed. The global suicide underreporting rate was estimated to be 17.9% (95% CI: 10.9–28.1%) with large differences between countries with high and low/very low data quality. In this scenario, the last WHO estimates of suicide deaths – corrected for underreporting – would be more than one million (1,000,638; 95% CI: 859,511–1,293,006) and not 727,000 suicides per year. Underreporting was higher in low- and middle-income countries (LMICs) with incomplete death registration systems, such as India and China (34.9%; 95% CI 20.3–53%), while high-income countries exhibited lower rates (11.5%; 95% CI 6.6–19.3%). Contributing factors included stigma, religiosity, limited forensic resources, and inconsistent use of International Classification of Diseases (ICD) codes. Gender and age disparities were notable; Female suicides and those among younger or older individuals were more likely to be misclassified.DiscussionAddressing suicide underreporting requires improving death registration systems globally, particularly in LMICs. Standardizing ICD usage, improving forensic capacity, and reducing stigma are critical steps to ensure accurate data. Heterogeneity, geographical disparities, temporal biases, and invariance of suicide underreporting for countries with low-quality data demand further corroboration of these findings.Systematic Review Registrationhttps://osf.io/9j8dg.

BackgroundAbout 1 million people worldwide commit suicide each year, and college students with suicidal ideation are at high risk of suicide. The prevalence of suicidal ideation in college students has been estimated extensively, but quantitative syntheses of overall prevalence are scarce, especially in China. Accurate estimates of prevalence are important for making public policy. In this paper, we aimed to determine the prevalence of suicidal ideation in Chinese college students.Objective and MethodsDatabases including PubMed, Web of Knowledge, Chinese Web of Knowledge, Wangfang (Chinese database) and Weipu (Chinese database) were systematically reviewed to identify articles published between 2004 to July 2013, in either English or Chinese, reporting prevalence estimates of suicidal ideation among Chinese college students. The strategy also included a secondary search of reference lists of records retrieved from databases. Then the prevalence estimates were summarized using a random effects model. The effects of moderator variables on the prevalence estimates were assessed using a meta-regression model.ResultsA total of 41 studies involving 160339 college students were identified, and the prevalence ranged from 1.24% to 26.00%. The overall pooled prevalence of suicidal ideation among Chinese college students was 10.72% (95%CI: 8.41% to 13.28%). We noted substantial heterogeneity in prevalence estimates. Subgroup analyses showed that prevalence of suicidal ideation in females is higher than in males.ConclusionsThe prevalence of suicidal ideation in Chinese college students is relatively high, although the suicide rate is lower compared with the entire society, suggesting the need for local surveys to inform the development of health services for college students.

The dataset contains World Bank Suicide mortality rate WDI (world development indicator) (2000-2019) world-wide data in original and processed form. In addition to the statistical data this dataset also contains bibliographic records of articles published on the topic of suicide in relation to individual countries during (2000-2019) in original and processed form.

The data consists of six archives:

1. World development indicator suicide mortality rate SH.STA.SUIC.P5. This archive contains suicide mortality rate of 159 countries during the period of 2000-2019 per 100,000 population including males and females as of November, 2023.
2. Web of science records country and suicide. This archive contains bibliographic records organized by country on the topic of suicide related to that country published during 2000-2019 as of November, 2023.
3. Suicide mortality rate statistics and keywords. This archive contains processed data of 1 and 2 archives in three files. The 'Countries suicide rates and WOS records' contains organized temporal suicide mortality rate data for each country and each year for males and females including counts of articles on suicide related in that country. The 'words and countries matrix' file contains information about how many times author and paper keywords from suicide related publications were seen in articles associated with each country. This data is organized as matrix in which rows are keywords, columns are countries and cells are counts of the keyword. The 'words and countries pairs' file contains same information only organized as keyword country pairs.
4. Suicide mortality rate clusters countries keywords titles. This archive contains bibliographic data organized by country clusters. These clusters group countries with similar suicide mortality rate dynamics in males and females shown in two included figures. Each folder of the cluster contains a section with bibliographic records; a section with keywords associated with each country; and a section in which each publication associated with the country has a separate filecontaining its title and keywords.
5. Suicide keywords embedding data. This archive contains word embedding vectors and metadata learned by recurrent neural network trained to classify countries from suicide related keywords of articles associated with those countries. Folder 'trained with keywords' contains embeddings learned in classifying countries in which training samples are keyword strings of publications. Folder 'trained with titles' contains embeddings learned in classifying countries in which training samples are strings containing titles of publication plus keywords.
6. Suicide keywords association rule mining. This archive contains files of subsets of keywords frequently mentioned together in suicide related publications. Folder 'Mining in clusters' has frequent keyword itemsets in country clusters. Folder 'Mining in individual countries' has frequent keyword itemsets in countries. Examples of keyword networks connecting clusters and networks connecting countries in individual clusters are included which helps to identify specific and shared keywords by country clusters and by countries in the individual clusters.

These datasets support a data availability statements for upcoming articles.

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 report draws on data from the National Child Mortality Database (NCMD) to identify the common characteristics of children and young people who die by suicide, investigate factors associated with these deaths and pull out recommendations for service providers and policymakers. This report, the second thematic report from the NCMD, looks at deaths that occurred or were reviewed by a child death overview panel between 1st April 2019 and 31st March 2020.

Demographic characteristics of New South Wales men diagnosed with prostate cancer in 1997 to 2007, comparing those who committed suicide with all men diagnosed with prostate cancer, number, percent, person years at risk and crude rate per 100,000 person years at risk.

This dataset provides comprehensive information on the total number of suicides in Mexico from 1990 to 2023, categorized by sex and state.The dataset adheres to the government methodology by using the year of registration and the state of residence of the deceased as key variables. It includes the following data points:The total male and female populations.Suicide counts for males and females.Suicide rates for each sex.Data SourcesSuicide Data: Extracted from the INEGI database of registered deaths.Source: INEGI - Microdata on DeathsPopulation Data: Sourced from Mexican government population projections for 2020-2070.Source: Gob.mx - Population ProjectionsThis dataset is a valuable resource for understanding trends in suicide across Mexico and offers insights into differences by sex and state-level demographics.

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.

The file (S1_File). contains data that support the presented analyses. Due to data safety reasons the file is anonymized and the variable “age” was reduced to 5-year age groups. (SAV)