HIV-AIDS Data For Ukraine
HIV-AIDS dataset for Ukraine 2014-2024, transmission ways, # of cases & deaths
@kaggle.kostyaprisych_hiv_aids_data_for_ukraine
HIV-AIDS dataset for Ukraine 2014-2024, transmission ways, # of cases & deaths
@kaggle.kostyaprisych_hiv_aids_data_for_ukraine
CREATE TABLE hiv_ukraine_data_2014 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" DOUBLE,
"hiv_rate" DOUBLE,
"new_aids_cases" DOUBLE,
"aids_rate" DOUBLE,
"aids_deaths" DOUBLE,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2017 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2018 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2019 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2020 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2021 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2022 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2023 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_2024 (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" BIGINT,
"hiv_rate" DOUBLE,
"new_aids_cases" BIGINT,
"aids_rate" DOUBLE,
"aids_deaths" BIGINT,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
CREATE TABLE hiv_ukraine_data_all (
"date" TIMESTAMP,
"region" VARCHAR,
"new_hiv_cases" DOUBLE,
"hiv_rate" DOUBLE,
"new_aids_cases" DOUBLE,
"aids_rate" DOUBLE,
"aids_deaths" DOUBLE,
"death_rate" DOUBLE,
"sexual_transmission" DOUBLE,
"heterosexual" DOUBLE,
"homosexual" DOUBLE,
"parenteral_transmission" DOUBLE,
"other_transmission" DOUBLE,
"children_hiv" DOUBLE -- Children HIV+
);
Anyone who has the link will be able to view this.