# TracingInsights Data Catalog **Version:** f1db-163fff24e1d7c55d1960b258a868ef6cf8804e05eae5147c4f097c0050f2ae30 **Last Updated:** 2026-07-31T02:48:56.640Z **Tables:** 57 **Total Rows:** 1,123,627 **Total Size:** 8.59 MB ## Table of Contents | # | Table | Rows | Columns | Size | |---|-------|------|---------|------| | 1 | chassis | 1,153 | 4 | 14.7 KB | | 2 | circuits | 78 | 13 | 7.48 KB | | 3 | circuits_layouts | 160 | 5 | 3.23 KB | | 4 | constructors | 187 | 22 | 12.1 KB | | 5 | constructors_chronology | 217 | 5 | 2.68 KB | | 6 | continents | 7 | 4 | 852.0 B | | 7 | countries | 249 | 7 | 7.64 KB | | 8 | drivers | 917 | 32 | 64.0 KB | | 9 | drivers_family_relationships | 86 | 4 | 2.33 KB | | 10 | engine_manufacturers | 78 | 20 | 6.78 KB | | 11 | engines | 424 | 7 | 9.54 KB | | 12 | entrants | 830 | 2 | 15.1 KB | | 13 | grands_prix | 54 | 7 | 3.63 KB | | 14 | races | 1,171 | 47 | 36.7 KB | | 15 | races_constructor_standings | 10,610 | 11 | 41.0 KB | | 16 | races_driver_of_the_day_results | 874 | 12 | 9.02 KB | | 17 | races_driver_standings | 21,449 | 10 | 71.5 KB | | 18 | races_fastest_laps | 17,085 | 18 | 326.2 KB | | 19 | races_free_practice_1_results | 16,076 | 18 | 288.1 KB | | 20 | races_free_practice_2_results | 15,509 | 18 | 274.9 KB | | 21 | races_free_practice_3_results | 8,823 | 18 | 154.0 KB | | 22 | races_free_practice_4_results | 706 | 18 | 17.4 KB | | 23 | races_lap_times | 876,525 | 6 | 5.09 MB | | 24 | races_pit_stops | 22,430 | 15 | 223.0 KB | | 25 | races_pre_qualifying_results | 647 | 24 | 17.9 KB | | 26 | races_qualifying_1_results | 7,707 | 24 | 144.0 KB | | 27 | races_qualifying_2_results | 7,541 | 24 | 141.3 KB | | 28 | races_qualifying_results | 26,954 | 24 | 522.1 KB | | 29 | races_race_results | 27,533 | 34 | 429.7 KB | | 30 | races_red_flags | 98 | 7 | 6.59 KB | | 31 | races_safety_cars | 369 | 7 | 4.06 KB | | 32 | races_sprint_qualifying_results | 444 | 24 | 14.2 KB | | 33 | races_sprint_race_results | 568 | 34 | 22.1 KB | | 34 | races_sprint_starting_grid_positions | 567 | 17 | 10.4 KB | | 35 | races_starting_grid_positions | 25,770 | 17 | 260.5 KB | | 36 | races_warming_up_results | 7,683 | 18 | 143.1 KB | | 37 | seasons | 77 | 1 | 335.0 B | | 38 | seasons_constructor_standings | 721 | 8 | 6.07 KB | | 39 | seasons_constructors | 1,079 | 19 | 17.8 KB | | 40 | seasons_driver_standings | 1,680 | 7 | 12.3 KB | | 41 | seasons_drivers | 3,415 | 19 | 42.8 KB | | 42 | seasons_engine_manufacturers | 560 | 18 | 12.2 KB | | 43 | seasons_entrants | 1,799 | 3 | 11.8 KB | | 44 | seasons_entrants_chassis | 2,292 | 5 | 25.0 KB | | 45 | seasons_entrants_constructors | 1,925 | 4 | 15.8 KB | | 46 | seasons_entrants_drivers | 3,880 | 8 | 49.7 KB | | 47 | seasons_entrants_engines | 2,027 | 5 | 21.7 KB | | 48 | seasons_entrants_tyre_manufacturers | 1,955 | 5 | 16.7 KB | | 49 | seasons_eras | 77 | 6 | 15.8 KB | | 50 | seasons_points_overrides | 7 | 7 | 2.22 KB | | 51 | seasons_points_systems | 77 | 16 | 4.38 KB | | 52 | seasons_qualifying_formats | 77 | 8 | 3.68 KB | | 53 | seasons_sporting_regulations | 77 | 13 | 3.42 KB | | 54 | seasons_sprint_points_systems | 77 | 12 | 3.29 KB | | 55 | seasons_technical_regulations | 77 | 18 | 4.88 KB | | 56 | seasons_tyre_manufacturers | 160 | 15 | 5.49 KB | | 57 | tyre_manufacturers | 9 | 16 | 3.14 KB | --- ## `chassis` - **Rows:** 1,153 - **Columns:** 4 - **Size:** 14.7 KB - **Source CSV:** `/f1db/f1db-chassis.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the chassis. | | constructorId | VARCHAR | NO | The identifier of the constructor associated with the chassis. | | name | VARCHAR | NO | The name of the chassis. | | fullName | VARCHAR | NO | The full name of the chassis. | --- ## `circuits` - **Rows:** 78 - **Columns:** 13 - **Size:** 7.48 KB - **Source CSV:** `/f1db/f1db-circuits.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the circuit. | | name | VARCHAR | NO | The name of the circuit, typically used for display purposes. | | fullName | VARCHAR | NO | The full official name of the circuit. | | previousNames | VARCHAR | YES | The previous names used for the circuit. | | type | VARCHAR | NO | The type of the circuit. | | direction | VARCHAR | NO | The direction of the current or most recently used layout of the circuit. | | placeName | VARCHAR | NO | The place name where the circuit is located. | | countryId | VARCHAR | NO | The identifier of the country where the circuit is located. | | latitude | DOUBLE | NO | The latitude coordinate where the circuit is located. | | longitude | DOUBLE | NO | The longitude coordinate where the circuit is located. | | length | DOUBLE | NO | The length of the current or most recently used layout of the circuit in kilometers. | | turns | BIGINT | NO | The number of turns (corners) in the current or most recently used layout of the circuit. | | totalRacesHeld | BIGINT | NO | The total number of races held at the circuit. | --- ## `circuits_layouts` - **Rows:** 160 - **Columns:** 5 - **Size:** 3.23 KB - **Source CSV:** `/f1db/f1db-circuits-layouts.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the circuit layout. | | circuitId | VARCHAR | NO | The identifier of the circuit associated with the circuit layout. | | effective | BOOLEAN | NO | Whether the layout is the current or most recently used layout. | | length | DOUBLE | NO | The length of the circuit layout in kilometers. | | turns | BIGINT | NO | The number of turns (corners) in the circuit layout. | --- ## `constructors` - **Rows:** 187 - **Columns:** 22 - **Size:** 12.1 KB - **Source CSV:** `/f1db/f1db-constructors.csv` ### Schema | 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. | --- ## `constructors_chronology` - **Rows:** 217 - **Columns:** 5 - **Size:** 2.68 KB - **Source CSV:** `/f1db/f1db-constructors-chronology.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | parentConstructorId | VARCHAR | NO | The identifier of the parent constructor. | | positionDisplayOrder | BIGINT | NO | The display order of the constructor within the chronological sequence of the parent constructor. | | constructorId | VARCHAR | NO | The identifier of the child constructor. | | yearFrom | BIGINT | NO | The year from. | | yearTo | BIGINT | YES | The year to, or null if it is still active. | --- ## `continents` - **Rows:** 7 - **Columns:** 4 - **Size:** 852.0 B - **Source CSV:** `/f1db/f1db-continents.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier for the continent. | | code | VARCHAR | NO | The unique code of the continent. | | name | VARCHAR | NO | The name of the continent. | | demonym | VARCHAR | NO | The demonym used for people from the continent. | --- ## `countries` - **Rows:** 249 - **Columns:** 7 - **Size:** 7.64 KB - **Source CSV:** `/f1db/f1db-countries.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier for the country. | | alpha2Code | VARCHAR | NO | The unique ISO 3166-1 alpha-2 code of the country. | | alpha3Code | VARCHAR | NO | The unique ISO 3166-1 alpha-3 code of the country. | | iocCode | VARCHAR | YES | The unique International Olympic Committee (IOC) code of the country. | | name | VARCHAR | NO | The name of the country. | | demonym | VARCHAR | YES | The demonym for citizens of the country. | | continentId | VARCHAR | NO | The identifier for the continent where the country is located. | --- ## `drivers` - **Rows:** 917 - **Columns:** 32 - **Size:** 64.0 KB - **Source CSV:** `/f1db/f1db-drivers.csv` ### Schema | 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 (cast from INT64) | YES | The permanent racing number chosen by the driver. | | gender | VARCHAR | NO | The gender of the driver. | | dateOfBirth | VARCHAR (cast from DATE) | NO | The birth date of the driver. | | dateOfDeath | VARCHAR (cast from DATE) | 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. | --- ## `drivers_family_relationships` - **Rows:** 86 - **Columns:** 4 - **Size:** 2.33 KB - **Source CSV:** `/f1db/f1db-drivers-family-relationships.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | parentDriverId | VARCHAR | NO | The identifier of the parent driver in the relationship. | | positionDisplayOrder | BIGINT | NO | The display order of the family relationship relative to other relationships of the parent driver. | | driverId | VARCHAR | NO | The identifier of the related driver. | | type | VARCHAR | NO | The type of the family relationship. | --- ## `engine_manufacturers` - **Rows:** 78 - **Columns:** 20 - **Size:** 6.78 KB - **Source CSV:** `/f1db/f1db-engine-manufacturers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the engine manufacturer. | | name | VARCHAR | NO | The name of the engine manufacturer. | | countryId | VARCHAR | NO | The identifier of the country of origin of the engine manufacturer. | | bestChampionshipPosition | BIGINT | YES | The best finishing position achieved by the engine manufacturer in a World Constructor's Championship. | | bestStartingGridPosition | BIGINT | YES | The best starting grid position achieved by the engine manufacturer in a race. | | bestRaceResult | BIGINT | YES | The best finishing position achieved by the engine manufacturer in a race. | | bestSprintRaceResult | BIGINT | YES | The best finishing position achieved by the engine manufacturer in a sprint race. | | totalChampionshipWins | BIGINT | NO | The total number of World Constructors' Championship titles won by the engine manufacturer. | | totalRaceEntries | BIGINT | NO | The total number of races entered by the engine manufacturer. | | totalRaceStarts | BIGINT | NO | The total number of races started by the engine manufacturer. | | totalRaceWins | BIGINT | NO | The total number of races won by the engine manufacturer. | | totalRaceLaps | BIGINT | NO | The total number of laps completed by the engine manufacturer. | | totalPodiums | BIGINT | NO | The total number of podium finishes achieved by the engine manufacturer. | | totalPodiumRaces | BIGINT | NO | The total number of races in which the engine manufacturer finished on the podium. | | totalPoints | DOUBLE | NO | The total number of points accumulated by the engine manufacturer. | | totalChampionshipPoints | DOUBLE | NO | The total number of World Constructors' Championship points accumulated by the engine manufacturer. | | totalPolePositions | BIGINT | NO | The total number of pole positions achieved by the engine manufacturer. | | totalFastestLaps | BIGINT | NO | The total number of fastest laps set by the engine manufacturer. | | totalSprintRaceStarts | BIGINT | NO | The total number of sprint races started by the engine manufacturer. | | totalSprintRaceWins | BIGINT | NO | The total number of sprint races won by the engine manufacturer. | --- ## `engines` - **Rows:** 424 - **Columns:** 7 - **Size:** 9.54 KB - **Source CSV:** `/f1db/f1db-engines.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the engine. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer associated with the engine. | | name | VARCHAR | NO | The name of the engine. | | fullName | VARCHAR | NO | The full name of the engine. | | capacity | DOUBLE | YES | The capacity of the engine, measured in liters. | | configuration | VARCHAR | NO | The configuration of the engine, such as V6, V8, etc. | | aspiration | VARCHAR | NO | The aspiration of the engine, such as naturally aspirated or turbocharged. | --- ## `entrants` - **Rows:** 830 - **Columns:** 2 - **Size:** 15.1 KB - **Source CSV:** `/f1db/f1db-entrants.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the entrant. | | name | VARCHAR | NO | The name of the entrant. | --- ## `grands_prix` - **Rows:** 54 - **Columns:** 7 - **Size:** 3.63 KB - **Source CSV:** `/f1db/f1db-grands-prix.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the Grand Prix. | | name | VARCHAR | NO | The name of the Grand Prix, typically used for display purposes. | | fullName | VARCHAR | NO | The full name of the Grand Prix. | | shortName | VARCHAR | NO | The short name of the Grand Prix. | | abbreviation | VARCHAR | NO | The three-character abbreviation of the Grand Prix. | | countryId | VARCHAR | YES | The identifier of the country where the Grand Prix is held. | | totalRacesHeld | BIGINT | NO | The total number of races held for this Grand Prix. | --- ## `races` - **Rows:** 1,171 - **Columns:** 47 - **Size:** 36.7 KB - **Source CSV:** `/f1db/f1db-races.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | BIGINT | NO | The unique identifier of the race. | | year | BIGINT | NO | The year of the season. | | round | BIGINT | NO | The round number of the race in the season. | | date | VARCHAR (cast from DATE) | NO | The date of the race in UTC. | | time | VARCHAR | YES | The start time of the race in UTC. | | grandPrixId | VARCHAR | NO | The identifier of the Grand Prix associated with the race. | | officialName | VARCHAR | NO | The official name of the race. | | qualifyingFormat | VARCHAR | NO | The qualifying format of the race. | | sprintQualifyingFormat | VARCHAR | NO | The sprint qualifying format of the race. | | circuitId | VARCHAR | NO | The identifier of the circuit where the race takes place. | | circuitLayoutId | VARCHAR | NO | The identifier of the circuit layout. | | circuitType | VARCHAR | NO | The type of the circuit. | | direction | VARCHAR | NO | The direction of the circuit. | | courseLength | DOUBLE | NO | The length of the circuit (race course) in kilometers. | | turns | BIGINT | NO | The number of turns (corners) in the configuration of the circuit. | | laps | BIGINT | NO | The total number of laps of the race. | | distance | DOUBLE | NO | The total distance of the race in kilometers. | | scheduledLaps | BIGINT | YES | The scheduled number of laps of the race. | | scheduledDistance | DOUBLE | YES | The scheduled distance of the race in kilometers. | | driversChampionshipDecider | BOOLEAN | NO | Whether the race was the decider of the World Drivers' Championship. | | constructorsChampionshipDecider | BOOLEAN | NO | Whether the race was the decider of the World Constructors' Championship. | | preQualifyingDate | VARCHAR | YES | The date of the pre-qualifying session in UTC. | | preQualifyingTime | VARCHAR | YES | The start time of the pre-qualifying session in UTC. | | freePractice1Date | VARCHAR (cast from DATE) | YES | The date of the 1st free practice session in UTC. | | freePractice1Time | VARCHAR | YES | The start time of the 1st free practice session in UTC. | | freePractice2Date | VARCHAR (cast from DATE) | YES | The date of the 2nd free practice session in UTC. | | freePractice2Time | VARCHAR | YES | The start time of the 2nd free practice session in UTC. | | freePractice3Date | VARCHAR (cast from DATE) | YES | The date of the 3rd free practice session in UTC. | | freePractice3Time | VARCHAR | YES | The start time of the 3rd free practice session in UTC. | | freePractice4Date | VARCHAR | YES | The date of the 4th free practice session UTC. | | freePractice4Time | VARCHAR | YES | The start time of the 4th free practice session in UTC. | | qualifying1Date | VARCHAR | YES | The date of the 1st qualifying session in UTC. | | qualifying1Time | VARCHAR | YES | The start time of the 1st qualifying session in UTC. | | qualifying2Date | VARCHAR | YES | The date of the 2nd qualifying session UTC. | | qualifying2Time | VARCHAR | YES | The start time of the 2nd qualifying session UTC. | | qualifyingDate | VARCHAR (cast from DATE) | YES | The date of the qualifying session UTC. | | qualifyingTime | VARCHAR | YES | The start time of the qualifying session UTC. | | sprintQualifyingDate | VARCHAR (cast from DATE) | YES | The date of the sprint qualifying session in UTC. | | sprintQualifyingTime | VARCHAR | YES | The start time of the sprint qualifying session in UTC. | | sprintRaceDate | VARCHAR (cast from DATE) | YES | The date of the sprint race in UTC. | | sprintRaceTime | VARCHAR | YES | The start time of the sprint race in UTC. | | sprintRaceLaps | BIGINT | YES | The total number of laps of the sprint race. | | sprintRaceDistance | DOUBLE | YES | The total distance of the sprint race in kilometers. | | sprintRaceScheduledLaps | BIGINT | YES | The scheduled number of laps of the sprint race. | | sprintRaceScheduledDistance | DOUBLE | YES | The scheduled distance of the sprint race in kilometers. | | warmingUpDate | VARCHAR | YES | The date of the warming-up session in UTC. | | warmingUpTime | VARCHAR | YES | The start time of the warming-up session in UTC. | --- ## `races_constructor_standings` - **Rows:** 10,610 - **Columns:** 11 - **Size:** 41.0 KB - **Source CSV:** `/f1db/f1db-races-constructor-standings.csv` ### Schema | 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 for the constructor's position in the standings. | | positionNumber | BIGINT | YES | The numerical position of the constructor in the standings. | | positionText | VARCHAR | NO | The textual representation of the constructor's position in the standings, including special statuses. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | points | DOUBLE | NO | The total number of points determining the constructor's position in the standings. | | positionsGained | BIGINT | YES | The positions gained in the standings since the previous race. | | championshipWon | BOOLEAN | NO | Whether the constructor has won the World Constructors' Championship. | --- ## `races_driver_of_the_day_results` - **Rows:** 874 - **Columns:** 12 - **Size:** 9.02 KB - **Source CSV:** `/f1db/f1db-races-driver-of-the-day-results.csv` ### Schema | 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 Driver of the Day vote. | | positionNumber | BIGINT | YES | The numerical position of the driver's position in the Driver of the Day vote. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the Driver of the Day vote, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | percentage | DOUBLE | YES | The percentage of votes received by the driver. | --- ## `races_driver_standings` - **Rows:** 21,449 - **Columns:** 10 - **Size:** 71.5 KB - **Source CSV:** `/f1db/f1db-races-driver-standings.csv` ### Schema | 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 standings. | | positionNumber | BIGINT | YES | The numerical position of the driver in the standings. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the standings, including special statuses. | | driverId | VARCHAR | NO | The identifier of the driver. | | points | DOUBLE | NO | The total number of points determining the driver's position in the standings. | | positionsGained | BIGINT | YES | The positions gained in the standings since the previous race. | | championshipWon | BOOLEAN | NO | Whether the driver has won the World Drivers' Championship. | --- ## `races_fastest_laps` - **Rows:** 17,085 - **Columns:** 18 - **Size:** 326.2 KB - **Source CSV:** `/f1db/f1db-races-fastest-laps.csv` ### Schema | 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 fastest laps. | | positionNumber | BIGINT | YES | The numerical position of the driver's position in the fastest laps. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the fastest laps, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | lap | BIGINT | YES | The lap number on which the driver recorded the fastest lap. | | time | VARCHAR | YES | The fastest lap time recorded for the driver. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver the top fastest lap. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the previous fastest lap. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | --- ## `races_free_practice_1_results` - **Rows:** 16,076 - **Columns:** 18 - **Size:** 288.1 KB - **Source CSV:** `/f1db/f1db-races-free-practice-1-results.csv` ### Schema | 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 practice session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the practice session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the practice session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the practice session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the practice session. | --- ## `races_free_practice_2_results` - **Rows:** 15,509 - **Columns:** 18 - **Size:** 274.9 KB - **Source CSV:** `/f1db/f1db-races-free-practice-2-results.csv` ### Schema | 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 practice session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the practice session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the practice session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the practice session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the practice session. | --- ## `races_free_practice_3_results` - **Rows:** 8,823 - **Columns:** 18 - **Size:** 154.0 KB - **Source CSV:** `/f1db/f1db-races-free-practice-3-results.csv` ### Schema | 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 practice session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the practice session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the practice session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the practice session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the practice session. | --- ## `races_free_practice_4_results` - **Rows:** 706 - **Columns:** 18 - **Size:** 17.4 KB - **Source CSV:** `/f1db/f1db-races-free-practice-4-results.csv` ### Schema | 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 practice session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the practice session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the practice session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the practice session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the practice session. | --- ## `races_lap_times` - **Rows:** 876,525 - **Columns:** 6 - **Size:** 5.09 MB - **Source CSV:** `/f1db/f1db-races-lap-times.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | raceId | BIGINT | NO | The identifier of the race. | | driverId | VARCHAR | NO | The identifier of the driver. | | lap | BIGINT | NO | The lap number. | | position | BIGINT | NO | The position of the driver on the lap. | | time | VARCHAR | NO | The lap time in mm:ss(.mmm) format. | | timeMillis | BIGINT | NO | The lap time in milliseconds. | --- ## `races_pit_stops` - **Rows:** 22,430 - **Columns:** 15 - **Size:** 223.0 KB - **Source CSV:** `/f1db/f1db-races-pit-stops.csv` ### Schema | 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 position display order of the pit stop. | | positionNumber | BIGINT | YES | The numerical position of the pit stop. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the position of the pit stop, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | stop | BIGINT | NO | The number of the pit stop for the driver during the race. | | lap | BIGINT | NO | The lap number on which the pit stop occurred. | | time | VARCHAR | YES | The total time of the pit stop. | | timeMillis | BIGINT | YES | The total time in milliseconds. | --- ## `races_pre_qualifying_results` - **Rows:** 647 - **Columns:** 24 - **Size:** 17.9 KB - **Source CSV:** `/f1db/f1db-races-pre-qualifying-results.csv` ### Schema | 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 qualifying session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the qualifying session. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the qualifying session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the qualifying session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | q1 | VARCHAR | YES | The Q1 lap time recorded for the driver during the qualifying session. | | q1Millis | BIGINT (cast from OBJECT) | YES | The Q1 lap time in milliseconds. | | q2 | VARCHAR | YES | The Q2 lap time recorded for the driver during the qualifying session. | | q2Millis | BIGINT (cast from OBJECT) | YES | The Q2 lap time in milliseconds. | | q3 | VARCHAR | YES | The Q3 lap time recorded for the driver during the qualifying session. | | q3Millis | BIGINT (cast from OBJECT) | YES | The Q3 lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT (cast from OBJECT) | YES | The number of laps completed by the driver during the qualifying session. | --- ## `races_qualifying_1_results` - **Rows:** 7,707 - **Columns:** 24 - **Size:** 144.0 KB - **Source CSV:** `/f1db/f1db-races-qualifying-1-results.csv` ### Schema | 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 qualifying session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the qualifying session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the qualifying session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the qualifying session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | q1 | VARCHAR | YES | The Q1 lap time recorded for the driver during the qualifying session. | | q1Millis | BIGINT (cast from OBJECT) | YES | The Q1 lap time in milliseconds. | | q2 | VARCHAR | YES | The Q2 lap time recorded for the driver during the qualifying session. | | q2Millis | BIGINT (cast from OBJECT) | YES | The Q2 lap time in milliseconds. | | q3 | VARCHAR | YES | The Q3 lap time recorded for the driver during the qualifying session. | | q3Millis | BIGINT (cast from OBJECT) | YES | The Q3 lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the qualifying session. | --- ## `races_qualifying_2_results` - **Rows:** 7,541 - **Columns:** 24 - **Size:** 141.3 KB - **Source CSV:** `/f1db/f1db-races-qualifying-2-results.csv` ### Schema | 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 qualifying session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the qualifying session. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the qualifying session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the qualifying session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | q1 | VARCHAR | YES | The Q1 lap time recorded for the driver during the qualifying session. | | q1Millis | BIGINT (cast from OBJECT) | YES | The Q1 lap time in milliseconds. | | q2 | VARCHAR | YES | The Q2 lap time recorded for the driver during the qualifying session. | | q2Millis | BIGINT (cast from OBJECT) | YES | The Q2 lap time in milliseconds. | | q3 | VARCHAR | YES | The Q3 lap time recorded for the driver during the qualifying session. | | q3Millis | BIGINT (cast from OBJECT) | YES | The Q3 lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the qualifying session. | --- ## `races_qualifying_results` - **Rows:** 26,954 - **Columns:** 24 - **Size:** 522.1 KB - **Source CSV:** `/f1db/f1db-races-qualifying-results.csv` ### Schema | 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 qualifying session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the qualifying session. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the qualifying session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the qualifying session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | q1 | VARCHAR | YES | The Q1 lap time recorded for the driver during the qualifying session. | | q1Millis | BIGINT | YES | The Q1 lap time in milliseconds. | | q2 | VARCHAR | YES | The Q2 lap time recorded for the driver during the qualifying session. | | q2Millis | BIGINT | YES | The Q2 lap time in milliseconds. | | q3 | VARCHAR | YES | The Q3 lap time recorded for the driver during the qualifying session. | | q3Millis | BIGINT | YES | The Q3 lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the qualifying session. | --- ## `races_race_results` - **Rows:** 27,533 - **Columns:** 34 - **Size:** 429.7 KB - **Source CSV:** `/f1db/f1db-races-race-results.csv` ### Schema | 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 (cast from INT64) | 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 (cast from FLOAT64) | 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 (cast from OBJECT) | 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. | --- ## `races_red_flags` - **Rows:** 98 - **Columns:** 7 - **Size:** 6.59 KB - **Source CSV:** `/f1db/f1db-races-red-flags.csv` ### Schema | 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. | | lap | BIGINT | YES | The lap number on which the red flag occurred. | | resumed | VARCHAR | YES | Status of race resumption (e.g. Y, N, R, S). | | incident | VARCHAR | YES | Description of the incident causing the red flag. | | excluded | VARCHAR | YES | Drivers excluded during the red flag period. | --- ## `races_safety_cars` - **Rows:** 369 - **Columns:** 7 - **Size:** 4.06 KB - **Source CSV:** `/f1db/f1db-races-safety-cars.csv` ### Schema | 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. | | cause | VARCHAR | YES | The cause of the safety car deployment (e.g. Accident, Rain). | | deployed | BIGINT | YES | The lap on which the safety car was deployed. | | retreated | DOUBLE | YES | The lap on which the safety car returned to the pits. | | fullLaps | BIGINT | YES | The number of full laps completed under safety car conditions. | --- ## `races_sprint_qualifying_results` - **Rows:** 444 - **Columns:** 24 - **Size:** 14.2 KB - **Source CSV:** `/f1db/f1db-races-sprint-qualifying-results.csv` ### Schema | 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 qualifying session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the qualifying session. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the qualifying session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the qualifying session. | | timeMillis | BIGINT (cast from OBJECT) | YES | The lap time in milliseconds. | | q1 | VARCHAR | YES | The Q1 lap time recorded for the driver during the qualifying session. | | q1Millis | BIGINT | YES | The Q1 lap time in milliseconds. | | q2 | VARCHAR | YES | The Q2 lap time recorded for the driver during the qualifying session. | | q2Millis | BIGINT | YES | The Q2 lap time in milliseconds. | | q3 | VARCHAR | YES | The Q3 lap time recorded for the driver during the qualifying session. | | q3Millis | BIGINT | YES | The Q3 lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the qualifying session. | --- ## `races_sprint_race_results` - **Rows:** 568 - **Columns:** 34 - **Size:** 22.1 KB - **Source CSV:** `/f1db/f1db-races-sprint-race-results.csv` ### Schema | 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 (cast from INT64) | 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 (cast from FLOAT64) | 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 (cast from INT64) | 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 (cast from OBJECT) | 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. | --- ## `races_sprint_starting_grid_positions` - **Rows:** 567 - **Columns:** 17 - **Size:** 10.4 KB - **Source CSV:** `/f1db/f1db-races-sprint-starting-grid-positions.csv` ### Schema | 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 starting grid position. | | positionNumber | BIGINT | YES | The numerical starting grid position. | | positionText | VARCHAR | NO | The textual representation of the starting grid position, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | qualificationPositionNumber | BIGINT | YES | The numerical position achieved in the qualification session. | | qualificationPositionText | VARCHAR | YES | The textual representation of the qualification position, including special statuses. | | gridPenalty | VARCHAR | YES | The grid penalty applied, either as a number of positions or as 'SFB' (Start from Back) or 'PL' (Pit Lane). | | gridPenaltyPositions | BIGINT | YES | The number of grid positions lost due to penalties. | | time | VARCHAR | YES | The lap time recorded for the position. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | --- ## `races_starting_grid_positions` - **Rows:** 25,770 - **Columns:** 17 - **Size:** 260.5 KB - **Source CSV:** `/f1db/f1db-races-starting-grid-positions.csv` ### Schema | 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 starting grid position. | | positionNumber | BIGINT | YES | The numerical starting grid position. | | positionText | VARCHAR | NO | The textual representation of the starting grid position, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | qualificationPositionNumber | BIGINT | YES | The numerical position achieved in the qualification session. | | qualificationPositionText | VARCHAR | YES | The textual representation of the qualification position, including special statuses. | | gridPenalty | VARCHAR | YES | The grid penalty applied, either as a number of positions or as 'SFB' (Start from Back) or 'PL' (Pit Lane). | | gridPenaltyPositions | BIGINT | YES | The number of grid positions lost due to penalties. | | time | VARCHAR | YES | The lap time recorded for the position. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | --- ## `races_warming_up_results` - **Rows:** 7,683 - **Columns:** 18 - **Size:** 143.1 KB - **Source CSV:** `/f1db/f1db-races-warming-up-results.csv` ### Schema | 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 practice session. | | positionNumber | BIGINT | YES | The numerical position of the driver in the practice session. | | positionText | VARCHAR (cast from INT64) | NO | The textual representation of the driver's position in the practice session, including special statuses. | | driverNumber | VARCHAR (cast from INT64) | 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. | | time | VARCHAR | YES | The lap time recorded for the driver during the practice session. | | timeMillis | BIGINT | YES | The lap time in milliseconds. | | gap | VARCHAR | YES | The gap between the driver and the leader. | | gapMillis | BIGINT | YES | The gap in milliseconds. | | interval | VARCHAR | YES | The interval between the driver and the car ahead. | | intervalMillis | BIGINT | YES | The interval in milliseconds. | | laps | BIGINT | YES | The number of laps completed by the driver during the practice session. | --- ## `seasons` - **Rows:** 77 - **Columns:** 1 - **Size:** 335.0 B - **Source CSV:** `/f1db/f1db-seasons.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | --- ## `seasons_constructor_standings` - **Rows:** 721 - **Columns:** 8 - **Size:** 6.07 KB - **Source CSV:** `/f1db/f1db-seasons-constructor-standings.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | positionDisplayOrder | BIGINT | NO | The display order for the constructor's position in the standings. | | positionNumber | BIGINT | YES | The numerical position of the constructor in the standings. | | positionText | VARCHAR | NO | The textual representation of the constructor's position in the standings, including special statuses. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | points | DOUBLE | NO | The total number of points determining the constructor's position in the standings. | | championshipWon | BOOLEAN | NO | Whether the constructor has won the World Constructors' Championship. | --- ## `seasons_constructors` - **Rows:** 1,079 - **Columns:** 19 - **Size:** 17.8 KB - **Source CSV:** `/f1db/f1db-seasons-constructors.csv` ### Schema | 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. | --- ## `seasons_driver_standings` - **Rows:** 1,680 - **Columns:** 7 - **Size:** 12.3 KB - **Source CSV:** `/f1db/f1db-seasons-driver-standings.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | positionDisplayOrder | BIGINT | NO | The display order of the driver's position in the standings. | | positionNumber | BIGINT | YES | The numerical position of the driver in the standings. | | positionText | VARCHAR | NO | The textual representation of the driver's position in the standings, including special statuses. | | driverId | VARCHAR | NO | The identifier of the driver. | | points | DOUBLE | NO | The total number of points determining the driver's position in the standings. | | championshipWon | BOOLEAN | NO | Whether the driver has won the World Drivers' Championship. | --- ## `seasons_drivers` - **Rows:** 3,415 - **Columns:** 19 - **Size:** 42.8 KB - **Source CSV:** `/f1db/f1db-seasons-drivers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | driverId | VARCHAR | NO | The identifier of the driver. | | positionNumber | BIGINT | YES | The numerical position of the driver in the season standings. | | positionText | VARCHAR | YES | The textual representation of the driver's position in the season standings, including special statuses. | | bestStartingGridPosition | BIGINT | YES | The best starting grid position achieved by the driver during the season. | | bestRaceResult | BIGINT | YES | The best finishing position achieved by the driver during the season. | | bestSprintRaceResult | BIGINT | YES | The best sprint race finishing position achieved by the driver during the season. | | totalRaceEntries | BIGINT | NO | The total number of races entered by the driver during the season. | | totalRaceStarts | BIGINT | NO | The total number of races started by the driver during the season. | | totalRaceWins | BIGINT | NO | The total number of races won by the driver during the season. | | totalRaceLaps | BIGINT | NO | The total number of laps completed by the driver during the season. | | totalPodiums | BIGINT | NO | The total number of podium finishes achieved by the driver during the season. | | totalPoints | DOUBLE | NO | The total number of points accumulated by the driver during the season. | | totalPolePositions | BIGINT | NO | The total number of pole positions achieved by the driver during the season. | | totalFastestLaps | BIGINT | NO | The total number of fastest laps set by the driver during the season. | | totalSprintRaceStarts | BIGINT | NO | The total number of sprint races started by the driver during the season. | | totalSprintRaceWins | BIGINT | NO | The total number of sprint races won by the driver during the season. | | totalDriverOfTheDay | BIGINT | NO | The total number of Driver of the Day awards received by the driver during the season. | | totalGrandSlams | BIGINT | NO | The total number of Grand Slams achieved by the driver during the season, defined as pole position, fastest lap, and leading every lap of the race. | --- ## `seasons_engine_manufacturers` - **Rows:** 560 - **Columns:** 18 - **Size:** 12.2 KB - **Source CSV:** `/f1db/f1db-seasons-engine-manufacturers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | positionNumber | BIGINT | YES | The numerical position of the engine manufacturer in the season standings. | | positionText | VARCHAR | YES | The textual representation of the engine manufacturer's position in the season standings, including special statuses. | | bestStartingGridPosition | BIGINT | YES | The best starting grid position achieved by the engine manufacturer during the season. | | bestRaceResult | BIGINT | YES | The best finishing position achieved by the engine manufacturer during the season. | | bestSprintRaceResult | BIGINT | YES | The best sprint race finishing position achieved by the engine manufacturer during the season. | | totalRaceEntries | BIGINT | NO | The total number of races entered by the engine manufacturer during the season. | | totalRaceStarts | BIGINT | NO | The total number of races started by the engine manufacturer during the season. | | totalRaceWins | BIGINT | NO | The total number of races won by the engine manufacturer during the season. | | totalRaceLaps | BIGINT | NO | The total number of laps completed by the engine manufacturer during the season. | | totalPodiums | BIGINT | NO | The total number of podium finishes achieved by the engine manufacturer during the season. | | totalPodiumRaces | BIGINT | NO | The total number of races in which the engine manufacturer finished on the podium during the season. | | totalPoints | DOUBLE | NO | The total number of points accumulated by the engine manufacturer during the season. | | totalPolePositions | BIGINT | NO | The total number of pole positions achieved by the engine manufacturer during the season. | | totalFastestLaps | BIGINT | NO | The total number of fastest laps set by the engine manufacturer during the season. | | totalSprintRaceStarts | BIGINT | NO | The total number of sprint races started by the engine manufacturer during the season. | | totalSprintRaceWins | BIGINT | NO | The total number of sprint races won by the engine manufacturer during the season. | --- ## `seasons_entrants` - **Rows:** 1,799 - **Columns:** 3 - **Size:** 11.8 KB - **Source CSV:** `/f1db/f1db-seasons-entrants.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | countryId | VARCHAR | NO | The identifier of the country of the entrant. | --- ## `seasons_entrants_chassis` - **Rows:** 2,292 - **Columns:** 5 - **Size:** 25.0 KB - **Source CSV:** `/f1db/f1db-seasons-entrants-chassis.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | chassisId | VARCHAR | NO | The identifier of the chassis. | --- ## `seasons_entrants_constructors` - **Rows:** 1,925 - **Columns:** 4 - **Size:** 15.8 KB - **Source CSV:** `/f1db/f1db-seasons-entrants-constructors.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | --- ## `seasons_entrants_drivers` - **Rows:** 3,880 - **Columns:** 8 - **Size:** 49.7 KB - **Source CSV:** `/f1db/f1db-seasons-entrants-drivers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | driverId | VARCHAR | NO | The identifier of the driver. | | rounds | VARCHAR | YES | The rounds in which the driver participated. | | roundsText | VARCHAR | YES | The textual representation of the rounds in which the driver participated. | | testDriver | BOOLEAN | NO | Whether the driver was a test / free practice driver. | --- ## `seasons_entrants_engines` - **Rows:** 2,027 - **Columns:** 5 - **Size:** 21.7 KB - **Source CSV:** `/f1db/f1db-seasons-entrants-engines.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | constructorId | VARCHAR | NO | The identifier of the constructor. | | engineManufacturerId | VARCHAR | NO | The identifier of the engine manufacturer. | | engineId | VARCHAR | NO | The identifier of the engine. | --- ## `seasons_entrants_tyre_manufacturers` - **Rows:** 1,955 - **Columns:** 5 - **Size:** 16.7 KB - **Source CSV:** `/f1db/f1db-seasons-entrants-tyre-manufacturers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | entrantId | VARCHAR | NO | The identifier of the entrant. | | 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. | --- ## `seasons_eras` - **Rows:** 77 - **Columns:** 6 - **Size:** 15.8 KB - **Source CSV:** `/f1db/f1db-seasons-eras.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | eraName | VARCHAR | NO | Name of the era this season belongs to. | | eraOverview | VARCHAR | NO | Long-form narrative overview of the era (500+ words, Markdown). | | keyChanges | VARCHAR | NO | Key regulatory and historical changes during this era (bullet list, Markdown). | | technicalSummary | VARCHAR | NO | Technical regulations summary for the era (100-200 words). | | sportingSummary | VARCHAR | NO | Sporting regulations summary for the era (100-200 words). | --- ## `seasons_points_overrides` - **Rows:** 7 - **Columns:** 7 - **Size:** 2.22 KB - **Source CSV:** `/f1db/f1db-seasons-points-overrides.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | round | BIGINT | NO | The round number of the race. | | grandPrixId | VARCHAR | NO | The Grand Prix identifier. | | pointsMultiplier | DOUBLE | NO | Points multiplier (0.5 for half points, 2.0 for double points). | | lapsCompleted | BIGINT | YES | Number of racing laps completed. | | lapsScheduled | BIGINT | YES | Number of scheduled racing laps. | | reason | VARCHAR | NO | Reason for the points override. | --- ## `seasons_points_systems` - **Rows:** 77 - **Columns:** 16 - **Size:** 4.38 KB - **Source CSV:** `/f1db/f1db-seasons-points-systems.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | name | VARCHAR | NO | Short label for the points system, e.g. '25-18-15-12-10-8-6-4-2-1'. | | description | VARCHAR | YES | Human-readable description of the points system. | | position1Points | DOUBLE (cast from INT64) | NO | Points awarded for 1st place. | | position2Points | DOUBLE (cast from INT64) | NO | Points awarded for 2nd place. | | position3Points | DOUBLE (cast from INT64) | NO | Points awarded for 3rd place. | | position4Points | DOUBLE (cast from INT64) | NO | Points awarded for 4th place. | | position5Points | DOUBLE (cast from INT64) | NO | Points awarded for 5th place. | | position6Points | DOUBLE (cast from INT64) | NO | Points awarded for 6th place. | | position7Points | DOUBLE (cast from INT64) | NO | Points awarded for 7th place. | | position8Points | DOUBLE (cast from INT64) | NO | Points awarded for 8th place. | | position9Points | DOUBLE (cast from INT64) | NO | Points awarded for 9th place. | | position10Points | DOUBLE (cast from INT64) | NO | Points awarded for 10th place. | | fastestLapPoints | DOUBLE (cast from INT64) | NO | Bonus points for fastest lap (0 when not awarded). | | fastestLapCondition | VARCHAR | NO | Condition for fastest lap points: ANY, TOP_10, or NONE. | | fastestLapMinDistancePercent | DOUBLE (cast from INT64) | YES | Minimum race distance percentage to qualify for fastest lap point (50 for 2022-2024). | --- ## `seasons_qualifying_formats` - **Rows:** 77 - **Columns:** 8 - **Size:** 3.68 KB - **Source CSV:** `/f1db/f1db-seasons-qualifying-formats.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | format | VARCHAR | NO | Qualifying format name: TWO_SESSION, ONE_HOUR, ONE_SHOT, AGGREGATE_KNOCKOUT, KNOCKOUT_3, ELIMINATION. | | description | VARCHAR | YES | Detailed description of the qualifying format. | | q1DurationMinutes | BIGINT | YES | Q1 session duration in minutes. | | q2DurationMinutes | BIGINT | YES | Q2 session duration in minutes. | | q3DurationMinutes | BIGINT | YES | Q3 session duration in minutes. | | eliminationCountPerStage | BIGINT | YES | Number of drivers eliminated per stage. | | hundredSevenPercentRule | BOOLEAN | NO | Whether the 107% rule is active. | --- ## `seasons_sporting_regulations` - **Rows:** 77 - **Columns:** 13 - **Size:** 3.42 KB - **Source CSV:** `/f1db/f1db-seasons-sporting-regulations.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | raceDistanceKm | DOUBLE (cast from INT64) | YES | Standard race distance in kilometers. | | sprintRacesCount | BIGINT | NO | Number of sprint races in the season. | | sprintRaceDistanceKm | DOUBLE (cast from INT64) | YES | Sprint race distance in kilometers. | | sprintQualifyingFormat | VARCHAR | YES | Sprint qualifying format description. | | drsActive | BOOLEAN | NO | Whether DRS is active. | | vscActive | BOOLEAN | NO | Whether Virtual Safety Car is active. | | budgetCapIntroduced | BOOLEAN | NO | Whether a budget cap is in effect. | | budgetCapAmountUsd | DOUBLE (cast from INT64) | YES | Budget cap amount in USD. | | numberOfRaces | BIGINT | YES | Number of races in the season. | | dropScoresUsed | BOOLEAN | NO | Whether drop scores (best-N results) are used. | | dropScoresCount | BIGINT | YES | Number of best results that count toward championship. | | shortenedRaceRules | VARCHAR | YES | Rules for shortened race points allocation. | --- ## `seasons_sprint_points_systems` - **Rows:** 77 - **Columns:** 12 - **Size:** 3.29 KB - **Source CSV:** `/f1db/f1db-seasons-sprint-points-systems.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | name | VARCHAR | NO | Short label for the sprint points system. | | description | VARCHAR | YES | Human-readable description. | | position1Points | DOUBLE (cast from INT64) | NO | Sprint points for 1st place. | | position2Points | DOUBLE (cast from INT64) | NO | Sprint points for 2nd place. | | position3Points | DOUBLE (cast from INT64) | NO | Sprint points for 3rd place. | | position4Points | DOUBLE (cast from INT64) | NO | Sprint points for 4th place. | | position5Points | DOUBLE (cast from INT64) | NO | Sprint points for 5th place. | | position6Points | DOUBLE (cast from INT64) | NO | Sprint points for 6th place. | | position7Points | DOUBLE (cast from INT64) | NO | Sprint points for 7th place. | | position8Points | DOUBLE (cast from INT64) | NO | Sprint points for 8th place. | | sprintRacesCount | BIGINT | NO | Number of sprint races in this season. | --- ## `seasons_technical_regulations` - **Rows:** 77 - **Columns:** 18 - **Size:** 4.88 KB - **Source CSV:** `/f1db/f1db-seasons-technical-regulations.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | eraName | VARCHAR | NO | Name of the regulatory era. | | engineFormula | VARCHAR | NO | Engine formula description. | | engineCapacityCc | DOUBLE (cast from INT64) | YES | Engine capacity in cubic centimeters. | | cylinders | VARCHAR | YES | Cylinder configuration. | | turboAllowed | BOOLEAN | NO | Whether turbocharging is allowed. | | superchargingRequired | BOOLEAN | NO | Whether supercharging is required. | | groundEffectAllowed | BOOLEAN | NO | Whether ground effect aerodynamics are allowed. | | activeAeroAllowed | BOOLEAN | NO | Whether active aerodynamics are allowed. | | minWeightKg | DOUBLE (cast from INT64) | YES | Minimum car weight in kilograms. | | fuelLimitKg | DOUBLE (cast from INT64) | YES | Fuel limit per race in kilograms. | | fuelType | VARCHAR | YES | Fuel type specification. | | refuellingAllowed | BOOLEAN | NO | Whether in-race refueling is allowed. | | consumptionLimitMjPerHour | DOUBLE (cast from INT64) | YES | Fuel energy consumption limit in MJ/hour. | | energyStoreCapacityMj | DOUBLE (cast from INT64) | YES | Energy store capacity in MJ. | | maxEnginesPerSeason | BIGINT | YES | Maximum engines/power units per season. | | maxRpm | BIGINT | YES | Maximum engine RPM. | | tyreSupplier | VARCHAR | YES | Tyre supplier(s) for the season. | --- ## `seasons_tyre_manufacturers` - **Rows:** 160 - **Columns:** 15 - **Size:** 5.49 KB - **Source CSV:** `/f1db/f1db-seasons-tyre-manufacturers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | year | BIGINT | NO | The year of the season. | | tyreManufacturerId | VARCHAR | NO | The identifier of the tyre manufacturer. | | bestStartingGridPosition | BIGINT | YES | The best starting grid position achieved by the tyre manufacturer during the season. | | bestRaceResult | BIGINT | YES | The best finishing position achieved by the tyre manufacturer during the season. | | bestSprintRaceResult | BIGINT | YES | The best sprint race finishing position achieved by the tyre manufacturer during the season. | | totalRaceEntries | BIGINT | NO | The total number of races entered by the tyre manufacturer during the season. | | totalRaceStarts | BIGINT | NO | The total number of races started by the tyre manufacturer during the season. | | totalRaceWins | BIGINT | NO | The total number of races won by the tyre manufacturer during the season. | | totalRaceLaps | BIGINT | NO | The total number of laps completed by the tyre manufacturer during the season. | | totalPodiums | BIGINT | NO | The total number of podium finishes achieved by the tyre manufacturer during the season. | | totalPodiumRaces | BIGINT | NO | The total number of races in which the tyre manufacturer finished on the podium during the season. | | totalPolePositions | BIGINT | NO | The total number of pole positions achieved by the tyre manufacturer during the season. | | totalFastestLaps | BIGINT | NO | The total number of fastest laps set by the tyre manufacturer during the season. | | totalSprintRaceStarts | BIGINT | NO | The total number of sprint races started by the tyre manufacturer during the season. | | totalSprintRaceWins | BIGINT | NO | The total number of sprint races won by the tyre manufacturer during the season. | --- ## `tyre_manufacturers` - **Rows:** 9 - **Columns:** 16 - **Size:** 3.14 KB - **Source CSV:** `/f1db/f1db-tyre-manufacturers.csv` ### Schema | Column | Type | Nullable | Description | |--------|------|----------|-------------| | id | VARCHAR | NO | The unique identifier of the tyre manufacturer. | | name | VARCHAR | NO | The name of the tyre manufacturer. | | countryId | VARCHAR | NO | The identifier of the country of origin of the tyre manufacturer. | | bestStartingGridPosition | BIGINT | YES | The best starting grid position achieved by the tyre manufacturer in a race. | | bestRaceResult | BIGINT | YES | The best finishing position achieved by the tyre manufacturer in a race. | | bestSprintRaceResult | BIGINT | YES | The best finishing position achieved by the tyre manufacturer in a sprint race. | | totalRaceEntries | BIGINT | NO | The total number of races entered by the tyre manufacturer. | | totalRaceStarts | BIGINT | NO | The total number of races started by the tyre manufacturer. | | totalRaceWins | BIGINT | NO | The total number of races won by the tyre manufacturer. | | totalRaceLaps | BIGINT | NO | The total number of laps completed by the tyre manufacturer. | | totalPodiums | BIGINT | NO | The total number of podium finishes achieved by the tyre manufacturer. | | totalPodiumRaces | BIGINT | NO | The total number of races in which the tyre manufacturer finished on the podium. | | totalPolePositions | BIGINT | NO | The total number of pole positions achieved by the tyre manufacturer. | | totalFastestLaps | BIGINT | NO | The total number of fastest laps set by the tyre manufacturer. | | totalSprintRaceStarts | BIGINT | NO | The total number of sprint races started by the tyre manufacturer. | | totalSprintRaceWins | BIGINT | NO | The total number of sprint races won by the tyre manufacturer. | --- # Stats Records & Leaderboards Beyond the raw data tables above, TracingInsights generates **29 pre-computed record domains** with over 500 all-time leaderboards. Each domain is a static JSON file at `/stats/data/records/.json`. Every record includes a `title`, `methodology`, `valueLabel`, and ranked `rows` array with entity names, values, contexts, URLs, and chronological event lists. ## Record Domains (sorted by record count) | Domain | Records | Description | |--------|---------|-------------| | drivers | 84 | Wins, podiums, poles, championships, fastest laps, points, streaks, lead, sprint | | constructors | 120 | Team wins, 1-2 finishes, championships, poles, sprint records | | countries | 67 | Nationality-based achievements | | engines | 102 | Power unit performance records | | circuits | 26 | Most races, wins by driver, closest finishes, safety cars, red flags | | wins | 30 | Consecutive wins, wins per circuit, by age, gap to second | | podiums | 28 | Consecutive podiums, duo records, per team | | grands-prix | 23 | Decisive results, lap/km records, finishers, speed, gaps, nations | | poles | 24 | Consecutive poles, win rate from pole, by age | | gp-entries | 18 | Most GPs, consecutive GPs, GPs without win | | championships | 15 | WDC/WCC titles, chronology, by age, vice-champion | | misc | 15 | Hat tricks, grand slams, finishes, retirements | | numbers | 13 | Achievements by car number (championships, wins, poles, fastest laps, points, podiums) | | fastest-laps | 12 | By number, chronology, by age, consecutive, by GP/circuit | | points | 11 | Points scoring records and firsts | | lead | 10 | Laps led, km led, GP led, start-to-finish, consecutive | | qualifying | 8 | Q3 appearances, Q1 exits, consecutive streaks | | first-rows | 6 | Front row starts, lockouts, consecutive | | h2h | 6 | Teammate qualifying & race H2H | | youngest-oldest | 4 | Age-based records | | milestones | 3 | Career and historical milestones | | chassis | 2 | Car chassis performance records | | laps | 2 | Fastest laps and lap-related records | | sprints | 2 | Sprint race performance | | streaks | 2 | Consecutive wins, podiums, points | | tyres | 2 | Tyre manufacturer records | | races | 1 | Most starters, closest finishes | | seasons | 1 | Most wins/poles/points in a single season | | pit-stops | 1 | Pit stop speed and strategy | Browse all record domains at [`/stats/records`](http://localhost:5173/stats/records). Each domain JSON includes a `title`, `methodology`, `valueLabel`, and ranked `rows` array with `entity`, `value`, optional `context`, `url`, and `events` fields. --- # SQL DDL ```sql CREATE TABLE chassis ( id VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, name VARCHAR NOT NULL, fullName VARCHAR NOT NULL ); CREATE TABLE circuits ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, fullName VARCHAR NOT NULL, previousNames VARCHAR, type VARCHAR NOT NULL, direction VARCHAR NOT NULL, placeName VARCHAR NOT NULL, countryId VARCHAR NOT NULL, latitude DOUBLE NOT NULL, longitude DOUBLE NOT NULL, length DOUBLE NOT NULL, turns BIGINT NOT NULL, totalRacesHeld BIGINT NOT NULL ); CREATE TABLE circuits_layouts ( id VARCHAR NOT NULL, circuitId VARCHAR NOT NULL, effective BOOLEAN NOT NULL, length DOUBLE NOT NULL, turns BIGINT NOT NULL ); CREATE TABLE constructors ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, fullName VARCHAR NOT NULL, countryId VARCHAR NOT NULL, bestChampionshipPosition BIGINT, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalChampionshipWins BIGINT NOT NULL, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, total1And2Finishes BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalChampionshipPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); CREATE TABLE constructors_chronology ( parentConstructorId VARCHAR NOT NULL, positionDisplayOrder BIGINT NOT NULL, constructorId VARCHAR NOT NULL, yearFrom BIGINT NOT NULL, yearTo BIGINT ); CREATE TABLE continents ( id VARCHAR NOT NULL, code VARCHAR NOT NULL, name VARCHAR NOT NULL, demonym VARCHAR NOT NULL ); CREATE TABLE countries ( id VARCHAR NOT NULL, alpha2Code VARCHAR NOT NULL, alpha3Code VARCHAR NOT NULL, iocCode VARCHAR, name VARCHAR NOT NULL, demonym VARCHAR, continentId VARCHAR NOT NULL ); CREATE TABLE drivers ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, firstName VARCHAR NOT NULL, lastName VARCHAR NOT NULL, fullName VARCHAR NOT NULL, abbreviation VARCHAR NOT NULL, permanentNumber VARCHAR, gender VARCHAR NOT NULL, dateOfBirth VARCHAR NOT NULL, dateOfDeath VARCHAR, placeOfBirth VARCHAR NOT NULL, countryOfBirthCountryId VARCHAR NOT NULL, nationalityCountryId VARCHAR NOT NULL, secondNationalityCountryId VARCHAR, bestChampionshipPosition BIGINT, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalChampionshipWins BIGINT NOT NULL, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalChampionshipPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL, totalDriverOfTheDay BIGINT NOT NULL, totalGrandSlams BIGINT NOT NULL ); CREATE TABLE drivers_family_relationships ( parentDriverId VARCHAR NOT NULL, positionDisplayOrder BIGINT NOT NULL, driverId VARCHAR NOT NULL, type VARCHAR NOT NULL ); CREATE TABLE engine_manufacturers ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, countryId VARCHAR NOT NULL, bestChampionshipPosition BIGINT, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalChampionshipWins BIGINT NOT NULL, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalChampionshipPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); CREATE TABLE engines ( id VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, name VARCHAR NOT NULL, fullName VARCHAR NOT NULL, capacity DOUBLE, configuration VARCHAR NOT NULL, aspiration VARCHAR NOT NULL ); CREATE TABLE entrants ( id VARCHAR NOT NULL, name VARCHAR NOT NULL ); CREATE TABLE grands_prix ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, fullName VARCHAR NOT NULL, shortName VARCHAR NOT NULL, abbreviation VARCHAR NOT NULL, countryId VARCHAR, totalRacesHeld BIGINT NOT NULL ); CREATE TABLE races ( id BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, date VARCHAR NOT NULL, time VARCHAR, grandPrixId VARCHAR NOT NULL, officialName VARCHAR NOT NULL, qualifyingFormat VARCHAR NOT NULL, sprintQualifyingFormat VARCHAR NOT NULL, circuitId VARCHAR NOT NULL, circuitLayoutId VARCHAR NOT NULL, circuitType VARCHAR NOT NULL, direction VARCHAR NOT NULL, courseLength DOUBLE NOT NULL, turns BIGINT NOT NULL, laps BIGINT NOT NULL, distance DOUBLE NOT NULL, scheduledLaps BIGINT, scheduledDistance DOUBLE, driversChampionshipDecider BOOLEAN NOT NULL, constructorsChampionshipDecider BOOLEAN NOT NULL, preQualifyingDate VARCHAR, preQualifyingTime VARCHAR, freePractice1Date VARCHAR, freePractice1Time VARCHAR, freePractice2Date VARCHAR, freePractice2Time VARCHAR, freePractice3Date VARCHAR, freePractice3Time VARCHAR, freePractice4Date VARCHAR, freePractice4Time VARCHAR, qualifying1Date VARCHAR, qualifying1Time VARCHAR, qualifying2Date VARCHAR, qualifying2Time VARCHAR, qualifyingDate VARCHAR, qualifyingTime VARCHAR, sprintQualifyingDate VARCHAR, sprintQualifyingTime VARCHAR, sprintRaceDate VARCHAR, sprintRaceTime VARCHAR, sprintRaceLaps BIGINT, sprintRaceDistance DOUBLE, sprintRaceScheduledLaps BIGINT, sprintRaceScheduledDistance DOUBLE, warmingUpDate VARCHAR, warmingUpTime VARCHAR ); CREATE TABLE races_constructor_standings ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, points DOUBLE NOT NULL, positionsGained BIGINT, championshipWon BOOLEAN NOT NULL ); CREATE TABLE races_driver_of_the_day_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, percentage DOUBLE ); CREATE TABLE races_driver_standings ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverId VARCHAR NOT NULL, points DOUBLE NOT NULL, positionsGained BIGINT, championshipWon BOOLEAN NOT NULL ); CREATE TABLE races_fastest_laps ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, lap BIGINT, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT ); CREATE TABLE races_free_practice_1_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_free_practice_2_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_free_practice_3_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_free_practice_4_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_lap_times ( raceId BIGINT NOT NULL, driverId VARCHAR NOT NULL, lap BIGINT NOT NULL, position BIGINT NOT NULL, time VARCHAR NOT NULL, timeMillis BIGINT NOT NULL ); CREATE TABLE races_pit_stops ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, stop BIGINT NOT NULL, lap BIGINT NOT NULL, time VARCHAR, timeMillis BIGINT ); CREATE TABLE races_pre_qualifying_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, q1 VARCHAR, q1Millis BIGINT, q2 VARCHAR, q2Millis BIGINT, q3 VARCHAR, q3Millis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_qualifying_1_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, q1 VARCHAR, q1Millis BIGINT, q2 VARCHAR, q2Millis BIGINT, q3 VARCHAR, q3Millis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_qualifying_2_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, q1 VARCHAR, q1Millis BIGINT, q2 VARCHAR, q2Millis BIGINT, q3 VARCHAR, q3Millis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_qualifying_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, q1 VARCHAR, q1Millis BIGINT, q2 VARCHAR, q2Millis BIGINT, q3 VARCHAR, q3Millis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_race_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, sharedCar BOOLEAN NOT NULL, laps BIGINT, time VARCHAR, timeMillis BIGINT, timePenalty VARCHAR, timePenaltyMillis BIGINT, gap VARCHAR, gapMillis BIGINT, gapLaps BIGINT, interval VARCHAR, intervalMillis BIGINT, reasonRetired VARCHAR, points DOUBLE, polePosition BOOLEAN, qualificationPositionNumber BIGINT, qualificationPositionText VARCHAR, gridPositionNumber BIGINT, gridPositionText VARCHAR, positionsGained BIGINT, pitStops BIGINT, fastestLap BOOLEAN, driverOfTheDay BOOLEAN, grandSlam BOOLEAN ); CREATE TABLE races_red_flags ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, lap BIGINT, resumed VARCHAR, incident VARCHAR, excluded VARCHAR ); CREATE TABLE races_safety_cars ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, cause VARCHAR, deployed BIGINT, retreated DOUBLE, fullLaps BIGINT ); CREATE TABLE races_sprint_qualifying_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, q1 VARCHAR, q1Millis BIGINT, q2 VARCHAR, q2Millis BIGINT, q3 VARCHAR, q3Millis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE races_sprint_race_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, sharedCar BOOLEAN NOT NULL, laps BIGINT, time VARCHAR, timeMillis BIGINT, timePenalty VARCHAR, timePenaltyMillis BIGINT, gap VARCHAR, gapMillis BIGINT, gapLaps BIGINT, interval VARCHAR, intervalMillis BIGINT, reasonRetired VARCHAR, points DOUBLE, polePosition BOOLEAN, qualificationPositionNumber BIGINT, qualificationPositionText VARCHAR, gridPositionNumber BIGINT, gridPositionText VARCHAR, positionsGained BIGINT, pitStops BIGINT, fastestLap BOOLEAN, driverOfTheDay BOOLEAN, grandSlam BOOLEAN ); CREATE TABLE races_sprint_starting_grid_positions ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, qualificationPositionNumber BIGINT, qualificationPositionText VARCHAR, gridPenalty VARCHAR, gridPenaltyPositions BIGINT, time VARCHAR, timeMillis BIGINT ); CREATE TABLE races_starting_grid_positions ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, qualificationPositionNumber BIGINT, qualificationPositionText VARCHAR, gridPenalty VARCHAR, gridPenaltyPositions BIGINT, time VARCHAR, timeMillis BIGINT ); CREATE TABLE races_warming_up_results ( raceId BIGINT NOT NULL, year BIGINT NOT NULL, round BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverNumber VARCHAR NOT NULL, driverId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL, time VARCHAR, timeMillis BIGINT, gap VARCHAR, gapMillis BIGINT, interval VARCHAR, intervalMillis BIGINT, laps BIGINT ); CREATE TABLE seasons ( year BIGINT NOT NULL ); CREATE TABLE seasons_constructor_standings ( year BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, points DOUBLE NOT NULL, championshipWon BOOLEAN NOT NULL ); CREATE TABLE seasons_constructors ( year BIGINT NOT NULL, constructorId VARCHAR NOT NULL, positionNumber BIGINT, positionText VARCHAR, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, total1And2Finishes BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); CREATE TABLE seasons_driver_standings ( year BIGINT NOT NULL, positionDisplayOrder BIGINT NOT NULL, positionNumber BIGINT, positionText VARCHAR NOT NULL, driverId VARCHAR NOT NULL, points DOUBLE NOT NULL, championshipWon BOOLEAN NOT NULL ); CREATE TABLE seasons_drivers ( year BIGINT NOT NULL, driverId VARCHAR NOT NULL, positionNumber BIGINT, positionText VARCHAR, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL, totalDriverOfTheDay BIGINT NOT NULL, totalGrandSlams BIGINT NOT NULL ); CREATE TABLE seasons_engine_manufacturers ( year BIGINT NOT NULL, engineManufacturerId VARCHAR NOT NULL, positionNumber BIGINT, positionText VARCHAR, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPoints DOUBLE NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); CREATE TABLE seasons_entrants ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, countryId VARCHAR NOT NULL ); CREATE TABLE seasons_entrants_chassis ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, chassisId VARCHAR NOT NULL ); CREATE TABLE seasons_entrants_constructors ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL ); CREATE TABLE seasons_entrants_drivers ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, driverId VARCHAR NOT NULL, rounds VARCHAR, roundsText VARCHAR, testDriver BOOLEAN NOT NULL ); CREATE TABLE seasons_entrants_engines ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, engineId VARCHAR NOT NULL ); CREATE TABLE seasons_entrants_tyre_manufacturers ( year BIGINT NOT NULL, entrantId VARCHAR NOT NULL, constructorId VARCHAR NOT NULL, engineManufacturerId VARCHAR NOT NULL, tyreManufacturerId VARCHAR NOT NULL ); CREATE TABLE seasons_eras ( year BIGINT NOT NULL, eraName VARCHAR NOT NULL, eraOverview VARCHAR NOT NULL, keyChanges VARCHAR NOT NULL, technicalSummary VARCHAR NOT NULL, sportingSummary VARCHAR NOT NULL ); CREATE TABLE seasons_points_overrides ( year BIGINT NOT NULL, round BIGINT NOT NULL, grandPrixId VARCHAR NOT NULL, pointsMultiplier DOUBLE NOT NULL, lapsCompleted BIGINT, lapsScheduled BIGINT, reason VARCHAR NOT NULL ); CREATE TABLE seasons_points_systems ( year BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, position1Points DOUBLE NOT NULL, position2Points DOUBLE NOT NULL, position3Points DOUBLE NOT NULL, position4Points DOUBLE NOT NULL, position5Points DOUBLE NOT NULL, position6Points DOUBLE NOT NULL, position7Points DOUBLE NOT NULL, position8Points DOUBLE NOT NULL, position9Points DOUBLE NOT NULL, position10Points DOUBLE NOT NULL, fastestLapPoints DOUBLE NOT NULL, fastestLapCondition VARCHAR NOT NULL, fastestLapMinDistancePercent DOUBLE ); CREATE TABLE seasons_qualifying_formats ( year BIGINT NOT NULL, format VARCHAR NOT NULL, description VARCHAR, q1DurationMinutes BIGINT, q2DurationMinutes BIGINT, q3DurationMinutes BIGINT, eliminationCountPerStage BIGINT, hundredSevenPercentRule BOOLEAN NOT NULL ); CREATE TABLE seasons_sporting_regulations ( year BIGINT NOT NULL, raceDistanceKm DOUBLE, sprintRacesCount BIGINT NOT NULL, sprintRaceDistanceKm DOUBLE, sprintQualifyingFormat VARCHAR, drsActive BOOLEAN NOT NULL, vscActive BOOLEAN NOT NULL, budgetCapIntroduced BOOLEAN NOT NULL, budgetCapAmountUsd DOUBLE, numberOfRaces BIGINT, dropScoresUsed BOOLEAN NOT NULL, dropScoresCount BIGINT, shortenedRaceRules VARCHAR ); CREATE TABLE seasons_sprint_points_systems ( year BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, position1Points DOUBLE NOT NULL, position2Points DOUBLE NOT NULL, position3Points DOUBLE NOT NULL, position4Points DOUBLE NOT NULL, position5Points DOUBLE NOT NULL, position6Points DOUBLE NOT NULL, position7Points DOUBLE NOT NULL, position8Points DOUBLE NOT NULL, sprintRacesCount BIGINT NOT NULL ); CREATE TABLE seasons_technical_regulations ( year BIGINT NOT NULL, eraName VARCHAR NOT NULL, engineFormula VARCHAR NOT NULL, engineCapacityCc DOUBLE, cylinders VARCHAR, turboAllowed BOOLEAN NOT NULL, superchargingRequired BOOLEAN NOT NULL, groundEffectAllowed BOOLEAN NOT NULL, activeAeroAllowed BOOLEAN NOT NULL, minWeightKg DOUBLE, fuelLimitKg DOUBLE, fuelType VARCHAR, refuellingAllowed BOOLEAN NOT NULL, consumptionLimitMjPerHour DOUBLE, energyStoreCapacityMj DOUBLE, maxEnginesPerSeason BIGINT, maxRpm BIGINT, tyreSupplier VARCHAR ); CREATE TABLE seasons_tyre_manufacturers ( year BIGINT NOT NULL, tyreManufacturerId VARCHAR NOT NULL, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); CREATE TABLE tyre_manufacturers ( id VARCHAR NOT NULL, name VARCHAR NOT NULL, countryId VARCHAR NOT NULL, bestStartingGridPosition BIGINT, bestRaceResult BIGINT, bestSprintRaceResult BIGINT, totalRaceEntries BIGINT NOT NULL, totalRaceStarts BIGINT NOT NULL, totalRaceWins BIGINT NOT NULL, totalRaceLaps BIGINT NOT NULL, totalPodiums BIGINT NOT NULL, totalPodiumRaces BIGINT NOT NULL, totalPolePositions BIGINT NOT NULL, totalFastestLaps BIGINT NOT NULL, totalSprintRaceStarts BIGINT NOT NULL, totalSprintRaceWins BIGINT NOT NULL ); ```