Equaldex Dataset (Equaldex, 2023)

CREATE TABLE owid_equaldex_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "homosexuality" VARCHAR,
  "changing_gender" VARCHAR,
  "marriage" VARCHAR,
  "adoption" VARCHAR,
  "age_of_consent" VARCHAR,
  "blood" VARCHAR,
  "censorship" VARCHAR,
  "conversion_therapy" VARCHAR,
  "discrimination" VARCHAR,
  "employment_discrimination" VARCHAR,
  "housing_discrimination" VARCHAR,
  "military" VARCHAR,
  "non_binary_gender_recognition" VARCHAR,
  "homosexuality_current" VARCHAR,
  "changing_gender_current" VARCHAR,
  "marriage_current" VARCHAR,
  "adoption_current" VARCHAR,
  "age_of_consent_current" VARCHAR,
  "blood_current" VARCHAR,
  "censorship_current" VARCHAR,
  "conversion_therapy_current" VARCHAR,
  "discrimination_current" VARCHAR,
  "employment_discrimination_current" VARCHAR,
  "housing_discrimination_current" VARCHAR,
  "military_current" VARCHAR,
  "non_binary_gender_recognition_current" VARCHAR
);

CREATE TABLE owid_equaldex_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "homosexuality" VARCHAR,
  "changing_gender" VARCHAR,
  "marriage" VARCHAR,
  "adoption" VARCHAR,
  "age_of_consent" VARCHAR,
  "blood" VARCHAR,
  "censorship" VARCHAR,
  "conversion_therapy" VARCHAR,
  "discrimination" VARCHAR,
  "employment_discrimination" VARCHAR,
  "housing_discrimination" VARCHAR,
  "military" VARCHAR,
  "non_binary_gender_recognition" VARCHAR,
  "gender_affirming_care" VARCHAR,
  "intersex_infant_surgery" VARCHAR,
  "homosexuality_current" VARCHAR,
  "changing_gender_current" VARCHAR,
  "marriage_current" VARCHAR,
  "adoption_current" VARCHAR,
  "age_of_consent_current" VARCHAR,
  "blood_current" VARCHAR,
  "censorship_current" VARCHAR,
  "conversion_therapy_current" VARCHAR,
  "discrimination_current" VARCHAR,
  "employment_discrimination_current" VARCHAR,
  "housing_discrimination_current" VARCHAR,
  "military_current" VARCHAR,
  "non_binary_gender_recognition_current" VARCHAR,
  "gender_affirming_care_current" VARCHAR,
  "intersex_infant_surgery_current" VARCHAR,
  "ei" FLOAT,
  "ei_legal" FLOAT,
  "ei_po" FLOAT,
  "homosexuality_missing_count" INTEGER,
  "homosexuality_illegal_death_penalty_count" INTEGER,
  "homosexuality_male_illegal_female_legal_or_uncertain_count" INTEGER,
  "homosexuality_legal_count" INTEGER,
  "homosexuality_illegal_prison_or_other_penalty_count" INTEGER,
  "homosexuality_varies_by_region_count" INTEGER,
  "homosexuality_ambiguous_count" INTEGER,
  "changing_gender_missing_count" INTEGER,
  "changing_gender_illegal_count" INTEGER,
  "changing_gender_ambiguous_count" INTEGER,
  "changing_gender_legal_no_restrictions_count" INTEGER,
  "changing_gender_legal_medical_diagnosis_required_count" INTEGER,
  "changing_gender_legal_surgery_required_count" INTEGER,
  "changing_gender_varies_by_region_count" INTEGER,
  "marriage_missing_count" INTEGER,
  "marriage_banned_count" INTEGER,
  "marriage_unrecognized_count" INTEGER,
  "marriage_civil_union_or_other_partnership_count" INTEGER,
  "marriage_legal_count" INTEGER,
  "marriage_unregistered_cohabitation_count" INTEGER,
  "marriage_varies_by_region_count" INTEGER,
  "marriage_ambiguous_count" INTEGER,
  "marriage_foreign_same_sex_marriages_recognized_only_count" INTEGER,
  "adoption_missing_count" INTEGER,
  "adoption_illegal_count" INTEGER,
  "adoption_single_only_count" INTEGER,
  "adoption_legal_count" INTEGER,
  "adoption_varies_by_region_count" INTEGER,
  "adoption_second_parent_adoption_only_count" INTEGER,
  "adoption_ambiguous_count" INTEGER,
  "age_of_consent_missing_count" INTEGER,
  "age_of_consent_unequal_count" INTEGER,
  "age_of_consent_equal_count" INTEGER,
  "age_of_consent_female_equal_male_illegal_count" INTEGER,
  "age_of_consent_ambiguous_count" INTEGER,
  "age_of_consent_varies_by_region_count" INTEGER,
  "blood_missing_count" INTEGER,
  "blood_banned_indefinite_deferral_count" INTEGER,
  "blood_legal_count" INTEGER,
  "blood_banned_1_year_deferral_count" INTEGER,
  "blood_banned_less_than_6_month_deferral_count" INTEGER,
  "blood_ambiguous_count" INTEGER,
  "blood_varies_by_region_count" INTEGER,
  "blood_banned_5_year_deferral_count" INTEGER,
  "blood_legal_with_restrictions_count" INTEGER,
  "blood_banned_6_month_deferral_count" INTEGER,
  "censorship_missing_count" INTEGER,
  "censorship_imprisonment_as_punishment_count" INTEGER,
  "censorship_no_censorship_count" INTEGER,
  "censorship_state_enforced_count" INTEGER,
  "censorship_fine_as_punishment_count" INTEGER,
  "censorship_ambiguous_count" INTEGER,
  "censorship_other_punishment_count" INTEGER,
  "censorship_varies_by_region_count" INTEGER,
  "conversion_therapy_missing_count" INTEGER,
  "conversion_therapy_not_banned_count" INTEGER,
  "conversion_therapy_banned_count" INTEGER,
  "conversion_therapy_varies_by_region_count" INTEGER,
  "conversion_therapy_sexual_orientation_only_count" INTEGER,
  "conversion_therapy_ambiguous_count" INTEGER,
  "discrimination_no_protections_count" INTEGER,
  "discrimination_missing_count" INTEGER,
  "discrimination_illegal_count" INTEGER,
  "discrimination_illegal_in_some_contexts_count" INTEGER,
  "discrimination_varies_by_region_count" INTEGER
);

CREATE TABLE owid_equaldex_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "homosexuality" VARCHAR,
  "changing_gender" VARCHAR,
  "marriage" VARCHAR,
  "adoption" VARCHAR,
  "age_of_consent" VARCHAR,
  "blood" VARCHAR,
  "censorship" VARCHAR,
  "conversion_therapy" VARCHAR,
  "discrimination" VARCHAR,
  "employment_discrimination" VARCHAR,
  "housing_discrimination" VARCHAR,
  "military" VARCHAR,
  "non_binary_gender_recognition" VARCHAR,
  "gender_affirming_care" VARCHAR,
  "intersex_infant_surgery" VARCHAR,
  "homosexuality_current" VARCHAR,
  "changing_gender_current" VARCHAR,
  "marriage_current" VARCHAR,
  "adoption_current" VARCHAR,
  "age_of_consent_current" VARCHAR,
  "blood_current" VARCHAR,
  "censorship_current" VARCHAR,
  "conversion_therapy_current" VARCHAR,
  "discrimination_current" VARCHAR,
  "employment_discrimination_current" VARCHAR,
  "housing_discrimination_current" VARCHAR,
  "military_current" VARCHAR,
  "non_binary_gender_recognition_current" VARCHAR,
  "gender_affirming_care_current" VARCHAR,
  "intersex_infant_surgery_current" VARCHAR,
  "ei" FLOAT,
  "ei_legal" FLOAT,
  "ei_po" FLOAT,
  "homosexuality_missing_count" INTEGER,
  "homosexuality_illegal_death_penalty_count" INTEGER,
  "homosexuality_legal_count" INTEGER,
  "homosexuality_male_illegal_female_legal_or_uncertain_count" INTEGER,
  "homosexuality_illegal_prison_or_other_penalty_count" INTEGER,
  "homosexuality_ambiguous_count" INTEGER,
  "homosexuality_varies_by_region_count" INTEGER,
  "changing_gender_missing_count" INTEGER,
  "changing_gender_illegal_count" INTEGER,
  "changing_gender_legal_surgery_required_count" INTEGER,
  "changing_gender_legal_no_restrictions_count" INTEGER,
  "changing_gender_varies_by_region_count" INTEGER,
  "changing_gender_legal_medical_diagnosis_required_count" INTEGER,
  "changing_gender_ambiguous_count" INTEGER,
  "marriage_banned_count" INTEGER,
  "marriage_missing_count" INTEGER,
  "marriage_civil_union_or_other_partnership_count" INTEGER,
  "marriage_legal_count" INTEGER,
  "marriage_unrecognized_count" INTEGER,
  "marriage_varies_by_region_count" INTEGER,
  "marriage_unregistered_cohabitation_count" INTEGER,
  "marriage_foreign_same_sex_marriages_recognized_only_count" INTEGER,
  "marriage_ambiguous_count" INTEGER,
  "adoption_missing_count" INTEGER,
  "adoption_illegal_count" INTEGER,
  "adoption_individual_only_count" INTEGER,
  "adoption_legal_count" INTEGER,
  "adoption_second_parent_adoption_only_count" INTEGER,
  "adoption_ambiguous_count" INTEGER,
  "adoption_varies_by_region_count" INTEGER,
  "age_of_consent_missing_count" INTEGER,
  "age_of_consent_unequal_count" INTEGER,
  "age_of_consent_equal_count" INTEGER,
  "age_of_consent_female_equal_male_unequal_or_uncertain_count" INTEGER,
  "age_of_consent_varies_by_region_count" INTEGER,
  "age_of_consent_ambiguous_count" INTEGER,
  "blood_missing_count" INTEGER,
  "blood_banned_indefinite_deferral_count" INTEGER,
  "blood_legal_count" INTEGER,
  "blood_banned_1_year_deferral_count" INTEGER,
  "blood_banned_less_than_6_month_deferral_count" INTEGER,
  "blood_ambiguous_count" INTEGER,
  "blood_varies_by_region_count" INTEGER,
  "blood_legal_with_restrictions_count" INTEGER,
  "blood_banned_5_year_deferral_count" INTEGER,
  "blood_banned_6_month_deferral_count" INTEGER,
  "censorship_missing_count" INTEGER,
  "censorship_state_enforced_count" INTEGER,
  "censorship_imprisonment_as_punishment_count" INTEGER,
  "censorship_no_censorship_count" INTEGER,
  "censorship_varies_by_region_count" INTEGER,
  "censorship_other_punishment_count" INTEGER,
  "censorship_fine_as_punishment_count" INTEGER,
  "conversion_therapy_missing_count" INTEGER,
  "conversion_therapy_not_banned_count" INTEGER,
  "conversion_therapy_banned_count" INTEGER,
  "conversion_therapy_varies_by_region_count" INTEGER,
  "conversion_therapy_sexual_orientation_only_count" INTEGER,
  "conversion_therapy_ambiguous_count" INTEGER,
  "discrimination_missing_count" INTEGER,
  "discrimination_no_protections_count" INTEGER,
  "discrimination_illegal_count" INTEGER,
  "discrimination_illegal_in_some_contexts_count" INTEGER,
  "discrimination_varies_by_region_count" INTEGER,
  "employment_discrimination_missing_count" INTEGER
);