All Countries Details.

All Details by countries (Globally)

@kaggle.adityakishor1_all_countries_details

Table List

1 table(125.44 KB)

All Countries

@kaggle.adityakishor1_all_countries_details.all_countries

125.44 KB
194 rows
64 columns

country Country	country_long Country Long	currency Currency	capital_city Capital City	region Region	continent Continent	demonym Demonym	latitude Latitude	longitude Longitude	agricultural_land Agricultural Land	forest_area Forest Area	land_area Land Area	rural_land Rural Land	urban_land Urban Land	central_government_debt_pct_gdp Central Government Debt Pct Gdp	expense_pct_gdp Expense Pct Gdp	gdp Gdp	inflation Inflation	self_employed_pct Self Employed Pct	tax_revenue_pct_gdp Tax Revenue Pct Gdp	unemployment_pct Unemployment Pct	vulnerable_employment_pct Vulnerable Employment Pct	electricity_access_pct Electricity Access Pct	alternative_nuclear_energy_pct Alternative Nuclear Energy Pct	electricty_production_coal_pct Electricty Production Coal Pct	electricty_production_hydroelectric_pct Electricty Production Hydroelectric Pct	electricty_production_gas_pct Electricty Production Gas Pct	electricty_production_nuclear_pct Electricty Production Nuclear Pct	electricty_production_oil_pct Electricty Production Oil Pct	electricty_production_renewable_pct Electricty Production Renewable Pct	energy_imports_pct Energy Imports Pct	fossil_energy_consumption_pct Fossil Energy Consumption Pct	renewable_energy_consumption_pct Renewable Energy Consumption Pct	co2_emissions Co2 Emissions	methane_emissions Methane Emissions	nitrous_oxide_emissions Nitrous Oxide Emissions	greenhouse_other_emissions Greenhouse Other Emissions	urban_population_under_5m Urban Population Under 5m	health_expenditure_pct_gdp Health Expenditure Pct Gdp	health_expenditure_capita Health Expenditure Capita	hospital_beds Hospital Beds	hiv_incidence Hiv Incidence	suicide_rate Suicide Rate	armed_forces Armed Forces	internally_displaced_persons Internally Displaced Persons	military_expenditure_pct_gdp Military Expenditure Pct Gdp	birth_rate Birth Rate	death_rate Death Rate	fertility_rate Fertility Rate	internet_pct Internet Pct	life_expectancy Life Expectancy	net_migration Net Migration	population_female Population Female	population_male Population Male	population Population	women_parliament_seats_pct Women Parliament Seats Pct	rural_population Rural Population	urban_population Urban Population	press Press	democracy_score Democracy Score	democracy_type Democracy Type	median_age Median Age	political_leader Political Leader	title Title
Afghanistan	Islamic State of Afghanistan	Afghan afghani	Kabul	Southern Asia	Asia	Afghan	33	65	383560	12084.4	652230	636173	3993.84		39.2201	14583100000	2.30237	84.3339	9.89845	11.71	82.6907	97.7										17.86	8709.47	16222	4863.39	-1800		16.8261	81.3198	0.39	0.04	4.1	278000	4394000	1.35886	35.842	7.344	4.643	18.4	62	-183672	20362329	20766442	41128771	27.0161	30181937	10946834	2.14	2.97	Authoritarian	12.9	Ashraf Ghani	President
Albania	Republic of Albania	Albanian lek	Tirana	Southern Europe	Europe	Albanian	41	20	11655.5	7889	27400	27331.6	827.694	82.3836	24.5363	18882100000	6.7252	53.0455	18.1986	11.808	50.0624	100	24.548		100					13.798	61.4218	44.58	4383.2	2692.2	1015.19	11.6814	6.36726	6.65959	350.835	2.89	0.03	4.3	8000		1.41564	10.24	11.325	1.39	79.32	76	-10612	1391085	1384548	2775634	35.7143	1004807	1770827	2.62	5.98	Hybrid regime	33.7	Edi Rama	Prime Minister
Algeria	People's Democratic Republic of Algeria	Algerian dinar	Algiers	Northern Africa	Africa	Algerian	28	3	413588	19490	2381740	2305480	9357.1			191913000000	9.26552	30.5259		11.55	26.0712	99.7878	0.030106		0.210762	98.3575		1.31981	0.111922	-177.124	99.9779	0.15	161563	86543.9	12578.7	-7720.56	1.12475	6.32118	214.852	1.9	0.04	2.5	317000	2500	5.59258	21.524	4.546	2.889	70.77	76	-18797	22040987	22862237	44903225	8.10811	11328186	33575039	1.71	3.5	Authoritarian	24	Abdelmadjid Tebboune	President
Andorra	Principality of Andorra	Euro	Andorra la Vella	Southern Europe	Europe	Andorran	42.5	1.5	187.2	160	470	409.497	30.9358			3352030000						100										20.59	448.884	53.601	1.75881			9.05176	3336.92	2.5						7	3.9	1.27	93.8975		1377	39038	40786	79824	46.4286	9730	70094	3.17		Unknown	38.9	Xavier Espot Zamora	Head of Government
Angola	People's Republic of Angola	Angolan kwanza	Luanda	Middle Africa	Africa	Angolan	-12.5	18.5	569525	666074	1246700	1251000	2991.35		16.685	106714000000	25.7543	65.8522	10.0904	10.209	61.3252	48.2239	2.54884		53.1749			46.8251		-540.997	48.3056	61.02	19814.5	32703.2	17757.9	5203.07	1.22031	2.91183	50.7426	0.8	0.52	6.1	117000		1.13206	38.809	8.009	5.304	32.6023	62	29089	17998220	17590767	35588987	33.6364	11359649	24229338	2.24	3.62	Authoritarian	12.4	João Lourenço	President
Antigua and Barbuda	Antigua and Barbuda	East Caribbean dollar	Saint John's	Caribbean	Americas	Antiguan	17.05	-61.8	90	81.2	440	396.335	31.8633			1757600000	7.53108					100										0.72	474.6	204.866	11.7635	471.237	3.97656	5.61473	830.34	2.89		0.4				12.115	6.365	1.58	95.6634	78		48981	44782	93763	11.1111	70935	22828			Unknown	31.1	Gaston Browne	Prime Minister
Argentina	Argentine Republic	Argentine peso	Buenos Aires	South America	Americas	Argentine	-34	-64	1083820	285730	2736690	2735390	11432.7		22.8656	632770000000		28.6018	11.4844	6.491	25.4633	100	5.5015	2.02957	26.2416	49.4823	4.16673	15.4232	1.89849	13.0294	87.7224	9.84	154536	131036	51061.5	3701.73	0.896205	9.98438	863.714	4.99	0.11	8.4	103000		0.565318	13.902	8.955	1.885	87.1507	75	2344	23345532	22889298	46234830	44.7471	3538352	42696478	2.76	7.02	Flawed democracy	27.6	Alberto Fernández	President
Armenia	Republic of Armenia	Armenian dram	Yerevan	Western Asia	Asia	Armenian	40	45	16760	3284.7	28470	27342.2	922.335	60.1562	25	19502800000	8.64091	30.5691	22.0288	12.557	29.0658	100	25.7183		28.2857	35.9149	31.8065		0.0512886	71.3413	74.5619	8.38	6746.6	2319.92	1173.58	722.155		12.241	551.543	4.2		3.3	49000	8400	4.44012	12.049	13.007	1.575	78.6123	72	-12825	1530390	1250079	2780469	35.514	1012841	1767628	2.7	4.79	Hybrid regime	30.8	Nikol Pashinyan	Prime Minister
Australia	Commonwealth of Australia	Australian dollar	Canberra	Australia and New Zealand	Oceania	Australian	-27	133	3557750	1340050	7692020	7650420	11946	70.1764	32.7189	1675420000000	6.5941	16.6016	23.1275	3.661	10.7567	100	2.15439	62.8716	5.29618	20.7955		2.69506	8.34166	-190.191	89.6256	10.89	378997	131485	49331.8	-17268.7	2.70968	10.649	5901.11	3.84	0.02	12.5	59000		1.97842	12.1	6.7	1.7	96.24	83	117929	13079142	12899794	25978935	38.4106	3510274	22468661	4.73	9.09	Full democracy	33.3	Anthony Albanese	Prime Minister
Austria	Republic of Austria	Euro	Vienna	Western Europe	Europe	Austrian	47.33333333	13.33333333	26467.6	38991.5	82520	80030.9	2973.71	94.321	49.9715	471400000000	8.54687	11.7563	25.783	4.707	7.48276	100	12.2129	8.22661	59.9971	12.6014		1.39404	16.4937	63.5449	65.6618	35.77	59142.4	6863.08	3759.74	-8604.11		12.1736	6491.12	7.27		14.6	22000		0.802122	9.6	10.3	1.48	92.5292	81	20314	4590655	4451873	9042528	40.9836	3684288	5358240	5.1	8.29	Full democracy	39	Sebastian Kurz	Federal Chancellor


CREATE TABLE all_countries (
  "country" VARCHAR,
  "country_long" VARCHAR,
  "currency" VARCHAR,
  "capital_city" VARCHAR,
  "region" VARCHAR,
  "continent" VARCHAR,
  "demonym" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "agricultural_land" DOUBLE,
  "forest_area" DOUBLE,
  "land_area" DOUBLE,
  "rural_land" DOUBLE,
  "urban_land" DOUBLE,
  "central_government_debt_pct_gdp" DOUBLE,
  "expense_pct_gdp" DOUBLE,
  "gdp" DOUBLE,
  "inflation" DOUBLE,
  "self_employed_pct" DOUBLE,
  "tax_revenue_pct_gdp" DOUBLE,
  "unemployment_pct" DOUBLE,
  "vulnerable_employment_pct" DOUBLE,
  "electricity_access_pct" DOUBLE,
  "alternative_nuclear_energy_pct" DOUBLE,
  "electricty_production_coal_pct" DOUBLE,
  "electricty_production_hydroelectric_pct" DOUBLE,
  "electricty_production_gas_pct" DOUBLE,
  "electricty_production_nuclear_pct" DOUBLE,
  "electricty_production_oil_pct" DOUBLE,
  "electricty_production_renewable_pct" DOUBLE,
  "energy_imports_pct" DOUBLE,
  "fossil_energy_consumption_pct" DOUBLE,
  "renewable_energy_consumption_pct" DOUBLE,
  "co2_emissions" DOUBLE,
  "methane_emissions" DOUBLE,
  "nitrous_oxide_emissions" DOUBLE,
  "greenhouse_other_emissions" DOUBLE,
  "urban_population_under_5m" DOUBLE,
  "health_expenditure_pct_gdp" DOUBLE,
  "health_expenditure_capita" DOUBLE,
  "hospital_beds" DOUBLE,
  "hiv_incidence" DOUBLE,
  "suicide_rate" DOUBLE,
  "armed_forces" DOUBLE,
  "internally_displaced_persons" DOUBLE,
  "military_expenditure_pct_gdp" DOUBLE,
  "birth_rate" DOUBLE,
  "death_rate" DOUBLE,
  "fertility_rate" DOUBLE,
  "internet_pct" DOUBLE,
  "life_expectancy" DOUBLE,
  "net_migration" BIGINT,
  "population_female" BIGINT,
  "population_male" BIGINT,
  "population" BIGINT,
  "women_parliament_seats_pct" DOUBLE,
  "rural_population" BIGINT,
  "urban_population" BIGINT,
  "press" DOUBLE,
  "democracy_score" DOUBLE,
  "democracy_type" VARCHAR,
  "median_age" DOUBLE,
  "political_leader" VARCHAR,
  "title" VARCHAR
);