> ## Documentation Index > Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # dbt Models > Auto-generated reference for all 74 dbt models. Auto-generated reference for all 74 dbt models. ## Staging | Model | Description | | -------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------- | | [`stg_circuit_info`](/reference/models/stg/stg_circuit_info) | Corner geometry from FastF1 circuit\_info.corners. | | [`stg_events`](/reference/models/stg/stg_events) | Race-level events (damage, retirements, penalties) sourced from the raw\_dim\_events seed. | | [`stg_laps`](/reference/models/stg/stg_laps) | Cleaned lap-level data from FastF1 race sessions. | | [`stg_laps_qualifying`](/reference/models/stg/stg_laps_qualifying) | Cleaned qualifying lap data (Q1/Q2/Q3), mirroring stg\_laps for qualifying sessions. | | [`stg_pits`](/reference/models/stg/stg_pits) | One row per pit stop: a lap carrying PitInTime. | | [`stg_race_control`](/reference/models/stg/stg_race_control) | The FIA race-control message feed. | | [`stg_results`](/reference/models/stg/stg_results) | Official classified race results from FastF1 session.results. | | [`stg_results_qualifying`](/reference/models/stg/stg_results_qualifying) | Official classified results for the qualifying session. | | [`stg_sector_times`](/reference/models/stg/stg_sector_times) | Per-sector timing unpivoted from stg\_laps. | | [`stg_session_status`](/reference/models/stg/stg_session_status) | Session lifecycle events from FastF1 session.session\_status (Inactive / Started / Aborted / Finished / Finalised). | | [`stg_session_status_qualifying`](/reference/models/stg/stg_session_status_qualifying) | Session lifecycle events for the qualifying session, mirroring stg\_session\_status. | | [`stg_telemetry`](/reference/models/stg/stg_telemetry) | High-frequency car telemetry (\~10 Hz) from FastF1, one row per sample. | | [`stg_telemetry_position`](/reference/models/stg/stg_telemetry_position) | Phase 10c, the channel split. | | [`stg_track_status`](/reference/models/stg/stg_track_status) | SC/VSC/yellow/red timeline from FastF1 session.track\_status. | | [`stg_tyre_allocations`](/reference/models/stg/stg_tyre_allocations) | Pirelli weekend compound nominations for 2019-2024: which C-code each of hard/medium/soft actually was, per race. | | [`stg_weather`](/reference/models/stg/stg_weather) | Weather snapshot nearest each lap start. | ## Intermediate | Model | Description | | ---------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [`int_circuit_x_constructor_interaction`](/reference/models/int/int_circuit_x_constructor_interaction) | One row per (race\_year, race\_id, constructor\_id). | | [`int_compound_cliff_predicted`](/reference/models/int/int_compound_cliff_predicted) | Tyre compound degradation prediction using fitted survival-analysis parameters. | | [`int_constructor_car_fe`](/reference/models/int/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`](/reference/models/int/int_constructor_deg_sensitivity) | One row per (race\_year, constructor\_id, compound). | | [`int_constructor_structural_pace`](/reference/models/int/int_constructor_structural_pace) | One row per (race\_year, race\_id, constructor\_id). | | [`int_constructor_structural_pace_qualifying`](/reference/models/int/int_constructor_structural_pace_qualifying) | One row per (race\_year, race\_id, constructor\_id). | | [`int_corner_metrics`](/reference/models/int/int_corner_metrics) | Per-corner telemetry metrics. | | [`int_corner_skill_residuals`](/reference/models/int/int_corner_skill_residuals) | One row per lap per named corner. | | [`int_dirty_air_tax_component`](/reference/models/int/int_dirty_air_tax_component) | One row per lap. | | [`int_driver_circuit_affinity`](/reference/models/int/int_driver_circuit_affinity) | One row per (driver\_id, circuit\_id). | | [`int_driver_circuit_era_affinity`](/reference/models/int/int_driver_circuit_era_affinity) | One row per (driver\_id, circuit\_id, era\_key). | | [`int_driver_race_skill_loro`](/reference/models/int/int_driver_race_skill_loro) | De-confounded absolute equal-car skill, race grain (race\_year, race\_id, driver\_id). | | [`int_driver_season_ratings`](/reference/models/int/int_driver_season_ratings) | One row per (driver\_id, season). | | [`int_era_normalized_driver_rating`](/reference/models/int/int_era_normalized_driver_rating) | One row per (driver\_id, season). | | [`int_event_corrections`](/reference/models/int/int_event_corrections) | Safety car, red flag, and other race event corrections. | | [`int_field_pace_curve`](/reference/models/int/int_field_pace_curve) | Field-level baseline pace curve. | | [`int_lap_air_state`](/reference/models/int/int_lap_air_state) | Air state classification and thermal load from dirty air. | | [`int_lap_anomaly_flags`](/reference/models/int/int_lap_anomaly_flags) | Anomaly detection flags for data quality control. | | [`int_lap_corner_inputs`](/reference/models/int/int_lap_corner_inputs) | 02c (Tier 2). | | [`int_lap_fuel_state`](/reference/models/int/int_lap_fuel_state) | Fuel burnoff and weight correction. | | [`int_lap_fuel_state_qualifying`](/reference/models/int/int_lap_fuel_state_qualifying) | One row per qualifying lap. | | [`int_lap_normalized_pace`](/reference/models/int/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`](/reference/models/int/int_lap_proximity) | Phase 10a. | | [`int_lap_residual_decomposed`](/reference/models/int/int_lap_residual_decomposed) | One row per lap. | | [`int_lap_residual_decomposed_qualifying`](/reference/models/int/int_lap_residual_decomposed_qualifying) | One row per qualifying lap. | | [`int_lap_residual_stint_detrend`](/reference/models/int/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`](/reference/models/int/int_lap_telemetry_aggregates) | Per-lap telemetry features for the tyre-cliff model. | | [`int_lap_thermal_proxy`](/reference/models/int/int_lap_thermal_proxy) | Cumulative push load from tyre thermal management. | | [`int_pit_loss_circuit`](/reference/models/int/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`](/reference/models/int/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`](/reference/models/int/int_pit_strategy_value) | One row per stint. | | [`int_qualifying_decomposed`](/reference/models/int/int_qualifying_decomposed) | One row per qualifying lap. | | [`int_qualifying_driver_summary`](/reference/models/int/int_qualifying_driver_summary) | 02b (Tier 1). | | [`int_qualifying_push_laps`](/reference/models/int/int_qualifying_push_laps) | One row per qualifying lap (gated or not, so consumers filter rather than lose the row set). | | [`int_qualifying_segments`](/reference/models/int/int_qualifying_segments) | One row per (race\_year, race\_id, quali\_segment). | | [`int_sc_hazard_history`](/reference/models/int/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`](/reference/models/int/int_sector_residual_decomposed) | One row per lap per sector (3 rows/lap). | | [`int_stint_end_regime`](/reference/models/int/int_stint_end_regime) | Why did this stint end? | | [`int_stint_geometry`](/reference/models/int/int_stint_geometry) | Foundation for all downstream window functions. | | [`int_synthetic_teammate`](/reference/models/int/int_synthetic_teammate) | Synthetic teammate for driver skill extraction. | | [`int_track_evolution`](/reference/models/int/int_track_evolution) | Track temperature and grip evolution over race. | | [`int_track_geometry`](/reference/models/int/int_track_geometry) | Circuit geometry (gradient + curvature) from raw X/Y/Z telemetry, binned to 25m distance intervals. | | [`int_tyre_surface_vs_bulk_decoupling`](/reference/models/int/int_tyre_surface_vs_bulk_decoupling) | One row per lap (post-cliff only). | ## Marts | Model | Description | | ---------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | | [`dim_events`](/reference/models/dim/dim_events) | Race-level event dimension. | | [`fct_cliff_prediction_features`](/reference/models/fct/fct_cliff_prediction_features) | Lap-grain feature table for the tyre cliff XGBoost model. | | [`fct_driver_skill_features`](/reference/models/fct/fct_driver_skill_features) | Race-grain driver skill feature table for the driver skill extraction model. | | [`fct_ghost_car_pace`](/reference/models/fct/fct_ghost_car_pace) | One row per (ego\_driver, host\_constructor, race, lap). | | [`fct_ghost_race_finish`](/reference/models/fct/fct_ghost_race_finish) | One row per (host\_constructor, ego\_driver, race). | | [`fct_lap_residuals`](/reference/models/fct/fct_lap_residuals) | Lap-grain analytics table. | | [`fct_stint_features`](/reference/models/fct/fct_stint_features) | One row per stint. | | [`fct_telemetry_deltas`](/reference/models/fct/fct_telemetry_deltas) | Driver-vs-teammate corner-metric deltas. | | [`mart_corner_skill_driver`](/reference/models/fct/mart_corner_skill_driver) | Driver corner skill vs a LORO (leave-one-race-out) same-car baseline. | | [`mart_degradation_history_envelope`](/reference/models/fct/mart_degradation_history_envelope) | Pre-aggregated historical stint envelope for the Degradation Simulator. | ## Reference | Model | Description | | -------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [`dim_circuits`](/reference/models/dim/dim_circuits) | One row per event slug (circuit\_key). | | [`dim_compounds_season`](/reference/models/dim/dim_compounds_season) | One row per circuit × compound × season. | | [`dim_constructors`](/reference/models/dim/dim_constructors) | One row per constructor (team). | | [`dim_corners`](/reference/models/dim/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`](/reference/models/dim/dim_drivers) | One row per driver\_id. |