CheckYourCouncil.com by Douglas MangerisCheckYourCouncil.com by Douglas Mangeris

CheckYourCouncil.com

Portfolio project
Douglas Mangeris
CASE STUDY 02 / API APPLICATION · LOCAL GOVERNMENT

CheckYourCouncil.com: local government, made navigable.

Congress is watched. Your council is not. CheckYourCouncil covers all 273 incorporated municipalities in Colorado: where each one publishes its record, who sits on the council, and which towns publish nothing at all.
THE PROBLEM

273 towns, 273 different ways to publish.

Every Colorado municipality publishes agendas, minutes, and rosters differently: PDFs on a city site, a third-party agenda portal, a Facebook page, or nothing at all. A resident who wants to know what their council decided last Tuesday has to know where to look, and many never find it. There was no single place that said where the record lives for every town in the state.
THE BUILD

Inconsistent sources, one structured record.

COVERAGE

All 273 municipalities

Every city council and town board in Colorado, from Denver to the smallest statutory town.
SOURCES

Agendas, minutes, rosters

Published agendas, approved and draft minutes, and official municipal rosters, collected and normalized.
STRUCTURE

Four sections per council

The Record, Money, Your Seats, and How We Know: the same navigation for every town.
HONESTY

Non-publishers flagged

Towns that publish no records are listed as such. Absence of a record is itself a finding.
DATA

Shared platform

Built on the same Postgres and ingestion patterns as CheckYourRepresentative, so both platforms improve together.
STANCE

Record, not conclusions

The site publishes the record and lets residents draw their own conclusions.
WHY IT MATTERS

Local decisions, local data.

Zoning, water, policing, and budgets are decided at the council table, and far fewer people watch those meetings than watch Congress. CheckYourCouncil gives residents a starting point: pick your town, see who sits on the council, open the official agenda portal, and know whether minutes are draft or approved.
For clients, it demonstrates the hardest part of a data product: taking hundreds of inconsistent sources and making them navigable without inventing anything.
NEXT

0 likes · 2 views · Oct 23, 2026

Covers all 273 Colorado municipalities: collects and normalizes agendas, minutes, and council rosters so residents find local records in one place.

Tags