stg_session_status

Session lifecycle events from FastF1 session.session_status (Inactive / Started / Aborted / Finished / Finalised).

Part of the Staging family.

Session lifecycle events from FastF1 session.session_status (Inactive / Started / Aborted / Finished / Finalised). ‘Aborted’ marks red-flag stoppages, surfaced as is_red_flag_stop. One row per lifecycle event.

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

3 tests guard this model - 3 generic, 0 singular.

Columns

Column	Type	Nullable	Tests	Description
session_status_id	varchar	Yes	not_null	Surrogate key {race_id}_{session_time_s}.
race_year	integer	Yes		Season year.
race_id	varchar	Yes	not_null	Numeric FastF1 event id cast to string; matches stg_laps.race_id.
race_slug	varchar	Yes		Human-readable event name.
session_time_s	double	Yes	not_null	Session clock (s) at the lifecycle event.
status	varchar	Yes		Raw FastF1 session status (‘Started’, ‘Aborted’, ‘Finished’, …).
is_red_flag_stop	boolean	Yes		TRUE when status is ‘Aborted’ (a red-flag stoppage).