✦ Civic data platform · In development

EAIP — Electricity Insight Platform

In Development

Civic data platform that converts unstructured electricity supply experience into structured insight for personal planning and community visibility in Nigeria.

Stack: Event-driven ingestionMake.comTelegramREST APIUser research
Status: In Development
Year: —

OVERVIEW

EAIP is a data platform that transforms unstructured, experience-based knowledge of electricity supply in Nigeria into structured, queryable insight — enabling both personal planning and community-level visibility. Electricity access in Nigeria is not just unreliable — it is opaque. Households operate on guesswork and memory. EAIP changes that by capturing real-world supply events and converting them into actionable intelligence — making an invisible system measurable. Status: Pre-build · Data pipeline in development · Architecture designed and validated through user research Technical architecture Data ingestion: Stateless event capture — power state transitions logged in real time Processing pipeline: Event normalisation → interval reconstruction → feature extraction → time-series transformation → reliability scoring (frequency × duration × consistency) Data model: Relational schema optimised for time-series event data — users, locations, event logs, computed intervals, aggregated metrics Backend: RESTful API serving processed insights, designed for real-time and batch processing Frontend: Not yet prioritised — initial focus is data correctness, density, and pipeline reliability Validated assumptions User research confirmed both core hypotheses before a line of production code was written: ✦ Patterns exist — users consistently report noticing recurring supply behaviours, even without data to confirm them ✦ Insight drives behaviour change — access to reliable supply windows would meaningfully influence daily planning and energy usage decisions

THE PROBLEM

Electricity supply across Nigeria is unreliable — and most people have found ways to work around it. Generators, inverters, and careful scheduling are the norm. The workarounds exist. What hasn't been solved is the invisibility. There is no structured data on when power actually arrives, how long it lasts, or which areas are better or worse served. Citizens manage outages individually and informally — but nobody is measuring the system. Without measurement there is no accountability, no evidence base for advocacy, and no way to plan beyond instinct and memory. The barrier to improvement is not technical. It's the absence of data.

WHAT WAS BUILT

✦Personal insight layer — electricity availability trends, identification of reliable supply windows, rolling reliability score, and trend analysis over time
✦Community intelligence layer — aggregated reliability metrics by area, comparative insights across locations, peak and low supply windows, and data-backed visibility into distribution disparities
✦Data collection system — lightweight event logging designed for low friction and accessibility, capturing timestamped supply state changes without requiring app installation
✦Computation and processing pipeline — transformation of raw event logs into structured supply intervals, derivation of reliability metrics, and aggregation across users and geographies
✦API layer — centralised data access layer serving both personal and community views, designed for extensibility across mobile apps, dashboards, and third-party integrations

THE INSIGHT

EAIP is civic data infrastructure delivered through a personal utility. At the individual level it enables better daily decision-making. At the community level it introduces something currently missing: quantifiable evidence of how electricity is distributed across Nigeria — data that communities can organise around, take to utility companies, and present to government bodies. That shift from informal frustration to structured evidence is where civic data becomes genuinely powerful. The data collection approach reflects the same principle — meeting people in interfaces they already use daily, removing every possible barrier between a citizen and a data point.

STACK & TOOLS