Life Expectancy Based On Geographic Locations

Analyzing Life Expectancy Variation Across Different Geographic Locations

@kaggle.saurabhbadole_life_expectancy_based_on_geographic_locations

Table List

1 table(148.32 KB)

Lifeexpectancy

@kaggle.saurabhbadole_life_expectancy_based_on_geographic_locations.lifeexpectancy

148.32 KB
2928 rows
22 columns

country Country	year Year	status Status	life_expectancy Life Expectancy	adult_mortality Adult Mortality	infant_deaths Infant Deaths	alcohol Alcohol	percentage_expenditure Percentage Expenditure	hepatitis_b Hepatitis B	measles Measles	n__bmi BMI	under_five_deaths Under-five Deaths	polio Polio	total_expenditure Total Expenditure	diphtheria Diphtheria	n__hiv_aids HIV/AIDS	gdp GDP	population Population	n__thinness_1_19_years Thinness 1-19 Years	n__thinness_5_9_years Thinness 5-9 Years	income_composition_of_resources Income Composition Of Resources	schooling Schooling
Afghanistan	2015	Developing	65	263	62	0.01	71.27962362	65	1154	19.1	83	6	8.16	65	0.1	584.25921	33736494	17.2	17.3	0.479	10.1
Afghanistan	2014	Developing	59.9	271	64	0.01	73.52358168	62	492	18.6	86	58	8.18	62	0.1	612.696514	327582	17.5	17.5	0.476	10
Afghanistan	2013	Developing	59.9	268	66	0.01	73.21924272	64	430	18.1	89	62	8.13	64	0.1	631.744976	31731688	17.7	17.7	0.47	9.9
Afghanistan	2012	Developing	59.5	272	69	0.01	78.1842153	67	2787	17.6	93	67	8.52	67	0.1	669.959	3696958	17.9	18	0.463	9.8
Afghanistan	2011	Developing	59.2	275	71	0.01	7.097108703	68	3013	17.2	97	68	7.87	68	0.1	63.537231	2978599	18.2	18.2	0.454	9.5
Afghanistan	2010	Developing	58.8	279	74	0.01	79.67936736	66	1989	16.7	102	66	9.2	66	0.1	553.32894	2883167	18.4	18.4	0.448	9.2
Afghanistan	2009	Developing	58.6	281	77	0.01	56.76221682	63	2861	16.2	106	63	9.42	63	0.1	445.8932979	284331	18.6	18.7	0.434	8.9
Afghanistan	2008	Developing	58.1	287	80	0.03	25.87392536	64	1599	15.7	110	64	8.33	64	0.1	373.3611163	2729431	18.8	18.9	0.433	8.7
Afghanistan	2007	Developing	57.5	295	82	0.02	10.91015598	63	1141	15.2	113	63	6.73	63	0.1	369.835796	26616792	19	19.1	0.415	8.4
Afghanistan	2006	Developing	57.3	295	84	0.03	17.17151751	64	1990	14.7	116	58	7.43	58	0.1	272.56377	2589345	19.2	19.3	0.405	8.1


CREATE TABLE lifeexpectancy (
  "country" VARCHAR,
  "year" BIGINT,
  "status" VARCHAR,
  "life_expectancy" DOUBLE,
  "adult_mortality" BIGINT,
  "infant_deaths" BIGINT,
  "alcohol" DOUBLE,
  "percentage_expenditure" DOUBLE,
  "hepatitis_b" DOUBLE,
  "measles" BIGINT,
  "n__bmi" DOUBLE,
  "under_five_deaths" BIGINT,
  "polio" DOUBLE,
  "total_expenditure" DOUBLE,
  "diphtheria" DOUBLE,
  "n__hiv_aids" DOUBLE,
  "gdp" DOUBLE,
  "population" DOUBLE,
  "n__thinness_1_19_years" DOUBLE,
  "n__thinness_5_9_years" DOUBLE,
  "income_composition_of_resources" DOUBLE,
  "schooling" DOUBLE
);