HIV / AIDS

CREATE TABLE annual_number_of_deaths_by_cause (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "number_of_executions_amnesty_international" VARCHAR  -- Number Of Executions (Amnesty International),
  "deaths_meningitis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Meningitis - Sex: Both - Age: All Ages (Number),
  "deaths_alzheimer_s_disease_and_other_dementias_sex_bot_448cb23e" DOUBLE  -- Deaths - Alzheimer\u0027s Disease And Other Dementias - Sex: Both - Age: All Ages (Number),
  "deaths_parkinson_s_disease_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Parkinson\u0027s Disease - Sex: Both - Age: All Ages (Number),
  "deaths_nutritional_deficiencies_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Nutritional Deficiencies - Sex: Both - Age: All Ages (Number),
  "deaths_malaria_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Malaria - Sex: Both - Age: All Ages (Number),
  "deaths_drowning_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Drowning - Sex: Both - Age: All Ages (Number),
  "deaths_interpersonal_violence_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Interpersonal Violence - Sex: Both - Age: All Ages (Number),
  "deaths_maternal_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Maternal Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_hiv_aids_sex_both_age_all_ages_number" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Number),
  "deaths_drug_use_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Drug Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_tuberculosis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Tuberculosis - Sex: Both - Age: All Ages (Number),
  "deaths_cardiovascular_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Cardiovascular Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_lower_respiratory_infections_sex_both_age_all_a_04c08283" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: All Ages (Number),
  "deaths_neonatal_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Neonatal Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_alcohol_use_disorders_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Alcohol Use Disorders - Sex: Both - Age: All Ages (Number),
  "deaths_self_harm_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Self-harm - Sex: Both - Age: All Ages (Number),
  "deaths_exposure_to_forces_of_nature_sex_both_age_all_a_da879c0d" DOUBLE  -- Deaths - Exposure To Forces Of Nature - Sex: Both - Age: All Ages (Number),
  "deaths_diarrheal_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Diarrheal Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_environmental_heat_and_cold_exposure_sex_both_a_d4f48874" DOUBLE  -- Deaths - Environmental Heat And Cold Exposure - Sex: Both - Age: All Ages (Number),
  "deaths_neoplasms_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Neoplasms - Sex: Both - Age: All Ages (Number),
  "deaths_conflict_and_terrorism_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Conflict And Terrorism - Sex: Both - Age: All Ages (Number),
  "deaths_diabetes_mellitus_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Diabetes Mellitus - Sex: Both - Age: All Ages (Number),
  "deaths_chronic_kidney_disease_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Chronic Kidney Disease - Sex: Both - Age: All Ages (Number),
  "deaths_poisonings_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Poisonings - Sex: Both - Age: All Ages (Number),
  "deaths_protein_energy_malnutrition_sex_both_age_all_ag_9b9b0ecc" DOUBLE  -- Deaths - Protein-energy Malnutrition - Sex: Both - Age: All Ages (Number),
  "terrorism_deaths" DOUBLE  -- Terrorism (deaths),
  "deaths_road_injuries_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Road Injuries - Sex: Both - Age: All Ages (Number),
  "deaths_chronic_respiratory_diseases_sex_both_age_all_a_5fe95eb3" DOUBLE  -- Deaths - Chronic Respiratory Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_cirrhosis_and_other_chronic_liver_diseases_sex__97badbdc" DOUBLE  -- Deaths - Cirrhosis And Other Chronic Liver Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_digestive_diseases_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Digestive Diseases - Sex: Both - Age: All Ages (Number),
  "deaths_fire_heat_and_hot_substances_sex_both_age_all_a_a15461ab" DOUBLE  -- Deaths - Fire, Heat, And Hot Substances - Sex: Both - Age: All Ages (Number),
  "deaths_acute_hepatitis_sex_both_age_all_ages_number" DOUBLE  -- Deaths - Acute Hepatitis - Sex: Both - Age: All Ages (Number)
);

CREATE TABLE antiretroviral_therapy_coverage_among_people_living_with_hiv (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "antiretroviral_therapy_coverage_of_people_living_with_hiv" DOUBLE  -- Antiretroviral Therapy Coverage (% Of People Living With HIV)
);

CREATE TABLE art_coverage_for_pregnant_women (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "antiretroviral_therapy_coverage_for_pmtct_of_pregnant__01cf041c" DOUBLE  -- Antiretroviral Therapy Coverage For PMTCT (% Of Pregnant Women Living With HIV)
);

CREATE TABLE children_living_with_hiv (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "children_0_14_living_with_hiv" BIGINT  -- Children (0-14) Living With HIV
);

CREATE TABLE condom_use_at_last_high_risk_sex (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "condom_use_at_last_high_risk_sex_all_sexes_adults_15_49" DOUBLE  -- Condom Use At Last High-risk Sex - All Sexes Adults (15-49)
);

CREATE TABLE condom_use_during_last_high_risk_sex (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "condom_use_at_last_high_risk_sex_males_15_19" DOUBLE  -- Condom Use At Last High-risk Sex - Males 15-19,
  "condom_use_at_last_high_risk_sex_males_20_24" DOUBLE  -- Condom Use At Last High-risk Sex - Males 20-24,
  "condom_use_at_last_high_risk_sex_males_25_49" DOUBLE  -- Condom Use At Last High-risk Sex - Males 25-49,
  "condom_use_at_last_high_risk_sex_females_15_19" DOUBLE  -- Condom Use At Last High-risk Sex - Females 15-19,
  "condom_use_at_last_high_risk_sex_females_20_24" DOUBLE  -- Condom Use At Last High-risk Sex - Females 20-24,
  "condom_use_at_last_high_risk_sex_females_25_49" DOUBLE  -- Condom Use At Last High-risk Sex - Females 25-49
);

CREATE TABLE deaths_and_new_cases_of_hiv (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_all_ages_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Number),
  "incidence_hiv_aids_sex_both_age_all_ages_number" DOUBLE  -- Incidence - HIV/AIDS - Sex: Both - Age: All Ages (Number),
  "prevalence_hiv_aids_sex_both_age_all_ages_number" DOUBLE  -- Prevalence - HIV/AIDS - Sex: Both - Age: All Ages (Number)
);

CREATE TABLE deaths_from_hiv_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_under_5_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: Under 5 (Number),
  "deaths_hiv_aids_sex_both_age_70_years_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: 70+ Years (Number),
  "deaths_hiv_aids_sex_both_age_5_14_years_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: 5-14 Years (Number),
  "deaths_hiv_aids_sex_both_age_15_49_years_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: 15-49 Years (Number),
  "deaths_hiv_aids_sex_both_age_50_69_years_number" BIGINT  -- Deaths - HIV/AIDS - Sex: Both - Age: 50-69 Years (Number)
);

CREATE TABLE hivaids_deaths_and_averted_due_to_art (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_averted_due_to_art_estimate" DOUBLE  -- Deaths Averted Due To ART - Estimate,
  "aids_related_deaths_all_ages_all_ages_estimate" DOUBLE  -- AIDS-related Deaths - All Ages - All Ages Estimate
);

CREATE TABLE hiv_death_rates (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_age_standardized_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: Age-standardized (Rate)
);

CREATE TABLE hiv_death_rates_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_under_5_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: Under 5 (Rate),
  "deaths_hiv_aids_sex_both_age_70_years_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: 70+ Years (Rate),
  "deaths_hiv_aids_sex_both_age_5_14_years_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: 5-14 Years (Rate),
  "deaths_hiv_aids_sex_both_age_15_49_years_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: 15-49 Years (Rate),
  "deaths_hiv_aids_sex_both_age_50_69_years_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: 50-69 Years (Rate),
  "deaths_hiv_aids_sex_both_age_all_ages_rate" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Rate)
);

CREATE TABLE hiv_expenditure (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "country_reported_hiv_expenditure_by_funding_source_total" DOUBLE  -- Country-reported HIV Expenditure By Funding Source - Total
);

CREATE TABLE hiv_funding_and_future_requirements (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "estimated_hiv_resource_availability_for_low_and_middle_d804fd8d" DOUBLE  -- Estimated HIV Resource Availability For Low- And Middle-income Countries (million US$),
  "estimated_resource_needs_for_fast_track_targets_million_us" DOUBLE  -- Estimated Resource Needs For Fast-track Targets (million US$)
);

CREATE TABLE knowledge_hiv_prevention_in_males_vs_females (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "knowledge_about_hiv_prevention_in_young_people_males_y_5d22c276" DOUBLE  -- Knowledge About HIV Prevention In Young People - Males Young People (15-24) Yes To All Questions,
  "knowledge_about_hiv_prevention_in_young_people_females_c253840a" DOUBLE  -- Knowledge About HIV Prevention In Young People - Females Young People (15-24) Yes To All Questions,
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE life_expectancy (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "life_expectancy" DOUBLE
);

CREATE TABLE new_cases_of_hiv_infection (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "incidence_hiv_aids_sex_both_age_all_ages_number" BIGINT  -- Incidence - HIV/AIDS - Sex: Both - Age: All Ages (Number)
);

CREATE TABLE new_cases_of_hiv_unaids_vs_ihme (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "hiv_incidence_per_1000_population_all_ages_estimate" DOUBLE  -- HIV Incidence Per 1000 Population - All Ages Estimate,
  "incidence_hiv_aids_sex_both_age_all_ages_rate" DOUBLE  -- Incidence - HIV/AIDS - Sex: Both - Age: All Ages (Rate),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

CREATE TABLE number_of_children_newly_infected_with_hiv (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "children_ages_0_14_newly_infected_with_hiv" BIGINT  -- Children (ages 0-14) Newly Infected With HIV
);

CREATE TABLE number_of_children_orphaned_from_aids (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "aids_orphans_0_17_estimate" DOUBLE  -- AIDS Orphans - 0-17 Estimate
);

CREATE TABLE number_of_deaths_by_risk_factor (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_all_causes_risk_outdoor_air_pollution_owi_2223f033" BIGINT  -- Deaths - Cause: All Causes - Risk: Outdoor Air Pollution - OWID - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_systolic_blood_press_6d2d316d" BIGINT  -- Deaths - Cause: All Causes - Risk: High Systolic Blood Pressure - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_high_in_sodium_sex_b_1e7c3e5c" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet High In Sodium - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_whole_grains__97b77447" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Whole Grains - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_alcohol_use_sex_both_age__c423e43f" BIGINT  -- Deaths - Cause: All Causes - Risk: Alcohol Use - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_fruits_sex_bo_8caf0533" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Fruits - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_water_source_sex_b_2fc61ce0" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Water Source - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_secondhand_smoke_sex_both_bfa91e74" BIGINT  -- Deaths - Cause: All Causes - Risk: Secondhand Smoke - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_birth_weight_sex_both_8686a6c4" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Birth Weight - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_child_wasting_sex_both_ag_fe7dd6b3" BIGINT  -- Deaths - Cause: All Causes - Risk: Child Wasting - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_sex_sex_both_age_a_bd9458b2" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Sex - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_nuts_and_seed_3b9ce52c" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Nuts And Seeds - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_household_air_pollution_f_493ab017" BIGINT  -- Deaths - Cause: All Causes - Risk: Household Air Pollution From Solid Fuels - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_diet_low_in_vegetables_se_90ecc789" BIGINT  -- Deaths - Cause: All Causes - Risk: Diet Low In Vegetables - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_physical_activity_sex_113bde09" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Physical Activity - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_smoking_sex_both_age_all__b379affe" BIGINT  -- Deaths - Cause: All Causes - Risk: Smoking - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_fasting_plasma_gluco_9c7ae811" BIGINT  -- Deaths - Cause: All Causes - Risk: High Fasting Plasma Glucose - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_air_pollution_sex_both_ag_57d75277" BIGINT  -- Deaths - Cause: All Causes - Risk: Air Pollution - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_high_body_mass_index_sex__0ab68ab2" BIGINT  -- Deaths - Cause: All Causes - Risk: High Body-mass Index - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_unsafe_sanitation_sex_bot_769695cd" BIGINT  -- Deaths - Cause: All Causes - Risk: Unsafe Sanitation - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_no_access_to_handwashing__d22ef465" BIGINT  -- Deaths - Cause: All Causes - Risk: No Access To Handwashing Facility - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_drug_use_sex_both_age_all_ff53b46e" BIGINT  -- Deaths - Cause: All Causes - Risk: Drug Use - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_low_bone_mineral_density__0011ff40" BIGINT  -- Deaths - Cause: All Causes - Risk: Low Bone Mineral Density - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_vitamin_a_deficiency_sex__1b749459" BIGINT  -- Deaths - Cause: All Causes - Risk: Vitamin A Deficiency - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_child_stunting_sex_both_a_8f7eb8cb" BIGINT  -- Deaths - Cause: All Causes - Risk: Child Stunting - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_discontinued_breastfeedin_0b193825" BIGINT  -- Deaths - Cause: All Causes - Risk: Discontinued Breastfeeding - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_non_exclusive_breastfeedi_254d4816" BIGINT  -- Deaths - Cause: All Causes - Risk: Non-exclusive Breastfeeding - Sex: Both - Age: All Ages (Number),
  "deaths_cause_all_causes_risk_iron_deficiency_sex_both__054f5981" BIGINT  -- Deaths - Cause: All Causes - Risk: Iron Deficiency - Sex: Both - Age: All Ages (Number)
);

CREATE TABLE number_of_new_hiv_child_infections_vs_number_of_infect_aeb2f163 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "new_hiv_infections_averted_due_to_pmtct_estimate" DOUBLE  -- New HIV Infections Averted Due To PMTCT - Estimate,
  "new_hiv_infections_children_aged_0_14_children_0_14_estimate" DOUBLE  -- New HIV Infections - Children (aged 0-14) - Children (0-14) Estimate
);

CREATE TABLE resource_needs_to_meet_hiv_targets (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "estimated_resource_needs_for_fast_track_targets_million_us" BIGINT  -- Estimated Resource Needs For Fast-track Targets (million US$)
);

CREATE TABLE share_deaths_aids (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_all_ages_percent" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Percent)
);

CREATE TABLE share_deaths_aids_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_hiv_aids_sex_both_age_all_ages_percent" DOUBLE  -- Deaths - HIV/AIDS - Sex: Both - Age: All Ages (Percent)
);

CREATE TABLE share_of_children_under_five_years_old_with_hiv (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "prevalence_hiv_aids_sex_both_age_under_5_percent" DOUBLE  -- Prevalence - HIV/AIDS - Sex: Both - Age: Under 5 (Percent)
);