Proportion of population using safely managed drinking water services, by urban/rural (%)
Proportion of population using safely managed drinking water services, by urban/rural (%) SDG indicator SH_H2O_SAFE (SDG goal 6). Source: UN SDG Global Database. Rows are geo-area x year x disaggregation dimensions (sex, age, location/urban-rural where published).
Source: UN SDG Global Database10,780 rowsUpdated: 9/21/2026
watersanitationhygienesdg6whounicef
Quality
97
Attribution
United Nations Statistics Division, SDG Global Database
Schema
| Column | Type | Description |
|---|---|---|
| date | timestamp | Start date of the observation year (UN SDG API field timePeriodStart). |
| year | integer | Year of observation (UN SDG API field timePeriodStart). |
| series_id | string | Stable row key: geo-area code plus the SDG dimension codes for this observation. |
| series_label | string | Human-readable label: geo-area name plus the UN SDG API dimension code descriptions for this observation. |
| geo_area_code | string | UN SDG API field geoAreaCode (UN M49 area code; aggregates such as regions and income groups use codes like 2 for Africa). |
| geo_area_name | string | Geo-area name (UN SDG API field geoAreaName). |
| location | string | Disaggregation dimension from the UN SDG API (dimension 'Location'). Provider code values include: RURAL: Rural; ALLAREA: All areas; URBAN: Urban. |
| reporting_type | string | Disaggregation dimension from the UN SDG API (dimension 'Reporting Type'). Provider code values include: N: National; G: Global. |
| unit | string | Measurement unit description from the UN SDG API 'Units' attribute metadata for this series. |
| data_nature | string | Nature of the data point from the UN SDG API 'Nature' attribute metadata (e.g. Country data, Estimated data, Modelled data, Global monitoring data). |
| source | string | Source credit from the UN SDG API record (UN SDG API field source). Runs of 10+ digits are stripped from this per-row credit because they falsely trip the platform's phone-number PII heuristic; the full verbatim citation is preserved in the dataset description. |
| value | float | Estimate value for the geo-area, year and disaggregation dimensions, as published in the UN SDG Global Database (UN SDG API field value). Definition and unit are those of the SDG series — see the dataset description. |
Sample rows
| date | year | series_id | series_label | geo_area_code | geo_area_name | location | reporting_type | unit | data_nature | source | value |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000-01-01T00:00:00 | 2000 | 1.ALLAREA.G | World — All areas — Global | 1 | World | ALLAREA | G | Percentage | Non-relevant | WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (2025) | 61.26163483 |
| 2001-01-01T00:00:00 | 2001 | 1.ALLAREA.G | World — All areas — Global | 1 | World | ALLAREA | G | Percentage | Non-relevant | WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (2025) | 61.49473953 |
| 2002-01-01T00:00:00 | 2002 | 1.ALLAREA.G | World — All areas — Global | 1 | World | ALLAREA | G | Percentage | Non-relevant | WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (2025) | 61.81621552 |
| 2003-01-01T00:00:00 | 2003 | 1.ALLAREA.G | World — All areas — Global | 1 | World | ALLAREA | G | Percentage | Non-relevant | WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (2025) | 62.14219284 |
| 2004-01-01T00:00:00 | 2004 | 1.ALLAREA.G | World — All areas — Global | 1 | World | ALLAREA | G | Percentage | Non-relevant | WHO/UNICEF Joint Monitoring Programme for Water Supply, Sanitation and Hygiene (2025) | 62.47008896 |
Download sample data
Download the full sample snapshot for this dataset (sample rows, not the complete dataset).
Use with an LLM
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
cURL
curl "https://datazimuts.com/v1/datasets/unsdg/safely_managed_drinking_water" | jq '{title, rows, columns_count, license}'Python
import requests
ds = requests.get("https://datazimuts.com/v1/datasets/unsdg/safely_managed_drinking_water").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/unsdg/safely_managed_drinking_water
Tip: fetch /llms.txt for the full machine-readable catalog.