Dataset: World Military Personnel Power From 1994 To 2018

About this Dataset

World Military Personnel Power From 1994 To 2018

Context

Like it or hate it, military power is always become one crucial aspect in world's diplomacy. Those who have more personnel or sophisticated weapons are easier to get what they want. And those who don't can find another way to ensure their sovereignty intact but their needs also fulfilled. And we must admit that flexing military power always be a thing for countries in the world. That's why I collected military personnel data from about 126 countries in this world in 25 years range.

Content

What inside this dataset are not only numbers. It also told us the stories about why the numbers goes up and down. We can see the dynamics of the amount of military personnel each countries have per years. Some multiplied, some depleted and unable to regain back.

Not all countries data are in this dataset. I only collect data from countries where military data is available for each year. There are problems with Angola in my dataset, since they are all Null. I'll try to fix it later.

Acknowledgements

All data I collected come from http://www.macrotrends.net/countries/ranking/military-army-size, accessed in March, 2022.

Tables

Military Data

@kaggle.yafethtb_world_military_personnel_power_from_1994_to_2018.military_data

92.04 KB
25 rows
126 columns


CREATE TABLE military_data (
  "year" BIGINT,
  "belize" BIGINT,
  "malta" BIGINT,
  "suriname" BIGINT,
  "luxembourg" BIGINT,
  "guyana" BIGINT,
  "papua_new_guinea" BIGINT,
  "fiji" BIGINT,
  "trinidad_and_tobago" BIGINT,
  "guinea_bissau" BIGINT,
  "jamaica" BIGINT,
  "moldova" BIGINT,
  "estonia" BIGINT,
  "latvia" BIGINT,
  "slovenia" BIGINT,
  "brunei" BIGINT,
  "sierra_leone" BIGINT,
  "ireland" BIGINT,
  "botswana" BIGINT,
  "albania" BIGINT,
  "new_zealand" BIGINT,
  "togo" BIGINT,
  "niger" BIGINT,
  "bosnia" BIGINT,
  "mozambique" BIGINT,
  "nicaragua" BIGINT,
  "denmark" BIGINT,
  "malawi" BIGINT,
  "sweden" BIGINT,
  "slovak_republic" BIGINT,
  "namibia" BIGINT,
  "north_macedonia" BIGINT,
  "zambia" BIGINT,
  "tajikistan" BIGINT,
  "mongolia" BIGINT,
  "croatia" BIGINT,
  "senegal" BIGINT,
  "bahrain" BIGINT,
  "yemen" BIGINT,
  "mauritania" BIGINT,
  "kyrgyz_republic" BIGINT,
  "mali" BIGINT,
  "switzerland" BIGINT,
  "qatar" BIGINT,
  "czech_republic" BIGINT,
  "austria" BIGINT,
  "honduras" BIGINT,
  "norway" BIGINT,
  "kuwait" BIGINT,
  "finland" BIGINT,
  "georgia" BIGINT,
  "paraguay" BIGINT,
  "belgium" BIGINT,
  "serbia" BIGINT,
  "bulgaria" BIGINT,
  "lithuania" BIGINT,
  "hungary" BIGINT,
  "ecuador" BIGINT,
  "netherlands" BIGINT,
  "turkmenistan" BIGINT,
  "el_salvador" BIGINT,
  "guatemala" BIGINT,
  "oman" BIGINT,
  "tunisia" BIGINT,
  "armenia" BIGINT,
  "zimbabwe" BIGINT,
  "portugal" BIGINT,
  "australia" BIGINT,
  "singapore" BIGINT,
  "uae" BIGINT,
  "uzbekistan" BIGINT,
  "kazakhstan" BIGINT,
  "dominican_republic" BIGINT,
  "bolivia" BIGINT,
  "canada" BIGINT,
  "cuba" BIGINT,
  "lebanon" BIGINT,
  "azerbaijan" BIGINT,
  "south_africa" BIGINT,
  "jordan" BIGINT,
  "argentina" BIGINT,
  "nepal" BIGINT,
  "chile" BIGINT,
  "romania" BIGINT,
  "lao" BIGINT,
  "n__pdr" BIGINT,
  "malaysia" BIGINT,
  "greece" BIGINT,
  "united_kingdom" BIGINT,
  "philippines" BIGINT,
  "belarus" BIGINT,
  "peru" BIGINT,
  "israel" BIGINT,
  "germany" BIGINT,
  "cambodia" BIGINT,
  "spain" BIGINT,
  "poland" BIGINT,
  "nigeria" BIGINT,
  "bangladesh" BIGINT,
  "morocco" BIGINT
);