Baselight

States In Regions (ISD)

@owid.isd

Loading...
Loading...

About this Dataset

States In Regions (ISD)

The International System(s) Dataset (ISD) is a register of sovereign states across the 1816–2016 period that includes numerous states that are missed in commonly used datasets like the Correlates of War (COW) Project.

Whereas ISD version 1 identified 363 states between 1816 and 2011, this version (version 2) identifies 482. It also records valuable information on various corollary variables, including start dates, end dates, estimated population sizes, diplomatic relations with Europe, conflict episodes, borders, and the location of capital cities.

This dataset makes an important contribution to the study of international relations. It provides a more accurate understanding of the development of the international system over the last two centuries, it moves beyond the Eurocentric bias that sits at the heart of existing quantitative IR scholarship, and it will enable scholars to pursue a range of research topics such as the historical importance of state borders and boundaries, the practices surrounding recognition, and the frequency and intensity of conflict across regions.

Find more details in their codebookk

Tables

International System Dataset

@owid.isd.owid_isd
  • 50.04 KB
  • 482 rows
  • 35 columns
Loading...

CREATE TABLE owid_isd (
  "cownum" INTEGER,
  "start" VARCHAR,
  "end" VARCHAR,
  "cowid" VARCHAR,
  "statename" VARCHAR,
  "othername" VARCHAR,
  "isd_category" INTEGER,
  "region" INTEGER,
  "start_am" INTEGER,
  "estart" INTEGER,
  "estart_am" INTEGER,
  "declare" INTEGER,
  "decdate" VARCHAR,
  "population" UINTEGER,
  "popdate" INTEGER,
  "popam" INTEGER,
  "populationhigh" UINTEGER,
  "populationlow" UINTEGER,
  "starttype" INTEGER,
  "starttype_am" INTEGER,
  "startsettle" INTEGER,
  "end_am" INTEGER,
  "endtype" INTEGER,
  "endtype_am" INTEGER,
  "endsettle" INTEGER,
  "sovereignty_am" INTEGER,
  "eurodip" INTEGER,
  "borders" INTEGER,
  "borders_am" INTEGER,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "viostart" INTEGER,
  "viostart_am" INTEGER,
  "vioend" INTEGER,
  "vioend_am" INTEGER
);

International System Dataset

@owid.isd.owid_isd_countries
  • 15.43 KB
  • 29850 rows
  • 3 columns
Loading...

CREATE TABLE owid_isd_countries (
  "id" INTEGER,
  "year" INTEGER,
  "country" VARCHAR
);

States In Regions (ISD)

@owid.isd.owid_isd_regions
  • 18.69 KB
  • 1656 rows
  • 4 columns
Loading...

CREATE TABLE owid_isd_regions (
  "region" VARCHAR,
  "year" INTEGER,
  "number_countries" INTEGER,
  "population" BIGINT
);

Share link

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