Static F1 database table
races_race_results
The races_race_results table
contains
27,533 Formula 1 records across
34 columns. Column types include
BIGINT, BOOLEAN, DOUBLE, VARCHAR.
- Rows
- 27,533
- Columns
- 34
- Parquet size
- 429.7 KB
- Updated
- 2026-07-31
Schema for races_race_results
| Column | Type | Nullable | Description |
|---|---|---|---|
| raceId | BIGINT | no | The identifier of the race. |
| year | BIGINT | no | The year of the season. |
| round | BIGINT | no | The round number of the race in the season. |
| positionDisplayOrder | BIGINT | no | The display order of the driver's position in the race. |
| positionNumber | BIGINT | yes | The numerical finishing position of the driver in the race. |
| positionText | VARCHAR | no | The textual representation of the driver's finishing position in the race. |
| driverNumber | VARCHAR | no | The car number of the driver. |
| driverId | VARCHAR | no | The identifier of the driver. |
| constructorId | VARCHAR | no | The identifier of the constructor. |
| engineManufacturerId | VARCHAR | no | The identifier of the engine manufacturer. |
| tyreManufacturerId | VARCHAR | no | The identifier of the tyre manufacturer. |
| sharedCar | BOOLEAN | no | Whether the driver shared the car with another driver. |
| laps | BIGINT | yes | The total number of laps completed by the driver. |
| time | VARCHAR | yes | The race time recorded for the driver. |
| timeMillis | BIGINT | yes | The race time in milliseconds. |
| timePenalty | VARCHAR | yes | The time penalty imposed on the driver. |
| timePenaltyMillis | BIGINT | yes | The time penalty in milliseconds. |
| gap | VARCHAR | yes | The gap between the driver and the leader. |
| gapMillis | BIGINT | yes | The gap in milliseconds. |
| gapLaps | BIGINT | yes | The gap measured in laps between the driver and the leader. |
| interval | VARCHAR | yes | The interval between the driver and the car ahead. |
| intervalMillis | BIGINT | yes | The interval in milliseconds. |
| reasonRetired | VARCHAR | yes | The reason for the driver's retirement from the race, if applicable. |
| points | DOUBLE | yes | The points awarded to the driver for the race. |
| polePosition | BOOLEAN | yes | Whether the driver was awarded the pole position honour. |
| qualificationPositionNumber | BIGINT | yes | The numerical position achieved in the qualification session. |
| qualificationPositionText | VARCHAR | yes | The textual representation of the qualification position, including special statuses. |
| gridPositionNumber | BIGINT | yes | The numerical starting grid position. |
| gridPositionText | VARCHAR | yes | The textual representation of the starting grid position, including special statuses. |
| positionsGained | BIGINT | yes | The number of positions gained by the driver during the race. |
| pitStops | BIGINT | yes | The total number of pit stops made by the driver during the race. |
| fastestLap | BOOLEAN | yes | Whether the driver set the fastest lap during the race. |
| driverOfTheDay | BOOLEAN | yes | Whether the driver was voted Driver of the Day. |
| grandSlam | BOOLEAN | yes | Whether the driver achieved a Grand Slam, defined as pole position, fastest lap, and leading every lap of the race. |