Dataset: V-Dem Country-Year (Full + Others)

About this Dataset

V-Dem Country-Year (Full + Others)

The Varieties of Democracy (V-Dem) project publishes data and research on democracy and human rights.

It acknowledges that democracy can be characterized differently and measures electoral, liberal, participatory, deliberative, and egalitarian characterizations of democracy.

The project relies on evaluations by around 3,500 country experts and supplementary work by its researchers to assess political institutions and the protection of rights.

The project is managed by the V-Dem Institute, based at the University of Gothenburg in Sweden.

This snapshot contains all 531 V-Dem indicators and 245 indices + 60 other indicators from other data sources.

For more information, please refer to https://www.v-dem.net/data/the-v-dem-dataset/

Tables

Democracy Report

@owid.vdem.owid_metadata

31.19 KB
32518 rows
5 columns


CREATE TABLE owid_metadata (
  "country" VARCHAR,
  "year" INTEGER,
  "regime_imputed" BOOLEAN,
  "regime_imputed_country" VARCHAR,
  "histname" VARCHAR
);

Vdem 1

@owid.vdem.owid_vdem_1

4.88 MB
33808 rows
350 columns


CREATE TABLE owid_vdem_1 (
  "index" BIGINT,
  "country" VARCHAR,
  "year" INTEGER,
  "regime_row_owid" INTEGER,
  "electdem_age_row_owid" VARCHAR,
  "electdem_age_group_row_owid" INTEGER,
  "libdem_age_row_owid" VARCHAR,
  "libdem_age_group_row_owid" INTEGER,
  "regime_amb_row_owid" INTEGER,
  "electmulpar_row_owid" INTEGER,
  "electmulpar_high_row_owid" INTEGER,
  "electmulpar_low_row_owid" INTEGER,
  "electmulpar_leg_row_owid" INTEGER,
  "electmulpar_leg_high_row_owid" INTEGER,
  "electmulpar_leg_low_row_owid" INTEGER,
  "electmulpar_hoe_row_owid" INTEGER,
  "electmulpar_hoe_high_row_owid" INTEGER,
  "electmulpar_hoe_low_row_owid" INTEGER,
  "electfreefair_row_owid" INTEGER,
  "electfreefair_high_row_owid" INTEGER,
  "electfreefair_low_row_owid" INTEGER,
  "electdem_dich_row_owid" INTEGER,
  "electdem_dich_high_row_owid" INTEGER,
  "electdem_dich_low_row_owid" INTEGER,
  "accessjust_m_row_owid" INTEGER,
  "accessjust_m_high_row_owid" INTEGER,
  "accessjust_m_low_row_owid" INTEGER,
  "accessjust_w_row_owid" INTEGER,
  "accessjust_w_high_row_owid" INTEGER,
  "accessjust_w_low_row_owid" INTEGER,
  "transplaws_row_owid" INTEGER,
  "transplaws_high_row_owid" INTEGER,
  "transplaws_low_row_owid" INTEGER,
  "lib_dich_row_owid" INTEGER,
  "lib_dich_high_row_owid" INTEGER,
  "lib_dich_low_row_owid" INTEGER,
  "electdem_vdem_owid" FLOAT,
  "electdem_vdem_low_owid" FLOAT,
  "electdem_vdem_high_owid" FLOAT,
  "libdem_vdem_owid" FLOAT,
  "libdem_vdem_low_owid" FLOAT,
  "libdem_vdem_high_owid" FLOAT,
  "participdem_vdem_owid" FLOAT,
  "participdem_vdem_low_owid" FLOAT,
  "participdem_vdem_high_owid" FLOAT,
  "delibdem_vdem_owid" FLOAT,
  "delibdem_vdem_low_owid" FLOAT,
  "delibdem_vdem_high_owid" FLOAT,
  "egaldem_vdem_owid" FLOAT,
  "egaldem_vdem_low_owid" FLOAT,
  "egaldem_vdem_high_owid" FLOAT,
  "freeexpr_vdem_owid" FLOAT,
  "freeexpr_vdem_low_owid" FLOAT,
  "freeexpr_vdem_high_owid" FLOAT,
  "freeassoc_vdem_owid" FLOAT,
  "freeassoc_vdem_low_owid" FLOAT,
  "freeassoc_vdem_high_owid" FLOAT,
  "suffr_vdem_owid" FLOAT,
  "electfreefair_vdem_owid" FLOAT,
  "electfreefair_vdem_low_owid" FLOAT,
  "electfreefair_vdem_high_owid" FLOAT,
  "electoff_vdem_owid" FLOAT,
  "lib_vdem_owid" FLOAT,
  "lib_vdem_low_owid" FLOAT,
  "lib_vdem_high_owid" FLOAT,
  "indiv_libs_vdem_owid" FLOAT,
  "indiv_libs_vdem_low_owid" FLOAT,
  "indiv_libs_vdem_high_owid" FLOAT,
  "judicial_constr_vdem_owid" FLOAT,
  "judicial_constr_vdem_low_owid" FLOAT,
  "judicial_constr_vdem_high_owid" FLOAT,
  "legis_constr_vdem_owid" FLOAT,
  "legis_constr_vdem_low_owid" FLOAT,
  "legis_constr_vdem_high_owid" FLOAT,
  "particip_vdem_owid" FLOAT,
  "particip_vdem_low_owid" FLOAT,
  "particip_vdem_high_owid" FLOAT,
  "civsoc_particip_vdem_owid" FLOAT,
  "civsoc_particip_vdem_low_owid" FLOAT,
  "civsoc_particip_vdem_high_owid" FLOAT,
  "dirpop_vote_vdem_owid" FLOAT,
  "locelect_vdem_owid" FLOAT,
  "locelect_vdem_low_owid" FLOAT,
  "locelect_vdem_high_owid" FLOAT,
  "regelect_vdem_owid" FLOAT,
  "regelect_vdem_low_owid" FLOAT,
  "regelect_vdem_high_owid" FLOAT,
  "delib_vdem_owid" FLOAT,
  "delib_vdem_low_owid" FLOAT,
  "delib_vdem_high_owid" FLOAT,
  "justified_polch_vdem_owid" FLOAT,
  "justified_polch_vdem_low_owid" FLOAT,
  "justified_polch_vdem_high_owid" FLOAT,
  "justcomgd_polch_vdem_owid" FLOAT,
  "justcomgd_polch_vdem_low_owid" FLOAT,
  "justcomgd_polch_vdem_high_owid" FLOAT,
  "counterarg_polch_vdem_owid" FLOAT,
  "counterarg_polch_vdem_low_owid" FLOAT,
  "counterarg_polch_vdem_high_owid" FLOAT,
  "elitecons_polch_vdem_owid" FLOAT
);

V-Dem Country-Year (Full + Others)

@owid.vdem.owid_vdem_2

140.7 KB
32339 rows
25 columns


CREATE TABLE owid_vdem_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "regime_imputed_country" VARCHAR,
  "histname" VARCHAR,
  "suffr_vdem" FLOAT,
  "electoff_vdem" FLOAT,
  "dirpop_vote_vdem" FLOAT,
  "turnout_total_vdem" FLOAT,
  "turnout_vdem" FLOAT,
  "wom_hos_vdem" INTEGER,
  "wom_hog_vdem" INTEGER,
  "goveffective_vdem_wbgi" FLOAT,
  "corruption_cpi" INTEGER,
  "regime_row_owid" INTEGER,
  "regime_amb_row_owid" INTEGER,
  "regime_redux_row_owid" INTEGER,
  "wom_hoe_vdem" INTEGER,
  "regime_imputed" BOOLEAN,
  "num_years_in_electdem_consecutive" INTEGER,
  "num_years_in_libdem_consecutive" INTEGER,
  "num_years_in_electdem" INTEGER,
  "num_years_in_libdem" INTEGER,
  "num_years_in_electdem_consecutive_cat" VARCHAR,
  "num_years_in_libdem_consecutive_cat" VARCHAR,
  "wom_parl_vdem_cat" VARCHAR
);

V-Dem Country-Year (Full + Others)

@owid.vdem.owid_vdem_multi_with_regions_1

4.18 MB
106887 rows
32 columns


CREATE TABLE owid_vdem_multi_with_regions_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "estimate" VARCHAR,
  "aggregate_method" VARCHAR,
  "civ_libs_vdem" FLOAT,
  "civ_soc_str_vdem" FLOAT,
  "corr_exec_vdem" FLOAT,
  "corr_jud_vdem" FLOAT,
  "corr_leg_vdem" FLOAT,
  "corr_publsec_vdem" FLOAT,
  "corruption_vdem" FLOAT,
  "delibdem_vdem" FLOAT,
  "dom_auton_vdem" FLOAT,
  "egaldem_vdem" FLOAT,
  "electdem_vdem" FLOAT,
  "int_auton_vdem" FLOAT,
  "libdem_vdem" FLOAT,
  "participdem_vdem" FLOAT,
  "personalism_vdem" FLOAT,
  "phys_integr_libs_vdem" FLOAT,
  "pol_libs_vdem" FLOAT,
  "priv_libs_vdem" FLOAT,
  "public_admin_vdem" FLOAT,
  "rule_of_law_vdem" FLOAT,
  "socgr_civ_libs_vdem" FLOAT,
  "socgr_pow_vdem" FLOAT,
  "terr_contr_vdem" FLOAT,
  "wom_civ_libs_vdem" FLOAT,
  "wom_civ_soc_vdem" FLOAT,
  "wom_emp_vdem" FLOAT,
  "wom_parl_vdem" FLOAT,
  "wom_pol_par_vdem" FLOAT
);

Democracy Report

@owid.vdem.owid_vdem_multi_with_regions_2

9.17 MB
107466 rows
67 columns


CREATE TABLE owid_vdem_multi_with_regions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "estimate" VARCHAR,
  "civ_libs_vdem" FLOAT,
  "civ_soc_str_vdem" FLOAT,
  "civsoc_particip_vdem" FLOAT,
  "corr_exec_vdem" FLOAT,
  "corr_jud_vdem" FLOAT,
  "corr_leg_vdem" FLOAT,
  "corr_publsec_vdem" FLOAT,
  "corruption_vdem" FLOAT,
  "counterarg_polch_vdem" FLOAT,
  "delib_vdem" FLOAT,
  "delibdem_vdem" FLOAT,
  "dom_auton_vdem" FLOAT,
  "egal_vdem" FLOAT,
  "egaldem_vdem" FLOAT,
  "electdem_vdem" FLOAT,
  "electfreefair_vdem" FLOAT,
  "elitecons_polch_vdem" FLOAT,
  "equal_access_vdem" FLOAT,
  "equal_res_vdem" FLOAT,
  "equal_rights_vdem" FLOAT,
  "freeassoc_vdem" FLOAT,
  "freeexpr_vdem" FLOAT,
  "indiv_libs_vdem" FLOAT,
  "int_auton_vdem" FLOAT,
  "judicial_constr_vdem" FLOAT,
  "justcomgd_polch_vdem" FLOAT,
  "justified_polch_vdem" FLOAT,
  "legis_constr_vdem" FLOAT,
  "lib_vdem" FLOAT,
  "libdem_vdem" FLOAT,
  "locelect_vdem" FLOAT,
  "particip_vdem" FLOAT,
  "participdem_vdem" FLOAT,
  "personalism_vdem" FLOAT,
  "phys_integr_libs_vdem" FLOAT,
  "pol_libs_vdem" FLOAT,
  "priv_libs_vdem" FLOAT,
  "public_admin_vdem" FLOAT,
  "regelect_vdem" FLOAT,
  "rule_of_law_vdem" FLOAT,
  "soccons_polch_vdem" FLOAT,
  "socgr_civ_libs_vdem" FLOAT,
  "socgr_pow_vdem" FLOAT,
  "terr_contr_vdem" FLOAT,
  "v2caautmob" FLOAT,
  "v2cacamps" FLOAT,
  "v2cademmob" FLOAT,
  "v2cagenmob" FLOAT,
  "v2caviol" FLOAT,
  "v2elvotbuy" FLOAT,
  "v2mebias" FLOAT,
  "v2mecenefm" FLOAT,
  "v2mecorrpt" FLOAT,
  "v2meharjrn" FLOAT,
  "v2meslfcen" FLOAT,
  "v2smgovdom" FLOAT,
  "v2xca_academ" FLOAT,
  "v2xcl_prpty" FLOAT,
  "v2xnp_client" FLOAT,
  "wom_civ_libs_vdem" FLOAT,
  "wom_civ_soc_vdem" FLOAT,
  "wom_emp_vdem" FLOAT,
  "wom_parl_vdem" FLOAT,
  "wom_pol_par_vdem" FLOAT
);

Vdem Multi Without Regions 1

@owid.vdem.owid_vdem_multi_without_regions_1

1.53 MB
97017 rows
33 columns


CREATE TABLE owid_vdem_multi_without_regions_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "estimate" VARCHAR,
  "accessjust_m_row" INTEGER,
  "accessjust_w_row" INTEGER,
  "civsoc_particip_vdem" FLOAT,
  "counterarg_polch_vdem" FLOAT,
  "delib_vdem" FLOAT,
  "egal_vdem" FLOAT,
  "electdem_dich_row_owid" INTEGER,
  "electfreefair_row" INTEGER,
  "electfreefair_vdem" FLOAT,
  "electmulpar_hoe_row_owid" INTEGER,
  "electmulpar_leg_row" INTEGER,
  "electmulpar_row" INTEGER,
  "elitecons_polch_vdem" FLOAT,
  "equal_access_vdem" FLOAT,
  "equal_res_vdem" FLOAT,
  "equal_rights_vdem" FLOAT,
  "freeassoc_vdem" FLOAT,
  "freeexpr_vdem" FLOAT,
  "indiv_libs_vdem" FLOAT,
  "judicial_constr_vdem" FLOAT,
  "justcomgd_polch_vdem" FLOAT,
  "justified_polch_vdem" FLOAT,
  "legis_constr_vdem" FLOAT,
  "lib_dich_row" INTEGER,
  "lib_vdem" FLOAT,
  "locelect_vdem" FLOAT,
  "particip_vdem" FLOAT,
  "regelect_vdem" FLOAT,
  "soccons_polch_vdem" FLOAT,
  "transplaws_row" INTEGER
);

Vdem Multi Without Regions 2

@owid.vdem.owid_vdem_multi_without_regions_2

44.08 KB
97554 rows
12 columns


CREATE TABLE owid_vdem_multi_without_regions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "estimate" VARCHAR,
  "accessjust_m_row" INTEGER,
  "accessjust_w_row" INTEGER,
  "electdem_dich_row_owid" INTEGER,
  "electfreefair_row" INTEGER,
  "electmulpar_hoe_row_owid" INTEGER,
  "electmulpar_leg_row" INTEGER,
  "electmulpar_row" INTEGER,
  "lib_dich_row" INTEGER,
  "transplaws_row" INTEGER
);

Vdem Num Countries 1

@owid.vdem.owid_vdem_num_countries_1

104.18 KB
41125 rows
11 columns


CREATE TABLE owid_vdem_num_countries_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "num_countries_hoe" INTEGER,
  "num_countries_hog" INTEGER,
  "num_countries_hos" INTEGER,
  "num_countries_regime" INTEGER,
  "num_countries_regime_amb" INTEGER,
  "num_countries_wom_parl" INTEGER,
  "num_countries_years_in_electdem" INTEGER,
  "num_countries_years_in_libdem" INTEGER
);

Vdem Num Countries 2

@owid.vdem.owid_vdem_num_countries_2

116.27 KB
44604 rows
12 columns


CREATE TABLE owid_vdem_num_countries_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "category" VARCHAR,
  "num_countries_hoe" INTEGER,
  "num_countries_hog" INTEGER,
  "num_countries_hos" INTEGER,
  "num_countries_natelect" INTEGER,
  "num_countries_regime" INTEGER,
  "num_countries_regime_amb" INTEGER,
  "num_countries_wom_parl" INTEGER,
  "num_countries_years_in_electdem" INTEGER,
  "num_countries_years_in_libdem" INTEGER
);

Vdem Population 1

@owid.vdem.owid_vdem_population_1

305.2 KB
41125 rows
11 columns


CREATE TABLE owid_vdem_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "category" VARCHAR,
  "population_hoe" BIGINT,
  "population_hog" BIGINT,
  "population_hos" BIGINT,
  "population_regime" UINTEGER,
  "population_regime_amb" UINTEGER,
  "population_wom_parl" UINTEGER,
  "population_years_in_electdem" UINTEGER,
  "population_years_in_libdem" UINTEGER
);

Vdem Population 2

@owid.vdem.owid_vdem_population_2

349.12 KB
44604 rows
12 columns


CREATE TABLE owid_vdem_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "category" VARCHAR,
  "population_hoe" BIGINT,
  "population_hog" BIGINT,
  "population_hos" BIGINT,
  "population_natelect" BIGINT,
  "population_regime" UINTEGER,
  "population_regime_amb" UINTEGER,
  "population_wom_parl" UINTEGER,
  "population_years_in_electdem" UINTEGER,
  "population_years_in_libdem" UINTEGER
);

Democracy Report

@owid.vdem.owid_vdem_uni_with_regions

85.95 KB
35822 rows
6 columns


CREATE TABLE owid_vdem_uni_with_regions (
  "country" VARCHAR,
  "year" INTEGER,
  "suffr_vdem" FLOAT,
  "electoff_vdem" FLOAT,
  "turnout_total_vdem" FLOAT,
  "turnout_vdem" FLOAT
);

Democracy Report

@owid.vdem.owid_vdem_uni_without_regions

104.78 KB
32518 rows
22 columns


CREATE TABLE owid_vdem_uni_without_regions (
  "country" VARCHAR,
  "year" INTEGER,
  "dirpop_vote_vdem" FLOAT,
  "wom_hos_vdem" INTEGER,
  "wom_hog_vdem" INTEGER,
  "v2xpas_democracy" FLOAT,
  "v2xpas_democracy_government" FLOAT,
  "v2xpas_democracy_opposition" FLOAT,
  "goveffective_vdem_wbgi" FLOAT,
  "corruption_cpi" INTEGER,
  "held_national_election" INTEGER,
  "regime_row_owid" INTEGER,
  "regime_amb_row_owid" INTEGER,
  "regime_redux_row_owid" INTEGER,
  "wom_hoe_vdem" INTEGER,
  "num_years_in_electdem_consecutive" INTEGER,
  "num_years_in_libdem_consecutive" INTEGER,
  "num_years_in_electdem" INTEGER,
  "num_years_in_libdem" INTEGER,
  "num_years_in_electdem_consecutive_cat" VARCHAR,
  "num_years_in_libdem_consecutive_cat" VARCHAR,
  "wom_parl_vdem_cat" VARCHAR
);