socialwatersanitationhygieneWASHSDG6world-bankWHOUNICEFfreshwaterpublic-healthdevelopmentinfrastructure
Water, Sanitation & Hygiene Indicators
1960–2023
Source, license and coverage
Supplier documentation. These claims are separate from the automated sample score. A listing edit date is not a data freshness date.
- License
- Not documented — confirm reuse terms with the seller
- Source / creator
- Supplier-cited: World Bank Open Data; UNESCO Institute for Statistics; WHO Global Health Observatory; FAO
- Collection method
- uploaded
- Coverage / snapshot
- 1960–2023
- Data last updated
- Not documented
- Update schedule
- Not documented
Source attribution is supplier-reported. The source link identifies publisher documentation; it does not independently verify this uploaded extract. Other cited publishers: UNESCO Institute for Statistics: https://uis.unesco.org/; WHO Global Health Observatory: https://www.who.int/data/gho; FAO: https://www.fao.org/faostat/ Coverage is stated by the supplier; it has not been verified against every record in the full file.
Sample structure score: 76.9 / 100
This automated check describes the inspected sample, not factual accuracy, legal rights, representativeness, or the quality of the entire dataset. It is not a customer rating.
Assessed 10 sample records (CSV) on 2026-10-09. All records in the provided sample were checked.
| Check | Points | Evidence |
|---|---|---|
| Populated cells | 26.9 / 50 | 215 of 400 top-level cells contain a value. Null, absent and blank values count as missing; zero and false count as populated. |
| Consistent value types | 30 / 30 | 215 of 215 populated cells match their column's most common observed type. Types are inferred, not checked against real-world truth. |
| Consistent record shape | 20 / 20 | 10 of 10 records have the expected fields. CSV/TSV use the header width; JSON uses the union of observed keys. |
Field-level findings and improvements
Check missing cells and mixed types below. Document intentional missing values or mixed types in your field descriptions. Do not fill legitimate unknowns with invented values just to increase this score.
| Field | Missing cells | Most common type | Other populated types |
|---|---|---|---|
| country_name | 0 / 10 | string | 0 / 10 |
| country_code | 0 / 10 | string | 0 / 10 |
| region | 0 / 10 | string | 0 / 10 |
| income_level | 0 / 10 | string | 0 / 10 |
| capital_city | 1 / 10 | string | 0 / 9 |
| latitude | 0 / 10 | number | 0 / 10 |
| longitude | 0 / 10 | number | 0 / 10 |
| year | 0 / 10 | number | 0 / 10 |
| safely_managed_drinking_water_pct | 8 / 10 | number | 0 / 2 |
| basic_drinking_water_pct | 7 / 10 | number | 0 / 3 |
| rural_safely_managed_water_pct | 9 / 10 | number | 0 / 1 |
| urban_safely_managed_water_pct | 9 / 10 | number | 0 / 1 |
| rural_basic_water_pct | 7 / 10 | number | 0 / 3 |
| urban_basic_water_pct | 7 / 10 | number | 0 / 3 |
| safely_managed_sanitation_pct | 8 / 10 | number | 0 / 2 |
| basic_sanitation_pct | 7 / 10 | number | 0 / 3 |
| rural_safely_managed_sanitation_pct | 9 / 10 | number | 0 / 1 |
| urban_safely_managed_sanitation_pct | 9 / 10 | number | 0 / 1 |
| rural_basic_sanitation_pct | 7 / 10 | number | 0 / 3 |
| urban_basic_sanitation_pct | 7 / 10 | number | 0 / 3 |
| open_defecation_pct | 7 / 10 | number | 0 / 3 |
| rural_open_defecation_pct | 7 / 10 | number | 0 / 3 |
| urban_open_defecation_pct | 7 / 10 | number | 0 / 3 |
| basic_handwashing_facilities_pct | 10 / 10 | unknown | 0 / 0 |
| rural_handwashing_facilities_pct | 10 / 10 | unknown | 0 / 0 |
| renewable_freshwater_per_capita_cubic_m | 3 / 10 | number | 0 / 7 |
| renewable_freshwater_total_billion_cubic_m | 3 / 10 | number | 0 / 7 |
| freshwater_withdrawal_pct_of_resources | 4 / 10 | number | 0 / 6 |
| freshwater_withdrawal_agriculture_pct | 4 / 10 | number | 0 / 6 |
| freshwater_withdrawal_industry_pct | 5 / 10 | number | 0 / 5 |
| freshwater_withdrawal_domestic_pct | 5 / 10 | number | 0 / 5 |
| total_water_withdrawal_billion_cubic_m | 4 / 10 | number | 0 / 6 |
| wash_mortality_rate_per_100k | 10 / 10 | unknown | 0 / 0 |
| under5_mortality_rate_per_1000 | 0 / 10 | number | 0 / 10 |
| infant_mortality_rate_per_1000 | 0 / 10 | number | 0 / 10 |
| diarrhea_treatment_ors_pct | 10 / 10 | unknown | 0 / 0 |
| population_total | 0 / 10 | number | 0 / 10 |
| urban_population_pct | 0 / 10 | number | 0 / 10 |
| rural_population_pct | 0 / 10 | number | 0 / 10 |
| gdp_per_capita_usd | 1 / 10 | number | 0 / 9 |
About this data
Curated indicators covering drinking water access, sanitation, hygiene, freshwater resources, and health outcomes for 217 countries and territories. Includes urban/rural breakdowns, freshwater withdrawal by sector, child and WASH-attributable mortality, and contextual demographics.
Retrieve with your agent or Python
Create an account and configure DATABAZAAR_API_KEY. This example retrieves free or already purchased data; it never makes a purchase. For a multi-file dataset, choose a file index from the manifest.
Download the Python examplepython3 retrieve-dataset.py 279b85ba-cc86-44af-af24-57d11e75bf57 --output dataset.bin
Full supplier documentation
Original supplier listing: Water, Sanitation & Hygiene (WASH) Indicators — 217 Countries (1960–2023)
Curated 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.
Public sample only. Sign in to retrieve the full dataset, including free datasets.
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: "Water, Sanitation & Hygiene In" })
// Found: 279b85ba-cc86-44af-af24-57d11e75bf57
get_download_url({ dataset_id: "279b85ba-cc86-44af-af24-57d11e75bf57" }) // free — sign in with MCP OAuth firstVia REST API
# Free dataset — sign in or use your account API key: curl https://api.databazaar.io/datasets/279b85ba-cc86-44af-af24-57d11e75bf57/download-url -H "Authorization: Bearer $DATABAZAAR_API_KEY"