stg_results_qualifying

Official classified results for the qualifying session.

Part of the Staging family.

Official classified results for the qualifying session. One row per driver × session. The Q1/Q2/Q3 columns are each driver’s official best lap in each segment and are populated only on the qualifying session’s own results (they are always null on the race session’s, which is what stg_results reads). Those times are the anchors int_qualifying_segments matches back to the laps that set them.

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

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

Columns

Column	Type	Nullable	Tests	Description
quali_result_id	varchar	Yes	not_null, unique	Surrogate key {race_id}Q{driver_id}.
race_year	integer	Yes	not_null	Season year.
race_id	varchar	Yes	not_null	Numeric FastF1 event id cast to string; matches stg_laps_qualifying.race_id.
race_slug	varchar	Yes		Human-readable event name.
session_type	varchar	Yes		Constant ‘Q’ marking the qualifying session.
driver_id	varchar	Yes	not_null	FastF1 three-letter driver code (e.g. VER, HAM).
driver_number	varchar	Yes		Car number the driver carried in this session.
constructor_id	varchar	Yes		Team name as reported by FastF1.
quali_position	integer	Yes		Official qualifying classification (1..20). Not the race grid penalties are applied afterwards and show up in stg_results.grid_position.
q1_time_s	double	Yes		Official best Q1 lap in seconds; NULL if the driver set no Q1 time.
q2_time_s	double	Yes		Official best Q2 lap in seconds; NULL if eliminated in Q1.
q3_time_s	double	Yes		Official best Q3 lap in seconds; NULL if eliminated in Q1 or Q2.
final_segment_reached	varchar	Yes	not_null	Furthest segment the driver reached ‘Q1’, ‘Q2’, ‘Q3’, or ‘none’ when they set no time at all.