fct_driver_isolation_stint

Driver isolation per stint and phase: one row per (stint_id, stint_phase) with stint_phase in early / mid / cliff / recovery, plus an ‘all’ row per stint (built with UNION ALL, never GROUPING SETS).

Part of the Marts family.

Driver isolation per stint and phase: one row per (stint_id, stint_phase) with stint_phase in early / mid / cliff / recovery, plus an ‘all’ row per stint (built with UNION ALL, never GROUPING SETS). Per rating: raw, n, SE, lambda, shrunk, confidence_pct, trust_label; tactical_banked_s; cliff_excess_gain_s (overextension when negative); the tier-3 identity split; and context (strategy verdict and opportunity cost, stint end cause, strategy position, lift-and-coast excess, dirty-air share). tau^2 per season from the ‘all’ rows with n >= 6. Positive = faster. Leakage: a function of the residual trajectory; no ML-contract mart may depend on it (T48, ml/tests/test_manifest_contract.py). WI-16a, _roadmap/_fixes/wi/WI-16-cumulative- driver-isolation.md.

Lineage

Overview

Property	Value
Layer	marts
Family	Marts
Contract enforced	No
Tags	driver_isolation
Upstream	fct_driver_isolation_lap, fct_driver_isolation_pair_lap, int_driver_isolation_stint_tyre, int_stint_end_regime, int_pit_strategy_value
Model-level tests	unique_combination_of_columns

21 tests guard this model - 18 generic, 3 singular.

Columns

Column	Type	Nullable	Tests	Description
stint_phase_id		Yes	not_null, unique	PK: stint_id || ’|’ || stint_phase.
stint_id		Yes	not_null	Stint identifier (int_stint_geometry.stint_id).
stint_phase		Yes	not_null, accepted_values	’recovery’ when is_recovery, else tyre_phase (T45).
race_year		Yes	not_null	Season.
race_id		Yes	not_null	FastF1 event id, e.g. 2021_8.
driver_id		Yes	not_null	Driver (three-letter code). In the pair mart, the focal driver whose gains the row reports.
constructor_id		Yes	not_null	Constructor (stg_laps.constructor_id).
stint_number		Yes		Stint ordinal within the driver’s race (int_stint_geometry).
compound		Yes	not_null	Dry compound of the stint (INTERMEDIATE and WET laps are not in Ω).
era		Yes		Regulation era: pre<era_boundary> or post<era_boundary> (var era_boundary, 2022).
n_laps		Yes	not_null	Ω laps in the group.
first_lap_number		Yes		First Ω lap number in the group.
last_lap_number		Yes		Last Ω lap number in the group.
min_age_in_stint		Yes		Youngest tyre age in the group, laps.
max_age_in_stint		Yes		Oldest tyre age in the group, laps.
pace_isolated_gain_s		Yes		Mean p over the group’s laps, s/lap, positive = faster (pure + tactical before the split).
n_pure_laps		Yes	not_null	Non-extrapolated laps with pure in the group (the pure rating’s n).
n_pair_laps		Yes	not_null	Pair-laps in the group (the relative rating’s n).
n_relative_laps		Yes	not_null	Distinct laps with at least one peer in the group.
n_teammate_pair_laps		Yes	not_null	Of n_pair_laps, those against a teammate.
relative_pace_raw_gain_s		Yes		t(peer) - t(driver), s/lap: model-free, POSITIVE = the driver faster. In aggregates, the mean over pair-laps.
identity_n_pair_laps		Yes		Pair-laps with both car terms, over which the identity_* contributions are computed.
identity_relative_pace_gain_s		Yes		Mean relative_pace_gain_s over the identity_n_pair_laps rows, s/lap. = the three identity_* contributions plus the group’s mean tyre-age bias (the seed’s pricing of the peers’ age gap, at most the match tolerance; not published, 0 when every pair is on the same tyre age). W63 design 2, 2026-10-03.
identity_pace_gap_gain_s		Yes		Contribution: SUM(pace_gap) over rows with both car terms / identity_n_pair_laps, s/lap.
identity_car_advantage_gain_s		Yes		Contribution: mean car_advantage_gain_s over identity rows, s/lap; > 0 = the driver’s car faster.
identity_traffic_advantage_gain_s		Yes		Contribution: mean traffic_advantage_gain_s over identity rows, s/lap; > 0 = he lost less to dirty air.
n_line_laps		Yes		Line laps the stint’s slope was fitted on (early/mid, not recovery, with p). Below var(‘isolation_min_stint_laps’) the slope and every tactical value are NULL.
line_slope_s_per_lap2		Yes		beta_s: REGR_SLOPE(p, age) over the stint’s line laps, s/lap per lap of age; > 0 = his isolated pace rises through the stint. NULL below the line floor or with Sxx = 0 (never NaN).
tyre_offset_vs_field_s		Yes		Mean tyre_offset_vs_field_s over the group: the strategy position, context.
lift_coast_excess_share		Yes		Mean lift_coast_excess_share over the group (context).
dirty_air_lap_share		Yes		Share of the group’s laps with is_dirty_air_lap.
stint_end_cause		Yes		int_stint_end_regime.stint_end_cause (context).
is_censored_stint		Yes		int_stint_end_regime.is_censored_stint (context).
strategy_verdict		Yes		int_pit_strategy_value.strategy_verdict (context: staying out is the pit wall’s call, not the driver’s).
opportunity_cost_s		Yes		int_pit_strategy_value.opportunity_cost_s (context).
pure_skill_gain_s		Yes		Pure pace skill, mean over the group’s non-extrapolated laps at stint-phase grain, s/lap, POSITIVE = faster / better (raw, before shrinkage). Includes the declared season offset (2018 +0.37 s, W33; see int_driver_isolation_lap_values).
pure_skill_se_s		Yes		SE of pure_skill_gain_s, s/lap (see the model header for the formula).
pure_skill_lambda		Yes		Reliability tau^2 / (tau^2 + SE^2) in [0, 1]; tau^2 per (season, rating) at this grain. 1 when SE = 0.
pure_skill_shrunk_gain_s		Yes		lambda * pure_skill_gain_s: shrunk toward 0 (the ratings are field- or peer- centred), s/lap.
pure_skill_confidence_pct		Yes		ROUND(100 * lambda * method_score); NULL until WI-16b validates the method (seed driver_isolation_method_scores).
pure_skill_trust_label		Yes	accepted_values	solid (>= 75), indicative (50-75), thin (25-50), suppress (< 25, grade F or no lambda), unvalidated (no method score yet). NULL without a raw value.
relative_pace_gain_s		Yes		Relative pace vs same-strategy peers, mean over the group’s pair-laps at stint-phase grain, s/lap, POSITIVE = faster / better (raw, before shrinkage).
relative_pace_se_s		Yes		SE of relative_pace_gain_s, s/lap (see the model header for the formula).
relative_pace_lambda		Yes		Reliability tau^2 / (tau^2 + SE^2) in [0, 1]; tau^2 per (season, rating) at this grain. 1 when SE = 0.
relative_pace_shrunk_gain_s		Yes		lambda * relative_pace_gain_s: shrunk toward 0 (the ratings are field- or peer- centred), s/lap.
relative_pace_confidence_pct		Yes		ROUND(100 * lambda * method_score); NULL until WI-16b validates the method (seed driver_isolation_method_scores).
relative_pace_trust_label		Yes	accepted_values	solid (>= 75), indicative (50-75), thin (25-50), suppress (< 25, grade F or no lambda), unvalidated (no method score yet). NULL without a raw value.