Static F1 database table
drivers
The drivers table
contains
917 Formula 1 records across
32 columns. Column types include
BIGINT, DOUBLE, VARCHAR.
- Rows
- 917
- Columns
- 32
- Parquet size
- 64.0 KB
- Updated
- 2026-07-31
Schema for drivers
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | VARCHAR | no | The unique identifier of the driver. |
| name | VARCHAR | no | The name of the driver, typically used for display purposes. |
| firstName | VARCHAR | no | The given name or first name of the driver. |
| lastName | VARCHAR | no | The family name or last name of the driver. |
| fullName | VARCHAR | no | The full name of the driver, usually a combination of first, middle and last names. |
| abbreviation | VARCHAR | no | The three-letter abbreviation for the driver, consisting of uppercase letters (e.g., 'SEN' for Ayrton Senna). |
| permanentNumber | VARCHAR | yes | The permanent racing number chosen by the driver. |
| gender | VARCHAR | no | The gender of the driver. |
| dateOfBirth | VARCHAR | no | The birth date of the driver. |
| dateOfDeath | VARCHAR | yes | The death date of the driver, if applicable. |
| placeOfBirth | VARCHAR | no | The place of birth of the driver. |
| countryOfBirthCountryId | VARCHAR | no | The identifier of the country where the driver was born. |
| nationalityCountryId | VARCHAR | no | The identifier of the nationality of the driver. |
| secondNationalityCountryId | VARCHAR | yes | The identifier of the second nationality of the driver, if applicable. |
| bestChampionshipPosition | BIGINT | yes | The best finishing position achieved by the driver in a World Drivers' Championship. |
| bestStartingGridPosition | BIGINT | yes | The best starting grid position achieved by the driver in a race. |
| bestRaceResult | BIGINT | yes | The best finishing position achieved by the driver in a race. |
| bestSprintRaceResult | BIGINT | yes | The best finishing position achieved by the driver in a sprint race. |
| totalChampionshipWins | BIGINT | no | The total number of World Drivers' Championship titles won by the driver. |
| totalRaceEntries | BIGINT | no | The total number of races entered by the driver. |
| totalRaceStarts | BIGINT | no | The total number of races started by the driver. |
| totalRaceWins | BIGINT | no | The total number of races won by the driver. |
| totalRaceLaps | BIGINT | no | The total number of laps completed by the driver. |
| totalPodiums | BIGINT | no | The total number of podium finishes achieved by the driver. |
| totalPoints | DOUBLE | no | The total number of points accumulated by the driver. |
| totalChampionshipPoints | DOUBLE | no | The total number of World Drivers' Championship points accumulated by the driver. |
| totalPolePositions | BIGINT | no | The total number of pole positions achieved by the driver. |
| totalFastestLaps | BIGINT | no | The total number of fastest laps set by the driver. |
| totalSprintRaceStarts | BIGINT | no | The total number of sprint races started by the driver. |
| totalSprintRaceWins | BIGINT | no | The total number of sprint races won by the driver. |
| totalDriverOfTheDay | BIGINT | no | The total number of Driver of the Day awards received by the driver. |
| totalGrandSlams | BIGINT | no | The total number of Grand Slams achieved by the driver, defined as pole position, fastest lap, and leading every lap of the race. |