| Title: | Household Water Costs and Coping Strategies, Accra 2023 |
|---|---|
| Description: | A household survey on water costs and coping strategies (116 households) and a water point survey (49 water points, with E. coli and total coliform test results) were conducted in October and November 2023 in two low-income communities in metropolitan Accra, Ghana. These are Korle Gonno, a larger, well-planned coastal area with over 35 household water vendors, and Abuja, a small, densely packed, extralegal settlement with 15 water vendor and bathhouse businesses. |
| Authors: | Elizabeth Vicario [aut] (ORCID: <https://orcid.org/0009-0000-6081-2076>), Margaux Götschmann [aut] (ORCID: <https://orcid.org/0009-0002-2567-3343>), Betty Avanu Davidson [aut] (ORCID: <https://orcid.org/0009-0006-9594-4048>), Ebenezer F. Amankwaa [aut] (ORCID: <https://orcid.org/0000-0002-8735-2521>), Mian Zhong [aut] (ORCID: <https://orcid.org/0009-0009-4546-7214>), Lars Schöbitz [cre] (ORCID: <https://orcid.org/0000-0003-2196-5015>) |
| Maintainer: | Lars Schöbitz <[email protected]> |
| License: | CC BY 4.0 |
| Version: | 0.0.0.9000 |
| Built: | 2026-09-24 05:14:47 UTC |
| Source: | https://github.com/openwashdata/watercostaccra |
A survey of 116 households was conducted in two low-income communities in metropolitan Accra. These are Korle Gonno, a larger, well-planned coastal area with over 35 household water vendors, and Abuja, a small, densely packed, extralegal settlement with 15 water vendor and bathhouse businesses.
householdshouseholds
A tibble with 116 rows and 89 variables
identification number
the communities surveyed, options including 1 kg: Korle Gonno and 2 abuja: Abuja
housing type, options includin 1 block_unit: unit in a row of apartments made of cement blocks, 2 wood_unit: unit in a row of apartments made of wood, 3 house, 4 compound_house: single-story L- or C-shaped house with a multiple units around a shared courtyard, 5 multistory_apt: multi-story apartment building, 6 wood_shack: wooden shack, 7 no_structure, and 8 other
respondent's relationship to the household head (respondent identified), options including 1 self, 2 child, 3 spouse, and 4 other_relative
gender (self-identified) of respondent, options including 1 female and 2 male
tenure status, options including 1 rented: renter, 2 owned: homeowner, or 3 no_payment: living without payment)
number of years respondent has lived in community
number of adults in household including respondent. Household is described as those "eating from the same pot"
number of children under 18 in household. Household is described as those "eating from the same pot"
number of rooms used for sleeping. Household is described as those "eating from the same pot"
household or respondent owns a business, options including 1 respondent-owned and 2 household-owned
location type of the business, options including 1 home_based, 2 outside_home: fixed location outside home, or 3 mobile: mobile location.
type of business, options including 1 food, 2 shop, 3 salon, 4 vented_water, 5 tailoring, and 6 other_services.
respondent's business uses water beyond typical needs of household (true or false)
primary source of water for business use (packaged water, piped to home, piped to neighbor's home, piped to compound, commercial or public tap, borehole, dug well, spring water, delivered water)
primary source of drinking water (packaged water, piped to home, piped to neighbor's home, piped to compound, commercial or public tap, borehole, dug well, spring water, delivered water)
respondent names convenience as a reason for using the drinking water source (true or false)
respondent names affordability as a reason for using the drinking water source (true or false)
respondent names availability as a reason for using the drinking water source (true or false)
respondent names temperature (cold water) as a reason for using the drinking water source (true or false)
respondent names cleanliness as a reason for using the drinking water source (true or false)
respondent names taste as a reason for using the drinking water source (true or false)
respondent names habit or cultural norm as a reason for using the drinking water source (true or false)
respondent names trustworthiness as a reason for using the drinking water source (true or false)
respondent names health as a reason for using the drinking water source (true or false)
respondent names another reason for using the drinking water source (true or false)
respondent typically purchases individual, options including 1individual: sachets/packets/bottles, 2 bag: multipacks of these, or 3 both
respondent names storage space in the home as a reason for purchasing the preferred package type (true or false)
respondent names cost effectiveness as a reason for purchasing the preferred package type (true or false)
respondent names temperature at the time of purchase as a reason for purchasing the preferred package type (true or false)
respondent names availability of money as a reason for purchasing the preferred package type (true or false)
respondent names convenience as a reason for purchasing the preferred package type (true or false)
respondent names the size needed for the respondent or household as a reason for purchasing the preferred package type (true or false)
respondent names avoiding wasting water by purchasing only when needed as a reason for purchasing the preferred package type (true or false)
treatment methods of water before drinking, options including 1no_treatment, 2 boil, 3boil;settle, 4 filter, and 5settle
primary water source for non-drinking water, options including 1packaged water, 2piped_to_home, 3piped to neighbor's home, 4piped to compound, 5commercial or public tap, 6borehole, 7dug well, 8spring water, and 9 delivered water)
respondent names proximity to home as a reason for using the primary source of non-drinking water (true or false)
respondent names convenience as a reason for using the primary source of non-drinking water (true or false)
respondent names affordability as a reason for using the primary source of non-drinking water (true or false)
respondent names availability as a reason for using the primary source of non-drinking water (true or false)
respondent names cleanliness as a reason for using the primary source of non-drinking water (true or false)
respondent names another reason for using the primary source of non-drinking water (true or false)
respondent uses at least one source besides primary non-drinking water source (true or false)
respondent uses packaged water as an additional source of non-drinking water (true or false)
respondent uses water piped to home as an additional source of non-drinking water (true or false)
respondent uses water piped to a neighbor's home as an additional source of non-drinking water (true or false)
respondent uses a commercial or public tap as an additional source of non-drinking water (true or false)
respondent uses water piped to the compound as an additional source of non-drinking water (true or false)
respondent uses a borehole as an additional source of non-drinking water (true or false)
respondent uses a dug well as an additional source of non-drinking water (true or false)
respondent uses spring water as an additional source of non-drinking water (true or false)
respondent uses delivered water as an additional source of non-drinking water (true or false)
respondent uses another source as an additional source of non-drinking water (true or false)
respondent uses a secondary source of non-drinking water because the primary source is not available (true or false)
respondent uses a secondary source of non-drinking water because the primary source is not clean (true or false)
respondent uses a secondary source of non-drinking water because the primary source is crowded (true or false)
respondent uses a secondary source of non-drinking water because shower stalls are available (true or false)
respondent uses a secondary source of non-drinking water because of its convenient location (true or false)
respondent's mechanism for paying for piped water (all respondents use piped water as a primary or secondary source). Options include 1 pay_to_fetch: paying to fetch, 2 shares_bill: sharing or paying the whole bill, or 3 both (at different taps).
daily estimated cost of drinking water for respondent's household
daily estimated cost of drinking water for respondent's household per household member
respondent has struggled to find water before (defined as extreme difficulty in accessing water) (true or false)
respondent's last time of struggle to find water, options including 1 last_3_days, 2 last_7_days, 3 last_30_days, 4 last_year, and 5 over_year_ago.
days in a week the respondent typically struggles to find or pay for water
primary reason for past struggles to find water, options including 1 availability: availability, 2 cost, and 3 distance: distance to nearest source.
respondent's knowledge about tap closures: usually known (true or false)
respondent's knowledge about tap closures: sometimes known (true or false)
respondent's knowledge about tap closures: expected due to patterns in closures (true or false)
respondent's knowledge about tap closures: not known (true or false)
respondent's knowledge about tap closures: no answer (true or false)
respondent copes with water shortage by spending more on the same amount of water (true or false)
respondent copes with water shortage by purchasing extra water to store at home (true or false)
respondent copes with water shortage by using another source (true or false)
respondent copes with water shortage by using packaged water for cooking (true or false)
respondent copes with water shortage by skipping cooking (true or false)
respondent copes with water shortage by using packaged water for bathing (true or false)
respondent copes with water shortage by skipping bathing (true or false)
respondent copes with water shortage by closing the business (true or false)
respondent copes with water shortage by skipping laundry (true or false)
respondent typically stores drinking water at home (true or false)
respondent typically stores non-drinking water at home (true or false)
respondent typically does not store water at home (true or false)
respondent stores non-drinking water in plastic jugs (jerry cans or Kufuor gallons) (true or false)
respondent stores non-drinking water in uncovered barrels (true or false)
respondent stores non-drinking water in covered barrels (true or false)
respondent stores non-drinking water in other covered containers (true or false)
respondent stores non-drinking water in other uncovered containers (true or false)
estimated capacity of storage for non-drinking water (liters)
estimated actual storage of non-drinking water (liters)
A water point survey was conducted in two low-income communities in metropolitan Accra. These are Korle Gonno, a larger, well-planned coastal area with over 35 household water vendors, and Abuja, a small, densely packed, extralegal settlement with 15 water vendor and bathhouse businesses.
waterpointswaterpoints
A tibble with 49 rows and 30 variables
identification number
the communities surveyed, options including 1 kg: Korle Gonno and 2 abuja: Abuja
water point type,options including 1 piped_water, 2 borehole, 3 public_bath, and 4 natural_spring.
services available at water point, options including (bathing, public sale of water, toilet, or comination of these)
location of the water point, options including 1 within_a_compound or 2 on_the_street: outside compound adjacent to street.
year established
year of establishment is unknown to the respondent (TRUE, otherwise NA)
owner, options including 1 household_head, 2 household_member, 3 community_member: community member outside household, and 4 multiple_community_members: multiple community members outside household
owner question not applicable (TRUE, otherwise NA)
type of constructor, options including 1 government or 2 community_member.
type of typical manager(s) of water point, options including household head or member(s), employee(s), self managed by customers, or combination of these)
estimated storage capacity in liters
average number of daily visits per customer
respondent would use this water to prepare rice, based on its quality (true or false)
respondent's perception of water quality, options including 1 acceptable, 2 high, and 3 low.
typical number of tap closures per week
current price of 25-liter jug of water (cedis)
current price of 20-liter bucket of water (cedis)
current price of 30-liter basin of water (cedis)
average price per liter, calculated by averaging price per liter of known prices (cedis)
typical dynamics of water point management during closure (increasing prices, water point likely to close due to low storage, bathing customers have less water than when taps are flowing)
manager adjusts price depending on amount of water needed or familiarity or need of customer (true or false)
price of any volume of water has increased in the last year (true or false)
source of sample for compartment bag test (CBT) supplied by Aquagenx (https://www.aquagenx.com/cbt-ectc/), options including 1 indirect_from_tap_(traveled_through_hose), 2 other_storage_(traveled_through_hose_or_poured_through_container), 3 storage_tank, and 4 tap.
results of E. Coli most probable number (MPN) test per 100 mL sample
results of E. Coli most probable number (MPN) test per 100 mL sample - upper 95% confidence interval (CI)
results of E. Coli most probable number (MPN) test per 100 mL sample - descriptive health risk, options including options including 1safe, 2possibly_safe, 3 possibly_unsafe and 4unsafe.
results of Total Coliforms (TC) most probable number (MPN) test per 100 mL sample
results of Total Coliforms (TC) most probable number (MPN) test per 100 mL sample - upper 95% confidence interval (CI)
results of Total Coliforms (TC) most probable number (MPN) test per 100 mL sample - descriptive health risk, options including 1safe, 2possibly_safe, 3 possibly_unsafe and 4unsafe.