Baselight

History Of War (Project Mars, 2020)

@owid.mars

Loading...
Loading...

About this Dataset

History Of War (Project Mars, 2020)

This dataset provides information on conventional wars, using data from Jason Lyall's Project Mars.

The project provides information on the number of ongoing and new wars, the number of ongoing and new war types, as well as the number of deaths in ongoing wars and war types.

Deaths of combatants due to fighting are included.

We use the world regions as defined by Project Mars. The regions are shown below, along with the codes of the countries in them. Find the complete list of country codes at https://correlatesofwar.org/wp-content/uploads/states2016.csv.

  • Americas: 2-165
  • Europe: 200-395
  • Sub-Saharan Africa: 402-420, 433-434, 437-482, 484-517, 540-591
  • North Africa and the Middle East: 432, 435-436, 483, 520-531, 600-698
  • Asia and Oceania: 700-990

You can find more information about the data in our article: [To be published]

Tables

Mars

@owid.mars.owid_mars
  • 55.9 KB
  • 3816 rows
  • 13 columns
Loading...

CREATE TABLE owid_mars (
  "year" INTEGER,
  "region" VARCHAR,
  "conflict_type" VARCHAR,
  "number_ongoing_conflicts" INTEGER,
  "number_deaths_ongoing_conflicts_low" UINTEGER,
  "number_deaths_ongoing_conflicts_high" UINTEGER,
  "number_new_conflicts" INTEGER,
  "number_ongoing_conflicts_per_country" FLOAT,
  "number_ongoing_conflicts_per_country_pair" FLOAT,
  "number_new_conflicts_per_country" FLOAT,
  "number_new_conflicts_per_country_pair" FLOAT,
  "number_deaths_ongoing_conflicts_high_per_capita" FLOAT,
  "number_deaths_ongoing_conflicts_low_per_capita" FLOAT
);

Mars Country

@owid.mars.owid_mars_country
  • 54.25 KB
  • 86936 rows
  • 5 columns
Loading...

CREATE TABLE owid_mars_country (
  "year" INTEGER,
  "country" VARCHAR,
  "conflict_type" VARCHAR,
  "participated_in_conflict" INTEGER,
  "number_participants" INTEGER
);

Share link

Anyone who has the link will be able to view this.