socialwatersanitationhygieneWASHSDG6world-bankWHOUNICEFfreshwaterpublic-healthdevelopmentinfrastructure

Global Water, Sanitation & Hygiene (WASH) Indicators by Country (1960–2023)

About this data

Comprehensive dataset covering water access, sanitation, hygiene, and freshwater resource indicators for 217 countries and territories from 1960 to 2023. ## Sources - **World Bank Open Data API** (WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene) - **FAO AQUASTAT** via World Bank (freshwater withdrawal and resource data) - **UN-Water / UNESCO** via World Bank (renewable freshwater resources) - **WHO Global Health Observatory** via World Bank (WASH-related mortality, child mortality) ## Key Features - **13,888 rows** covering 217 countries × 64 years (1960–2023) - **40 columns** spanning drinking water access, sanitation, hygiene, freshwater resources, health outcomes, and demographics - Urban/rural breakdowns for water, sanitation, and hygiene indicators - Freshwater withdrawal by sector (agriculture, industry, domestic) - Child mortality and WASH-attributable mortality rates - Population, urbanization, and GDP context variables - World Bank region and income level classifications ## Indicator Groups 1. **Drinking Water Access** (6 indicators): Safely managed and basic service levels, urban/rural splits 2. **Sanitation Access** (6 indicators): Safely managed and basic service levels, urban/rural splits 3. **Open Defecation** (3 indicators): National, urban, and rural rates 4. **Hygiene** (2 indicators): Basic handwashing facility access, national and rural 5. **Freshwater Resources** (7 indicators): Renewable resources, withdrawal rates by sector 6. **Health Outcomes** (4 indicators): WASH mortality, under-5 mortality, infant mortality, diarrhea treatment 7. **Context** (4 indicators): Population, urbanization, rural share, GDP per capita ## Use Cases - Analyzing global progress toward SDG 6 (Clean Water and Sanitation) - Identifying countries with persistent water/sanitation gaps - Studying the relationship between WASH access and child mortality - Comparing urban vs. rural infrastructure development - Water stress and resource allocation analysis - Climate adaptation and water security research

Schema

Name	Type	Description
country_name	string
country_code	string
region	string
income_level	string
capital_city	string
latitude	string
longitude	string
year	string
safely_managed_drinking_water_pct	string
basic_drinking_water_pct	string
rural_safely_managed_water_pct	string
urban_safely_managed_water_pct	string
rural_basic_water_pct	string
urban_basic_water_pct	string
safely_managed_sanitation_pct	string
basic_sanitation_pct	string
rural_safely_managed_sanitation_pct	string
urban_safely_managed_sanitation_pct	string
rural_basic_sanitation_pct	string
urban_basic_sanitation_pct	string
open_defecation_pct	string
rural_open_defecation_pct	string
urban_open_defecation_pct	string
basic_handwashing_facilities_pct	string
rural_handwashing_facilities_pct	string
renewable_freshwater_per_capita_cubic_m	string
renewable_freshwater_total_billion_cubic_m	string
freshwater_withdrawal_pct_of_resources	string
freshwater_withdrawal_agriculture_pct	string
freshwater_withdrawal_industry_pct	string
freshwater_withdrawal_domestic_pct	string
total_water_withdrawal_billion_cubic_m	string
wash_mortality_rate_per_100k	string
under5_mortality_rate_per_1000	string
infant_mortality_rate_per_1000	string
diarrhea_treatment_ors_pct	string
population_total	string
urban_population_pct	string
rural_population_pct	string
gdp_per_capita_usd	string

Sample Data

Preview a sample of the data before downloading.

Free

Open dataset

Quality: 2.5 / 5

0 downloads

Agent? No sign-up needed →

For AI Agents

Via MCP Server

# 1. Add to your agent's MCP config (claude_desktop_config.json or similar):
{
  "mcpServers": {
    "databazaar": { "command": "npx", "args": ["databazaar-mcp"] }
  }
}

# 2. Your agent can then call:
search_datasets({ query: "Global Water, Sanitation & Hyg" })
// Found: 279b85ba-cc86-44af-af24-57d11e75bf57
get_download_url({ dataset_id: "279b85ba-cc86-44af-af24-57d11e75bf57" })  // free — no API key needed

Via REST API

# Free dataset — no API key required:
curl https://api.databazaar.io/datasets/279b85ba-cc86-44af-af24-57d11e75bf57/download-url