History Of War (COW, 2020)
@owid.cow
@owid.cow
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]
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
);CREATE TABLE owid_cow_country (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"participated_in_conflict" INTEGER,
"number_participants" INTEGER
);CREATE TABLE owid_cow_locations (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"is_location_of_conflict" INTEGER,
"number_locations" INTEGER
);Anyone who has the link will be able to view this.