Human Development Report 2015
Countries ranked by human development, gender inequality, and poverty
@kaggle.undp_human_development
Countries ranked by human development, gender inequality, and poverty
@kaggle.undp_human_development
The Human Development Index (HDI) is a summary measure of achievements in key dimensions of human development: a long and healthy life, access to knowledge, and a decent standard of living. The HDI is the geometric mean of normalized indices for each of the three dimensions. The health dimension is assessed by life expectancy at birth, the education dimension is measured by mean of years of education for adults aged 25 years and more and expected years of education for children, and the standard of living dimension is measured by gross national income per capita. The Inequality-Adjusted Human Development Index (IHDI) adjusts the HDI for inequality in the distribution of each dimension across the population.
The Gender Development Index (GDI) measures gender inequalities in achievement in three basic dimensions of human development: health, measured by female and male life expectancy at birth; education, measured by female and male expected years of education for children and female and male mean years of education for adults ages 25 and older; and command over economic resources, measured by female and male estimated earned income. The Gender Inequality Index (GII) reflects gender-based disadvantage in three dimensions—reproductive health, empowerment, and the labour market—for as many countries as data of reasonable quality allow. It shows the loss in potential human development due to inequality between female and male achievements in these dimensions.
The Multidimensional Poverty Index (MPI) identifies multiple deprivations at the household level in education, health, and standard of living as indicators of poverty. It uses micro data from household surveys, and — unlike the IHDI — all the indicators needed to construct the measure must come from the same survey.
CREATE TABLE gender_development (
"gdi_rank" DOUBLE,
"country" VARCHAR,
"gender_development_index_gdi" VARCHAR -- Gender Development Index (GDI),
"human_development_index_female" VARCHAR -- Human Development Index (Female),
"human_development_index_male" VARCHAR -- Human Development Index (Male),
"life_expectancy_at_birth_female" VARCHAR -- Life Expectancy At Birth (Female),
"life_expectancy_at_birth_male" VARCHAR -- Life Expectancy At Birth (Male),
"expected_years_of_education_female" VARCHAR -- Expected Years Of Education (Female),
"expected_years_of_education_male" VARCHAR -- Expected Years Of Education (Male),
"mean_years_of_education_female" VARCHAR -- Mean Years Of Education (Female),
"mean_years_of_education_male" VARCHAR -- Mean Years Of Education (Male),
"estimated_gross_national_income_per_capita_female" VARCHAR -- Estimated Gross National Income Per Capita (Female),
"estimated_gross_national_income_per_capita_male" VARCHAR -- Estimated Gross National Income Per Capita (Male)
);CREATE TABLE gender_inequality (
"gii_rank" DOUBLE,
"country" VARCHAR,
"gender_inequality_index_gii" VARCHAR -- Gender Inequality Index (GII),
"maternal_mortality_ratio" VARCHAR,
"adolescent_birth_rate" VARCHAR,
"percent_representation_in_parliament" VARCHAR,
"population_with_secondary_education_female" VARCHAR -- Population With Secondary Education (Female),
"population_with_secondary_education_male" VARCHAR -- Population With Secondary Education (Male),
"labour_force_participation_rate_female" VARCHAR -- Labour Force Participation Rate (Female),
"labour_force_participation_rate_male" VARCHAR -- Labour Force Participation Rate (Male)
);CREATE TABLE historical_index (
"hdi_rank" DOUBLE,
"country" VARCHAR,
"human_development_index_1990" VARCHAR -- Human Development Index (1990),
"human_development_index_2000" VARCHAR -- Human Development Index (2000),
"human_development_index_2010" DOUBLE -- Human Development Index (2010),
"human_development_index_2011" DOUBLE -- Human Development Index (2011),
"human_development_index_2012" DOUBLE -- Human Development Index (2012),
"human_development_index_2013" DOUBLE -- Human Development Index (2013),
"human_development_index_2014" DOUBLE -- Human Development Index (2014)
);CREATE TABLE human_development (
"hdi_rank" DOUBLE,
"country" VARCHAR,
"human_development_index_hdi" DOUBLE -- Human Development Index (HDI),
"life_expectancy_at_birth" DOUBLE,
"expected_years_of_education" DOUBLE,
"mean_years_of_education" DOUBLE,
"gross_national_income_gni_per_capita" BIGINT -- Gross National Income (GNI) Per Capita,
"gni_per_capita_rank_minus_hdi_rank" DOUBLE
);CREATE TABLE inequality_adjusted (
"ihdi_rank" DOUBLE,
"country" VARCHAR,
"human_development_index_hdi" DOUBLE -- Human Development Index (HDI),
"inequality_adjusted_hdi_ihdi" VARCHAR -- Inequality-adjusted HDI (IHDI),
"ihdi_loss_percent" VARCHAR,
"ihdi_rank_difference" VARCHAR,
"coefficient_of_human_inequality" VARCHAR,
"inequality_in_life_expectancy" VARCHAR,
"inequality_adjusted_life_expectancy_index" VARCHAR,
"inequality_in_education" VARCHAR,
"inequality_adjusted_education_index" VARCHAR,
"inequality_in_income" VARCHAR,
"inequality_adjusted_income_index" VARCHAR,
"income_inequality_quintile_ratio" VARCHAR -- Income Inequality (Quintile Ratio),
"income_inequality_palma_rati" VARCHAR -- Income Inequality (Palma Rati),
"income_inequality_gini_coefficient" VARCHAR -- Income Inequality (Gini Coefficient)
);CREATE TABLE multidimensional_poverty (
"country" VARCHAR,
"year_and_survey" VARCHAR,
"multidimensional_poverty_index_mpi_hdro" DOUBLE -- Multidimensional Poverty Index (MPI, HDRO),
"mpi_hdro_percent" DOUBLE,
"multidimensional_poverty_index_mpi_2010" DOUBLE -- Multidimensional Poverty Index (MPI, 2010),
"mpi_2010_percent" DOUBLE,
"population_in_multidimensional_poverty" BIGINT,
"intensity_of_deprivation" DOUBLE,
"education_deprivation" DOUBLE,
"health_deprivation" DOUBLE,
"living_standards" DOUBLE,
"population_below_national_poverty_line" VARCHAR,
"population_below_1_25_per_day" VARCHAR -- Population Below $1.25 Per Day
);Anyone who has the link will be able to view this.