About this Dataset

States In Regions (COW)

This data set contains the list of states in the international system as updated and distributed by the Correlates of War Project. These data sets identify states, their standard Correlates of War “country code” or state number (used throughout the Correlates of War project data sets), state abbreviations, and dates of membership as states and major powers in the international system. Version 2016 extends the temporal domain of the collection through December 2016.

The Correlates of War project includes a state in the international system from 1816-2016 for the following criteria. Prior to 1920, the entity must have had a population greater than 500,000 and have had diplomatic missions at or above the rank of charge d’affaires with Britain and France. After 1920, the entity must be a member of the League of Nations or the United Nations, or have a population greater than 500,000 and receive diplomatic missions from two major powers.

Find more information in their codebook

Tables

State System Membership

@owid.cow_ssm.owid_cow_ssm_countries

9.41 kB
17,121 rows
3 columns

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

State System Membership

@owid.cow_ssm.owid_cow_ssm_majors

8.28 kB
14 rows
10 columns

CREATE TABLE owid_cow_ssm_majors (
  "ccode" INTEGER,
  "styear" INTEGER,
  "stmonth" INTEGER,
  "stday" INTEGER,
  "endyear" INTEGER,
  "endmonth" INTEGER,
  "endday" INTEGER,
  "stateabb" VARCHAR,
  "version" INTEGER,
  "statenme" VARCHAR
);

States In Regions (COW)

@owid.cow_ssm.owid_cow_ssm_regions

15.41 kB
1,242 rows
4 columns

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

State System Membership

@owid.cow_ssm.owid_cow_ssm_states

13.41 kB
243 rows
10 columns

CREATE TABLE owid_cow_ssm_states (
  "ccode" INTEGER,
  "styear" INTEGER,
  "stmonth" INTEGER,
  "stday" INTEGER,
  "endyear" INTEGER,
  "endmonth" INTEGER,
  "endday" INTEGER,
  "stateabb" VARCHAR,
  "statenme" VARCHAR,
  "version" INTEGER
);

State System Membership

@owid.cow_ssm.owid_cow_ssm_system

12.25 kB
15,951 rows
5 columns

CREATE TABLE owid_cow_ssm_system (
  "ccode" INTEGER,
  "year" INTEGER,
  "stateabb" VARCHAR,
  "version" INTEGER,
  "statenme" VARCHAR
);