stg_sector_times

Per-sector timing unpivoted from stg_laps.

Part of the Staging family.

Per-sector timing unpivoted from stg_laps. One row per lap × sector (1/2/3). Carries the speed-trap reading associated with each sector exit (S1→I1, S2→I2, S3→FL).

Lineage

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No
Upstream	stg_laps

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

Columns

Column	Type	Nullable	Tests	Description
sector_id	varchar	Yes	not_null, unique	Surrogate key {lap_id}_S{sector}.
lap_id	varchar	Yes	not_null	Foreign key to stg_laps.
race_year	integer	Yes		Season year.
race_id	varchar	Yes		Numeric FastF1 event id cast to string.
driver_id	varchar	Yes		FastF1 three-letter driver code.
lap_number	integer	Yes		Lap index within the race.
sector	integer	Yes	accepted_values	Sector number (1, 2 or 3).
sector_time_s	double	Yes		Time spent in the sector (seconds).
sector_session_time_s	double	Yes		Session clock (s) at the sector split.
speed_trap_kph	double	Yes		Speed-trap reading associated with the sector exit (kph).
is_valid_lap	boolean	Yes		Inherited clean-lap flag from the parent lap.