stg_events

Race-level events (damage, retirements, penalties) sourced from the raw_dim_events seed.

Part of the Staging family.

Race-level events (damage, retirements, penalties) sourced from the raw_dim_events seed. Currently manual entries for 2021 only expand as automated detection is built.

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

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

Columns

Column	Type	Nullable	Tests	Description
stg_event_id	varchar	Yes	not_null, unique	Surrogate key {race_id}_{event_id}.
event_id	varchar	Yes		Seed-level event identifier.
race_id	integer	Yes		Race identifier from the seed (numeric).
driver_id	varchar	Yes		Driver the event affects (FastF1 three-letter code).
event_type	varchar	Yes		Event category label (e.g. damage, retirement, penalty).
event_severity	double	Yes		Magnitude estimate of the event’s impact.
source	varchar	Yes		Provenance of the event row (constant ‘manual’ for the seed).
is_performance_impact	boolean	Yes		TRUE when the event degrades on-track performance.
is_reliability_impact	boolean	Yes		TRUE when the event is a reliability/mechanical issue.