65 World Indexes

Why are some countries so different?

@kaggle.joniarroba_65_world_indexes_gathered

Table List

1 table(149.71 KB)

Kaggle

@kaggle.joniarroba_65_world_indexes_gathered.kaggle

149.71 KB
188 rows
66 columns

id Id	human_development_index_hdi_2014 Human Development Index HDI-2014	gini_coefficient_2005_2013 Gini Coefficient 2005-2013	adolescent_birth_rate_15_19_per_100k_20102015 Adolescent Birth Rate 15-19 Per 100k 20102015	birth_registration_funder_age_5_2005_2013 Birth Registration Funder Age 5–2005-2013	carbon_dioxide_emissionsaverage_annual_growth Carbon Dioxide EmissionsAverage Annual Growth	carbon_dioxide_emissions_per_capita_2011_tones Carbon Dioxide Emissions Per Capita 2011 Tones	change_forest_percentable_1900_to_2012 Change Forest Percentable 1900 To 2012	change_mobile_usage_2009_2014 Change Mobile Usage 2009–2014	consumer_price_index_2013 Consumer Price Index 2013	domestic_credit_provided_by_financial_sector_2013 Domestic Credit Provided By Financial Sector 2013	domestic_food_price_level_2009_2014_index Domestic Food Price Level 2009–2014 Index	domestic_food_price_level_2009_2014_volitility_index Domestic Food Price Level 2009-2014 Volitility Index	electrification_rate_or_population Electrification Rate Or Population	expected_years_of_schooling_years Expected Years Of Schooling - Years	exports_and_imports_percentage_gpd_2013 Exports And Imports Percentage GPD 2013	female_suicide_rate_100k_people Female Suicide Rate 100k People	foreign_direct_investment_net_inflows_percentage_gdp_2013 Foreign Direct Investment Net Inflows Percentage GDP 2013	forest_area_percentage_of_total_land_area_2012 Forest Area Percentage Of Total Land Area 2012	fossil_fuels_percentage_of_total_2012 Fossil Fuels Percentage Of Total 2012	fresh_water_withdrawals_2005 Fresh Water Withdrawals 2005	gender_inequality_index_2014 Gender Inequality Index 2014	general_government_final_consumption_expenditure_annua_87c34934 General Government Final Consumption Expenditure - Annual Growth 2005–2013	general_government_final_consumption_expenditure_perce_79131c7a General Government Final Consumption Expenditure - Perce Of GDP 2005-2013	gross_domestic_product_gdp_2013 Gross Domestic Product GDP 2013	gross_domestic_product_gdp_percapta Gross Domestic Product GDP Percapta	gross_fixed_capital_formation_of_gdp_2005_2013 Gross Fixed Capital Formation Of GDP 2005-2013	gross_national_income_gni_per_capita_2011_dollars Gross National Income GNI Per Capita - 2011 Dollars	homeless_people_due_to_natural_disaster_2005_2014_per__41c5f21e Homeless People Due To Natural Disaster 2005–2014 Per Million People	homicide_rate_per_100k_people_2008_2012 Homicide Rate Per 100k People 2008-2012	infant_mortality_2013_per_thousands Infant Mortality 2013 Per Thousands	international_inbound_tourists_thausands_2013 International Inbound Tourists Thausands 2013	international_student_mobility_of_total_tetiary_enrolvemnt_2013 International Student Mobility Of Total Tetiary Enrolvemnt 2013	internet_users_percentage_of_population_2014 Internet Users Percentage Of Population 2014	intimate_or_nonintimate_partner_violence_ever_experien_26358a57 Intimate Or Nonintimate Partner Violence Ever Experienced 2001-2011	life_expectancy_at_birth_years Life Expectancy At Birth- Years	malesuicide_rate_100k_people MaleSuicide Rate 100k People	maternal_mortality_ratio_deaths_per_100_live_births_2013 Maternal Mortality Ratio Deaths Per 100 Live Births 2013	mean_years_of_schooling_years Mean Years Of Schooling - Years	mobile_phone_subscriptions_per_100_people_2014 Mobile Phone Subscriptions Per 100 People 2014	natural_resource_depletion Natural Resource Depletion	net_migration_rate_per_1k_people_2010_2015 Net Migration Rate Per 1k People 2010-2015	physicians_per_10k_people Physicians Per 10k People	population_affected_by_natural_desasters_average_annua_29d58941 Population Affected By Natural Desasters Average Annual Per Million People 2005-2014	population_living_on_degraded_land_percentage_2010 Population Living On Degraded Land Percentage 2010	population_with_at_least_some_secondary_education_perc_a8f59bca Population With At Least Some Secondary Education Percent 2005-2013	pre_primary_2008_2014 Pre-primary 2008-2014	primary_2008_2014 Primary-2008-2014	primary_school_dropout_rate_2008_2014 Primary School Dropout Rate 2008-2014	prison_population_per_100k_people Prison Population Per 100k People	private_capital_flows_percentage_gdp_2013 Private Capital Flows Percentage GDP 2013	public_expenditure_on_education_percentange_gdp Public Expenditure On Education Percentange GDP	public_health_expenditure_percentage_of_gdp_2013 Public Health Expenditure Percentage Of GDP 2013	pupil_teacher_ratio_primary_school_pupils_per_teacher_2008_2014 Pupil-teacher Ratio Primary School Pupils Per Teacher 2008-2014	refugees_by_country_of_origin Refugees By Country Of Origin	remittances_inflows_percentual_gdp_2013 Remittances Inflows Percentual GDP 2013	renewable_sources_percentage_of_total_2012 Renewable Sources Percentage Of Total 2012	research_and_development_expenditure_2005_2012 Research And Development Expenditure 2005-2012	secondary_2008_2014 Secondary 2008-2014	share_of_seats_in_parliament_percentage_held_by_womand_2014 Share Of Seats In Parliament Percentage Held By Womand 2014	stock_of_immigrants_percentage_of_population_2013 Stock Of Immigrants Percentage Of Population 2013	taxes_on_income_profit_and_capital_gain_205_2013 Taxes On Income Profit And Capital Gain 205–2013	tertiary_2008_2014 Tertiary -2008-2014	total_tax_revenue_of_gdp_2005_2013 Total Tax Revenue Of GDP 2005-2013	tuberculosis_rate_per_thousands_2012 Tuberculosis Rate Per Thousands 2012	under_five_mortality_2013_thousands Under-five Mortality 2013 Thousands
Norway	0.9438772800225896	26.83	7.834	100	0.778924806	9.192879069	11.914567373052098	5.22	104.1941748	86.956222267	1.51	11.3	100	17.49259	67.03594	5.2	0.5125554	27.973433205	57.27180466	0.75	0.0674430017421526	1.815163573	21.85272015	317.4975867	62448.01762	22.6444755	64992.34046		2.2	2.3	4963	-3.37449	96.3	26.8	81.6	13	4	12.631	116.51	9.019499492	6	37.39	12.3478376	0.186818481	97.05961	98.85057	99.43699	1.51155	72	11.4674	6.552840233	9.573011	9.590636666666668	0.013	0.1544065	47.75267616	1.65474	111.0613	39.6449704	13.77262169	31.798390749	74.10112	27.288096905	0.14	2.8
Australia	0.9349582502222634	34.01	12.059	100	1.090351403	16.51920992	-4.56181232106	30.27	107.7894398	158.840775744	1.36	6.3	100	20.22107	40.99572	5.2	3.330412	19.193731044	95.36779752	3.93	0.1101301029569508	-0.017409664	17.7467415	990.7210035	42831.06163	28.3274072	42260.61295	33.40661991	1.1	3.4	6382	17.13209	84.56	39.9	82.4	16.1	6	12.96338081	131.23	3.819851398	6.5	32.73	1337.393551	8.98454966	94.44895	107.77737	104.8384	6.118623333333333	130	-6.789013	5.110410213	8.998704	12.303006666666668	0.025	0.1579534	4.632201736	2.38562	135.53543	30.5309735	27.71179314	65.333748426	86.33409	21.361425995	0.19	4
Switzerland	0.9296131398867122	32.35	1.9	100	-1.101253915	4.625229924	8.56741640883676	16.72	99.3172293	173.429315611	1.35	6.6	100	15.79043	132.1828	5.1	-1.193327	31.612511388	51.07563775	12.313333333333334	0.0278476453019586	1.447042892	10.96350675	442.0365935	54697.46682	23.4173357	56431.06833		0.6	3.6	8967	12.61502	87	39	83	13.6	6	12.82348463	140.54	0.013972937	8	39.38	73.08219091	0.4567513	95.74914	99.52254	102.79424	6.056439999999999	82	12.6332	5.276949883	11.46621	10.7542	0.015	0.4594014	49.65939818	2.87046	96.30638	28.4552846	28.90699771	22.673298671	55.5619	9.759124063	0.22	4.2
Denmark	0.9233279260476808	26.88	5.101	100	-1.767732957	7.248328717	23.029973966129116	1.83	106.0577185	199.614502386	1.31	6	100	18.68933	102.8064	4.1	0.4755334	12.915390054	70.58238697	10.75	0.0484322470579875	-0.484064419	26.71585401	235.7224101	41990.51573	18.3244425	44025.48217		0.8	2.9	8557	8.32088	95.99	50	80.2	13.6	5	12.72938824	125.96	1.463290729	2.7	34.24		8.536134407	96.07674	101.75368	101.26672	1.11317	73	-0.124352	8.745690346	10.62326	12.303006666666668	0.01	0.4342917	26.76724503	2.98416	124.65927	37.9888268	9.909512135	39.677938196	79.59763	33.395651012	0.4	3.5
Netherlands	0.9217935118651917	28.87	6.165	100	-0.25273377	10.06448974	5.922602189956794	-4.31	107.4741544	193.011288775	1.38	5.6	100	17.92333	155.5511	4.8	3.761942	10.824436536	91.44745084	11.65	0.0624059806438122	-0.251702124	26.33518498	755.2590028	44944.59267	18.2463744	45435.1166		0.9	3.3	12800	5.42285	93.17	39.46666666666667	81.6	11.7	6	11.88930225	116.42	0.866811752	0.6	31.49	0.006033418	5.352625045	89.04594	90.89967	105.79075	6.056439999999999	82	7.619826	5.930980206	12.8853	11.50226	0.063	0.1834062	6.671365641	2.15676	129.91277	36.8888889	11.72441763	23.533103608	77.34356	19.724058916	0.17	4
Germany	0.9160799076988912	30.63	3.795	100	-0.739740093	8.917832846	3.293447369083502	-4.6	105.692141	113.521434572	1.54	5.6	100	16.45695	85.31842	4.1	1.374354	31.77827509	80.187836	20.95	0.0407289546024232	0.726060184	19.26363598	3483.398236	43206.66066	19.7839458	43918.53597		0.8	3.2	31500	2.78761	86.19	40	80.9	14.5	7	13.06677702	120.42	0.076885776	1.3	38.06	10.09729788	8.085258727	96.64598	112.51651	100.46041	3.75764	79	6.659943	4.979529858	11.29719	11.71402	0.176	0.4233354	20.38880799	2.9191	101.2664	36.8571429	11.90093743	16.25383828	61.65019	11.518237027	0.35	3.9
Ireland	0.9155415619842028	32.06	8.236	100	0.591211929	7.880759326	62.7096774133141	-2.26	104.8396802	186.081408593	1.23	3.3	100	18.56885	189.7978	5.2	21.52736	10.982726085	84.72883027	12.313333333333334	0.1129315369457314	-0.037290291	17.4782253	206.4707637	44931.04202	15.1765979	39568.12085		1.2	3.2	8260	-3.8625	79.69	14.5	80.9	16.9	9	12.2	104.26	0.069177694	2.2	27.19	13.54171627	0.483991792	79.56229	52.436	104.41245	6.118623333333333	88	19.25707	6.154679775	8.921805	16.06046	0.009	0.3095776	6.405793703	1.72382	119.11933	19.9115044	15.89599092	37.823960113	71.24203	22.006956424	0.39	3.8
United States	0.9149593539597776	41.12	31.001	100	-0.692444213	17.02021634	2.982134130241443	11.04	106.8338489	240.546463207	1		100	16.48	30.01294	5.2	1.75912	33.319515229	83.55005184	15.49	0.2799765595892246	-1.322071182	15.19253821	16230.20875	51340.48763	19.3480478	52946.51344	14.93525005	4.7	5.9	69800	3.62564	87.36	35.6	79.1	19.4	28	12.94252883	98.41	0.958708867	3.1	24.52	5073.851216	1.09258942	94.98449	74.27443	98.13031	2.4252166666666666	716	0.6691694	5.226019859	17.09764	14.42216	4.786	0.039927	16.29966924	2.79197	93.67395	19.4392523	14.30557337	53.181714509	94.2767	10.565895957	0.14	6.9
Canada	0.913178984420728	33.68	14.499	100	-0.40164638	14.13581338	1.1728462645521633e-8	17.63	105.4522038	173.054866602	1.25	7.1	100	15.875	61.85041	4.8	3.873133	34.104982564	73.69457159	12.313333333333334	0.1292273423287928	0.579248131	21.67536679	1472.925397	41894.09697	23.7232617	42155.00562	20.64102374	1.6	4.6	16600	3.8092466666666662	87.12	6.4	82	14.9	11	13.00416198	82.98	2.412690401	6.3	20.68	363.9395819	2.682220681	99.99999	71.55781	98.30092	4.6367	118	-2.021756	5.272459984	10.8607	11.17668	0.107	0.0656526	27.89825014	1.72797	103.40475	28.1725888	20.70413929	51.64931625	63.46592333333333	11.531947693	0.19	5.2
New Zealand	0.9134976556492512	28.76333333333333	25.309	100	1.115933201	7.124050867	6.893782371915913	3.07	106.7281728	153.954466358	1.96	8.7	100	19.15634	57.48594	5	-0.2743136	31.340245338	61.43322269	5.26	0.1572014980711076	1.862379329	18.67254022	146.6764056	32807.64194	20.5684371	32689.36246	16.10972323	0.9	5.2	2629	14.02246	85.5	33.1	81.8	14.4	8	12.503	112.05	1.592807025	3.3	27.35	14225.89823	5.257356694	95.15481	91.71803	98.65525	2.48661	192	0.7918984	7.354410172	9.738794	14.58702	0.02	0.2471849	38.37153225	1.2709	119.54439	31.4049587	25.1417685	36.311316741	79.77627	29.274728302	0.08	6.3


CREATE TABLE kaggle (
  "id" VARCHAR,
  "human_development_index_hdi_2014" DOUBLE,
  "gini_coefficient_2005_2013" DOUBLE,
  "adolescent_birth_rate_15_19_per_100k_20102015" DOUBLE,
  "birth_registration_funder_age_5_2005_2013" DOUBLE,
  "carbon_dioxide_emissionsaverage_annual_growth" DOUBLE,
  "carbon_dioxide_emissions_per_capita_2011_tones" DOUBLE,
  "change_forest_percentable_1900_to_2012" DOUBLE,
  "change_mobile_usage_2009_2014" DOUBLE,
  "consumer_price_index_2013" DOUBLE,
  "domestic_credit_provided_by_financial_sector_2013" DOUBLE,
  "domestic_food_price_level_2009_2014_index" DOUBLE,
  "domestic_food_price_level_2009_2014_volitility_index" DOUBLE,
  "electrification_rate_or_population" DOUBLE,
  "expected_years_of_schooling_years" DOUBLE,
  "exports_and_imports_percentage_gpd_2013" DOUBLE,
  "female_suicide_rate_100k_people" DOUBLE,
  "foreign_direct_investment_net_inflows_percentage_gdp_2013" DOUBLE,
  "forest_area_percentage_of_total_land_area_2012" DOUBLE,
  "fossil_fuels_percentage_of_total_2012" DOUBLE,
  "fresh_water_withdrawals_2005" DOUBLE,
  "gender_inequality_index_2014" DOUBLE,
  "general_government_final_consumption_expenditure_annua_87c34934" DOUBLE,
  "general_government_final_consumption_expenditure_perce_79131c7a" DOUBLE,
  "gross_domestic_product_gdp_2013" DOUBLE,
  "gross_domestic_product_gdp_percapta" DOUBLE,
  "gross_fixed_capital_formation_of_gdp_2005_2013" DOUBLE,
  "gross_national_income_gni_per_capita_2011_dollars" DOUBLE,
  "homeless_people_due_to_natural_disaster_2005_2014_per__41c5f21e" DOUBLE,
  "homicide_rate_per_100k_people_2008_2012" DOUBLE,
  "infant_mortality_2013_per_thousands" DOUBLE,
  "international_inbound_tourists_thausands_2013" DOUBLE,
  "international_student_mobility_of_total_tetiary_enrolvemnt_2013" DOUBLE,
  "internet_users_percentage_of_population_2014" DOUBLE,
  "intimate_or_nonintimate_partner_violence_ever_experien_26358a57" DOUBLE,
  "life_expectancy_at_birth_years" DOUBLE,
  "malesuicide_rate_100k_people" DOUBLE,
  "maternal_mortality_ratio_deaths_per_100_live_births_2013" DOUBLE,
  "mean_years_of_schooling_years" DOUBLE,
  "mobile_phone_subscriptions_per_100_people_2014" DOUBLE,
  "natural_resource_depletion" DOUBLE,
  "net_migration_rate_per_1k_people_2010_2015" DOUBLE,
  "physicians_per_10k_people" DOUBLE,
  "population_affected_by_natural_desasters_average_annua_29d58941" DOUBLE,
  "population_living_on_degraded_land_percentage_2010" DOUBLE,
  "population_with_at_least_some_secondary_education_perc_a8f59bca" DOUBLE,
  "pre_primary_2008_2014" DOUBLE,
  "primary_2008_2014" DOUBLE,
  "primary_school_dropout_rate_2008_2014" DOUBLE,
  "prison_population_per_100k_people" DOUBLE,
  "private_capital_flows_percentage_gdp_2013" DOUBLE,
  "public_expenditure_on_education_percentange_gdp" DOUBLE,
  "public_health_expenditure_percentage_of_gdp_2013" DOUBLE,
  "pupil_teacher_ratio_primary_school_pupils_per_teacher_2008_2014" DOUBLE,
  "refugees_by_country_of_origin" DOUBLE,
  "remittances_inflows_percentual_gdp_2013" DOUBLE,
  "renewable_sources_percentage_of_total_2012" DOUBLE,
  "research_and_development_expenditure_2005_2012" DOUBLE,
  "secondary_2008_2014" DOUBLE,
  "share_of_seats_in_parliament_percentage_held_by_womand_2014" DOUBLE,
  "stock_of_immigrants_percentage_of_population_2013" DOUBLE,
  "taxes_on_income_profit_and_capital_gain_205_2013" DOUBLE,
  "tertiary_2008_2014" DOUBLE,
  "total_tax_revenue_of_gdp_2005_2013" DOUBLE,
  "tuberculosis_rate_per_thousands_2012" DOUBLE,
  "under_five_mortality_2013_thousands" DOUBLE
);