World Bank Data - Suicide Analysis
Datased used to make an small analysis about suicide based in economic factors
@kaggle.wildocelot_world_bank_data_suicidal_analysis
Datased used to make an small analysis about suicide based in economic factors
@kaggle.wildocelot_world_bank_data_suicidal_analysis
This data was used to make an economical model to analyze the incidence of suicide worldwide.
All the data has been gathered from World Bank datasets.
CREATE TABLE wb_data_suicide_economic_factors (
"country_name" VARCHAR,
"country_code" VARCHAR,
"time" BIGINT,
"suicide_mortality_rate_per_100_000_population_sh_sta_suic_p5" VARCHAR -- Suicide Mortality Rate (per 100,000 Population) [SH.STA.SUIC.P5],
"inflation_consumer_prices_annual_fp_cpi_totl_zg" VARCHAR -- Inflation, Consumer Prices (annual %) [FP.CPI.TOTL.ZG],
"final_consumption_expenditure_constant_2015_us_ne_con_totl_kd" VARCHAR -- Final Consumption Expenditure (constant 2015 US$) [NE.CON.TOTL.KD],
"gross_capital_formation_constant_2015_us_ne_gdi_totl_kd" VARCHAR -- Gross Capital Formation (constant 2015 US$) [NE.GDI.TOTL.KD],
"gross_national_expenditure_constant_2015_us_ne_dab_totl_kd" VARCHAR -- Gross National Expenditure (constant 2015 US$) [NE.DAB.TOTL.KD],
"gni_per_capita_constant_2015_us_ny_gnp_pcap_kd" VARCHAR -- GNI Per Capita (constant 2015 US$) [NY.GNP.PCAP.KD],
"agriculture_forestry_and_fishing_value_added_per_worke_2b266d9e" VARCHAR -- Agriculture, Forestry, And Fishing, Value Added Per Worker (constant 2015 US$) [NV.AGR.EMPL.KD],
"industry_including_construction_value_added_per_worker_630be16f" VARCHAR -- Industry (including Construction), Value Added Per Worker (constant 2015 US$) [NV.IND.EMPL.KD],
"services_value_added_constant_2015_us_nv_srv_totl_kd" VARCHAR -- Services, Value Added (constant 2015 US$) [NV.SRV.TOTL.KD],
"government_expenditure_on_education_total_of_governmen_83df6d78" VARCHAR -- Government Expenditure On Education, Total (% Of Government Expenditure) [SE.XPD.TOTL.GB.ZS],
"domestic_general_government_health_expenditure_of_gene_f271e1b8" VARCHAR -- Domestic General Government Health Expenditure (% Of General Government Expenditure) [SH.XPD.GHED.GE.ZS],
"life_expectancy_at_birth_total_years_sp_dyn_le00_in" VARCHAR -- Life Expectancy At Birth, Total (years) [SP.DYN.LE00.IN],
"population_total_sp_pop_totl" VARCHAR -- Population, Total [SP.POP.TOTL],
"employment_to_population_ratio_15_total_national_estim_789cb5d0" VARCHAR -- Employment To Population Ratio, 15+, Total (%) (national Estimate) [SL.EMP.TOTL.SP.NE.ZS],
"gini_index_si_pov_gini" VARCHAR -- Gini Index [SI.POV.GINI],
"income_share_held_by_highest_20_si_dst_05th_20" VARCHAR -- Income Share Held By Highest 20% [SI.DST.05TH.20],
"income_share_held_by_lowest_20_si_dst_frst_20" VARCHAR -- Income Share Held By Lowest 20% [SI.DST.FRST.20],
"co2_emissions_metric_tons_per_capita_en_atm_co2e_pc" VARCHAR -- CO2 Emissions (metric Tons Per Capita) [EN.ATM.CO2E.PC]
);Anyone who has the link will be able to view this.