Static F1 database table
constructors
The constructors table
contains
187 Formula 1 records across
22 columns. Column types include
BIGINT, DOUBLE, VARCHAR.
- Rows
- 187
- Columns
- 22
- Parquet size
- 12.1 KB
- Updated
- 2026-07-31
Schema for constructors
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | VARCHAR | no | The unique identifier of the constructor. |
| name | VARCHAR | no | The name of the constructor, typically used for display purposes. |
| fullName | VARCHAR | no | The full name of the constructor. |
| countryId | VARCHAR | no | The identifier of the country of origin of the constructor. |
| bestChampionshipPosition | BIGINT | yes | The best finishing position achieved by the constructor in a World Constructors' Championship. |
| bestStartingGridPosition | BIGINT | yes | The best starting grid position achieved by the constructor in a race. |
| bestRaceResult | BIGINT | yes | The best finishing position achieved by the constructor in a race. |
| bestSprintRaceResult | BIGINT | yes | The best finishing position achieved by the constructor in a sprint race. |
| totalChampionshipWins | BIGINT | no | The total number of World Constructors' Championship titles won by the constructor. |
| totalRaceEntries | BIGINT | no | The total number of races entered by the constructor. |
| totalRaceStarts | BIGINT | no | The total number of races started by the constructor. |
| totalRaceWins | BIGINT | no | The total number of races won by the constructor. |
| total1And2Finishes | BIGINT | no | The total number of races in which the constructor finished in both 1st and 2nd place. |
| totalRaceLaps | BIGINT | no | The total number of laps completed by the constructor. |
| totalPodiums | BIGINT | no | The total number of podium finishes achieved by the constructor. |
| totalPodiumRaces | BIGINT | no | The total number of races in which the constructor finished on the podium. |
| totalPoints | DOUBLE | no | The total number of points accumulated by the constructor. |
| totalChampionshipPoints | DOUBLE | no | The total number of World Constructors' Championship points accumulated by the constructor. |
| totalPolePositions | BIGINT | no | The total number of pole positions achieved by the constructor. |
| totalFastestLaps | BIGINT | no | The total number of fastest laps set by the constructor. |
| totalSprintRaceStarts | BIGINT | no | The total number of sprint races started by the constructor. |
| totalSprintRaceWins | BIGINT | no | The total number of sprint races won by the constructor. |