Bertelsmann Transformation Index, Scores
@owid.bti
@owid.bti
CREATE TABLE owid_bti (
"country" VARCHAR,
"year" INTEGER,
"democracy_bti" FLOAT,
"state_bti" FLOAT,
"political_participation_bti" FLOAT,
"rule_of_law_bti" FLOAT,
"stability_dem_inst_bti" FLOAT,
"pol_soc_integr_bti" FLOAT,
"regime_bti" INTEGER,
"electfreefair_bti" INTEGER,
"effective_power_bti" INTEGER,
"freeassoc_bti" INTEGER,
"freeexpr_bti" INTEGER,
"sep_power_bti" INTEGER,
"civ_rights_bti" INTEGER,
"state_basic_bti" FLOAT
);
CREATE TABLE owid_num_countries (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"num_regime_bti" INTEGER
);
CREATE TABLE owid_num_people (
"country" VARCHAR,
"year" INTEGER,
"category" VARCHAR,
"pop_regime_bti" UINTEGER
);
Anyone who has the link will be able to view this.