Episodes Of Regime Transformation
@owid.ert
@owid.ert
This dataset captures 680 unique episodes of regime transformation (ERT) from 1900 to 2019.
These data provide novel insights into regime change over the past 120 years, illustrating the value of developing a unified framework for studying regime transformation. Such transformations, while meaningfully altering the qualities of the regime, only produce a regime transition about 32% of the time. The majority of episodes either end before a transition takes place or do not have the potential for such a transition (i.e. constituted further democratization in democratic regimes or further autocratization in autocratic regimes).
CREATE TABLE owid_ert_1 (
"country" VARCHAR,
"year" INTEGER,
"regime_dich_ert" INTEGER,
"regime_ert" INTEGER,
"regime_trich_ert" INTEGER,
"regime_trep_outcome_ert" INTEGER
);CREATE TABLE owid_ert_2 (
"country" VARCHAR,
"year" INTEGER,
"regime_dich_ert" INTEGER,
"regime_ert" INTEGER,
"regime_trich_ert" INTEGER,
"regime_trep_outcome_ert" INTEGER
);CREATE TABLE owid_region_aggregates_1 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_regime_ert" INTEGER,
"num_regime_trich_ert" INTEGER,
"pop_regime_ert" UINTEGER,
"pop_regime_trich_ert" BIGINT
);CREATE TABLE owid_region_aggregates_2 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_regime_ert" INTEGER,
"num_regime_trich_ert" INTEGER,
"pop_regime_ert" UINTEGER,
"pop_regime_trich_ert" BIGINT
);Anyone who has the link will be able to view this.