Court daily list contaminated with wrong-venue data
resolvedQuestion: A Robinvale court-list page was showing Kerang court data from a different date. How did cross-venue data get published?
- All Magistrates' Court venues share one CMS portal URL; the refresh path forced unconditional re-fetch of whatever page the portal returned.
- refresh_article_raw overwrote title/location while preserving external_id/slug, so the row identity stayed 'Robinvale' while the content became 'Kerang'.
- A poison row (external_id court-robinvale-cri-2026-09-22, title 'Kerang Magistrates' Court Criminal List - Friday 05 November 2027') was live.
Venue- and date-specific source URLs; discovery-time published_at; event_start_at/event_end_at columns; refresh identity guard verifying venue+date before overwrite; 12-month future-date cap; poison row deleted; regression tests added.