History Of War (Project Mars, 2020)
@owid.mars
@owid.mars
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.
You can find more information about the data in our article: [To be published]
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
);CREATE TABLE owid_mars_country (
"year" INTEGER,
"country" VARCHAR,
"conflict_type" VARCHAR,
"participated_in_conflict" INTEGER,
"number_participants" INTEGER
);Anyone who has the link will be able to view this.