I · Three questions a working civic team asks
From FOI to cross-portal join to coverage gap.
Demo 1 · Municipal motion lookup1.3 ms · local
motion · social housing density · Berlin districts · 2022–2026 · vote outcome
01BVV-Mitte motion 0492/VI · density-up-zoning · passed 32–19 · 2024-06. OParl · Berlin Mitte · BVV-Drs 0492/VI
0.94
02BVV-Pankow companion motion — withdrawn before vote. OParl · Berlin Pankow · 2024-09
0.85
Demo 2 · Deadline-missed scan on the portalscan · weekly
scan · public-body deliverables · deadline passed · not yet published
01Ministry X · annual transparency report · due 2025-09 · still unpublished. scan · anomaly.civic.deadline-missed.de · gov portal · 14 mo overdue
0.92
02EU agency · open-data refresh · 22 datasets last updated 2023-Q4. scan · anomaly.civic.coverage-gap.de · 22 datasets stale
0.84
Sources are public, but the join across them and the anomaly detection are what's hard to do without Indago.
II · What's included
data.gov, OParl, EU open data — joined.
Pair with Legal for citing the directive, with Procurement for tender-side context, with Business for macro joins.
- data.gov · EU open data · OParl~120 portals · delta-indexed
- National gov portalsDE / FR / ES / IT / UK / NL / AT / Nordics
- Deadline-missed · coverage-gap · off-agenda-motion (DE)scan · anomaly.civic.deadline-missed.de · anomaly.civic.coverage-gap.de · anomaly.civic.off-agenda-motion.de
- Jurisdiction-conflict (DE)scan · anomaly.legal.jurisdiction-conflict.de — cross-state law conflicts on German legal sources
- Investigative exportcite-ready, URL + date + retrieval hash
Sources of recorddata.govEU open dataOParlGovInfo (US)Bundestagdata.gouv.frdata.gov.uk
II.5 · Sample workflows
Real workflows. Real numbers.
Three workflows shaped for this bundle. Where the box reads Verified, the numbers come from a real run logged in this codebase. Where it reads Pending validation, the workflow shape is implemented and we are still gathering the headline numbers before we publish them.
Workflow 01
Pending validation
OParl municipal motion lookup
Investigative journalism
- InputTopic + district list + date range.
- MethodCross-portal ranked search over OParl + national open-data.
- OutputPer-district motion record with vote tallies and meeting protocols attached.
Cross-district
OParl fetcher works on cached data — pending a published live newsroom workflow.
Workflow 02
Pending validation
Deadline-missed scan
Public-sector audit
- InputMinistry / agency portfolio.
- Method
anomaly.civic.deadline-missed.de + anomaly.civic.coverage-gap.de scans on the DE portal dump.
- OutputOverdue-reports list with portal URL, due date and elapsed-time per item.
Overdue surfacing
Pending a real-portfolio audit run before publishing the per-ministry numbers.
Workflow 03
Pending validation
Cross-portal join · FOI replacement
Civic tech
- InputSubject + portal scope.
- MethodCross-portal entity-resolution +
anomaly.legal.jurisdiction-conflict.de scan (DE-scoped).
- OutputJoined record set with provenance per cell.
Months → minutes
Workflow is demoable on cached portals — pending a customer FOI-equivalent run.
Verified workflows are reproducible against the index hash listed in each run. Pending workflows are a written commitment, not a customer quote — we publish numbers only when we have measured them.
Civic bundle · from€499/ seat / month· newsroom & NGO discount · sovereign / air-gapped options
Indago surfaces signals for human review. Anomaly flags are indicators warranting further investigation, not findings of wrongdoing or proof of misconduct.