Context
In light of Suicide Awareness Month, relationships between overall health investment (as a mental health proxy) and suicide rates are a key index to watch.
We expect a positive effect of more expenditure in health topics, giving away less rates of suicides in countries worldwide.
The hope of less suicides brings us a light of answers of where to put our efforts, even though this job does not consider other relevant factors such as socioeconomical development, private and public actions, and individuals characteristics.
Content
This data was downloaded from the WHO Mortality stats published and ICD10 death classification codes, then edited for format and condensation of ICD (more than 5 million rows) in SQL (Query attached). Finally, a tableau visualization was also developed.
The following links are the primary content sources:
-
https://www.who.int/data/data-collection-tools/who-mortality-database
- https://www.who.int/data/gho/data/indicators/indicator-details/GHO/current-health-expenditure-(che)-as-percentage-of-gross-domestic-product-(gdp)-(-)
- https://health.mo.gov/data/documentation/death/death-icd10.php
"The data available for download from this web site are official national statistics in the sense that they have been transmitted to the World Health Organization by the competent authorities of the countries concerned.
The database contains number of deaths by country, year, sex, age group and cause of death as far back from 1950. Data are included only for countries reporting data properly coded according to the International Classification of Diseases (ICD).
"
Tableau Visualization