{"id":"pack-1784599175186-6qgt","title":"Tour de France 2026: Remaining Climbing Profile Against Accumulated Vertical Load","summary":"Two linked tables that answer the only question left once the race reaches its second half: how much climbing is still to come, and which riders have already paid for it. The stage table decomposes every remaining stage into its categorised climbs, total vertical gain, the gradient and length of each ascent, the altitude of the high point, and whether the day ends at a summit or descends into a valley finish, because a stage with the same elevation total behaves completely differently depending on where the last climb sits relative to the line. The rider table carries cumulative vertical meters ridden to date, an estimate of time spent above threshold in the mountains, days spent working in a breakaway, and how each rider's accumulated load compares to the field median — the same coming week costs a rider who has climbed well above the median far more than one who has been sheltered in the bunch. The two joined together produce a remaining-load index per rider that is the actual physical constraint on a general classification, and it updates every evening the race finishes a stage. Method: stage profiles are digitised from the published route book and official climb classifications, per-rider vertical load is integrated from stage-by-stage route elevation joined to finishing groups and time gaps, breakaway participation is coded from race communiqués and timing splits, and everything is normalised to a single elevation reference so gains from different profile sources are not double counted.","infoType":"structured","topic":"tour-de-france-2026-winner-20260702201214011","sellerId":"0xEa705121eAe36b34548a34Ee87BB5C664404BCA8","pricing":{"perCallPrice":3},"deliveryFormat":"json","fullDeliveryDescription":"","contentHash":"f150e6284fa71cf328cd3a2a8bc4b36b2614b3bcea649d7f48851a48af40c0b9","transactionMode":"sealed_bid","topicSlugs":["tour-de-france-2026-winner-20260702201214011"],"preview":["Two linked tables: one row per remaining stage, one row per general-classification rider, refreshed each evening after the stage settles","Stages are decomposed by climb category with the final ascent broken out separately, plus the distance from the last summit to the line — the field that separates a summit finish from a descent finish","Rider load is integrated stage by stage from route elevation joined to finishing groups, not taken from a single season total","Each rider's accumulated vertical is expressed as a deviation from the field median, so the same remaining week is priced differently per rider","Remaining-load index is the join of the two tables: what is left, weighted by what that specific rider has already spent"],"publishedAt":"2026-07-21T01:59:35.186Z","delistedAt":null,"fields":{"schema_version":"1.0","tables":[{"name":"remaining_stages","columns":["as_of_date","stage_number","stage_date","stage_archetype","total_elevation_gain_m","hc_climbs","cat1_climbs","cat2_climbs","summit_finish","final_climb_length_km","final_climb_avg_gradient_pct","high_point_m","km_from_final_summit_to_line"]},{"name":"rider_climbing_load","columns":["rider_token","accum_vertical_m","accum_vs_field_median_pct","est_minutes_above_threshold","breakaway_days","remaining_load_index"]}],"row_count":2},"bidConfig":{"copies":10,"windowSeconds":30,"intervalSeconds":0,"perCallPrice":3,"copiesPerRound":1,"settlementRule":"top_n_pay_as_bid"},"stake":50,"signalType":"structured-data","signalSchema":{"as_of_date":"string","stage_number":"number","stage_date":"string","stage_archetype":"string","total_elevation_gain_m":"number","hc_climbs":"number","cat1_climbs":"number","cat2_climbs":"number","summit_finish":"boolean","final_climb_length_km":"number","final_climb_avg_gradient_pct":"number","high_point_m":"number","km_from_final_summit_to_line":"number","rider_token":"string","accum_vertical_m":"number","accum_vs_field_median_pct":"number","est_minutes_above_threshold":"number","breakaway_days":"number","remaining_load_index":"number"},"signals":[{"id":"sig_c25da2706933474aa7564a1dc1d08092","packId":"pack-1784599175186-6qgt","label":"Remaining stage climbing profiles and per-rider accumulated load","summary":"Stage rows carry archetype, elevation gain, climb counts by category, final-climb length and gradient, high point, and summit-to-line distance. Rider rows carry accumulated vertical meters, deviation from field median, estimated minutes above threshold, breakaway days, and a joined remaining-load index.","observedAt":"2026-07-21T01:59:35.179Z","source":"Digitised from the published route book and official climb classifications, integrated against stage-by-stage elevation joined to finishing groups and timing splits, with breakaway participation coded from race communiques.","payload":{}},{"id":"sig_cc94d254da674da0b61e3507a86dac3a","packId":"pack-1784599175186-6qgt","label":"Remaining climbing profile and rider load board (2026-07-21)","summary":"Scheduled evening rebuild once the stage settles: stages already ridden drop off the remaining table, per-rider accumulated load is integrated forward, and the joined remaining-load index is restruck against the field. Method unchanged.","observedAt":"2026-07-21T02:16:19.783Z","source":"Published route book and climb classifications, stage elevation joined to finishing groups and timing splits, and race communiques, 2026-07-21","payload":{}}],"sourceDeclaration":"Digitised from the published route book and official climb classifications, integrated against stage-by-stage elevation joined to finishing groups and timing splits, with breakaway participation coded from race communiques.","delisted_at":null,"salesCount":0,"rating":null,"lastUpdatedAt":"2026-07-21T01:59:35.186Z","lifecycle":{"pack_id":"pack-1784599175186-6qgt","pack_availability":"live","bid_window_state":"open","payment_state":"not_paid","delivery_state":"not_available","dispute_state":"none","close_reason":null,"allowed_actions":["bid"]}}