Name: Pneumonia
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Pneumonia

Pneumonia is an infection that inflames the air sacs in one or both lungs. The air sacs may fill with fluid or pus (purulent material), causing cough with phlegm or pus, fever, chills, and difficulty breathing. A variety of organisms, including bacteria, viruses and fungi, can cause pneumonia

@article{owidpneumonia,
author = {Bernadeta Dadonaite and Max Roser},
title = {Pneumonia},
journal = {Our World in Data},
year = {2018},
note = {https://ourworldindata.org/pneumonia}
}

Tables

Child Deaths From Streptococcus By Disease

@kaggle.programmerrdai_pneumonia.child_deaths_from_streptococcus_by_disease

30.4 kB
3,120 rows
6 columns

CREATE TABLE child_deaths_from_streptococcus_by_disease (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "streptococcus_pneumonia_deaths_aged_under_5" BIGINT  -- Streptococcus Pneumonia Deaths (aged Under-5),
  "streptococcus_non_pneumonia_non_meningitis_deaths_aged_under_5" BIGINT  -- Streptococcus Non-pneumonia-non-meningitis Deaths (aged Under-5),
  "streptococcus_meningitis_deaths_aged_under_5" BIGINT  -- Streptococcus Meningitis Deaths (aged Under-5)
);

Death Rates From Pneumonia And Other Lower Respiratory Af54c28a

@kaggle.programmerrdai_pneumonia.death_rates_from_pneumonia_and_other_lower_respiratory_af54c28a

529.48 kB
56,810 rows
7 columns

CREATE TABLE death_rates_from_pneumonia_and_other_lower_respiratory_af54c28a (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_lower_respiratory_infections_sex_both_age_under_5_rate" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Rate),
  "gdp_per_capita_ppp_current_international" DOUBLE  -- GDP Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Deaths From Pneumonia In People Aged 70 And Older By R 7b92e6a8

@kaggle.programmerrdai_pneumonia.deaths_from_pneumonia_in_people_aged_70_and_older_by_r_7b92e6a8

78.17 kB
6,840 rows
7 columns

CREATE TABLE deaths_from_pneumonia_in_people_aged_70_and_older_by_r_7b92e6a8 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_lower_respiratory_infections_risk_no_acce_eee73f75" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: No Access To Handwashing Facility - Sex: Both - Age: 70+ Years (Number),
  "deaths_cause_lower_respiratory_infections_risk_secondh_925d9360" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Secondhand Smoke - Sex: Both - Age: 70+ Years (Number),
  "deaths_cause_lower_respiratory_infections_risk_particu_30eb3528" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Particulate Matter Pollution - Sex: Both - Age: 70+ Years (Number),
  "deaths_cause_lower_respiratory_infections_risk_smoking_c2bdff2d" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Smoking - Sex: Both - Age: 70+ Years (Number)
);

Exclusive Breastfeeding

@kaggle.programmerrdai_pneumonia.exclusive_breastfeeding

9.75 kB
527 rows
4 columns

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

Pneumococcal Vaccination Averted Deaths

@kaggle.programmerrdai_pneumonia.pneumococcal_vaccination_averted_deaths

3.47 kB
7 rows
4 columns

CREATE TABLE pneumococcal_vaccination_averted_deaths (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_averted" BIGINT
);

Pneumonia And Lower Respiratory Diseases Deaths

@kaggle.programmerrdai_pneumonia.pneumonia_and_lower_respiratory_diseases_deaths

117.59 kB
6,840 rows
8 columns

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: Under 5 (Number),
  "deaths_lower_respiratory_infections_sex_both_age_50_69_60f44770" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 50-69 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_15_49_9327ec61" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 15-49 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_5_14__15742278" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 5-14 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_70_ye_924401ba" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 70+ Years (Number)
);

Pneumonia Careseeking

@kaggle.programmerrdai_pneumonia.pneumonia_careseeking

8.06 kB
421 rows
4 columns

CREATE TABLE pneumonia_careseeking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_children_under_5_with_symptoms_of_pneumo_15fa99a3" DOUBLE  -- Percentage Of Children Under 5 With Symptoms Of Pneumonia Taken For Care To A Health Provider
);

Pneumonia Death Rates Age Standardized

@kaggle.programmerrdai_pneumonia.pneumonia_death_rates_age_standardized

74.32 kB
6,840 rows
4 columns

CREATE TABLE pneumonia_death_rates_age_standardized (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_lower_respiratory_infections_sex_both_age_age_s_03dd0a3f" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Age-standardized (Rate)
);

Pneumonia Death Rates In Children Under 5

@kaggle.programmerrdai_pneumonia.pneumonia_death_rates_in_children_under_5

74.31 kB
6,840 rows
4 columns

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  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Rate)
);

Pneumonia Mortality By Age

@kaggle.programmerrdai_pneumonia.pneumonia_mortality_by_age

342.38 kB
6,840 rows
8 columns

CREATE TABLE pneumonia_mortality_by_age (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_lower_respiratory_infections_sex_both_age_under_5_rate" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Rate),
  "deaths_lower_respiratory_infections_sex_both_age_5_14__d95e81b4" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 5-14 Years (Rate),
  "deaths_lower_respiratory_infections_sex_both_age_15_49_7c1e8bf4" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 15-49 Years (Rate),
  "deaths_lower_respiratory_infections_sex_both_age_50_69_c0a38d76" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 50-69 Years (Rate),
  "deaths_lower_respiratory_infections_sex_both_age_70_years_rate" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 70+ Years (Rate)
);

Pneumonia Risk Factors

@kaggle.programmerrdai_pneumonia.pneumonia_risk_factors

162.34 kB
6,840 rows
12 columns

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 Stunting - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_child_w_8bcb31fa" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Child Wasting - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_low_bir_92ca2c2e" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Low Birth Weight - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_no_acce_4cca3d6f" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: No Access To Handwashing Facility - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_secondh_5806f820" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Secondhand Smoke - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_child_u_d7eef78b" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Child Underweight - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_househo_22ca5aec" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Household Air Pollution From Solid Fuels - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_non_exc_6d6a73c0" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Non-exclusive Breastfeeding - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_short_g_7a7064b7" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Short Gestation - Sex: Both - Age: Under 5 (Number)
);

Share Of One Year Olds Who Received The Final Dose Of, 752b6f2b

@kaggle.programmerrdai_pneumonia.share_of_one_year_olds_who_received_the_final_dose_of__752b6f2b

10.21 kB
1,846 rows
4 columns

CREATE TABLE share_of_one_year_olds_who_received_the_final_dose_of__752b6f2b (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "indicator_pneumococcal_conjugate_vaccines_pcv3_immuniz_b093022d" BIGINT  -- Indicator:Pneumococcal Conjugate Vaccines (PCV3) Immunization Coverage Among 1-year-olds (%)
);