Dataset: Peace Data (Diehl Et Al., 2023)

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.03 KB
98731 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.05 KB
98674 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.46 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.51 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
);