dim_circuits

One row per event slug (circuit_key).

Part of the Reference family.

One row per event slug (circuit_key). Lifts the circuit_reference seed into a typed dimension carrying the physical properties used for fuel-load estimation (weight_penalty_factor), track evolution (abrasiveness_index), and constructor pace decomposition (track_energy_index). circuit_key is a grand-prix/event slug, so several keys can share one physical venue (renamed events, double-headers); circuit_id is the stable physical-circuit identifier used to pool races run at the same track. Refresh the seed when layouts change.

​

Lineage

​

Overview

Property	Value
Layer	reference
Family	Reference
Contract enforced	No

17 tests guard this model - 14 generic, 3 singular.

​

Columns

Column	Type	Nullable	Tests	Description
circuit_key	varchar	Yes	not_null, unique	Event slug (grand-prix key) matching race_id in stg_laps.
circuit_id	varchar	Yes	not_null	Physical-circuit identifier (slug of circuit_name). Several event slugs can share one circuit_id (renamed events, double-headers), so it is non-unique here.
circuit_name	varchar	Yes		Human-readable circuit name from the seed.
lap_length_km	double	Yes	expect_column_values_to_be_between	Circuit lap length in kilometres.
corner_count	integer	Yes		Number of corners on the lap (used in the weight-penalty formula).
avg_lateral_g	double	Yes		Average lateral g-force proxy for the circuit (used in the weight-penalty formula).
fuel_consumption_rate_kg_per_lap	double	Yes	not_null	LEGACY — no transform model or fitter computes from it. A hand-set per-circuit burn estimate (kg/lap). Since WI-05 the fuel model burns the season’s FIA limit over the race’s scheduled laps (int_lap_fuel_state.fuel_consumption_rate_kg_per_lap), and since WI-13 (F55) fit_weight_penalty.py divides by that rate too. Kept, not dropped, because the app’s Degradation Simulator still reads it here as the burn rate of the stint it sweeps. It runs high against the model’s rate: 1.09x on average over the 36 raced circuits (0.97-1.35x; Spain 1.9 against ~1.66).
track_energy_index	double	Yes		Energy-demand index for the circuit; conditions constructor structural-pace decomposition.
abrasiveness_index	integer	Yes		Ordinal surface-abrasiveness rating driving track-evolution / rubber-in modelling.
weight_penalty_factor	double	Yes	not_null	Seconds per kg of fuel mass carried. Formula: 0.02 + 0.0002 × corner_count × avg_lateral_g. Used in int_lap_fuel_state to compute weight_corrected_lap_time.
era_start_year	integer	Yes		First season of the regulation era this circuit row applies to (e.g. 2022 ground-effect).