Baselight

V-Dem Country-Year (Full + Others)

@owid.vdem

Loading...
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
);

Share link

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