Baselight

EIU Democratic Index (2006-2023)

@owid.eiu

Loading...
Loading...

About this Dataset

EIU Democratic Index (2006-2023)

The Economist Intelligence Unit's (EIU) Democracy Index provides a snapshot of the state of democracy in 165 independent states and two territories. This covers almost the entire population of the world and the vast majority of the world's states (microstates are excluded). Scored on a 0-10 scale, the Democracy Index is based on five categories: electoral process and pluralism, functioning of government, political participation, political culture, and civil liberties. Based on its scores on a range of indicators within these categories, each country is classified as one of four types of regime: "full democracy", "flawed democracy", "hybrid regime" or "authoritarian regime".

This dataset was constructed using data collected from various EIU yearly reports and a multi-year compilation by Gapminder.

Tables

Avg Pop

@owid.eiu.owid_avg_pop
  • 3.7 KB
  • 112 rows
  • 3 columns
Loading...

CREATE TABLE owid_avg_pop (
  "country" VARCHAR,
  "year" INTEGER,
  "democracy_eiu_weighted" FLOAT
);

Eiu 1

@owid.eiu.owid_eiu_1
  • 25.16 KB
  • 2784 rows
  • 9 columns
Loading...

CREATE TABLE owid_eiu_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "democracy_eiu" FLOAT,
  "elect_freefair_eiu" FLOAT,
  "funct_gov_eiu" FLOAT,
  "pol_part_eiu" FLOAT,
  "dem_culture_eiu" FLOAT,
  "civlib_eiu" FLOAT,
  "regime_eiu" VARCHAR
);

Eiu 2

@owid.eiu.owid_eiu_2
  • 33.4 KB
  • 3077 rows
  • 9 columns
Loading...

CREATE TABLE owid_eiu_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "democracy_eiu" FLOAT,
  "elect_freefair_eiu" FLOAT,
  "funct_gov_eiu" FLOAT,
  "pol_part_eiu" FLOAT,
  "dem_culture_eiu" FLOAT,
  "civlib_eiu" FLOAT,
  "regime_eiu" VARCHAR
);

Num Countries 1

@owid.eiu.owid_num_countries_1
  • 4.4 KB
  • 448 rows
  • 4 columns
Loading...

CREATE TABLE owid_num_countries_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "num_regime_eiu" INTEGER
);

Num Countries 2

@owid.eiu.owid_num_countries_2
  • 4.49 KB
  • 476 rows
  • 4 columns
Loading...

CREATE TABLE owid_num_countries_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "num_regime_eiu" INTEGER
);

Num People 1

@owid.eiu.owid_num_people_1
  • 5.39 KB
  • 315 rows
  • 4 columns
Loading...

CREATE TABLE owid_num_people_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "pop_regime_eiu" UINTEGER
);

Num People 2

@owid.eiu.owid_num_people_2
  • 7.18 KB
  • 595 rows
  • 4 columns
Loading...

CREATE TABLE owid_num_people_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "pop_regime_eiu" UINTEGER
);

Share link

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