Suicide Rates Overview (1985 To 2021)

Compares socio-economic info with suicide rates by year and country

@kaggle.omkargowda_suicide_rates_overview_1985_to_2021

Table List

1 table(445.02 KB)

Master

@kaggle.omkargowda_suicide_rates_overview_1985_to_2021.master

445.02 KB
31756 rows
12 columns

country Country	year Year	sex Sex	age Age	suicides_no Suicides No	population Population	suicides_100k_pop Suicides/100k Pop	country_year Country-year	n__gdp_for_year Gdp For Year ($)	gdp_per_capita Gdp Per Capita ($)	generation Generation
Albania	1987	male	15-24 years	21	312900	6.71	Albania1987	2156624900	796	Generation X
Albania	1987	male	35-54 years	16	308000	5.19	Albania1987	2156624900	796	Silent
Albania	1987	female	15-24 years	14	289700	4.83	Albania1987	2156624900	796	Generation X
Albania	1987	male	75+ years	1	21800	4.59	Albania1987	2156624900	796	G.I. Generation
Albania	1987	male	25-34 years	9	274300	3.28	Albania1987	2156624900	796	Boomers
Albania	1987	female	75+ years	1	35600	2.81	Albania1987	2156624900	796	G.I. Generation
Albania	1987	female	35-54 years	6	278800	2.15	Albania1987	2156624900	796	Silent
Albania	1987	female	25-34 years	4	257200	1.56	Albania1987	2156624900	796	Boomers
Albania	1987	male	55-74 years	1	137500	0.73	Albania1987	2156624900	796	G.I. Generation
Albania	1987	female	5-14 years		311000		Albania1987	2156624900	796	Generation X


CREATE TABLE master (
  "country" VARCHAR,
  "year" BIGINT,
  "sex" VARCHAR,
  "age" VARCHAR,
  "suicides_no" DOUBLE,
  "population" BIGINT,
  "suicides_100k_pop" DOUBLE,
  "country_year" VARCHAR,
  "hdi_for_year" DOUBLE,
  "n__gdp_for_year" DOUBLE,
  "gdp_per_capita" DOUBLE,
  "generation" VARCHAR
);