Surface Underused Schema Data Across App

[kpeatt]

The Problem

The database has rich metadata that is never shown in the UI, including:

• motions.disposition — Tabled, Referred, Amended (not shown anywhere)
• agenda_items.is_controversial — boolean flag (not surfaced)
• agenda_items.keywords — text array tags
• transcript_segments.sentiment_score — not surfaced
• meeting_events table — Left Meeting, Returned, Recused events
• topics + agenda_item_topics — controlled taxonomy (not used)

Proposed Solution

Incrementally surface this data in relevant UI contexts as other features are built. This is a tracking issue for the general effort.

Specific Opportunities

• Show disposition on motion cards (Tabled, Referred, etc.)
• Use is_controversial flag for visual badges/indicators
• Display keywords as tags on agenda item cards
• Show meeting events (recusals, departures) in meeting timelines
• Connect topics taxonomy to topic clustering page (Topic/Issue Clustering Page #6)

Impact

Medium — Enriches every feature with data that already exists.

[kpeatt]

Partially addressed across v1.5 (document surfacing) and v1.6 (search coverage). This was a broad tracking issue — specific gaps should be filed as focused issues if found.