Human Development Index (HDI)
HDI = Horse Demand Increase lol 😂
@kaggle.programmerrdai_human_development_index_hdi
HDI = Horse Demand Increase lol 😂
@kaggle.programmerrdai_human_development_index_hdi
The Human Development Index is a statistic composite index of life expectancy, education, and per capita income indicators, which are used to rank countries into four tiers of human development. Wikipedia
CREATE TABLE expected_years_of_schooling (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"expected_years_of_schooling_years" DOUBLE -- Expected Years Of Schooling (years)
);CREATE TABLE gross_national_income_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"gni_per_capita_ppp_constant_2017_international" DOUBLE -- GNI Per Capita, PPP (constant 2017 International $)
);CREATE TABLE hdi_vs_gdp_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"historical_index_of_human_development_prados_de_la_escosura" DOUBLE -- Historical Index Of Human Development (Prados De La Escosura),
"gdp_per_capita" DOUBLE,
"n_417485_annotations" VARCHAR -- 417485-annotations,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE hdi_vs_hihd (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"human_development_index_undp" DOUBLE -- Human Development Index (UNDP),
"historical_index_of_human_development_prados_de_la_escosura" DOUBLE -- Historical Index Of Human Development (Prados De La Escosura),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE hihd_without_gdp_vs_gdp_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"historical_index_of_human_development_without_gdp_metric" DOUBLE -- Historical Index Of Human Development (without GDP Metric),
"gdp_per_capita" DOUBLE,
"n_417485_annotations" VARCHAR -- 417485-annotations,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE human_development_index (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"human_development_index_undp" DOUBLE -- Human Development Index (UNDP)
);CREATE TABLE human_development_index_comparison (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"historical_index_of_human_development_prados_de_la_escosura" DOUBLE -- Historical Index Of Human Development (Prados De La Escosura),
"historical_index_of_human_development_without_gdp_metric" DOUBLE -- Historical Index Of Human Development (without GDP Metric),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE human_development_index_escosura (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"historical_index_of_human_development_prados_de_la_escosura" DOUBLE -- Historical Index Of Human Development (Prados De La Escosura)
);CREATE TABLE mean_years_of_schooling_long_run (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"average_total_years_of_schooling_for_adult_population__5d6bdda7" DOUBLE -- Average Total Years Of Schooling For Adult Population (Lee-Lee (2016), Barro-Lee (2018) And UNDP (2018))
);Anyone who has the link will be able to view this.