Dataset: UCDP, History Of War (preview)

About this Dataset

UCDP, History Of War (preview)

This dataset provides information on armed conflicts, using data from the UCDP Georeferenced Event Dataset (version 24.1), the UCDP/PRIO Armed Conflict Dataset (version 24.1), the UCDP Battle-Related Deaths Dataset (version 24.1), and the UCDP Candidate Event Dataset (version 24.X).

Its difference with the main "UCDP, History of war" dataset is that it includes data up to the latest available, using preliminary data from the UCDP Candidate Event Dataset.

We aggregate the UCDP Georeferenced Event Dataset up to the year and world (region) to identify all conflict deaths, non-state conflicts, and one-sided violence.

We use the UCDP/PRIO Armed Conflict Dataset to identify state-based conflicts: interstate, intrastate (all, internationalized, and non-internationalized), and extrasystemic.

We use the UCDP Battle-Related Deaths Dataset to link deaths in the Georeferenced Event Dataset to types of state-based conflicts in the UCDP/PRIO Armed Conflict Dataset.

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.

The Georeferenced Event Dataset has been extracted from the UCDP systems at a certain point in time. However, the UCDP team works with the data all year round, including revisions and updates. Therefore, their dashboard
might show slightly more up-to-date data, which sometimes result in minor discrepancies in the data.

We use the world regions as defined by UCDP/PRIO: Africa, Americas, Asia, Europe, and Middle East. These are defined based on Gleditsch and Ward codes. 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]

This dataset contains information on armed conflicts - state, non-state and one-sided conflicts, in the period of 1989 and 2022.

Tables

Ucdp Preview 1

@owid.ucdp_preview.owid_ucdp_preview_1

106.96 KB
3708 rows
18 columns


CREATE TABLE owid_ucdp_preview_1 (
  "year" INTEGER,
  "region" VARCHAR,
  "conflict_type" VARCHAR,
  "number_deaths_ongoing_conflicts" UINTEGER,
  "number_deaths_ongoing_conflicts_high" UINTEGER,
  "number_deaths_ongoing_conflicts_low" UINTEGER,
  "number_deaths_ongoing_conflicts_civilians" UINTEGER,
  "number_deaths_ongoing_conflicts_unknown" INTEGER,
  "number_deaths_ongoing_conflicts_combatants" UINTEGER,
  "number_ongoing_conflicts" INTEGER,
  "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,
  "number_deaths_ongoing_conflicts_high_per_capita" FLOAT,
  "number_deaths_ongoing_conflicts_low_per_capita" FLOAT
);

Battle-Related Deaths

@owid.ucdp_preview.owid_ucdp_preview_2

420.68 KB
77508 rows
18 columns


CREATE TABLE owid_ucdp_preview_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "conflict_type" VARCHAR,
  "number_deaths_ongoing_conflicts" UINTEGER,
  "number_deaths_ongoing_conflicts_high" UINTEGER,
  "number_deaths_ongoing_conflicts_low" UINTEGER,
  "number_deaths_ongoing_conflicts_civilians" UINTEGER,
  "number_deaths_ongoing_conflicts_unknown" INTEGER,
  "number_deaths_ongoing_conflicts_combatants" UINTEGER,
  "number_ongoing_conflicts" INTEGER,
  "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,
  "number_deaths_ongoing_conflicts_high_per_capita" FLOAT,
  "number_deaths_ongoing_conflicts_low_per_capita" FLOAT
);

Ucdp Preview Country 1

@owid.ucdp_preview.owid_ucdp_preview_country_1

27.67 KB
91943 rows
5 columns


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

Ucdp Preview Country 2

@owid.ucdp_preview.owid_ucdp_preview_country_2

27.67 KB
91943 rows
5 columns


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

Battle-Related Deaths

@owid.ucdp_preview.owid_ucdp_preview_locations_1

296 KB
70209 rows
14 columns


CREATE TABLE owid_ucdp_preview_locations_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "conflict_type" VARCHAR,
  "number_deaths" UINTEGER,
  "number_deaths_high" UINTEGER,
  "number_deaths_low" UINTEGER,
  "number_deaths_civilians" UINTEGER,
  "number_deaths_unknown" INTEGER,
  "number_deaths_combatants" UINTEGER,
  "is_location_of_conflict" INTEGER,
  "death_rate" FLOAT,
  "death_rate_high" FLOAT,
  "death_rate_low" FLOAT,
  "number_locations" INTEGER
);

Battle-Related Deaths

@owid.ucdp_preview.owid_ucdp_preview_locations_2

16.93 KB
68364 rows
5 columns


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