The job we'll follow — one stop, two hops, 10,000 rows

A partner's catalog of bus stops slated for rebuilding, enriched with every regular rider each stop serves. Hop 1: partner_stops → route_stops finds the routes serving a stop. Hop 2: route_stops → rider_routes fans each route out into its regular riders. Click a stop to watch both hops run.

partner stop (the data being enriched)

Sample of the network

Fare zones are the partner's 4-digit zone_code; each stop shows its raw zone/stop integers. Depot Lane sits on no route — it's the left join's null case.

Two-hop enrichment

Output — one row per (stop, rider)

stop_refzone_codestop_codeclosure_startrider_id