History Of War (PRIO V3.1, 2017)
@owid.prio_v31
@owid.prio_v31
This dataset provides information on armed conflicts, using data from the PRIO Battledeaths Dataset (version 3.1).
We combine these datasets to provide information on the number of ongoing and new conflicts, the number of ongoing and new conflict types, as well as the number of deaths in ongoing conflicts and conflict types.
Deaths of combatants and civilians due to fighting are included.
We use the world regions as defined by PRIO: Africa, Americas, Asia, Europe, and Middle East. The regions are defined based on Gleditsch and Ward codes, as in "UCDP/PRIO Armed Conflict Dataset".
Find the complete mapping at http://ksgleditsch.com/data/iisystem.dat (states) and http://ksgleditsch.com/data/microstatessystem.dat (micro-states).
• Americas: 2-199
• Europe: 200-399
• Africa: 400-626
• Middle East: 630-699
• Asia and Oceania: 700-999
You can find more information about the data in our article: [To be published]
CREATE TABLE owid_prio_v31 (
"year" INTEGER,
"region" VARCHAR,
"conflict_type" VARCHAR,
"number_ongoing_conflicts" INTEGER,
"number_deaths_ongoing_conflicts_battle_low" UINTEGER,
"number_deaths_ongoing_conflicts_battle" INTEGER,
"number_deaths_ongoing_conflicts_battle_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_battle_high_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_battle_low_per_capita" FLOAT,
"number_deaths_ongoing_conflicts_battle_per_capita" FLOAT
);CREATE TABLE owid_prio_v31_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.