LGBT+ Policies (Kristopher Velasco)
@owid.lgbti_policy_index
@owid.lgbti_policy_index
CREATE TABLE owid_lgbti_policy_index (
"country" VARCHAR,
"year" INTEGER,
"equal_age" FLOAT,
"unequal_age" FLOAT,
"constitution" INTEGER,
"conversion_therapies" FLOAT,
"death_penalty" FLOAT,
"employment_discrim" FLOAT,
"gender_surgery" INTEGER,
"hate_crimes" FLOAT,
"incite_hate" FLOAT,
"joint_adoption" FLOAT,
"lgb_military" INTEGER,
"lgb_military_ban" INTEGER,
"marriage_equality" FLOAT,
"marriage_ban" FLOAT,
"samesex_legal" FLOAT,
"third_gender" INTEGER,
"trans_military" INTEGER,
"samesex_illegal" FLOAT,
"civil_unions" FLOAT,
"gendermarker" FLOAT,
"propaganda" FLOAT,
"policy_index" FLOAT,
"equal_age_yes" INTEGER,
"equal_age_no" INTEGER,
"equal_age_yes_pop" UINTEGER,
"equal_age_no_pop" BIGINT,
"constitution_yes" INTEGER,
"constitution_no" INTEGER,
"constitution_yes_pop" UINTEGER,
"constitution_no_pop" BIGINT,
"conversion_therapies_yes" INTEGER,
"conversion_therapies_no" INTEGER,
"conversion_therapies_yes_pop" UINTEGER,
"conversion_therapies_no_pop" BIGINT,
"employment_discrim_yes" INTEGER,
"employment_discrim_no" INTEGER,
"employment_discrim_yes_pop" UINTEGER,
"employment_discrim_no_pop" BIGINT,
"gender_surgery_yes" INTEGER,
"gender_surgery_no" INTEGER,
"gender_surgery_yes_pop" UINTEGER,
"gender_surgery_no_pop" BIGINT,
"hate_crimes_yes" INTEGER,
"hate_crimes_no" INTEGER,
"hate_crimes_yes_pop" UINTEGER,
"hate_crimes_no_pop" BIGINT,
"incite_hate_yes" INTEGER,
"incite_hate_no" INTEGER,
"incite_hate_yes_pop" UINTEGER,
"incite_hate_no_pop" BIGINT,
"joint_adoption_yes" INTEGER,
"joint_adoption_no" INTEGER,
"joint_adoption_yes_pop" UINTEGER,
"joint_adoption_no_pop" BIGINT,
"lgb_military_yes" INTEGER,
"lgb_military_no" INTEGER,
"lgb_military_yes_pop" UINTEGER,
"lgb_military_no_pop" BIGINT,
"lgb_military_ban_yes" INTEGER,
"lgb_military_ban_no" INTEGER,
"lgb_military_ban_yes_pop" UINTEGER,
"lgb_military_ban_no_pop" BIGINT,
"marriage_equality_yes" INTEGER,
"marriage_equality_no" INTEGER,
"marriage_equality_yes_pop" UINTEGER,
"marriage_equality_no_pop" BIGINT,
"samesex_legal_yes" INTEGER,
"samesex_legal_no" INTEGER,
"samesex_legal_yes_pop" BIGINT,
"samesex_legal_no_pop" UINTEGER,
"third_gender_yes" INTEGER,
"third_gender_no" INTEGER,
"third_gender_yes_pop" UINTEGER,
"third_gender_no_pop" BIGINT,
"trans_military_yes" INTEGER,
"trans_military_no" INTEGER,
"trans_military_yes_pop" UINTEGER,
"trans_military_no_pop" BIGINT,
"civil_unions_yes" INTEGER,
"civil_unions_no" INTEGER,
"civil_unions_yes_pop" UINTEGER,
"civil_unions_no_pop" BIGINT,
"gendermarker_yes" INTEGER,
"gendermarker_no" INTEGER,
"gendermarker_yes_pop" UINTEGER,
"gendermarker_no_pop" BIGINT,
"death_penalty_yes" INTEGER,
"death_penalty_no" INTEGER,
"death_penalty_yes_pop" UINTEGER,
"death_penalty_no_pop" BIGINT,
"propaganda_yes" INTEGER,
"propaganda_no" INTEGER,
"propaganda_yes_pop" UINTEGER,
"propaganda_no_pop" BIGINT,
"unequal_age_yes" INTEGER,
"unequal_age_no" INTEGER,
"unequal_age_yes_pop" UINTEGER,
"unequal_age_no_pop" BIGINT
);
Anyone who has the link will be able to view this.