stg_race_control

The FIA race-control message feed.

Part of the Staging family.

The FIA race-control message feed. One row per message; 14,992 rows across 173 races (2018-2025), of which 5,388 are waved blue flags. Ingested since the beginning of the project and consumed by nothing until the proximity features needed it. Staged for one reason: the blue flags are a traffic label produced by race control rather than by the position channel, which makes them the only supervised check available for the proximity features that is not derived from the same sensor. The car number is resolved to driver_id here so consumers join on the key the rest of the warehouse uses.

​

Lineage

​

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No
Upstream	stg_results
Model-level tests	unique_combination_of_columns

8 tests guard this model - 7 generic, 1 singular.

​

Columns

Column	Type	Nullable	Tests	Description
message_index	integer	Yes	not_null	Position of the message in the race session feed (FastF1 message index); with race_year and race_id it identifies one message.
race_year	integer	Yes	not_null	Season year.
race_id	varchar	Yes	not_null, relationships	Numeric FastF1 event id; matches stg_laps.race_id.
message_time_s	double	Yes		Session clock of the message. NOT on the same origin as the telemetry SessionTime column (it runs to ~55,000 s on a two-hour race, i.e. it is a wall-clock derivative). Join on lap_number, not on this.
flag	varchar	Yes		Flag colour, upper-cased, NULL for non-flag messages (BLUE / YELLOW / DOUBLE YELLOW / GREEN / CLEAR / RED / CHEQUERED / BLACK AND WHITE).
driver_id	varchar	Yes	relationships	Three-letter code resolved from RacingNumber via stg_results. NULL where the message is not driver-scoped, or where the number did not resolve.
is_blue_flag_event	boolean	Yes	not_null	TRUE when this row is a blue flag whose driver identity and lap both resolved - “this driver was being lapped on this lap”. All 5,388 blue flags resolve (2018-2025; verified 2026-10-22). A flag whose number failed to resolve would be a data gap, not a negative, which is why this is a flag and not a filter.