Lexical Index Of Electoral Democracy (LIED)
@owid.lexical_index
@owid.lexical_index
CREATE TABLE owid_lexical_index_1 (
"country" VARCHAR,
"year" INTEGER,
"regime_lied" INTEGER,
"regime_redux_lied" INTEGER,
"exelec_lied" INTEGER,
"legelec_lied" INTEGER,
"opposition_lied" INTEGER,
"competition_lied" INTEGER,
"male_suffrage_lied" INTEGER,
"female_suffrage_lied" INTEGER,
"poliberties_lied" INTEGER,
"democracy_lied" INTEGER,
"age_electdem_lied" VARCHAR,
"experience_electdem_lied" INTEGER,
"age_polyarchy_lied" VARCHAR,
"experience_polyarchy_lied" INTEGER,
"group_age_electdem_lied" VARCHAR,
"group_age_polyarchy_lied" VARCHAR,
"suffrage_lied" INTEGER
);
CREATE TABLE owid_lexical_index_2 (
"country" VARCHAR,
"year" INTEGER,
"regime_lied" INTEGER,
"regime_redux_lied" INTEGER,
"exelec_lied" INTEGER,
"legelec_lied" INTEGER,
"opposition_lied" INTEGER,
"competition_lied" INTEGER,
"male_suffrage_lied" INTEGER,
"female_suffrage_lied" INTEGER,
"poliberties_lied" INTEGER,
"turnover_event" INTEGER,
"turnover_period" INTEGER,
"two_turnover_period" INTEGER,
"democratic_transition" INTEGER,
"transition_type" INTEGER,
"democratic_breakdown" INTEGER,
"breakdown_type" INTEGER,
"democracy_lied" INTEGER,
"is_full_democracy" INTEGER,
"is_electoral_democracy" INTEGER,
"age_electdem_lied" VARCHAR,
"experience_electdem_lied" INTEGER,
"age_polyarchy_lied" VARCHAR,
"experience_polyarchy_lied" INTEGER,
"group_age_electdem_lied" VARCHAR,
"group_age_polyarchy_lied" VARCHAR,
"suffrage_lied" INTEGER
);
CREATE TABLE owid_region_aggregates_1 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_democracy_lied" INTEGER,
"num_group_age_electdem_lied" INTEGER,
"num_group_age_polyarchy_lied" INTEGER,
"num_regime_lied" INTEGER,
"num_suffrage_lied" INTEGER,
"pop_democracy_lied" BIGINT,
"pop_group_age_electdem_lied" UINTEGER,
"pop_group_age_polyarchy_lied" UINTEGER,
"pop_regime_lied" UINTEGER,
"pop_suffrage_lied" BIGINT
);
CREATE TABLE owid_region_aggregates_2 (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_breakdown_type" INTEGER,
"num_democracy_lied" INTEGER,
"num_group_age_electdem_lied" INTEGER,
"num_group_age_polyarchy_lied" INTEGER,
"num_is_electoral_democracy" INTEGER,
"num_is_full_democracy" INTEGER,
"num_regime_lied" INTEGER,
"num_suffrage_lied" INTEGER,
"num_transition_type" INTEGER,
"num_turnover_event" INTEGER,
"pop_breakdown_type" BIGINT,
"pop_democracy_lied" BIGINT,
"pop_group_age_electdem_lied" UINTEGER,
"pop_group_age_polyarchy_lied" UINTEGER,
"pop_is_electoral_democracy" BIGINT,
"pop_is_full_democracy" BIGINT,
"pop_regime_lied" UINTEGER,
"pop_suffrage_lied" BIGINT,
"pop_transition_type" BIGINT,
"pop_turnover_event" BIGINT
);
Anyone who has the link will be able to view this.