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.93 kB
32,518 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

5.12 MB
33,808 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

144.08 kB
32,339 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
);

Vdem Multi Without Regions 1

@owid.vdem.owid_vdem_multi_without_regions_1

1.61 MB
97,017 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

45.14 kB
97,554 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
);

V-Dem Country-Year (Full + Others)

@owid.vdem.owid_vdem_multi_with_regions_1

4.38 MB
106,887 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.26 MB
105,621 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 Num Countries 1

@owid.vdem.owid_vdem_num_countries_1

106.68 kB
41,125 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

139.77 kB
47,908 rows
14 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_hoe_ever" INTEGER,
  "num_countries_wom_hoe_ever_demelect" 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

312.53 kB
41,125 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

433.49 kB
47,908 rows
14 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_hoe_ever" BIGINT,
  "population_wom_hoe_ever_demelect" BIGINT,
  "population_wom_parl" UINTEGER,
  "population_years_in_electdem" UINTEGER,
  "population_years_in_libdem" UINTEGER
);

Vdem Share Countries

@owid.vdem.owid_vdem_share_countries

5.62 kB
236 rows
4 columns


CREATE TABLE owid_vdem_share_countries (
  "country" VARCHAR,
  "year" INTEGER,
  "share_countries_wom_hoe_ever" FLOAT,
  "share_countries_wom_hoe_ever_demelect" FLOAT
);

Democracy Report

@owid.vdem.owid_vdem_uni_without_regions

115.08 kB
32,518 rows
27 columns


CREATE TABLE owid_vdem_uni_without_regions (
  "country" VARCHAR,
  "year" INTEGER,
  "dirpop_vote_vdem" FLOAT,
  "v2exfemhos" INTEGER,
  "v2exfemhog" INTEGER,
  "v2xpas_democracy" FLOAT,
  "v2xpas_democracy_government" FLOAT,
  "v2xpas_democracy_opposition" FLOAT,
  "goveffective_vdem_wbgi" FLOAT,
  "corruption_cpi" INTEGER,
  "wom_hog_vdem" INTEGER,
  "wom_hos_vdem" INTEGER,
  "held_national_election" INTEGER,
  "regime_row_owid" INTEGER,
  "regime_amb_row_owid" INTEGER,
  "regime_redux_row_owid" INTEGER,
  "wom_hoe_vdem" INTEGER,
  "v2exfemhoe" INTEGER,
  "wom_hoe_ever" INTEGER,
  "wom_hoe_ever_dem" 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
);

Democracy Report

@owid.vdem.owid_vdem_uni_with_regions

78.92 kB
35,207 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
);