## 1. Authoritative Data Model

- [x] 1.1 Add validated preset/custom UTC reporting-window helpers.
- [x] 1.2 Add PostgreSQL-authoritative KPI, source activity, alive breakdown, queue, and runtime queries.
- [x] 1.3 Add safe lookup normalization and bounded current-status/origin queries.

## 2. Single-Page Interface

- [x] 2.1 Build the one-page lookup, KPI, breakdown, and runtime layout with clear empty/error states.
- [x] 2.2 Replace visible legacy navigation and compatibility panels with the single-page route.
- [x] 2.3 Disable Streamlit usage telemetry while retaining loopback supervisor authority and disabled-by-default startup.

## 3. Verification

- [x] 3.1 Add focused tests for time-window validation, SQL-before-limit behavior, lookup hashing, identity search, and raw-column exclusion.
- [x] 3.2 Run dashboard and security tests, then the broader relevant suite.
- [x] 3.3 Launch through the supervisor and smoke-test desktop/mobile rendering, search, accurate 24-hour totals, and clean shutdown.