Skip to main content
Glama
eshaambhattad-tech

CivicLens Cook County

by eshaambhattad-tech
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python

CivicLens Cook County

Public civic transparency database + MCP server. Enter any Cook County address → see every layer of local government you live under, who represents you, where the money goes, and what's on the next agenda.

Setup

python -m venv .venv && source .venv/bin/activate
pip install -r requirements.txt
cp .env.example .env   # fill in DATABASE_URL (Supabase → Settings → Database)

Enable PostGIS in Supabase: Dashboard → Database → Extensions → postgis.

Related MCP server: MCP Data Cook County

Load data

Fixture mode (no downloads needed — approximate boundaries, fake finances):

cd ingest
python tiger_loader.py --fixtures
python comptroller_loader.py --fixtures

Real data (see Build Spec §6 for sources):

python tiger_loader.py --cousub data/tl_2024_17_cousub.zip --place data/tl_2024_17_place.zip
python comptroller_loader.py --csv data/afr_export.csv

Run API

uvicorn api.main:app --reload

Endpoint

Purpose

GET /governments?address=...

Address → all containing units

GET /units?type=township&query=...

List/search units

GET /units/{id}

Unit profile + coverage flags

GET /units/{id}/finances?years_back=3

AFR summaries, per-capita

GET /compare?unit_ids=a,b&metric=per_capita_expenditures

Compare units

GET /freshness

Per-table as_of dates

Every response carries a provenance block: {source_url, as_of, certainty, note?}.

Data certainty levels

  • verified — from official filing, human-checked

  • extracted — parsed from PDF, may contain errors

  • stale_risk — older than its expected update cycle

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityStale
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • who_reps-mcp

    cstillick
    A
    license
    A
    quality
    D
    maintenance
    Given a U.S. street address, returns the people who represent it (U.S. Senators, House member, Governor, and state legislators) using free public data, with no API keys required for federal officials.
    5
    MIT

  • Cook County / Chicago Property

    hyperionxmota
    F
    license
    A
    quality
    F
    maintenance
    Hosted, pay-per-call MCP server for Cook County / Chicago property records — parcels, recorded sales & deeds, building permits, tax assessments, and comparable sales — by street address or 14-digit PIN. Pay per call via x402 (USDC on Base/Solana); no signup or API key.
    4
    -