Dataset: History Of War (Project Mars, 2020)

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


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


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