Baselight

History Of War (UCDP, 2023)

@owid.ucdp

Loading...
Loading...

About this Dataset

History Of War (UCDP, 2023)

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

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

States In Regions (Gleditsch)

@owid.ucdp.owid_ucdp_1
  • 81.36 KB
  • 3384 rows
  • 15 columns
Loading...

CREATE TABLE owid_ucdp_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_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 2

@owid.ucdp.owid_ucdp_2
  • 406.93 KB
  • 68013 rows
  • 18 columns
Loading...

CREATE TABLE owid_ucdp_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
);

List Of Independent States

@owid.ucdp.owid_ucdp_country_1
  • 26.99 KB
  • 82156 rows
  • 5 columns
Loading...

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

List Of Independent States

@owid.ucdp.owid_ucdp_country_2
  • 27.29 KB
  • 83577 rows
  • 5 columns
Loading...

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

List Of Independent States

@owid.ucdp.owid_ucdp_locations_1
  • 213.27 KB
  • 57392 rows
  • 11 columns
Loading...

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

List Of Independent States

@owid.ucdp.owid_ucdp_locations_2
  • 15.56 KB
  • 59080 rows
  • 5 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.