dbt Models

Auto-generated reference for all 74 dbt models.

Auto-generated reference for all 74 dbt models.

Staging

Model	Description
stg_circuit_info	Corner geometry from FastF1 circuit_info.corners.
stg_events	Race-level events (damage, retirements, penalties) sourced from the raw_dim_events seed.
stg_laps	Cleaned lap-level data from FastF1 race sessions.
stg_laps_qualifying	Cleaned qualifying lap data (Q1/Q2/Q3), mirroring stg_laps for qualifying sessions.
stg_pits	One row per pit stop: a lap carrying PitInTime.
stg_race_control	The FIA race-control message feed.
stg_results	Official classified race results from FastF1 session.results.
stg_results_qualifying	Official classified results for the qualifying session.
stg_sector_times	Per-sector timing unpivoted from stg_laps.
stg_session_status	Session lifecycle events from FastF1 session.session_status (Inactive / Started / Aborted / Finished / Finalised).
stg_session_status_qualifying	Session lifecycle events for the qualifying session, mirroring stg_session_status.
stg_telemetry	High-frequency car telemetry (~10 Hz) from FastF1, one row per sample.
stg_telemetry_position	Phase 10c, the channel split.
stg_track_status	SC/VSC/yellow/red timeline from FastF1 session.track_status.
stg_tyre_allocations	Pirelli weekend compound nominations for 2019-2024: which C-code each of hard/medium/soft actually was, per race.
stg_weather	Weather snapshot nearest each lap start.

Intermediate

Model	Description
int_circuit_x_constructor_interaction	One row per (race_year, race_id, constructor_id).
int_compound_cliff_predicted	Tyre compound degradation prediction using fitted survival-analysis parameters.
int_constructor_car_fe	De-biased constructor car pace (constructor×race fixed effect), one row per (race_year, race_id, constructor_id).
int_constructor_deg_sensitivity	One row per (race_year, constructor_id, compound).
int_constructor_structural_pace	One row per (race_year, race_id, constructor_id).
int_constructor_structural_pace_qualifying	One row per (race_year, race_id, constructor_id).
int_corner_metrics	Per-corner telemetry metrics.
int_corner_skill_residuals	One row per lap per named corner.
int_dirty_air_tax_component	One row per lap.
int_driver_circuit_affinity	One row per (driver_id, circuit_id).
int_driver_circuit_era_affinity	One row per (driver_id, circuit_id, era_key).
int_driver_race_skill_loro	De-confounded absolute equal-car skill, race grain (race_year, race_id, driver_id).
int_driver_season_ratings	One row per (driver_id, season).
int_era_normalized_driver_rating	One row per (driver_id, season).
int_event_corrections	Safety car, red flag, and other race event corrections.
int_field_pace_curve	Field-level baseline pace curve.
int_lap_air_state	Air state classification and thermal load from dirty air.
int_lap_anomaly_flags	Anomaly detection flags for data quality control.
int_lap_corner_inputs	02c (Tier 2).
int_lap_fuel_state	Fuel burnoff and weight correction.
int_lap_fuel_state_qualifying	One row per qualifying lap.
int_lap_normalized_pace	Phase C: lap pace with the dirty-air cost removed, so laps run in traffic stay usable for wear/cliff fitting instead of being discarded.
int_lap_proximity	Phase 10a.
int_lap_residual_decomposed	One row per lap.
int_lap_residual_decomposed_qualifying	One row per qualifying lap.
int_lap_residual_stint_detrend	Per-stint linear drift of driver_skill_residual_s against lap_in_stint, fit on pre-cliff laps only (cliff_onset_passed = FALSE) via OLS REGR_SLOPE.
int_lap_telemetry_aggregates	Per-lap telemetry features for the tyre-cliff model.
int_lap_thermal_proxy	Cumulative push load from tyre thermal management.
int_pit_loss_circuit	Empirical circuit-specific pit-lane loss prior, read by int_pit_strategy_value in place of the largely-imputed circuit_reference constant.
int_pit_strategy_cost_curve	One row per (stint_id, horizon_scope, candidate_pit_lap_offset): the Total_Cost(L) surface int_pit_strategy_value’s header described for two years and never computed.
int_pit_strategy_value	One row per stint.
int_qualifying_decomposed	One row per qualifying lap.
int_qualifying_driver_summary	02b (Tier 1).
int_qualifying_push_laps	One row per qualifying lap (gated or not, so consumers filter rather than lose the row set).
int_qualifying_segments	One row per (race_year, race_id, quali_segment).
int_sc_hazard_history	Safety-Car / Virtual-Safety-Car base rate per circuit (venue slug) as a hazard per racing lap, POINT-IN-TIME AS OF THE START OF EACH SEASON.
int_sector_residual_decomposed	One row per lap per sector (3 rows/lap).
int_stint_end_regime	Why did this stint end?
int_stint_geometry	Foundation for all downstream window functions.
int_synthetic_teammate	Synthetic teammate for driver skill extraction.
int_track_evolution	Track temperature and grip evolution over race.
int_track_geometry	Circuit geometry (gradient + curvature) from raw X/Y/Z telemetry, binned to 25m distance intervals.
int_tyre_surface_vs_bulk_decoupling	One row per lap (post-cliff only).

Marts

Model	Description
dim_events	Race-level event dimension.
fct_cliff_prediction_features	Lap-grain feature table for the tyre cliff XGBoost model.
fct_driver_skill_features	Race-grain driver skill feature table for the driver skill extraction model.
fct_ghost_car_pace	One row per (ego_driver, host_constructor, race, lap).
fct_ghost_race_finish	One row per (host_constructor, ego_driver, race).
fct_lap_residuals	Lap-grain analytics table.
fct_stint_features	One row per stint.
fct_telemetry_deltas	Driver-vs-teammate corner-metric deltas.
mart_corner_skill_driver	Driver corner skill vs a LORO (leave-one-race-out) same-car baseline.
mart_degradation_history_envelope	Pre-aggregated historical stint envelope for the Degradation Simulator.

Reference

Model	Description
dim_circuits	One row per event slug (circuit_key).
dim_compounds_season	One row per circuit × compound × season.
dim_constructors	One row per constructor (team).
dim_corners	One row per race × circuit turn: the telemetry distance window each corner owns, derived from FastF1’s own corner table (stg_circuit_info) rather than maintained by hand.
dim_drivers	One row per driver_id.