dim_driver_seasons

One row per season × driver code.

Part of the Reference family.

One row per season × driver code. The three-letter code is reused across seasons and names vary by season, so season is part of the key. driver_id is FastF1’s stable DriverId; names are the official ones for that season. Built from bronze race results.

Lineage

Overview

Property	Value
Layer	reference
Family	Reference
Contract enforced	No
Model-level tests	unique_combination_of_columns

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

Columns

Column	Type	Nullable	Tests	Description
season	integer	Yes	not_null	Season year.
driver_code	varchar	Yes	not_null	Three-letter FastF1 code matching laps.Driver and results.Abbreviation within the season.
driver_id	varchar	Yes	not_null	FastF1 stable DriverId for this code in this season.
full_name	varchar	Yes	not_null	Official full name for this code in this season.
first_name	varchar	Yes		First name.
last_name	varchar	Yes		Last name.
team_name	varchar	Yes		Team the driver raced for most often in the season.