OnTime route dashboard

Highest daily hops for one aircraft on one flight number

Dynamic route analysis over the most recent five years of OnTime data. The lead narrative stays anchored to the current Rank 1 itinerary, while the KPI strip, map, route detail, and operational-stress pane follow the actively selected itinerary.
Ready
Visual mode: dynamic
Visual type: html_map
Date range not loaded

Load the dashboard

Enter a valid JWE token in the footer control block, then run the dashboard. The page will fetch the latest available OnTime date, default the analytical window to the most recent five years, and execute the primary, supporting, coordinate, and selection-driven lookup queries through the ClickHouse MCP endpoint.

Anchored hero narrative

Geographic pattern across the top itineraries

Selected itinerary map

Awaiting analytical results
Selection pending
Airport-coordinate lookup has not run yet.
Selected itinerary route
Airport stops in sequence
Lead itinerary stays in the narrative even when another row is selected

Selected route sequence and detail

Derived directly by splitting the selected row’s Route string on “-”.

Selection notes

Operational stress lookup

Selection-driven pane. It reruns when the active itinerary changes.

Top 10 unique itineraries

Click a row to refresh the KPI strip, map bounds, route detail, and operational-stress pane for that itinerary.

Rank Date Tail Flight Hops Repeats Route

Connector, origin, and terminus roles

Supporting query q1 over the live top 10 result set.

Geographic breadth of the top itineraries

Supporting query q2 over the live top 10 result set.

Unified query ledger

Every primary, supporting, lookup, and date-default query execution appears here with status, row count, range, and expandable SQL.