Access to clean drinking water

Key: dhs_drinkwater | Category: Infrastructure |

Proportion of households whose main source of drinking water is an improved water source

Data Layer information

Source file is not available

Data is not available locally

Data is loaded into the database

Log | Files

Operation	Mean
Database unit	Fraction
Value type	`-`
Temporal resolution	`-`

Original data information

Information	Description
Format	API
Format unit	Fraction
Spatial details	Regional
Spatial coverage	Ghana
Temporal details	Cross-sectional
Temporal coverage	1991/92; 1996; 1999; 2003/04; 2007/08; 2010; 2011/12; 2015/16; 2017; 2022
Source	DHS Program (STATcompiler)
Language	en
License	CC BY-ND 4.0
Date published
Date last accessed	None
Citation

The Data Layers data can be accessed via an API. Below you see minimal code snippets to query the data. For more information regarding the API please look at the documentation.

import requests
from requests.auth import HTTPBasicAuth
from urllib.parse import urlencode

import pandas as pd
import matplotlib.pyplot as plt

# set host, like http://localhost:8000, to where your Data Hub is running
HOST = ''
# in case of basic auth set to HTTPBasicAuth('user', 'password')
AUTH = None

q = {
    'datalayer_key': 'dhs_drinkwater',

    # Optional filters to narrow down the returned data:
    #'shape_id': '',
    #'shape_type': '',
    #'start_date': '',
    #'end_date': '',
}
d = requests.get(f"{HOST}/api/datalayers/data/?{urlencode(q)}", auth=AUTH).json()
dhs_drinkwater_df = pd.DataFrame(d['data'])
dhs_drinkwater_df[''] = pd.to_datetime(dhs_drinkwater_df[''], format="")

There is no ready use snippet for API usage in R yet, though you can adapt the Python example to your R needs.