Malaria
Malaria is not good. :(
@kaggle.programmerrdai_malaria
Malaria is not good. :(
@kaggle.programmerrdai_malaria
Malaria is a disease caused by a parasite. The parasite is spread to humans through the bites of infected mosquitoes. People who have malaria usually feel very sick with a high fever and shaking chills. While the disease is uncommon in temperate climates, malaria is still common in tropical and subtropical countries
@article{owidmalaria,
author = {Max Roser and Hannah Ritchie},
title = {Malaria},
journal = {Our World in Data},
year = {2019},
note = {https://ourworldindata.org/malaria}
}
CREATE TABLE children_sleeping_under_treated_bednet (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"use_of_insecticide_treated_bed_nets_of_under_5_population" DOUBLE -- Use Of Insecticide-treated Bed Nets (% Of Under-5 Population)
);CREATE TABLE global_malaria_deaths_by_world_region (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"malaria_deaths" BIGINT
);CREATE TABLE incidence_of_malaria (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"incidence_of_malaria_per_1_000_population_at_risk" DOUBLE -- Incidence Of Malaria (per 1,000 Population At Risk)
);CREATE TABLE malaria_death_rates (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_age_standardized_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: Age-standardized (Rate)
);CREATE TABLE malaria_death_rates_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: Under 5 (Rate),
"deaths_malaria_sex_both_age_all_ages_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: All Ages (Rate),
"deaths_malaria_sex_both_age_70_years_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: 70+ Years (Rate),
"deaths_malaria_sex_both_age_50_69_years_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: 50-69 Years (Rate),
"deaths_malaria_sex_both_age_15_49_years_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: 15-49 Years (Rate),
"deaths_malaria_sex_both_age_5_14_years_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: 5-14 Years (Rate),
"deaths_malaria_sex_both_age_age_standardized_rate" DOUBLE -- Deaths - Malaria - Sex: Both - Age: Age-standardized (Rate)
);CREATE TABLE malaria_deaths_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: Under 5 (Number),
"deaths_malaria_sex_both_age_70_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 70+ Years (Number),
"deaths_malaria_sex_both_age_5_14_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 5-14 Years (Number),
"deaths_malaria_sex_both_age_15_49_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 15-49 Years (Number),
"deaths_malaria_sex_both_age_50_69_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 50-69 Years (Number)
);CREATE TABLE malaria_deaths_by_region (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_all_ages_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: All Ages (Number)
);CREATE TABLE malaria_deaths_comparisons (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_all_ages_number" DOUBLE -- Deaths - Malaria - Sex: Both - Age: All Ages (Number),
"indicator_estimated_number_of_malaria_deaths" VARCHAR,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE malaria_prevalence_vs_gdp_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"prevalence_malaria_sex_both_age_age_standardized_percent" DOUBLE -- Prevalence - Malaria - Sex: Both - Age: Age-standardized (Percent),
"gdp_per_capita_ppp_constant_2017_international" DOUBLE -- GDP Per Capita, PPP (constant 2017 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);Anyone who has the link will be able to view this.