Child And Infant Mortality
Child and Infant Mortality Dataset
@kaggle.programmerrdai_child_and_infant_mortality
Child and Infant Mortality Dataset
@kaggle.programmerrdai_child_and_infant_mortality
CREATE TABLE number_of_deaths_from_diarrheal_diseases_by_risk_facto_3c0f063f (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_cause_diarrheal_diseases_risk_child_growth_fail_81077e0b" BIGINT,
"deaths_cause_diarrheal_diseases_risk_no_access_to_hand_bf68c2ef" BIGINT,
"deaths_cause_diarrheal_diseases_risk_suboptimal_breast_ef680568" BIGINT,
"deaths_cause_diarrheal_diseases_risk_unsafe_water_sour_364b1834" BIGINT,
"deaths_cause_diarrheal_diseases_risk_zinc_deficiency_s_14d16cda" BIGINT,
"deaths_cause_diarrheal_diseases_risk_low_birth_weight__d488618d" BIGINT,
"deaths_cause_diarrheal_diseases_risk_short_gestation_s_e94c3322" BIGINT,
"deaths_cause_diarrheal_diseases_risk_unsafe_sanitation_dcefff8f" BIGINT,
"deaths_cause_diarrheal_diseases_risk_vitamin_a_deficie_d721d620" BIGINT
);
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_children_aged_0_14_children_0_14_estimate" DOUBLE
);
CREATE TABLE per_capita_total_expenditure_on_health_vs_child_mortality (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE,
"current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE pneumonia_and_lower_respiratory_diseases_deaths (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_under_3846a113" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_50_69_60f44770" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_15_49_9327ec61" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_5_14__15742278" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_70_ye_924401ba" BIGINT
);
CREATE TABLE pneumonia_careseeking (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"percentage_of_children_under_5_with_symptoms_of_pneumo_15fa99a3" DOUBLE
);
CREATE TABLE pneumonia_death_rates_in_children_under_5 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_under_5_rate" DOUBLE
);
CREATE TABLE pneumonia_risk_factors (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_child_s_0229f330" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_child_w_8bcb31fa" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_low_bir_92ca2c2e" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_no_acce_4cca3d6f" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_secondh_5806f820" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_child_u_d7eef78b" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_househo_22ca5aec" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_non_exc_6d6a73c0" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_short_g_7a7064b7" BIGINT
);
CREATE TABLE poverty_and_child_mortality (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE,
"n__1_90_per_day_share_of_population_below_poverty_line" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE youth_mortality_rate (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"youth_mortality_rate_un_igme_2021" DOUBLE
);
Anyone who has the link will be able to view this.