Polity5 Project, Political Regime Characteristics And Transitions, 1800-2018
@owid.polity
@owid.polity
CREATE TABLE owid_num_countries (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_group_age_dem_polity" INTEGER,
"num_regime_polity" INTEGER
);
CREATE TABLE owid_num_people (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"pop_group_age_dem_polity" UINTEGER,
"pop_regime_polity" BIGINT
);
CREATE TABLE owid_polity (
"country" VARCHAR,
"year" INTEGER,
"democracy_polity" FLOAT,
"exec_reccomp_polity" INTEGER,
"exec_recopen_polity" INTEGER,
"exec_constr_polity" INTEGER,
"polpart_reg_polity" INTEGER,
"polpart_comp_polity" INTEGER,
"regime_polity" VARCHAR,
"democracy_recod_polity" FLOAT,
"age_dem_polity" VARCHAR,
"experience_dem_polity" INTEGER,
"group_age_dem_polity" VARCHAR
);
Anyone who has the link will be able to view this.