469 Tracker

469 Tracker started with a simple question that was annoyingly hard to answer: where does each member of Nigeria's National Assembly stand on the Reserved Seats for Women Bill?

The Problem

The information was out there, but not in a way most people could use. It lived across updates, screenshots, statements, and documents you would only open if you already cared a lot.

I did not want to build a policy archive. I wanted a public tool you could open, check your state, and understand quickly.

Core Idea

The map became the center of it. Once that clicked, the product got much clearer.

A long explanation would keep the bill abstract. The map makes it local. You can move from a national debate to your state and the people representing it.

Data Visualization

The map had to do real work.

It carries state stance, vote distribution, hover summaries, direct selection, and the deeper view when a state is opened.

That mix matters. People need to scan first, then inspect when they have a reason to.

• State-by-state exploration through an interactive Nigeria map
• Color-coded stance reading for quick scanning
• Hover summaries for fast context
• Selected-state overlays for deeper inspection
• Aggregate vote distribution for a national read at a glance

Design Direction

I wanted campaign energy without noise. Bold type, high contrast, and clear color signals gave the issue some urgency while the interactions stayed simple.

Someone might arrive from a social post or a news link. The page had to orient them before their attention moved on.

Engineering

I kept the build light: React, Vite, Tailwind, Motion, Lenis, React Simple Maps, and D3 geographic tooling.

Google Sheets was the right source of truth here. It kept updates boring in the good way, while the frontend normalized the data, joined it with GeoJSON, and calculated the totals the map needed.

• Google Sheets as an editable source of truth
• GeoJSON + map projection for the state visualization
• Frontend aggregation for state totals and stance counts
• Motion for overlays, dropdowns, and progressive disclosure

Impact

The finished tracker made the bill easier to see and easier to talk about.

It also travelled well. The work was featured by Premium Times and TechCabal. That mattered because the tracker was meant to travel, not just sit quietly online.

I like this project because the interface, the data, and the public story all had to hold each other up.