Build a Water Vendor Pricing Tracker for Urban Lagos

In low-income areas of Lagos like Ajegunle, Makoko, or Bariga, piped water is either absent or unreliable. Residents buy water from vendors and tanker trucks at prices that can be ten to twenty times what wealthier households pay on the formal network. The pricing is opaque, varies street by street, and disproportionately hits the poorest families. Your task is to design and execute a small-scale data collection exercise, survey at least 20 water purchase transactions across a defined neighbourhood, and build a clear analysis of what people are paying, for what volume, from which sources, and at what time of year. You can do this through primary fieldwork, publicly available household survey data, or a combination of both. Deliver a structured data set, a one-page visual summary of your findings (a chart, infographic, or dashboard), and a short written brief (600 to 900 words) explaining what the data shows and what a ward councillor or NGO could do with it. The data set should be clean, documented, and reusable by someone else. Good work is specific. It names the area, describes the methodology honestly, acknowledges gaps, and draws at least one non-obvious insight from the numbers. A map layer showing vendor locations and price ranges would make a strong submission even stronger.