Boix-Miller-Rosato (BMR) Dichotomous Coding Of Democracy (1800-2020)
@owid.bmr
@owid.bmr
This dataset covers all sovereign countries (including micro-states) from 1800 to 2020. Generally, we use United Nations membership to define when micro-states enter the data set. We thank Benjamin A.T. Graham and his students at USC (Valeria Flores-Cadena, Jiaming Shi, Affan Rahman, and Apurvi Bhartia) for providing their own democracy ratings and supporting information as part of a class project.
The authors argue that their measure’s distinguishing features—a concrete, dichotomous coding and a long time span—are of critical value to empirical work on democracy. Inspired by Robert Dahl, they define a country as democratic if it satisfies conditions for both contestation and participation. Specifically, democracies feature political leaders chosen through free and fair elections and satisfy a threshold value of suffrage.
CREATE TABLE owid_bmr (
"country" VARCHAR,
"year" INTEGER,
"regime" INTEGER,
"regime_womsuffr" INTEGER,
"regime_imputed_country" VARCHAR,
"regime_imputed" BOOLEAN,
"num_years_in_democracy_consecutive" INTEGER,
"num_years_in_democracy" INTEGER,
"num_years_in_democracy_ws_consecutive" INTEGER,
"num_years_in_democracy_ws" INTEGER,
"num_years_in_democracy_consecutive_group" VARCHAR,
"num_years_in_democracy_ws_consecutive_group" VARCHAR
);CREATE TABLE owid_num_countries_regime (
"country" VARCHAR,
"year" INTEGER,
"category" INTEGER,
"num_countries_regime" INTEGER,
"num_countries_regime_ws" INTEGER
);CREATE TABLE owid_num_countries_regime_years (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_countries_years_in_democracy_consec" INTEGER,
"num_countries_years_in_democracy_ws_consec" INTEGER
);CREATE TABLE owid_population_regime (
"country" VARCHAR,
"year" INTEGER,
"category" INTEGER,
"population_regime" UINTEGER,
"population_regime_ws" UINTEGER
);CREATE TABLE owid_population_regime_years (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"population_years_in_democracy_consec" UINTEGER,
"population_years_in_democracy_ws_consec" UINTEGER
);Anyone who has the link will be able to view this.