About this Dataset

Peace Data (Diehl Et Al., 2023)

This dataset provides information on the relationships between countries, using data from Diehl et al. (2023).

We aggregate the data to the year and world (region).

The data distinguishes five types of relationships between a pair of countries: severe rivalry, lesser rivalry, negative peace, warm peace, and security community.

It does not include country pairs without any relationship.

Tables

Peace Diehl 1

@owid.peace_diehl.owid_peace_diehl_1

26.66 kB
98,731 rows
4 columns

CREATE TABLE owid_peace_diehl_1 (
  "code_1" INTEGER,
  "code_2" INTEGER,
  "year" INTEGER,
  "peace_scale_level" FLOAT
);

Peace Data

@owid.peace_diehl.owid_peace_diehl_2

26.67 kB
98,674 rows
4 columns

CREATE TABLE owid_peace_diehl_2 (
  "code_1" INTEGER,
  "code_2" INTEGER,
  "year" INTEGER,
  "peace_scale_level" FLOAT
);

Peace Diehl Agg 1

@owid.peace_diehl.owid_peace_diehl_agg_1

13.78 kB
847 rows
8 columns

CREATE TABLE owid_peace_diehl_agg_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "lesser_rivalry" INTEGER,
  "negative_peace" INTEGER,
  "security_community" INTEGER,
  "severe_rivalry" INTEGER,
  "warm_peace" INTEGER,
  "no_relation" INTEGER
);

Peace Data

@owid.peace_diehl.owid_peace_diehl_agg_2

13.83 kB
847 rows
8 columns

CREATE TABLE owid_peace_diehl_agg_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "lesser_rivalry" INTEGER,
  "negative_peace" INTEGER,
  "security_community" INTEGER,
  "severe_rivalry" INTEGER,
  "warm_peace" INTEGER,
  "no_relation" INTEGER
);