Name: World Health Statistics 2020|Complete|Geo-Analysis
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

World Health Statistics 2020|Complete|Geo-Analysis

INTRO

This dataset covers the most recent and updated health statistics of the world (countries recognized by WHO- all), BUT the data could not be directly used as the major indicator of various subtopics in the dataset was mixed so I have filtered based on various indicators and hence, divided into subcategories. I know so many datasets seem overwhelming, but I will be giving the various categories they belong to and what they represent so do not worry!)

The dataset was filtered to increase user readability and create amazing and beautiful visualizations and EDA’s.
Listed below will be the various datasets (named csv’s) and what they represent under their categories.

Also, before starting I will soon be uploading a viz for the same and this data cleaning and filtering has along with compiling has been a great task so...

Let us get started.

DATASET (CONTENTS)

Life expectancy and Healthy life expectancy

lifeExpectancyAtBirth.csv -> Life expectancy at birth, country wise mentioned in age (years).
HALElifeExpectancyAtBirth.csv -> Healthy life expectancy (HALE) at birth, country wise mentioned in age(years).csv
WHOregionLifeExpectancAtBirth.csv -> Life expectancy at birth, Region wise mentioned in age (years).
HAleWHOregionLifeExpectancy.csv -> Healthy life expectancy at birth, region wise mentioned in age(years).
%HaleInLifeExpectancy.csv -> Healthy life and life expectancy at birth with the % of HALE in life expectancy.

Maternal mortality

Data from 2014 to 2019 indicate that approximately 81% of all births globally took place in the presence of skilled health personnel, an increase from 64% in the 2000–2006 period

maternalMortalityRatio.csv-> Maternal mortality ratio per 100,000 births
birthAttendedBySkilledPersonal.csv-> Births attended by skilled personals (percentile)

Newborn and child mortality

infantMortalityRate.csv-> Probability of dying between birth and age 1 per 1000 live births.
neonatalMortalityRate.csv -> Probability of children dying in the first 28 days of life.
under5MortalityRate.csv- > Probability of children dying below the age of 5 per 1000 live births.

Communicable Diseases

incedenceOfMalaria.csv-> Malaria incidence per 1000 population at risk
incedenceOfTuberculosis.csv-> Incidence of TB per 100,000 population per year.
hepatitusBsurfaceAntigen.csv -> Hepatitis B surface antigen (HBsAg) prevalence among children under 5 years)
interventionAgianstNTD's.csv -> Reported number of people requiring interventions against NTDs.
newHivInfections.csv ->New HIV infections per 1000 uninfected population

Noncommunicable diseases and mental health

30-70cancerChdEtc.csv -> Probability of dying between the age of 30 and exact age of 70 from any of the cardiovascular disease, cancer, diabetes, or chronic respiratory disease.
crudeSuicideRates.csv -> Crude suicide rates per 100,000 population

Substance abuse

AlcoholSubstanceAbuse.csv -> Total (recorded + unrecorded) alcohol per capita (15 +) consumption’s

Road Traffic Injuries

roadTrafficDeaths.csv -> Estimated road traffic death rate per 100,000 population

Sexual and reproductive health

reproductiveAgeWomen.csv -> Married or in-union women of reproductive age who have their need for family planning satisfied with modern methods (%)
adolescentBirthRate.csv -> Adolescent birth rate per 1000 women aged 15-19 years

Achieve universal health coverage (UHC) including financial risk protection

uhcCoverage.csv ->UHC index of service coverage (SCI)
dataAvailibilityForUhc.csv ->Data availability of UHC index of essential service coverage (%)
population10%SDG3.8.2.csv ->Population with household expenditures on health greater than 10% of total household expenditure or income (SDG indicator 3.8.2) (%)
population25%SDG3.8.2.csv -> Population with household expenditures on health greater than 25% of total household expenditure or income (SDG indicator 3.8.2) (%)

Mortality from environment pollution

airPollutionDeathRate.csv -> Ambient and household air pollution attributable death rate per 100,00 population and the same data with age-standardized.
mortalityRateUnsafeWash.csv -> Mortality rate attributed to exposure to unsafe WASH services per 100,000 population SDG3.9.2
mortalityRatePoisoning.csv -> Mortality rate attributed to unintentional poisoning per 100,000 population

Tobacco control

tobaccoAge15.csv ->Prevalence of current tobacco use among persons aged 15 years and older (age- standardized rate)

Health Workforce

medicalDoctors.csv -> Medical doctors per 10,000 population.
nursingAndMidwife.csv -> Nursing and midwifery personnel per 10,000 population.
Dentists.csv -> Dentists available per 10,000 population
Pharmacists.csv -> Pharmacists per 10,000 population

Eliminate violence Against women and girls

eliminateViolenceAgainstWomen.csv -> Proportion of ever-partnered women and girls aged 15-49 years subjected to physical and/or sexual violence by a current or former intimate partner in previous 12 months.

Drinking Water

basicDrinkingWaterServices.csv ->Population using at least basic drinking water services (%)
Sanitation and Hygiene
atLeastBasicSanitizationServices.csv - > Population using at least basic sanitation services (%)
safelySanitization.csv -> Population using safe sanitation services (%)
basicHandWashing.csv -> Population with basic handwashing facilities at home (%)

Clean household energy

cleanFuelAndTech.csv -> Proportion of population with primary reliance on clean fuels and technologies (%)

Tables

Adolescentbirthrate

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.adolescentbirthrate

13.68 KB
2189 rows
4 columns


CREATE TABLE adolescentbirthrate (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" DOUBLE
);

Airpollutiondeathrate

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.airpollutiondeathrate

103.46 KB
6588 rows
6 columns


CREATE TABLE airpollutiondeathrate (
  "location" VARCHAR,
  "dim2" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "dim1" VARCHAR,
  "first_tooltip" VARCHAR
);

Alcoholsubstanceabuse

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.alcoholsubstanceabuse

16.34 KB
2787 rows
5 columns


CREATE TABLE alcoholsubstanceabuse (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Atleastbasicsanitizationservices

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.atleastbasicsanitizationservices

44.01 KB
9368 rows
5 columns


CREATE TABLE atleastbasicsanitizationservices (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Basicdrinkingwaterservices

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.basicdrinkingwaterservices

20.68 KB
3455 rows
4 columns


CREATE TABLE basicdrinkingwaterservices (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" DOUBLE
);

Basichandwashing

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.basichandwashing

16.08 KB
2726 rows
5 columns


CREATE TABLE basichandwashing (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Birthattendedbyskilledpersonal

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.birthattendedbyskilledpersonal

10.33 KB
1755 rows
4 columns


CREATE TABLE birthattendedbyskilledpersonal (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" DOUBLE
);

Cleanfuelandtech

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.cleanfuelandtech

8.67 KB
3610 rows
4 columns


CREATE TABLE cleanfuelandtech (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "first_tooltip" BIGINT
);

Crudesuiciderates

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.crudesuiciderates

11.11 KB
2745 rows
5 columns


CREATE TABLE crudesuiciderates (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Dataavailibilityforuhc

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.dataavailibilityforuhc

6.13 KB
183 rows
4 columns


CREATE TABLE dataavailibilityforuhc (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" VARCHAR,
  "first_tooltip" DOUBLE
);

Dentists

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.dentists

13.59 KB
2134 rows
4 columns


CREATE TABLE dentists (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" DOUBLE
);

Eliminateviolenceagainstwomen

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.eliminateviolenceagainstwomen

9.59 KB
558 rows
6 columns


CREATE TABLE eliminateviolenceagainstwomen (
  "location" VARCHAR,
  "period" VARCHAR,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "dim2" VARCHAR,
  "first_tooltip" DOUBLE
);

Halelifeexpectancyatbirth

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.halelifeexpectancyatbirth

16.01 KB
2196 rows
5 columns


CREATE TABLE halelifeexpectancyatbirth (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Halewhoregionlifeexpectancyatbirth

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.halewhoregionlifeexpectancyatbirth

8.18 KB
72 rows
8 columns


CREATE TABLE halewhoregionlifeexpectancyatbirth (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "hale_expectency" DOUBLE,
  "life_expectany" DOUBLE,
  "unnamed_6" DOUBLE,
  "n__of_hale_in_life_expectancy" BIGINT
);

Hepatitusbsurfaceantigen

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.hepatitusbsurfaceantigen

8.41 KB
194 rows
4 columns


CREATE TABLE hepatitusbsurfaceantigen (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "first_tooltip" VARCHAR
);

Incedenceofmalaria

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.incedenceofmalaria

14.51 KB
2033 rows
4 columns


CREATE TABLE incedenceofmalaria (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "first_tooltip" DOUBLE
);

Incedenceoftuberculosis

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.incedenceoftuberculosis

29.46 KB
3857 rows
4 columns


CREATE TABLE incedenceoftuberculosis (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "first_tooltip" VARCHAR
);

Infantmortalityrate

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.infantmortalityrate

455.06 KB
29999 rows
5 columns


CREATE TABLE infantmortalityrate (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" VARCHAR
);

Interventionagianstntds

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.interventionagianstntds

14.93 KB
1746 rows
4 columns


CREATE TABLE interventionagianstntds (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "first_tooltip" BIGINT
);

Lifeexpectancyatbirth

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.lifeexpectancyatbirth

16.31 KB
2197 rows
5 columns


CREATE TABLE lifeexpectancyatbirth (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Maternalmortalityratio

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.maternalmortalityratio

32.21 KB
3294 rows
4 columns


CREATE TABLE maternalmortalityratio (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" VARCHAR
);

Medicaldoctors

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.medicaldoctors

19.11 KB
2506 rows
4 columns


CREATE TABLE medicaldoctors (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "first_tooltip" DOUBLE
);

Mortalityratepoisoning

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.mortalityratepoisoning

12.56 KB
2745 rows
5 columns


CREATE TABLE mortalityratepoisoning (
  "location" VARCHAR,
  "indicator" VARCHAR,
  "period" BIGINT,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

Mortalityrateunsafewash

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.mortalityrateunsafewash

9.6 KB
549 rows
5 columns


CREATE TABLE mortalityrateunsafewash (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);

N 30–70cancerchdetc

@kaggle.utkarshxy_who_worldhealth_statistics_2020_complete.n_30_70cancerchdetc

11.73 KB
2745 rows
5 columns


CREATE TABLE n_30_70cancerchdetc (
  "location" VARCHAR,
  "period" BIGINT,
  "indicator" VARCHAR,
  "dim1" VARCHAR,
  "first_tooltip" DOUBLE
);