Baselight

Episodes Of Regime Transformation

@owid.ert

Loading...
Loading...

About this Dataset

Episodes Of Regime Transformation

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).

Tables

Episodes Of Regime Transformation

@owid.ert.owid_ert_1
  • 17.67 KB
  • 19499 rows
  • 6 columns
Loading...

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
);

Episodes Of Regime Transformation

@owid.ert.owid_ert_2
  • 17.6 KB
  • 19678 rows
  • 6 columns
Loading...

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
);

Region Aggregates 1

@owid.ert.owid_region_aggregates_1
  • 58.94 KB
  • 8680 rows
  • 7 columns
Loading...

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
);

Region Aggregates 2

@owid.ert.owid_region_aggregates_2
  • 59.46 KB
  • 8750 rows
  • 7 columns
Loading...

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
);

Share link

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