Dataset: History Of War (COW, 2020)

About this Dataset

History Of War (COW, 2020)

This dataset provides information on wars, using data from Correlates of War's Inter-State War Data (version 4.0), Intra-State War Data (version 5.1), Extra-State War Data (version 4.0), and Non-State War Data (version 4.0).

We combine these datasets to provide 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, disease, and starvation are included.

We align the world regions across the datasets to be Africa, Americas, Asia, Europe, Middle East, and Oceania. This meant we sometimes had to identify the regions manually. The regions are defined based on Gleditsch and Ward codes. Find the complete mapping at
https://correlatesofwar.org/wp-content/uploads/states2016.csv

• Americas: 2-165

• Europe: 200-399

• Africa: 402-626

• Middle East: 630-698

• Asia and Oceania: 700-999

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

Tables

Cow

@owid.cow.owid_cow

56.03 KB
8208 rows
11 columns


CREATE TABLE owid_cow (
  "year" INTEGER,
  "region" VARCHAR,
  "conflict_type" VARCHAR,
  "number_ongoing_conflicts" INTEGER,
  "number_deaths_ongoing_conflicts" 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_per_capita" FLOAT
);

Cow Country

@owid.cow.owid_cow_country

48.26 KB
262917 rows
5 columns


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

State System Membership

@owid.cow.owid_cow_locations

31.3 KB
80815 rows
5 columns


CREATE TABLE owid_cow_locations (
  "year" INTEGER,
  "country" VARCHAR,
  "conflict_type" VARCHAR,
  "is_location_of_conflict" INTEGER,
  "number_locations" INTEGER
);