DataBrighten

    Diarrhea treatment (% of children under 5 receiving oral rehydration and continued feeding)

    465 × 6rows × columns: 126 countries, 1986 to 2021

    Real data: World Bank, World Development Indicators, indicator SH.STA.ORCF.ZS, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows465country-year values
    Countries126with at least one value
    Years1986 – 202136 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Children with diarrhea who received oral rehydration and continued feeding refer to the percentage of children under age five with diarrhea in the two weeks prior to the survey who received either oral rehydration therapy or increased fluids, with continued feeding.

    Limits and exceptions (World Bank note)

    Recommendations for the use of oral rehydration therapy have changed over time based on scientific progress, so it is difficult to accurately compare use rates across countries. Until the current recommended method for home management of diarrhea is adopted and applied in all countries, the data should be used with caution. Also, the prevalence of diarrhea may vary by season. Since country surveys are administered at different times, data comparability is further affected.

    The numbers in 2006

    In 2006, 44 countries have a value. The highest is Serbia (71); the lowest is Somalia, Fed. Rep. (6.8). The median country value is 41.85.

    Top 10 countries, 2006

    % of children under 5 receiving oral rehydration and continued feeding

    Source: World Bank, SH.STA.ORCF.ZS, retrieved 19 November 2026. Computed from diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv.

    Highest, 2006

    #CountryValue
    1Serbia71
    2Viet Nam64.8
    3Montenegro64.3
    4Iraq64
    5Sao Tome and Principe63
    6Tunisia62
    7Peru60
    8Sudan55.9
    9Bosnia and Herzegovina53
    10Cambodia50

    Lowest, 2006

    #CountryValue
    1Somalia, Fed. Rep.6.8
    2Togo22
    3Kyrgyz Republic22
    4Cameroon22
    5Algeria24
    6India24.1
    7Guinea-Bissau25
    8Turkmenistan25.2
    9Belize26
    10Malawi27
    How many countries report, by decade
    DecadeMost countries in one year
    1980s4
    1990s7
    2000s51
    2010s30
    2020s10

    First rows

    diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201147.5
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201540.7
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income201848.5
    AlbaniaALBEurope & Central AsiaUpper middle income200051
    AlbaniaALBEurope & Central AsiaUpper middle income200550
    AlbaniaALBEurope & Central AsiaUpper middle income200963.3
    AlbaniaALBEurope & Central AsiaUpper middle income201852.5
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income200624

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberDiarrhea treatment (% of children under 5 receiving oral rehydration and continued feeding), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2006?

    Serbia, with 71.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2006)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2006)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2006
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2006);

    pandas (df = pd.read_csv("diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv"))

    y = df[df.year == 2006]
    y[y.value == y.value.max()][["country", "value"]]

    File: diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv

    How many countries report a value for 2006?

    44 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2006)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2006;

    pandas (df = pd.read_csv("diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv"))

    (df.year == 2006).sum()

    File: diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv

    What is the median across countries in 2006?

    41.85 (median of the 44 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2006))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2006 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2006) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2006));

    pandas (df = pd.read_csv("diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv"))

    df[df.year == 2006]["value"].median()

    File: diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv

    Which year has the most countries reporting?

    2000, with 51 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: diarrhea-treatment-percent-of-children-under-5-receiving-oral-rehydration-and-continued-fe.csv