Homicide Rate, Suicide Rate And GDP 1970-2020

50 years of Homicide rate, Suicide rate and GDP by country

@kaggle.prasertk_homicide_suicide_rate_and_gdp

Table List

1 table(245.59 KB)

Suicide Homicide Gdp

@kaggle.prasertk_homicide_suicide_rate_and_gdp.suicide_homicide_gdp

245.59 KB
13566 rows
10 columns

country Country	iso3c Iso3c	iso2c Iso2c	year Year	gdp_current_us GDP (current US$)	adminregion Adminregion	incomelevel IncomeLevel
Afghanistan	AFG	AF	1970	1748886595.55556	South Asia	Low income
Afghanistan	AFG	AF	1971	1831108971.11111	South Asia	Low income
Afghanistan	AFG	AF	1972	1595555475.55556	South Asia	Low income
Afghanistan	AFG	AF	1973	1733333264.44444	South Asia	Low income
Afghanistan	AFG	AF	1974	2155555497.77778	South Asia	Low income
Afghanistan	AFG	AF	1975	2366666615.55556	South Asia	Low income
Afghanistan	AFG	AF	1976	2555555566.66667	South Asia	Low income
Afghanistan	AFG	AF	1977	2953333417.77778	South Asia	Low income
Afghanistan	AFG	AF	1978	3300000108.88889	South Asia	Low income
Afghanistan	AFG	AF	1979	3697940409.61098	South Asia	Low income


CREATE TABLE suicide_homicide_gdp (
  "country" VARCHAR,
  "iso3c" VARCHAR,
  "iso2c" VARCHAR,
  "year" BIGINT,
  "intentional_homicides_per_100_000_people" DOUBLE,
  "suicide_mortality_rate_per_100_000_population" DOUBLE,
  "gdp_current_us" DOUBLE,
  "gdp_per_capita_ppp_current_international" DOUBLE,
  "adminregion" VARCHAR,
  "incomelevel" VARCHAR
);