> ## Documentation Index
> Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# stg_telemetry

> High-frequency car telemetry (~10 Hz) from FastF1, one row per sample.

<Note>Part of the [Staging](/transform/families/staging) family.</Note>

High-frequency car telemetry (\~10 Hz) from FastF1, one row per sample. Renames Bronze channels to snake\_case and projects the powertrain channels (rpm, n\_gear, drs\_active) consumed by int\_lap\_telemetry\_aggregates. Samples are filtered to 0 \< distance\_m \< 6500. DRS decode: FastF1 codes 10/12/14 = active → drs\_active = TRUE.

## Lineage

```mermaid theme={null}
flowchart LR
  stg_telemetry --> int_corner_metrics
  stg_telemetry --> int_lap_telemetry_aggregates
  style stg_telemetry fill:#e40404,stroke:#e40404,color:#fff
```

## Overview

| Property          | Value                                  |
| ----------------- | -------------------------------------- |
| Layer             | `staging`                              |
| Family            | [Staging](/transform/families/staging) |
| Contract enforced | No                                     |

**0 tests** [guard](/transform/ci/overview) this model  -  0 generic, 0 singular.

## Columns

| Column           | Type      | Nullable | Tests | Description                                                                                                                                                                                                                                                                                                                                                                                                              |
| ---------------- | --------- | -------- | ----- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `telemetry_id`   | `varchar` | Yes      |       | Composite key   \{season}*\{race\_id}*\{driver\_id}\_\{lap\_number} (not unique; many samples per lap).                                                                                                                                                                                                                                                                                                                  |
| `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 the sample belongs to.                                                                                                                                                                                                                                                                                                                                                                                         |
| `distance_m`     | `double`  | Yes      |       | Distance along the lap from start/finish (m); samples filtered to 0–6500 m.                                                                                                                                                                                                                                                                                                                                              |
| `session_time_s` | `double`  | Yes      |       | Session clock of the sample (s), from the FastF1 SessionTime nanosecond field. Present so that (race, driver, lap, distance\_m, session\_time\_s) is a total order: distance\_m alone ties on 982,303 car-channel samples (a stationary car keeps sampling while distance does not advance), which made any LAG/LEAD ordered on distance alone pick an arbitrary neighbour. Unique across all 59.5M samples, zero nulls. |
| `speed_kph`      | `double`  | Yes      |       | Instantaneous car speed (kph).                                                                                                                                                                                                                                                                                                                                                                                           |
| `throttle_pct`   | `double`  | Yes      |       | Throttle application (0–100%).                                                                                                                                                                                                                                                                                                                                                                                           |
| `brake_applied`  | `boolean` | Yes      |       | TRUE when the brake pedal was applied at the sample.                                                                                                                                                                                                                                                                                                                                                                     |
| `rpm`            | `double`  | Yes      |       | Engine speed (revolutions per minute).                                                                                                                                                                                                                                                                                                                                                                                   |
| `n_gear`         | `integer` | Yes      |       | Selected gear (0 = neutral).                                                                                                                                                                                                                                                                                                                                                                                             |
| `drs_active`     | `boolean` | Yes      |       | TRUE when DRS was open/active (FastF1 codes 10/12/14).                                                                                                                                                                                                                                                                                                                                                                   |
| `source_channel` | `varchar` | Yes      |       | FastF1 sample provenance ('car' = true channel cadence; 'pos'/'interpolation' = forward-filled).                                                                                                                                                                                                                                                                                                                         |