Boix-Miller-Rosato (BMR) Dichotomous Coding Of Democracy (1800-2020)
@owid.bmr
@owid.bmr
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.