EIU Democratic Index (2006-2023)
@owid.eiu
@owid.eiu
CREATE TABLE owid_avg_pop (
"country" VARCHAR,
"year" INTEGER,
"democracy_eiu_weighted" FLOAT
);
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
);
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
);
CREATE TABLE owid_num_countries_1 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_regime_eiu" INTEGER
);
CREATE TABLE owid_num_countries_2 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_regime_eiu" INTEGER
);
CREATE TABLE owid_num_people_1 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"pop_regime_eiu" UINTEGER
);
CREATE TABLE owid_num_people_2 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"pop_regime_eiu" UINTEGER
);
Anyone who has the link will be able to view this.