V-Dem Country-Year (Full + Others)
@owid.vdem
@owid.vdem
CREATE TABLE owid_metadata (
"country" VARCHAR,
"year" INTEGER,
"regime_imputed" BOOLEAN,
"regime_imputed_country" VARCHAR,
"histname" VARCHAR
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
CREATE TABLE owid_vdem_uni_with_regions (
"country" VARCHAR,
"year" INTEGER,
"suffr_vdem" FLOAT,
"electoff_vdem" FLOAT,
"turnout_total_vdem" FLOAT,
"turnout_vdem" FLOAT
);
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
);
Anyone who has the link will be able to view this.