Static F1 database table
seasons_constructors
The seasons_constructors table
contains
1,079 Formula 1 records across
19 columns. Column types include
BIGINT, DOUBLE, VARCHAR.
- Rows
- 1,079
- Columns
- 19
- Parquet size
- 17.8 KB
- Updated
- 2026-07-31
Schema for seasons_constructors
| Column | Type | Nullable | Description |
|---|---|---|---|
| year | BIGINT | no | The year of the season. |
| constructorId | VARCHAR | no | The identifier of the constructor. |
| positionNumber | BIGINT | yes | The numerical position of the constructor in the season standings. |
| positionText | VARCHAR | yes | The textual representation of the constructor's position in the season standings, including special statuses. |
| bestStartingGridPosition | BIGINT | yes | The best starting grid position achieved by the constructor during the season. |
| bestRaceResult | BIGINT | yes | The best finishing position achieved by the constructor during the season. |
| bestSprintRaceResult | BIGINT | yes | The best sprint race finishing position achieved by the constructor during the season. |
| totalRaceEntries | BIGINT | no | The total number of races entered by the constructor during the season. |
| totalRaceStarts | BIGINT | no | The total number of races started by the constructor during the season. |
| totalRaceWins | BIGINT | no | The total number of races won by the constructor during the season. |
| total1And2Finishes | BIGINT | no | The total number of races in which the constructor finished in both 1st and 2nd place during the season. |
| totalRaceLaps | BIGINT | no | The total number of laps completed by the constructor during the season. |
| totalPodiums | BIGINT | no | The total number of podium finishes achieved by the constructor during the season. |
| totalPodiumRaces | BIGINT | no | The total number of races in which the constructor finished on the podium during the season. |
| totalPoints | DOUBLE | no | The total number of points accumulated by the constructor during the season. |
| totalPolePositions | BIGINT | no | The total number of pole positions achieved by the constructor during the season. |
| totalFastestLaps | BIGINT | no | The total number of fastest laps set by the constructor during the season. |
| totalSprintRaceStarts | BIGINT | no | The total number of sprint races started by the constructor during the season. |
| totalSprintRaceWins | BIGINT | no | The total number of sprint races won by the constructor during the season. |