World Health Statistics 2020|Complete|Geo-Analysis

location Location	period Period	indicator Indicator	dim1 Dim1	hale_expectency Hale Expectency	life_expectany Life Expectany	unnamed_6 Unnamed: 6	n__of_hale_in_life_expectancy % OF HALE In Life Expectancy
Africa	2019	Healthy life expectancy (HALE) at birth (years)	Both sexes	56.04	64.49	86.89719336	87
Africa	2019	Healthy life expectancy (HALE) at birth (years)	Male	55	62.37	88.18342152	88
Africa	2019	Healthy life expectancy (HALE) at birth (years)	Female	57.09	66.65	85.6564141	86
Africa	2015	Healthy life expectancy (HALE) at birth (years)	Both sexes	54.42	62.56	86.98849105	87
Africa	2015	Healthy life expectancy (HALE) at birth (years)	Male	53.38	60.47	88.27517777	88
Africa	2015	Healthy life expectancy (HALE) at birth (years)	Female	55.47	64.69	85.74741073	86
Africa	2010	Healthy life expectancy (HALE) at birth (years)	Both sexes	51.8	59.49	87.07345772	87
Africa	2010	Healthy life expectancy (HALE) at birth (years)	Male	50.98	57.69	88.36886809	88
Africa	2010	Healthy life expectancy (HALE) at birth (years)	Female	52.63	61.31	85.84244006	86
Africa	2000	Healthy life expectancy (HALE) at birth (years)	Both sexes	45.8	52.65	86.98955366	87


CREATE TABLE ofhaleinlifeexpectancy (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "hale_expectency" DOUBLE,
  "life_expectany" DOUBLE,
  "unnamed_6" DOUBLE,
  "n__of_hale_in_life_expectancy" BIGINT
);