Life Expectancy (WHO) Fixed

Life Expectancy data is fixed and missing values filled.

@kaggle.lashagoch_life_expectancy_who_updated

Table List

1 table(127.43 KB)

Life Expectancy Data Updated

@kaggle.lashagoch_life_expectancy_who_updated.life_expectancy_data_updated

127.43 KB
2864 rows
21 columns

country Country	region Region	year Year	infant_deaths Infant Deaths	under_five_deaths Under Five Deaths	adult_mortality Adult Mortality	alcohol_consumption Alcohol Consumption	hepatitis_b Hepatitis B	measles Measles	bmi BMI	polio Polio	diphtheria Diphtheria	incidents_hiv Incidents HIV	gdp_per_capita GDP Per Capita	population_mln Population Mln	thinness_ten_nineteen_years Thinness Ten Nineteen Years	thinness_five_nine_years Thinness Five Nine Years	schooling Schooling	economy_status_developed Economy Status Developed	economy_status_developing Economy Status Developing	life_expectancy Life Expectancy
Turkiye	Middle East	2015	11.1	13	105.824	1.32	97	65	27.8	97	97	0.08	11006	78.53	4.9	4.8	7.8		1	76.5
Spain	European Union	2015	2.7	3.3	57.9025	10.35	97	94	26	97	97	0.09	25742	46.44	0.6	0.5	9.7	1		82.8
India	Asia	2007	51.5	67.9	201.0765	1.57	60	35	21.2	67	64	0.13	1076	1183.21	27.1	28	5		1	65.4
Guyana	South America	2006	32.8	40.5	222.1965	5.68	93	74	25.3	92	93	0.79	4146	0.75	5.7	5.5	7.9		1	67
Israel	Middle East	2012	3.4	4.3	57.951	2.89	97	89	27	94	94	0.08	33995	7.91	1.2	1.1	12.8	1		81.7
Costa Rica	Central America and Caribbean	2006	9.8	11.2	95.22	4.19	88	86	26.4	89	89	0.16	9110	4.35	2	1.9	7.9		1	78.2
Russian Federation	Rest of Europe	2015	6.6	8.2	223	8.06	97	97	26.2	97	97	0.08	9313	144.1	2.3	2.3	12		1	71.2
Hungary	European Union	2000	8.7	10.1	192.969	12.23	88	99	25.9	99	99	0.08	8971	10.21	2.3	2.3	10.2	1		71.2
Jordan	Middle East	2001	22	26.1	129.764	0.52	97	87	27.9	97	99	0.13	3708	5.22	4	3.9	9.6		1	71.9
Moldova	Rest of Europe	2008	15.3	17.8	217.857	7.72	97	92	26.5	96	90	0.43	2235	2.87	2.9	3.1	10.9		1	68.7


CREATE TABLE life_expectancy_data_updated (
  "country" VARCHAR,
  "region" VARCHAR,
  "year" BIGINT,
  "infant_deaths" DOUBLE,
  "under_five_deaths" DOUBLE,
  "adult_mortality" DOUBLE,
  "alcohol_consumption" DOUBLE,
  "hepatitis_b" BIGINT,
  "measles" BIGINT,
  "bmi" DOUBLE,
  "polio" BIGINT,
  "diphtheria" BIGINT,
  "incidents_hiv" DOUBLE,
  "gdp_per_capita" BIGINT,
  "population_mln" DOUBLE,
  "thinness_ten_nineteen_years" DOUBLE,
  "thinness_five_nine_years" DOUBLE,
  "schooling" DOUBLE,
  "economy_status_developed" BIGINT,
  "economy_status_developing" BIGINT,
  "life_expectancy" DOUBLE
);