Dataset: Wars Since 1816

About this Dataset

Wars Since 1816

Data behind the Economist's article: https://www.economist.com/interactive/international/2022/10/24/vladimir-putin-is-dragging-the-world-back-to-a-bloodier-time

Sources:

The Correlates of War Project
- Sarkees, Meredith Reid and Frank Wayman (2010). Resort to War: 1816 – 2007. Washington DC: CQ Press.
- Zeev Maoz, Paul L. Johnson, Jasper Kaplan, Fiona Ogunkoya, and Aaron Shreve 2019. The Dyadic Militarized Interstate Disputes (MIDs) Dataset Version 3.0: Logic, Characteristics, and Comparisons to Alternative Datasets, Journal of Conflict Resolution (forthcoming).
- Braithwaite, A. 2010. “MIDLOC: Introducing the Militarized Interstate Dispute (MID) Location Dataset.” Journal of Peace Research 47(1): 91-98.
- Bezerra, P., & Braithwaite, A. 2019. Codebook for the Militarized Interstate Dispute Location (MIDLOC-A/I) Dataset, v2.1.
- Tir, Jaroslav, Philip Schafer, Paul Diehl, and Gary Goertz. 1998. “Territorial Changes, 1816-1996: Procedures and Data”, Conflict Management and Peace Science 16:89-97.
Pettersson, Therese, Shawn Davis, Amber Deniz, Garoun Engström, Nanar Hawach, Stina Högbladh, Margareta Sollenberg & Magnus Öberg (2021). Organized violence 1989-2020, with a special emphasis on Syria. Journal of Peace Research 58(4).; Bethany Lacina & and Nils Petter Gleditsch, 2005. „Monitoring Trends in Global Combat: A New Dataset of Battle Deaths‟, European Journal of Population 21(2–3): 145–116.
Our World In Data
World Bank
Encyclopedia Britannica

We thank Kristian Skrede Gleditsch, Dan Altman, Paul F. Diehl, and Jaroslav Tir for providing useful context on these numbers.

Suggested citation
The Economist and Solstad, S. (corresponding author), 2022. Vladimir Putin is dragging the world back to a bloodier time. [online] The Economist. Available at: https://www.economist.com/interactive/international/2022/10/24/vladimir-putin-is-dragging-the-world-back-to-a-bloodier-time [Published October 25th, 2022].

Tables

Conquests Since 1816

@kaggle.joebeachcapital_wars_since_1816.conquests_since_1816

8.96 KB
123 rows
8 columns


CREATE TABLE conquests_since_1816 (
  "year" BIGINT,
  "country_gaining" VARCHAR,
  "iso3c_gaining" VARCHAR,
  "country_losing" VARCHAR,
  "iso3c_losing" VARCHAR,
  "type" VARCHAR,
  "pop" VARCHAR,
  "area" DOUBLE
);

Conquests Since 1945

@kaggle.joebeachcapital_wars_since_1816.conquests_since_1945

6.54 KB
21 rows
8 columns


CREATE TABLE conquests_since_1945 (
  "year" BIGINT,
  "country_gaining" VARCHAR,
  "iso3c_gaining" VARCHAR,
  "country_losing" VARCHAR,
  "iso3c_losing" VARCHAR,
  "type" VARCHAR,
  "pop" BIGINT,
  "area" DOUBLE
);

Territorial Changes Since 1816

@kaggle.joebeachcapital_wars_since_1816.territorial_changes_since_1816

24.28 KB
842 rows
8 columns


CREATE TABLE territorial_changes_since_1816 (
  "year" BIGINT,
  "country_gaining" VARCHAR,
  "iso3c_gaining" VARCHAR,
  "country_losing" VARCHAR,
  "iso3c_losing" VARCHAR,
  "type" VARCHAR,
  "pop" VARCHAR,
  "area" VARCHAR
);

Territorial Changes Since 1945

@kaggle.joebeachcapital_wars_since_1816.territorial_changes_since_1945

14.32 KB
283 rows
8 columns


CREATE TABLE territorial_changes_since_1945 (
  "year" BIGINT,
  "country_gaining" VARCHAR,
  "iso3c_gaining" VARCHAR,
  "country_losing" VARCHAR,
  "iso3c_losing" VARCHAR,
  "type" VARCHAR,
  "pop" VARCHAR,
  "area" VARCHAR
);

Wars With Approximate Location

@kaggle.joebeachcapital_wars_since_1816.wars_with_approximate_location

35.24 KB
340 rows
31 columns


CREATE TABLE wars_with_approximate_location (
  "warnum" BIGINT,
  "ccode" DOUBLE,
  "warname" VARCHAR,
  "wartype" DOUBLE,
  "statename" VARCHAR,
  "side" DOUBLE,
  "startmonth1" DOUBLE,
  "startday1" DOUBLE,
  "startyear1" BIGINT,
  "endmonth1" DOUBLE,
  "endday1" DOUBLE,
  "endyear1" BIGINT,
  "startmonth2" DOUBLE,
  "startday2" DOUBLE,
  "startyear2" BIGINT,
  "endmonth2" DOUBLE,
  "endday2" DOUBLE,
  "endyear2" BIGINT,
  "transfrom" VARCHAR,
  "wherefought" DOUBLE,
  "initiator" DOUBLE,
  "outcome" DOUBLE,
  "transto" DOUBLE,
  "batdeath" DOUBLE,
  "version" DOUBLE,
  "total_battle_deaths" DOUBLE,
  "iso3c" VARCHAR,
  "lng_country" DOUBLE,
  "lat_country" DOUBLE,
  "lat" DOUBLE,
  "lng" DOUBLE
);

War List 1816–2010

@kaggle.joebeachcapital_wars_since_1816.war_list_1816_2010

35.24 KB
340 rows
31 columns


CREATE TABLE war_list_1816_2010 (
  "warnum" BIGINT,
  "ccode" DOUBLE,
  "warname" VARCHAR,
  "wartype" DOUBLE,
  "statename" VARCHAR,
  "side" DOUBLE,
  "startmonth1" DOUBLE,
  "startday1" DOUBLE,
  "startyear1" BIGINT,
  "endmonth1" DOUBLE,
  "endday1" DOUBLE,
  "endyear1" BIGINT,
  "startmonth2" DOUBLE,
  "startday2" DOUBLE,
  "startyear2" BIGINT,
  "endmonth2" DOUBLE,
  "endday2" DOUBLE,
  "endyear2" BIGINT,
  "transfrom" VARCHAR,
  "wherefought" DOUBLE,
  "initiator" DOUBLE,
  "outcome" DOUBLE,
  "transto" DOUBLE,
  "batdeath" DOUBLE,
  "version" DOUBLE,
  "total_battle_deaths" DOUBLE,
  "iso3c" VARCHAR,
  "lng_country" DOUBLE,
  "lat_country" DOUBLE,
  "lat" DOUBLE,
  "lng" DOUBLE
);

War List 1816–2010 Long Format

@kaggle.joebeachcapital_wars_since_1816.war_list_1816_2010_long_format

35.24 KB
340 rows
31 columns


CREATE TABLE war_list_1816_2010_long_format (
  "warnum" BIGINT,
  "ccode" DOUBLE,
  "warname" VARCHAR,
  "wartype" DOUBLE,
  "statename" VARCHAR,
  "side" DOUBLE,
  "startmonth1" DOUBLE,
  "startday1" DOUBLE,
  "startyear1" BIGINT,
  "endmonth1" DOUBLE,
  "endday1" DOUBLE,
  "endyear1" BIGINT,
  "startmonth2" DOUBLE,
  "startday2" DOUBLE,
  "startyear2" BIGINT,
  "endmonth2" DOUBLE,
  "endday2" DOUBLE,
  "endyear2" BIGINT,
  "transfrom" VARCHAR,
  "wherefought" DOUBLE,
  "initiator" DOUBLE,
  "outcome" DOUBLE,
  "transto" DOUBLE,
  "batdeath" DOUBLE,
  "version" DOUBLE,
  "total_battle_deaths" DOUBLE,
  "iso3c" VARCHAR,
  "lng_country" DOUBLE,
  "lat_country" DOUBLE,
  "lat" DOUBLE,
  "lng" DOUBLE
);