Global AIDS Update
@owid.unaids
@owid.unaids
CREATE TABLE owid_epi (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"estimate" VARCHAR,
"aids_mortality_1000_pop" FLOAT,
"coverage_mothers_receiving_arv" FLOAT,
"hiv_incidence" FLOAT,
"hiv_prevalence" FLOAT,
"imr" FLOAT,
"ipr" FLOAT,
"mtct_rate" FLOAT,
"pct_change_aids_deaths_2010" INTEGER,
"pct_change_new_infections_2010" INTEGER,
"people_unsupp_vl" FLOAT,
"percent_art_vl_suppressed" FLOAT,
"percent_know_status_on_art" FLOAT,
"percent_plwh" FLOAT,
"plhiv_knowledge_of_status" FLOAT,
"viral_load_suppression" FLOAT,
"aids_deaths" FLOAT,
"aids_orphans" FLOAT,
"children_exposed_uninfected" FLOAT,
"deaths_plhiv_all_causes" FLOAT,
"infections_averted_pmtct" FLOAT,
"new_infections" FLOAT,
"plwh" FLOAT,
"deaths_averted_art" FLOAT,
"mothers_needing_arv_for_pmtct" FLOAT,
"mothers_receiving_arv_for_pmtct" FLOAT,
"people_receiving_art" FLOAT,
"number_plhiv_knowledge_of_status" FLOAT,
"art_none_preg_child_inf_preg" INTEGER,
"art_drop_bf_child_inf" INTEGER,
"art_drop_preg_child_inf" INTEGER,
"mother_child_inf_bf" INTEGER,
"mother_child_inf_preg" INTEGER,
"art_none_bf" INTEGER,
"art_start_before_preg_child_inf_bf" INTEGER,
"art_start_before_preg_child_inf_preg" INTEGER,
"art_start_during_preg_child_inf_bf" INTEGER,
"art_start_child_inf_during_preg" INTEGER,
"art_start_late_preg_child_inf_bf" INTEGER,
"art_start_late_preg_child_inf_preg" INTEGER,
"number_viral_suppression" FLOAT
);
CREATE TABLE owid_gam (
"country" VARCHAR,
"year" INTEGER,
"expenditure_tb_hiv_activities" FLOAT,
"plhiv_current_tb_preventative" FLOAT,
"plhiv_in_care_with_active_tb" FLOAT,
"plhiv_receiving_tb_preventive_therapy" FLOAT,
"prisoners_tb" FLOAT,
"pwid_needles" INTEGER,
"resource_needs_ft" BIGINT,
"tb_expenditure" FLOAT,
"tb_patients_documented_hiv_positive_status" FLOAT,
"tb_patients_documented_hiv_status" FLOAT,
"new_relapse_tb_cases" UINTEGER,
"notified_tb_cases" UINTEGER,
"hiv_tb_patients_receiving_art" UINTEGER,
"hiv_tb_patients_receiving_cpt" UINTEGER,
"hiv_tb_patients_under_ipt" UINTEGER,
"tb_patients_tested_positive_hiv" UINTEGER,
"hiv_care" UINTEGER,
"newly_enrolled_care" UINTEGER,
"hiv_tb_diagnosis" UINTEGER,
"prisoners_condoms_distributed" UINTEGER,
"prisoners_ost" UINTEGER,
"num_art_init_tpt" UINTEGER,
"people_on_prep" UINTEGER,
"plhiv_current_enrolled" UINTEGER,
"plhiv_current_treatment_tb" UINTEGER,
"people_art_elig_tpt" UINTEGER,
"people_art_elig_tpt_strt" UINTEGER,
"prop_art_tpt_start" FLOAT,
"per_tpt_art_cmplt" FLOAT,
"num_art_complt_tpt" UINTEGER,
"people_new_art_elig_tpt_strt" UINTEGER,
"prop_new_art_tpt_strt" FLOAT,
"pwid_needles_distributed" UINTEGER
);
CREATE TABLE owid_gam_age (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"male_circumcisions_performed" UINTEGER
);
CREATE TABLE owid_gam_age_group (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"group" VARCHAR,
"prevalence_male_circumcision" FLOAT,
"hiv_self_tests" UINTEGER
);
CREATE TABLE owid_gam_age_sex (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"att_tow_wife_beating" FLOAT,
"demand_family_planning" FLOAT,
"hiv_pos_rate" FLOAT,
"prevalence_ipv" FLOAT,
"pwid_ost_coverage" FLOAT
);
CREATE TABLE owid_gam_age_sex_group (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"group" VARCHAR,
"art_coverage" FLOAT,
"avoidance_care" FLOAT,
"condom_use" FLOAT,
"discriminatory_attitudes" FLOAT,
"experience_stigma" FLOAT,
"hiv_prevalence" FLOAT,
"hiv_programmes_coverage" FLOAT,
"hiv_status_awareness" FLOAT,
"pwid_safety" FLOAT,
"hiv_tests" UINTEGER
);
CREATE TABLE owid_gam_estimates (
"country" VARCHAR,
"year" INTEGER,
"estimate" VARCHAR,
"comanagement_tb_hiv" FLOAT,
"hiv_new_tb_cases" FLOAT,
"incident_tb_cases" UINTEGER,
"tb_related_deaths" INTEGER
);
CREATE TABLE owid_gam_group (
"country" VARCHAR,
"year" INTEGER,
"group" VARCHAR,
"discrimination_hc_settings" FLOAT,
"domestic_spending_fund_source" FLOAT,
"resource_avail_constant" BIGINT,
"population" UINTEGER,
"condoms_distributed_pp" FLOAT
);
CREATE TABLE owid_gam_hepatitis (
"country" VARCHAR,
"year" INTEGER,
"age" VARCHAR,
"sex" VARCHAR,
"group" VARCHAR,
"hepatitis" VARCHAR,
"viral_hepatitis" FLOAT
);
CREATE TABLE owid_gam_sex (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"knowledge_in_young_people" FLOAT
);
CREATE TABLE owid_gam_sex_group (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"group" VARCHAR,
"experience_violence" FLOAT,
"syphilis_prevalence" FLOAT,
"condoms_distributed" UINTEGER
);
CREATE TABLE owid_unaids (
"country" VARCHAR,
"year" INTEGER,
"disaggregation" VARCHAR,
"aids_deaths" FLOAT,
"aids_orphans" FLOAT,
"condom_use" FLOAT,
"deaths_averted_art" FLOAT,
"discriminatory_attitudes" FLOAT,
"domestic_spending_fund_source" FLOAT,
"gap_on_art" FLOAT,
"hiv_incidence" FLOAT,
"hiv_prevalence" FLOAT,
"infections_averted_pmtct" FLOAT,
"knowledge_in_young_people" FLOAT,
"msm_condom_use" FLOAT,
"new_infections" FLOAT,
"resource_avail_constant" FLOAT,
"resource_needs_ft" FLOAT,
"domestic_spending_fund_source_per_capita" FLOAT,
"hiv_tb_patients_receiving_art" FLOAT,
"tb_patients_tested_positive_hiv" FLOAT,
"tb_related_deaths" FLOAT
);
Anyone who has the link will be able to view this.