Socio-Economic Country Profiles

Contains 95 socio-economic metrics of 66 countries

@kaggle.nishanthsalian_socioeconomic_country_profiles

Table List

1 table(122.96 KB)

Soci Econ Country Profiles

@kaggle.nishanthsalian_socioeconomic_country_profiles.soci_econ_country_profiles

122.96 KB
66 rows
96 columns

unnamed_0 Unnamed: 0	country Country	region Region	surface_area_km2 Surface Area (km2)	population_in_thousands_2017 Population In Thousands (2017)	population_density_per_km2_2017 Population Density (per Km2, 2017)	sex_ratio_m_per_100_f_2017 Sex Ratio (m Per 100 F, 2017)	gdp_gross_domestic_product_million_current_us GDP: Gross Domestic Product (million Current US$)	gdp_growth_rate_annual_const_2005_prices GDP Growth Rate (annual %, Const. 2005 Prices)	gdp_per_capita_current_us GDP Per Capita (current US$)	economy_agriculture_of_gva Economy: Agriculture (% Of GVA)	economy_industry_of_gva Economy: Industry (% Of GVA)	economy_services_and_other_activity_of_gva Economy: Services And Other Activity (% Of GVA)	employment_agriculture_of_employed Employment: Agriculture (% Of Employed)	employment_industry_of_employed Employment: Industry (% Of Employed)	employment_services_of_employed Employment: Services (% Of Employed)	unemployment_of_labour_force Unemployment (% Of Labour Force)	labour_force_participation_female_male_pop Labour Force Participation (female/male Pop. %)	agricultural_production_index_2004_2006_100 Agricultural Production Index (2004-2006\u003d100)	food_production_index_2004_2006_100 Food Production Index (2004-2006\u003d100)	international_trade_exports_million_us International Trade: Exports (million US$)	international_trade_imports_million_us International Trade: Imports (million US$)	international_trade_balance_million_us International Trade: Balance (million US$)	balance_of_payments_current_account_million_us Balance Of Payments, Current Account (million US$)	population_growth_rate_average_annual Population Growth Rate (average Annual %)	urban_population_of_total_population_x Urban Population (% Of Total Population) X	urban_population_growth_rate_average_annual Urban Population Growth Rate (average Annual %)	fertility_rate_total_live_births_per_woman Fertility Rate, Total (live Births Per Woman)	population_age_distribution_0_14_60_years Population Age Distribution (0-14 / 60+ Years, %)	international_migrant_stock_000_of_total_pop International Migrant Stock (000/% Of Total Pop.)	refugees_and_others_of_concern_to_unhcr_in_thousands Refugees And Others Of Concern To UNHCR (in Thousands)	infant_mortality_rate_per_1000_live_births Infant Mortality Rate (per 1000 Live Births	health_total_expenditure_of_gdp Health: Total Expenditure (% Of GDP)	health_physicians_per_1000_pop Health: Physicians (per 1000 Pop.)	education_government_expenditure_of_gdp Education: Government Expenditure (% Of GDP)	education_primary_gross_enrol_ratio_f_m_per_100_pop Education: Primary Gross Enrol. Ratio (f/m Per 100 Pop.)	education_secondary_gross_enrol_ratio_f_m_per_100_pop Education: Secondary Gross Enrol. Ratio (f/m Per 100 Pop.)	education_tertiary_gross_enrol_ratio_f_m_per_100_pop Education: Tertiary Gross Enrol. Ratio (f/m Per 100 Pop.)	seats_held_by_women_in_national_parliaments Seats Held By Women In National Parliaments %	mobile_cellular_subscriptions_per_100_inhabitants Mobile-cellular Subscriptions (per 100 Inhabitants)	mobile_cellular_subscriptions_per_100_inhabitants_1 Mobile-cellular Subscriptions (per 100 Inhabitants).1	individuals_using_the_internet_per_100_inhabitants Individuals Using The Internet (per 100 Inhabitants)	threatened_species_number Threatened Species (number)	forested_area_of_land_area Forested Area (% Of Land Area)	co2_emission_estimates_million_tons_tons_per_capita CO2 Emission Estimates (million Tons/tons Per Capita)	energy_production_primary_petajoules Energy Production, Primary (Petajoules)	energy_supply_per_capita_gigajoules Energy Supply Per Capita (Gigajoules)	pop_using_improved_drinking_water_urban_rural Pop. Using Improved Drinking Water (urban/rural, %)	pop_using_improved_sanitation_facilities_urban_rural Pop. Using Improved Sanitation Facilities (urban/rural, %)	net_official_development_assist_received_of_gni Net Official Development Assist. Received (% Of GNI)	quality_of_life_index Quality Of Life Index	purchasing_power_index Purchasing Power Index	safety_index Safety Index	health_care_index Health Care Index	cost_of_living Cost Of Living	property_price_to_income_ratio Property Price To Income Ratio	traffic_commute_time_index Traffic Commute Time Index	pollution_index Pollution Index	climate_index Climate Index	gross_rental_yield_city_center Gross Rental Yield City Center	gross_rental_yield_outside_center Gross Rental Yield Outside Center	property_price_to_rent_ratio_city_center Property Price To Rent Ratio City Center	property_price_to_rent_ratio_outside_center Property Price To Rent Ratio Outside Center	mortgate_as_percentage_of_income Mortgate As Percentage Of Income	affordability_index Affordability Index	cost_of_living_index Cost Of Living Index	rent_index Rent Index	cost_of_living_plus_rent_index Cost Of Living Plus Rent Index	grocery_index Grocery Index	restaurant_price_index Restaurant Price Index	local_purchasing_power_index Local Purchasing Power Index	access_to_electricity_of_population Access To Electricity (% Of Population)	adjusted_net_national_income_per_capita_constant_2010_us Adjusted Net National Income Per Capita (constant 2010 US$)	age_dependency_ratio_of_working_age_population Age Dependency Ratio (% Of Working-age Population)	air_transport_freight_million_ton_km Air Transport, Freight (million Ton-km)	air_transport_passengers_carried Air Transport, Passengers Carried	commercial_service_exports_current_us Commercial Service Exports (current US$)	commercial_service_imports_current_us Commercial Service Imports (current US$)	consumer_price_index_2010_100 Consumer Price Index (2010 \u003d 100)	current_account_balance_of_gdp Current Account Balance (% Of GDP)	current_health_expenditure_of_gdp Current Health Expenditure (% Of GDP)	exports_of_goods_and_services_of_gdp Exports Of Goods And Services (% Of GDP)	gross_domestic_savings_of_gdp Gross Domestic Savings (% Of GDP)	high_technology_exports_current_us High-technology Exports (current US$)	human_capital_index_hci_scale_0_1 Human Capital Index (HCI) (scale 0-1)	imports_of_goods_and_services_of_gdp Imports Of Goods And Services (% Of GDP)	inflation_consumer_prices_annual Inflation, Consumer Prices (annual %)	life_expectancy_at_birth_female_years Life Expectancy At Birth, Female (years)	life_expectancy_at_birth_male_years Life Expectancy At Birth, Male (years)	life_expectancy_at_birth_total_years Life Expectancy At Birth, Total (years)	military_expenditure_of_gdp Military Expenditure (% Of GDP)	population_female Population, Female	population_male Population, Male	tax_revenue_of_gdp Tax Revenue (% Of GDP)	taxes_on_income_profits_and_capital_gains_of_revenue Taxes On Income, Profits And Capital Gains (% Of Revenue)	urban_population_of_total_population_y Urban Population (% Of Total Population) Y
	Argentina	SouthAmerica	2780400	44271	16.2	95.9	632343	2.4	14564.5	6.0	27.8	66.2	2	24.8	73.1	6.5	48.6/74.4	119	119	57733	55610	2124	-15944	1.0	91.8	1.0	2.3	24.9/15.4	2086.3/4.8	5.0	13.7	4.8	3.8	5.3	109.8/110.2	110.3/103.4	102.9/63.5	38.9	143.9	69.4	256	10	204.0/4.7	3167	85	99.0/100.0	96.2/98.3	0.01	-99	139.59	58.4	37.37	73.3	52.57	12.07	37.95	53.33	90.67	3.77	3.9	26.53	25.64	333.23	0.3	52.57	13.92	34.05	44.06	50.37	58.4	100	9094.367252161	56.04635544369761	305.10200000000003	16749271	15274156208.2134	24982416353.4138	112.887108333333	-4.84884981091141	9.12431478500366	11.2427213207093	16.0193423909208	1494147748	0.611	13.9806106427674		79.726	72.92399999999999	76.372	0.856137916373543	22572521	21472290	10.9555014904363	12.9299128513563	91.749
1	Australia	Oceania	7692060	24451	3.2	99.3	1230859	2.4	51352.2	2.5	26.5	71.1	2.7	21.2	76.1	5.5	58.4/70.7	111	111	189630	189406	224	-57746	1.5	89.4	1.5	1.9	19.0/21.0	6763.7/28.2	58.2	3.9	9.4	3.4	5.2	102.1/102.3	133.6/141.3	106.3/75.4	28.7	132.8	84.6	948	16.2	361.3/15.3	15282	222	100.0/100.0	100.0/100.0	-99	-99	176.54	101.94	57.58	74.25	80.66	9.24	34.73	24.58	72.79	4.9	5.05	20.41	19.82	70.87	1.41	80.66	42.54	62.39	76.87	77.12	101.94	100	43073.9671702132	52.599670595728206	1982.586170817	74257326	64296388330.0338	67392204900.9734	115.686784599376	-2.68999652428858	9.20594781637192	21.1932001494647	24.687192926849	4837243928	0.8029999999999999	20.576799969608103	1.94864740944522	84.6	80.5	82.5	2.00796639339341	12349632	12252228	21.915858625435	64.1103056368251	85.904
2	Austria	WesternEurope	83871	8736	106	96.2	376967	1	44117.7	1.3	28.3	70.4	4.7	25.6	69.7	6.2	54.6/65.8	108	108	145503	149299	-3795	7020	0.6	66	0.4	1.4	14.1/25.1	1492.4/17.5	166.4	3.3	11.2	5.2	5.5	102.2/103.7	97.6/102.4	89.2/74.3	30.6	157.4	83.9	118	46.9	58.7/6.9	505	158	100.0/100.0	100.0/100.0	-99	-99	190.37	95.66	80.75	80.91	71.52	9.66	26.27	21.9	62.13	3.63	3.78	27.55	26.46	59.08	1.69	71.52	25.86	49.64	65.86	66.94	95.66	100	39557.6679946118	49.6725857002038	391.268	16171640	66403956922.3678	55455087774.4416	113.999736749152	1.5345140680346	10.3966169059277	54.037671021734894	28.291362874601603	17027611644	0.7929999999999999	50.7355052962123	2.08126858275521	84	79.4	81.64390243902442	0.7561790419805479	4478340	4319226	25.3552369771872	27.0240733573006	58.094
3	Belarus	EasternEurope	207600	9468	46.7	87	54609	-3.9	5750.8	7.5	38.9	53.6	9.6	32	58.4	0.5	54.0/67.8	122	122	23414	27464	-4050	-2037	~0.0	76.7	~0.0	1.6	16.7/21.3	1082.9/11.4	7.9	3.6	5.7	4.1	4.9	101.3/101.4	106.4/107.8	100.7/75.9	34.5	123.6	62.2	25	42.5	63.5/6.7	155	122	99.9/99.1	94.1/95.2	0.20	-99	119.23	36.43	77.74	53.76	33.84	18.73	27.66	39.64	20.07	5.31	4.82	18.85	20.75	587.51	0.17	33.84	12.21	23.47	27.19	37.6	36.43	100	5923.22311762587	45.5244210861446	1.9151	2493100	7883700000	4820200000		-1.74028732403957	5.92578575015068	66.7896002012327	29.891194365483305	687613900		66.5781545217791	6.0318372517778895	79.2	69.3	74.12926829268291	1.16241694312684	5077542	4420722	13.0190056104974	2.9331006348086297	78.134
4	Belgium	WesternEurope	30528	11429	377.5	97.3	455107	1.5	40277.8	0.7	22.2	77.1	1.2	21.2	77.6	8.3	48.1/58.9	108	107	398033	372713	25321	1936	0.6	97.9	0.5	1.8	17.1/24.6	1387.9/12.3	63.8	3.5	10.6	3.0	6.6	104.2/104.2	177.7/156.4	85.4/65.0	38	115.7	85.1	37	22.6	93.4/8.3	520	196	100.0/100.0	99.5/99.4	-99	-99	160.52	91.02	55.49	78.92	75.36	6.96	36.26	48.92	75.16	5.82	5.92	17.18	16.88	44.69	2.24	75.36	29.64	53.44	65.77	82.34	91.02	100	38493.2724438044	55.329079400808105	1574.378609	13676844	115167388267.646	114004179542.095	113.128902605325	1.2267750362186298	10.338669270277	82.38680624975609	25.5049930867712	34397964674	0.757	80.9918274558556	2.12597086002609	83.9	79.2	81.4926829268293	0.910370732936129	5766141	5609017	23.3997209593938	33.727746392633904	97.961
5	Bosnia and Herzegovina	SouthernEurope	51209	3507	68.8	96.4	16251	3.1	4265	7.3	26.5	66.2	18	30.4	51.7	25.4	34.3/57.5	96	97	5327	9130	-3803	-923	-1.0	39.8	0.1	1.3	14.1/23.4	34.8/0.9	157.6	7.6	9.6	1.9	-99	-99	-99	-99	21.4	90.2	65.1	91	42.7	22.2/5.8	252	85	99.7/100.0	98.9/92.0	2.20	-99	139.14	51.29	59.03	61.49	35.05	11.35	26.63	60.69	73.29	3.41	3.31	29.36	30.18	104.89	0.95	35.05	6.22	21.23	29.76	24.22	51.29	100	5061.66690367064	43.9790668132436			2006406620.98605	657386055.099024	102.85158612695	-4.33992505123469	8.93166735768318	40.830587810769	1.771104673897	236675619	0.618	57.04359002642671	0.8101333219530471	79.581	74.622	77.128	0.906093302475231	1709258	1642269	20.2593374095498	8.22683714661225	47.876000000000005
6	Brazil	SouthAmerica	8515767	209288	25	96.6	1772591	-3.8	8528.3	5.2	22.7	72	15.2	21.5	63.2	12.4	56.0/78.2	135	136	185235	137552	47683	-58882	0.9	85.7	1.2	1.8	21.7/12.6	713.6/0.3	41.1	15.8	8.3	1.9	6.0	113.8/116.8	102.2/97.2	59.3/42.4	10.7	126.6	59.1	990	59.2	529.8/2.6	10948	61	100.0/87.0	88.0/51.5	0.06	-99	96.15	42.38	29.38	51.7	53.07	16.96	46.39	61.17	70.76	4.01	4.02	24.92	24.85	224.6	0.45	53.07	15.52	35.07	41.65	42.33	42.38	100	9359.89169634609	43.450060748941794	1736.549227	96395709	33676596772.93	70369731833.56	155.668786230018	-0.727859993379999	9.46747660636902	12.5230753666957	15.348823291108902	10756516887	0.56	11.804638359465802	3.4463733503267204	79.156	71.804	75.456	1.41952663807017	105601740	102232091	13.615780876239	24.9622611349703	86.309
7	Bulgaria	EasternEurope	111002	7085	65.3	94.6	48953	3	6846.8	5.1	27.6	67.2	6.5	29.4	64.1	8.1	48.5/60.1	117	119	26088	28875	-2787	196	-0.6	73.9	-0.3	1.5	14.2/27.7	102.1/1.4	33.7	8.3	8.4	4.0	4.1	96.7/97.7	97.4/100.5	82.9/65.4	19.2	129.3	56.7	104	35.1	42.4/5.9	474	103	99.6/99.0	86.8/83.7	-99	-99	138.2	51.4	59.82	54.03	36.49	9.07	27.92	63.12	77.05	5.36	5.68	18.65	17.59	77.24	1.29	36.49	8.91	23.27	30.49	29.56	51.4	100	7224.353984864671	54.3265513629189	1.7189599999999998	1133069	9383450000	5879280000	107.938957188495	3.59956827691833	8.095603436231611	67.3035598741689	24.2251906503994	1684916675	0.6759999999999999	62.9680088765738	2.06435506312528	78.4	71.4	74.81463414634149	1.42170625732142	3636886	3439061	20.1081515255189	16.86693626951	74.669
8	Canada	NorthernAmerica	9984670	36624	4	98.5	1552808	0.9	43205.6	1.8	28.6	69.6	2.1	19.5	78.4	7.1	60.7/69.9	109	109	388911	402954	-14043	-53083	1.0	81.8	1.2	1.6	16.0/23.5	7835.5/21.8	155.8	4.7	10.4	2.5	5.3	101.1/100.1	110.0/109.8	.../...	26.3	81.9	88.5	122	38.2	537.2/15.1	19276	324	100.0/99.0	100.0/99.0	-99	-99	167.18	108.01	60.75	69.23	70.16	6.4	36.24	26.54	44.31	5.47	6.16	18.29	16.23	42.14	2.37	70.16	29.84	50.83	69.26	65.65	108.01	100	41350.0699269085	48.6160745277263	2840.9851350232	91404001	93063926790.1683	111157192260.8	111.984831139096	-2.81404646394062	10.5727694928646	31.4105273580442	21.322801709582897	27599664924	0.799	33.6232145334166	1.5968841285297	84.1	79.9	81.94878048780491	1.2933951067783702	18418770	18124551	12.7154317836521	54.9120234604106	81.35
9	Chile	SouthAmerica	756102	18055	24.3	98.2	240796	2.3	13416.2	3.9	32.8	63.3	9.6	22.9	67.5	6.8	50.7/74.7	111	111	59884	58804	1080	-4761	0.9	89.5	1.1	1.8	20.3/16.0	469.4/2.6	3.7	7.4	7.8	...	4.9	100.0/103.3	101.3/100.0	94.4/83.0	15.8	129.5	64.3	197	23.4	82.6/4.7	540	85	99.7/93.3	100.0/90.9	0.02	-99	136.2	61.28	52.5	60.97	50.09	10.67	35.7	67.67	89.39	4.42	5.06	22.64	19.77	83.59	1.2	50.09	15.43	33.48	43.19	44.38	61.28	100	10980.762997382	45.3828389358575	1237.960141	17664974	9763417564.2942	13194488376.6783	125.566544829069	-2.15290830965023	8.983509987592699	28.439500474910304	22.4799188188258	623854353	0.674	27.2161650772848	2.18271846868523	82.333	77.333	79.90899999999999	1.93561273288572	9373185	9097254	17.462826293603698	36.5514783039443	87.49


CREATE TABLE soci_econ_country_profiles (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "region" VARCHAR,
  "surface_area_km2" BIGINT,
  "population_in_thousands_2017" BIGINT,
  "population_density_per_km2_2017" DOUBLE,
  "sex_ratio_m_per_100_f_2017" DOUBLE,
  "gdp_gross_domestic_product_million_current_us" BIGINT,
  "gdp_growth_rate_annual_const_2005_prices" DOUBLE,
  "gdp_per_capita_current_us" DOUBLE,
  "economy_agriculture_of_gva" VARCHAR,
  "economy_industry_of_gva" DOUBLE,
  "economy_services_and_other_activity_of_gva" DOUBLE,
  "employment_agriculture_of_employed" DOUBLE,
  "employment_industry_of_employed" DOUBLE,
  "employment_services_of_employed" DOUBLE,
  "unemployment_of_labour_force" DOUBLE,
  "labour_force_participation_female_male_pop" VARCHAR,
  "agricultural_production_index_2004_2006_100" BIGINT,
  "food_production_index_2004_2006_100" BIGINT,
  "international_trade_exports_million_us" BIGINT,
  "international_trade_imports_million_us" BIGINT,
  "international_trade_balance_million_us" BIGINT,
  "balance_of_payments_current_account_million_us" BIGINT,
  "population_growth_rate_average_annual" VARCHAR,
  "urban_population_of_total_population_x" DOUBLE,
  "urban_population_growth_rate_average_annual" VARCHAR,
  "fertility_rate_total_live_births_per_woman" DOUBLE,
  "population_age_distribution_0_14_60_years" VARCHAR,
  "international_migrant_stock_000_of_total_pop" VARCHAR,
  "refugees_and_others_of_concern_to_unhcr_in_thousands" VARCHAR,
  "infant_mortality_rate_per_1000_live_births" DOUBLE,
  "health_total_expenditure_of_gdp" DOUBLE,
  "health_physicians_per_1000_pop" VARCHAR,
  "education_government_expenditure_of_gdp" VARCHAR,
  "education_primary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR,
  "education_secondary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR,
  "education_tertiary_gross_enrol_ratio_f_m_per_100_pop" VARCHAR,
  "seats_held_by_women_in_national_parliaments" DOUBLE,
  "mobile_cellular_subscriptions_per_100_inhabitants" DOUBLE,
  "mobile_cellular_subscriptions_per_100_inhabitants_1" DOUBLE,
  "individuals_using_the_internet_per_100_inhabitants" BIGINT,
  "threatened_species_number" DOUBLE,
  "forested_area_of_land_area" VARCHAR,
  "co2_emission_estimates_million_tons_tons_per_capita" BIGINT,
  "energy_production_primary_petajoules" BIGINT,
  "energy_supply_per_capita_gigajoules" VARCHAR,
  "pop_using_improved_drinking_water_urban_rural" VARCHAR,
  "pop_using_improved_sanitation_facilities_urban_rural" VARCHAR,
  "net_official_development_assist_received_of_gni" BIGINT,
  "quality_of_life_index" DOUBLE,
  "purchasing_power_index" DOUBLE,
  "safety_index" DOUBLE,
  "health_care_index" DOUBLE,
  "cost_of_living" DOUBLE,
  "property_price_to_income_ratio" DOUBLE,
  "traffic_commute_time_index" DOUBLE,
  "pollution_index" DOUBLE,
  "climate_index" DOUBLE,
  "gross_rental_yield_city_center" DOUBLE,
  "gross_rental_yield_outside_center" DOUBLE,
  "property_price_to_rent_ratio_city_center" DOUBLE,
  "property_price_to_rent_ratio_outside_center" DOUBLE,
  "mortgate_as_percentage_of_income" DOUBLE,
  "affordability_index" DOUBLE,
  "cost_of_living_index" DOUBLE,
  "rent_index" DOUBLE,
  "cost_of_living_plus_rent_index" DOUBLE,
  "grocery_index" DOUBLE,
  "restaurant_price_index" DOUBLE,
  "local_purchasing_power_index" DOUBLE,
  "access_to_electricity_of_population" DOUBLE,
  "adjusted_net_national_income_per_capita_constant_2010_us" DOUBLE,
  "age_dependency_ratio_of_working_age_population" DOUBLE,
  "air_transport_freight_million_ton_km" DOUBLE,
  "air_transport_passengers_carried" DOUBLE,
  "commercial_service_exports_current_us" DOUBLE,
  "commercial_service_imports_current_us" DOUBLE,
  "consumer_price_index_2010_100" DOUBLE,
  "current_account_balance_of_gdp" DOUBLE,
  "current_health_expenditure_of_gdp" DOUBLE,
  "exports_of_goods_and_services_of_gdp" DOUBLE,
  "gross_domestic_savings_of_gdp" DOUBLE,
  "high_technology_exports_current_us" DOUBLE,
  "human_capital_index_hci_scale_0_1" DOUBLE,
  "imports_of_goods_and_services_of_gdp" DOUBLE,
  "inflation_consumer_prices_annual" DOUBLE,
  "life_expectancy_at_birth_female_years" DOUBLE,
  "life_expectancy_at_birth_male_years" DOUBLE,
  "life_expectancy_at_birth_total_years" DOUBLE,
  "military_expenditure_of_gdp" DOUBLE,
  "population_female" DOUBLE,
  "population_male" DOUBLE,
  "tax_revenue_of_gdp" DOUBLE,
  "taxes_on_income_profits_and_capital_gains_of_revenue" DOUBLE,
  "urban_population_of_total_population_y" DOUBLE
);