stg_laps

Cleaned lap-level data from FastF1 race sessions.

Part of the Staging family.

Cleaned lap-level data from FastF1 race sessions. One row per driver × lap. Renames Bronze columns to snake_case, casts nanosecond timings to seconds, and derives the validity / track-status flags consumed across the warehouse. is_valid_lap = TRUE excludes pit laps, deleted laps, SC/VSC laps, and lap 1. Known bronze defect, not corrected here (F18, one race): 2020_1 (Austrian GP) is numbered 1-68 in bronze laps while the race ran 71. Race control puts the CHEQUERED flag on lap 71 and race_scheduled_laps says 71; on the 2026-09-25 dev build it is the only race with a chequered flag on record whose laps end short of it. The audit also found Jolpica’s pit laps for that race running 4 to 5 laps ahead of stg_pits (not re-run since). The two other feeds are ingested separately from the lap feed and neither passes through stg_laps, so the fault is in bronze ingestion, outside this layer. Effect, that race only: lap_number runs behind the true lap (3 laps at the flag, 4-5 by the pit-lap comparison), so the lap_number feature reads early and fuel_mass_kg, which counts down from lap_number at the scheduled 71-lap rate (about 1.55 kg per lap), reads about 1.5 kg per lap of offset too heavy (4.6 kg at 3 laps). The fix is a re-pull of 2020_1.

​

Lineage

​

Overview

Property	Value
Layer	staging
Family	Staging
Contract enforced	No

26 tests guard this model - 15 generic, 11 singular.

​

Columns

Column	Type	Nullable	Tests	Description
lap_id	varchar	Yes	not_null, unique	Surrogate key {season}{race_id}{driver}_{lap_number}.
race_year	integer	Yes	not_null	Season year.
circuit_key	varchar	Yes	relationships	Event/grand-prix key (equals race_id); used to group laps by circuit.
race_id	varchar	Yes	not_null, relationships	Numeric FastF1 event id cast to string (e.g. ‘4’); the join key used across staging, not the human-readable slug.
driver_id	varchar	Yes	not_null, relationships	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	relationships	Team name as reported by FastF1 (e.g. ‘Mercedes’).
lap_number	integer	Yes	not_null	Lap index within the race (1-based).
stint_number	integer	Yes		Stint index within the race (1-based); increments after each pit stop.
tyre_life	integer	Yes		Laps already completed on the current tyre set at the start of this lap.
is_fresh_tyre	boolean	Yes		TRUE when the lap began on a freshly fitted tyre set.
is_personal_best	boolean	Yes		FastF1 flag the lap was the driver’s personal best at the time it was set.
position	integer	Yes		Track position (classification order) at the end of the lap.
lap_time_s	double	Yes		Lap time in seconds (Bronze nanoseconds ÷ 1e9); NULL when not timed.
lap_start_time_s	double	Yes		Session clock (s) at the start of the lap; used to join weather and air state.
sector1_time_s	double	Yes		Sector 1 time in seconds; NULL when missing.
sector2_time_s	double	Yes		Sector 2 time in seconds; NULL when missing.
sector3_time_s	double	Yes		Sector 3 time in seconds; NULL when missing.
sector1_session_time_s	double	Yes		Session clock (s) at the sector 1 split.
sector2_session_time_s	double	Yes		Session clock (s) at the sector 2 split.
sector3_session_time_s	double	Yes		Session clock (s) at the sector 3 split.
speed_i1_kph	double	Yes		Speed-trap reading at intermediate point 1 (kph).
speed_i2_kph	double	Yes		Speed-trap reading at intermediate point 2 / sector 2 exit (kph).
speed_fl_kph	double	Yes		Speed-trap reading at the finish line (kph).
speed_st_kph	double	Yes		Speed-trap reading on the longest straight (kph).
track_status	varchar	Yes		Raw FastF1 TrackStatus string for the lap (concatenated digit codes, e.g. ‘41’ = SC+yellow).
is_pit_lap	boolean	Yes		TRUE when the lap has a pit-in or pit-out time (an in/out lap).
is_deleted	boolean	Yes		TRUE when stewards deleted the lap time (e.g. track-limits breach).
is_accurate	boolean	Yes		FastF1 quality flag timing considered reliable.
is_fastf1_generated	boolean	Yes		TRUE when the row was synthesised by FastF1 rather than read from raw timing.
compound	varchar	Yes	accepted_values, relationships	Normalised tyre compound label (UPPER). None/nan/UNKNOWN mapped to NULL. Pre-2019 compounds (SUPERSOFT/ULTRASOFT/HYPERSOFT) preserved as-is.
is_safety_car_lap	boolean	Yes	not_null	TRUE when TrackStatus contains a 4 (SCDeployed). Full safety car only VSC is is_vsc_lap and a red flag is is_red_flag_lap. Decode matches stg_track_status, ground-truthed against the bronze Message column.
is_vsc_lap	boolean	Yes	not_null	TRUE when TrackStatus contains a 6 (VSCDeployed) or 7 (VSCEnding). Decode matches stg_track_status.
is_red_flag_lap	boolean	Yes	not_null	TRUE when TrackStatus contains a 5 (Red). A red flag is a full session stoppage physically the opposite of a VSC lap (tyres go to ambient, and may legally be changed), so it is flagged separately rather than folded into either neutralisation flag. The three flags together are the neutralised set the layer excludes; consumers should test all three, not a pair.
is_valid_lap	boolean	Yes		Clean-lap flag: timed (lap_time_s > 0), not a pit lap, not deleted, accurate, lap_number > 1, and no SC/VSC/red flag (TrackStatus contains no 4–7).